Sponsor Message:
Civil Aviation Forum
My Starred Topics | Profile | New Topic | Forum Index | Help | Search 
Summer 2012 Transatlantic Offer Analysis  
User currently offlineBrusselsSouth From Belgium, joined Aug 2001, 624 posts, RR: 5
Posted (2 years 1 month 1 hour ago) and read 8097 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.

Previous versions of my analysis:

- Summer 2011 North Atlantic Flights Offer Data (by BrusselsSouth Apr 25 2011 in Aviation Polls)
- Summer 2011 Transpacific Flights Offer Data (by BrusselsSouth May 14 2011 in Aviation Polls)
- W11/12 Transatlantic Offer Detailed Analysis (by BrusselsSouth Nov 21 2011 in Civil Aviation) (much more detailed)

- Airport with the largest transatlantic seats offer: London Heathrow.

- Country with the largest transatlantic seats offer: USA.

- Busiest transatlantic route: New York JFK to London Heathrow.

- Alliance with the largest transatlantic offer: Star Alliance.

- Airline with the largest transatlantic offer: British Airways.

- Most popular transatlantic aircraft: Airbus A330.

- Total weekly eastbound seats offered: 1 309 595 (187 085 daily average).

- Total weekly eastbound flights offered: 4 864 (695 daily average).

Detailed rankings can be found in the analysis document:

Analysis download link (2.5 MB PDF)

Here's a simplified version of the raw data I gathered to write this analysis:

Raw data download link (400 KB PDF)

All comments and discussions in this thread are very welcome!

Cheers

BrusselsSouth

27 replies: All unread, showing first 25:
 
User currently offlinemodernart From , joined Dec 1969, posts, RR:
Reply 1, posted (2 years 1 month ago) and read 7953 times:

You list 'shortest transatlantic' flight twice in the fun facts section. The second should be 'longest'.

User currently offlineSkyteam10001 From United States of America, joined Jun 2004, 197 posts, RR: 0
Reply 2, posted (2 years 1 month ago) and read 7924 times:

Thanks for doing this. I am sure last the last times, it will provide for entertaining and insightful reading !

A.


User currently offlinepanamair From United States of America, joined Oct 2001, 4870 posts, RR: 25
Reply 3, posted (2 years 1 month ago) and read 7919 times:
Support Airliners.net - become a First Class Member!

Quoting BrusselsSouth (Thread starter):
- Airline with the largest transatlantic offer: British Airways.

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?


User currently offlineBrusselsSouth From Belgium, joined Aug 2001, 624 posts, RR: 5
Reply 4, posted (2 years 1 month ago) and read 7876 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!

Regards
BrusselsSouth


User currently offlineskymiler From United States of America, joined Aug 2007, 522 posts, RR: 1
Reply 5, posted (2 years 1 month ago) and read 7870 times:

Wonderful research -- very interesting, especially in the details (e.g. % of premium seats).

Glad to see BA still has the "Daytime Monarch" JFK - LHR -- flew it several times in the (way) past -- on VC-10's!!

Thank you!



I love to fly, and it shows!
User currently offlineeurowings From UK - England, joined Sep 2011, 298 posts, RR: 0
Reply 6, posted (2 years 4 weeks 1 day 23 hours ago) and read 7763 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.


User currently onlineslinky09 From United Kingdom, joined Jun 2009, 820 posts, RR: 0
Reply 7, posted (2 years 4 weeks 1 day 22 hours ago) and read 7577 times:

Wanted to check, are you including say codeshare flights in the Delta analysis for example?

User currently offlineVanguard From Solomon Islands, joined Feb 2004, 104 posts, RR: 0
Reply 8, posted (2 years 4 weeks 1 day 21 hours ago) and read 7471 times:
Support Airliners.net - become a First Class Member!

Transatlantic on a Fokker???

...ah! Iceland to Greenland....


Made me laugh at the thought of 7 or 8 hours in a F50!


User currently offlinekngkyle From United States of America, joined Dec 2006, 392 posts, RR: 1
Reply 9, posted (2 years 4 weeks 1 day 20 hours ago) and read 7351 times:
AIRLINERS.NET CREW
FORUM MODERATOR

Awesome analysis. Thanks for taking the time to complile it.

User currently offlinevinniewinnie From United States of America, joined Nov 2005, 772 posts, RR: 0
Reply 10, posted (2 years 4 weeks 1 day 18 hours ago) and read 7071 times:

Fun analysis! Thank you

User currently offlineSuperCaravelle From Netherlands, joined Jan 2012, 233 posts, RR: 0
Reply 11, posted (2 years 4 weeks 1 day 15 hours ago) and read 6855 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.

User currently offlineBNAOWB From United States of America, joined Dec 2009, 396 posts, RR: 1
Reply 12, posted (2 years 4 weeks 1 day 11 hours ago) and read 6507 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


User currently offlineKermode From Canada, joined Jun 2012, 35 posts, RR: 0
Reply 13, posted (2 years 4 weeks 1 day 10 hours ago) and read 6442 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!

  


User currently offlineyeogeo From United States of America, joined Jul 2009, 882 posts, RR: 14
Reply 14, posted (2 years 4 weeks 1 day 9 hours ago) and read 6355 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?

Encore, merci François!
yeo



Yokoso! to my world
User currently offlinenormie999 From United Kingdom, joined May 2009, 143 posts, RR: 0
Reply 15, posted (2 years 4 weeks 1 day 1 hour ago) and read 4419 times:

Daytime flights: you could add FI612 and FI634 - to KEF from JFK and BOS respectively. (Summer only, daily).

User currently offlineTW741 From Liechtenstein, joined Sep 2004, 478 posts, RR: 0
Reply 16, posted (2 years 4 weeks 1 day ago) and read 4356 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.


TWA - we showed you how good we have been!
User currently offlineTurkish350XWB From Switzerland, joined Jan 2009, 476 posts, RR: 0
Reply 17, posted (2 years 4 weeks 1 day ago) and read 4319 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...

User currently offlineBrusselsSouth From Belgium, joined Aug 2001, 624 posts, RR: 5
Reply 18, posted (2 years 4 weeks 1 day ago) and read 4238 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.


Thank you everyone for your comments  

Regards
BrusselsSouth


User currently offlineBrusselsSouth From Belgium, joined Aug 2001, 624 posts, RR: 5
Reply 19, posted (2 years 4 weeks 1 day ago) and read 4227 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...

I understand your feeling, however as clearly mentioned in the PDF document, I used the United Nations Statistics Division classification (http://unstats.un.org/unsd/methods/m49/m49regin.htm).

This classification also includes the following debatable cases into "Western Asia": Armenia, Azerbaijan, Cyprus and Georgia.

I used this classification as to have an "official" reference, since previous versions of the analysis used my own, arbitrary classification.

Regards
BrusselsSouth


User currently offlineTurkish350XWB From Switzerland, joined Jan 2009, 476 posts, RR: 0
Reply 20, posted (2 years 4 weeks 23 hours ago) and read 4102 times:

Quoting BrusselsSouth (Reply 19):

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...


User currently offlineSkyTeam7488 From United States of America, joined Mar 2004, 93 posts, RR: 0
Reply 21, posted (2 years 4 weeks 22 hours ago) and read 4030 times:

Quoting BrusselsSouth (Reply 19):

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.

Anthony



You only live once... So live the high life.
User currently offlinejumpjets From United Kingdom, joined Apr 2012, 790 posts, RR: 0
Reply 22, posted (2 years 4 weeks 20 hours ago) and read 3877 times:

Thanks for preparing this for us - there's a hell of a lot of work you have done and will keep me quiet for hours to come.

User currently offlineBrusselsSouth From Belgium, joined Aug 2001, 624 posts, RR: 5
Reply 23, posted (2 years 4 weeks 16 hours ago) and read 3661 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 :

Summer 2012 Transpacific Offer Analysis (by BrusselsSouth Jun 25 2012 in Civil Aviation)

I'll think of you for future updates  

Regards
BrusselsSouth


User currently offlineDocLightning From United States of America, joined Nov 2005, 19372 posts, RR: 58
Reply 24, posted (2 years 4 weeks 15 hours ago) and read 3564 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
26 jfk777 : Asia to Europe would be great too.
27 BrusselsSouth : Strictly speaking you are correct. The number of aisles classification is meant to distinguish between narrow and wide bodies. The correct denominati
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...
AS Summer 2012 Departures By Hub And Aircraft Type posted Sat Jun 9 2012 22:54:04 by FSDan
AC Summer 2012 Departures By Hub And Aircraft Type posted Wed Jun 6 2012 19:03:41 by SHUPirate1
Interesting Charter AC - Summer 2012 posted Wed Jun 6 2012 15:46:00 by baexecutive
US Summer 2012 Departures By Hub And Aircraft Type posted Tue Jun 5 2012 20:21:31 by FSDan
AA Summer 2012 Departures By Hub And Aircraft Type posted Tue Jun 5 2012 20:21:19 by FSDan
DL Summer 2012 Departures By Hub And Aircraft Type posted Tue Jun 5 2012 20:21:06 by FSDan
UA Summer 2012 Departures By Hub And Aircraft Type posted Tue Jun 5 2012 20:20:51 by FSDan
STL-Summer 2012 Edition posted Thu May 3 2012 14:54:13 by atrude777
DL 744 Routes Summer 2012 posted Sun Apr 29 2012 20:30:51 by PHX787
UA At MIA, Summer 2012 posted Mon Apr 16 2012 08:06:19 by ANITIX87