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.
N49162Ryan Aeronautical ST3KR · S/N 2126N49214Consolidated Vultee BT-13A · S/N 2091N49269Ryan Aeronautical PT-22 · S/N 1449N49250Fairchild M-62A · S/N T41-854N34595Aeronca 65-CA · S/N 16381N22135Aeronca 50-C · S/N C-2369N23531Aeronca 65-C · S/N 4859N22544Stinson HW75 · S/N 7030N1043NCessna AT 17B · S/N 3087N1044NCessna T-50 · S/N 3193N1002NFairchild PT-26A · S/N FT-675N1041NCessna UC-78B · S/N 5528N49441Cessna T-50 · S/N 5067N27555Taylorcraft BL-65 · S/N 2197N218KArrow Aircraft & Motors ARROW SPORT · S/N 417N79KBird BK · S/N 2010-69N9150Fairchild 71 · S/N 635N1974Boeing B1E · S/N 1N5821Waco GXE · S/N 1508N835MBoeing 40-B-4 · S/N 1160N836MBoeing 40-B-4 · S/N 1161N49246Fairchild M-62A · S/N T42-1980N86614Grumman G-44A · S/N 1440N1362EAeronca 7AC · S/N 7AC-4923N85588Aeronca 7AC · S/N 7AC-4331N49439Cessna T-50 · S/N 6221N18585Beech E17B · S/N E17B-189N49282Consolidated Vultee BT-13A · S/N 6541N92909Commonwealth 185 · S/N 1640N49288Boeing PT-17 · S/N 75-1612N23519Aeronca 65-C · S/N C-4659N49129Interstate S-1B1 · S/N 227N34413Aeronca 65-CA · S/N CA14461N16446Beech C17L · S/N C17L-105N20818Piper J-3 · S/N 2118N41548Piper J3C-65 · S/N 8222N41549Piper J3C-65 · S/N 8203N602MFleet 7 · S/N 176N7824Monocoupe 113 · S/N 263N12413Aeronca C-3 · S/N A-179N6663AV Roe AVRO 594 AVIAN IV · S/N 169N13751Kinner SPORTSTER K · S/N A-1721N16482Arrow F · S/N 4N7755Bryon Carr Moore NB · S/N 23N19901Boeing S307 · S/N 1994N19784Aeronca KS · S/N K281N2734Lincoln Standard LINCOLN STANDARD · S/N A-1024N175MSavoia Marchetti S-55-P · S/N 10520N12740Vieweg Otto C O V 1 GLIDER · S/N 14-VN20KSavoia Marchetti S-55-P · S/N 10517
Back to Seattle, WA