OpenAirDocs.org
Port Alsworth, AK

Cancelled registrations · 40

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 = 'PORT ALSWORTH'
  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.

N863LPAeronca 11AC · S/N 11AC-158Cancelled Dec 3, 2022 · Registration expired, pending cancellation · Built 1946 · Lorentzen John RN2803BPiper PA-18A 150 · S/N 18-5068Cancelled Oct 1, 2022 · Registration expired, pending cancellation · Cavner And Julian IncN3780DCessna 182A · S/N 34480Cancelled Oct 1, 2022 · Registration expired, pending cancellation · Built 1957 · Cavner & Julian IncN36765Stinson 10A · S/N 8065Cancelled Dec 4, 2021 · Registration expired, pending cancellation · Built 1941 · Alsworth Glen R SrN39483Stinson 10A · S/N 8183Cancelled May 8, 2021 · Registration expired, pending cancellation · Alsworth Glen R SrN36753Stinson 10A · S/N 8153Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Built 1955 · Alsworth Chandelle SN317AKBeech 99 · S/N U-28Cancelled Nov 10, 2020 · Built 1968 · Lake Clark Air IncN29865Taylorcraft BF · S/N 2716Cancelled Sep 26, 2020 · Revoked, canceled · Built 1941 · Alsworth Leon RN21151Stinson HW75 · S/N 7009Cancelled Sep 3, 2020 · Revoked, pending cancellation · Built 1939 · Alsworth Leon R JrN9072KStinson 108-1 · S/N 108-2072Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Built 1947 · Alsworth Glen R SrN551CStinson 108-3 · S/N 108-3551Cancelled Mar 9, 2019 · Registration expired, pending cancellation · Built 1947 · Alsworth Glen R SrN9600KStinson 108-2 · S/N 108-2600Cancelled Mar 7, 2019 · Registration expired, pending cancellation · Built 1947 · Alsworth Glen Robert SrN938GStinson 108-3 · S/N 108-3938Cancelled Mar 6, 2019 · Registration expired, pending cancellation · Alsworth Glen RN8283KUniversal Stinson 108-1 · S/N 108-1283Cancelled Feb 27, 2019 · Registration expired, pending cancellation · Built 1946 · Alsworth Glen Robert SrN8648NPiper PA-28-180 · S/N 28-7105149Cancelled Jan 7, 2019 · Registration expired, pending cancellation · Built 1971 · Alsworth Glen RN7689HPiper PA-12 · S/N 12-579Cancelled Dec 18, 2018 · Registration expired, pending cancellation · Built 1946 · Meloon Ralph C Jr DBAN5308FFairchild Heli-Porter PILATUS PC6/C-H2 · S/N 2068Cancelled Mar 27, 2018 · Registration expired, pending cancellation · Built 1975 · Highlandair LLCN6436MStinson 108-3 · S/N 108-4436Cancelled Mar 27, 2018 · Registration expired, pending cancellation · Built 1948 · Alsworth Glen R SrN26229Stinson L-9B · S/N 7521Cancelled Mar 21, 2018 · Registration expired, pending cancellation · Built 1940 · Alsworth Glen RN469PVCessna T206H · S/N T20608075Cancelled Mar 21, 2018 · Exported to South Korea · Built 1999 · Silver Mountain Aviation LLCN7438UCessna T207A · S/N 20700464Cancelled Mar 7, 2018 · Registration expired, pending cancellation · Tanalian Aviation IncN608CStinson 108-3 · S/N 108-3608Cancelled Mar 5, 2018 · Registration expired, pending cancellation · Built 1947 · Fowler Ned AustinN6443MStinson 108-3 · S/N 108-4443Cancelled Feb 20, 2018 · Registration expired, pending cancellation · Built 1948 · Alsworth WayneN8624XCessna 180D · S/N 18051024Cancelled Jan 10, 2018 · Registration expired, pending cancellation · Built 1961 · Tanalian Aviation IncN27231Piper PA-31-350 · S/N 31-7752106Cancelled Jan 3, 2018 · Registration expired, pending cancellation · Built 1977 · Lake Clark Air IncN59352Cessna U206F · S/N U20603221Cancelled Mar 21, 2017 · Registration expired, pending cancellation · Cavner & Julian IncN72067Cessna U206D · S/N U206-1273Cancelled Aug 7, 2013 · Sale reported, canceled · Built 1969N111MTBell 206B · S/N 1989Cancelled Aug 6, 2013 · Sale reported, canceled · Built 1976N3229DCessna 180 · S/N 32027Cancelled Jul 11, 2013 · Sale reported, canceled · Built 1955N9530FCessna 208 · S/N 20800088Cancelled Dec 18, 2012 · Registration expired, pending cancellation · Lake And Peninsula Airlines IncN422RBell 206B · S/N 1696Cancelled Sep 21, 2012 · Sale reported, canceled · Built 1975N1966UCessna A185E · S/N 18501689Cancelled Aug 20, 2012 · Registration expired, pending cancellation · Mcrae DavidN4338HPiper PA-15 · S/N 15-123Cancelled Jun 21, 2012 · Revoked, canceled · Built 1948 · Alsworth Leon R JrN1118DCessna 140A · S/N 15682Cancelled May 24, 2012 · Sale reported, canceled · Built 1950N996PKPiper PA-32-260 · S/N 32-168Cancelled Feb 20, 2008 · Triennial form not returned · Built 1965 · Mcgee Mark KN4839SPiper PA-32-260 · S/N 321268Cancelled May 21, 1997 · Triennial form not returned · Lake Clark Air IncN9201CCessna 180 · S/N 31300Cancelled Jul 12, 1996 · Triennial form not returned · Alsworth Wayne CN9918YChampion 7GCB · S/N 7GCB96Cancelled Apr 22, 1991 · Triennial form not returned · Reed Eugene ON7226KPiper PA-18 · S/N 18-120Cancelled Feb 5, 1971 · Alsworth Wayne C SrN6497KRepublic RC-3 · S/N 763Cancelled Jan 12, 1971 · Coray John C
Back to Port Alsworth, AK