OpenAirDocs.org
Hermiston, OR

Registered aircraft · 51

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 = 'HERMISTON'
  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.

N1424JRockwell International 112A · S/N 424Built 1975 · Duwelius Sue DBAN155PFPedro CCX-2300 · S/N CCX-2300-0052Pedro Aviation LLCN159AFAmerican Champion 8GCBC · S/N 413-2000Built 2000 · Morter Roger PN1647FCessna 172H · S/N 17255042Built 1966 · Blue Sky Rentals LLCN178RVVogt Raymond J CHALLENGER II · S/N CH2 0488 B 0302Built 1997 · Vogt Raymond JN179RAAmerican Champion 7GCBC · S/N 1352-2003Built 2004 · Morter Roger PN187YMHughes 369A · S/N 691183Brown Byron TimN1960YMooney M20D · S/N 225Built 1964 · White Duwayne FN200LAAir Tractor AT-802A · S/N 802A-0292Built 2008 · Asap Flying Service IncN223RSEnstrom F-28F · S/N 748Built 1987 · Jsh Farms IncN228PMCostruzioni Aeronautiche Tecna P2010 TDI · S/N 160/USBuilt 2021 · Gray Kevin J TrusteeN2452FCessna 180H · S/N 18051654Built 1966 · Pesicka Theodore JN251ZCessna 195 · S/N 7842Built 1952 · Watkinds Steven GN2841ZPiper PA-22-150 · S/N 22-6836Built 1959 · Van Ryn William CN3045HThrush S2R-T34 · S/N T34-411Built 2013 · Pesicka Theodore JN315TBTurnbull Thomas G VANS AIRCRAFTS RV-7A · S/N 70582Built 2010 · Burns Daniel FN351LUDJI AGRAS T30 · S/N 527BK5C001004MAsap Flying Service IncN354BWBeech A36TC · S/N EA-40Built 1979 · Carpenter Richard AN36KBeech 95-B55 (T42A) · S/N TC-1299Hermiston Aviation IncN39690Piper PA-32RT-300T · S/N 32R-7887145Built 1978 · Basin Ag Imaging LLCN3989GCessna U206C · S/N U206-0989Jsh Farms IncN399CCCub Crafters CC11-100 · S/N CC11-00086Built 2009 · Eagle River Ranch LLCN4053VPowrachute PEGASUS · S/N A361PEGBuilt 2005 · Carroll Larry DN40586Noerring Gary O RANS S-6-ES · S/N 0193426Built 2003 · Stanley Bobby EN4534RPiper PA-28-140 · S/N 28-21238Built 1965 · Duwelius Charlotte Sue DBAN4641BCessna 180 · S/N 31539Built 1955 · Key James MN477DKAviat A-1B · S/N 2160Philippi Ranches IncN49AYCessna P337H · S/N P3370303Lopez FernandoN50SCRonald Osgood/Robert Meharry GLASAIR II S · S/N 2061Meharry RobertN52554Cessna 182P · S/N 18262672Built 1973 · Hermiston Aviation IncN529HEnstrom Helicopter 280C · S/N 1042Built 1976 · Jsh Farms IncN602EAir Tractor AT-602 · S/N 602-0486Built 1998 · Asap Flying Service IncN6126VBeech 35-C33 · S/N CD-859Ka Aviation LLCN615YMEavision EA-J150 · S/N JMZKJ150UAV602595758Mid Columbia Unmanned Ag Solutions LLCN66YCMooney M20M · S/N 27-0344Built 2005 · Watts LorenN68DLBeech H35 · S/N D-5118Asap Flying Service IncN69058Grumman G-44 · S/N 1291Built 1943 · Pesicka Theodore JN7306DPiper PA-22-150 · S/N 22-5093Built 1957 · J S H Farms IncN7592VCessna 177RG · S/N 177RG0883Built 1976 · Misener Richard HN797TECessna 550 · S/N 550-0962Built 2001 · N797te LLCN8044LCessna 172H · S/N 17256244Overton Larry DN822JLLeroux John F SPORTSMAN GS-2 · S/N 7396Built 2013 · Eagle River Ranch LLCN8292UCessna 172F · S/N 17252192Built 1964 · Rettkowski Brady AN83424Piper PA-18-150 · S/N 18-7609128Built 1976 · Carpenter Richard AN8394TCessna 175C · S/N 17557094Built 1962 · Burke Dennis EN8757HRyan NAVION · S/N NAV-4-757Ochoa AviationN884TMCessna 510 · S/N 510-0180Built 2009 · Fiesta Foods Of Oregon IncN8993DPiper PA-18A 150 · S/N 18-6397Built 1958 · Key James MN91509Cessna 182M · S/N 18259799Watts Timothy RN937DRCessna 172R · S/N 17280217Built 1997 · Stratton Michael C
Back to Hermiston, OR