OpenAirDocs.org
Lehi, UT

Registered aircraft · 45

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 = 'LEHI'
  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.

N103GMMitchell Gary M KITFOX IV · S/N 1824Sandoval JimmyN159SCSix Chuter LEGEND XL · S/N 3103Built 2009 · Visker Jeremy LN194SCCzech Sport Aircraft A S SPORTCRUISER · S/N C0598Built 2017 · Fracasso LeandroN2220MPilatus PC-12/47E · S/N 2002Built 2020 · Obsidian Leasing LLCN22XZBombardier BD-100-1A10 · S/N 20294Built 2010 · Saetta LLCN232ADDJI AGRAS T40 · S/N 64TBL5A00200Q7Avary Drone CorpN259AQDJI T40 · S/N 64TBL5H00200EHAvary DroneN259BTDJI T40 · S/N 64TBL5H00200H0Avary DroneN2987HSchweizer SGS 2-33A · S/N 559Sterling Flyers LLCN3038NPiper PA-28-181 · S/N 2843574N3038n LLCN312JEBombardier CL-600-2B16 · S/N 6131Built 2019 · Obsidian Leasing LLCN3140MKodiak KODIAK 100 · S/N 100-0326Obsidian Leasing LLCN3172SCessna 182G · S/N 18255672Sterling Flyers LLCN359JPDiamond Aircraft Ind DA20-C1 · S/N C0295Built 2004 · N359jp Aircraft Leasing LLCN366CAPiper PA-28-181 · S/N 2843135Built 1998 · Cavorite Aviation LLCN40670Piper PA-28-181 · S/N 28-7890007Built 1977 · Cavorite Aviation LLCN47BNPiper PA-28-181 · S/N 28-43020Built 1995 · Cavorite Aviation LLCN482DTPiper PA-28-181 · S/N 28-8490071Cavorite Aviation LLCN488PCTextron 525C · S/N 525C0347Built 2021 · Savory Aviation LLCN5103ACessna 172 · S/N 28103Winkelstein Aaron BN516NSPiper PA-44-180 · S/N 447995098Cavorite Aviation LLCN5355WCessna 172R · S/N 17281167Built 2003 · N5355w Partners LLCN555NREmbraer Executive EMB-505 · S/N 50500327Eagle Jet 300 LLCN5615WPiper PA-28-150 · S/N 28-755Built 1963 · H&H Aviation LLCN590DBDehavilland-Kenmore DHC-2 · S/N 1412Built 1959 · Admiralty Assets LLCN611SGPiper PA-23-250 · S/N 27-8054020Built 1979 · Rph Engineering LLCN6493FCessna 182P · S/N 18264202Built 1975 · Hatcher JessN75WCCessna 150M · S/N 15076045Cedar Valley Air LLCN7914DBeech H35 · S/N D-5198Built 1957 · Losee DanN818ELCirrus Design SR22T · S/N 10186Built 2024 · N22tq LLCN825ADPiper PA-46-600TP · S/N 4698022Built 2016 · Intrepid Aviation LLCN8342NPiper PA-28-181 · S/N 28-8190171Built 1981 · Hansen Derek JN8412TCessna 182B · S/N 52312Sterling Flyers LLCN845MADiamond Aircraft Ind DA 40 · S/N 40.345N845ma Aircraft Leasing LLCN8528TCessna 182C · S/N 52428Built 1959 · Lonni RasmussenN863CFCirrus Design SR22 · S/N 0191Built 2002 · Bpa Leasing LLCN86CPCirrus Design SF50 · S/N 0319Built 2021 · Flat Iron Aviation LLCN8786XCessna 182D · S/N 18253186Cedar Valley Air LLCN88078Bellanca 7KCAB · S/N 464-74Built 1974 · Khm Investments IncN888KGBombardier BD-100-1A10 · S/N 20402Built 2013 · N888kg LLCN92939Andrew E Dalrymple SONEX · S/N 0751Richins Landon DN953CTDiamond Aircraft Ind DA20-C1 · S/N C0053Built 1999 · Centerline Aviation IncN963WCPiper PA-28-181 · S/N 2843381Built 2000 · Cavorite Aviation LLCN970WCPiper PA-28-181 · S/N 2843522Built 2002 · Cavorite Aviation LLCN971WCPiper PA-28-181 · S/N 2843525Built 2002 · Cavorite Aviation LLC
Back to Lehi, UT