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.
N2179CCessna 195B · S/N 16164N40120Boeing 737-268 · S/N 21282N40112Boeing 737-284 · S/N 21302N73WJGrumman G-164 · S/N 9N6224GCessna 150K · S/N 15071724N982SCCessna 185B · S/N 185-0586N16768Boeing 727-30 · S/N 18363N61956Cessna 172M · S/N 17264913N12427Beech D-45 (T-34B) · S/N BG-356N772ESikorsky S-55 · S/N 52-7501N85TABell 206B · S/N 1606N26981Weaver BD-5B · S/N 2874N4034Scheibe SF-24B MOTORSPATZ · S/N 4034N20822Cessna 172M · S/N 17263847N1451ZBoeing 737-281 · S/N 20226N1238EBoeing 737-2N8 · S/N 21296N604XSikorsky S-55B · S/N 55459N7478ECessna 210 · S/N 57178N97135Stinson 108 · S/N 108-135N46479Cessna 172K · S/N 17257294N2614HErcoupe 415-C · S/N 3239N3437APiper PA-22 · S/N 22-1709N9290LAmerican AA-1A · S/N AA1A0190N6286GCessna 150K · S/N 15071786N11383Cessna 150L · S/N 15075372N9702CLockheed 188A · S/N 188A-1052N23419Cessna 150H · S/N 15068937N87569Boeing 737-241 · S/N 21006N1035Stits SA6B FLUT-R-BUG · S/N P-2106N1507WBoeing 707-347C · S/N 20316N1508WBoeing 707-347C · S/N 20317N1509WBoeing 707-347C · S/N 20318N1510WBoeing 707-347C · S/N 20319N94624Ercoupe 415-CD · S/N 4725N7212DPiper PA-22-150 · S/N 22-5036N7251DPiper PA-22-150 · S/N 22-5077N68654Sorrell John JA-3-80 · S/N 1N8396UCessna 172F · S/N 17252296N2378XCessna 182H · S/N 18256278N35369Cessna 172G · S/N 17256737N7743YPiper PA-30 · S/N 30-834N5534TCessna 172E · S/N 17251434N6772GCessna 150L · S/N 15072272N6327VHelio H-295 · S/N 1401N3638EAeronca 11AC · S/N 11AC-1832N4649LCessna 172G · S/N 17254644N77437Cessna 120 · S/N 11879N4291RPiper PA-32-300 · S/N 32-40668N5771LAmerican AA-1 · S/N AA1-0171N5861GCessna 150K · S/N 15071361
Back to Seattle, WA