King Salmon, AK

Cancelled registrations · 39

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 = 'AK' AND d.registrant_city = 'KING SALMON'
  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.

N8843DPiper PA-22-160 · S/N 22-6013Cancelled Jan 14, 2023 · Sale reported, canceled · Built 1958N3562ZPiper PA-22-160 · S/N 22-7476Cancelled Oct 3, 2020 · Registration expired, pending cancellation · Built 1960 · Lake Nornek Aviation LLCN6335XCessna 172RG · S/N 172RG0631Cancelled Apr 3, 2020 · Registration expired, pending cancellation · Built 1980 · Tundra Wolf LLCN40853Piper J3F-65 · S/N 7568Cancelled Jul 26, 2019 · Registration expired, pending cancellation · Built 1941 · Scord Richard MN5840ZPiper PA-22-108 · S/N 22-9694Cancelled Apr 30, 2019 · Registration expired, pending cancellation · Built 1963 · Briggs Roland BN5340DCessna 172N · S/N 17272529Cancelled Dec 27, 2018 · Registration expired, pending cancellation · Built 1979 · Arctic Winds IncN5965HPiper PA-16 · S/N 16-594Cancelled Jan 25, 2018 · Registration expired, pending cancellation · Built 1949 · Lobo Jason EN345TVBell 206B · S/N 2483Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Egli Air Haul IncN7151ECessna 182B · S/N 52151Cancelled Oct 31, 2017 · Registration expired, pending cancellation · Built 1959 · Babiak Robert AN7096KPiper PA-20 · S/N 20-203Cancelled Jul 20, 2017 · Registration expired, pending cancellation · Built 1950 · Jeknavorian RafiN1712PPiper PA-22-150 · S/N 22-2502Cancelled Feb 22, 2017 · Registration expired, pending cancellation · Built 1954 · Angasan Ralph SrN3176EAeronca 11AC · S/N 11AC-1516Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1946 · Lindenberg Gregory WN83625Aeronca 7AC · S/N 7AC-2303Cancelled Sep 11, 2013 · Registration expired, pending cancellation · Built 1946 · Flerchinger ZekeN5369BCessna 182 · S/N 33369Cancelled Aug 15, 2013 · Registration expired, pending cancellation · Built 1956 · Alaskan Peninsula OutfittersN9835MMaule M-4-210C · S/N 1018CCancelled Mar 7, 2013 · Registration expired, pending cancellation · Built 1966 · Sherman Ronald DN3746FCessna 172H · S/N 17255241Cancelled Nov 9, 2012 · Registration expired, pending cancellation · Built 1966 · Knopp Steven LN7345NCessna TU206G · S/N U20603623Cancelled Oct 16, 2012 · Sale reported, pending cancellationN2737BSemco Balloon TC-4 · S/N SEM15Cancelled Sep 21, 2012 · Registration expired, pending cancellation · Built 1968 · Tundra Wolf IncN44382Taylorcraft BC12-D1 · S/N 10182Cancelled Jul 9, 2012 · Revoked, canceled · Built 1946 · Gottsbhalk GeorgeN9376HBeech D17S · S/N 2685Cancelled Sep 17, 2009 · Registration revoked · Built 1941 · Pinette William SN15843Beech C17B · S/N 86Cancelled Jun 30, 2009 · Registration revoked · Built 1936 · Pinette William SN4074RPiper PA-32-300 · S/N 32-40386Cancelled May 18, 2009 · Registration revoked · Built 1968 · Peninsula Airways IncN1510APiper PA-20 · S/N 20-698Cancelled Dec 19, 2001 · Registration revoked · Built 1951 · Baker DavidN735ERCessna U206G · S/N U20604909Cancelled Jan 26, 1999 · Exported to Mexico · Mercury Aircraft Sales IncN46560Cessna 172M · S/N 17264187Cancelled Nov 5, 1997 · Exported to Philippines · Mercury Aircraft Sales IncN5062Grumman G-164A · S/N 1106Cancelled Nov 5, 1997 · Exported to Philippines · Mercury Aircraft Sales IncN3155XCessna 207 · S/N 20700215Cancelled Nov 13, 1996 · Exported to Philippines · Mercury Aircraft Sales IncN123TAPiper PA-32-300 · S/N 327940120Cancelled Jul 18, 1994 · Triennial form not returned · Peninsula Airways IncN74965Piper PA-31-350 · S/N 31-7305114Cancelled May 17, 1994 · Peninsula Airways IncN2585MPiper PA-32-300 · S/N 327840050Cancelled Mar 16, 1994 · Triennial form not returned · Peninsula Airways IncN5206SPiper PA-32-300 · S/N 3240895Cancelled Mar 5, 1993 · Triennial form not returned · Peninsula Airways IncN37611Taylorcraft BC-65 · S/N 2050Cancelled Feb 26, 1993 · Triennial form not returned · Roberson Terri AN9781GCessna 180H · S/N 18052281Cancelled Jan 14, 1982 · Administratively canceled · Edwards Richard AN2913ZPiper PA-22-150 · S/N 22-6883Cancelled Sep 29, 1971 · Peter LindN67829Cessna T-50 · S/N 3613Cancelled Sep 24, 1970 · Jensen Richard HN148MGrumman G-44 · S/N 1220Cancelled Jun 23, 1970 · Built 1941 · Peninsula Airways IncN6432HPiper J3C-65 · S/N 19609Cancelled Jun 3, 1965 · Katmai Flying ClubN3328MPiper PA-12 · S/N 12-2188Cancelled May 22, 1965 · Jack GottschalkN92281Piper J3C-65 · S/N 16742Cancelled May 12, 1961 · Chatlain Phillip
Back to King Salmon, AK