Exnavy,

C-40's are going to be harder to get than C-130's. Larger navy cities are harder than the smaller ones (Jacksonville vs New Orleans). Try calling the NATOPS officers for the squadrons you're interested in.

Best of luck