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.
N214GBDouglas R4D-6 · S/N 26388N219GBDouglas DC3 · S/N 50761N4903JPiper PA-28R-180 · S/N 28R30621N9879WPiper PA-28-140 · S/N 28-23399N710BQBritish Aerospace HS 125-700A · S/N NA 0347N710BRBritish Aerospace HS 125-700A · S/N NA 0346N84762Antonov AN-2M · S/N 600810N718Cessna 180K · S/N 18052851N78Boeing 727-30 · S/N 18362N6749Grumman S-2D · S/N 148721N4577SBeech 58 · S/N TH-779N7033UBoeing 727 · S/N 18325N7035UBoeing 727 · S/N 18327N7034UBoeing 727-22 · S/N 18326N2457MPiper PA-23-250 · S/N 27-7954062N710BDBritish Aerospace HS 125-700A · S/N NA0330N2704ACessna 404 · S/N 404-0035N788CGrumman G-1159 · S/N 165N77112Douglas DC3C 1830-94 · S/N 25627N1095YHughes Helicopters HUGHES 369D · S/N 900784DN40180Douglas DC3C · S/N 25824N214FCDehavilland DHC-6-300 · S/N 727N53063Cessna A185F · S/N 18502351N33Douglas DC3C-S1C3G · S/N 26583N35Douglas DC3C 1830-94 · S/N 32794N7791Westland LYSANDERIIIA · S/N 1185N5RJPiper PA-32R-300 · S/N 32R-7880028N617Bell 206B · S/N 1879N780CCBell 206B · S/N 639N57038Rockwell International 500-S · S/N 3165N57039Aero Commander 500 S · S/N 3166N57283Aero Commander 500 S · S/N 3205N4999GNorth American T-39A · S/N 59-2869N1550British BAC 1-11 203/AE · S/N 044N5817Convair 340 · S/N 81N1321LCessna 337C · S/N 33701813N1341LCessna 337H · S/N 33701833N603KGreat Lakes 2T-1A · S/N 57N4765XCessna U206G · S/N U20605534N13Beech 65-80 · S/N LD-33N9Beech 65-80 · S/N LD-83N756QBCessna U206G · S/N U20604262N5441GCessna 404 · S/N 4040059N9054FHughes 369HE · S/N 1090206EN29824Nord 262-A · S/N 48N62427Douglas DC3 · S/N 50751N192XPilatus Porter PC-6/C-H2 · S/N 586N365FFairchild Heli-Porter PILATUS PC6/C-H2 · S/N 2022N366FFairchild Heli-Porter PILATUS PC6/C-H2 · S/N 2023N748NPilatus PC-6-H2 · S/N 539
Back to Washington, DC