Detailed Short-Haul Route Database

1

If you’re like me and don’t want to leave your device on for hours and hours, then this is for you. Flights will be organized by flight time category.

There have been many route database topics created, but the goal of this database is to provide people with all the information needed to fly a route. (except for flight plans and performance data, which would be case specific)

I will include all real world suggestions, including those with missing information. I will not be accepting flights to or from smaller airports near hubs or larger airports, unless the smaller airport happens to be 3D, or if it is the only airport used in real life on that particular route. For example, no KLGB to KOAK.

Note: short haul means 3 hours or less.

This section will be removed…

1 hour or less
Departure airport Arrival airport Flight time Airline–Aircraft–Flight# combos
KLAX KSFO 55 min. Delta 2614 — A319; Alaska 3397 — E175; United 1093 — B737-900
KLAX KLAS 40 min. Southwest 2686 — B737-700; Alaska 3322 — E175
KLAX KSAN 20 min. United 4643 — CRJ-700; United 4629 — E175
KLAX KPHX 45 min. Delta 8836 — B757-200; Delta 3738 — E175; United 741 — B737-900; American 313 — A321
KLAX KSLC 1.5 hr Delta 1647 — B737-800; jetBlue 2532 — A320
KSFO KLAX 50 min. Alaska 3372 — E175; Southwest 2686 — B737-700; Delta 2272 — A319
KSFO KRNO 25 min. United 5394 — E175
PHOG PHNL 15 min. Southwest 3586 — B737-800; Hawaiian 325 — B717-200
RPVV RPLL 50 Min. Philippine Airlines 2964 — Dash-8
RPLL RPVV 50 Min. Philippine Airlines 2963 — Dash-8
LPPR LPPT 40 Min. TAP Portugal 1933 — E190
LPPT LPPR 40 Min. TAP Portugal 1950 — E190
EGLL EGCC 45 min. British Airways 32 — A321
WMKL WMKK 50 min. Malaysian Airlines 1471 — B737-800
WMKK WMKL 50 min. Malaysian Airlines 1446 — B737-800
YMHB YMML 1 Hour Qantas 1552 — B737-800
YMML YMHB 1 Hour Qantas 1503 — B737-800
NVVW NVVV 1 Hour Air Vanuatu 1241 — ATR72-600
NVVV NVVW 1 Hour Air Vanuatu 238 — ATR72-600
NVSS NVVV 50 min. Air Vanuatu 211 — ATR72-600
NVVV NVSS 50 min. Air Vanuatu 208 — ATR72-600
VYTD VYYY 50 min. Air KBZ 245 — ATR72-600
VYHH VYTD 1 Hour Air KBZ 122 — ATR72-600
VYMD VYHH 30 min. Air KBZ 918 — ATR72-600
VYBG VYMD 30 min. Air KBZ 917 — ATR72-600
FQIN FQMA 1 hr LAM Mozambique 124 — Dash-8
FAOR FQIN 1 hr LAM Mozambique 300 — Dash-8
RJOO RJNO 50 min. Japan Airlines 2331 — E190 & B737-800
RJNO RJOO 50 min. Japan Airlines 2332 — E190 & B737-800
1-2 hours
Departure airport Arrival airport Flight time Airline–Aircraft–Flight# combos
KLAX KDEN 1 hr 50 min. Spirit 1845 — A320; United 2318 — 737-900
KSFO KLAS 1 hr 10 min. United 1372 — B737-800; Alaska 3328 — E175
KSFO KSAN 1 hr Alaska 3482 — E175; United 1041 — A320
KSFO KPHX 1.5 hr Southwest 3098 — 737-700; United 1201 — 737-900
KSFO KSLC 1.5 hr United 4802 — E175; Delta 2414 — A319
VVDN VHHH 1.5 - 2 Hours VietJetAir 872 — A321
VHHH VVDN 1.5 - 2 Hours VietJetAir 873 — A321
RJCC RJGG 1.5 - 2 Hours Japan Airlines 3106 — B737-800
RJGG RJCC 1.5 - 2 Hours Japan Airlines 3115 — B737-800
VHHH RCTP 1.5 - 2 Hours Cathay Pacific 530 — B777-300ER
RCKH VHHH 1.5Hours China Airlines 671 — B737-800
VHHH RCKH 1.5Hours China Airlines 934 — A330-300
EGLL EGPF 1.5 Hours British Airways 1472 — A321
RPVD RPLL 1.5 Hours Philippine Airlines 2544 — A320
RPLL RPVD 1.5 Hours Philippine Airlines 2545 — A320
KORD KRDU 2 Hours American Airlines 168 — MD80
VYYY VYBG 1.5 Hours Air KBZ 917 — ATR72-600
VLLB VTBS 1.5 Hours Thai Airways 2577 — A320
VTBS VLLB 1.5 Hours Thai Airways 2576 — A320
VTCC VHHH 2 Hours Dragonair 233 — A320
VTSP VHHH 2 Hours Dragonair 213 — A320
VAUD VABB 1.5 Hours Air India 471 — A321
VABB VIJP 2 Hours SpiceJet 344 — B737-800
2-3 hours
Departure airport Arrival airport Flight time Airline–Aircraft–Flight# combos
RPLL VHHH 2.5 Hours Philippine Airlines 306 — A321
VHHH RPLL 2.5 Hours Philippine Airlines 307 — A321
LPPT EGCC 2.5 - 3 Hours TAP Portugal 1310 — A320
EGLL LPPT 2.5 - 3 Hours TAP Portugal 1359 — E190
RCTP RJGG 2.5 - 3 Hours Cathay Pacific 530 — B777-300ER
RKPC VHHH 2.5 - 3 Hours Cathay Dragon 325 — A320
VHHH RKPC 2.5 - 3 Hours Cathay Dragon 326 — A320
VTBS VHHH 2.5 - 3 Hours Cathay Pacific 654 — B777-300ER
RPLL VHHH 2.5 Hours Cathay Pacific 912 — A330-300
VHHH RPLL 2.5 Hours Cathay Pacific 913 — A350-1000
YBBN YMML 2.5 Hours Qantas 605 — B737-800
YBBN NVVV 3 Hours Air Vanuatu 20 — B737-800
KDFW KPHX 2.5 Hours American Airlines 544 — A321
KRDU KDFW 3 Hours American Airlines 1455 — MD80
RPVM VHHH 3 Hours Cathay Pacific 922 — A330-300
VHHH RPVM 3 Hours Cathay Pacific 925 — A330-300
VYYY WMKK 2.5 - 3 Hours Malaysian Airlines 741 — B737-800
WMKK VYYY 2.5 - 3 Hours Malaysia Airlines 740 — B737-800
WADD WMKK 3 Hours Malaysia Airlines 714 — B737-800
VTBS VHHH 2.5 - 3 Hours Thai Airways 638 — A330-300
VHHH VTBS 2.5 - 3 Hours Thai Airways 603 — B777-300ER
VHHH VTCC 3 Hours Dragonair 232 — A320
VHHH VTSP 3 Hours Dragonair 212 — A320

This section is still under construction…

U.S: CA, NV, AZ, OR, CO, UT, NM
1 hour or less
Departure airport Arrival airport Flight time Airline–Aircraft–Flight# combos
KLAX KSFO 55 min. Delta 2614 — A319; Alaska 3397 — E175; United 1093 — B737-900
KLAX KLAS 40 min. Southwest 2686 — B737-700; Alaska 3322 — E175
KLAX KSAN 20 min. United 4643 — CRJ-700; United 4629 — E175
KLAX KPHX 45 min. Delta 8836 — B757-200; Delta 3738 — E175; United 741 — B737-900; American 313 — A321
U.S: OR, WA; Southwestern Canada
Japan

Moderators, please consider making this a wiki.

3 Likes
2

PHOG-PHNL SWA 738 HAL 712, you can add too

1 Like
3

While searching for a flight number for the 737 on Flight Radar 24, I could only find the MAX-8 on that route, but I know I’ve seen a NG on it before. Until I find it again, the flight number will be for a MAX.

4

Actually, I think I’ve done it with an NG in Infinite Flight before. (why I found the NG flight in the first place) I’ll look at my callsign in the replay when I get the chance.

5

ive been on it on the -8H4 more than 3 times

6

Hmm… Anyway the flight number is updated.

7

If I have a long list (like really long) of short haul flights that are interesting that I have flown IRL, would you prefer me to DM it to you or just post it here?

8

Please post here to keep everything in the same place. If you’re concerned about is taking up too much space then put it inside a detail thing.

1 Like
9

Here ya go!

My Short Haul Flights
Departure airport Arrival airport Flight time Airline–Aircraft–Flight# combos
RPLL VHHH 2.5 Hours Philippine Airlines 306 — A321
RPVV RPLL 50 Minutes Philippine Airlines 2964 — Dash-8
RPLL RPVV 50 Minutes Philippine Airlines 2963 — Dash-8
VHHH RPLL 2.5 Hours Philippine Airlines 307 — A321
LPPT EGCC 2.5 - 3 Hours TAP Portugal 1310 — A320
LPPR LPPT 40 Minutes TAP Portugal 1933 — E190
LPPT LPPR 40 Minutes TAP Portugal 1950 — E190
EGLL LPPT 2.5 - 3 Hours TAP Portugal 1359 — E190
EGLL EGCC 45 Minutes British Airways 32 — A321
VVDN VHHH 1.5 - 2 Hours VietJetAir 872 — A321
VHHH VVDN 1.5 - 2 Hours VietJetAir 873 — A321
WMKL WMKK 50 Minutes Malaysian Airlines 1471 — B737-800
WMKK WMKL 50 Minutes Malaysian Airlines 1446 — B737-800
RJCC RJGG 1.5 - 2 Hours Japan Airlines 3106 — B737-800
RJGG RJCC 1.5 - 2 Hours Japan Airlines 3115 — B737-800
RCTP RJGG 2.5 - 3 Hours Cathay Pacific 530 — B777-300ER
VHHH RCTP 1.5 - 2 Hours Cathay Pacific 530 — B777-300ER
RKPC VHHH 2.5 - 3 Hours Cathay Dragon 325 — A320
VHHH RKPC 2.5 - 3 Hours Cathay Dragon 326 — A320
RCKH VHHH 1.5Hours China Airlines 671 — B737-800
VHHH RCKH 1.5Hours China Airlines 934 — A330-300
VTBS VHHH 2.5 - 3 Hours Cathay Pacific 654 — B777-300ER
RPLL VHHH 2.5 Hours Cathay Pacific 912 — A330-300
VHHH RPLL 2.5 Hours Cathay Pacific 913 — A350-1000
EGLL EGPF 1.5 Hours British Airways 1472 — A321
YMHB YMML 1 Hour Qantas 1552 — B737-800
YMML YMHB 1 Hour Qantas 1503 — B737-800
YBBN YMML 2.5 Hours Qantas 605 — B737-800
YBBN NVVV 3 Hours Air Vanuatu 20 — B737-800
NVVW NVVV 1 Hour Air Vanuatu 1241 — ATR72-600
NVVV NVVW 1 Hour Air Vanuatu 238 — ATR72-600
NVSS NVVV 50 Minutes Air Vanuatu 211 — ATR72-600
NVVV NVSS 50 Minutes Air Vanuatu 208 — ATR72-600
RPVD RPLL 1.5 Hours Philippine Airlines 2544 — A320
RPLL RPVD 1.5 Hours Philippine Airlines 2545 — A320
KDFW KPHX 2.5 Hours American Airlines 544 — A321
KRDU KDFW 3 Hours American Airlines 1455 — MD80
KORD KRDU 2 Hours American Airlines 168 — MD80
RPVM VHHH 3 Hours Cathay Pacific 922 — A330-300
VHHH RPVM 3 Hours Cathay Pacific 925 — A330-300
VYYY WMKK 2.5 - 3 Hours Malaysian Airlines 741 — B737-800
VYTD VYYY 50 Minutes Air KBZ 245 — ATR72-600
VYHH VYTD 1 Hour Air KBZ 122 — ATR72-600
VYMD VYHH 30 Minutes Air KBZ 918 — ATR72-600
VYBG VYMD 30 Minutes Air KBZ 917 — ATR72-600
VYYY VYBG 1.5 Hours Air KBZ 917 — ATR72-600
WMKK VYYY 2.5 - 3 Hours Malaysia Airlines 740 — B737-800
WADD WMKK 3 Hours Malaysia Airlines 714 — B737-800
VTBS VHHH 2.5 - 3 Hours Thai Airways 638 — A330-300
VLLB VTBS 1.5 Hours Thai Airways 2577 — A320
VTBS VLLB 1.5 Hours Thai Airways 2576 — A320
VHHH VTBS 2.5 - 3 Hours Thai Airways 603 — B777-300ER
FQIN FQMA 1 Hour LAM Mozambique 124 — Dash-8
FAOR FQIN 1 Hour LAM Mozambique 300 — Dash-8
VTCC VHHH 2 Hours Dragonair 233 — A320
VHHH VTCC 3 Hours Dragonair 232 — A320
VTSP VHHH 2 Hours Dragonair 213 — A320
VHHH VTSP 3 Hours Dragonair 212 — A320
VAUD VABB 1.5 Hours Air India 471 — A321
VABB VIJP 2 Hours SpiceJet 344 — B737-800

That is all I can find for now without seriously digging deep.

1 Like
10

Wow. I’ll be sure to add that! Thanks!

1 Like
11

No worries! Thought I might as well help with this side of the world!

1 Like
12

not yet sorted

I’ll sort them when I have more time.

1 Like
13

Actually Hold on, now I have them written down I can sort them. Apologies, should have done that initially!

1 Hour or Less
Departure airport Arrival airport Flight time Airline–Aircraft–Flight# combos
RPVV RPLL 50 Minutes Philippine Airlines 2964 — Dash-8
RPLL RPVV 50 Minutes Philippine Airlines 2963 — Dash-8
LPPR LPPT 40 Minutes TAP Portugal 1933 — E190
LPPT LPPR 40 Minutes TAP Portugal 1950 — E190
EGLL EGCC 45 Minutes British Airways 32 — A321
WMKL WMKK 50 Minutes Malaysian Airlines 1471 — B737-800
WMKK WMKL 50 Minutes Malaysian Airlines 1446 — B737-800
YMHB YMML 1 Hour Qantas 1552 — B737-800
YMML YMHB 1 Hour Qantas 1503 — B737-800
NVVW NVVV 1 Hour Air Vanuatu 1241 — ATR72-600
NVVV NVVW 1 Hour Air Vanuatu 238 — ATR72-600
NVSS NVVV 50 Minutes Air Vanuatu 211 — ATR72-600
NVVV NVSS 50 Minutes Air Vanuatu 208 — ATR72-600
VYTD VYYY 50 Minutes Air KBZ 245 — ATR72-600
VYHH VYTD 1 Hour Air KBZ 122 — ATR72-600
VYMD VYHH 30 Minutes Air KBZ 918 — ATR72-600
VYBG VYMD 30 Minutes Air KBZ 917 — ATR72-600
FQIN FQMA 1 Hour LAM Mozambique 124 — Dash-8
FAOR FQIN 1 Hour LAM Mozambique 300 — Dash-8
1-2 Hours
Departure airport Arrival airport Flight time Airline–Aircraft–Flight# combos
VVDN VHHH 1.5 - 2 Hours VietJetAir 872 — A321
VHHH VVDN 1.5 - 2 Hours VietJetAir 873 — A321
RJCC RJGG 1.5 - 2 Hours Japan Airlines 3106 — B737-800
RJGG RJCC 1.5 - 2 Hours Japan Airlines 3115 — B737-800
VHHH RCTP 1.5 - 2 Hours Cathay Pacific 530 — B777-300ER
RCKH VHHH 1.5Hours China Airlines 671 — B737-800
VHHH RCKH 1.5Hours China Airlines 934 — A330-300
EGLL EGPF 1.5 Hours British Airways 1472 — A321
RPVD RPLL 1.5 Hours Philippine Airlines 2544 — A320
RPLL RPVD 1.5 Hours Philippine Airlines 2545 — A320
KORD KRDU 2 Hours American Airlines 168 — MD80
VYYY VYBG 1.5 Hours Air KBZ 917 — ATR72-600
VLLB VTBS 1.5 Hours Thai Airways 2577 — A320
VTBS VLLB 1.5 Hours Thai Airways 2576 — A320
VTCC VHHH 2 Hours Dragonair 233 — A320
VTSP VHHH 2 Hours Dragonair 213 — A320
VAUD VABB 1.5 Hours Air India 471 — A321
VABB VIJP 2 Hours SpiceJet 344 — B737-800
2-3 Hours
Departure airport Arrival airport Flight time Airline–Aircraft–Flight# combos
RPLL VHHH 2.5 Hours Philippine Airlines 306 — A321
VHHH RPLL 2.5 Hours Philippine Airlines 307 — A321
LPPT EGCC 2.5 - 3 Hours TAP Portugal 1310 — A320
EGLL LPPT 2.5 - 3 Hours TAP Portugal 1359 — E190
RCTP RJGG 2.5 - 3 Hours Cathay Pacific 530 — B777-300ER
RKPC VHHH 2.5 - 3 Hours Cathay Dragon 325 — A320
VHHH RKPC 2.5 - 3 Hours Cathay Dragon 326 — A320
VTBS VHHH 2.5 - 3 Hours Cathay Pacific 654 — B777-300ER
RPLL VHHH 2.5 Hours Cathay Pacific 912 — A330-300
VHHH RPLL 2.5 Hours Cathay Pacific 913 — A350-1000
YBBN YMML 2.5 Hours Qantas 605 — B737-800
YBBN NVVV 3 Hours Air Vanuatu 20 — B737-800
KDFW KPHX 2.5 Hours American Airlines 544 — A321
KRDU KDFW 3 Hours American Airlines 1455 — MD80
RPVM VHHH 3 Hours Cathay Pacific 922 — A330-300
VHHH RPVM 3 Hours Cathay Pacific 925 — A330-300
VYYY WMKK 2.5 - 3 Hours Malaysian Airlines 741 — B737-800
WMKK VYYY 2.5 - 3 Hours Malaysia Airlines 740 — B737-800
WADD WMKK 3 Hours Malaysia Airlines 714 — B737-800
VTBS VHHH 2.5 - 3 Hours Thai Airways 638 — A330-300
VHHH VTBS 2.5 - 3 Hours Thai Airways 603 — B777-300ER
VHHH VTCC 3 Hours Dragonair 232 — A320
VHHH VTSP 3 Hours Dragonair 212 — A320
3 Likes
14

No problem. Thank you so much! Re-pasting it now.

15
1 Like
16

Organizing by region in addition to flight time would be helpful as well.
I’ll start with Japan, because there are just so many possible domestic routes - many of which are operated using widebodies - something you don’t see a lot outside East Asia.

Origin Destination Departure(Local) Arrival(Local) Total Travel Time (Minutes) Flight Number Aircraft
RJTT RJCC 1130 1305 95 JAL514 A359
RJTT RJCM 1240 1425 105 JAL567 B738
RJTT ROAH 1130 1425 175 ANA470 B772
RJTT RJSC 0715 0815 60 JAL175 E190
RJTT RJOT 1145 1305 80 JAL479 B738
RJTT RJOO 1325 1430 65 JAL119 A359
RJTT RJBD 0720 0840 80 JAL213 B738
RJBE RJSA 1240 1415 95 FDA833 E75L
RJTT RJOM 1540 1710 90 JAL437 B738
RJTT RJCC 1000 1135 95 ANA059 B772
RJTT RJFF 1915 2120 125 JAL333 B772
RJTT RJFO 0935 1120 105 JAL663 B738
RJTT ROAH 1010 1305 175 JAL909 B772
RJTT RJOB 1015 1135 80 JAL233 B738
RJTT RJSM 1035 1155 80 JAL155 E190
RJTT RJEC 1050 1230 100 JAL553 B738
RJTT RJSK 1105 1210 65 JAL163 B738
RJTT RJFF 1105 1305 120 JAL315 A359
RJTT RJCB 1120 1255 95 JAL575 B738
RJTT RJFF 1125 1325 120 ANA251 B789
RJTT RJFK 1145 1345 120 JAL647 B738
RJTT RJDC 1210 1355 105 JAL293 B738
RJTT RJCK 1215 1355 100 JAL543 B738
RJCC RJGG 0950 1145 115 APJ462 A320
RJCC RJTT 0955 1140 105 JAL504 A359
RJCC RJAA 1010 1200 110 APJ570 A320
RJCC RJBB 1110 1335 145 APJ104 A320
RJCC RJSC 1125 1245 80 FDA603 E75L
RJCC RJSK 1130 1240 70 ANA1832 DH8D
RJCC RJBB 1145 1405 140 JAL2504 B738
RJCC RJCN 1215 1305 50 ANA4883 DH8D
RJCC RJTT 1230 1410 100 ANA062 B772
RJCC RJSN 1230 1355 85 ANA1858 DH8D

This list is far from complete; I will continue to add flights later on.

17

Let’s give some love to the Caribbean, I have added a few routes that currently are flying at the moment. I hope this routes fit in with your requirements :D

I wanted to add some Caribbean Airline routes but since it’s being operated by the Boeing 737 MAX and Infinite Flight doesn’t have it, I decided to discard them.

1 Hour or less
Departure Airport Arrival Airport Flight time Airline-Aircraft-Flight# Combos
TJSJ TIST 30 Minutes Jetblue Airways 936 — A320
TJSJ MDPC 1 Hour JetBlue Airways 2631 — A320
MKJS MYNN 1 Hour Virgin Atlantic 108 — B787-9
1-2 Hours
Departure Airport Arrival Airport Flight time Airline-Aircraft-Flight# Combos
MDPC TNCB 1 Hour TUI Airlines 703 — B787-8
TJSJ MDSD 1.1 Hours JetBlue Airways 2537 — A320; Frontier Airlines 97 — A321
MYNN KMIA 1.1 Hours American Airlines 1921 — B737-800
MYNN KFLL 1.2 Hours Southwest Airlines 1858 — B737-700; Jetblue Airways 2394 — A320
MWCR MYNN 1.2 Hours British Airways 252 — B777-300ER
MYNN KMCO 1.3 Hours Jetblue Airways 1240 — E190
MWCR KMIA 1.3 Hours American Airlines 956 — A319
MWCR KFLL 1.3 Hours Southwest Airlines 1216 — B737-700
2-3 Hours
Departure Airport Arrival Airport Flight time Airline-Aircraft-Flight# Combos
MDSD KMIA 2.3 Hours American Airlines 1026 — B737-800
MDSD KFLL 2.3 Hours JetBlue Airways 2448 — A320; Spirit Airlines 845 — A320
MKJS MMUN 2.3 Hours TUI Airlines Netherlands 511 — B787-8
MDSD MPTO 2.4 Hours Copa Airlines 267 — B737-800
TJSJ MPTO 3 Hours Copa Airlines 451 – B737-800
TJSJ KMIA 3 Hours American Airlines 2227 — B737-800
TJSJ KFLL 3 Hours JetBlue Airways 1754 — A320

If anyone has any more Caribbean suggestions feel free to suggest them too.

2 Likes
18

Oh I can not believe I forgot

Departure airport Arrival airport Flight time Airline–Aircraft–Flight# combos
RJOO RJNO 50 min. Japan Airlines 2331 — E190 & B737-800
RJNO RJOO 50 min. Japan Airlines 2332 — E190 & B737-800
1 Like
19

That is operated by the E170 which is no longer in IF.

1 Like
20

True but I have also seen both of those historically from pictures while working to make it 3D. Just do not know how historic.

1 Like