United States Government

Earlier aircraft under this name · 44

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

N765MGDehavilland DHC-7-102 · S/N 65Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Built 1982 · Fort Belvoir, VAN875RSDouglas EA3B · S/N 144865Cancelled Sep 8, 2017 · Registration expired, pending cancellation · Built 1960 · Van Nuys, CAN572HADouglas ERA-3B · S/N 144841Cancelled Jul 18, 2017 · Registration expired, pending cancellation · Van Nuys, CAN877RSDouglas NTA3B · S/N 144867Cancelled Jun 22, 2017 · Registration expired, pending cancellation · Built 1960 · Van Nuys, CAN876RSDouglas NRA3B · S/N 142667Cancelled Apr 18, 2017 · Registration expired, pending cancellation · Built 1960 · Van Nuys, CAN878RSDouglas NRA3B · S/N 144825Cancelled Apr 4, 2017 · Registration expired, pending cancellation · Built 1959 · Van Nuys, CAN15YCMcdonnell Douglas YC-15 · S/N 72-01875Cancelled Mar 10, 2017 · Registration expired, pending cancellation · Built 1972 · Long Beach, CAN163TBDouglas ERA-3B · S/N 142668Cancelled May 5, 2015 · Registration expired, pending cancellation · Van Nuys, CAN215YCMcdonnell Douglas YC-15 · S/N 72-08176Cancelled Nov 13, 2012 · Registration expired, pending cancellation · Long Beach, CAN66000Beech A200 · S/N BC-66Cancelled Aug 10, 2012 · Registration expired, pending cancellation · Bluemont, VAN874RSDouglas EA3B · S/N 146454Cancelled May 11, 2011 · Third renewal notice · Built 1960 · Van Nuys, CAN162TBDouglas ERA-3B · S/N 144832Cancelled May 10, 2011 · Triennial form not returned · Van Nuys, CAN571HADouglas RA-3B · S/N 144843Cancelled May 10, 2011 · Triennial form not returned · Van Nuys, CAN573HADouglas ERA-3B · S/N 144838Cancelled May 10, 2011 · Triennial form not returned · Van Nuys, CAN870RSDouglas TA-3B · S/N 144856Cancelled May 10, 2011 · Triennial form not returned · Van Nuys, CAN879RSDouglas TA-3B · S/N 144858Cancelled May 10, 2011 · First renewal notice · Built 1959 · Van Nuys, CAN208MDMcdonnell Douglas F/A 18C · S/N 165219Cancelled Mar 27, 2003 · Triennial form not returned · Hazelwood, MON5382WDehavilland DHC-7-102 · S/N 95Cancelled Dec 8, 1999 · Berryville, VAN547HADouglas ERA-3B · S/N 144846Cancelled Sep 16, 1998 · Triennial form not returned · Van Nuys, CAN208MDMcdonnell Douglas F/A 18C · S/N 164726Cancelled Dec 23, 1997 · Saint Louis, MON208MDMcdonnell Douglas F/A 18C · S/N 165208Cancelled Aug 28, 1997 · Saint Louis, MON23SHBell H13G · S/N 52-7797Cancelled May 17, 1976 · Detroit, MIN19929Boeing B-17G · S/N 42-102642Cancelled Sep 8, 1950 · Washington, DCN309North American SNJ-4 · S/N 9742Cancelled Jul 14, 1948 · Built 1942 · Washington, DCN1801Grumman G-44A · S/N 37738Cancelled Jun 3, 1948 · Built 1945 · Washington 25, DCN277North American SNJ-4 · S/N 10167Cancelled Apr 20, 1948 · Washington, DCN291North American SNJ-4 · S/N 88-9401Cancelled Apr 20, 1948 · Washington, DCN246Waco SRE · S/N 5090Cancelled Mar 4, 1948 · Built 1916 · Washington, DCN7Beech C18S · S/N 507Cancelled Mar 18, 1947 · Washington, DCN391Beech C18S · S/N 6025Cancelled Feb 7, 1947 · Washington, DCN348North American SNJ-4 · S/N 10267Cancelled Jan 28, 1947 · Washington, DCN73Beech 18S · S/N 364Cancelled Jan 28, 1947 · Washington, DCN133Beech D17S · S/N 415Cancelled Nov 7, 1946 · Built 1940 · Washington, DCN18643Consolidatedvultee Acft 108 · S/N 42-63780Cancelled May 9, 1945 · Washington, DCN37194Douglas UNKNOWN DOUGLAS · S/N 42-107447Cancelled Apr 15, 1945 · Washington, DCN37719Douglas C-54 · S/N 42-107449Cancelled Apr 13, 1945 · Washington, DCN19936Consolidated C-87 · S/N 42-62787Cancelled Feb 10, 1945 · Washington, DCN18618Consolidated C-87 · S/N 43-30619Cancelled Nov 7, 1944 · Washington, DCN15558Consolidated B-24D · S/N 41-23721Cancelled Oct 2, 1944N18638Consolidated C-87 · S/N 43-30625Cancellation date not recorded · Washington, DCN18639Douglas C-47 · S/N 4118492Cancellation date not recordedN19135Consolidated C-87 · S/N 43-30618Cancellation date not recorded · Built 1944 · Washington, DCN19136Consolidated C-87 · S/N 44-39212Cancellation date not recorded · Built 1944 · Washington, DCN19943Douglas C-47A · S/N 43-47971Cancellation date not recorded · Washington, DC
Back to United States Government