Highland, UT
Registered aircraft · 22
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 = 'HIGHLAND' 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 = 'HIGHLAND' 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.
N111CMEmbraer S A EMB-545 · S/N 55010132N151JFPiper PA-28R-201T · S/N 28R-7703405N1579JPiper PA-28-140 · S/N 28-23987N2809FCessna 182J · S/N 18256909N366FBIsrael Aircraft Industries GULFSTREAM 200 · S/N 075N3683VCessna 150M · S/N 15076588N411YPCirrus Design SR22T · S/N 10581N492DZCirrus Design SR22T · S/N 2337N50404Cessna 150H · S/N 15069278N57PHCessna 182Q · S/N 18265514N645RSCirrus Design SR22 · S/N 9856N6836GCessna 150L · S/N 15072336Registration pendingN686RSRichard Kenneth Slack RANS S-20 RAVEN · S/N 08150050N7231JPiper PA-28-140 · S/N 28-24567N75SYCostruzioni Aeronautiche Tecna P2002 SIERRA · S/N 359N7785HPiper PA-12 · S/N 12-683N836TBCessna 182S · S/N 18280735N8501UCessna 172F · S/N 17252401N8626GCessna 150F · S/N 15062726N8632KCessna 340A · S/N 340A1243N9055QBalloon Works FIREFLY 8B · S/N F8B-330N9287GCessna 182P · S/N 18260827
Back to Highland, UT