OpenAirDocs.org
Ellensburg, WA

Registered aircraft · 76

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

N111VTJodel F-11 · S/N 6023Built 1972 · Thovson Virgil DN1197YSmith Richard E ROTORWAY EXEC 162F · S/N 6116First renewal noticeRhodes John SN1204TPiper PA-28-140 · S/N 28-7225421Built 1972 · High Sky LLCN125MADJI AGRAS T40 · S/N 64TBKBL0020067Airoterra LLCN1456HAeronca 15AC · S/N 15AC-524Lafrance Edward JN1457JRockwell International 112A · S/N 457Built 1976 · Ratcliff David R TrusteeN170MSCessna 170B · S/N 26085First renewal noticeBuilt 1953 · Midstate Aviation IncN170VWCessna 170B · S/N 20592Built 1952 · Pratz ChrisN175THCessna 175 · S/N 56237Built 1960 · La France Edward JN184KXCraig Clerf CLERF-CJ18 · S/N 001Built 2012 · Clerf Craig RN185BBCessna A185F · S/N 18503449Built 1977 · Beiter Paul RN186CKCirrus Design SR22 · S/N 3441Built 2009 · Puckett David BryanN2013BLuscombe 8A · S/N 6440Higgins David RN2210DCessna 170B · S/N 20362Sample Richard FN2341VCessna 140 · S/N 14726Built 1948 · Chilman NathanN2384GCessna 182B · S/N 51684Built 1958 · Aircraft Holdings LLCN269PLCano Richard J LANCAIR IVP · S/N 269ABuilt 2004 · Merrill MarkN2783GCessna 182B · S/N 52083Built 1959 · Larue Terrence WN3373SCessna 182G · S/N 18255390Built 1964 · Western Metal Products LLCN337BCAdkinson Gary Alan AVID FLYER · S/N 1016Built 1994 · Johnson Craig HN356RVJett Thomas R RV7A · S/N 70078Built 2007 · Blue Yonder Aviation LLCN360CWCessna 172R · S/N 17280312Built 1998 · Central Washington UniversityN375FBHal J Mason BOWERS FLYBABY BIBAB · S/N 75-4Boitano John JN397TCessna 172M · S/N 17260863Built 1973 · Nickerson Kelly DN405TSPiper PA-30 · S/N 30-159Built 1963 · Richard N ApplingN4093DCessna 182A · S/N 34793Built 1957 · Zito Nick DN4184JPiper PA-28-140 · S/N 28-22523Gorman Jeffrey MN42279Cessna 182L · S/N 18258940Built 1968 · Keller Mark DN422CWPiper PA-44-180 · S/N 4496438Built 2018 · Central Washington UniversityN423CWPiper PA-44-180 · S/N 4496439Built 2018 · Central Washington UniversityN428WABierman Frederick W III CHRISTEN EAGLE II · S/N BIERMAN 0001Built 1989 · Phillips Jeffry TN43215Piper PA-28R-200 · S/N 28R-7435254Built 1974 · Gremel TylerN44509Piper PA-28-151 · S/N 28-7415652Built 1974 · Central Washington UniversityN480MLEnstrom Helicopter 480 · S/N 5032Built 1998 · Cline Air Services LLCN480MTEnstrom Helicopter 480 · S/N 5003Built 1994 · Cline Air Services LLCN499ZBDJI AGRAS T50 · S/N 1581F6BUB252C001CB2JBare Steve WN517MSCessna R182 · S/N R18200681Built 1978 · Jewett John GN520CWPiper PA-28-181 · S/N 2843921Built 2017 · Central Washington UniversityN521CWPiper PA-28-181 · S/N 2843922Built 2017 · Central Washington UnivN522STJacques G Leroux HIGHLANDER · S/N JA259-01-12Built 2014 · Aircraft Holdings LLCN523CWPiper PA-28-181 · S/N 2843923Built 2017 · Central Washington UniversityN524CWPiper PA-28-181 · S/N 2843924Built 2017 · Central Washington UniversityN529CWPiper PA-28-181 · S/N 2843925Built 2017 · Central Washington UniversityN540CWPiper PA-28-181 · S/N 2881049Built 2018 · Central Washington UniversityN541CWPiper PA-28-181 · S/N 2881050Built 2018 · Central Washington UniversityN542CWPiper PA-28-181 · S/N 2881051Built 2018 · Central Washington UniversityN543CWPiper PA-28-181 · S/N 2881052Built 2018 · Central Washington UniversityN544CWPiper PA-28-181 · S/N 2881053Built 2018 · Central Washington UniversityN545CWPiper PA-28-181 · S/N 2881054Built 2018 · Central Washington UniversityN546CWPiper PA-28-181 · S/N 2881104Built 2019 · Central Washington University
Back to Ellensburg, WA