Washington, DC
Cancelled registrations · 1,453
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_state = 'DC' AND d.registrant_city = 'WASHINGTON' 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_state = 'DC' AND d.registrant_city = 'WASHINGTON' 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.
N103Grumman JRF-5 · S/N B-110N90641North American AT-6A · S/N 77-4480N79028Douglas C-47 · S/N 20182N36751Stinson 10A · S/N 8151N16563Aeronca C-3 · S/N A-702N1419DCessna 170A · S/N 20132N1761DCessna 170A · S/N 20204N9582HNorth American SNJ-4 · S/N 88-12132N80469North American AT-6 · S/N 88-9428N9574HNorth American SNJ-4 · S/N 88-11515N9576HNorth American SNJ-4 · S/N 88-11921N47793Lockheed 18-56 · S/N 18-2520N60533Cessna T-50 · S/N 1581N3937CDouglas C-47A · S/N 13295N37769Porterfield FP-65 · S/N 978N777ECessna T-50 · S/N 5967N86229Aeronca 11AC · S/N 11AC-33N39416Stinson 10A · S/N 8216N1411Fairchild PT-26A · S/N FW-889N50092Curtiss Wright C-46A · S/N 26515N3933CDouglas DC3C-S1C3G · S/N 4763N93299Dehavilland BEAVER DHC-2 · S/N 63N555Fairchild UC-61A · S/N 41-38851N154BBell 47D · S/N 8N55438Noorduyn UC-64A · S/N 244N113Cessna C-165 · S/N 484N338North American SNJ-4 · S/N 11231N66Beech C18S · S/N 8052N68Beech C18S · S/N 5659N700Cessna T-50 · S/N 3933N72Beech C18S · S/N 5755N8543HNorth American NAVION · S/N NAV-4-548N9190HStinson VULTEE V-77 · S/N 77-180N219Beech C18S · S/N 6063N9299ACessna 170A · S/N 19060N19Beech C18S · S/N 6263N19929Boeing B-17G · S/N 42-102642N821Cessna T-50 · S/N 5825N173HWhite NEW STANDARD D-25 · S/N 128N49542Douglas C-53 · S/N 4947N13353Douglas DC3 · S/N 11634N48596Cessna T-50 · S/N 2128N14675Aeronca C-3 · S/N 561N75640Republic P-47 · S/N 393-353N91009Douglas C54A-DC · S/N 7453N9990HBell P63E · S/N 33-14N4261HPiper PA-14 · S/N 14-65N2964HEngineering & Research ERCOUPE 415-C · S/N 3589N56Beech C18S · S/N 5678N15875Porterfield 35-70 · S/N 175
Back to Washington, DC