OpenAirDocs.org
Medford, OR

Registered aircraft · 199

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

N1107HPiper PA-28-151 · S/N 28-7715308Built 1977 · Shurtz William W JrN1131KColumbia Aircraft Mfg LC41-550FG · S/N 41742Built 2007 · First Properties LLCN11962Cessna 150L · S/N 15075740Built 1974 · Aeroleasing IncN119MFBell Helicopter Textron Canada 407 · S/N 54550Built 2014 · Mercy Flights IncN121MFTextron C90GTI · S/N LJ-2144Mercy Flights IncN126MMRaytheon C90A · S/N LJ-1669Built 2002 · Freeman Holdings Of West Texas LLCN1288DCessna 170A · S/N 19861Built 1951 · Conner Brent FN134RSShick Robert L JR RV-4 · S/N 49Built 1986 · Rosborough Todd DN1385LCessna T337H · S/N 33701877Built 1978 · Whiskey River Aviation LLCN142AVRobinson Helicopter R44 II · S/N 14776Built 2024 · Straight Up Leasing IncN144DEEngh Duncan C RV-7A · S/N 01Built 2010 · Schlosser Robert AnthonyN149MFTextron C90GTI · S/N LJ-2151Built 2018 · Mercy Flights IncN150NVCessna 150H · S/N 15069140Built 1968 · Altom Chase SN1520KKuntz Mark T QUICKSILVER SPRT 2-S · S/N 2864Built 2022 · Tomaszewski KyleN152ULNorth Wing Ultralight Products APACHE SPORT · S/N 35196Built 2003 · Benson Howard RN1539CCirrus Design SR22 · S/N 0545Built 2003 · Marincus Benjamin MariusN155SRCirrus Design SR22 · S/N 1924Built 2006 · Smedley Charles AN1630YCessna 172C · S/N 17249330Built 1962 · Hart Gregory DN16KPJihlavan Airplanes Sro KP 5 ASA · S/N 5113131KBuilt 2005 · Schatz MarkN16XLChaplin Raymond ZODIAC 601XL · S/N 6-5729Built 2006 · Plax PierreN174EMBell Textron Canada 429 · S/N 57387Built 2020 · West States Leasing IncN1856ECessna T310R · S/N 310R1591Built 1979 · Gv Air IncN1894GChampion 7ECA · S/N 610Built 1968 · Weyhe Joel JN18ABeech F33A · S/N CE-629Wayman Ian AN191SCSix Chuter LEGEND P103 · S/N 3068Built 2007 · Bartholomew John DavisN207MDPiper PA-31-325 · S/N 31-7612092Built 1976 · Gv Air IncN224CFCirrus Design SR22 · S/N 2926Titan Land Company LLCN224TFCessna T182T · S/N T18208906Built 2008 · Cdtskyview LLCN226TPiper PA-18 105 · S/N 18-2340Built 1953 · Mcallister HunterN2291PPiper PA-23 · S/N 23-902Built 1957 · Nice Flight LLCN2303RCessna 182G · S/N 18255403Built 1964 · Rosborough Todd DN2399FCessna 210E · S/N 21058599Built 1965 · Jordan Danny LN241MPCessna T206H · S/N T20609035Built 2011 · Gv Air IncN242SDTextron 525 · S/N 525-1069Built 2020 · Binette AlanN242WWayman Daniel CHRISTEN EAGLE II · S/N DMACDW 1Wayman Daniel MN2468YCessna T206H · S/N T20609005Built 2011 · Gv Air IncN247HCorben Baby Ace D · S/N JJV1Built 1966 · Ryder Teddy AN2508YCessna 172D · S/N 17249808Warren Jerry LN250BWCirrus Design SR22T · S/N 1992Built 2019 · Hawk Aviation LLCN257BBVans RV-12 · S/N 120428Built 2012 · Warner William SN257CKCirrus Design SF50 · S/N 0541Built 2024 · Straight Up Leasing IncN2618APiper PA-22-135 · S/N 22-902Levin HenryN26370Cessna 310R · S/N 310R1659Built 1979 · Gv Air IncN26655Grumman American Avn. AA-5A · S/N AA5A0623Built 1978 · Weyhe Joan MonicaN274HSBeech V35B · S/N D-9922Built 1976 · Webb Alan JN2800SCessna 150G · S/N 15066700Built 1967 · Simpson Gavin JN281AWWebb Alan HARMON ROCKET II · S/N 256Webb Alan JN283CUPilatus PC-12/47E · S/N 1283Built 2011 · Shoreline Assets LLCN2917LMooney M20F · S/N 670311Built 1967 · Dobbs J SN2927UCessna 172D · S/N 17250527Built 1963 · Carlson Brent A
Back to Medford, OR