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.
N48355Nowak WHING DING II · S/N 9N4282KRyan NAVION · S/N NAV-4-1282N9533FHughes 269B · S/N 680372N4133LCessna 172G · S/N 17254202N48035Fairchild M-62A · S/N T423703N3772NBeech 35 · S/N D-993N4520UCessna 150D · S/N 15060520N425QXBombardier DHC-8-402 · S/N 4039N985TKBoeing 737-9F2ER · S/N 40985N39502Bell UH-1B · S/N 63-8554N493GWCessna 172S · S/N 172S9493N963SSBoeing 737-7ES · S/N 35329N3VWOtey KR-1 · S/N 74-1N984TKBoeing 737-9F2ER · S/N 40984N12PELundgren KR-2 · S/N 969N6674JPiper PA-28-140 · S/N 28-24360N2117VPiper PA-34-200T · S/N 34-7970160N300EZFoy-John VARI-EZE · S/N 300N279ASPilatus B4-PC11AF · S/N 261N1039NFairchild PT-26A · S/N FW922N3990GGoode Robert D EVANS VP-2 · S/N V2-1263N5038NAirborne EDGE X · S/N 503-529N5010Briegleb BG-12BD · S/N RH-1N16RTThrasher Robert W MONERAI · S/N 114N67185Cessna T-50 · S/N 5556N67450Cessna T-50 · S/N 5437N2683JCessna 150G · S/N 15065683N54699Raven S-50A · S/N S50A-249N64MLCessna 172RG · S/N 172RG0081N2540BConsolidated Vultee/Hops L-13A · S/N 47-371N701PFFried Phillip A ZENITH 701 · S/N 7-7511N2258QPiper PA-28-161 · S/N 28-7716092N231DPPiccard AX-6 · S/N 795N5017ZPiper PA-22-108 · S/N 22-8632N51117Cessna T-50 · S/N 5100N9182FBeech E50 · S/N 58-3057N95DCBeech V35A · S/N D-8615N48DPPiccard AX-6 · S/N 769N1524CBalloon Works FIREFLY 8-24 · S/N 10307N4635UCessna 180G · S/N 18051335N6159KBink Andrew BEDE 5 · S/N 2963N1695PPiper PA-22-150 · S/N 22-2481N27MSMelvill VARIVIGGEN · S/N 115N16712Bell 206B · S/N 2181N981TKBoeing 737-9F2ER · S/N 40979N516DSBoeing 737-8FV · S/N 40812N978TKBoeing 737-9F2ER · S/N 40978N53408Cessna 172P · S/N 17274746N1231Aero Commander 680 · S/N 680-534-203N133TTBrundage SCORPION 133 · S/N 2570
Back to Seattle, WA