Spanish Fork, UT
Registered aircraft · 75
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 = 'SPANISH FORK' 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 = 'SPANISH FORK' 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.
N11390Cessna LC41-550FG · S/N 411139N117WPOlandese Phillip J RANS S-6ES · S/N 01091916N121BTBell 206A · S/N 395N123TEADS PZL Warszawa-Okecie PZL-104MA WILGA 2000 · S/N 00060024N181DPPiper PA-28R-200 · S/N 28R-7335246N20666Cessna 172M · S/N 17261473N209NDDiamond Aircraft Ind DA20-C1 · S/N C0023N2123QCessna 177RG · S/N 177RG0523N220WMRobinson Helicopter R22 BETA · S/N 3815N221WMRobinson Helicopter R22 BETA · S/N 4285N225WMRobinson Helicopter R22 BETA · S/N 4109N227WMRobinson Helicopter R22 · S/N 4172N229WMRobinson Helicopter R22 BETA · S/N 4142N22LPPilatus PC-12/45 · S/N 402N242DSSpickes David E SPICKES RV-6 · S/N 001N2529PLancair LC41-550FG · S/N 41521N2680WMooney M20E · S/N 1001N2885YCessna 182E · S/N 18253885N28NERobinson Helicopter R22 BETA · S/N 3039N2994RPiper PA-28R-200 · S/N 28R-35386N3121QHughes 369HS · S/N 950768SN3297QRobinson Helicopter R44 II · S/N 10178N332MEMcclatchy Warren G HIGHLANDER · S/N JAESC0055N335SCCzech Sport Aircraft A S SPORTCRUISER · S/N C0639N340WHCessna 340 · S/N 340-0366N373KMPilatus PC-12/45 · S/N 373N3849DCessna 182A · S/N 34549N4391QCessna 172L · S/N 17260291N43EXJason Sneed CCK-1865 · S/N CCK-1865-1019N453DSDiamond Aircraft Ind DA 40 · S/N 40.1123N476RXLeading Edge Aerial Tech PV40X · S/N 11363N47869Piper PA-28R-201 · S/N 28R-7837008N496RXLeading Edge Aerial Tech PV40X · S/N 11443N504SMTapestry Entertainment EPIC LT · S/N 041N505UCUtah County Sheriff CCX-2000 · S/N CCX-2000-0130N52255Cessna 182P · S/N 18262488N5239ZPiper PA-22-108 · S/N 22-8919N52877Cessna 172P · S/N 17274626N5306TAerostar International RXS-8 · S/N RXS8-3110N530FFHughes Helicopters 369FF · S/N 0050FFN544ABRobinson Helicopter R44 II · S/N 10048N5525LCessna T240 · S/N T24002039N589CBeech F33A · S/N CE-1224N6024UBeech 95-B55 (T42A) · S/N TC-2210N603CPCirrus Design SR22 · S/N 3361N6338ECessna 172 · S/N 46438N6430QMooney M20F · S/N 670509N663CVFruit Clinton R ONEX · S/N ONX0091N6967KPiper PA-20 · S/N 20-71N704GRCessna 150M · S/N 15078604First renewal notice
Back to Spanish Fork, UT