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.
N154Lockheed TV-2 · S/N 128719N314ADouglas DC-7 · S/N 44135N6343UAero Commander 680FL · S/N 1379-48N61380Cessna T-50 · S/N 5409N73Douglas DC3 · S/N 33206N44Douglas DC3C · S/N 25775N6300UAero Commander 500-B · S/N 1378-136N90702Douglas DC-6 · S/N 42855N74Douglas DC3C-S1C3G · S/N 26733N30BPiper PA-12 · S/N 12-89N91261Douglas C-47A · S/N 19495N174AMartin 202 · S/N 9159N4788CDouglas DC3C · S/N 34325N4137DHelio H-395 · S/N 087N4143DHelio H-395 · S/N 075N7507SHelio H-395 · S/N 507N2801VBeech 35 · S/N D-197N59Beech C18S · S/N 6799N68Beech C18S · S/N 4321N6346UAero Commander 680FL · S/N 1437-75N84740Aeronca 7AC · S/N 7AC-3452N7410Vickers VISCOUNT 745 · S/N 108N71Douglas DC3C-S1C3G · S/N 9005N177AMartin 202 · S/N 9147N3846SCessna 172E · S/N 17251046N3853SCessna 172E · S/N 17251053N3861SCessna 172E · S/N 17251061N3869SCessna 172E · S/N 17251069N6310UAero Commander 680-F · S/N 1358-138N3784UCessna 182 · S/N 18255184N1003Beech UC-45F · S/N 43-35919N612Kaman H-43A · S/N 58-1837N160Douglas C-47A · S/N 20424N6347UAero Commander 680-F · S/N 1369N322ADouglas DC-7 · S/N 44143N162Douglas C-47A · S/N 20016N161Douglas C-47A · S/N 19754N90407Douglas DC-4 · S/N 3071N90423Douglas DC-4 · S/N 18392N78339Aero Commander 560-F · S/N 560F-1194-44N90910Douglas C-54G · S/N 35984N78354Aero Commander 680FL · S/N 1351-30N4190DHelio H-395 · S/N 545N86555Douglas DC-4 · S/N 3062N6128XAero Commander 560-F · S/N 560F-978-5N4191DHelio H-395 · S/N 546N78392Aero Commander 500-A · S/N 1267N97Martin RB57A · S/N AF52-1447N440EConvair 440 · S/N 445N116ALockheed 749A-79 · S/N 2611
Back to Washington, DC