Trans World Airlines Inc
Earlier aircraft under this name · 146
Cancelled registrations that named this owner when they ended, newest first.
Query with SQL
duckdb -csv -c "SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code WHERE d.registrant_name = 'TRANS WORLD AIRLINES INC' OR list_contains(d.other_registrant_names, 'TRANS WORLD AIRLINES INC') ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id"
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.
SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code WHERE d.registrant_name = 'TRANS WORLD AIRLINES INC' OR list_contains(d.other_registrant_names, 'TRANS WORLD AIRLINES INC') ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N765TWMcdonnell Douglas DC-9-83(MD-83) · S/N 53120N836NKMcdonnell Douglas DC-9-83(MD-83) · S/N 53045N7036TLockheed L-1011-385-1-15 · S/N 193B-1232N605TWBoeing 767-231 · S/N 22568N6763TBoeing 707-131B · S/N 19220N602TWBoeing 767-231 · S/N 22565N855TWBoeing 727-31 · S/N 18574N601TWBoeing 767-231 · S/N 22564N54325Boeing 727-231 · S/N 20232N54330Boeing 727-231 · S/N 20308N54331Boeing 727-231 · S/N 20309N54332Boeing 727-231 · S/N 20310N54327Boeing 727-231 · S/N 20234N54329Boeing 727-231 · S/N 20307N856TWBoeing 727-31 · S/N 18575N53116Boeing 747-131 · S/N 20321N93109Boeing 747-131 · S/N 19675N133TWBoeing 747-156 · S/N 19957N53110Boeing 747-131 · S/N 19676N134TWBoeing 747-156 · S/N 19958N831TWBoeing 727-31 · S/N 18902N854TWBoeing 727-31 · S/N 18573N54338Boeing 727-231 · S/N 20843N93104Boeing 747-131 · S/N 19670N93105Boeing 747-131 · S/N 19671N93119Boeing 747-131 · S/N 20083N91208Lockheed 749-79 · S/N 2584N18711Boeing 707-331B · S/N 19225N18710Boeing 707-331B · S/N 19224N18702Boeing 707-331B · S/N 18979N8729Boeing 707-331B · S/N 20058N18707Boeing 707-331B · S/N 18983N28714Boeing 707-331B · S/N 18408N18708Boeing 707-331B · S/N 18984N8705TBoeing 707-331B · S/N 18916N8725TBoeing 707-331B · S/N 18918N8732Boeing 707-331B · S/N 20061N18706Boeing 707-331B · S/N 18982N749TWBoeing 707-131B · S/N 18388N794TWBoeing 707-331C · S/N 20429N6764TBoeing 707-131B · S/N 19221N6722Boeing 707-131B · S/N 18988N789TWBoeing 707-373C · S/N 18709N797TWBoeing 707-131B · S/N 18760N771TWBoeing 707-331 · S/N 17688N766TWBoeing 707-331 · S/N 17681N764TWBoeing 707-331 · S/N 17678N765TWBoeing 707-331 · S/N 17679N770TWBoeing 707-331 · S/N 17687N1057TDouglas DC9-15 · S/N 45738
Back to Trans World Airlines Inc