OpenAirDocs.org
The Dalles, OR

Registered aircraft · 41

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 = 'THE DALLES'
  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.

N1313YCessna 172C · S/N 17249013Built 1962 · Sullivan Shawn MN1392YCessna 172C · S/N 17249092Built 1961 · Doty Douglas CN1521RGrumman American Avn. AA-5B · S/N AA5B-0021Built 1975 · Perkins J R IIIN15570Air Tractor AT-402 · S/N 402-0884Built 1992 · Shearer Sprayers IncN175HAHiller UH-12E · S/N HA3075Built 1978 · Shearer JohnN200EMDoyle Timothy VANS RV-9A · S/N 90199Built 2005 · Haines ErinN2032ZCessna 150C · S/N 15059832Built 1963 · Pointer Ned AN2383PPiper PA-22-150 · S/N 22-2774Built 1955 · Jkr7 LLCN23KXCub Crafters CC11-100 · S/N CC11-00082Built 2008 · Kortge RichN263LPCessna 182Q · S/N 18265959Markman William JN2652VCessna 177RG · S/N 177RG0644Built 1974 · Trapp Terry Lee TrusteeN2723LCessna 172H · S/N 17255923Built 1967 · Jkr7 LLCN31779Airframes Unlimited SS-2 · S/N AUNW013Built 2005 · Vance Dennis LN3254GBeech A36 · S/N E-2954Built 1995 · Edling Tyrell RN3312GAlexander Schleicher ASH 31 MI · S/N 31190Seim Thomas AN3330FCessna 182J · S/N 18257330Emk Trans LLCN3368UCessna 182F · S/N 18254768Built 1963 · Zeigler Ryan CN4010FCessna 172 · S/N 36910Built 1958 · Larsen Harry AN409JPPointer Ned A REPLICA PA-18 · S/N 000001Built 2012 · Pointer Ned AN413Park STEEN SKYBOLT · S/N 32848Built 1988 · Shearer John WN4290ZPiper PA-18-150 · S/N 18-8539Built 1967 · Shearer John WN5026WPiper PA-28-160 · S/N 28-27Built 1961 · Spencer Don WN5317TCessna TR182 · S/N R18201856Built 1982 · Covert Charles FN56034Ryan Aeronautical ST3KR · S/N 1527Built 1941 · Edling Tyrell RN5951UPiper PA-28-140 · S/N 28-26803Built 1970 · Link David RN60679Air Tractor AT-402B · S/N 402B-0997Built 1996 · Shearer JohnN64MESteel Mary B RV-6 · S/N MS-1Built 1999 · Shearer John RN6785MCessna 182P · S/N 18263834Built 1975 · Rocerick Dean GN7145QCessna 182P · S/N 18262038Built 1973 · Edling Tyrell RN7318BBeech E35 · S/N D-3781Built 1954 · Gonzales Gabriel JN7411Arthur Van Eaton EXCALIBUR · S/N 001Van Eaton Arthur HN7424Maule MXT-7-180 · S/N 14119CBuilt 2006 · Stansbury Tracy EN78428Cessna 172K · S/N 17257612Built 1968 · Cypher Anne KN799JWCessna T240 · S/N T24002004Built 2013 · Russell Michael DN8314BPiper PA-32R-301T · S/N 32R-8129021Built 1980 · Schultens Robert R TrusteeN8444TCessna 182B · S/N 52344Built 1959 · Slusher Thomas RN84KBeech V35B · S/N D-10067Built 1977 · N84k LLCN8569WPiper PA-28-235 · S/N 28-10081Built 1963 · Columbia Gorge Community CollegeN9021WPiper PA-28-235 · S/N 28-10819Built 1966 · Hage Electric And Construction Services IncN9053SAir Tractor AT-402 · S/N 402-0890Built 1992 · Shearer John WN95JQJames Q Johnson JCUB18 · S/N 001Johnson James Q
Back to The Dalles, OR