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.
N200Douglas DC3C · S/N 20400N78332Aero Commander 500-B · S/N 500B-1217-101N6234XAero Commander 500-A · S/N 500A-1105-53N1013Helio H-395 · S/N 567N8747RHelio H-395 · S/N 525N6205XAero Commander 680-F · S/N 680F-1036-52N2764AStinson V77 · S/N 77-469N9440ZBeech C-45H · S/N 51-11517N6240XAero Commander 500-B · S/N 500B-1109-64N6267XAero Commander 680-F · S/N 680F-1171-90N4187DHelio H-395 · S/N 543N7840ECessna 150 · S/N 17640N6237XAero Commander 560-F · S/N 560F-1077-28N999GBeech A45 · S/N G-107N312AADouglas DC-7 · S/N 44133N179Beech C18S · S/N 7756N6241XAero Commander 500-B · S/N 500B-1110-65N2052ACurtiss Wright C-46 · S/N 117-1859N6189XAero Commander 680-F · S/N 680F-1063-60N6113XAero Commander 680-F · S/N 680F-942-13N88709Douglas DC-4 · S/N 18339N455Piper PA-18-150 · S/N 18-4106N6204XAero Commander 500-A · S/N 500A-1031-41N6188XAero Commander 680-F · S/N 680F-1019-48N6137XAero Commander 680-F · S/N 680F-1001-40N91730North American NAVION · S/N NAV-4-429N8406HConvair 240-1 · S/N 27N6186XAero Commander 680-F · S/N 680F-1005-43N2736ALockheed 49-46 · S/N 1977N6102XAero Commander 500-B · S/N 500B-923-8N83Lockheed F-80C · S/N 2493N84Lockheed F-80-C-10 · S/N 2115N492Douglas DC3 · S/N 1553N2738ALockheed 49-46 · S/N 2051N77Beech C18S · S/N 6335N1763CCessna 305A · S/N 51-12757N11136Convair 340 · S/N 136N1759CCessna L-19A · S/N 51-12739N1760CCessna L-19A · S/N 51-12740N1761CCessna L-19A · S/N 51-12746N1762CCessna L-19A · S/N 51-12753N147ADouglas DC3C-S1C3G · S/N 9175N497Douglas DC-3A-S1C3G · S/N 4811N67Beech C18S · S/N 5757N680EAero Commander 680-E · S/N 680E-743-37N96Martin RB57A · S/N 52-1438N122Grumman G-21A · S/N B-133N1311APiper PA-18A · S/N 18-1117N1782APiper PA-18A · S/N 18-1655N27656Taylorcraft BL-65 · S/N 2298
Back to Washington, DC