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.
N9577ZBeech C-45H · S/N 51-11622N185KPilatus Porter PC-6/C-H2 · S/N 563N358FFairchild Heli-Porter PILATUS PC6/C-H2 · S/N 2016N359FFairchild Heli-Porter PILATUS PC6/C-H2 · S/N 2017N8354QCessna TU206F · S/N U20603215N229XGates Learjet 35A · S/N 35129N2295VNorth American T-39A · S/N 592868N501ASDassault/Sud FAN JET FALCON SER F · S/N 262N9521ZBeech D18S · S/N AF-99N5826Convair 440 · S/N 385N2957FBell 204 · S/N 654N710UFairchild FH-227B · S/N 554N708UFairchild FH-227B · S/N 549N5822Convair 340 · S/N 141N709UFairchild FH-227B · S/N 552N3934GCessna U206C · S/N U206-0934N48333Cessna 337 · S/N 337M00101N1811Lockheed 18-56 · S/N 2131N705UFairchild FH-227B · S/N 545N45Douglas DC3C 1830-94 · S/N 33322N70720Boeing 737-2E1 · S/N 21112N367FFairchild Heli-Porter PILATUS PC6/C-H2 · S/N 2024N12450Pilatus Porter PC-6/C-H2 · S/N 514N90TFBritish BAC 1-11 401/AK · S/N BAC 080N994VJDouglas DC-9-31 · S/N 47333N198XPilatus Porter PC-6/C-H2 · S/N 600N24MPBell 47G-3B-1 · S/N 3820N716HHBoeing 707-321 · S/N 17594N1305XBell 204-B · S/N 2197N1307XBell 204-B · S/N 2199N5838Convair 340 · S/N 147N7695CBeech C-45G · S/N AF357N9956ZBeech C-45H · S/N AF-704N501TLVickers VISCOUNT 810 · S/N 353N57101Rockwell Commander 690A · S/N 11101N8433QCessna U206F · S/N U20603292N8359QCessna U206F · S/N U20603220N6154UBeech C-45H · S/N AF509N6742Grumman S-2D · S/N 149237N921XBeech 65 · S/N L-6N617ACAerospatiale SN-601 CORVETTE · S/N 22N618ACAerospatiale SN-601 CORVETTE · S/N 26N614ACAerospatiale SN-601 CORVETTE · S/N 17N616ACAerospatiale SN-601 CORVETTE · S/N 20N6868Dehavilland DHC-6 TWIN OTTER · S/N 235N611ACAerospatiale SN-601 CORVETTE · S/N 7N612ACAerospatiale SN-601 CORVETTE · S/N 9N613ACAerospatiale SN-601 CORVETTE · S/N 11N9267ZBell 206A · S/N 697N7823MFairchild FH-227B · S/N 563
Back to Washington, DC