The Double Connect Routes table details information about all double connections, including marketing airlines, operating airlines and stations on each segment. When the Host Airline Report Only checkbox is selected on the Scenario Analysis screen (Figure 1), the output is limited to connections involving the host airline as either a marketing airline or an operating airline.

The table is accessible from the menu Planning > Connection Reports > Double Connects, as shown in Figure 2.

This image is password protected.
This image is password protected.
Enter the password in the first protected image above to unlock all images on this page.

Table Structure

FieldDescription
YYMMTravel month in the YYMM format (2 digits year + 2 digits month)
OrgOrigin airport
Cnx_1Connecting airport 1
Cnx_2Connecting airport 2
DstDestination airport
Org_CountryOrigin country code
Dst_CountryDestination country code
OnlineTrue for online connections
Dom_Mkt_ALDominant market airline
Mkt_AL_1Marketing airline on the first flight leg
Mkt_AL_2Marketing airline on the second flight leg
Mkt_AL_3Marketing airline on the third flight leg
Dom_Opt_ALDominant operating airline
Opt_AL_1Operating airline on the first flight leg
Opt_AL_2Operating airline on the second flight leg
Opt_AL_3Operating airline on the third flight leg
Num_ALsNumber of different marketing airlines on the trip
Miles_1Distance of the first leg in miles
Miles_2Distance of the second leg in miles
Miles_3Distance of the third leg in miles
Table 1: Data Structure (part 1)
This image is password protected.
Enter the password in the first protected image above to unlock all images on this page.
FieldDescription
Great_Circle_MilesGreat circle distance in miles from the trip origin to the trip destination
Circuity_BandTrip circuity category:
2: low circuity
3: medium circuity
4: high circuity
Turbo4The number of operations where at least one flight is operated by a turboprop and the total grounding time at all connecting points is equal to or less than 4 hours
RJ4The number of operations where at least one flight is operated by a regional jet and the total grounding time is equal to or less than 4 hours
JJ4The number of operations where all flights are operated by jets and the total grounding time is equal to or less than 4 hours
Turbo8The number of operations where at least one flight is operated by a turboprop and the total grounding time at all connecting points is greater than 4 hours and equal to or less than 8 hours
RJ8The number of operations where at least one flight is operated by a regional jet and the total grounding time is between 4-8 hours
JJ8The number of operations where all flights are operated by jets and the total grounding time is between 4-8 hours
Turbo12The number of operations where at least one flight is operated by a turboprop and the total grounding time is between 8-12 hours
RJ12The number of operations where at least one flight is operated by a regional jet and the total grounding time is between 8-12 hours
JJ12The number of operations where all flights are operated by jets and the total grounding time is between 8-12 hours
Turbo24The number of operations where at least one flight is operated by a turboprop and the total grounding time is between 12-24 hours
RJ24The number of operations where at least one flight is operated by a regional jet and the total grounding time is between 12-24 hours
JJ24The number of operations where all flights are operated by jets and the total grounding time is between 12-24 hours
Table 2: Data Structure (part 2)