Skip to content

Twa International Inc

Earlier aircraft under this name · 25

Cancelled registrations that named this owner when they ended, newest first.

Query with SQL

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 = 'TWA INTERNATIONAL INC' OR list_contains(d.other_registrant_names, 'TWA INTERNATIONAL INC') ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

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 = 'TWA INTERNATIONAL INC' OR list_contains(d.other_registrant_names, 'TWA INTERNATIONAL 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 = 'TWA INTERNATIONAL INC' OR list_contains(d.other_registrant_names, 'TWA INTERNATIONAL 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.

N347TCBritish Aerospace HS 125-700A · S/N 257055Cancelled Feb 4, 2026 · Exported to Mexico · Cheyenne, WY N700KLBritish Aerospace HS 125-700A · S/N 257105Cancelled Apr 1, 2023 · Registration expired, pending cancellation · Built 1980 · Cheyenne, WY N316JPBeech B200 · S/N BB-923Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Built 1981 · Cheyenne, WY N903DKBeech 200 · S/N BB-578Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Built 1980 · Cheyenne, WY N4231VPiper PA-31-350 · S/N 31-7652162Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Built 1976 · Cheyenne, WY N28AVPiper PA-31-350 · S/N 31-7405161Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Cheyenne, WY N530GAGulfstream American G-1159 · S/N 247Cancelled Oct 2, 2021 · Registration expired, pending cancellation · Built 1979 · Cheyenne, WY N500KDBeech B100 · S/N BE-79Cancelled May 5, 2020 · Exported to Mexico · Built 1980 · Cheyenne, WY N706AMHawker Siddeley HS.125 SERIES 700A · S/N NA0206Cancelled Apr 29, 2020 · Exported to Mexico · Built 1977 · Cheyenne, WY N15HEGulfstream American G-1159A · S/N 369Cancelled Apr 27, 2020 · Exported to Mexico · Built 1982 · Cheyenne, WY N812DPBeech 200 · S/N BB-69Cancelled Mar 16, 2020 · Exported to Mexico · Built 1975 · Cheyenne, WY N54TSBeech 200 · S/N BB515Cancelled Mar 5, 2020 · Exported to Mexico · Built 1979 · Cheyenne, WY N904JRBritish Aerospace BAE 125 SERIES 800A · S/N 258018Cancelled Oct 29, 2019 · Exported to Mexico · Cheyenne, WY N465BCRockwell International NA-265-65 · S/N 465-53Cancelled Oct 28, 2019 · Exported to Mexico · Built 1981 · Cheyenne, WY N67511Beech C90 · S/N LJ-888Cancelled Sep 24, 2019 · Exported to Mexico · Built 1980 · Cheyenne, WY N322BCBritish Aerospace HS 125-700A · S/N NA0322Cancelled Sep 18, 2019 · Exported to Mexico · Cheyenne, WY N39PHBeech 200C · S/N BL-3Cancelled Sep 4, 2019 · Exported to Mexico · Cheyenne, WY N795CABeech 200 · S/N BB-559Cancelled Jul 10, 2019 · Exported to Mexico · Built 1979 · Cheyenne, WY N991KABeech 200 · S/N BB-809Cancelled Jun 21, 2019 · Exported to Mexico · Built 1981 · Cheyenne, WY N990PARockwell International NA-265-60 · S/N 306-114Cancelled Apr 16, 2019 · Built 1975 · Cheyenne, WY N2883Beech 200 · S/N BB-144Cancelled Apr 10, 2019 · Exported to Mexico · Built 1976 · Cheyenne, WY N4039LPiper PA-31-325 · S/N 31-8112013Cancelled Apr 3, 2019 · Exported to Mexico · Built 1980 · Cheyenne, WY N3540ZPiper PA-31-350 · S/N 31-8052085Cancelled Jan 18, 2019 · Exported to Mexico · Built 1980 · Cheyenne, WY N241CWBeech B100 · S/N BE-54Cancelled Jan 9, 2019 · Exported to Mexico · Built 1978 · Cheyenne, WY N410REBeech A100-1 · S/N BB04Cancelled Dec 4, 2018 · Exported to Mexico · Built 1972 · Cheyenne, WY

Back to Twa International Inc