User avatar
lightsaber
Crew
Topic Author
Posts: 12024
Joined: Wed Jan 19, 2005 10:55 pm

Airports With Greatest Number Of Connected Cities

Mon May 14, 2012 6:06 pm

Airports and the number of connections:

Rank by airport destinations Airport # destinations
1 FRA 253 FRA with 253 destinations
2 AMS 221 AMS with 221 destinations
3 CDG 218 CDG with 218 destinations
4 ATL 200 ATL with 200 destinations
5 PEK 190 PEK with 190 destinations
6 IST 185 IST with 185 destinations
7 DXB 175 DXB with 175 destinations
8 DFW 173 DFW with 173 destinations
9 IAH 168 IAH with 168 destinations
10 DEN 161 DEN with 161 destinations
11 FCO 155 FCO with 155 destinations
12 LHR 155 LHR with 155 destinations
13 MAD 155 MAD with 155 destinations
14 EWR 148 EWR with 148 destinations
15 JFK 148 JFK with 148 destinations
16 PVG 144 PVG with 144 destinations
17 LAX 140 LAX with 140 destinations
18 CLT 130 CLT with 130 destinations
19 ICN 129 ICN with 129 destinations
20 LAS 129 LAS with 129 destinations
21 DTW 128
22 CAN 125 CAN with 125 destinations
23 MIA 122 MIA with 122 destinations
24 BKK 121 BKK with 121 destinations
25 IAD 118 IAD with 118 destinations
26 SIN 117 SIN with 117 destinations
27 HKG 113 HKG with 113 destinations
28 KUL 107 KUL with 107 destinations
29 DEL 98 DEL with 98 destinations
30 DOH 97 DOH with 97 destinations
31 SFO 96 SFO with 96 destinations
32 ATH 94
33 PHX 93 PHX with 93 destinations
34 NRT 90 NRT with 90 destinations
35 AUH 88 AUH with 88 destinations
36 JNB 84
37 SYD 83 SYD with 83 destinations
38 GRU 82 GRU with 82 destinations
39 BOM 81 BOM with 81 destinations
40 HND 62 HND with 62 destinations
41 CGK 61 CGK with 61 destinations




I do not claim the above list is all inclusive, in particular below #25. I selected airports that were:
1. On this wikipedia link: http://en.wikipedia.org/wiki/World's...iest_airports_by_passenger_traffic
2. Major hubs that have been debated here on a.net
3. Major capitol cities that were not part of #1 or #2.
4. A few previously significant hubs (hey, I grew up in the 1980s and I wanted to see which faded).

Methodology:
1. Used Google and searched for "Flights from XXX" (hattip CMF for mentoring me on the idea)
2. I clicked on the "+Show all non-stop routes from" link (search for it)
3. I summed up the destinations

This list shows:
1. FRA is indeed the jewel of the *A.
2. The European hubs are very well connected
3. Newer Asian hubs are rising up the list fast
4. Constrained hubs (LHR, NRT/HND, SFO, DEL/BOM) are dropping down the list. Constrained could be bilateral constraints or infrastructure constraints.

I was personally surprised to see IST ranking above DXB in number of cities connected. IMHO, this list shows TK/*A, Skyteam, and LH/FRA are EK's primary competitors and not QR/EY as we like to discuss here on a.net.

Lightsaber

Ps
Please suggest other cities to add but be aware I have arbitrarily decided that 60 connected cities is the fewest cities that will make the list. (Sorry CVG, HNL, MEL, etc.). This thread is about well connected cities.
"They did not know it was impossible, so they did it!" - Mark Twain
 
airceo
Posts: 16
Joined: Fri Feb 26, 2010 3:09 am

RE: Airports With Greatest Number Of Connected Cit

Mon May 14, 2012 6:28 pm

I'm not sure if your list includes domestic operations or not. Either way YYZ has to make this list. By my count there is direct service to 177 destinations. 34 domestic, 143 international. List here: http://airceo.com/files/destinations.served.from.yyz.csv

Cheers,
@airceo
blogger at airceo | reach me: @airceo or fly@airceo.com
 
User avatar
lightsaber
Crew
Topic Author
Posts: 12024
Joined: Wed Jan 19, 2005 10:55 pm

RE: Airports With Greatest Number Of Connected Cit

Mon May 14, 2012 6:44 pm

Quoting airceo (Reply 1):
Either way YYZ has to make this list.

You're correct. YYZ is in a 3 way tie for #14 by destinations found by Google at 148. I'm searching for flights available today, so seasonal routes are not included. I use the same methodology for all the airports, so some flights might be missed, but the ranking should remain about the same.

Rank by airport destinations Airport # destinations
1 FRA 253
2 AMS 221
3 CDG 218
4 ATL 200
5 PEK 190
6 IST 185
7 DXB 175
8 DFW 173
9 IAH 168
10 DEN 161
11 FCO 155
11 LHR 155
11 MAD 155
14 EWR 148
14 YYZ 148
14 JFK 148
17 PVG 144
18 LAX 140
19 CLT 130
20 ICN 129
20 LAS 129
22 DTW 128
23 CAN 125
24 MIA 122
25 BKK 121
26 IAD 118
27 SIN 117
28 HKG 113
29 KUL 107
30 DEL 98
31 DOH 97
32 SFO 96
33 ATH 94
34 PHX 93
35 NRT 90
36 AUH 88
37 JNB 84
38 SYD 83
39 GRU 82
40 BOM 81
41 HND 62
42 CGK 61

Lightsaber
"They did not know it was impossible, so they did it!" - Mark Twain
 
airtrainer
Posts: 1492
Joined: Sat Aug 30, 2003 11:44 pm

RE: Airports With Greatest Number Of Connected Cit

Mon May 14, 2012 8:02 pm

Quoting lightsaber (Thread starter):
Methodology:
1. Used Google and searched for "Flights from XXX" (hattip CMF for mentoring me on the idea)
2. I clicked on the "+Show all non-stop routes from" link (search for it)
3. I summed up the destinations

I counted 153 from BRU using the method above  
Life is short : eat dessert first !
 
bobnwa
Posts: 4485
Joined: Fri Dec 22, 2000 12:10 am

RE: Airports With Greatest Number Of Connected Cit

Mon May 14, 2012 8:14 pm

Where is MSP on your list?
 
User avatar
lightsaber
Crew
Topic Author
Posts: 12024
Joined: Wed Jan 19, 2005 10:55 pm

RE: Airports With Greatest Number Of Connected Cit

Mon May 14, 2012 9:08 pm

Quoting airtrainer (Reply 3):
I counted 153 from BRU using the method above

My spreadsheet says 151 bookable flights today.   Added to list. (I don't have the time to worry about a difference of two flights and put in some big airports I missed!)

Quoting bobnwa (Reply 4):
Where is MSP on your list?

errr.... now at 30.   


I've added BOS, MAN, MUC, BRU, MSP, TXL, JED, RUH, SVO, DME, CKG, CDU, CLE, MXP, VCE, ZRH, MNL, BRU, ORD, AMM, and a few more.

Further suggestions are welcome. I hope to make this a thread similar to yeogeo's world's longest fligths threads with the intent to update this at least quarterly. I will raise the minimum number of connected cities to keep the list below ~120 airports as required. (I hope I didn't miss *that* many. But I just added 18 more airports or almost extended the list by half!)

Rank by airport destinations Airport # destinations
1 FRA 253
2 AMS 221
3 CDG 218
4 ATL 200
5 PEK 190
6 DME 189
7 IST 185
8 MUC 184
9 ORD 182
10 DXB 175
11 DFW 173
12 IAH 168
13 DEN 161
14 FCO 155
14 LHR 155
14 MAD 155
17 DUS 153
18 BRU 151
19 EWR 148
19 YYZ 148
19 JFK 148
22 PVG 144
23 LAX 140
24 SVO 136
25 ZRH 133
26 CLT 130
27 ICN 129
27 LAS 129
29 DTW 128
30 MSP 127
31 CAN 125
32 MIA 122
33 BKK 121
33 DUB 121
35 IAD 118
35 MAN 118
37 SIN 117
38 HKG 113
39 KUL 107
40 MXP 100
41 DEL 98
41 JED 98
43 DOH 97
44 SFO 96
45 ATH 94
46 PHX 93
47 CTU 92
48 NRT 90
48 TXL 90
50 BOS 89
51 AUH 88
52 MEX 86
53 SEA 85
52 JNB 84
53 SYD 83
54 GRU 82
55 BOM 81
56 CKG 79
56 MNL 79
58 RUH 75
69 WAW 69
60 CLE 62
61 HND 62
62 CGK 61
63 AMM 60
63 VCE 60
"They did not know it was impossible, so they did it!" - Mark Twain
 
yeogeo
Posts: 625
Joined: Sun Jul 26, 2009 2:47 pm

RE: Airports With Greatest Number Of Connected Cit

Mon May 14, 2012 11:55 pm

Interesting thread, lightsaber. Thanks for the    !

I count 118 for LED

...and a few more Chinese cities just make the list for now:

SZX : 71
XMN : 61
HGH : 61

yeo
One great use of words is to hide our thoughts. Voltaire
 
dstc47
Posts: 1269
Joined: Thu Sep 16, 1999 3:53 am

RE: Airports With Greatest Number Of Connected Cit

Tue May 15, 2012 6:01 am

Interesting list but it does tend to "favour" cities which have only one single airport.

It would be educational to see what the addition of LGW and STN, in particular, does to possible London connections.
Of course some services will serve the same places as LHR.
 
User avatar
lightsaber
Crew
Topic Author
Posts: 12024
Joined: Wed Jan 19, 2005 10:55 pm

RE: Airports With Greatest Number Of Connected Cit

Tue May 15, 2012 7:17 am

I updated the list with suggestions, more hubs, and secondary airports in large cities. The list is *almost* at the top 100 most connected airports.

Rank by airport destinations Airport # destinations
1 FRA 253
2 AMS 221
3 CDG 218
4 ATL 200
5 PEK 190
6 DME 189
7 IST 185
8 MUC 184
9 ORD 182
10 DXB 175
11 DFW 173
12 IAH 168
13 DEN 161
14 LGW 157
15 FCO 155
15 LHR 155
15 MAD 155
18 DUS 153
19 BRU 151
20 EWR 148
20 YYZ 148
20 JFK 148
23 PVG 144
24 BCN 141
25 LAX 140
26 STN 137
27 SVO 136
28 ZRH 133
29 CLT 130
30 ICN 129
30 LAS 129
32 DTW 128
33 MSP 127
34 CAN 125
35 MIA 122
36 BKK 121
36 DUB 121
38 IAD 118
38 LED 118
38 MAN 118
38 ORY 118
42 SIN 117
43 PHL 114
44 HKG 113
45 KUL 107
46 MXP 100
47 ARN 98
47 DEL 98
47 JED 98
47 MCO 98
51 DOH 97
51 LIS 97
53 SFO 96
54 ATH 94
54 FLL 94
56 CGN 93
56 PHX 93
58 CTU 92
58 OSL 92
60 NRT 90
60 TXL 90
62 BOS 89
63 AUH 88
64 HAM 87
65 MEX 86
66 CAI 85
66 LTN 85
66 SEA 85
69 JNB 84
70 SYD 83
70 TPE 83
72 GRU 82
72 SLC 82
74 BOM 81
75 KBP 80
76 CKG 79
76 MNL 79
78 YVR 78
79 RUH 75
80 SZX 71
81 WAW 69
82 SHA 65
82 SHJ 65
84 LGA 64
85 CLE 62
85 HND 62
85 PTY 62
88 BNE 61
88 BSL 61
88 CGK 61
88 HGH 61
88 MDW 61
93 AMM 60
93 VCE 60

Quoting yeogeo (Reply 6):
I count 118 for LED

...and a few more Chinese cities just make the list for now:

SZX : 71
XMN : 61
HGH : 61

Thank you. .

I also utilized this link to add further airports
http://en.wikipedia.org/wiki/List_of_hub_airports


FWIW, the largest number of destinations that didn't make the list were 58 from HHN and MEM.

I've over doubled the length of the list in one day.    I'm sure I missed a few. Any suggestions appreciated.

Lightsaber
"They did not know it was impossible, so they did it!" - Mark Twain
 
User avatar
lightsaber
Crew
Topic Author
Posts: 12024
Joined: Wed Jan 19, 2005 10:55 pm

RE: Airports With Greatest Number Of Connected Cit

Tue May 15, 2012 3:45 pm

In graphical form, the trend of connectivity:
X-axis: Airport ranking 1=most connected=FRA, in order of declining number of cities connected to.
Y-axis: Number of airports the ranked airport is connected too.


Airport Connectivity



Note: Updated list as I missed one airport (again, had data but didn't move into table):
I've included all the way to what I currently calculate to the #100 airport. I know I've missed a few, so please more suggestions. Airports at the bottom of the list are likely to fall off (unless the MAX/NEO/787 disproportionately increase their connectivity).

Rank by airport destinations Airport # destinations
1 FRA 253
2 AMS 221
3 CDG 218
4 ATL 200
5 PEK 190
6 DME 189
7 IST 185
8 MUC 184
9 ORD 182
10 DXB 175
11 DFW 173
12 IAH 168
13 DEN 161
14 LGW 157
15 FCO 155
15 LHR 155
15 MAD 155
18 DUS 153
19 BRU 151
20 EWR 148
20 YYZ 148
20 JFK 148
23 PVG 144
24 BCN 141
25 LAX 140
26 STN 137
27 SVO 136
28 ZRH 133
29 CLT 130
30 ICN 129
30 LAS 129
32 DTW 128
33 MSP 127
34 CAN 125
35 MIA 122
36 BKK 121
36 DUB 121
38 IAD 118
38 LED 118
38 MAN 118
38 ORY 118
42 SIN 117
43 PHL 114
44 HKG 113
45 KUL 107
46 MXP 100
47 ARN 98
47 DEL 98
47 JED 98
47 MCO 98
51 DOH 97
51 LIS 97
53 SFO 96
54 ATH 94
54 FLL 94
56 CGN 93
56 PHX 93
58 CTU 92
58 OSL 92
60 NRT 90
60 TXL 90
62 BOS 89
63 AUH 88
64 HAM 87
65 MEX 86
66 CAI 85
66 LTN 85
66 SEA 85
69 JNB 84
70 SYD 83
70 TPE 83
72 GRU 82
72 SLC 82
74 BOM 81
75 KBP 80
76 CKG 79
76 MNL 79
78 YVR 78
79 RUH 75
80 SZX 71
81 WAW 69
82 SHA 65
82 SHJ 65
84 LGA 64
85 CLE 62
85 HND 62
85 PTY 62
88 BNE 61
88 BSL 61
88 CGK 61
88 HGH 61
88 MDW 61
88 XMN 61
94 AMM 60
94 VCE 60
96 HHN 58
96 MEM 58
98 AKL 55
98 YYC 55
100 MEL 52
"They did not know it was impossible, so they did it!" - Mark Twain
 
dstc47
Posts: 1269
Joined: Thu Sep 16, 1999 3:53 am

RE: Airports With Greatest Number Of Connected Cit

Tue May 15, 2012 4:32 pm

Who would have expected LGW to score higher than LHR?

A respectable score for STN also.
 
rutankrd
Posts: 2649
Joined: Mon Sep 08, 2003 6:08 am

RE: Airports With Greatest Number Of Connected Cit

Tue May 15, 2012 6:14 pm

Quoting dstc47 (Reply 10):

Who would have expected LGW to score higher than LHR?

A respectable score for STN also.

Why ?

Both STN and LGW are served by Easy and Ryan and these dwarf BA on the European destinations basis.

Heathrow has lost something around 30 direct services as BA have concentrated on the North Atlantic and has NEVER served many of those European Secondary cities and bucket and spade routes.
 
User avatar
lightsaber
Crew
Topic Author
Posts: 12024
Joined: Wed Jan 19, 2005 10:55 pm

RE: Airports With Greatest Number Of Connected Cit

Tue May 15, 2012 10:17 pm

Quoting dstc47 (Reply 10):
Who would have expected LGW to score higher than LHR?

Is it seasonal or do to the LCCs blanketing European destinations?

Quoting dstc47 (Reply 10):
A respectable score for STN also.

With a LCC 'cat fight' going on there, I'm not that surprised.

Quoting rutankrd (Reply 11):
Heathrow has lost something around 30 direct services

That is the pattern for 'congested hubs' as slots and aircraft are allocated to the higher RASM markets. Slowly and steadily frequency should be expected to increase to high O&D RASM destinations and be cut from lower RASM markets (who will eventually lose service to congested hubs). In particular, low O&D markets will be cut first. I'll have to find the source, but it is the typical pattern.

The alternative is to expand the available slots (regulation such as reducing curfew or expanding the airport such as a 3rd runway and more terminal space). This is one advantage of an expanding hub as new frequency to high RASM markets will often promote connections to low RASM markets 'saving their service.'

I've read about how 30% of the passengers at LHR connect and that is a really low fraction for a hub. That implies BA is approaching the point where routes with less than ~60% O&D must be cut to make way for O&D traffic.  

Again, I welcome suggestions for other airports to consider for the list. It is a work in progress.

Lightsaber
"They did not know it was impossible, so they did it!" - Mark Twain
 
yeogeo
Posts: 625
Joined: Sun Jul 26, 2009 2:47 pm

RE: Airports With Greatest Number Of Connected Cit

Tue May 15, 2012 10:59 pm

I count 59 for CUN
58 for ADD
55 for DLC
& 55 (just for) KIX

...but something tells me that the 55's will soon be off the list   

yeo
One great use of words is to hide our thoughts. Voltaire
 
aloges
Posts: 14842
Joined: Tue Jan 17, 2006 3:38 am

RE: Airports With Greatest Number Of Connected Cit

Tue May 15, 2012 11:34 pm

Holy cow, that's a huge gap between FRA and AMS! I would never have guessed, so thank you!
Don't cry because it's over, smile because it happened.
 
User avatar
lightsaber
Crew
Topic Author
Posts: 12024
Joined: Wed Jan 19, 2005 10:55 pm

RE: Airports With Greatest Number Of Connected Cit

Wed May 16, 2012 12:03 am

Quoting yeogeo (Reply 13):

I count 59 for CUN
58 for ADD
55 for DLC
& 55 (just for) KIX

...but something tells me that the 55's will soon be off the list

I'll happily put on the top 120.    I'll add those later (I'm away from the computer with the spreadsheet.) I personally set the bar at 60 just because that was my 'best guess' for top 100. I'm curious as to the real number...

Thanks for doing the footwork!   

Quoting aloges (Reply 14):

Holy cow, that's a huge gap between FRA and AMS! I would never have guessed, so thank you!

Its been a learning experience for myself. Then again, FRA is the only major *A hub besides MUC in Europe while Skyteam splits AMS, CDG, and one could argue ORY. OW is stuck with constraints on their hub... So it is not apples to apples.

Lightsaber
"They did not know it was impossible, so they did it!" - Mark Twain
 
User avatar
lightsaber
Crew
Topic Author
Posts: 12024
Joined: Wed Jan 19, 2005 10:55 pm

RE: Airports With Greatest Number Of Connected Cit

Wed May 16, 2012 5:16 am

Updated with YeoGeo's. I'm also going to have fun just posting the complete list I have. Oh, there are a few dozen airports with under 40 connections that I didn't bother to keep the data.

I expect the bottom of the list to be missing many examples. I have no intention to keep track of any city with less than 40 connections and it is unlikely I'll put in the effort on those cities below 60 for very long. But it is interesting to see how they stack up.

Rank by airport destinations Airport # destinations
1 FRA 253
2 AMS 221
3 CDG 218
4 ATL 200
5 PEK 190
6 DME 189
7 IST 185
8 MUC 184
9 ORD 182
10 DXB 175
11 DFW 173
12 IAH 168
13 DEN 161
14 LGW 157
15 FCO 155
15 LHR 155
15 MAD 155
18 DUS 153
19 BRU 151
20 EWR 148
20 YYZ 148
20 JFK 148
23 PVG 144
24 BCN 141
25 LAX 140
26 STN 137
27 SVO 136
28 ZRH 133
29 CLT 130
30 ICN 129
30 LAS 129
32 DTW 128
33 MSP 127
34 CAN 125
35 MIA 122
36 BKK 121
36 DUB 121
38 IAD 118
38 LED 118
38 MAN 118
38 ORY 118
42 SIN 117
43 PHL 114
44 HKG 113
45 KUL 107
46 MXP 100
47 ARN 98
47 DEL 98
47 JED 98
47 MCO 98
51 DOH 97
51 LIS 97
53 SFO 96
54 ATH 94
54 FLL 94
56 CGN 93
56 PHX 93
58 CTU 92
58 OSL 92
60 NRT 90
60 TXL 90
62 BOS 89
63 AUH 88
64 HAM 87
65 MEX 86
66 CAI 85
66 LTN 85
66 SEA 85
69 JNB 84
70 SYD 83
70 TPE 83
72 DCA 82
72 GRU 82
72 KMG 82
72 SLC 82
76 BOM 81
77 KBP 80
78 CKG 79
78 MNL 79
80 YVR 78
81 RUH 75
82 SZX 71
83 WAW 69
83 XIY 69
85 BOG 68
86 SHA 65
86 SHJ 65
88 LGA 64
89 SAW 63
90 CLE 62
90 HND 62
90 PTY 62
93 BNE 61
93 BSL 61
93 CGK 61
93 HGH 61
93 MDW 61
93 XMN 61
99 AMM 60
99 VCE 60
101 CUN 59
102 ADD 58
102 HHN 58
102 MEM 58
105 KWI 56
106 AKL 55
106 DLC 55
106 KIX 55
106 YYC 55
110 NKG 54
110 WUH 54
112 CSX 52
112 MEL 52
114 STL 51
115 URC 50
116 PDX 49
117 GLA 48
118 GIG 47
118 OVB 47
120 CVG 45
120 TAO 45


Note: Edited with more China, India, South American, and even one more US station in there.

I have another dozen cities that 'fell off the list.'

Lightsaber

[Edited 2012-05-15 23:02:27]

PS (late edit):
It looks like my SWAG of 60 connections to be in the top hundred is about right. I expect to find a few more 'top 100 connected airports,' but not too many.

Lightsaber


[Edited 2012-05-15 23:04:04]
"They did not know it was impossible, so they did it!" - Mark Twain
 
airtrainer
Posts: 1492
Joined: Sat Aug 30, 2003 11:44 pm

RE: Airports With Greatest Number Of Connected Cit

Wed May 16, 2012 2:42 pm

That would be interesting to compare the list with the top 100 busiest airports in term of trafic / passengers...

Quoting lightsaber (Reply 5):
My spreadsheet says 151 bookable flights today

I guess I counted some twice then, hard to be fully concentrated with the cats playing around  
Life is short : eat dessert first !
 
travelavnut
Posts: 1327
Joined: Wed May 12, 2010 1:35 pm

RE: Airports With Greatest Number Of Connected Cit

Wed May 16, 2012 3:46 pm

Cool, AMS is 2nd, who would have thought?! (not me!  Smile )

Quoting lightsaber (Thread starter):
Methodology:
1. Used Google and searched for "Flights from XXX" (hattip CMF for mentoring me on the idea)
2. I clicked on the "+Show all non-stop routes from" link (search for it)
3. I summed up the destinations


I think the list from Google is not entirely complete, ArkeFly flies to Banjul, Gambia (BJL) from AMS. Although its a charter operation you can still book flights throught http://www.arkefly.nl

[Edited 2012-05-16 08:47:20]
Live From Amsterdam!
 
timz
Posts: 6160
Joined: Fri Sep 17, 1999 7:43 am

RE: Airports With Greatest Number Of Connected Cit

Wed May 16, 2012 3:57 pm

Quoting lightsaber (Thread starter):
1. Used Google and searched for "Flights from XXX" (hattip CMF for mentoring me on the idea)
2. I clicked on the "+Show all non-stop routes from" link (search for it)

Looks like an exact figure is harder to get-- it doesn't list multiple airports for each city.
 
User avatar
lightsaber
Crew
Topic Author
Posts: 12024
Joined: Wed Jan 19, 2005 10:55 pm

RE: Airports With Greatest Number Of Connected Cit

Wed May 16, 2012 5:21 pm

Quoting travelavnut (Reply 18):
I think the list from Google is not entirely complete

While it wouldn't surprise me, it also captures the most accurate quick picture I could find. Too many airport sites list destinations that are announced or were prior served and thus inflate the figures. Most sources for connections I've found list all the seasonsal connections and not the number of connections available to book now. Most airports drop some winter destinations for summer.

There are also destinations that are tough to book. I have no interest in tracking what are effectively charter flights.

Quoting timz (Reply 19):
Looks like an exact figure is harder to get-- it doesn't list multiple airports for each city.

That is true. It is still the best representation available. I plan to compare quarterly to see how airports shift rankings seasonally and track their growth (or contraction). Other methods I tried contained out of date destinations that have been cut in this economic downturn. I do not believe the magnitude would be impacted much nor the order of the airports.

Besides, I'm not a fan of 'split hubs.'   As soon as a connection requires a bus/train/taxi ride, that connection drops off the internet search engines and might as well not exist for 85% plus of customers. I for one will not connect between airports due to the hassle, cost, and connection risk. There is little need today, there is always an alternative hub. Adding in ground and re-checkin times, a less conveniently timed competing flight is often now the more convenient flight. For example, I was going to visit my brother in KMJ. Why hassle with NRT-HND with luggage? ICN was my plan (and then work schedule nuked that plan...). Due to the growth of hubs in the mid-east and Asia, hubbing today is a different world than hubbing a decade ago. (Thankfully!) The 787/A350/NEO/MAX will only improve global connectivity (for any expanding hub, that is).

Lightsaber
"They did not know it was impossible, so they did it!" - Mark Twain
 
User avatar
lightsaber
Crew
Topic Author
Posts: 12024
Joined: Wed Jan 19, 2005 10:55 pm

RE: Airports With Greatest Number Of Connected Cit

Thu May 17, 2012 7:49 am

Updated after finding a number of European Airports that placed on the list. After searching, I better understand how the LCCs have better connected Europe. For grins, I've included the top 150 connected airports that I've found. To be in the top 100 requires 71 connections.

I ask help for recommendations on airports I might have missed. (e.g., I added VIE with 145 connections tonight!)


Rank by airport destinations Airport # destinations
1 FRA 253
2 AMS 221
3 CDG 218
4 ATL 200
5 PEK 190
6 DME 189
7 IST 185
8 MUC 184
9 ORD 182
10 DXB 175
11 DFW 173
12 IAH 168
13 DEN 161
14 LGW 157
15 FCO 155
15 LHR 155
15 MAD 155
18 DUS 153
19 BRU 151
20 EWR 148
20 YYZ 148
20 JFK 148
23 VIE 145
24 PVG 144
25 BCN 141
26 LAX 140
27 STN 137
28 SVO 136
29 ZRH 133
30 CLT 130
31 ICN 129
31 LAS 129
33 DTW 128
34 MSP 127
35 CAN 125
36 MIA 122
37 BKK 121
37 DUB 121
39 IAD 118
39 LED 118
39 MAN 118
39 ORY 118
43 SIN 117
44 PHL 114
45 HKG 113
46 CPH 109
47 KUL 107
47 VKO 107
49 PMI 106
50 MXP 100
51 ARN 98
51 DEL 98
51 JED 98
51 MCO 98
55 DOH 97
55 LIS 97
57 PRG 96
57 SFO 96
57 STR 96
60 AGP 94
60 ATH 94
60 BGY 94
60 CRL 94
60 FLL 94
65 CGN 93
65 PHX 93
67 CTU 92
67 GVA 92
67 OSL 92
70 NRT 90
70 TXL 90
72 BOS 89
73 AUH 88
74 HAM 87
75 MEX 86
76 CAI 85
76 LTN 85
76 SEA 85
79 JNB 84
80 NCE 83
80 SYD 83
80 TPE 83
83 DCA 82
83 GRU 82
83 KMG 82
83 SLC 82
87 BOM 81
87 MRS 81
89 Edi 80
89 KBP 80
91 CKG 79
91 HEL 79
91 MNL 79
94 YVR 78
95 LYS 75
95 RUH 75
97 BWI 72
97 SXF 72
99 ALC 71
99 BHX 71
99 SZX 71
102 LPA 70
103 WAW 69
103 XIY 69
105 BOG 68
105 BUD 68
107 BRS 67
108 SHA 65
108 SHJ 65
110 LGA 64
111 SAW 63
111 TFS 63
113 CLE 62
113 HND 62
113 PTY 62
116 BNE 61
116 BSL 61
116 CGK 61
116 HGH 61
116 MDW 61
116 XMN 61
122 AMM 60
122 VCE 60
124 CUN 59
125 ADD 58
125 HHN 58
125 MEM 58
128 KWI 56
129 AKL 55
129 BLQ 55
129 DLC 55
129 KIX 55
129 TPA 55
129 YYC 55
135 NKG 54
135 WUH 54
137 TLS 53
138 CSX 52
138 FAO 52
138 IBZ 52
138 MEL 52
142 OPO 51
142 STL 51
144 URC 50
145 PDX 49
146 GLA 48
147 GIG 47
147 OVB 47
149 KRK 46
150 CVG 45
150 NAP 45
150 TAO 45

Note: Updated with a few more airports after initial posting.

[Edited 2012-05-17 01:01:07]

[Edited 2012-05-17 01:04:35]
"They did not know it was impossible, so they did it!" - Mark Twain
 
BE77
Posts: 360
Joined: Fri Nov 02, 2007 2:15 am

RE: Airports With Greatest Number Of Connected Cit

Thu May 17, 2012 6:38 pm

Perhaps the elimination of charters has something to do with it, but checking arrivals for YUL in the next day or so, there seems to be about 75 different direct flights (their website and wiki claim 120 or so, but many are seasonal).
Tower, Affirmitive, gear is down and welded
 
User avatar
lightsaber
Crew
Topic Author
Posts: 12024
Joined: Wed Jan 19, 2005 10:55 pm

RE: Airports With Greatest Number Of Connected Cit

Fri May 18, 2012 4:50 am

Quoting BE77 (Reply 22):
Perhaps the elimination of charters has something to do with it, but checking arrivals for YUL in the next day or so, there seems to be about 75 different direct flights

I count 92 destinations for YUL, which puts them in a tie for 67th most connected airport. It was an oversight on my part not having YUL on the list. I'll update the list later (I'm waiting for more input).

This shows how airports with room for expansion will be more connected than those that are constrained. The obvious example is NRT due to it having a few less connections than YUL. If NRT had say another 75 slot pairs per day, I would expect about half to 2/3rds of the slots to be used for frequency and the remaining 1/3rd for new destinations.    Oh, there are more possible new destinations, but there is also demand (alliance pressure?) for more frequency.

Thanks,
Lightsaber
"They did not know it was impossible, so they did it!" - Mark Twain
 
FlyboyOz
Posts: 1743
Joined: Tue Nov 21, 2000 10:05 am

RE: Airports With Greatest Number Of Connected Cit

Sun May 20, 2012 6:40 am

Why FRA? I guess it's because there are not many foreign airlines fly to german cities. That's why they have to stop in FRA and then fly with another airlines from FRA to other cities. Am i right???
The Spirit of AustraliAN - Longreach
 
David_itl
Posts: 5988
Joined: Wed Jun 27, 2001 7:39 am

RE: Airports With Greatest Number Of Connected Cit

Sun May 20, 2012 10:03 am

This is a mini-table for the UK showing the number of scheduled passenger services an airport had in 2011 based on the CAA's annual statistics. It doesn't take into account any services that ceased during the year.:

LGW 186
LHR 185
STN 157
MAN 143
EDI 105
LTN 89
BHX 83
BRS 83
LPL 70
EMA 67
LBA 65
GLA 60
NCL 56
LCY 38
BFS 36
ABZ 32


For comparison, these are the results when charter destinations are also included. Some are going to be bumped up due to ad-hoc nature of some of the chartering organisations

LGW 286
MAN 230
LHR 228
STN 227
LTN 196
EDI 156
BHX 156
GLA 141
BRS 123
EMA 117
NCL 108
LPL 96
LBA 87
BFS 87
ABZ 61
LCY 43
 
User avatar
lightsaber
Crew
Topic Author
Posts: 12024
Joined: Wed Jan 19, 2005 10:55 pm

RE: Airports With Greatest Number Of Connected Cit

Sun May 20, 2012 11:45 pm

Quoting david_itl (Reply 25):
It doesn't take into account any services that ceased during the year.:

How many were seasonal? Interesting stats. Unfortunately, finding that information for every airport would be tough. I will use your list to see about additions though! Thanks.

Quoting FlyboyOz (Reply 24):
Why FRA? I guess it's because there are not many foreign airlines fly to german cities.

That is a good question. I do not claim to have the answer.

Lightsaber
"They did not know it was impossible, so they did it!" - Mark Twain
 
leftyboarder
Posts: 750
Joined: Sun Apr 13, 2008 3:38 pm

RE: Airports With Greatest Number Of Connected Cit

Mon May 21, 2012 8:28 pm

IST might rank higher. TK alone serves over 190 destinations. even if you take out London for multiple airports, that is still more than the figure in the list. And that doesn't include the many other airlines serving other points from IST. I'd say that figure is closer to 200, although I can't pinpoint an exact number.

Interesting to see LHR at the same level as FCO and MAD, two hubs not necessarily very well connected especially towards the east. You'd think that LHR would be ranked higher.
 
User avatar
lightsaber
Crew
Topic Author
Posts: 12024
Joined: Wed Jan 19, 2005 10:55 pm

RE: Airports With Greatest Number Of Connected Cit

Mon May 21, 2012 11:22 pm

Quoting leftyboarder (Reply 27):
TK alone serves over 190 destinations

year round? I'm searching for flights available now. I couldn't explain why they wouldn't have them searchable online...
Any error should be consistent across the airports.

Quoting leftyboarder (Reply 27):
You'd think that LHR would be ranked higher.

   LHR, LGA, and other congested airports have been used as case studies to show that when airports are not able to further expand, they tend to contract to frequency on the highest RASM 'trunk routes.'

Connections are handled by higher gauge flights to hub airports. Look at how the slot auctions go at LHR. I haven't heard of a slot going to anything but a competitor's hub (usually one increasing frequency) or for a 'trunk route.' Now, BA is acquiring a huge number of BM slots. While its obvious a few BM destinations will be lost quickly, perhaps the slots will be redistributed to open up a few new long haul routes.


Lightsaber
"They did not know it was impossible, so they did it!" - Mark Twain
 
User avatar
lightsaber
Crew
Topic Author
Posts: 12024
Joined: Wed Jan 19, 2005 10:55 pm

RE: Airports With Greatest Number Of Connected Cit

Tue May 22, 2012 3:05 pm

I've updated the top 150. After looking at the suggestions... I am not going to worry about a few additional flights; those are probably seasonal. The industry has also contracted in many areas.

The Top 150:
Rank by airport destinations Airport # destinations
1 FRA 253
2 AMS 221
3 CDG 218
4 ATL 200
5 PEK 190
6 DME 189
7 IST 185
8 MUC 184
9 ORD 182
10 DXB 175
11 DFW 173
12 IAH 168
13 DEN 161
14 LGW 157
15 FCO 155
15 LHR 155
15 MAD 155
18 DUS 153
19 BRU 151
20 EWR 148
20 YYZ 148
20 JFK 148
23 VIE 145
24 PVG 144
25 BCN 141
26 LAX 140
27 STN 137
28 SVO 136
29 ZRH 133
30 CLT 130
31 ICN 129
31 LAS 129
33 DTW 128
34 MSP 127
35 CAN 125
36 MIA 122
37 BKK 121
37 DUB 121
39 IAD 118
39 LED 118
39 MAN 118
39 ORY 118
43 SIN 117
44 PHL 114
45 HKG 113
46 CPH 109
47 KUL 107
47 VKO 107
49 PMI 106
50 MXP 100
51 ARN 98
51 DEL 98
51 JED 98
51 MCO 98
55 DOH 97
55 LIS 97
57 PRG 96
57 SFO 96
57 STR 96
60 AGP 94
60 ATH 94
60 BGY 94
60 CRL 94
60 FLL 94
65 CGN 93
65 PHX 93
67 CTU 92
67 GVA 92
67 OSL 92
67 YUL 92
71 NRT 90
71 TXL 90
73 BOS 89
74 AUH 88
75 HAM 87
76 MEX 86
77 CAI 85
77 LTN 85
77 SEA 85
80 JNB 84
81 NCE 83
81 SYD 83
81 TPE 83
84 DCA 82
84 GRU 82
84 KMG 82
84 SLC 82
88 BOM 81
88 MRS 81
90 Edi 80
90 KBP 80
92 CKG 79
92 HEL 79
92 MNL 79
95 YVR 78
96 LYS 75
96 RUH 75
98 BWI 72
98 SXF 72
100 ALC 71
100 BHX 71
100 SZX 71
103 LPA 70
104 WAW 69
104 XIY 69
106 BOG 68
106 BUD 68
108 BRS 67
109 SHA 65
109 SHJ 65
111 LGA 64
112 SAW 63
112 TFS 63
114 CLE 62
114 HND 62
114 PTY 62
117 BNE 61
117 BSL 61
117 CGK 61
117 HGH 61
117 MDW 61
117 XMN 61
123 AMM 60
123 VCE 60
125 CUN 59
126 ADD 58
126 HHN 58
126 MEM 58
129 EMA 57
130 KWI 56
130 LBA 56
132 AKL 55
132 BLQ 55
132 DLC 55
132 KIX 55
132 TPA 55
132 YYC 55
138 NKG 54
138 WUH 54
140 LPL 53
140 TLS 53
142 CSX 52
142 FAO 52
142 IBZ 52
142 MEL 52
146 OPO 51
146 STL 51
148 URC 50
149 PDX 49
150 GLA 48


I thank everyone for their suggestions. As can be seen, six airports dropped off the list with the updates. I have 185 airports in my list, but the order of the last few dozen is very inaccurate. More suggestions are welcome.

Lightsaber
"They did not know it was impossible, so they did it!" - Mark Twain
 
Aircellist
Posts: 1295
Joined: Fri Oct 08, 2004 8:43 am

RE: Airports With Greatest Number Of Connected Cit

Thu May 31, 2012 3:34 am

Brave and fool! Thanks, I like it very much!
"When I find out I was wrong, I change my mind. What do you do?" -attributed to John Maynard Keynes

Who is online

Users browsing this forum: No registered users and 5 guests

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