Emmett, ID

Registered aircraft · 48

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

N1091NMooney M20K · S/N 25-1220Built 1989 · Dunkin Stevan RN13521Cessna 172M · S/N 17262817Ekberg Jeff MN140PMMichael H Zimmering RV14 · S/N 140350Built 2023 · Zimmering Michael HN167ALHughes Helicopters HUGHES 369D · S/N 270083DBuilt 1977 · Ferguson And Sons Construction LLCN169MSSwett Mark AVID BANDIT · S/N 1429EDonesky Robert DN180BDCessna 180 · S/N 30848Built 1954 · Sanderson Bryan DN1919WWiley Dennis C 2/3 JENNY · S/N 002Built 1999 · Wiley Dennis C DBAN1920XCessna 182H · S/N 18256020Built 1965 · Jensen Richard VaughnN21924Cessna 150L · S/N 15074541Built 1973 · Berwick Mark AN226NTContinental Copters TOMCAT MK5A · S/N CCI-742Britton John EN2353VCessna 140 · S/N 14727Built 1948 · Spredemann Carl AN2507FChampion 7ECA · S/N 122Morley Thomas ON253BAPetiletky Strojirny Prvni NP L-13 BLANIK · S/N 172419Aero Head Soaring Club IncN302BZCessna 501 · S/N 501-0193Built 1980 · Ferguson And Sons Construction LLCN3128SNew Piper PA-46-500TP · S/N 4697251Built 2006 · Gem Equipment Leasing LLCN355ZBeech 35-A33 · S/N CD-387Built 1960 · Roeder Richard EN369FCHughes Helicopters HUGHES 369D · S/N 610983DBuilt 1981 · Ferguson And Sons Construction LLCN4119ZPiper PA-18-150 · S/N 18-8161Sanderson Bryan DN45308Cessna 150M · S/N 15076833Built 1975 · Berry Thomas FN469FCHughes Helicopters HUGHES 369D · S/N 1100854DBuilt 1980 · Ferguson And Sons Construction LLCN4839DCessna 182A · S/N 34939Built 1958 · Rosecrans RobertN4924CContinental Copters TOMCAT MK5A · S/N 2Built 1960 · Britton John EN500FCMcdonnell Douglas Helicopter 369E · S/N 0442EBuilt 1983 · Ferguson And Sons Construction LLCN510FCCessna 501 · S/N 5010098Built 1980 · Ferguson And Sons Construction LLCN510PMMichael Zimmering SUPERSTOL XL · S/N JA677-10-22Built 2026 · Zimmering Michael HN51264Kurta William B QUAD CITY CHALNGR II · S/N CH20199-1831Kurta William BN530FCMD Helicopters 369FF · S/N 0712FFBuilt 2007 · Ferguson And Sons ConstructionN530XXMD Helicopters 369FF · S/N 0710FFBuilt 2000 · Ferguson And Sons Construction LLCN5388BCessna 182 · S/N 33388Built 1956 · Burak Steven WN5395BCessna 182 · S/N 33395Built 1956 · Rosecrans Robert MichaelN541JTThomson Jim VANS RV6 · S/N 24884Built 1998 · Thomson JimN569FCHughes Helicopters HUGHES 369D · S/N 570126DBuilt 1977 · Ferguson And Sons Constructions LLCN6486JCessna 172N · S/N 17273877Built 1980 · Spredemann Carl AN691BEAviat A-1 · S/N 1309Wester JoshuaN707MFPilatus P3-05 · S/N 504-53Built 1958 · Feist Richard TN7178RPiper PA-28-140 · S/N 28-21889Bronson Erin WilliamN7179ECessna 182B · S/N 52179Built 1959 · Hoem Shawn MN718DHHirsch Darrel L GLASAIR III SH-3R · S/N 3083Built 2003 · Wester Joshua CN73240Bell 47G-3B · S/N 2772Britton John EN7559EChampion 7FC · S/N 7FC-256Morley Thomas ON7676GCessna 172L · S/N 17259376Built 1970 · Palmer Michael CN833DMXag P100 PRO · S/N 1863FPEG821942541QX4Jerico Building & Storage LLCN86252Aeronca 11AC · S/N 11AC58Built 1946 · Reek David AN8950WPiper PA-28-235 · S/N 28-10523Ethington ScottN9069DBalloon Works FIREFLY 8 · S/N F8-369Saldana AdolfoN9482TPiper PA-38-112 · S/N 38-78A0111Built 1978 · Reid JohnN97372Stinson 108 · S/N 108-372Reek David AN9818GCessna 172L · S/N 17259718Built 1971 · Gough Gregory
Back to Emmett, ID