Sandy, UT
Registered aircraft · 88
Aircraft may not be kept in the town where they are registered. This site does not publish street address information.
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 = 'SANDY' 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 = 'SANDY' 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.
N101AGSchempp-Hirth VENTUS BT · S/N 57N103JBDehavilland DHC-2 MK.I · S/N 1344N106ESCessna 172N · S/N 17272099N123EFDehavilland DHC-2 MK. I(L20A) · S/N 735N132CDCirrus Design SR22T · S/N 10703N1498MCessna 182P · S/N 18264353N1607CCessna 180 · S/N 30307N178LCTextron 560XL · S/N 560-6218N1860Cirrus Design SF50 · S/N 0263N198SCSix Chuter XT SSDC · S/N 3052N21369Cessna 182T · S/N 18281292N2223BPiper PA-28-181 · S/N 28-7990130N2259XCzech Sport PIPER SPORT · S/N P1001072N2397RCessna 182G · S/N 18255497N260PGAviat PITTS S-2B · S/N 5223N272MMCessna 172S · S/N 172S10105N275CDCirrus Design SR20 · S/N 1208N28277Gulfstream American AA-5B · S/N AA5B0992N287CPCirrus Design SR22 · S/N 3225N28MCPiper PA-28RT-201T · S/N 28R-7931271N2923QPiper PA-28-161 · S/N 28-7716124Registration pendingN2994TAero Commander 200D · S/N 367N3094QCessna 182K · S/N 18258094N3192SCessna 182G · S/N 18255692N326KBBeech F33A · S/N CE-422N338TPDehavilland BEAVER DHC-2 MK.1 · S/N 932N33PNLiam Freeman-Nave RANS S6-S · S/N 08031517-SN343APDassault FALCON 7X · S/N 265N344CRPiper PA-28 · S/N 28-153N3491QCessna 320E · S/N 320E-0091N365DGBombardier BD-700-2A12 · S/N 70248N3852WPiper PA-32-260 · S/N 32-792N396SCSixchuter West LEGEND XL · S/N 3190N397SXSchandel Sean M SONEX · S/N 0001N400PPPiper PA-24-400 · S/N 26-28N4265Spealman BRIEGLEB BG12-16 · S/N 221N450JFEmbraer-Empresa Brasileira De EMB-500 · S/N 50000184N4600YDehavilland BEAVER U-6A · S/N 993N4636BCessna 180 · S/N 31534N4637BCessna 180 · S/N 31535N490PDCirrus Design SR22T · S/N 2234N4FCDassault FALCON 2000EX · S/N 185N50THCessna T182 · S/N 18267759N516BAIcon A5 · S/N 00195N5212ECessna 172N · S/N 17271772N534GMPilatus PC-12/47E · S/N 1112N535BBPilatus PC-12/45 · S/N 596N540RSLee R/Lee S EAI BERKUT · S/N 049N56DZMichael Coney CCX-2000 · S/N CCX-2000-0187N582DWAvatar LLC/Ronald S Francis NWING SPRT X2 APACHE · S/N K1005
Back to Sandy, UT