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.
N9855ZBeech C-45H · S/N AF113N9871ZBeech C-45H · S/N AF-624N70348Cessna A185F · S/N 18502123N7816MFairchild FH-227B · S/N 537N392RPilatus PC-6/A-H2 · S/N 530N5304FPilatus Porter PC-6/C-H2 · S/N 2049N645BBeech D18S · S/N A450N111JGFairchild Hiller FH-1100 · S/N 188N763Dehavilland BEAVER U-6 · S/N 266N27TCAero Commander 1121 · S/N 81N7808MFairchild FH-227 · S/N 522N58449Cessna 182P · S/N 18262071N916RConvair 580 · S/N 473N1934RRaven S-50A · S/N S50A140N5844Convair 340/440 · S/N 43N1196WBell 204-B · S/N 2036N9169ZBeech C-45H · S/N AF-675N152Lockheed TV-2 · S/N 128671N88790Douglas DC3C · S/N 4628N247Convair AT-29C · S/N 378N6132XAero Commander 680-F · S/N 680F-967-25N3471YCessna 180H · S/N 18051971N6740Grumman OV-1D · S/N 61-2699N6740Grumman OV-1C · S/N 60-3750N830QAero Commander 680-E · S/N 828-65N1374TDehavilland DHC-6 TWIN OTTER · S/N 142N5662Dehavilland DHC-6 TWIN OTTER · S/N 326N1001LLake LA-4A · S/N 244N51FWDehavilland DHC-6 TWIN OTTER · S/N 51N195XPilatus Porter PC-6/C-H2 · S/N 593N671GPBeech 99 · S/N U-86N722PABoeing 707-321 · S/N 17600N162GCessna 310D · S/N 39114N551GPBeech 99 · S/N U79N7927Grumman G-164A · S/N 813N3338Beech C18S · S/N 6940N921GPBeech 99 · S/N U-90N197XPilatus Porter PC-6/C-H2 · S/N 597N9445Pilatus PC-6/A-H2 · S/N 570N5832Convair 440 · S/N 384N249Convair AT-29C · S/N 336N161VDouglas DC3C · S/N 4644N6453Aerospatiale SE3160 ALOUETTE III · S/N 1834N6750Grumman S-2D · S/N 148730N6748Grumman S-2D · S/N 149230N6743Grumman OV-1C · S/N 60-3758N999QRyan NAVION A · S/N NAV-4-1722N74CLockheed 18-08 · S/N 2561N4292DBeech G35 · S/N D-4583N863GAGrumman G-1159 · S/N 23
Back to Washington, DC