North Salt Lake, UT
Registered aircraft · 1,667
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 = 'NORTH SALT LAKE' 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 = 'NORTH SALT LAKE' 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.
N100BDBombardier BD-700-2A12 · S/N 70234N100HBGulfstream Aerospace GV-SP (G550) · S/N 5137N100LABombardier BD-700-1A11 · S/N 9321N100PETextron 680 · S/N 680-0580N100RPBombardier BD-700-1A10 · S/N 9450N100WXEmbraer-Empresa Brasileira De EMB-500 · S/N 50000037N100XSGulfstream Aerospace GV-SP (G550) · S/N 5376N100XVCanadair CL-600-2B16 · S/N 5320N10100Gulfstream Aerospace GVI (G650ER) · S/N 6514N10180Construcciones Aeronauticas CN-235-300 · S/N C139N1018PDehavilland BEAVER DHC-2 · S/N 1133N10199Gulfstream Aerospace GVII-G600 · S/N 73021N101KQQuest KODIAK 100 · S/N 100-0101N101SSLearjet 60 · S/N 161N101WJCessna 525A · S/N 525A0151N102AEBell Helicopter Textron Canada 407 · S/N 54721N102FTGulfstream Aerospace GV-SP (G550) · S/N 5532N103SWBombardier BD-700-1A10 · S/N 9129N103WGBombardier BD-700-2A12 · S/N 70213N1040NAirbus S A S A340-642 · S/N 1040N104AEBell Helicopter Textron Canada 407 · S/N 54733N104ARGulfstream Aerospace GVII-G500 · S/N 72123N104DABombardier BD-700-1A10 · S/N 9266N104MDConstrucciones Aeronauticas CN-235-300 · S/N C135N10566Gulfstream Aerospace GIV-X (G450) · S/N 4267N10666Gulfstream Aerospace GV-SP (G550) · S/N 5404N106ANCessna 208B · S/N 208B0917N106GRAirbus Helicopters EC 130 T2 · S/N 9634N1073PEmbraer S A ERJ 190-200 IGW · S/N 19000107N108DBGulfstream Aerospace GVII-G600 · S/N 73008N108GRBell Textron Canada 407 · S/N 56489N109BMAgusta A109E · S/N 11157Registration pendingN109BTAgusta A109S · S/N 22055N10VWCompagnie Daher TBM 700 · S/N 1454N1103SSikorsky S-76D · S/N 761016N1111PGulfstream Aerospace G-V · S/N 536N1112BTextron B300 · S/N FL-1112N111UBGulfstream Aerospace GVI (G650ER) · S/N 6393N1129GCessna 208B · S/N 208B0924N113AHAirbus Helicopters MBB-BK 117 C-2 · S/N 9858N113WAEmbraer EMB-110P1 · S/N 110 205N1154FCessna 208B · S/N 208B1065N115DRAirbus Helicopters AS350B3 · S/N 9724N115LRGulfstream Aerospace GIV-X (G450) · S/N 4331N115RTAgustawestland AW139 · S/N 31458N115WAEmbraer EMB-110P1 · S/N 110451N116MBCessna 650 · S/N 650-7081N116WAEmbraer EMB-110P1 · S/N 110.399N117ALGulfstream Aerospace GVI (G650ER) · S/N 6350N117MKEurocopter Deutschland MBB-BK 117-B2 · S/N 7196
Back to North Salt Lake, UT