If you can't get direct answers from someone in the aviation community as to what planes are based where, I think your best bet is Tripp's advice, surf till your mouse overheats.
What you might want to try is this: Search for NAS, or Naval Air Station on your most thorough search engine and hit the websites for the individual air stations, once on a station's home page, usually under "Tenant Commands" you'll find what squadrons are stationed there. Usually there will be a link to the individual sqaudrons page and all the info on them you could think of, usually.
I don't know about the P-3, S-3, E-2/C-2, E-6 or various helo org's but I know that all east coast F/A-18 squadrons (except for two at MCAS Beaufort) and all F-14 Tomcat squadrons are at NAS Oceana in Virginia, and all west coast Hornets and all Super Hornets, are at NAS Leemore in California.
Also, a carrier air wing is foward deployed in Atsugi Japan (with Kitty hawk, I think?)
Hope this helps.
D
Edited by - Dave Shutter on 5 May 2000