Sandpoint, ID

Registered aircraft · 134

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 = 'ID' AND g.registrant_city = 'SANDPOINT'
  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.

N7330MCessna 175 · S/N 55630Built 1958 · Jorgenson Brian KN7348RBeech 95-B55 (T42A) · S/N TC-1709Built 1974 · Berrey AndrewN735NSCessna 182Q · S/N 18265560Built 1977 · Dunn Scott RN73QDehavilland BEAVER DHC-2 MK.1 · S/N 302Built 1952 · Gdfm LLCN7434RPiper PA-28-140 · S/N 28-21969Built 1966 · Myers LisaN7521KCessna 180J · S/N 18052660Built 1976 · 5b 7b Aero LLCN759BECessna 182Q · S/N 18265856First renewal noticeBuilt 1977 · Bates Andrew TN78654Piper PA-11 · S/N 11-454Built 1948 · Jorgenson Brian KN7878CTaylorcraft DC-65 · S/N 6245Built 1942 · Brown Charles MN791TBBidus Brent E KITFOX CLASSIC 4 · S/N C9802-0218Built 2026 · Bidus Brent EN800DEDG Flugzeugbau DG-800B · S/N 8-147B71Built 1998 · Easton DougN8192BCessna 172 · S/N 29992Built 1957 · All Sports Aviation LLCN829WDKodiak KODIAK 100 · S/N 100-0375Kodiak Aircraft Co IncN8401XCessna 172C · S/N 17248901Built 1961 · Wilkinson Bert DN842THSikorsky UH-60L · S/N 84-23970Timberline Helicopters IncN8476JPiper PA-14 · S/N 14-204Built 1949 · Blue Streak Aire LLCN8537EChampion 7EC · S/N 7FC-343Built 1959 · Hoech Neal LN881VCCirrus Design SF50 · S/N 0238Built 2020 · Redhawk One LLCN8847JPiper PA-28-180 · S/N 28-2805Flw LLCN893KAircraft Builders STUDENT PRINCE X · S/N 102Built 1930 · Brown Charles MN895DSSwenson Donald R RV-6A · S/N 20530Guida Associates Consulting IncN8989XDevin Sirois SUPER CUB EXP · S/N 001Built 2016 · Cascadia Aircraft LLCN900KXKodiak KODIAK 200 · S/N 200-0001Built 2020 · Kodiak Aircraft Co IncN902ARKodiak KODIAK 200 · S/N K2-0035Kodiak Aircraft Co IncN916THSikorsky UH-60A · S/N 83-23916Timberline Helicopters IncN942VTLenart David R AVIPRO BEARHAWK · S/N 942Built 2010 · Mcintosh Donald WN9438NCessna A185F · S/N 18504356Built 1981 · Sallmon James HenryN953CNCraig Ellison BEARHAWK FOUR · S/N 443-87/88Built 2026 · Ellison CraigN953TWEllison Craig M GLASAIR SPORTSMAN · S/N 001Built 2008 · Ellison Craig MN955DWCub Crafters PA18-150 · S/N 9969CCBuilt 2004 · Witham DavidN9598ZChristen Industries A-1 · S/N 1102Built 1989 · Del Valle Enterprises IncN962SPKodiak KODIAK 100 · S/N 100-0372Built 2026 · Kodiak Aircraft Co IncN9894GCessna 172L · S/N 172597941s6 Flying Club IncN9950DPiper PA-22-150 · S/N 22-6738Sierra Charlie Aviation LLC
Back to Sandpoint, ID