Hayden, ID
Registered aircraft · 99
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 = 'HAYDEN' 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 = 'HAYDEN' 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.
N110EAeropro CZ S R O A240 · S/N 436 14N1179SSchweizer SGS 2-33A · S/N 229N11PBDehavilland DHC-1B-2-S5 · S/N 177/215N120MKVans RV-12 · S/N 120153N128EMooney M20E · S/N 1190N144DXDene P Jones ZENITH CH 601 XL · S/N 6-6434N145MMWhiskey Romeo OUTLAW · S/N 0001N158KQQuest KODIAK 100 · S/N 100-0158N169PMCostruzioni Aeronautiche Tecna P2008 · S/N 208N1757MPiper PA-18A 150 · S/N 18-6009N1806KLuscombe 8E · S/N 4533N18356Beech A36 · S/N E-1101N183EBeech A36 · S/N E-2034N187MMCessna 210E · S/N 21058707N18JMPiper PA 46-350P · S/N 4636229N190PCessna P206 · S/N P206-0012N21DBAlon A2 · S/N A-232N231BWPilatus PC-12/45 · S/N 600N24679Beech B19 · S/N MB-576N268DKRutan Richard BERKUT · S/N 059N276RAmerican Champion 8KCAB · S/N 713-93N2803DBoeing B75N1 · S/N 75-6822N298FBKodiak KODIAK 100 · S/N 100-0329N307KEKilo Bravo Holdings MK1 · S/N FBH2N3166MPiper PA-12 · S/N 12-2001N317DDBRM Aero S R O BRISTELL LSA · S/N 519/2020N331GTThwaites Richard S SHA-GLASAIR · S/N 331N3357DCessna 180 · S/N 32155N335WHPilatus PC-12/45 · S/N 335N348CMCessna 550 · S/N 550-0915N35669Cessna 172I · S/N 17256897N3590SCessna 172E · S/N 17250790N3832YCessna 210D · S/N 21058332N401REickstedt Raymond W RV-4 · S/N 1647N4106KNavion NAVION A · S/N NAV-4-1106N4161WTextron B200GT · S/N BY-337N419KSReims CESSNA F182Q · S/N 0080N4424KNavion NAVION A · S/N NAV-4-1424N4559KRyan NAVION · S/N NAV-4-1559N473BGCoyne Donald SIX-CHUTER LEGEND XL · S/N 2989N478EATomark Aero CZ Sro VIPER SD-4 · S/N 39478N47HDAmerican Legend AL11 · S/N AL-1049N47NARyan NAVION A · S/N NAV-4-1314N481RDBell 47G-3B-2 · S/N 6716N48PABeech B200 · S/N BB-996N5269ECessna 180B · S/N 50569N5281DCessna 180A · S/N 50179N5436DBeech H35 · S/N D-4964N55402Piper PA-28-140 · S/N 28-7325395N5619UNorth Wing Design APACHE · S/N 07181
Back to Hayden, ID