OpenAirDocs.org
American Airlines Inc

Registered aircraft · 1,000

Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.

Query with SQL
duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
  WHERE g.registrant_name = 'AMERICAN AIRLINES INC' OR list_contains(g.other_registrant_names, 'AMERICAN AIRLINES INC')
  ORDER BY g.n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

N107USAirbus Industrie A320-214 · S/N 1052Built 1999 · Fort Worth, TXN108NNAirbus Industrie A321-231 · S/N 5946Built 2014 · Fort Worth, TXN108UWAirbus Industrie A320-214 · S/N 1061Built 1999 · Fort Worth, TXN109UWAirbus Industrie A320-214 · S/N 1065Built 1999 · Fort Worth, TXN110ANAirbus Industrie A321-231 · S/N 5975Built 2014 · Fort Worth, TXN110UWAirbus Industrie A320-214 · S/N 1112Built 1999 · Fort Worth, TXN111USAirbus Industrie A320-214 · S/N 1114Built 1999 · Fort Worth, TXN111ZMAirbus Industrie A321-231 · S/N 5983Built 2014 · Fort Worth, TXN112ANAirbus Industrie A321-231 · S/N 5991Built 2014 · Fort Worth, TXN112USAirbus Industrie A320-214 · S/N 1134Built 1999 · Fort Worth, TXN113ANAirbus Industrie A321-231 · S/N 6020Built 2014 · Fort Worth, TXN114UWAirbus Industrie A320-214 · S/N 1148Built 1999 · Fort Worth, TXN115NNAirbus Industrie A321-231 · S/N 6063Built 2014 · Fort Worth, TXN117ANAirbus A321-231 · S/N 6094Built 2014 · Fort Worth, TXN12028Airbus A319-115 · S/N 6456Built 2015 · Fort Worth, TXN125UWAirbus A320-214 · S/N 4086Built 2009 · Forth Worth, TXN126UWAirbus A320-214 · S/N 4149Built 2009 · Forth Worth, TXN127UWAirbus A320-214 · S/N 4202Built 2010 · Fort Worth, TXN128UWAirbus A320-214 · S/N 4242Built 2010 · Fort Worth, TXN135NNAirbus A321-231 · S/N 6520Built 2015 · Fort Worth, TXN136ANAirbus A321-231 · S/N 6532Built 2015 · Fort Worth, TXN137AAAirbus A321-231 · S/N 6647Built 2015 · Fort Worth, TXN138ANAirbus A321-231 · S/N 6650Built 2015 · Fort Worth, TXN139ANAirbus A321-231 · S/N 6687Built 2015 · Fort Worth, TXN140ANAirbus A321-231 · S/N 6667Built 2015 · Fort Worth, TXN141NNAirbus A321-231 · S/N 6656Built 2015 · Fort Worth, TXN142ANAirbus A321-231 · S/N 6711Built 2015 · Fort Worth, TXN143ANAirbus A321-231 · S/N 6745Built 2015 · Fort Worth, TXN144ANAirbus A321-231 · S/N 6723Built 2015 · Fort Worth, TXN145ANAirbus A321-231 · S/N 6783Built 2015 · Fort Worth, TXN146AAAirbus A321-231 · S/N 6761Built 2015 · Fort Worth, TXN147AAAirbus A321-231 · S/N 6802Built 2015 · Fort Worth, TXN148ANAirbus A321-231 · S/N 6790Built 2015 · Fort Worth, TXN149ANAirbus A321-231 · S/N 6812Built 2015 · Fort Worth, TXN150NNAirbus A321-231 · S/N 6828Built 2015 · Fort Worth, TXN150UWAirbus A321-211 · S/N 5504Built 2013 · Fort Worth, TXN151ANAirbus A321-231 · S/N 6840Built 2015 · Fort Worth, TXN151UWAirbus A321-211 · S/N 5513Built 2013 · Fort Worth, TXN152AAAirbus A321-231 · S/N 6887Built 2015 · Fort Worth, TXN152UWAirbus A321-211 · S/N 5588Built 2013 · Fort Worth, TXN153ANAirbus A321-231 · S/N 6908Built 2015 · Fort Worth, TXN153UWAirbus A321-211 · S/N 5594Built 2013 · Fort Worth, TXN154AAAirbus A321-231 · S/N 6928Built 2016 · Fort Worth, TXN154UWAirbus A321-211 · S/N 5644Built 2013 · Fort Worth, TXN155NNAirbus A321-231 · S/N 6940Built 2016 · Fort Worth, TXN155UWAirbus A321-211 · S/N 5659Built 2013 · Fort Worth, TXN156ANAirbus A321-231 · S/N 6983Built 2016 · Fort Worth, TXN156UWAirbus A321-211 · S/N 5684Built 2013 · Fort Worth, TXN157AAAirbus A321-231 · S/N 6998Built 2016 · Fort Worth, TXN157UWAirbus A321-211 · S/N 5696Built 2013 · Fort Worth, TX
Back to American Airlines Inc