OpenAirDocs.org
Ketchikan, AK

Cancelled registrations · 137

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 = 'KETCHIKAN'
  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.

N6099YEurocopter AS 350 B2 ECUREUIL · S/N 2847Cancelled Nov 5, 2001 · Triennial form not returned · Built 1995 · Temsco Helicopters IncN67667Dehavilland DHC-2 MK. I(L20A) · S/N 401Cancelled Sep 18, 2000 · Exported to Canada · Taquan Air Svc IncN5389ZCessna U206G · S/N U20606107Cancelled Aug 7, 2000 · Exported to Canada · Taquan Air Service IncN9871ZCessna U206G · S/N U20606716Cancelled May 5, 2000 · Exported to Mexico · Taquan Air Service IncN1018HDehavilland BEAVER DHC-2 · S/N 732Cancelled Apr 14, 2000 · Exported to Canada · Taquan Air Service IncN5314RCessna A185F · S/N 18503030Cancelled Dec 8, 1999 · Triennial form not returned · Taquan Air Service IncN68086Dehavilland-Hansen DHC-3 · S/N 288Cancelled Nov 17, 1999 · Exported to Fiji · Taquan Air Service IncN1964TBell 206B · S/N 2738Cancelled Apr 2, 1999 · Exported to Canada · Temsco Helicopters IncN5001UBell 206B · S/N 2415Cancelled Mar 2, 1999 · Exported to Canada · Temsco Helicopters IncN1974TBell 206B · S/N 2464Cancelled Jan 19, 1999 · Exported to Canada · Temsco Helicopters IncN57955Aerospatiale AS350BA · S/N 1538Cancelled Nov 16, 1998 · Exported to Canada · Temsco Helicopters IncN58317Hughes Helicopters HUGHES 369D · S/N 490498DCancelled Oct 31, 1997 · Triennial form not returned · Temsco Helicopters IncN58318Hughes Helicopters HUGHES 369D · S/N 590499DCancelled Sep 10, 1997 · Triennial form not returned · Temsco Helicopters IncN58315Hughes Helicopters HUGHES 369D · S/N 490495DCancelled Oct 7, 1996 · Triennial form not returned · Temsco Helicopters IncN6478HCessna 207A · S/N 20700538Cancelled Jun 3, 1996 · Triennial form not returned · Ketchikan Air Service IncN9895BDehavilland-Hansen DHC-3 · S/N 194Cancelled Apr 4, 1996 · Exported to Canada · Scudero IncN3191LBell 206B · S/N 3803Cancelled Oct 17, 1995 · Exported to New Zealand · C And I CorpN11250Dehavilland DHC-3 · S/N 171Cancelled Mar 31, 1993 · Triennial form not returned · Temsco Helicopters IncN68HABritten-Norman BN2A-26 ISLANDER · S/N 2009Cancelled Jan 6, 1992 · Triennial form not returned · Temsco Helicopters IncN1454TDehavilland BEAVER DHC-2 MK.3 · S/N 1625TB15Cancelled Jun 13, 1991 · Exported to Canada · Ketchikan Air Service IncN99676Bell UH-1B · S/N 638513Cancelled Apr 23, 1991 · Triennial form not returned · Temsco Helicopters IncN96336Taylorcraft BCS12-D · S/N 8636Cancelled Apr 1, 1991 · Triennial form not returned · Mcgee CharlesN1908BLuscombe 8A · S/N 6335Cancelled Mar 21, 1991 · Triennial form not returned · Prentiss James RN7172HAerospatiale AS350B · S/N 1213Cancelled Jul 24, 1990 · Exported to Canada · Temsco Helicopters IncN3585ZPiper PA-18-150 · S/N 18-7377Cancelled Nov 16, 1982 · Built 1960 · South East Alaska Airlines IncN21749Cessna A185F · S/N 18503065Cancelled Nov 5, 1982 · Built 1976 · Clark Dale DavidN3790GDehavilland BEAVER DHC-2 · S/N 600Cancelled Mar 1, 1982 · Built 1960 · Tyee Airlines IncN5384VHiller UH-12E · S/N 2078Cancelled Dec 23, 1981 · Temsco Helicopters IncN8318FHughes 369HS · S/N 1050777SCancelled Oct 13, 1981 · Temsco Helicopters IncN935WStinson SM-8A · S/N M-4110Cancelled May 8, 1981 · Pioneer Airways IncN68086Dehavilland-Webber Airlines DHC-2 BEAVER · S/N 1383Cancelled Nov 26, 1980 · Tyee Airlines IncN5358VHiller UH-12E · S/N 2066Cancelled Sep 11, 1980 · Temsco Helicopters IncN1045Grumman G-21A · S/N 1195Cancelled Jul 11, 1980 · Built 1943 · Webber Airlines IncN4116VCessna 170 · S/N 18448Cancelled Mar 29, 1980 · Administratively canceled · Sal ReportedN9139FHughes 369HS · S/N 230449SCancelled Jul 14, 1977 · Temsco Helicopters IncN9172FHughes 369HS · S/N 340573SCancelled Jul 14, 1977 · Temsco Helicopters IncN95988Taylorcraft BC12-D · S/N 8288Cancelled Jul 22, 1976 · Salamanchuk Patricia AN1416ZDehavilland BEAVER DHC-2 · S/N 1503Cancelled Dec 11, 1975 · Exported to Canada · Coast Air IncN4766Dehavilland BEAVER DHC-2 · S/N 22Cancelled May 9, 1975 · Built 1948 · Swaim Jack RN2407KLuscombe 8E · S/N 5134Cancelled May 8, 1975 · Reid Alex SN129WADehavilland DHC-2 · S/N 1004Cancelled Apr 21, 1975 · Built 1956 · Webber Airlines IncN31774Aeronca S-65-CA · S/N CA13441Cancelled Aug 9, 1974 · Built 1941 · Bass CarrollN53479Boeing A75N1 · S/N 752440Cancelled May 16, 1974 · Wills TerryN2760JCessna A185E · S/N 185-1510Cancelled Jan 24, 1974 · Todds Air ServiceN70295Cessna A185F · S/N 185-02099Cancelled Nov 15, 1973 · Carl D Jackson DBA Revilla Flying ServiceN92505Piper PA-12 · S/N 12-28Cancelled Jun 25, 1973 · Davis Charles QN6746CHiller UH-12B · S/N 406Cancelled Jan 12, 1971 · Temsco Copters IncN4118YCessna 185A · S/N 185-0318Cancelled Jun 30, 1970 · Simpson Air Service IncN1656ZCessna 185A · S/N 185-0456Cancelled Jun 26, 1970 · Todd EdN4275HPiper PA-14 · S/N 14-82Cancelled Jun 23, 1970 · Todd Edwin V
Back to Ketchikan, AK