BrusselsSouth From Belgium, joined Aug 2001, 598 posts, RR: 5 Posted (11 months 4 days 20 hours ago) and read 7063 times:
Hi all,
Following a good reception of my previous transatlantic offer analysis (summer 2011 and winter 2011-2012), here's the summer 2012 update (in a PDF file because of the presentation limitations of this forum).
Unfortunately, lack of available time for non profit work at the moment prevents me from going into as many details as for the previous edition. I have limited myself to gathering the data and writing database queries, and have dropped the actual analysis part for this release. Anyway, I hope that some members here will find this interesting and/or entertaining.
Please keep in mind that this is a purely non-profit work for Airliners.net. As such, while I am confident that the level of accuracy of the data used is acceptable, the level of proofing/checking is much less than for a professional analysis. Similarly, as database queries use my personal airlines/airports/geography database, some recent airline related changes (mergers, name change, ...) may not be included (CO/UA data is fully merged from the first time in this version). Do not hesitate to share inaccuracies/errors in this thread.
Shouldn't this be Delta or am I reading the report incorrectly? Your list of Top carriers by seats offered and ASMs both show DL to be #1 followed by UA and then BA?
BrusselsSouth From Belgium, joined Aug 2001, 598 posts, RR: 5 Reply 4, posted (11 months 4 days 19 hours ago) and read 6842 times:
Quoting panamair (Reply 3): Shouldn't this be Delta or am I reading the report incorrectly? Your list of Top carriers by seats offered and ASMs both show DL to be #1 followed by UA and then BA?
Oops, yes, you're right. I did a copy paste from last edition and forgot to update that line (shows how BA went down from first to third!). It's unfortunately too late to edit the OP.
Quoting modernart (Reply 1): You list 'shortest transatlantic' flight twice in the fun facts section. The second should be 'longest'.
Thanks for pointing that out. The PDF has been corrected.
Oh, and stupid me who forgot to mention this in the OP: thanks to BNAOWB for his suggestions during data gathering!
eurowings From UK - England, joined Sep 2011, 298 posts, RR: 0 Reply 6, posted (11 months 4 days 18 hours ago) and read 6729 times:
An excellent analysis.
Just one thing I noted, In the section: "Flights operated by an airline whose country of origin is not related to the flight’s origin or destination country". I noticed PIA's MAN-JFK fifth-freedom service was missing, tickets are now sold on this sector, although they were not in the past.
SuperCaravelle From Netherlands, joined Jan 2012, 219 posts, RR: 0 Reply 11, posted (11 months 4 days 11 hours ago) and read 5821 times:
Very nice read, thanks for compiling. Especially the smaller details like planes used, premium % are very interesting as you won't find a comprehensive comparison anywhere else.
BNAOWB From United States of America, joined Dec 2009, 350 posts, RR: 1 Reply 12, posted (11 months 4 days 6 hours ago) and read 5473 times:
Wow! What a fantastic analysis! Thank you very much.
The daytime Royal Air Maroc flight (AT 203 JFK-CMN 9:05 - 21:30) is quite interesting since it is only non-LHR flight among the 10 daytime eastbound transatlantic flights. To my surprise, it appears that a large number of late connections (departing between 22:30 and 1:30) are available at CMN to airports such as Agadir, Bamako, Banjul, Bissau, Cotonou, Dakar, Fes, Lagos, Lome, Marrakech, Monrovia, Niamey, Tangier, etc.
From the raw data, a few random comments....
The only countries on the South American continent without transatlantic flights are Guyana and Paraguay.
How many U.S. states have at least one transatlantic flight? 23 (AK, AZ, CA, CO, FL, GA, IL, KY-CVG, MA, MD, MI, MN, NC, NJ, NV, NY, OR, PA, UT, TN, TX, VA, WA) + PR
Kermode From Canada, joined Jun 2012, 32 posts, RR: 0 Reply 13, posted (11 months 4 days 6 hours ago) and read 5408 times:
Can't say enough about people who take the time to provide such a detailed analysis. It's great that you've done this and I'm sure that everyone here will love what you've done! Thank you very much!
yeogeo From United States of America, joined Jul 2009, 790 posts, RR: 14 Reply 14, posted (11 months 4 days 5 hours ago) and read 5321 times:
Bravo BRU-South! Nicely done! Your PDF is a "keeper"; I'm sure I'll refer to it often.
I agree with the posters who find in the unusual details which you present so interesting. Thanks.
A small suggestion: In the table "Top airports with transatlantic service by number of seats offered (one-way)" (pg. 16)
I found myself adding up the figures for the three cities with two transatlantic airports (JFK/EWR, LHR/LGW, and CDG/ORY) to get what is arguably a more comprehensive view of the transatlantic traffic. Could that table be revised some day to "Top Cities with transatlantic service...", listing the multi-airport cities with their airports' traffic added together?
TW741 From Liechtenstein, joined Sep 2004, 477 posts, RR: 0 Reply 16, posted (11 months 3 days 20 hours ago) and read 3322 times:
great job! Thanks indeed for your work. Just a small correction on page 15 of the PDF file - OS is also operating the B772 transatlantic and not only the B763.
Turkish350XWB From Switzerland, joined Jan 2009, 429 posts, RR: 0 Reply 17, posted (11 months 3 days 19 hours ago) and read 3285 times:
Why is Turkey listed among the "Western Asian" states...?? We can have a discussion if Turkey has european culture etc., but as Turkey is part of European Aviation Associations and their airlines are members of AEA i think this categorization is a bit sloppy and overhasty...
BrusselsSouth From Belgium, joined Aug 2001, 598 posts, RR: 5 Reply 18, posted (11 months 3 days 19 hours ago) and read 3204 times:
Quoting eurowings (Reply 6): Flights operated by an airline whose country of origin is not related to the flight’s origin or destination country". I noticed PIA's MAN-JFK fifth-freedom service was missing, tickets are now sold on this sector, although they were not in the past.
Thanks for mentioning this. From what I understand, this service only stops at MAN westbound, the eastbound leg being a nonstop JFK-Pakistan. So, while the global transatlantic picture is slightly affected by this, it shouldn't be included in the analysis since it only takes eastbound traffic into account. But thanks for the suggestion anyway.
Quoting slinky09 (Reply 7): are you including say codeshare flights in the Delta analysis for example
No, code shares are not included, only flights by operating carrier.
Quoting Vanguard (Reply 8): Made me laugh at the thought of 7 or 8 hours in a F50!
Lol! 3 hours in a F50, like Air Iceland's Narssarssuaq - Reykjavik "transatlantic" service is already a long time in a Fokker...
Quoting BNAOWB (Reply 12): The daytime Royal Air Maroc flight (AT 203 JFK-CMN 9:05 - 21:30) is quite interesting since it is only non-LHR flight among the 10 daytime eastbound transatlantic flights. To my surprise, it appears that a large number of late connections (departing between 22:30 and 1:30) are available at CMN to airports such as Agadir, Bamako, Banjul, Bissau, Cotonou, Dakar, Fes, Lagos, Lome, Marrakech, Monrovia, Niamey, Tangier, etc.
Interesting! AT 203 is seasonal (June 17th through September 7th), but connections to the destinations you mention are sold on both the daylight and redeye JFK-CMN flights during AT203's operating period. However, to find those connections, one has to use the online booking engine on RAM's website, since their own official PDF timetable does not mention AT203. After September 7th, connections to those destinations require the long transit at CMN (morning arrival from JFK, evening departure to the final destination).
It would be interesting to have insight into the proportion of connecting pax on board those flights.
Quoting yeogeo (Reply 14): A small suggestion: In the table "Top airports with transatlantic service by number of seats offered (one-way)" (pg. 16)
I found myself adding up the figures for the three cities with two transatlantic airports (JFK/EWR, LHR/LGW, and CDG/ORY) to get what is arguably a more comprehensive view of the transatlantic traffic. Could that table be revised some day to "Top Cities with transatlantic service...", listing the multi-airport cities with their airports' traffic added together?
Thanks for the suggestion! I'll include this into my transpacific analysis (soon to be released) and will possibly retrofit it into the transatlantic analysis.
Quoting normie999 (Reply 15): Daytime flights: you could add FI612 and FI634 - to KEF from JFK and BOS respectively
You are right. Those flights are included in the analysis, but I forgot to add them to the daytime flight table. Thank you for mentioning this.
Quoting TW741 (Reply 16): Just a small correction on page 15 of the PDF file - OS is also operating the B772 transatlantic and not only the B763
Thank you for pointing it out. I will correct this in the PDF as soon as possible.
BrusselsSouth From Belgium, joined Aug 2001, 598 posts, RR: 5 Reply 19, posted (11 months 3 days 19 hours ago) and read 3193 times:
Quoting Turkish350XWB (Reply 17): Why is Turkey listed among the "Western Asian" states...?? We can have a discussion if Turkey has european culture etc., but as Turkey is part of European Aviation Associations and their airlines are members of AEA i think this categorization is a bit sloppy and overhasty...
Ah ok, i see. Not your personal classification. Anyway, i think in aviation the classification should be more on the "association" level. I don't know about the Caucasus countries, but Cyprus is also part of the european associations. I think this UN classification (which i didn't know before) takes your nice study a bit out of context. But this is my opintion. Thanks for sharing it with us. Best...
Excellent job man, I'm sure that took plenty of time and effort. I always thought I went into great deal with some of the analysis I do. Perhaps I should compile data for a transpacific offer analysis. I can collect the raw data if you would have time to assist me in formatting it like your original report.
BrusselsSouth From Belgium, joined Aug 2001, 598 posts, RR: 5 Reply 23, posted (11 months 3 days 11 hours ago) and read 2627 times:
Quoting Turkish350XWB (Reply 20): I think this UN classification (which i didn't know before) takes your nice study a bit out of context. But this is my opintion.
Thank you for sharing this opinion. I'll possibly alter the country classification in future releases, taking this into account.
Quoting SkyTeam7488 (Reply 21): Perhaps I should compile data for a transpacific offer analysis. I can collect the raw data if you would have time to assist me in formatting it like your original report.
Thanks for the offer but... my transpacific analysis has just been released :
DocLightning From United States of America, joined Nov 2005, 16826 posts, RR: 57 Reply 24, posted (11 months 3 days 10 hours ago) and read 2530 times:
You list #of aisles as a category, but then only have two categories: 1 and 2. The 747 has three aisles and the A380 has four. You do list single vs. double-deck, though.
I am a bit surprised to see that there are more A340 flights than 747 flights. That surprises me because I would have guessed that, since there are more 747's in service. I guess the 747 is primarily used on routes to/from SE Asia.
25 aircanada014: very nicely done. would be cool if you can do one for North America to Central and South America. transborder routes like Canada and USA and USA and M
27 BrusselsSouth: Strictly speaking you are correct. The number of aisles classification is meant to distinguish between narrow and wide bodies. The correct denominati
Sponsor Message: 
From Belgium, joined Aug 2001, 598 posts, 
From , joined Dec 1969, posts, 
From UK - England, joined Sep 2011, 298 posts, 
From United Kingdom, joined Jun 2009, 593 posts, 
From Solomon Islands, joined Feb 2004, 95 posts, 
From Netherlands, joined Jan 2012, 219 posts, 
From Canada, joined Jun 2012, 32 posts, 
Thank you very much!
From Liechtenstein, joined Sep 2004, 477 posts, 
From Switzerland, joined Jan 2009, 429 posts, 
Printer friendly format 
