City-pair rankings?

[Torquelink]

Anyone know where I can get recent data on major city-pairs ranked by traffic?

Thanks

[FormerFlyer]

Nope, sorry :(

[Cyrano]

Go on, give us a clue: where in the world do you want the data for?

For UK routes (including UK-to-international airport pairs), the CAA has excellent data (www.caa.co.uk).

I believe there is also publicly-available data for US-originating city pairs but I'm not sure of the source (BTS?).

IATA may have some relevant data but I don't recall if they provide public data down to city-pair level.

[Torquelink]

Cyrano,

Just want to rank city pairs, domestic or international, by traffic e.g I expect No 1 is LON-NYC (not worried about actual airport breakdown). I've searched IATA and ICAO sites and the data may be there somewhere but I've yet to find it. I agree that I can access some data from national institutions such as the CAA and FAA but it would be tricky, not to say time-consuming, to try to do this country by country. I've seen the data in various surveys in the past so it's got to be available somewhere. I know could just ask e.g. Airclaims but it would cost and I'm bit of a cheapskate!

Torque

[StephenM_SMC]

Use the CAA Stats and add the numbers together. Pretty simple!

[Torquelink]

StephenM,

The CAA has data on traffic to / from UK airports only. I need worldwide rankings.

[en2r]

e.g I expect No 1 is LON-NYC
Nope No 1 is from Taipei (in taiwan) to some city in China (I think Hong Kong but I'm not certain). No. 2 and busiest in Europe is LON-DUB.

[Wiggly Bob]

Iberia claim Madrid-Barcelona is the busiest in Europe!

[Economics101]

Well, this week the new AVE (Spanish version of TGV) started between Madrid and Barcelona (3 hrs 40m) so that might change the position. If the quality of the new service is anything like Madrid-Sevilla, then Iberia are going to take quite a hit.

[en2r]

Iberia claim Madrid-Barcelona is the busiest in Europe!
Madrid Airport-Barcelona Airport is the busiest air route in Europe. However Dublin-London(LTN, LGW, STN, LHR, LCY) is the busiest city pairing in Europe and the second busiest in the world. There are currently 51 flights per day to the 5 London airports. LHR-20, LGW-13, STN-10, LTN-4, LCY-4

[George Tower]

CPT-JNB is the busiest in Africa, and apparently the 6th busiest in the world

[Torquelink]

Here they are:


Top 100 City Pairs Worldwide by Monodirectional International & Domestic Scheduled Seats in 2007
Source: OAG Data

Ranking From To Seats in 2007
1 CTS HND 7,712,102
2 HND CTS 7,711,539
3 HND FUK 5,725,222
4 FUK HND 5,725,159
5 HKG TPE 4,917,314
6 TPE HKG 4,911,010
7 BCN MAD 3,913,125
8 MEL SYD 3,908,529
9 ITM HND 3,843,456
10 HND ITM 3,841,744
11 MAD BCN 3,836,165
12 CJU GMP 3,767,381
13 SYD MEL 3,762,664
14 GMP CJU 3,750,991
15 OKA HND 3,226,676
16 HND OKA 3,182,219
17 SDU CGH 3,156,240
18 CGH SDU 3,156,012
19 SHA PEK 3,131,150
20 PEK SHA 3,127,990
21 DEL BOM 3,110,331
22 BOM DEL 3,065,230
23 PVG HKG 2,858,173
24 HKG PVG 2,848,010
25 CPT JNB 2,768,900
26 JNB CPT 2,766,749
27 SYD BNE 2,641,318
28 BNE SYD 2,596,080
29 SUB CGK 2,325,126
30 CGK SUB 2,297,308
31 JFK LHR 2,101,896
32 LHR JFK 2,101,646
33 CGK SIN 2,062,437
34 BKK HKG 2,055,208
35 BKK SIN 2,028,065
36 SIN BKK 2,026,831
37 HKG BKK 2,018,942
38 SIN CGK 2,014,412
39 GMP PUS 1,992,702
40 PUS GMP 1,984,843
41 LIN FCO 1,931,477
42 FCO LIN 1,928,508
43 HIJ HND 1,917,487
44 HND HIJ 1,917,271
45 JNB DUR 1,904,084
46 DUR JNB 1,900,540
47 OGG HNL 1,846,044
48 HNL OGG 1,818,641
49 RUH JED 1,780,538
50 LAX LAS 1,752,962
51 MES CGK 1,750,099
52 JED RUH 1,733,519
53 CGK MES 1,720,773
54 DPS CGK 1,710,107
55 CAN PEK 1,703,930
56 LAS LAX 1,700,815
57 MCO ATL 1,694,276
58 ATL MCO 1,693,213
59 PEK CAN 1,684,718
60 KOJ HND 1,671,265
61 SFO LAX 1,656,136
62 HND KOJ 1,648,218
63 LAX SFO 1,628,033
64 LAS PHX 1,627,600
65 HKG SIN 1,604,452
66 SIN HKG 1,604,226
67 ORD LGA 1,604,038
68 HKT BKK 1,600,295
69 MEX MTY 1,595,215
70 LGA ORD 1,582,462
71 YYZ YUL 1,566,686
72 BLR BOM 1,563,296
73 PHX LAS 1,560,166
74 NRT TPE 1,551,656
75 TPE NRT 1,551,253
76 YUL YYZ 1,550,993
77 BOM BLR 1,544,211
78 ATL LGA 1,530,381
79 LGA ATL 1,527,377
80 MTY MEX 1,525,139
81 CGK DPS 1,520,511
82 CAN SHA 1,507,752
83 SHA CAN 1,507,315
84 GDL MEX 1,504,792
85 ICN NRT 1,494,858
86 NRT ICN 1,494,531
87 CTU PEK 1,489,713
88 BKK HKT 1,488,562
89 ORY TLS 1,485,326
90 NRT PVG 1,484,494
91 PVG NRT 1,484,466
92 TLS ORY 1,481,490
93 PEK CTU 1,476,765
94 HND KMJ 1,475,310
95 KMJ HND 1,464,217
96 HNL LIH 1,456,301
97 LIH HNL 1,443,504
98 MEX GDL 1,430,858
99 LAX JFK 1,429,216
100 NRT BKK 1,429,120

[en2r]

Top 100 City Pairs Worldwide by Monodirectional International & Domestic Scheduled Seats in 2007
Source: OAG Data
They're airport pairs? I thought that you were looking for city pairs?

[Torquelink]

I was but, in fact, the airport - airport figures were quite useful anyway. Just added up the relevant numbers to get the city pair data I needed.

[StephenM_SMC]

If you look at the above posts about the DUB-London data you'll see your results are skewed. Since on an individual route basis non of those sectors are on your list of the top 100.

Just a quick analysis of the Annual 2006 data, the total passengers on Dublin - London was 4,267,546
To fit it into the above table, just divided by two would give you 2,133,773 as one sector. That would place it well into the top 50 of the actual results instead of not at all.

[GoEDI]

With somewhere in the region of 56 flights a day during the week, EDI-LON must be up there? Would be interesting to see how it compares to DUB-LON.

[EC-ILS]

DUB-LON has in excess of 56 flights a day!

[iwhak]

Go Edi.....thin you'll find that the annual frequency of flights to London is far greater than from EDI. Additionally the capacity ex Dub is far higher, possibly by a factor of 3, Edi's made up to date by D328s, I know they've been replaced by RJs, bit EDI will always lag behind. Hope is of help.

[GoEDI]

I am well aware of that and certainly wasn't expecting EDI-LON to have a higher number of pax than DUB-LON. I was just curious as to how the numbers compared, hence:

Would be interesting to see how it compares to DUB-LON.

[840]

The last year for which there are full statistics is 2006. In terms of city pairs, the traffic that year was

Dublin-London: 4,267,546
Edinburgh-London: 3,477,242

So they aren't that far apart from each other, but Dublin still has a healthy enough lead.