Salt Lake City, UT
Registered aircraft · 2,922
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 = 'SALT LAKE CITY' 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 = 'SALT LAKE CITY' 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.
N100ZTTextron 525C · S/N 525C0392N1012PMooney M20R · S/N 29-0249N101DUC Series Aircraft Ltd Ptnrsp BD-500-1A10 · S/N 50020N101NYGulfstream Aerospace GIV-X (G450) · S/N 4221N102DUC Series Aircraft Ltd Ptnrsp BD-500-1A10 · S/N 50021N102NNAirbus A321-231 · S/N 5860N102NYGulfstream Aerospace GIV-X (G450) · S/N 4230N102UWAirbus Industrie A320-214 · S/N 0844N102XXAero L-39 ALBATROS · S/N 040002N103DYAirbus A321-211 · S/N 9538N103KFCessna 172S · S/N 172S8143N103USAirbus Industrie A320-214 · S/N 0861N104DNAirbus A321-211 · S/N 10009N104NNAirbus A321-231 · S/N 5895N104QTDassault FALCON 2000EX · S/N 018N104UWAirbus Industrie A320-214 · S/N 0863N105DUC Series Aircraft Ltd Ptnrsp BD-500-1A10 · S/N 50024N105DXAirbus A321-211 · S/N 10030N105GKMesserschmitt-Boelkow-Blohm BO-105S · S/N S-458N105HStart & Flug H101 "SALTO" · S/N 15N105JSBoeing 737-8 · S/N 43709N105NNAirbus A321-231 · S/N 5904N105TPAir Tractor AT-502A · S/N 502A-3352N105UWAirbus Industrie A320-214 · S/N 0868N105ZTCameron Balloons US Z-105 · S/N 6566N106DNAirbus A321-211 · S/N 10088N106DUC Series Aircraft Ltd Ptnrsp BD-500-1A10 · S/N 50025N106NNAirbus Industrie A321-231 · S/N 5932N106XXAero Vodochody L-39MS · S/N 140006N1073WBell 214B-1 · S/N 28012N1078NBell Helicopter Textron 206L-1 · S/N 45389N107AVCessna 750 · S/N 750-0107N107DNAirbus A321-211 · S/N 9582N107DUC Series Aircraft Ltd Ptnrsp BD-500-1A10 · S/N 50026N107NNAirbus Industrie A321-231 · S/N 5938N108DQC Series Aircraft Ltd Ptnrsp BD-500-1A10 · S/N 50027N109DUC Series Aircraft Ltd Ptnrsp BD-500-1A10 · S/N 50028N109JSBoeing 737-8 · S/N 43712N109NNAirbus Industrie A321-231 · S/N 5955N10EHBombardier BD-100-1A10 · S/N 20810N10GFHawker Beechcraft C90GTI · S/N LJ-1970N10TFAir Tractor AT-602 · S/N 602-1217N10XGGulfstream Aerospace GV-SP (G550) · S/N 5186N110CCBeech V35 · S/N D-8339N110DUC Series Aircraft Ltd Ptnrsp BD-500-1A10 · S/N 50029N110GDRaytheon HAWKER 800XP · S/N 258713N110HAIsrael Aircraft Industries GULFSTREAM 200 · S/N 035N110JSBoeing 737-8 · S/N 43755N111FNGates Learjet 25D · S/N 293N111GECessna 525 · S/N 525-0661
Back to Salt Lake City, UT