Seattle, WA
Cancelled registrations · 1,563
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 = 'WA' AND d.registrant_city = 'SEATTLE' 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 = 'WA' AND d.registrant_city = 'SEATTLE' 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.
N740RWBoeing 727-2M7 · S/N 21824N7435UBoeing 727-22C · S/N 19892N7438UBoeing 727-22C · S/N 19895N124ASBoeing 727-81 · S/N 18821N757GRCessna 152 · S/N 15279733N6829JPiper PA-32R-300 · S/N 32R-7680359N6990QBeech B23 · S/N M-1097N7436UBoeing 727-22C · S/N 19893N733LCCessna 172N · S/N 17268366N316PABoeing 727-21 · S/N 18994N318ASBoeing 727-21 · S/N 18996N5148QCessna T210L · S/N 21059648N3559SCessna 172F · S/N 17250759N3814MPiper PA-12 · S/N 12-2735N3033XCessna 150F · S/N 15064433N1293EBoeing 727-2T3 · S/N 1293EN19527Cessna 150L · S/N 15074472N1718Schleicher KA 6 E · S/N 4075N303ASBoeing 720-048 · S/N 18042N1027VCessna U206F · S/N U20602407N15186Sikorsky S-55B · S/N 130156N70405Cessna 172M · S/N 17267214N4193NCessna 140 · S/N 13664N8796FHughes 269A · S/N 0131N8730BBoeing YC-14 · S/N 0001N8740Boeing YC-14 · S/N 0002N19QBPiper PA-31 · S/N 31-378N8981BCessna 172 · S/N 36681N80713Cessna 172M · S/N 17266711N7221GCessna 172K · S/N 17258921N73741Cessna 172N · S/N 17267640N51424Maule M-4-210C · S/N 1094CN6591RBeech B24R · S/N MC-291N5452MSwearingen SA226TC · S/N TC250N48054Boeing 727-2K3 · S/N 21082N26060Liddington VANECK · S/N 1N8005UDouglas DC-8-21 · S/N 45282N78597Cessna 172K · S/N 17257679N302ASBoeing 720-062 · S/N 18377N78MLBellanca 8KCAB · S/N 63-73N1282SCessna 182P · S/N 18264850N2087QCessna 177RG · S/N 177RG 0487N40102Boeing 720-025 · S/N 18158N1511HHelton LARK 95 · S/N 9511N72700Boeing 727-22 · S/N 18464N1428WBell 206A · S/N 352N90581Beech UC-45J · S/N 90581N1243EBoeing 737-268 · S/N 21283N1236EBoeing 727-2D6 · S/N 21284N40124Boeing 727-276 · S/N 21171
Back to Seattle, WA