Elko, NV
Registered aircraft · 61
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 = 'ELKO' 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 = 'ELKO' 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.
N10AJBell 206B · S/N 3169N1101MSummit RANS S-7S · S/N 0111551N11XSPrange Douglas KOLB TWNSTR MARK III · S/N M3-231N1291NCessna LC41-550FG · S/N 411128N134JHHarmon John M RV-4 · S/N 937N172WECessna 172M · S/N 17265192N2248LBeech C23 · S/N M-1895N2378GCessna 182B · S/N 51678N2518CFaulkner William L 162F ROTORWAY · S/N 6376N2551YQuad City Ultralight Acft CHALLENGER II · S/N CH2-1100-2028N258TPiper PA-18-105 SPECIAL · S/N 18-2372N27PSStevens Peter STEVENS BEARHAWK · S/N 11/12-566N2928YCessna 182E · S/N 18253928N314TEclipse EA500 · S/N 000015N319RJMatthew J Stramel VANS RV-6 · S/N 20622N356VCTextron B300 · S/N FL-1304N35859Cessna U206F · S/N U20602763N382USAviat A-1C-200 · S/N 3082N4011VCessna 170 · S/N 18330N4141YBellanca 7ECA · S/N 1179-76N4149JPiper PA-28-140 · S/N 28-22474N4384XPiper PA-32-300 · S/N 32-7540123N4569HMooney M20J · S/N 24-0849N464GSCessna U206G · S/N U20604744N4650PPiper PA-23-250 · S/N 27-173N5028GBellanca 8KCAB · S/N 574-79N5099JTompkins Daniel M MARK 4 AVID · S/N 1032DN509DHHarold Stockman RANS S-7S · S/N 0116626N510DHHarold O Stockman BADLANDS VAQUERO · S/N 010N5258PPiper PA-24-250 · S/N 24-290N5290SLongpre Howard RANS S-7 COURIER · S/N 0693112N5292NCessna 182Q · S/N 18267624N545DMBoden Dennis H RANS S-6S · S/N 06061754-SN555PPBell 206B · S/N 4021N577CMPiper PA-18-150 · S/N 18-7709134N580MBirney M/Million S RV-6 · S/N 24580N6063KCessna T206H · S/N T20608650N6434WPiper PA-28-140 · S/N 28-20504N7193PPiper PA-24-250 · S/N 24-2363N7299NCessna 182P · S/N 18263086N74730Robinson Helicopter R44 II · S/N 10888N750WZWood Robert STOL CH 750 · S/N 75-8193N7512NRobinson Helicopter R44 II · S/N 10131N7625PPiper PA-24-250 · S/N 24-2836N829LWLewis W Wilcox CABINEAGLE · S/N 1311928N8359TCessna 175C · S/N 17557059N83GSRasmussen Wesley GLASTAR · S/N 001N84RLKnight Roger E BD-4 · S/N 84N86DZZahtilla Dirk L J6 KARATOO · S/N 12312N9115BCessna 172 · S/N 36615
Back to Elko, NV