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.
N55066Piper PA-28-180 · S/N 28-7305303N55457Cessna 172P · S/N 17275184N574HBMaule M-7-235 · S/N 4134CN5AXRabern Donald A VAN'S RV-8A · S/N 82241N5PABeech A36TC · S/N EA-251N6006BCessna 182A · S/N 34006N6046QMooney M20E · S/N 885N605FBCirrus Design SR22T · S/N 9421N6319RPiper PA-28-140 · S/N 28-21485N6381UHowes Rodney H KITFOX 2 · S/N 540N642BCCessna T206H · S/N T20609067N656RDNorth Wing Uum SPORT X2 · S/N E7031N661MCirrus Design SR22T · S/N 1013N666DYFoxair KITFOX LIGHT SPORT · S/N KA12089215N6749HPiper J3C-65 · S/N 19966N67652Cessna 152 · S/N 15281964N6812ECessna 175A · S/N 56312N6897GCessna 150L · S/N 15072397N68SFFreeman Scott G RV-7A · S/N 72356N692DCFrank R Little BLUE SHARK · S/N 71273N6950HPiper J3C-65 · S/N 20186N6VKBlack David Vaughan VELOCITY RG · S/N DMO-263N7050KPiper PA-20 · S/N 20-158N710JWSchempp-Hirth Flugzeugbau VENTUS 2C · S/N 122N7307NCessna 182P · S/N 18263093N7449PPiper PA-24-250 · S/N 24-2638N747BBeech A35 · S/N D-1755N752EGregory D Green VANS RV-14A · S/N 140201N753WWGyroflug SC 01 B 160 · S/N S44N777RVKirk Anthony S RV-7 · S/N 73993N7863YPiper PA-30 · S/N 30-945N787CBCirrus Design SR22 · S/N 0787N787NDuenas C ACRO SPORT I · S/N 2123N791JBBeech 95-A55 · S/N TC-273N7960KBeech 35-B33 · S/N CD-774N811CMichael Wright VANS RV7 · S/N 74902N811ESSalzman M L/Salzman T L LANCAIR ES · S/N ES-153N82941Piper PA-18-150 · S/N 18-7809026N832CATL Ultralight Sro TL-3000 SIRIUS · S/N 19 SI 186N8345PPiper PA-24-250 · S/N 24-3601N8747SCessna 150F · S/N 15062047N8831CPiper PA-22-135 · S/N 22-1446N8878UCessna 150M · S/N 15078011N88GHHess KR-2 · S/N GH-1N8986ZCessna 310G · S/N 310G0086N90898Woodard Osceola RV-6A · S/N 24131N9327MMooney M20E · S/N 1259N956MR K Baker VELOCITY XL-RG-5 · S/N 3RX-176N9746XCessna 210B · S/N 21058046N9873TPiper PA-38-112 · S/N 38-78A0227
Back to Hurricane, UT