Heber City, UT
Registered aircraft · 47
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 = 'HEBER CITY' 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 = 'HEBER CITY' 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.
N1040BKubicek Factory S R O BB22M · S/N 2338N105PZZaccagnino Super Legacy SUPER LEGACY · S/N L2K-295N11SGTextron 525B · S/N 525B0599N1452Diamond Aircraft Ind DA 40 NG · S/N 40.NC177N1718JRockwell International 112TC · S/N 13008N177ZXDiamond Aircraft Ind DA 40 NG · S/N 40.NC367N180CDCessna 180J · S/N 18052310N1867MCessna 560XL · S/N 560-5303N189DMMabbutt Darwin E RV-4 · S/N 1712N189PCAmerican Champion 8KCAB · S/N 1006-2005N219EAPipistrel D O O PANTHERA X152 · S/N PX1520029N2359CBalony Kubicek Spol Sro BB22XR · S/N 1255N2359MKubicek Factory S R O BB26M · S/N 2527N2359ZBalony Kubicek Spol Sro BB22XR · S/N 1431N23REEvans Randall H LANCAIR 320 · S/N 30N274WAPiper PA-46-600TP · S/N 4698103N286LADiamond Aircraft Ind DA 62 · S/N 62.C102N303MRElan/Glaser Dirks DG-300 ELAN · S/N 3E480A23N32749Piper PA-28R-200 · S/N 28R-7535085N327KMWest Desert Aviators RANS S-20 RAVEN · S/N 07220103N32ETCirrus Design SR22T · S/N 1090N421DRCessna 421C · S/N 421C0608N43449Piper PA-28-180 · S/N 28-7405195N4440CBalony Kubicek Spol Sro BB60Z · S/N 1766N4488BRans Designs S-21LS OUTBOUND · S/N 10180021N4582BBalony Kubicek Spol Sro BB51Z · S/N 1186N50TPPiper PA-25-235 · S/N 25-2341N516CBPilatus PC-12/47 · S/N 752N520TGVans RV-12IS · S/N 121041N528AGQuest KODIAK 100 · S/N 100-0086N530FMMD Helicopters 369FF · S/N 0253FFN5491DWilliam P Tew CCK-1865 · S/N CCK-1865-1035N617BPPerry Brian D RV-14 · S/N 140205N680QACessna 680 · S/N 680-0528N69043Cessna 152 · S/N 15282456N744CMCirrus Design SR22T · S/N 1142N773XEurocopter AS 350 B3 · S/N 4773N800XXDg-Flugzeugbau DG-800S · S/N 8-216S42N83KSExtra Flugzeugbau EA 300/L · S/N 074N84717Cessna 172K · S/N 17258589N8787WBalony Kubicek Spol Sro BB34Z · S/N 1892N907WGCirrus Design SR22 · S/N 3283N925VBVan Batavia Steven R RV8 · S/N 82308N94HPBell 206-L4 · S/N 52218N94LSCessna 182P · S/N 18262356N9532Balony Kubicek Spol Sro BB30Z · S/N 1588N9665VCessna 172M · S/N 17264445
Back to Heber City, UT