OpenAirDocs.org
Sterling, AK

Registered aircraft · 98

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

N102WRPiper PA-20-135 · S/N 20-919Built 1952 · St Onge Adam RN1090EBellanca 7ECA · S/N 1210-77Built 1977 · Crouse John AN1170APiper PA-18-125 · S/N 18-768Built 1951 · Abbott Barry RN1268APiper PA-18-125 · S/N 18-1063Built 1951 · Tegerdine Charley DN137DBDaniel Michel DANNY BOY SPECIAL · S/N 0001Built 2021 · Michel Daniel TN1584CCessna 180 · S/N 30284Built 1953 · Haakenson John RN1754APiper PA-18A · S/N 18-1319Schrock Jaden DN175TTCessna 175 · S/N 55193Built 1958 · Farrell Dolliver TN18YXMccarter John D WAIEX · S/N W0018Built 2006 · Kincaid Jerry LN1974PPiper PA-18A 150 · S/N 18-4207Built 1955 · Warren Josiah EN2133EChampion AERONCA 7AC · S/N 7AC-5704Built 1946 · Rowan Thomas WN2164NCessna 140 · S/N 12400Built 1947 · Crane Kelly DN2223CCessna 180 · S/N 30523Built 1953 · Elston Josh AN22MDCessna 337B · S/N 337-0590Built 1966 · Holland Bryan KN2305GCessna 182B · S/N 51605Built 1958 · Fratzke Nathan AN2401MBright Bert M BB-1 · S/N 001Sullivan Ronald EN2442MPiper PA-12 · S/N 12-1545Registration pendingBuilt 1947N2579KCessna 180K · S/N 18053000Built 1978 · Skywagon LLCN2593VCessna 170 · S/N 18098Built 1948 · Kenyon Chad JN2672MCessna 180H · S/N 18051729Built 1966 · Schmoll Aviation LLCN2711PDustin Alexander Padrta PA-18 EXPERIMENTAL · S/N 1Built 2026 · Padrta Dustin AlexanderN271PAPictaio Aerospace XENON IV · S/N CAJ14M3B13AA017LBuilt 2015 · Foust Eric JN2888KCessna 180K · S/N 18053119Built 1979 · Booth William R JrN29561Christen Industries A-1 · S/N 1069Built 1988 · St Onge Adam RN2977NCessna 140 · S/N 13235Built 1947 · Farrell Tammy JN3092MPiper PA-12 · S/N 12-1781Geeslin James Welch IIIN3151Dennis D Downs CCK-1865 · S/N CCK-1865-0106Built 2015 · Downs Dennis DN3211FPiper PA-11 · S/N 11-238Built 1974 · Johnson Kenneth EN324GCDaniel R Dufault GLACIER CUB · S/N 1-324Built 2014 · Wing LLCN3342MPiper PA-12 · S/N 12-2201Morris John BN338JMDehavilland DHC-2 MK. I(L20A) · S/N 456Built 1954 · Michel Daniel TN346CStinson 108-2 · S/N 108-3346Built 1947 · Veal Jeffrey SN35124Piper J3C-90 · S/N 6136Kauffman Peter LN3609ZPiper PA-22-150 · S/N 22-7497Built 1960 · Veal Petra LN3652SCessna 150F · S/N 15062745Bennett Quinn SN3677APiper PA-18 · S/N 18-3072Built 1953 · Wing LLCN3747PPiper PA-22-150 · S/N 22-3467Registration pendingBuilt 1955N3837PPiper PA-14 · S/N 14-154Plancich Don AN3869MPiper PA-12 · S/N 12-2784Built 1947 · Johnson Don SN40676Maule M-4-220C · S/N 2180CFarrell Tammy JeanN4231FCessna 172 · S/N 46131Yancey Emron AN4266ZPiper PA-18-150 · S/N 18-8512Built 1967 · Van Ryzin Chris KN4322MPiper PA-12 · S/N 12-3257Veal Jeffrey SN4394ZPiper PA-18-150 · S/N 18-8725Sherman Kent LN440FAviat A-1B · S/N 2344Built 2006 · Bock Jacqueline DN4489ZPiper PA-18-150 · S/N 18-8845Hernandez Michael JN4733UCessna 180G · S/N 18051433Built 1964 · Eicher Marlin DaleN47513Interstate S-1B1 · S/N 181Sullivan Ronald EN4871EChampion 7GC · S/N 7GC-76Sloss John WN4908PPiper PA-18-150 · S/N 18-7789Built 1962 · Johnson Dalton S
Back to Sterling, AK