OpenAirDocs.org
Sitka, AK

Registered aircraft · 47

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

N1043FCessna A185F · S/N 18502700Built 1975 · Bakkes FrancoisN11466Waco INF · S/N 3519Built 1931 · Command Aire LLCN11YBAlliance ARGO · S/N 108Command Aire LLCN1277APiper PA-18 · S/N 18-1072Built 1951 · Wagner Tyler MN14080Waco YMF-3 · S/N 4209Built 1934 · Command Aire LLCN15356Piper E-2 · S/N 266Built 1935 · Command Aire LLCN17253Taylor J-2 · S/N 919Built 1936 · Command Aire LLCN176KMonocoupe 90 · S/N 513Juranich Robert JN19314Aeronca K · S/N K180Command Aire LLCN1996UCessna A185E · S/N 18501765Built 1970 · Smith Aviation LLCN28437Silvaire LUSCOMBE 8A · S/N 1304Built 1940 · Handerson Ron SrN2MWWard STARDUSTER TWO · S/N 856Built 1972 · Command Aire LLCN31263Bellanca 7GCBC · S/N 402-72Built 1972 · Handerson Ronald JN337SREbbert P R/Ebbert S SEA REY · S/N 1DK337CBuilt 2008 · Ebbert Paul RN3405YCessna 180H · S/N 18051905Built 1967 · Campbell Casey JN34468Aeronca 65-TL · S/N L-10071TBuilt 1941 · Command Aire LLCN3491KCubcrafters CC11-160 · S/N CC11-00211Built 2012 · Perseverance Enterprises LLCN36539Aeronca 65-CA · S/N C16331Handerson Ron JN43679Taylorcraft BC12-D · S/N 7338Handerson Ronald J SrN4468CCessna 195 · S/N 16053Built 1953 · Command Aire LLCN4989NDehavilland DHC-2 · S/N 31Built 1948 · Lambeth Air LLCN510CDCirrus Design SR22 · S/N 1324Built 2005 · Mcgraw Jon WN51QTPiper PA-18-150 · S/N 18-905Built 1957 · Gordon David AN537WMonocoupe 90 · S/N 561Built 1930 · Command Aire LLCN545PMCirrus Design SR22 · S/N 3703Built 2010 · Perseverance Enterprises LLCN602LBDay Mardell H S-7 KITFOX · S/N 0306029Built 2011 · Adams Dale LN60611Cessna 150J · S/N 15070444Built 1969 · Feryok John IIN6122ACessna P210R · S/N P21000867Lambeth Air LLCN649LCBeech 58P · S/N TJ-304Built 1980 · Smith Aviation LLCN6590ECessna A185F · S/N 18504058Harbor Air LLCN66021Cessna 180K · S/N 18052905Built 1977 · Mcgraw Leasing LLCN7387MCessna 175 · S/N 55687Built 1958 · Handerson Ronald JN7478PPiper PA-24-250 · S/N 24-2671Handerson Ronald J SrN7614HPiper PA-12 · S/N 12-489Built 1946 · Command Aire LLCN80CRCessna TU206G · S/N U20605548Built 1980 · Rdp Construction LLCN8142YPiper PA-18-150 · S/N 18-8593Built 1967 · Garner Charles EN8240Eaglerock A-1 · S/N 714Built 1929 · Command Aire LLCN835GRGrutter Ivan T ZENITH 750 SUPERDUTY · S/N SD75-10918Built 2021 · Grutter Ivan TN8503UCessna 150M · S/N 15077941Cropley Alton IN894CCessna 525A · S/N 525A0013Built 2001 · Golden Jet LLCN8GACessna 421C · S/N 421C0842Lambeth Air LLCN946ECommand-Aire 5C-3 · S/N W-95Built 1929 · Command Aire LLCN947ARBellanca 7ECA · S/N 858-72Built 1972 · Papoi Coral AN9507BCessna 180A · S/N 32804Built 1957 · Handerson Ronald Jr SrN9556DPiper PA-22-160 · S/N 22-6473Built 1958 · Handerson Ronald J SrN95962Christen Industries A-1 · S/N 1093Built 1989 · Forst Richard AN98390Piper J-3 · S/N 18574Built 1946 · Command Aire LLC
Back to Sitka, AK