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.

N2486NCessna 140 · S/N 12739Cancelled Feb 24, 1953 · Boyd StephenN2656NCessna 140 · S/N 12914Cancelled Jan 27, 1953 · Exported to Canada · Reverman Henry JN3882KTemco GC-1B · S/N 3582Cancelled Dec 29, 1952 · Airflight IncN1190HAeronca 15AC · S/N 15AC-201Cancelled Dec 16, 1952 · Exported to Canada · Built 1948 · Pierce Monte K DBA The Sky HarborN4815HPiper PA-17 · S/N 17-113Cancelled Oct 16, 1952 · Galvin Flying ServiceN1362HAeronca 15AC · S/N 15AC-409Cancelled Jul 15, 1952 · Exported to Canada · Mccracken B LN4017NCessna 120 · S/N 13475Cancelled Jun 2, 1952 · Bovee Electric CompanyN9690HHoward DGA-15P · S/N 820Cancelled Apr 24, 1952 · Rueschenberg H BN2262VCessna 140 · S/N 14493Cancelled Apr 8, 1952 · Exported to Canada · Perry G W Or Perry ElizabethN89585Cessna 140 · S/N 8628Cancelled Mar 7, 1952 · Lee John HN1007NFairchild M-62A-3 · S/N FT 806Cancelled Jan 22, 1952 · Theodore P HinckelN73434Consolidated Vultee BT-13A · S/N 7570Cancelled Jan 3, 1952 · Downs J AN38937Beech SC17R · S/N 120Cancelled Jan 2, 1952 · Exported to Canada · Built 1937 · Hubbard Alfred MatthewN9012ACessna 170A · S/N 18767Cancelled Dec 13, 1951 · Aero ServiceN6311KRepublic RC-3 · S/N 532Cancelled Nov 19, 1951 · J M Gauntlett Co IncN78011Globe GC-1B · S/N 2011Cancelled Nov 16, 1951 · A S HopkinsN4530MPiper PA-11 · S/N 11-34Cancelled Nov 2, 1951 · Built 1947 · Calvin Flying ServiceN1184NFairchild M-62A-3 · S/N FV130Cancelled Sep 7, 1951 · Built 1942 · Hinckel Theodore PN9185ACessna 170A · S/N 18946Cancelled Jul 27, 1951 · Exported to Canada · Washington Aircraft & Transport CorpN2601KLuscombe 8A · S/N 5328Cancelled Jul 12, 1951 · Shupe Cecil ON1186NConsolidated Vultee BT-15 · S/N 11528Cancelled Jun 6, 1951 · Built 1942 · Crane Glen PN1470HAeronca 15AC · S/N 15AC-540Cancelled Jun 1, 1951 · Exported to Canada · Aeronca Manufacturing CorpN80837Globe GC-1A · S/N 240Cancelled May 21, 1951 · A S HopkinsN85694Aeronca S7AC · S/N 7AC-4440Cancelled Apr 5, 1951 · Kayler-Dahl Fish Co IncN32224Stinson 10A · S/N 7952Cancelled Mar 29, 1951 · Kurtzer Flying ServiceN48594Boeing PT-27 · S/N 75-3785Cancelled Mar 29, 1951 · Hartley Max ElmoN49283Fairchild M-62A · S/N T40-371Cancelled Feb 28, 1951 · Boeck Ivan EN72380Cessna 120 · S/N 9566Cancelled Feb 27, 1951 · Caapers IncN9195KStinson 108-1 · S/N 108-2195Cancelled Feb 20, 1951 · Harry F BoveeN1023NFairchild M-62A-3 · S/N T-42-4012Cancelled Feb 1, 1951 · Harold WatsonN4557VBeech 35 · S/N D-1386Cancelled Feb 1, 1951 · Built 1948 · Chas L Dick CoN49440Cessna T-50 · S/N 5407Cancelled Jan 26, 1951 · Witters Max JN1182NFairchild M-62A-3 · S/N FZ218Cancelled Dec 12, 1950 · Built 1943 · Hinckel Theodore PN1248NCurtiss Wright C-46F · S/N 22496Cancelled Jun 7, 1950 · Built 1945 · Usaf Of National Defense EstablishmentN76442Cessna 120 · S/N 10874Cancelled Mar 29, 1950 · Caspers IncN8147Cessna AW · S/N 162Cancelled Feb 20, 1950 · Arthur Howard WarrenN1198HAeronca 15AC · S/N 15AC-211Cancelled Jan 30, 1950 · Built 1948 · Macpherson Murdock DN49054Taylorcraft DCO-65 · S/N L-4931Cancelled Oct 14, 1949 · DavidsonN49164Aeronca L-3C · S/N 5132Cancelled Jun 16, 1949 · Martin L RN3762EAeronca 7AC · S/N 7AC-7050Cancelled Jun 9, 1949 · Built 1947 · Aero-Marine Service IncN1004NFairchild M-62A-3 · S/N FT818Cancelled Jun 7, 1949 · Buy-PlaneN3865KTemco GC-1B · S/N 3565Cancelled Jun 7, 1949 · Rutherford A HN49316North American AT-6A · S/N 77-4646Cancelled Jun 6, 1949 · Exported to Pakistan · Stickney WarrenN6528KRepublic RC-3 · S/N 794Cancelled May 31, 1949 · Palmer Kenneth RN86583Douglas DC-3A-S1C3G · S/N 19411Cancelled Mar 25, 1949 · Exported to Venezuela · Great Circle Aviation CorpN80763Globe GC-1A · S/N 166Cancelled Mar 22, 1949 · Yancey Richard BN28406Luscombe 8A · S/N 1273Cancelled Mar 9, 1949 · Pickel John DN79025Douglas DC3C-S1C3G · S/N 10181Cancelled Mar 7, 1949 · Leland William FN49267Fairchild M-62A · S/N T40-354Cancelled Feb 3, 1949 · Ridley Florence PN49280Cessna T-50 · S/N 5434Cancelled Feb 3, 1949 · Green Walter
Back to Seattle, WA