Springville, UT
Registered aircraft · 24
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 = 'SPRINGVILLE' 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 = 'SPRINGVILLE' 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.
N167DCDiamond Aircraft Ind DA20-C1 · S/N C0167N18307Beech V35B · S/N D-10038N2215GMesserschmitt-Boklow Blohm BO 105 P-1 · S/N 6066N242ARVans RV-12IS · S/N 12191N247KDEurocopter EC 130 T2 · S/N 7758N2495MPiper PA-28R-201 · S/N 28R-7837090N2672SCessna T337C · S/N 337-0972N357DRTextron T206H · S/N T20609590N454RMFreedom Air EPIC LT · S/N 111N45GVCessna R172K · S/N R1722204N48HYAviat A-1B · S/N 2196N48PKQuenzler P W/Frey K H GLASTAR · S/N 5382N51732Cessna 182T · S/N 18281088N531CACessna R172K · S/N R1722675N54RSDalton Bart VANS RV4 · S/N 633N5963WPiper PA-28-140 · S/N 28-24780N6105JCessna T206H · S/N T20608813N66753Cessna 150M · S/N 15076252N716USCameron Balloons Z-90 · S/N 6332N74231Bellanca 14-13 · S/N 1344N7570TPiper J3C-65 · S/N 7570N89XCSasquatch CCX-2300 · S/N CCX-2300-0097N943CBTextron 525B · S/N 525B0723N9598HCessna 172M · S/N 17266256
Back to Springville, UT