Park City, UT
Registered aircraft · 119
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 = 'PARK 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 = 'PARK 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.
N100GXIsrael Aircraft Industries GULFSTREAM G150 · S/N 228N100MTCessna 340A · S/N 340A0957N10111Columbia Aircraft Mfg LC41-550FG · S/N 41739N1020XPainter George L SONEX AEROVEE · S/N 1020N102EZCorbeil Shawn KITFOX S-7A · S/N S7A040458N105SSBalony Kubicek Spol Sro BB30XR · S/N 983N107PJPilatus PC-24 · S/N 107N1171GMooney M20K · S/N 25-0706N11TKThompson James/Katz Andres LANCAIR EVOLUTION · S/N EVO-006N120RTCameron Balloons US A-120 · S/N 6662N120WTBeech A36TC · S/N EA-99N122KCCampbell Kenneth R LONG-EZ · S/N 2105-LN124PHCessna 172N · S/N 17268084N125WPW L Peers TITAN MUSTANG T-51 · S/N M07XXXCOHK0125N135BEBeech V35B · S/N D-9524N1372ECessna 172N · S/N 17270974N13BLBeech A36 · S/N E-724N13UPWaco Classic YMF-F5C · S/N F5C-8-144N161RWWynn Richard AVID MAGNUM · S/N 53MN179EPAerovodochody L-29 DELFIN · S/N 591699N17WDDavis JR William R RV-4 · S/N 739N18XRBalony Kubicek Spol Sro BB22XR · S/N 1423N190BMCirrus Design SR20 · S/N 9381N222HMMooney M20M · S/N 27-0183N2454GCessna 182T · S/N 18281725First renewal noticeN247MMPiper PA-28-235 · S/N 28-7310132Sale reportedN2561RCessna 182K · S/N 18258261N272MRM&D Flugzeugbau JS-MD 3 RES · S/N 3.MD239N308JGGeiger William G CCK-1865 · S/N CCK-1865-1055N310EGCessna 525B · S/N 525B0067N31120Whisenand RV-3 · S/N 126N314CASchempp-Hirth VENTUS-B · S/N 67N3162SCessna 182G · S/N 18255662N325PEBombardier BD-100-1A10 · S/N 20409N329DLClydesdale Asset Mgmt CCX-2000 · S/N CCX-2000-0210N3318BPiper PA-22-135 · S/N 22-2133N33NXPilatus PC-12/47E · S/N 1733N33VCDassault FALCON 2000EX · S/N 387N341EAPipistrel D O O SINUS 912 · S/N 1247 SFNM 912 LSAN34SPStephen J Pollard GLASTAR · S/N 5118N356GEmbraer Executive EMB-505 · S/N 50500676N357WSDg-Flugzeugbau DG-808 C · S/N 8-416B315Z5N359FCPilatus PC-12/47E · S/N 1483N359FGYakovlev YAK-50 · S/N 842305N35WPCirrus Design SR22T · S/N 10990N38687Piper PA-11 · S/N 7195N400KCessna A185F · S/N 18503889N408KATextron 408 · S/N 408-0009N409LTPilatus PC-12 · S/N 1091N448SJCessna 510 · S/N 510-0448
Back to Park City, UT