OpenAirDocs.org
Ketchikan, AK

Registered aircraft · 118

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

Query with SQL
duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
  WHERE g.registrant_state = 'AK' AND g.registrant_city = 'KETCHIKAN'
  ORDER BY g.n_number"

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.

N1018ADehavilland BEAVER DHC-2 · S/N 178Built 1951 · Blue Aircraft LLCN1018UDehavilland BEAVER DHC-2 · S/N 1381Built 1959 · Island Wings Air Service LLCN1088NHughes Helicopters HUGHES 369D · S/N 300679DBuilt 1980 · Temsco Helicopters IncN1091PHughes Helicopters HUGHES 369D · S/N 300683DBuilt 1980 · Temsco Helicopters IncN1091SHughes Helicopters HUGHES 369D · S/N 300691DBuilt 1980 · Temsco Helicopters IncN1106DCessna 140A · S/N 15666Built 1950 · Murdock Mark FN1106ZHughes Helicopters HUGHES 369D · S/N 210900DBuilt 1981 · Enright MilesN1107PHughes Helicopters HUGHES 369D · S/N 210897DBuilt 1981 · Temsco Helicopters IncN1117FDehavilland BEAVER DHC-2 MK.1 · S/N 1369Built 1958 · Island Wings Air Service LLCN1140DBrown Robert L LITE - BIRD · S/N 0001Brown Robert LN12UADehavilland DHC-2 MK. I(L20A) · S/N 700Built 1954 · Murdock Mark FN1302TAirbus Helicopters EC 130 T2 · S/N 8258Built 2016 · Temsco Helicopters IncN1303TAirbus Helicopters EC 130 T2 · S/N 8260Built 2016 · Temsco Helicopters IncN1400ZDehavilland BEAVER DHC-2 MK.1 · S/N 1400Built 1959 · Alaskan Fish Pirate Outfitting LLCN141THEurocopter AS 350 B2 · S/N 1167Built 1979 · Temsco Helicopters IncN143THEurocopter AS 350 B2 ECUREUIL · S/N 9043Built 2002 · Temsco Helicopters IncN145THEurocopter AS 350 B2 · S/N 9060Built 2003 · Temsco Helicopters IncN146THEurocopter AS 350 B2 ECUREUIL · S/N 9065Built 2004 · Temsco Helicopters IncN147THEurocopter AS 350 B2 · S/N 9070Built 2005 · Temsco Helicopters IncN148THEurocopter AS 350 B2 · S/N 4623Built 2008 · Temsco Helicopters IncN149AEAirbus Helicopters AS350B3 · S/N 3370Built 2001 · Temsco Helicopters IncN149THEurocopter AS 350 B2 · S/N 9071Built 2005 · Temsco Helicopters IncN15725Schweizer 269C · S/N S1565Built 1991 · Hassell Dan JN16920Bell 212 · S/N 30865Built 1977 · Temsco Helicopters IncN16930Bell 212 · S/N 30920Built 1980 · Temsco Helicopters IncN192RKennedy Rockne L RK-1 · S/N RK 100 1Built 2003 · Disarro WayneN194AEAirbus Helicopters AS350B3 · S/N 3338Built 2001 · Temsco Helicopters IncN198AEAirbus Helicopters AS350B3 · S/N 3371Built 2001 · Temsco Helicopters IncN19GFFreitag Gary CHALLENGER II · S/N CH2-0802-2252Built 2004 · Freitag GaryN214THBell 214B-1 · S/N 28031Built 1978 · Temsco Helicopters IncN223TPiper PA-18 · S/N 18-2337Falconeri Michael AN241MFDehavilland DHC-2 MK 1 · S/N 880Built 1956 · Doyon & Doyon Leasing LLCN2498FCessna 180H · S/N 18051700Built 1966 · Taylor Andrew AN249MFDehavilland DHC 2 MK III · S/N 1662TB36Built 1968 · Doyon Air Transport LLCN28783Luscombe 8E · S/N 1544Built 1940 · Huffine Stephen WN2880PPiper PA-18-150 · S/N 18-4477Built 1955 · Saalsaa BradN292PMDehavilland DHC-3 · S/N 292Single Otter Leasing Two LLCN3125SDehavilland DHC-3 · S/N 407Built 1960 · Mountain Pt Leasing LLCN31NSAirbus Helicopters AS 350B3 · S/N 7971Temsco Helicopters IncN327DPMiller Darrel D MILLER SUPER CUB-18 · S/N 2010-1Built 2016 · Zamboni Fisheries LLCN3324TDehavilland DHC-3 · S/N 205Built 1957 · Blue Aircraft LLCN37756Dehavilland BEAVER DHC-2 · S/N 1456Built 1961 · Blue Aircraft LLCN379PMDehavilland DHC-3 · S/N 379Built 1961 · Single Otter Leasing LLCN3905MPiper PA-12S · S/N 12-2585Taro Brian James TrusteeN4022DEurocopter AS 350 B2 · S/N 2891Built 1995 · Temsco Helicopters IncN403AEEurocopter AS 350 B3 · S/N 3281Built 2000 · Temsco Helicopters IncN405AEEurocopter AS 350 B3 · S/N 3286Built 2000 · Temsco Helicopters IncN4249MPiper PA-12 · S/N 12-3143Built 1947 · Hassell Dan JN435BDehavilland DHC-3 · S/N 183Built 1956 · Single Otter Leasing LLCN436AKMaule M-5-235C · S/N 7053CBuilt 1976 · Thompson James A
Back to Ketchikan, AK