OpenAirDocs.org
United States Of America

Earlier aircraft under this name · 27

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 = 'UNITED STATES OF AMERICA' OR list_contains(d.other_registrant_names, 'UNITED STATES OF AMERICA')
  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.

N455AEEurocopter AS 350 B2 · S/N 3509Cancelled Jul 2, 2024 · Exported to Canada · Washington, DCN910SFMcdonnell Douglas DC-10-10 · S/N 46524Cancelled Jan 29, 2018 · Registration expired, pending cancellation · Built 1972 · Van Nuys, CAN58022Beech B200C · S/N BL-88Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Washington, DCN5803FBeech B200C · S/N BL-105Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Washington, DCN58009Beech B200C · S/N BL-83Cancelled Dec 18, 2014 · Registration expired, pending cancellation · Washington, DCN5819TBeech B200C · S/N BL-106Cancelled Dec 17, 2014 · Registration expired, pending cancellation · Washington, DCN932MLDouglas DC-9-31 · S/N 47547Cancelled Oct 28, 2013 · Registration expired, pending cancellation · Built 1971 · China Lake, CAN400BYGates Learjet 35A · S/N 535Cancelled Jul 12, 2005 · Second triennial mailing, no response · Built 1984 · Wright Patterson, OHN3099DAyres S2R-T65 · S/N T652XCancelled Aug 25, 1993 · Triennial form not returned · Washington, DCN3099FAyres S2R-T65 · S/N T653XCancelled Aug 25, 1993 · Triennial form not returned · Washington, DCN3099MAyres S2R-T65 · S/N T651XCancelled Aug 25, 1993 · Triennial form not returned · Washington, DCN4999GNorth American T-39A · S/N 59-2869Cancelled Jul 1, 1981 · Washington, DCN2295VNorth American T-39A · S/N 592868Cancelled Feb 12, 1979 · Washington, DCN88946Douglas C54G-DC · S/N 36069Cancelled Jun 4, 1954 · New Your 17, NYN88948Douglas C54G-DC · S/N 36043Cancelled Jun 4, 1954N88953Douglas C54G-DC · S/N 35990Cancelled Jun 4, 1954 · Washington, DCN88954Douglas C54G-DC · S/N 36070Cancelled Jun 4, 1954 · Washington, DCN88955Douglas C54G-DC · S/N 36039Cancelled Jun 4, 1954 · Washington, DCN88958Douglas C54-DC · S/N 36073Cancelled Jun 4, 1954 · Washington, DCN88959Douglas C54G-DC · S/N 36053Cancelled Jun 4, 1954 · Built 1945 · Washington, DCN1645MBoeing E75 · S/N 75-8797Cancelled Feb 21, 1952N702Grumman J4F-2 · S/N 1320Cancelled Aug 14, 1951 · Chicago, ILN79066Douglas C54G-DC · S/N 36052Cancelled Oct 25, 1948 · Washington, DCN5577Ford 4-AT-B · S/N 23Cancelled Mar 31, 1948 · Los Angeles, CAN702Grumman G-44 · S/N 1350Cancelled Mar 31, 1948 · Chicago, ILN90914Douglas C-54G · S/N 36007Cancelled Jun 12, 1947 · Washington, DCN19410Commonwealth REARWIN 6000M · S/N 306Cancelled Jan 1, 1942 · Built 1938 · None, OK
Back to United States Of America