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.
N8148CBell UH-1H · S/N 6308740N8149HBell UH-1H · S/N 6616942N8152QBell UH-1H · S/N 6413572N97033Fairchild C-123K · S/N 540658N81463Bell UH-1H · S/N 6616450N8149PBell UH-1H · S/N 6308785N8168TFairchild C-123K · S/N 54596N345MVShort Bros SHORTS SD3-60 · S/N SH3616N760FWBoeing 707-373C · S/N 19442N81342Hughes 269A · S/N 970717N82249Hughes 269A · S/N 1270746N8134YHughes 269A · S/N 180763N474FDassault/Sud FAN JET FALCON · S/N 467N19223Cessna 150L · S/N 15074250N944BCessna 500 · S/N 5000318N9583VCessna 172M · S/N 17264385N187ZSwearingen SA26-T · S/N T2629N522SCessna 310 · S/N 35522N414MXBritish Aerospace BAE JETSTREAM 3101 · S/N 699N31DWCessna TU206F · S/N U20602397N8159ZBell UH-1H · S/N 6717850N750FWBoeing 707-324C · S/N 19353N10564North American TB-25N · S/N 108-33162N9678NBell 205A-1 · S/N 30229N417MXBritish Aerospace BAE JETSTREAM 3101 · S/N 718N416MXBritish Aerospace BAE JETSTREAM 3101 · S/N 715N415MXBritish Aerospace BAE JETSTREAM 3101 · S/N 711N1269RBellanca 17-31ATC · S/N 31020N418MXBritish Aerospace BAE JETSTREAM 3101 · S/N 719N12581Cessna 172M · S/N 17262091N5802QMooney M20C · S/N 3110N320MJBoeing 707-321B · S/N 20028N4007QCessna 401 · S/N 4010107N7958DBeech H35 · S/N D5217N15941Grumman E-2C · S/N 158641N17115Grumman E-2C · S/N 160415N255ECCessna 337A · S/N 3370335N6504KBoeing 707-384C · S/N 20035N9205TLockheed L100-30 · S/N 4129N8163GBoeing 707-351C · S/N 18746N4635TEmeott 40 · S/N 1N7000YBoeing 707-344B · S/N 18891N7046ABoeing 727-46 · S/N 18877N6605RBeech B24R · S/N MC311N53601Frankfort TG-1A · S/N B239N72Farman SPORT · S/N 15N74401Bellanca 14-13-2 · S/N 1514N3823CAero Commander 560-E · S/N 746N749AVBritish Aerospace HS748 SERIES 2B · S/N 1790N9274FHughes 369HS · S/N 160781S
Back to Washington, DC