Hurricane, UT
Registered aircraft · 100
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 = 'UT' AND g.registrant_city = 'HURRICANE' 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 = 'UT' AND g.registrant_city = 'HURRICANE' 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.
N1028QCarter Richard L BUDDY BABY LAKES · S/N 1001N1296MCessna T206H · S/N T20608803N12KTCurran-Quirk RV7A · S/N 72045N13131Beech 95 · S/N TD-42N172CBCessna R172K · S/N R1722290N17LNLarry New AUTOGYRO MTO SPORT · S/N M00954N180EVCessna 180A · S/N 32949N18DNCirrus Design SR22 · S/N 0096N194GPBarth George J RV9A · S/N 90038N1BJObarr Jack EUROPA · S/N 1N20398Cessna 172M · S/N 17261258N203ECHeath Donald F MK 1 · S/N A001N206GTCessna P206B · S/N P206-0374N2313PPiper PA-22-150 · S/N 22-2724N2315FCessna 210E · S/N 21058515N2358FCessna 210E · S/N 21058558N237RCCrawford Russell RV-7A · S/N 70191N2411TInterplane SKYBOY · S/N 063/2002N250JRJim Rust VANS RV-8 · S/N 81426N254RSRaymond Schureman SKY REACH BUSH CAT · S/N CH-297N2556APiper PA-22 · S/N 22-853N2556VCessna 170 · S/N 18061N2591JCessna 150E · S/N 15061091N266DS.O.C.A.T.A. RALLYE 235E · S/N 13017N277PDRobinson Helicopter R44 II · S/N 10265N2930NCessna 120 · S/N 13191N299BTCirrus Design SF50 · S/N 0724N303LWBeech V35 · S/N D-8336N332SQuicksilver SPORT 2S · S/N 2S0015N333KLKurt M Lohmueller RV-12 · S/N 120385N3385BPiper PA-22-135 · S/N 22-2184N361SCBeech D55 · S/N TE-696N36202Piper PA-32RT-300T · S/N 32R-7887028N3653PPiper PA-22-150 · S/N 22-3404N40993Piper PA-28-180 · S/N 28-7405159N409RBeech K35 · S/N D-6011N4136BAero Commander 520 · S/N 52040N4157LPiper PA-18-150 · S/N 1809073N4201QCessna 172L · S/N 17260101N44413Piper PA-28-180 · S/N 28-7405241N444MNEmbraer Executive EMB-505 · S/N 50500351N4474CCessna 195 · S/N 16059N4546NGrumman American Avn. AA-5B · S/N AA5B1290N470TWHonda HA-420 · S/N 42000047N47445Piper PA-28R-201T · S/N 28R-7703379N4807LCessna 182A · S/N 34827N4916DCessna 182A · S/N 51016N499MTaylorcraft DCO-65 · S/N L5258N509CECirrus Design SR22 · S/N 0979N543RPiper PA-28-201T · S/N 28-7921032
Back to Hurricane, UT