BrusselsSouth
Topic Author
Posts: 568
Joined: Wed Aug 15, 2001 2:12 am

Summer 2012 Transatlantic Offer Analysis

Sun Jun 24, 2012 10:46 am

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
 
User avatar
modernArt
Posts: 467
Joined: Thu Jun 12, 2003 2:23 pm

RE: Summer 2012 Transatlantic Offer Analysis

Sun Jun 24, 2012 11:46 am

You list 'shortest transatlantic' flight twice in the fun facts section. The second should be 'longest'.
 
Skyteam10001
Posts: 132
Joined: Fri Jun 18, 2004 8:32 pm

RE: Summer 2012 Transatlantic Offer Analysis

Sun Jun 24, 2012 11:57 am

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

A.
 
panamair
Posts: 3774
Joined: Fri Oct 12, 2001 2:24 am

RE: Summer 2012 Transatlantic Offer Analysis

Sun Jun 24, 2012 11:59 am

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?
 
BrusselsSouth
Topic Author
Posts: 568
Joined: Wed Aug 15, 2001 2:12 am

RE: Summer 2012 Transatlantic Offer Analysis

Sun Jun 24, 2012 12:07 pm

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
 
skymiler
Posts: 307
Joined: Fri Aug 03, 2007 5:00 am

RE: Summer 2012 Transatlantic Offer Analysis

Sun Jun 24, 2012 12:08 pm

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 avatar
eurowings
Posts: 539
Joined: Sat Sep 10, 2011 10:40 pm

RE: Summer 2012 Transatlantic Offer Analysis

Sun Jun 24, 2012 12:38 pm

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.
"Freddie Laker may be at peace with his Maker, but he is persona non grata with IATA."- HRH Duke of Edinburgh
 
slinky09
Posts: 604
Joined: Sat Jun 06, 2009 5:03 pm

RE: Summer 2012 Transatlantic Offer Analysis

Sun Jun 24, 2012 1:46 pm

Wanted to check, are you including say codeshare flights in the Delta analysis for example?
 
Vanguard
Posts: 110
Joined: Mon Feb 23, 2004 12:26 am

RE: Summer 2012 Transatlantic Offer Analysis

Sun Jun 24, 2012 2:26 pm

Transatlantic on a Fokker???

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


Made me laugh at the thought of 7 or 8 hours in a F50!
 
User avatar
kngkyle
Crew
Posts: 397
Joined: Wed Dec 27, 2006 3:33 am

RE: Summer 2012 Transatlantic Offer Analysis

Sun Jun 24, 2012 3:17 pm

Awesome analysis. Thanks for taking the time to complile it.
 
vinniewinnie
Posts: 631
Joined: Mon Nov 28, 2005 4:23 am

RE: Summer 2012 Transatlantic Offer Analysis

Sun Jun 24, 2012 6:10 pm

Fun analysis! Thank you
 
SuperCaravelle
Posts: 261
Joined: Mon Jan 23, 2012 8:04 pm

RE: Summer 2012 Transatlantic Offer Analysis

Sun Jun 24, 2012 8:24 pm

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
Posts: 337
Joined: Mon Dec 07, 2009 11:01 pm

RE: Summer 2012 Transatlantic Offer Analysis

Mon Jun 25, 2012 12:50 am

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
Posts: 36
Joined: Wed Jun 20, 2012 8:43 pm

RE: Summer 2012 Transatlantic Offer Analysis

Mon Jun 25, 2012 1:18 am

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
Posts: 625
Joined: Sun Jul 26, 2009 2:47 pm

RE: Summer 2012 Transatlantic Offer Analysis

Mon Jun 25, 2012 2:17 am

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
One great use of words is to hide our thoughts. Voltaire
 
normie999
Posts: 72
Joined: Thu May 07, 2009 11:32 am

RE: Summer 2012 Transatlantic Offer Analysis

Mon Jun 25, 2012 10:57 am

Daytime flights: you could add FI612 and FI634 - to KEF from JFK and BOS respectively. (Summer only, daily).
 
TW741
Posts: 339
Joined: Thu Sep 09, 2004 11:04 pm

RE: Summer 2012 Transatlantic Offer Analysis

Mon Jun 25, 2012 11:21 am

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!
 
Turkish350XWB
Posts: 464
Joined: Tue Jan 13, 2009 1:23 pm

RE: Summer 2012 Transatlantic Offer Analysis

Mon Jun 25, 2012 11:34 am

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
Topic Author
Posts: 568
Joined: Wed Aug 15, 2001 2:12 am

RE: Summer 2012 Transatlantic Offer Analysis

Mon Jun 25, 2012 12:07 pm

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
 
BrusselsSouth
Topic Author
Posts: 568
Joined: Wed Aug 15, 2001 2:12 am

RE: Summer 2012 Transatlantic Offer Analysis

Mon Jun 25, 2012 12:11 pm

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
 
Turkish350XWB
Posts: 464
Joined: Tue Jan 13, 2009 1:23 pm

RE: Summer 2012 Transatlantic Offer Analysis

Mon Jun 25, 2012 1:06 pm

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...
 
SkyTeam7488
Posts: 80
Joined: Wed Mar 10, 2004 2:09 am

RE: Summer 2012 Transatlantic Offer Analysis

Mon Jun 25, 2012 1:34 pm

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.
 
jumpjets
Posts: 1142
Joined: Tue Apr 10, 2012 2:17 pm

RE: Summer 2012 Transatlantic Offer Analysis

Mon Jun 25, 2012 3:37 pm

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.
 
BrusselsSouth
Topic Author
Posts: 568
Joined: Wed Aug 15, 2001 2:12 am

RE: Summer 2012 Transatlantic Offer Analysis

Mon Jun 25, 2012 7:50 pm

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 avatar
DocLightning
Posts: 20142
Joined: Wed Nov 16, 2005 8:51 am

RE: Summer 2012 Transatlantic Offer Analysis

Mon Jun 25, 2012 8:34 pm

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

"The sky calls to us. If we do not destroy ourselves, we will one day venture to the stars."
-Carl Sagan
 
aircanada014
Posts: 1224
Joined: Sun Oct 09, 2005 2:24 pm

RE: Summer 2012 Transatlantic Offer Analysis

Tue Jun 26, 2012 12:59 am

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 Mexico.
 
jfk777
Posts: 5954
Joined: Tue Aug 22, 2006 7:23 am

RE: Summer 2012 Transatlantic Offer Analysis

Tue Jun 26, 2012 1:35 pm

Asia to Europe would be great too.
 
BrusselsSouth
Topic Author
Posts: 568
Joined: Wed Aug 15, 2001 2:12 am

RE: Summer 2012 Transatlantic Offer Analysis

Tue Jun 26, 2012 3:19 pm

Quoting DocLightning (Reply 24):
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.

Strictly speaking you are correct. The number of aisles classification is meant to distinguish between narrow and wide bodies. The correct denomination would have been "max number of aisles per deck".

Regards
BrusselsSouth

Popular Searches On Airliners.net

Top Photos of Last:   24 Hours  •  48 Hours  •  7 Days  •  30 Days  •  180 Days  •  365 Days  •  All Time

Military Aircraft Every type from fighters to helicopters from air forces around the globe

Classic Airliners Props and jets from the good old days

Flight Decks Views from inside the cockpit

Aircraft Cabins Passenger cabin shots showing seat arrangements as well as cargo aircraft interior

Cargo Aircraft Pictures of great freighter aircraft

Government Aircraft Aircraft flying government officials

Helicopters Our large helicopter section. Both military and civil versions

Blimps / Airships Everything from the Goodyear blimp to the Zeppelin

Night Photos Beautiful shots taken while the sun is below the horizon

Accidents Accident, incident and crash related photos

Air to Air Photos taken by airborne photographers of airborne aircraft

Special Paint Schemes Aircraft painted in beautiful and original liveries

Airport Overviews Airport overviews from the air or ground

Tails and Winglets Tail and Winglet closeups with beautiful airline logos