OpenAirDocs.org
Nyssa, OR

Registered aircraft · 32

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 = 'OR' AND g.registrant_city = 'NYSSA'
  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.

N140DCessna 140 · S/N 8395Built 1946 · Conant StephenN20576Air Tractor AT-602 · S/N 602-1211Built 2012 · Bain Aviation IncN206DYCessna T206H · S/N T20608684Built 2006 · Morgan Farms LLCN2186APiper PA-20-135 · S/N 20-894Built 1952 · Conant Stephen AN224BEXag P100 PRO · S/N 1863FPEG8219425M65H0Branch Enterprises 7 IncN247HEDJI AGRAS T100 · S/N 1581F8ZLC258L002Q84WHelo Precision Spraying LLCN259QQDJI T40 · S/N 52BLK6Q001003FHelo Precision Spraying LLCN275BETta America M8A PRO 20L · S/N 008834Branch Enterprises 7 IncN2KAPiper PA-18-150 · S/N 18-7809116Built 1978 · Morinaka Noble JrN312JWDJI AGRAS T50 · S/N 63YBLB200200ADWbh Farms LLCN3186MPiper PA-12 · S/N 12-2013Kuenzli Casey IN320GREavision EA-J150 · S/N JMZKJ150UAV602595440Starlight Drones LLCN331VSDJI AGRAS T50 · S/N 63YBM4S0020063Curt Sisson Farms IncN3733BDJI AGRAS T50 · S/N 63YBLAQ002003KBallantyne Agricultural Services LLCN400DQAir Tractor AT-400A · S/N 301-0343Oregon Trail Air Service LLCN403RDDaniels Randall W KITFOX SERIES 57 · S/N S9703-0209Built 2004 · Franks MichaelN410BHDJI T50 · S/N 63YBM9B00200K7Helo Precision Spraying LLCN410CHDJI T50 · S/N 63YBM6200200FFHelo Precision Spraying LLCN415GErcoupe G · S/N 5052Built 1949 · Webber Gregory WN430UBDJI AGRAS T50 · S/N 63YBMAE0020056Wbh Farms LLCN4979BEavision EA-J150 · S/N JMZKJ150UAV602595083Ballantyne Agricultural Services LLCN532ZHDJI AGRAS T100 · S/N 1581F8ZLC258Q0024YSFHelo Precision Spraying LLCN541WBBair Bryan M VANS AIRCRAFT RV14A · S/N 140145Built 2019 · Bair Bryan MN585BEXag P100 · S/N 82182504V004Branch Enterprises 7 IncN599DPEavision EA-J150 · S/N JMZKJ150UAV602595311B & B Custom Spraying LLCN6484BEa Vision EA J100 · S/N EAVUAV502485363Ballantyne Agricultural Services LLCN649NBEavision EA-J150 · S/N JMZKJ150UAV602595455Branch Enterprises 7 IncN670GREavision EA-J150 · S/N JMZKJ150UAV602596057Ballantyne Agricultural Services LLCN83163Aeronca 7AC · S/N 7AC-1824Built 1946 · Whipple Kenneth GN954QADJI AGRAS T40 · S/N 64TBK7H001011ABallantyne BillN984CTNoble Morinaka VANS RV3 · S/N 11317Built 2021 · Morinaka NobleN9853Grumman Acft ENG Cor-Schweizer G-164A · S/N 1291Built 1974 · Oregon Trail Air Service LLC
Back to Nyssa, OR