Pilotboi From United States of America, joined Sep 2007, 2366 posts, RR: 10 Posted (4 years 6 months 1 week 4 hours ago) and read 13911 times:
Okay I know a bunch of you have been waiting for this. I'm sure many of you have seen my list(s) before and know what I do. (If not, skip to the About My List section for a short description of what is posted here). Until recently I was keeping my DL and NW lists separate. After the merger was final a few weeks ago I combined the two, almost. Pinnacle's two lists (one for DL and one for NW) were combined. XJ and CP pages were moved over and allowed into the DL family. But the last bit, NW mainline, I have kept separate for now, mostly due to the fact that they still have a separate operating certificate. It will take a lot of work to combine the DL and NW mainline lists together, but it will happen. BUT, please note: Ever other reference to DL mainline includes both DL and NW mainline numbers/counts/etc. It's a slow transition but it's getting there.
Now for the other big thing I wanted to mention. As you may have known, I've been using Excel to create and organize my lists. Recently I have been using some of Office 2007's new features including advanced conditional formatting. Because of these features it's very hard to convert my Excel file into a webpage, website, or other generic form of display. So this time I am presenting you with the actual Excel file that I work with. But there's a catch - it's protected! Sorry, you won't be able to edit the file. Please understand that I have put a lot of work into these lists and would really hate it if someone made a few changes and called if their own work. If you have a valid reason for wanting to edit or modify my lists please feel free to contact me and talk about it.
Now, the best way to view this is with Excel 2007 as it is a .xslx file. For those of you who don't have 2007, there is a .xls version available. But please note it will not look the same as it does to me and may even be a bit confusing (due to hidden numbers, etc). But here are the links. Please feel free to download them and save them for your own viewing pleasure. Also feel free to share them and repost wherever you would like. (Avoid hotlinking if you can).
Please PM me if you have and additions or corrections!
About My List
My gigantic list began as a simple way to keep track of what Delta ships I had seen in person and worked on. When I began this list I was working for Delta at DAB as a ramp agent. We got MD-88s and CRJ-700s from ASA. Shortly after I began working there the new paint scheme was announced. I thought it would be interesting if I kept track of which MD-88s were repainted, so I added a column for that. I then started to keep track of all aircraft types. Since then I've added every regional carrier and tons of information pertaining to each aircraft type. Every month I add more information as well as update the info I have. The main goal of this list is to keep track of which aircraft are in the new colors and how many there are left to paint. But it's also so much more then that.
You'll notice each regional carrier, plus mainline, has a different color. Also, each aircraft manufacturer has a different color, to help distinguish them from each other. Information for each aircraft includes:
Ship number
Registration number
Paint scheme (if none is indicated, the aircraft is in wavy gravy/2000 colors)
Winglets
Comm equipment (Satcom, HF, GPS)
ETOPS certs
Exact model number
Engine type
Seat counts (in each class)
IFE (AVOD, LiveTV, Overhead LCDs, Wifi, etc)
Use (domestic/international/etc)
Internal code
MSN and L/N (if applicable)
Previous users/operators and N-numbers
Aircraft name (ie JetBlue's fleet)
Note: some categories not available or not applicable for every type
Among the items listed above, there is plenty of other information:
Totals by carrier and totals by aircraft type
Pictures showing the different seat types in each aircraft (P.S. If anyone sees a picture of theirs that they don't want on the list, just let me know and I'll remove it.)
Stored aircraft lists (not for all types)
Future orders and options, delivery dates, and fleet retirement news
Tons of graphs and pie-charts to visually look at the data
The777Man From United States of America, joined Jul 1999, 6082 posts, RR: 56 Reply 4, posted (4 years 6 months 1 week 3 hours ago) and read 13790 times:
Will Delta take delivery of the NW-ordered 319 and 320s ? (NW still have 2 320s and 5 319s left to be deliverd from Airbus)
The777Man
Need a Boeing 777 Firing Order....Further to fly....GA, T5, CI and LX 777s
Pilotboi From United States of America, joined Sep 2007, 2366 posts, RR: 10 Reply 5, posted (4 years 6 months 1 week 3 hours ago) and read 13701 times:
Quoting Dalb777 (Reply 1): 1. On the 757s, what's the "Bin 2" and "Bin 3" columns, with trays and carpet? Is that by any chance the cargo hold?
Yes, that is in the cargo holds. On the 757, there are 4 'bins' as rampers usually call them. From forward to aft they are numbered 1, 2, 3, and 4. Bins 1 and 2 are really just the same space, separated by the forward cargo door. Same with 3 and 4, only the aft cargo door.
Carpets, aka "magic carpets" are a rubber lining that is on the bottom of the bin and can be moved forward and backward with a switch. It's just like a wide conveyor belt.
Trays are similar to carpets only they are plastic and have several tiers that fit in each other. If I find some pictures I'll be sure to post them.
Quoting Dalb777 (Reply 1): 2. The delivery dates for 737-700s and 77L's...those haven't been adjusted for delays caused by the Boeing strike, have they?
I guess they have...
Quoting Flynavy (Reply 2): We will not take anymore 700s this year. The rest (ships 3105 and subsequent) have been delayed until 2009.
Thank you.
Quoting Mech24 (Reply 3): Seating on DL ships 1607-1613 is 34 F/C and 181 Y/C. They have the crew rest installed for the 12 Hours plus.
Burnsie28 From United States of America, joined Aug 2004, 7411 posts, RR: 9 Reply 10, posted (4 years 6 months 6 days 21 hours ago) and read 13093 times:
Quoting Pilotboi (Thread starter): XJ and CP pages were moved over and allowed into the DL family. But the last bit, NW mainline, I have kept separate for now, mostly due to the fact that they still have a separate operating certificate.
XJ and CP are the same thing basically since they are owned by NW INC.
"Some People Just Know How To Fly"- Best slogan ever, RIP NW 1926-2009
KingAir200 From United States of America, joined May 2006, 1579 posts, RR: 2 Reply 11, posted (4 years 6 months 6 days 20 hours ago) and read 13037 times:
The DC-9-30 list has a few errors in it. Off the top of my head, 9917 and 9613 have ventral stairs, when on your list, they show as having none. In addition, none of the ex-Eastern N89XXE birds have ventrals. Also, N8933E is ship number 9997, and N945N is 9922. You also show two ex-Eastern airplanes, 9995, and 9997 with aux tanks. I do not believe that any of the Eastern airplanes were fitted with aux tanks. While the engine lists will be accurate for the 40s and 50s, the 30s are much less predictable and will occasionally have intermixes.
Pilotboi From United States of America, joined Sep 2007, 2366 posts, RR: 10 Reply 12, posted (4 years 6 months 6 days 20 hours ago) and read 13003 times:
Quoting Burnsie28 (Reply 10): XJ and CP are the same thing basically since they are owned by NW INC.
Check the newspapers buddy. NW Inc doesn't exist anymore. XJ, CP, and NW are all now owned by Delta Air Lines Inc.
And yes they are the same thing, but different. XJ and CP are and always will be separate companies, and use separate operating certificates then mainline. NW however will eventually not be it's own company and will not have it's own certificate. That's why I say I am keeping it separate for now and will merge the NW and DL list together eventually. But all the regionals will remain separate, as they are.
Pilotboi From United States of America, joined Sep 2007, 2366 posts, RR: 10 Reply 14, posted (4 years 6 months 6 days 20 hours ago) and read 12655 times:
Quoting KingAir200 (Reply 11): The DC-9-30 list has a few errors in it. Off the top of my head, 9917 and 9613 have ventral stairs, when on your list, they show as having none. In addition, none of the ex-Eastern N89XXE birds have ventrals. Also, N8933E is ship number 9997, and N945N is 9922. You also show two ex-Eastern airplanes, 9995, and 9997 with aux tanks. I do not believe that any of the Eastern airplanes were fitted with aux tanks. While the engine lists will be accurate for the 40s and 50s, the 30s are much less predictable and will occasionally have intermixes.
Thanks for all the info! I will update all these things. I think I may have to look over my original source again and compare the data I have. I think something may have gotten mixed up a while ago when I did a sort on that particular list. Your info (as well as everyone elses) is invaluable! Collected public data, like my lists, could not be possible without help from people like you!
Quoting Cws818 (Reply 9): What an absolutely brilliant and informative compilation. Thanks very kindly for the effort and information!
Thank you! And your welcome!
Quoting PGNCS (Reply 13): I just wanted to tell you that despite any real or perceived errors others are bringing up, you have done an EXCELLENT job with this! bigthumbsup
Argonaut From UK - Scotland, joined Dec 2004, 417 posts, RR: 1 Reply 15, posted (4 years 6 months 6 days 18 hours ago) and read 11701 times:
Your work is stupendous! It's become one of the things I look for first whenever I get into a.net.
Thirty years from now, when all this has faded into history (and even the NW DC-9s are but a fond memory...), the airline nuts of the future will bless you for taking all this trouble and making the information available.
I frequently wish there were this sort of detailed list covering airlines from the 1950s/60s/70s.
Nwafan20 From United States of America, joined Apr 2006, 154 posts, RR: 0 Reply 16, posted (4 years 6 months 6 days 18 hours ago) and read 11305 times:
Great list. Just 1 thing.
NW has a hub at DTW (Detroit Metro), not DET (Detroit City)
Long live the Red Tail! | WMU Flight Science major
Burnsie28 From United States of America, joined Aug 2004, 7411 posts, RR: 9 Reply 18, posted (4 years 6 months 6 days 17 hours ago) and read 11192 times:
Quoting Pilotboi (Reply 12): NW Inc doesn't exist anymore. XJ, CP, and NW are all now owned by Delta Air Lines Inc.
Thats why in his "farewell" to employees Steenland wrote, "As you know we closed our merger with Delta today, tomorrow you all will wake up as employee's of NWA Inc. a wholly owned subsidary of Delta"
So yes it does still exist.
"Some People Just Know How To Fly"- Best slogan ever, RIP NW 1926-2009
Pilotboi From United States of America, joined Sep 2007, 2366 posts, RR: 10 Reply 21, posted (4 years 6 months 6 days 13 hours ago) and read 8814 times:
Quoting Argonaut (Reply 15): NW has a hub at DTW (Detroit Metro), not DET (Detroit City)
Noted, thanks!
Quoting F16arm (Reply 17): for S5 855, 856, 857 are flying for ual. 868, 869 are flying in hawaii 870 will be soon and 863 is in paint going to ual
Thanks! I've been looking for that info.
Quoting Burnsie28 (Reply 18): Thats why in his "farewell" to employees Steenland wrote, "As you know we closed our merger with Delta today, tomorrow you all will wake up as employee's of NWA Inc. a wholly owned subsidary of Delta"
So yes it does still exist.
Your right, I apologize. NW still has the Inc at the end. But in the stock market, NWA doesn't exist anymore. And back to the point we were talking about. XJ and CP are no longer subsidiaries of NW, Inc. They are subsidiaries of DAL, Inc. Just like NW, Inc is, and Comair.
Quoting Evan767 (Reply 20): Well done indeed. The one thing I ask, and I'm sure I speak for all of us, is that you please keep it updated as best as possible! Thanks!
Will do! I'll try to upload my newest version each week. And the one thing I ask from all of you is that you keep me informed of any changes. You are the people that make a lot of this possible.
DurangoMac From United States of America, joined Dec 2006, 586 posts, RR: 0 Reply 22, posted (4 years 6 months 6 days 10 hours ago) and read 7518 times:
I think this is great.
I've even got one for you. OO took delivery of N822SK on 11/14, CRJ-900 NextGen.
Aparently it was a blast for the employees who went up to Montreal to pick it up.
Pilotboi From United States of America, joined Sep 2007, 2366 posts, RR: 10 Reply 23, posted (4 years 6 months 6 days 9 hours ago) and read 7144 times:
Rwy04LGA From United States of America, joined Jul 2005, 2147 posts, RR: 7 Reply 24, posted (4 years 6 months 6 days 9 hours ago) and read 7092 times:
Quoting Dalb777 (Reply 1): 1. On the 757s, what's the "Bin 2" and "Bin 3" columns, with trays and carpet? Is that by any chance the cargo hold?
Yes.
Chris, Bless your soul!
The early bird gets the worm, BUT...the second mouse gets the cheese!
25 Pilotboi: Are you talking to me? Cus my name isn't Chris.
26 Rwy04LGA: Of course...sorry about that, it's been a long night.
27 Pilotboi: LOL No problem. Name's Justin - in case you or anyone else was wondering. And thanks for your comment!
28 Transpac787: Couple corrections to your list: 5635 (NW 757-251 N535US) is a Trans-Atlantic bird but is currently operating Asian routes out of the NRT 757 base. 56
29 Mech24: Great Job!! Anybody have a fleet list for AA, UA, US or CAL?
30 Jambrain: The engine on the B787-8 will be Trent 1000 either A C D or H Variant. I don't know what rating Delta / NW are going for. type cert:- http://www.rolls
31 Pilotboi: Thanks! Your info is greatly appreciated! That's what the explanation mark means...that they will be getting them soon, ie there is a plan to install
33 Flynavy: If its flying trans-Atlantic duties with passengers, then yes, it is ETOPS certified.
34 PSU.DTW.SCE: A few comments: Mesaba: There is 1 a/c in the new NWA livery, and 2 in the 50th Anniversary Route map scheme. N407XJ - (as you noted) -> in the new NW
35 Transpac787: N8978E is 9995. According to the fleet information register, 9988 through 9998 have no ventral stairs.
37 DurangoMac: But you can move it from from being delivered soon to in the fleet. Just joshing you! It hasn't made any revenue runs yet but hopefully soon.
38 Pilotboi: Thanks! It is, that's what I'm saying. I don't have it indicated as 'yet to be delivered'. Only those in italic are yet to be delivered. If you'll no
39 DeltaMIA: Great List. Just a couple of notes. All M88's are now back to 14F/128Y. Ships 9013, 9015, 9016 were the last Ship 649 is currently getting winglets. S
40 Pilotboi: Great! Do you know if 9015 is in new colors? It's the last ex-shuttle to not be reported as being repainted. 640 and 650 were reported on getting win
41 PeachAir: Pilotboi, Thanks for the great spreadsheet! How can we keep you interested enough to keep it updated? Is there a website you can post updated versions
42 Pilotboi: Thank you! And thanks for your interest. What keeps me interested is being able to find the most current information out there. So in other words - Y
43 KaiGywer: Rudolph finally did get a nose job though. 407 is now back to all silver. Looks weird Don't forget the red nose Pepsi plane This one still has the bl
44 Burnsie28: Look below, your own statement says they are, but there was a picture here or on "the other site" with one with winglets in Asia. Here are 7 of what
45 Transpac787: Guess my comment flew clear over your head, huh?? None of the none of the NRT-based 75X's have winglets. 5635, a TATL 75A, is over there temporarily.
46 Pilotboi: Weekly update is uploaded! You can use the same links as in the original post, or go to http://www.koolaiders.com/fleet.php to find the links as well
47 Transpac787: Couple more corrections for you, haha 5648, N548US, is in Pacific 75X configuration, 20C/162Y. Most recent flight was NW78 SPN-NGO Also to note about
48 Argonaut: Good question. There's not much precedent. AFAIK, the Boeing designation corresponds to the contracting airline's specification, rather than that of
49 FlyCaledonian: What letters do DL use to identify Domestic First, Domestic Economy, BizElite, and International Economy? Same for NW?
50 PSU.DTW.SCE: Nevermind, my bad. You're rig Yup, its back to its old self. Remember when it had a red cargo door for while a year or two ago? They always seem to f
51 Pilotboi: DL: http://www.cwsi.net/delta.htm NW: http://www.cwsi.net/nw.htm There are plenty of differences. But I'm sure they're already figuring out a new lis