Registered aircraft · 29

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

Query with SQL

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 = 'SAGLE' ORDER BY g.n_number

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

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 = 'SAGLE'
ORDER BY g.n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N161CPStokesberry Cecil F KITFOX MODEL IV · S/N 1451Built 2008 · Stokesberry Cecil F N193AWGibson Mark MANTA 503 · S/N M503-08-001Built 2008 · Mcdonald James R N26JNOlmstead Merle L JENNY · S/N 001Cummins Larimore J N273DFFarnham Donald C CH 750 CRUZER · S/N C75-10138Built 2020 · Farnham Donald C N2815TCessna 152 · S/N 15282250Built 1978 · Norwest Ventures LLC N2871YCessna 182E · S/N 18253871Johnson Cynthia Trustee N3154CCessna 180 · S/N 30953Built 1954 · Mitchell Barry C N3270UCessna 182F · S/N 18254670Built 1963 · Scott Brian W N343ZCampbell James SH 4 · S/N 5743Built 2004 · Lyon Leslie E N3989VCessna 170 · S/N 18308Built 1948 · Felten William J N437WDuncan Bill SUPER MAUL · S/N 001Built 2013 · Woodward James W N518TFFarmin Tc/Farmin TC RV-4 · S/N 2496Farmin Tim C N6299UGrumman American Avn. AA-5 · S/N AA5-0782Built 1975 · Keelin Freddie B N66FBFoy John P RV8 · S/N 81085Built 2001 · James W Woodward N6881HPiper J3C-65 · S/N 20104Built 1946 · Nickel Galen L N7108SCessna 150H · S/N 15067808Built 1967 · Chapman Gary M N722SBMaule M-6-235 · S/N 7499CBuilt 1989 · Woodward James W N749ABAirtime CYGNET · S/N 110Built 2016 · Beaty Adam R N75530Howell Arthur G AEROTRICK SAFARI · S/N 42182Mcdonald James R N755EECirrus Design SR22T · S/N 1276Built 2016 · Tango Kilo Aviation LLC N7963PPiper PA-24-250 · S/N 24-3200Built 1962 · Whitaker Joel D N817VVierra Aaron M RANS S-6 · S/N 0892337ABuilt 2025 · Vierra Aaron M N850AZSocata TBM 700 · S/N 384Built 2006 · Salt River Aviation LLC N881RDPiper PA-18-150 · S/N 18-8109047Built 1981 · Orchard Richard W N89938Cessna 120 · S/N 8990Built 1946 · Nickel Galen L N9623YAviat A-1 · S/N 1191Built 1991 · Townsend Richard N971ARans S-6ES COYOTE II · S/N 0892337Vierra Aaron M N9732ACessna 170A · S/N 19193Built 1949 · Moremen Joshua N977WWBrent A Frerichs RV8 · S/N 83889Built 2023 · Frerichs Brent A

Back to Sagle, ID