Draper, UT
Registered aircraft · 62
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 = 'DRAPER' 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 = 'DRAPER' 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.
N100UVDiamond Aircraft Ind DA 40 · S/N 40.405N104XPSchmidt Scott M RV-10 · S/N 40111N137EDSchleicher ASW-27 · S/N 27102N14CNZetting Douglas H VANS RV-14A · S/N 140341N15289Piper PA-28R-200 · S/N 28R-7335046N155JHAmerican Champion 8GCBC · S/N 562-2014N169RLeonardo AW169 · S/N 69009N17LXGTJ Investments LX7-20 · S/N LIV-351N203MHHotchkiss Matthew A RV-7 · S/N 73191N228ZCirrus Design SR22T · S/N 2241N22BPEpic E1000 · S/N K086N230CSCessna T240 · S/N T24002005N2564HGunnoe James E JR LASER · S/N 002N314SPRed Raven CCX-2300 · S/N CCX-2300-0102N31CRPiper PA-31-350 · S/N 31-8152011N331FZExtra Flugzeugproduktions EA 300/SC · S/N SC069N3588MPiper PA-28R-201T · S/N 28R-7803180N40CBBurnett Forrest H RV6A · S/N 22105N40RZPiper PA 46-350P · S/N 4636009N424HPPierce Henry E SKYBOLT · S/N 24N435LMangos Voladores M16 XTREME · S/N 16234546N45AFCessna 501 · S/N 5010284N480BRBeech B200 · S/N BB1355N503LMRaytheon B300 · S/N FL-182N504CASchweizer SGS 1-26E · S/N 595N507MCCirrus Design SR22 · S/N 3389N5551PPiper PA-24-250 · S/N 24-616N56824Piper PA-32-300 · S/N 32-7440029N56QCBenoit Leclair RANS S-7S · S/N 0215610N5723WPiper PA-28-160 · S/N 28-1281N5790QMooney M20C · S/N 3097N582TCCessna 182T · S/N 18281550N5915BCessna 182A · S/N 33915N603SBPitts Aerobatics S-2B · S/N 5035N6080FCessna 182P · S/N 18264095N6114NBeech B23 · S/N M-1200N629LEMax S Cloward/Elaine Cloward RV-7A · S/N 71170N62WLGunn David A ZODIAC 601 · S/N 62246N649RVUrban Rudolf S RV-6 · S/N 24127N6672BBeech A36 · S/N E-1584N66784Beech A36TC · S/N EA-34N697ZBolkow PHOEBUS A-1 · S/N 727N708TMVans RV-12IS · S/N 121321N716KPatterson Kelly J VANS RV-6A · S/N 22372N732DQCessna T210L · S/N 21061437N7638PPiper PA-24-180 · S/N 24-2850N77UNSchleicher ASW-27 · S/N 27186N780MMTrike Industries CCK-2000 · S/N CCK-2000-0043N7946PPiper PA-24 · S/N 24-3182N797VSchleicher ASW-27 · S/N 27145
Back to Draper, UT