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.
N83VLockheed 18-56 · S/N 2179N3414Convair 340-32 · S/N 45N91284Beech C-45H · S/N AF-439N406EConvair 240-27 · S/N 310N5466EHelio H-250 · S/N 2522N4579EAero Commander 500-U · S/N 1662-14N4580EAero Commander 500-U · S/N 1664-15N6526VAero Commander 500-U · S/N 1666-16N3173LCessna 310J · S/N 310J0173N45846Curtiss Wright C-46F · S/N 44-78562N6535VAero Commander 680FL · S/N 1595-113N8622PPiper PA-24-400 · S/N 26145N6117ECessna 172 · S/N 46217N5005XFairchild C-123B · S/N 20206N5006XFairchild C-123B · S/N 20237N9856FPiper PA-18A 150 · S/N 18-7043N52Douglas DC-3A-S1C3G · S/N 20419N8038ACessna 170B · S/N 20890N4732SDouglas C-47A · S/N 101033N3158ZPiper PA-22-150 · S/N 22-7105N6391UAero Commander 680FL · S/N 1464-88N38222Piper J3L-65 · S/N 6873N5003XFairchild C-123B · S/N 20234N2080AStinson OY-2 · S/N 03932N4975VStinson L-5 · S/N 2028N5174NPiper J-3C · S/N 9748N69Douglas DC3C · S/N 26593N466Convair C-131B · S/N 274N6255BAero Commander 680-E · S/N 680E-708-21N6378UAero Commander 680FL · S/N 1517-98N9933ZBeech C-45H · S/N AF490N1157ZAero Commander 680FL · S/N 1529-103N6311UAero Commander 680FL · S/N 1334-19N6389UAero Commander 680FL · S/N 1451-80N999NRyan NAVION A · S/N NAV4-1701N1218MBoeing E75 (PT-13D) · S/N 75-5387N2072AStinson OY-2 · S/N 03983N2091AStinson L-5G · S/N 04004N3939AStinson L-5G · S/N 45-35018AN5175NPiper J-3C · S/N 13914N6393UAero Commander 680FL · S/N 1511-95N88350Piper J3C-65 · S/N 15968N16151Stinson SR-8E · S/N 9722N6209XAero Commander 500-A · S/N 500A-1049-44N6220XAero Commander 500-B · S/N 500B-1082-53N4955BBeech D-50 · S/N DH-2N9367RAero Commander 560-E · S/N 884N9776XCessna 210B · S/N 210-58076N1016LLake LA-4 · S/N 259N122GBeech C-45H · S/N 52-10640
Back to Washington, DC