tk-20260729-162119

Scanned

166
Offers
1
Routes
0
Errors
production
Env
oneway
Trip
TK
Carrier

What this run found

10 trips had an Amadeus offer. For each, this is what NDC quoted for the same itinerary.

Route BOSโ€“DXB ยท trip a route on exact dates, what a search asks for ยท itinerary the exact flight combination that gets ticketed, e.g. EK238 / EK237. Tables below say which of the three they compare. Hover a flight code for its departure time.

Per trip: Amadeus's cheapest itinerary vs NDCtrip

One row per trip, anchored on the itinerary Amadeus was cheapest on โ€” what a price-driven agent would have booked. Shows what NDC quoted for those same flights. Every trip appears, including the ones NDC won: they are what the rest are measured against

origindestinationdeparture_datereturn_dateflight_codesreasonoperated_byamadeus_netndc_netdeltapct_diffndc_best_net
PRN LAS 2026-08-01 โ€” TK1018-TK79-TK9591 NDC returned nothing TK,UA 2223.93 โ€” โ€” โ€” โ€”
PRN LAS 2026-08-03 โ€” TK1020-TK185-TK8629 NDC returned nothing TK,UA 2252.33 โ€” โ€” โ€” โ€”
PRN LAS 2026-08-04 โ€” TK1020-TK185-TK8629 NDC returned nothing TK,UA 1975.33 โ€” โ€” โ€” โ€”
PRN LAS 2026-08-05 โ€” TK1020-TK289-TK9591 NDC returned nothing TK,UA 2223.93 โ€” โ€” โ€” โ€”
PRN LAS 2026-08-08 โ€” TK1020-TK185-TK8629 NDC returned nothing TK,UA 1935.33 โ€” โ€” โ€” โ€”
PRN LAS 2026-08-09 โ€” TK1020-TK185-TK8629 NDC returned nothing TK,UA 1422.33 โ€” โ€” โ€” โ€”
PRN LAS 2026-08-10 โ€” TK1020-TK3-TK8942 NDC returned nothing TK,B6 1852.33 โ€” โ€” โ€” โ€”
PRN LAS 2026-08-07 โ€” TK1020-TK185-TK8629 NDC cheaper TK,UA 1627.33 1565.95 61.38 3.9 1565.95
PRN LAS 2026-08-06 โ€” TK1020-TK185-TK8629 NDC cheaper TK,UA 1935.33 1866.75 68.58 3.7 1787.79
PRN LAS 2026-08-02 โ€” TK1018-TK79-TK9591 NDC cheaper TK,UA 2223.93 2152.99 70.94 3.3 2152.99

download this table as CSV

What decides the cheaper price

For itineraries both sources quoted: whether the cheaper net price comes from the fare or from the commission paid back โ€” net price is the fare minus commission. The last column counts the wins that would reverse if commission were removed

driveritinerariesavg_net_gapflips_without_commission
ndc wins on commission 11 62.16 11
amadeus wins on fare 1 -296.82 0

download this table as CSV

โ–ถ Itinerary ledger 12 itinerary Every itinerary quoted by both sources, priced side by side โ€” the drill-down behind why-amadeus
origindestinationdeparture_datereturn_dateflight_codesnightsamadeus_netndc_netdeltapct_diffcheaper
PRN LAS 2026-08-07 โ€” TK1018-TK79-TK9591 โ€” 1906.93 2203.75 -296.82 -13.5 amadeus
PRN LAS 2026-08-07 โ€” TK1018-TK5-TK8629 โ€” 1882.33 1866.75 15.58 0.8 ndc
PRN LAS 2026-08-07 โ€” TK1020-TK185-TK8629 โ€” 1627.33 1565.95 61.38 3.9 ndc
PRN LAS 2026-08-07 โ€” TK1018-TK1-TK8942 โ€” 1890.98 1827.74 63.24 3.5 ndc
PRN LAS 2026-08-07 โ€” TK1020-TK179-TK9582 โ€” 1906.93 1842.79 64.14 3.5 ndc
PRN LAS 2026-08-07 โ€” TK1018-TK11-TK8942 โ€” 1852.33 1787.79 64.54 3.6 ndc
PRN LAS 2026-08-07 โ€” TK1020-TK111-TK8942 โ€” 1852.33 1787.79 64.54 3.6 ndc
PRN LAS 2026-08-07 โ€” TK1018-TK111-TK8942 โ€” 1852.33 1787.79 64.54 3.6 ndc
PRN LAS 2026-08-06 โ€” TK1020-TK185-TK8629 โ€” 1935.33 1866.75 68.58 3.7 ndc
PRN LAS 2026-08-02 โ€” TK1018-TK79-TK9591 โ€” 2223.93 2152.99 70.94 3.3 ndc
PRN LAS 2026-08-06 โ€” TK1018-TK9-TK9582 โ€” 2223.93 2152.99 70.94 3.3 ndc
PRN LAS 2026-08-06 โ€” TK1018-TK5-TK8629 โ€” 2252.33 2176.95 75.38 3.5 ndc

download this table as CSV

โ–ถ NDC vs Amadeus per trip (cheapest to cheapest) 3 trip Two-way ledger per trip: cheapest Amadeus vs cheapest NDC, signed delta. The two sides may be different itineraries
origindestinationdeparture_datereturn_datenightsamadeus_netndc_netdeltapct_diffcheaper
PRN LAS 2026-08-07 โ€” โ€” 1627.33 1565.95 61.38 3.9 ndc
PRN LAS 2026-08-02 โ€” โ€” 2223.93 2152.99 70.94 3.3 ndc
PRN LAS 2026-08-06 โ€” โ€” 1935.33 1787.79 147.54 8.3 ndc

download this table as CSV

โ–ถ Trips where Amadeus was cheapest trip Trips where cheapest Amadeus < cheapest NDC. Coarser than why-amadeus โ€” the two sides may be different itineraries
No trips where Amadeus beat NDC.
โ–ถ Route overview: who wins where 1 route Per-route two-way overview: how many itineraries Amadeus vs NDC wins, and the biggest gap each way (computed per exact itinerary, so no nights-mixing)
origindestinationtripsamadeus_winsndc_winstiesbest_amadeus_deltabest_ndc_delta
PRN LAS 3 0 3 0 โ€” 147.54

download this table as CSV

Offer summary by source

Total offers by source and fare type

sourcefare_typeoffer_countmin_netavg_netmedian_netroutes
amadeus nego 117 1422.33 2008.17 1935.33 1
ndc_direct published 49 1565.95 2468.7 2152.99 1

download this table as CSV

Searches where a source returned nothingsearch

Routes/dates where one source returned zero offers (ndc_missing shown first)

origindestinationdeparture_dateamadeus_countndc_countamadeus_min_netndc_min_netgap
PRN LAS 2026-08-01 4 0 2223.93 โ€” ndc_missing
PRN LAS 2026-08-03 1 0 2252.33 โ€” ndc_missing
PRN LAS 2026-08-04 4 0 1975.33 โ€” ndc_missing
PRN LAS 2026-08-05 11 0 2223.93 โ€” ndc_missing
PRN LAS 2026-08-08 6 0 1935.33 โ€” ndc_missing
PRN LAS 2026-08-09 35 0 1422.33 โ€” ndc_missing
PRN LAS 2026-08-10 11 0 1852.33 โ€” ndc_missing

download this table as CSV

Download raw data (parquet)