tril1011star From United States of America, joined Jan 2014, 50 posts, RR: 0 Posted (2 years 3 months 2 weeks 6 days 3 hours ago) and read 2513 times:
I think it would be cool to be able to find out the exact planes I was on over the years, and find out what the history of them is, and where they are now.
I'm sure by now most have been scrapped, but I bet there are pics of them somewhere.
In particular, I would love to find out which TriStar I was on in July of 1995 when I flew TWA from STL to ORD.
But I would also like to find out what I flew moons ago. Like for example, when I flew on Eastern in 86 and Ozark in 87.
Say I wanted to find out what TWA plane I was on. Would American still have this info somewhere? And if so, would they be willing to give it to me?
I'm sure the Eastern and Ozark ones are a long shot, but when you watch detective shows on TV, the police are always somehow able to determine weather or not a person was on a certain flight, even if it was many moons ago. So that leads me to believe the records are still out there somewhere.
I'm about to post in the photos forum about a couple specific dates, but wondered if there was any other way possible.
It goes back to 1987, has most domestic flights operated by major carriers, and has the option to return the tail number of the aircraft operating each flight. If you know the dates of your flights, you can generate results based on the month, year, and the state where the flight either started or ended. You will want to check the boxes for "FlightDate," "Carrier," FlightNum," "TailNum," "Origin," and "Dest." "ArrTime" and "DepTime" are also helpful. It will then give you a comma-separated table of all domestic flights to/from that state in that month that can be manipulated with something like Excel. You can use the filtering tools in Excel to filter by date, origin and departure.
Quoting tril1011star (Reply 2): July 16, 1995, I flew a TWA 727 from ORD to STL, and a DC-9 from STL to ICT.
I looked up Missouri for July, 1995. TW had 10 flights on the ORD-STL route that day, operated by 9 different tails. Not sure how many of those 9 tails are 727s, but the plane that flew the route twice (N64320) was a 727. So we'd need to know your flight number or departure time to narrow it down. As for STL-ICT, TWA flew it 5 times that day with 5 different tails.
tril1011star From United States of America, joined Jan 2014, 50 posts, RR: 0
Reply 4, posted (2 years 3 months 2 weeks 5 days 6 hours ago) and read 2360 times:
Whoa...........that is one awesome database! I had no idea anything like that existed! I will have much fun with this.
So, I because there was only one TriStar that went from STL to ORD that day, I was able to determine that I was on N31008.
As I suspected, my google search lead to sadness. The plane was broken up at Kingman in october of 2001. Oh well, was hoping it may still live on in a desert somewhere or be the one that ended up at the museum in Kansas city lol
N31008 has been re-assigned, and is now a small private pipper plane.
I'm glad you found your TriStar. I only discovered that database a few days ago, and my biggest discovery so far also happened to be a TriStar. I didn't think I had ever been on one, but it turns out that I flew the L-1011 on SLC-JFK in 1997. I've long assumed that flight was a 767 based on an old timetable.
I've found that AA's tail numbers are a bit spotty in the database. Many appear legitimate, but I've also come up with numbers like N2CGAA, N2CWAA, and N4YSAA that I can't make sense of. The first 2 should be F100s and the third should be an MD80 based on my log. If any AA experts know how to decipher those please let me know. You can trace the numbers through the data and they appear to be unique to one aircraft.
It would be nice if the database included international flights and smaller regional/commuter carriers, but I'm not complaining. It's already done a lot to help me fill out blanks in my flight log. My current roadblock is with an AS flight from SEA to ANC in 2006. I know the date, and that it was in the evening, but there were flights every 30 minutes or so, and I can't find anything to confirm which one I was on. It's frustrating because I don't have a 734 in my log, and it's possible that I was on a 734 that night, but can't prove it...
threeifbyair From United States of America, joined Aug 2007, 1087 posts, RR: 1
Reply 6, posted (2 years 3 months 2 weeks 4 days 14 hours ago) and read 2310 times:
Quoting redzeppelin (Reply 5): I've found that AA's tail numbers are a bit spotty in the database. Many appear legitimate, but I've also come up with numbers like N2CGAA, N2CWAA, and N4YSAA that I can't make sense of. The first 2 should be F100s and the third should be an MD80 based on my log. If any AA experts know how to decipher those please let me know. You can trace the numbers through the data and they appear to be unique to one aircraft.
The middle characters in the registration are AA internal fleet numbers (e.g. 2CG, 2CW, 4YS)
For example, I flew on N851NN last year. It has fleet number 3GF and shows up in the BTS database as N3GFNN.
I did some brute force searching in the photo database. The fleet numbers are on the nose gear doors, so a high-res photo will give you proof.