Airline network statistics from 2LNR's schedule data

Definitions

Nonstop

A flight with zero en-route stops. A single flight number that touches down somewhere between its endpoints is excluded everywhere on this page, as it is on the 2LNR route map.

Directional route

An ordered pair of airports. JFK to LAX and LAX to JFK are two routes, because they are two separate schedules that can differ in frequency, equipment and carrier.

Operating carrier

The airline whose metal flies the segment, including its own regional affiliates flying under its brand. Codeshare partners that market a flight they do not operate are excluded, so one physical departure is counted once rather than once per partner.

Scheduled departure

One flight, on one date, scheduled to depart. It is a count of scheduled flying, not of seats, passengers, fares or availability.

Window

396 days: the 30 days before and the 365 days after the day the underlying snapshot was built, inclusive.

How the figures are produced

1. 2LNR continuously observes airline schedules and records each nonstop segment it sees, by carrier, aircraft type and date.
2. Those observations are aggregated into a route grain: one row per origin, destination, marketing airline, operating carrier and aircraft type, over the 396-day window.
3. Rows the marketing carrier does not itself operate are excluded, so a codeshared flight is counted once.
4. Rows whose implied speed, distance or aircraft range are physically impossible are excluded, and non-airport location codes such as rail and bus stations are excluded.
5. The four queries below run against that grain. Nothing on this page is estimated, extrapolated, seeded or hand-entered.

Limits worth knowing

• These counts describe what 2LNR observes, which is not the same as every flight operating in the world. A carrier or route absent here is absent from our data, not necessarily from the sky.
• Schedules are forward-looking and change constantly. A figure measured today will not reproduce exactly tomorrow.
• Charter, cargo-only and non-scheduled flying is not represented.
• No availability of any kind is published here. Seat, upgrade and award inventory is a separate question this report deliberately does not answer.

The queries

Run verbatim against the route grain described above. route_map_route_agg is the aggregated view; frequency is the number of scheduled departures on that grain row.

Totals

SELECT
    COUNT(DISTINCT (r.origin, r.destination))::bigint                                          AS directional_routes,
    COUNT(DISTINCT (LEAST(r.origin, r.destination), GREATEST(r.origin, r.destination)))::bigint AS airport_pairs,
    COUNT(DISTINCT r.airline) FILTER (WHERE r.airline ~ '^[A-Z0-9]{2,3}$')::bigint          AS operating_carriers,
    COALESCE(SUM(r.frequency), 0)::bigint                                                       AS scheduled_departures
FROM route_map_route_agg r
WHERE (r.operating_carrier = r.airline OR r.operating_carrier = '**')

Airports with nonstop service

SELECT COUNT(*)::bigint AS airports FROM (
    SELECT r.origin      AS code FROM route_map_route_agg r WHERE (r.operating_carrier = r.airline OR r.operating_carrier = '**')
    UNION
    SELECT r.destination AS code FROM route_map_route_agg r WHERE (r.operating_carrier = r.airline OR r.operating_carrier = '**')
) a

Busiest directional routes

SELECT r.origin, r.destination,
       COALESCE(SUM(r.frequency), 0)::bigint AS scheduled_departures,
       COUNT(DISTINCT r.airline)::int        AS operating_carriers
FROM route_map_route_agg r
WHERE (r.operating_carrier = r.airline OR r.operating_carrier = '**')
GROUP BY r.origin, r.destination
ORDER BY scheduled_departures DESC, r.origin, r.destination
LIMIT $1

Carriers by directional reach

SELECT r.airline,
       COUNT(DISTINCT (r.origin, r.destination))::bigint AS directional_routes,
       COALESCE(SUM(r.frequency), 0)::bigint             AS scheduled_departures
FROM route_map_route_agg r
WHERE (r.operating_carrier = r.airline OR r.operating_carrier = '**') AND r.airline ~ '^[A-Z0-9]{2,3}$'
GROUP BY r.airline
ORDER BY directional_routes DESC, scheduled_departures DESC, r.airline
LIMIT $1

Suggested citation:

Interline, Inc. “Airline network statistics from 2LNR's schedule data.” Measured August 9, 2026. https://2lnr.com/data/network

Machine-readable copy:

Download the figures as CSV — one row per measure, each carrying the date it was measured and the window length.