Eagle, ID
Registered aircraft · 90
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 = 'EAGLE' 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 = 'EAGLE' 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.
N113VBEvan Brunye KITFOX S7 STI · S/N KA20226461N116SLCessna 182T · S/N 18281242N124WBVans RV-12 · S/N 120445N125STJones Jerry E KITFOX S7 STI · S/N KA23150587N135CTFlight Design CTSW · S/N 06-02-09N1434GBeech 35-B33 · S/N CD-456N1445HPiper PA-32R-301T · S/N 3257092N14ELLewis Edward D GLASAIR · S/N SH2-426N1525YBalloon Works FIREFLY 7 · S/N F7-016N1746TPiper PA-28-140 · S/N 28-7125064N176MCPilatus PC-24 · S/N 109N180UBCessna 180J · S/N 18052611N1815UCessna T182T · S/N T18208434N181LTFriedman J/Webster K LT · S/N 018N189BCAmerican Champion 8GCBC · S/N 470-2005N20391Cameron Balloons US N-105 · S/N 5389N203JAGrumman American Avn. AA-5A · S/N AA5A-0474N20CCessna T337G · S/N P3370145N2105MFirefly Balloons FIREFLY 9 · S/N F9-2005N2113BSilvaire LUSCOMBE 8F · S/N 6541N21182Stinson SR-10C · S/N 35908N2187MCameron Balloons US A-250 · S/N 6572N2265GCessna 182B · S/N 51565N2320HPiper PA-18-150 · S/N 18-7909168N24129Cessna T182T · S/N T18208756N245DKBalony Kubicek Spol Sro BB70Z · S/N 817N246HFRolladen-Schneider OHG LS3-A · S/N 3305N2568XCessna P206 · S/N P206-0068N299JPDiamond Aircraft Ind DA 40 · S/N 40.329N3093UCessna 172E · S/N 17250693N30DLMarch David KITFOX S7 STI · S/N KA23088579N3123RCessna 182L · S/N 18258523N3279DCessna 180 · S/N 32077N332DACirrus Design SR22 · S/N 3453N336WCessna 336 · S/N 336-0156N360CDCirrus Design SR22 · S/N 3516N3676BBurton P Harger ZENITH 750 · S/N 757785N38776Piper PA-28R-201T · S/N 28R-7703274N390TTOTT Rex A GLASTAR · S/N 5601N4020ESpirit Engineering SE-1 · S/N 014N4077DCessna 182A · S/N 34777N427EMBundy Edward RV6-A · S/N 23834N4468FLancair LC41-550FG · S/N 41043N44TBCessna 182Q · S/N 18267207N4699FCessna P206A · S/N P206-0299N472WBFox Den KITFOX S7 STI · S/N KA23150588N4809NCessna 182Q · S/N 18267383N4842KCessna P210N · S/N P21000343N5013NAerostar International S-71A · S/N S71A-3027N510CMJones Mike SH-3R · S/N 3117
Back to Eagle, ID