OpenAirDocs.org
Yelm, WA

Registered aircraft · 60

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 = 'WA' AND g.registrant_city = 'YELM'
  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.

N101BJSchumacher Joe CHRISTEN EAGLE II · S/N SCHUMACHER 0001Blanchfield George TrusteeN1051QYoung Glenn THORP T-18 · S/N 802Built 1979 · Jacobsen Gary JamesN10838Cessna 150L · S/N 15075075Built 1973 · Hadley Paul TN1103EBellanca 7ECA · S/N 1212-77Built 1977 · Phantom Flyer LLCN112ETCelier XENON RST · S/N CAI02771SBuilt 2007 · True Eddie MN1182XNelick Rex D KITFOX IV · S/N ICS131Built 1999 · Reed CliffordN118JTTindell Jerry W THORP T18 · S/N 1377Built 1995 · Jacobsen Gary JamesN12UVEnstrom F280 · S/N 1503Capriccio Leasing LLCN1357APiper PA-18 · S/N 18-1181Built 1951 · Carson Cubs LLCN1464TPiper PA-28-180 · S/N 28-7205302Built 1972 · Siedentopf Zyurelaie IndianaN1526PPiper PA-22-135 · S/N 22-2391Bailey Mark TN177SCPiper PA18-160 · S/N 18-7709165Built 1977 · Carson Cubs LLCN181REEklund Richard D THORP T-18 · S/N 195Built 1996 · Jacobsen Gary JN18JFThorp T-18 · S/N 262Built 1970 · Finney Bruce RN208DCColliander Richard J VANS RV-8 · S/N 81103Built 2001 · Ray David LN21696Piper J4A · S/N 4-481Peterson Cristopher MN21699Cessna 172M · S/N 17263988Built 1974 · Ramirez Sam ErnestN244XRichard D Johnson KITFOX SERIES 5 · S/N S1312-0126Built 2013 · Reed CliffordN245KWPiper PA-18A · S/N 18-2495Carson Cubs LLCN260DZDrees Douglas L ZENAIR CH200 · S/N A260/2DWiss JasonN2677EAeronca 7AC · S/N 7AC-6257Built 1946 · Todd Michael EN330JHMyers Floyd THORP-18 · S/N 1058Built 1999 · Hoover Jerrald JN3363DCessna 180 · S/N 32161Built 1955 · Todd Michael EN3435BBeech D35 · S/N D-3673Built 1953 · Hadley Paul TN3438UCessna 182F · S/N 18254838Built 1963 · Grau Gary Wayne JrN347JPPiggott John H BEARHAWK · S/N 347Built 2003 · Phantom Flyer LLCN37ARRanck Amos D T-18 · S/N 1134Built 1999 · Flowers Charles LN4012UCessna 150E · S/N 15061412Built 1965 · Morris Donna LN40EZHughes Arleigh Bruce LONGEZE · S/N 69Maui Aero LLCN40KFThornberg Bradley Curtis KITFOX IV · S/N 1563Pierce Charles AN4408HPiper PA-15 · S/N 15-193Built 1948 · Hiebert Marvin RN45037Naval Aircraft Factory N3N-3 · S/N 2633Phantom Flyer LLCN4734NCessna 182Q · S/N 18267323Built 1979 · Wood Daniel MatthewN5391MGlasgow Gary E KR 2 · S/N 7097Built 1989 · Acklam DavidN5394DCessna 180A · S/N 50294Built 1958 · Bruce Gregory LN561TPMaule MX-7-180 · S/N 11041CBuilt 1988 · Kerner Christine AN56769Boeing A75N1(PT17) · S/N 75-4794Built 1943 · Rebbin Douglas HN57RBBeech A36 · S/N E-1572Built 1979 · Davis Timothy MN5888DPiper PA-18 · S/N 18-5312Built 1956 · Bruce Gregory LN6348FCessna 182P · S/N 18264169Built 1975 · Hiebert Marvin RN640JFFord Jeffery OUTBACK · S/N S 9805-0156Built 2001 · Harwell Benny MN649PHHadley Paul T VANS RV-4 · S/N 1649Built 2002 · Hadley Paul TN7013VMooney M20F · S/N 22-1365Built 1976 · Forsman Robert JN70867Cessna 182M · S/N 18259400Built 1968 · Phantom Flyer LLCN7153ZPiper PA-18-150 · S/N 18-8266Built 1965 · Carson Cubs LLCN7178SCessna 150H · S/N 15067878Built 1967 · Mcclain Matthew SN7223KPiper PA-18 · S/N 18-117Built 1950 · Downing Michael PN735VMCessna 182Q · S/N 18265719Built 1977 · Morris Dale LN77HKVans RV-12 · S/N 120369Built 2011 · Knepper Harold PN7991CNorth American AT-6A · S/N 78-7018Built 1958 · Fernalld Richard C
Back to Yelm, WA