AMARC tours are given Monday through FFiday. from the Pima Air And Space Museum. The tour is $6.00 US per person and well worth the hour it takes. Just don't plan on going on any US holiday, no matter how minor, and have a valid picture ID with you. And lots of film. Also be first in line to get a window seat.
As for the aircraft storage yards, you will not find CV-880s or 990s in any. The exception is at MHV. There is a 990 preserved and an 880 (hopefully) being restored to flying condition.
I can tell you most about the Arizona yards.
Kingman is OK. Not a massive facility but you can see what is there.
Goodyear is better. You can, or used to be able to, drive around the fence surrounding the stored aircraft. Lso at Goodyear is the last DC-7 built. At least it was 2 years ago.
Marana (Pinal Air Park) is best viewed from 6 miles away east of I-10. Take the Marana exit, head east (isn't that a band from the 70s?), turn left and go 5 miles north to Missle Base Road. Get out with your binoculars or suoer telephoto lens and look at the hundreds of aircraft. You can't identify specific aircraft but it's the best overview you'll get. Unless, of course you hire someone to fly you out there. Contrary to popular opinion, private aircraft can land here. You just can't leave the ramp.
Continue south on I-10 to Avra Valley road, head west about about 7 miles and you will come to Avra Valley Airport. (now called Marana Northwest, yuck!) At this field are based several WWII aircraft owned by the Abrams family. You're not likely to see them unless there is an airshow going on. It is also the winter training base for the Red Baron Stearmans. Whwn they are in town the best place to see them practicing is the Missle Base road site mentioned above. If one were to head west from the airport itself, they would come across a sign for The Marans Skydiving Center. Turn right and go down this road a bit and you will come to Vern Raburn's hangar. This is the home for the MATS Connie. Last I was there, the Dutch Connie was still present. You will also see a sizeable fleet, of C-54s and Convairs and the last DC-4 built. It is stored in in USAF markings. This is the storage yard for Central Air Services.
Head east on I-10 about 25 miles to I-19. South on I-19 to valencia road, turn left and go 5 or so miles. Turn right on Park Avenue and you will soon see Hamilton Aviation. Quite a collection of 727s, the 2 Mexicargo 707, 2 old TWA L-1011s, the ex Akdeniz A300 and who knows what else at any given time. One half mile south of Hamilton is the Pima College Aviation department. Here is the hulk of L-1011, XU-600, ex-Air Kampuchea. This will be around for several years.
Go back to Valencia, turn right and go another few miles. One mile past I-10, you will come to the Pima Air Museum. Over 250 aircraft on display including: The only Martin Mariner in the world, the first jet aircraft to carry a US president, the last piston aircraft to carry a US president, the last B-17 to serve on active duty in the US miltary, the smallest manned aircraft in existence that ever carried a human, the only B-52A left, the last B-58 built, the oldest Connie (I believe) in the world, the oldest turbine powered airliner in the world and much more.
Not that I'm proud of the Museum or anything. I've only been going out there since two years before it opened.
OK, I'll stop playing Chamber of Commerce for Tucson now. Of course if you stop by the air museum, I may just be the first person you see there.
Ya'll come vist now, y'hear.
PS : did I mention the Martin 4-O-4 we just got? The battle is on between the historic groups for the right to pay for a paint job in their airlines colors. I hope Piedmont's group wins but it looks as thoughthey are a long shot.
The day you stop learning is the day you should die.