Sandy Valley, NV
Registered aircraft · 39
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 = 'NV' AND g.registrant_city = 'SANDY VALLEY' 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 = 'NV' AND g.registrant_city = 'SANDY VALLEY' 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.
N113DTGough Alan GOUGH RV6A · S/N 25479N134LSRemos G-3/600 · S/N 215N142ZBMoravan N P Ortrokovice Z142 · S/N 0411N1634MBoeing A75N1(PT17) · S/N 75-7206N21990Cessna 150L · S/N 15074594N2313UCessna 172D · S/N 17249913N2401BPiper PA-38-112 · S/N 38-79A0045N2566CCessna 170B · S/N 26207N27AAAndersen Allen Edward STARDUSTER TOO SA300 · S/N 1001N28558Grumman American Avn. AA-5B · S/N AA5B0681N2875SCessna 150G · S/N 15066775N28PCAero Commander 200D · S/N 377N3257NJenkins Eugene Chad WAG A BOND PA-17 · S/N 1261N33880Schweizer SGS 1-26E · S/N 620N35565Cessna 172I · S/N 17256839N357ECirrus Design SR22 · S/N 0650N3636SCessna 172E · S/N 17250836N3864KTemco GC-1B · S/N 3564N5244GCessna 310E · S/N 310M0026N5678QMooney M20E · S/N 695N5788XCessna 320 · S/N 320-0088N579LPPipistrel D O O SINUS 912 · S/N 1237 SFM 912 LSAN606DCCzapla Douglas K LANCAIR LEGACY · S/N L2K-154N6300NChampion 7KCAB · S/N 19N631DMAmerican Champion 7GCBC · S/N 1355-2003N659DAero Adventure AVENTURA HP · S/N AAHP0022N7258FPiper PA-28-140 · S/N 28-25177N78082Globe GC-1B · S/N 2082N7859CKeleher LARK · S/N JK-1N7915BCessna 172 · S/N 29715N7961KBeech 35-B33 · S/N CD-775N8114BCessna 172 · S/N 29914N8245VCessna 180H · S/N 18051747N8298Belk DER JAGER D IX · S/N 017N84025Aeronca 7AC · S/N 7AC-2712N8608RSchweizer SGS 1-26A · S/N 128N9520VMooney M10 · S/N 700010N95641Taylorcraft BC12-D · S/N 7941N97LVIzatt Ron G NEVADA FLYER · S/N 101
Back to Sandy Valley, NV