Logan, UT
Registered aircraft · 130
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.
N383PSDiamond Aircraft Ind DA40 F · S/N 40.FC021N384CADiamond Aircraft Ind DA 40 · S/N 40.734N392SCSix Chuter West LEGEND XL · S/N 3178N400NKTextron 525C · S/N 525C0404N4097Mooney M-18LA · S/N 134N4138GRobinson Helicopter R22 BETA · S/N 4275N415AMDiamond Aircraft Ind DA 40 · S/N 40.517N4169KRyan NAVION · S/N NAV-4-1169N416FPDiamond Aircraft Ind DA40 F · S/N 40.FC016N416SMPiper PA-18-150 · S/N 18-8109061N417FPDiamond Aircraft Ind DA40 F · S/N 40.FC017N4183FCessna 172 · S/N 46083First renewal noticeN418FPDiamond Aircraft Ind DA40 F · S/N 40.FC018N422FPDiamond Aircraft Ind DA40 F · S/N 40.FC022N422KHartline J Bon HARTLINE KITFOX III · S/N 1000N423FPDiamond Aircraft Ind DA40 F · S/N 40.FC023N424FPDiamond Aircraft Ind DA40 F · S/N 40.FC024N425FPDiamond Aircraft Ind DA40 F · S/N 40.FC025N425KGKian Ben Jacob RV-14A · S/N 140776N434DDRobinson Helicopter R22 BETA · S/N 3182N442KPRobinson Helicopter R44 II · S/N 10862N442THRobinson Helicopter R44 II · S/N 11619N444CRRobinson Helicopter R22 · S/N 4578N448USDiamond Aircraft Ind DA 40 · S/N 40.708N44PVLarsen Charles Bennett PHOENIX VENDETTA LS · S/N 0051PVN451DSDiamond Aircraft Ind DA 40 · S/N 40.1136N459TSDiamond Aircraft Ind DA 42 · S/N 42.AC059N513ABJonathan Decker SLING TSI · S/N 613SKN536AAAmerican FALCON XP · S/N 600159N5380BCessna 182 · S/N 33380N543JWDiamond Aircraft Ind DA 40 · S/N 40.358N545BWBrad Wursten MX2 · S/N MX2-003N545EAMXR Technologies MXS · S/N 9N560RHCessna 560 · S/N 560-0773N57RJCirrus Design SR22 · S/N 4382N6006CCessna R182 · S/N R18200347N605CADiamond Aircraft Ind DA 40 · S/N 40.911N6122KCessna 150M · S/N 15077536N616MLDiamond Aircraft Ind DA 40 · S/N 40.1067N619THCessna 172S · S/N 172S10343N6513UMooney M20C · S/N 2267N66XEHerbert James J RV6A · S/N 60591N6706TCessna 310C · S/N 39006First renewal noticeN67508Cessna 152 · S/N 15281877N67CFRobinson Helicopter R66 · S/N 0339N6802MCessna 182P · S/N 18263845N700AWMaule M-7-235 · S/N 4032-CN704PADiamond Aircraft Ind DA 40 · S/N 40.704N711TVBeech S35 · S/N D-7931N712PADiamond Aircraft Ind DA 40 · S/N 40.912
Back to Logan, UT