Sponsor Message:
Travel Polls & Prefs Forum
My Starred Topics | Profile | New Topic | Forum Index | Help | Search 
Is It Possible To Find Out Which A/C I Flew On?  
User currently offlinetril1011star From United States of America, joined Jan 2014, 33 posts, RR: 0
Posted (7 months 2 weeks 6 days ago) and read 1074 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.

8 replies: All unread, jump to last
 
User currently offlinejporterfi From United States of America, joined Feb 2012, 443 posts, RR: 0
Reply 1, posted (7 months 2 weeks 5 days 19 hours ago) and read 1031 times:

I didn't see your post on the photography forum. If you give me the dates for the TWA TriStar flight from STL to ORD, I can see if one resource I know of contains aircraft registration numbers.

User currently offlinetril1011star From United States of America, joined Jan 2014, 33 posts, RR: 0
Reply 2, posted (7 months 2 weeks 5 days 15 hours ago) and read 1012 times:

July 9, 1995. It was mid morning or early afternoon I think.

The one in the photos forum got deleted cause they said I posted in the wrong forum. Guess I should have posted that one here as well.

On that same day I flew a TWA DC-9 from ICT to STL.


July 16, 1995, I flew a TWA 727 from ORD to STL, and a DC-9 from STL to ICT.

Any help would be awesome.  Smile

[Edited 2014-01-15 03:33:05]

User currently offlineredzeppelin From United States of America, joined Feb 2012, 576 posts, RR: 0
Reply 3, posted (7 months 2 weeks 5 days 13 hours ago) and read 975 times:

Over in another thread Cubsrule pointed me to this BTS database for on-time statistics:
http://www.transtats.bts.gov/DL_Sele...Table_ID=236&DB_Short_Name=On-Time

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.

View Large View Medium
Click here for bigger photo!

Photo © Michel Gilliand




Coming Up: VIE-CDG-SLC-BZN
User currently offlinetril1011star From United States of America, joined Jan 2014, 33 posts, RR: 0
Reply 4, posted (7 months 2 weeks 5 days 3 hours ago) and read 921 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.

Thank you so much for this link!


User currently offlineredzeppelin From United States of America, joined Feb 2012, 576 posts, RR: 0
Reply 5, posted (7 months 2 weeks 4 days 20 hours ago) and read 893 times:

Quoting tril1011star (Reply 4):
Whoa...........that is one awesome database!

Indeed!

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...



Coming Up: VIE-CDG-SLC-BZN
User currently offlinethreeifbyair From United States of America, joined Aug 2007, 675 posts, RR: 1
Reply 6, posted (7 months 2 weeks 4 days 11 hours ago) and read 871 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.

2CW is N1463A


View Large View Medium
Click here for bigger photo!

Photo © Eric Fortin AirTeamImages



2CG is N1450A


View Large View Medium
Click here for bigger photo!

Photo © Brian Peters



4YS is N982TW (ex-TWA, one of the last MD-80s made)


View Large View Medium
Click here for bigger photo!

Photo © Kory Crohn - PHX Spotters



Happy to help!

I have my own lost "child" - a Pinnacle CRJ from 3 years ago that appears impossible to track down as it is not in the BTS database despite Pinnacle reporting now.


User currently offlineredzeppelin From United States of America, joined Feb 2012, 576 posts, RR: 0
Reply 7, posted (7 months 2 weeks 4 days 7 hours ago) and read 852 times:

Quoting threeifbyair (Reply 6):
4YS is N982TW (ex-TWA, one of the last MD-80s made)

Thanks! That means I can finally check off the MD-83 in my log!



Coming Up: VIE-CDG-SLC-BZN
User currently offlinenicode From France, joined May 2012, 86 posts, RR: 0
Reply 8, posted (7 months 2 weeks 3 days 5 hours ago) and read 801 times:

Is it possible to find regs for international AA flights in 1998 ? (August 1998 to be exact)

Top Of Page
Forum Index

This topic is archived and can not be replied to any more.

Printer friendly format

Similar topics:More similar topics...
Is It Possible To Get Paper Tickets These Days? posted Wed Jun 23 2010 20:34:30 by AlnessW
Is It Possible To Change Class LikeThis....? posted Sun Nov 1 2009 08:57:31 by LazialeMKD
Why Is It Illegal To Have Intercourse On Airplanes posted Sun Sep 26 2010 16:09:53 by YYZRWY23
Any Way To Find Out Baggage Claim Info Online? posted Sun Jan 12 2014 15:53:28 by b6a322
Is It Safe To Use Www.flyl4l.com? posted Mon Apr 22 2013 09:07:13 by VCy
Is It Safe To Book An AA Ticket For This Summer? posted Wed Jan 2 2013 07:49:15 by LY777
What Is It Like To Jumpseat? posted Thu Feb 2 2012 18:53:31 by cvg2lga
How To Find Out Registration Of Your Flight posted Sun Dec 18 2011 17:59:47 by emirates202
Is It Ok To Buy An AC Ticket For March? posted Wed Dec 7 2011 10:40:24 by LY777
Possible To Sell/donate/trade Credit On FL? posted Tue Dec 21 2010 10:27:30 by DL787932ER