TriL1011Star
Posts: 49
Joined: Mon Jan 13, 2014 12:14 am

Is It Possible To Find Out Which A/C I Flew On?

Wed Jan 15, 2014 3:10 am

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.
 
jporterfi
Posts: 463
Joined: Sat Feb 25, 2012 6:25 am

RE: Is It Possible To Find Out Which A/C I Flew On

Wed Jan 15, 2014 8:25 am

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.
 
TriL1011Star
Posts: 49
Joined: Mon Jan 13, 2014 12:14 am

RE: Is It Possible To Find Out Which A/C I Flew On

Wed Jan 15, 2014 11:27 am

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 avatar
redzeppelin
Posts: 903
Joined: Wed Feb 08, 2012 4:30 pm

RE: Is It Possible To Find Out Which A/C I Flew On

Wed Jan 15, 2014 1:45 pm

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

 
TriL1011Star
Posts: 49
Joined: Mon Jan 13, 2014 12:14 am

RE: Is It Possible To Find Out Which A/C I Flew On

Thu Jan 16, 2014 12:02 am

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 avatar
redzeppelin
Posts: 903
Joined: Wed Feb 08, 2012 4:30 pm

RE: Is It Possible To Find Out Which A/C I Flew On

Thu Jan 16, 2014 6:53 am

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...
 
threeifbyair
Posts: 939
Joined: Tue Aug 21, 2007 1:44 pm

RE: Is It Possible To Find Out Which A/C I Flew On

Thu Jan 16, 2014 4:02 pm

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 avatar
redzeppelin
Posts: 903
Joined: Wed Feb 08, 2012 4:30 pm

RE: Is It Possible To Find Out Which A/C I Flew On

Thu Jan 16, 2014 7:40 pm

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!
 
nicode
Posts: 144
Joined: Fri May 11, 2012 7:58 pm

RE: Is It Possible To Find Out Which A/C I Flew On

Fri Jan 17, 2014 9:45 pm

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

Who is online

Users browsing this forum: theobcman and 9 guests