Sponsor Message:
Civil Aviation Forum
My Starred Topics | Profile | New Topic | Forum Index | Help | Search 
The Ultimate DL/NW Fleet List - Updated!  
User currently offlinePilotboi From United States of America, joined Sep 2007, 2366 posts, RR: 9
Posted (5 years 8 months 1 week 1 day 5 hours ago) and read 14914 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).

Excel 2007: http://www.koolaiders.com/files/DeltaFleet.xlsx
Excel 2003: http://www.koolaiders.com/files/DeltaFleet2003.xls

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


Enjoy!

51 replies: All unread, showing first 25:
 
User currently offlineDalb777 From United States of America, joined May 2005, 2192 posts, RR: 0
Reply 1, posted (5 years 8 months 1 week 1 day 5 hours ago) and read 14856 times:

I visit your site often, and appreciate the work you put into it! A few questions for you that I have been wanting to know:

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?

2. The delivery dates for 737-700s and 77L's...those haven't been adjusted for delays caused by the Boeing strike, have they?

Thanks for the info!



Geaux Tigers! Geaux Hornets! Geaux Saints! WHO DAT!!!
User currently offlineFlynavy From , joined Dec 1969, posts, RR:
Reply 2, posted (5 years 8 months 1 week 1 day 4 hours ago) and read 14807 times:

We took the following 737-700s this year:

N301DQ
N302DQ
N303DQ
N304DQ

We will not take anymore 700s this year. The rest (ships 3105 and subsequent) have been delayed until 2009.


User currently offlineMech24 From United States of America, joined Jul 2001, 61 posts, RR: 0
Reply 3, posted (5 years 8 months 1 week 1 day 4 hours ago) and read 14794 times:

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.

User currently offlineThe777Man From United States of America, joined Jul 1999, 6491 posts, RR: 55
Reply 4, posted (5 years 8 months 1 week 1 day 4 hours ago) and read 14793 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....CI, MU, LX and LH 777s
User currently offlinePilotboi From United States of America, joined Sep 2007, 2366 posts, RR: 9
Reply 5, posted (5 years 8 months 1 week 1 day 3 hours ago) and read 14704 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.

Thank you.


User currently offlineCityAirline From Sweden, joined Nov 2005, 686 posts, RR: 0
Reply 6, posted (5 years 8 months 1 week 1 day 2 hours ago) and read 14595 times:

Hi, just have question for you guys about the DL 752s that do the TATL flights, do they have PTVs in both classes?

//Alex



I don't fly to live, I live to fly...
User currently offlinePilotboi From United States of America, joined Sep 2007, 2366 posts, RR: 9
Reply 7, posted (5 years 8 months 1 week 1 day 1 hour ago) and read 14507 times:



Quoting CityAirline (Reply 6):
Hi, just have question for you guys about the DL 752s that do the TATL flights, do they have PTVs in both classes?

Yes, the international 757s (6801-6817) have PTVs with AVOD in every seat. However there is no live TV.

Every aircraft that has AVOD has it throughout the entire cabin, except for the 767-300ERs where it is only BizElite.


User currently offlineJfk777 From United States of America, joined Aug 2006, 8271 posts, RR: 7
Reply 8, posted (5 years 8 months 1 week 1 day ago) and read 14434 times:
Support Airliners.net - become a First Class Member!

How delayed are the early 2009 77L's in delivery ? 3 due in 1/31/09, one on 2/28/09 and 1 on 3/31/09.

User currently offlineCws818 From United States of America, joined Aug 2008, 1176 posts, RR: 2
Reply 9, posted (5 years 8 months 1 week 1 day ago) and read 14419 times:

What an absolutely brilliant and informative compilation. Thanks very kindly for the effort and information!


volgende halte...Station Hollands Spoor
User currently offlineBurnsie28 From United States of America, joined Aug 2004, 7529 posts, RR: 8
Reply 10, posted (5 years 8 months 1 week 21 hours ago) and read 14096 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
User currently offlineKingAir200 From United States of America, joined May 2006, 1611 posts, RR: 2
Reply 11, posted (5 years 8 months 1 week 21 hours ago) and read 14040 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.


Hey Swifty
User currently offlinePilotboi From United States of America, joined Sep 2007, 2366 posts, RR: 9
Reply 12, posted (5 years 8 months 1 week 21 hours ago) and read 14006 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.


User currently offlinePGNCS From United States of America, joined Apr 2007, 2820 posts, RR: 45
Reply 13, posted (5 years 8 months 1 week 21 hours ago) and read 13902 times:

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 

User currently offlinePilotboi From United States of America, joined Sep 2007, 2366 posts, RR: 9
Reply 14, posted (5 years 8 months 1 week 20 hours ago) and read 13658 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

Thank you!


User currently offlineArgonaut From UK - Scotland, joined Dec 2004, 421 posts, RR: 1
Reply 15, posted (5 years 8 months 1 week 19 hours ago) and read 12704 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.

In a phrase: THANK YOU!



'the rank is but the guinea stamp'
User currently offlineNwafan20 From United States of America, joined Apr 2006, 157 posts, RR: 0
Reply 16, posted (5 years 8 months 1 week 18 hours ago) and read 12308 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
User currently offlineF16arm From United States of America, joined Aug 2005, 90 posts, RR: 0
Reply 17, posted (5 years 8 months 1 week 18 hours ago) and read 12195 times:

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


One weekend a month and two (cough, cough 45, 90, 120 days) weeks a year supports my habbit
User currently offlineBurnsie28 From United States of America, joined Aug 2004, 7529 posts, RR: 8
Reply 18, posted (5 years 8 months 1 week 18 hours ago) and read 12195 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
User currently offlineXdlx From United States of America, joined Aug 2008, 631 posts, RR: 1
Reply 19, posted (5 years 8 months 1 week 16 hours ago) and read 11019 times:



Quoting PGNCS (Reply 13):

You have earned a great deal of respect with this work!

Kudos


User currently offlineEvan767 From United States of America, joined Aug 2005, 2957 posts, RR: 2
Reply 20, posted (5 years 8 months 1 week 15 hours ago) and read 10711 times:

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!


The proper term is "on final" not "on finals" bud...
User currently offlinePilotboi From United States of America, joined Sep 2007, 2366 posts, RR: 9
Reply 21, posted (5 years 8 months 1 week 13 hours ago) and read 9817 times:



Quoting Argonaut (Reply 15):

In a phrase: THANK YOU!

Your welcome!

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.  Smile You are the people that make a lot of this possible.


User currently offlineDurangoMac From United States of America, joined Dec 2006, 699 posts, RR: 0
Reply 22, posted (5 years 8 months 1 week 10 hours ago) and read 8521 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.


User currently offlinePilotboi From United States of America, joined Sep 2007, 2366 posts, RR: 9
Reply 23, posted (5 years 8 months 1 week 10 hours ago) and read 8147 times:



Quoting DurangoMac (Reply 22):
I think this is great.

I've even got one for you. OO took delivery of N822SK on 11/14, CRJ-900 NextGen.

Thanks! And thanks for the info, but if you look closely you'll see that it's already on the list! Big grin


User currently offlineRwy04LGA From United States of America, joined Jul 2005, 3176 posts, RR: 8
Reply 24, posted (5 years 8 months 1 week 9 hours ago) and read 8095 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!



Just accept that some days, you're the pigeon, and other days the statue
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 Post contains links 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
32 9V-SPJ : Great work! 9V-SPJ
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.
36 KingAir200 : I'm sure. 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 Post contains links 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 Post contains links 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 Post contains links 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
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...
Merger: DL/NW : Fleet Fun posted Mon Apr 14 2008 20:32:36 by FlyguyPBI
The Ultimate PTV Thread - With List And Pictures posted Tue Nov 23 2004 00:14:58 by Udo
The A330 In NW's Fleet posted Sat Oct 20 2001 11:21:36 by Airlinelover
DL/NW Merged Fleet: Too Many Subfleets? posted Mon Oct 27 2008 19:17:08 by Transpac787
DL/NW Merger And The 767-400ER - Why Overlooked? posted Mon Sep 15 2008 11:32:31 by 1337Delta764
Thoughts On The DL/NW Merger posted Tue Jul 22 2008 14:02:48 by Dutchdragon
What Will The DL/NW Cabins Become? posted Sun Jul 20 2008 11:20:14 by DL767captain
DL+NW Plan Fleet Re-Alignment posted Thu Jun 19 2008 06:11:23 by Flynavy
Did CO Made The Right Choice And DL/NW Didn't? posted Thu May 8 2008 02:36:59 by Aircanada014
Merger: DL/NW Have Announced The Merger #2 posted Mon Apr 14 2008 22:16:05 by Moderators
What Will The DL/NW Cabins Become? posted Sun Jul 20 2008 11:20:14 by DL767captain
DL+NW Plan Fleet Re-Alignment posted Thu Jun 19 2008 06:11:23 by Flynavy
Did CO Made The Right Choice And DL/NW Didn't? posted Thu May 8 2008 02:36:59 by Aircanada014