Logan, UT
Registered aircraft · 129
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 = 'LOGAN' 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 = 'LOGAN' 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.
N100LETextron 172S · S/N 172S13000N101LELet L-23 SUPER BLANIK · S/N 907601N1133Piper PA-18-135 · S/N 18-3558N11737Monocoupe 90A · S/N A664N11741Universal Moulded Products MONOCOUPE 90A · S/N A-670N118GMDiamond Aircraft Ind DA 40 · S/N 40.521N118NGPilatus PC-12/47E · S/N 1833N127KCDiamond Aircraft Ind DA 40 · S/N 40.1127N132MHRobinson Helicopter R22 BETA · S/N 3648N132TSDiamond Aircraft Ind DA 42 · S/N 42.AC018N13DADiamond Aircraft Ind DA 40 · S/N 40.1210N1446UCcx-1865 CCX-1865 · S/N CCX-1865-2004N146ZBeech 58P · S/N TJ-426N155UDiamond Aircraft Ind DA 40 · S/N 40.1251N156UDiamond Aircraft Ind DA 40 · S/N 40.1252N157UDiamond Aircraft Ind DA 40 · S/N 40.1253N158UDiamond Aircraft Ind DA 40 · S/N 40.1254N159UDiamond Aircraft Ind DA 40 · S/N 40.1255N15CVEmbraer S A EMB-545 · S/N 55010155N1632MCessna 182P · S/N 18264398N168CBCessna 172S · S/N 172S9119N1707SDiamond Aircraft Ind DA 40 · S/N 40.509N170HPBeech F33A · S/N CE-615N185EZSmith K C/Widauf D P RUTAN LONG-EZ · S/N 1408N194TSDiamond Aircraft Ind DA 40 · S/N 40.972N204LCRobinson Helicopter R44 II · S/N 10248N21257Cessna 182P · S/N 18261521N229TXCirrus Design SR22T · S/N 0076N230DCDiamond Aircraft Ind DA 40 · S/N 40.966N239DCDiamond Aircraft Ind DA 40 · S/N 40.968N239PCessna 172S · S/N 172S9613N240TSDiamond Aircraft Ind DA 42 · S/N 42.072N246PACessna 182J · S/N 18257487N2474YCessna 172S · S/N 172S10083N247ACirrus Design SR22T · S/N 2326N25324Piper PA46-500TP · S/N 4697519N2544TLancair LC41-550FG · S/N 41072N261KAFoxair KITFOX LIGHT SPORT · S/N KA12083226N26524Magruder Charles L J 6 KARATOO · S/N 001997N274KTPiper PA-46-600TP · S/N 4698036N275CHHarris Charles R Q-200 · S/N 2759N28HWCirrus Design SR22T · S/N 8663N3035FRobinson Helicopter R22 BETA · S/N 4169N3133VCessna 150M · S/N 15076396N321FSDiamond Aircraft Ind DA 40 · S/N 40.384N330DDRobinson Helicopter R22 BETA · S/N 3401N344AFDiamond Aircraft Ind DA 40 · S/N 40.1044N350TSDiamond Aircraft Ind DA 42 · S/N 42.061N35232Buckeye Industries DREAM MACHINE · S/N 4501N3823XCessna 310K · S/N 310K0223Registration pending
Back to Logan, UT