Pilotboi From United States of America, joined Sep 2007, 2366 posts, RR: 10 Posted (5 years 3 weeks 3 days 11 hours ago) and read 14470 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:
Paint scheme (if none is indicated, the aircraft is in wavy gravy/2000 colors)
Comm equipment (Satcom, HF, GPS)
Exact model number
Seat counts (in each class)
IFE (AVOD, LiveTV, Overhead LCDs, Wifi, etc)
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
Pilotboi From United States of America, joined Sep 2007, 2366 posts, RR: 10 Reply 5, posted (5 years 3 weeks 3 days 9 hours ago) and read 14260 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.
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, 7479 posts, RR: 9 Reply 10, posted (5 years 3 weeks 3 days 3 hours ago) and read 13652 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, 1598 posts, RR: 2 Reply 11, posted (5 years 3 weeks 3 days 3 hours ago) and read 13596 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 (5 years 3 weeks 3 days 3 hours ago) and read 13562 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 (5 years 3 weeks 3 days 2 hours ago) and read 13214 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, 420 posts, RR: 1 Reply 15, posted (5 years 3 weeks 3 days 1 hour ago) and read 12260 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.
Quoting Argonaut (Reply 15): NW has a hub at DTW (Detroit Metro), not DET (Detroit City)
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.