The US Coast Guard now has fourteen C-27Js that were virtually new, but considered excess by the USAF. They fly out of Elizabeth City and Sacramento. This aircraft is not as well known as the C-130, but it does have some unique capabilities. If you happen to catch a ride in one, don’t expect your Coast Guard pilot to fly like this, but it is nice to know what it can do.
The Aviation Geek Club brings us the video above and talks about the aircraft.
A Coast Guard C-27J Spartan crew, assigned to Coast Guard Air Station Sacramento, flies over San Francisco, California, during area of responsibility familiarization training, Monday, Feb. 6, 2018. The C-27Js are outfitted with weather radar and communications equipment capable of supporting transport and other Coast Guard missions. Coast Guard photo by Lt. Scott Handlin
Thanks to Dennis for bringing this to my attention.
Chuck Hill's CG Blog 
Fantastic flying! The C27 is an amazing little bird and a great complement to it’s ‘bigger brother’ the C-130.
What happened to the C-295?/! Seem to have a very short lived carrier…
The C-295 is a competitor of the C-27 and is still offered and getting orders.
https://en.wikipedia.org/wiki/EADS_CASA_C-295
Notably, it was selected as the Canadian Fixed Wing Search and Rescue platform, and designated CC-295W
Existing customers flying the C-27J tactical transport include the air forces of Italy, Lithuania, Mexico, Peru, Slovakia, Morocco, Zambia, Romania, Kenya, Chad, Bulgaria, Greece, Slovenia and Australia.
In the United States, the aircraft is operated by the Coast Guard and U.S. Special Operations Command.
https://www.defensenews.com/global/europe/2023/06/08/italy-azerbaijan-energy-talks-spawn-c-27j-aircraft-sales-for-leonardo/