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.
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
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.
N765MGDehavilland DHC-7-102 · S/N 65N875RSDouglas EA3B · S/N 144865N572HADouglas ERA-3B · S/N 144841N877RSDouglas NTA3B · S/N 144867N876RSDouglas NRA3B · S/N 142667N878RSDouglas NRA3B · S/N 144825N15YCMcdonnell Douglas YC-15 · S/N 72-01875N163TBDouglas ERA-3B · S/N 142668N215YCMcdonnell Douglas YC-15 · S/N 72-08176N66000Beech A200 · S/N BC-66N874RSDouglas EA3B · S/N 146454N162TBDouglas ERA-3B · S/N 144832N571HADouglas RA-3B · S/N 144843N573HADouglas ERA-3B · S/N 144838N870RSDouglas TA-3B · S/N 144856N879RSDouglas TA-3B · S/N 144858N208MDMcdonnell Douglas F/A 18C · S/N 165219N5382WDehavilland DHC-7-102 · S/N 95N547HADouglas ERA-3B · S/N 144846N208MDMcdonnell Douglas F/A 18C · S/N 164726N208MDMcdonnell Douglas F/A 18C · S/N 165208N23SHBell H13G · S/N 52-7797N19929Boeing B-17G · S/N 42-102642N309North American SNJ-4 · S/N 9742N1801Grumman G-44A · S/N 37738N277North American SNJ-4 · S/N 10167N291North American SNJ-4 · S/N 88-9401N246Waco SRE · S/N 5090N7Beech C18S · S/N 507N391Beech C18S · S/N 6025N348North American SNJ-4 · S/N 10267N73Beech 18S · S/N 364N133Beech D17S · S/N 415N18643Consolidatedvultee Acft 108 · S/N 42-63780N37194Douglas UNKNOWN DOUGLAS · S/N 42-107447N37719Douglas C-54 · S/N 42-107449N19936Consolidated C-87 · S/N 42-62787N18618Consolidated C-87 · S/N 43-30619N15558Consolidated B-24D · S/N 41-23721N18638Consolidated C-87 · S/N 43-30625N18639Douglas C-47 · S/N 4118492N19135Consolidated C-87 · S/N 43-30618N19136Consolidated C-87 · S/N 44-39212N19943Douglas C-47A · S/N 43-47971
Back to United States Government