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.
N9282CCessna 180 · S/N 31381N8491CAero Commander 500 · S/N 832-500N79Beech C18S · S/N 8066N8481CAero Commander 560-E · S/N 830N704Piper PA-20 · S/N 50331N74Beech C18S · S/N 6173N45XPiper J3C-65 · S/N 13189N9939BCessna 182A · S/N 34339N720Grumman G-21A · S/N B-144N9515CCurtiss Wright C-46/CW20-T · S/N 147N67Beech C18S · S/N 6057N6299BAero Commander 680 · S/N 680-614-244N2750ADouglas DC-4 · S/N 10736N3784VCessna 140A · S/N 15205N39902Taylorcraft BC12-D · S/N 6555N68578Douglas C-54B · S/N 10511N58690Noorduyn UC-64A · S/N 636N6226DAero Commander 680 · S/N 680-494-164N2087ADouglas DC-3C-R-1830-92 · S/N 6349N2734BAero Commander 560-A · S/N 402N6838SAero Commander 680 · S/N 680-445-116N10489Graichen Ralph R G-A · S/N 1N90441Douglas C54A-DC · S/N 10348N850BMooney M20 · S/N 1010N4965BBeech D-50 · S/N DH-18N1559VDehavilland DH-104 · S/N 04389N80871Globe GC-1A · S/N 274N2642BAero Commander 560-A · S/N 680-310N44976Naval Aircraft Factory N3N-3 · S/N 2711N40RNorth American NAVION A · S/N NAV-4-919N65908North American SNJ-3 · S/N 78-6788N60731Consolidated Vultee BT-13B (SNV-2) · S/N 79-1663N91023Fairchild M-62A-3 · S/N FV-459N85714Aeronca 7AC · S/N 7AC-4461N18588Noorduyn UC-64A · S/N 638N37009Luscombe 8B · S/N 1670N65116Consolidated Vultee BT-13A · S/N 2450N227Stinson L-5G · S/N 76-3614N51540Piper J3C-65 · S/N 10497N46460Aeronca 0-58B · S/N 058B-8803N46648Aeronca 0-58B · S/N 058B-1992N46880Cessna T-50 · S/N 6577N49840Douglas DC3 · S/N 6006N62321Consolidated Vultee BT-13A · S/N 11120N92718Piper PA-12 · S/N 12-154N41604Culver LFA · S/N 363N47781Piper J3L-65 · S/N 115N50062Paulistinha CAP-4 · S/N 376N19336Aeronca K · S/N K-204N3821KGlobe GC-1B · S/N 3510
Back to Washington, DC