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.
N5247FCessna 172F · S/N 17253342N5248FCessna 172F · S/N 17253344N5266FCessna 172F · S/N 17253388N7118ABeech S35 · S/N D-7440N4983VAeronca 7BCM · S/N 7BCM-179N3241WPiper PA-32-260 · S/N 32-55N5802Convair CV-440-79 · S/N 410N5825Convair 440 · S/N 386N988VJDouglas DC-9-31 · S/N 47211N46340Fairchild 24W-40 · S/N W-40-122N3143DCessna 180 · S/N 31941N245Convair AT-29C · S/N 337N800WDouglas B-26C · S/N 44-35725N4225JPiper PA-28-140 · S/N 28-22574N6093EBeech K35 · S/N D-6090N3639CCessna 180 · S/N 31137N6158XAero Commander 680-F · S/N 680-973-30N137LBeech C-45 · S/N AF-114N1386NCurtiss Wright C-46D · S/N 22265N193XPilatus Porter PC-6/C-H2 · S/N 587N196XPilatus Porter PC-6/C-H2 · S/N 596N343TBeech C-45H · S/N AF-836N91239Convair 240-13 · S/N 159N6326VHelio H-250 · S/N 2539N4939EAero Commander 500-U · S/N 1706-24N2762JCessna A185E · S/N 185-1512N2763JCessna A185E · S/N 185-1513N81Douglas C-54G · S/N 35941N3656DCessna 310 · S/N 35356N246Convair ET-29C · S/N 364N121Lockheed 749A-79 · S/N 2654N4794QCessna A185E · S/N 185-1263N8415HConvair 340 · S/N 125N2703JFairchild F-27J · S/N 114N2702JFairchild F-27J · S/N 113N478AMartin 404 · S/N 14226N51161Lockheed 18 · S/N 2624N1866CDouglas DC-4 · S/N 10816N12235Pilatus PC-6/A-H2 · S/N 556N7951CBeech C-45G · S/N AF-37 (51-11480)N4855EAero Commander 680FL P · S/N 1661-34N9475ZBeech C-45H · S/N AF634N6313UAero Commander 680FL · S/N 1365-39N84Douglas C54-D · S/N 10794N5348SCessna 337A · S/N 337-0448N5360SCessna 337A · S/N 337-0460N5392SCessna 337A · S/N 337-0492N5405SCessna 337A · S/N 337-0505N303MWBeech D18S · S/N A-587N700Hughes 269B · S/N 0209
Back to Washington, DC