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.
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
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.
N1091NMooney M20K · S/N 25-1220N13521Cessna 172M · S/N 17262817N140PMMichael H Zimmering RV14 · S/N 140350N167ALHughes Helicopters HUGHES 369D · S/N 270083DN169MSSwett Mark AVID BANDIT · S/N 1429EN180BDCessna 180 · S/N 30848N1919WWiley Dennis C 2/3 JENNY · S/N 002N1920XCessna 182H · S/N 18256020N21924Cessna 150L · S/N 15074541N226NTContinental Copters TOMCAT MK5A · S/N CCI-742N2353VCessna 140 · S/N 14727N2507FChampion 7ECA · S/N 122N253BAPetiletky Strojirny Prvni NP L-13 BLANIK · S/N 172419N302BZCessna 501 · S/N 501-0193N3128SNew Piper PA-46-500TP · S/N 4697251N355ZBeech 35-A33 · S/N CD-387N369FCHughes Helicopters HUGHES 369D · S/N 610983DN4119ZPiper PA-18-150 · S/N 18-8161N45308Cessna 150M · S/N 15076833N469FCHughes Helicopters HUGHES 369D · S/N 1100854DN4839DCessna 182A · S/N 34939N4924CContinental Copters TOMCAT MK5A · S/N 2N500FCMcdonnell Douglas Helicopter 369E · S/N 0442EN510FCCessna 501 · S/N 5010098N510PMMichael Zimmering SUPERSTOL XL · S/N JA677-10-22N51264Kurta William B QUAD CITY CHALNGR II · S/N CH20199-1831N530FCMD Helicopters 369FF · S/N 0712FFN530XXMD Helicopters 369FF · S/N 0710FFN5388BCessna 182 · S/N 33388N5395BCessna 182 · S/N 33395N541JTThomson Jim VANS RV6 · S/N 24884N569FCHughes Helicopters HUGHES 369D · S/N 570126DN6486JCessna 172N · S/N 17273877N691BEAviat A-1 · S/N 1309N707MFPilatus P3-05 · S/N 504-53N7178RPiper PA-28-140 · S/N 28-21889N7179ECessna 182B · S/N 52179N718DHHirsch Darrel L GLASAIR III SH-3R · S/N 3083N73240Bell 47G-3B · S/N 2772N7559EChampion 7FC · S/N 7FC-256N7676GCessna 172L · S/N 17259376N833DMXag P100 PRO · S/N 1863FPEG821942541QX4N86252Aeronca 11AC · S/N 11AC58N8950WPiper PA-28-235 · S/N 28-10523N9069DBalloon Works FIREFLY 8 · S/N F8-369N9482TPiper PA-38-112 · S/N 38-78A0111N97372Stinson 108 · S/N 108-372N9818GCessna 172L · S/N 17259718
Back to Emmett, ID