OpenAirDocs.org
Clarkston, WA

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

N108GWCessna 180A · S/N 32683Pope James DN14954Ryan Aeronautical ST-A · S/N 110Built 1935 · Peters GaryN1824NBeech A36TC · S/N EA-248Built 1981 · Maiorana Anthony J TrusteeN1841YCessna 172C · S/N 17249441Segroves ChrisN189FCKamp John KITFOX II · S/N 432Larrabee Jack BN19086Canadian Car & Foundry HARVARD MK IV · S/N 20470Built 1952 · Peters GaryN206NJBell UH-1B · S/N 62-1934Built 1962 · Pope James DN21HCPiper PA-18-150 · S/N 18-7711Built 1962 · Pope James DN2631GCessna 182B · S/N 51931Built 1959 · Mac Neil David MN2640VCessna 177RG · S/N 177RG0640Built 1974 · Bube Douglas GN26RHCessna 185A · S/N 185-0293Built 1961 · Harker Jonathan KimballN301HPBell UH-1H · S/N 65-10017Built 1965 · Pope Jim DN30268Cessna T210L · S/N 21059903Built 1973 · Rudd Terry RN3089QCessna 182K · S/N 18258089Built 1967 · Brotnov Jerald WN32945Piper J3C-65 · S/N 5729Israel Marlin LN3634WPiper PA-32-260 · S/N 32-536Built 1966 · Carey Nicholas IsaacN409XXDale Hughes G-202 · S/N 001Built 2013 · Pope James DN4366MPiper PA-12 · S/N 12-3312Built 1947 · Cline Robert AN466WARyan Aeronautical STM · S/N 466Built 1940 · Peters Gary BN4733TMaule M-4 · S/N 83Built 1964 · Macneil DavidN50733Wilson W Dean DW10 · S/N 010Built 2006 · Howlett Brian AN5128MCoyle Ralph V BB TRIKE SWING WING · S/N 001Built 2003 · Coyle Ralph VN522GHCessna T210N · S/N 21063399Built 1979 · Quailridge Aviation LLCN530BJDehavilland DHC-2 MK. I(L20A) · S/N 530Peters Gary BN550YWW Dean Wilson DW-40 · S/N 001Larrabee Jack BN557DHHendricks Douglas POCKETWIN · S/N 01AHendricks Douglas EN55JLNorth American F-51D · S/N AAF44-84615Peters GaryN60178Ryan Aeronautical ST3KR · S/N 2184Built 1942 · Peters Gary BN6187FCessna 210J · S/N 21059087Built 1968 · Nuxoll BuildersN6555CRobinson Helicopter R44 II · S/N 10965Built 2005 · Kiwi Air LLCN665KStearman 4-C · S/N 4003Built 1929 · Peters Gary BN6663RMooney M20C · S/N 2770Built 1964 · Warnecke Gary RN667KStearman 4E · S/N 4007Built 1929 · Peters Gary BN706FLPiper PA-28-140 · S/N 28-7225300Time Flys Idaho LLCN713WWBoeing E75 · S/N 75-5670Built 1944 · Peters Gary BN777QBCommonwealth 185 · S/N 1698Built 1946 · Bottomly Raymond VN810DSCompagnie Daher TBM 700 · S/N 1267Built 2018 · D&S Electrical Contractors IncN814TJAnthony J Maiorana AJM-CUB · S/N 001Built 2024 · Maiorana Anthony JN82PWR F Grady KITTYHAWK 2/3 P-40 · S/N RFG-02Howlett BrianN84FFCessna 182A · S/N 51221Built 1958 · Koorenny Brian GN8562TCessna 182 · S/N 52462Built 1959 · Backsen Rick LN877MGDouglas DC3C-R-1830-90C · S/N 20806Built 1949 · Peters GaryN8976TCessna 182C · S/N 52876Built 1960 · Kumm John JN9095CPiper L-4B · S/N 9400Peters Gary BN910DSAmerican Legend AL18 · S/N AL-357Flerchinger DickN91LROtto Loren H AVID FLYER · S/N 708Built 1993 · Larrabee Jack BN9368CCessna 180 · S/N 31766Built 1955 · Radtke Edward PN9405UCessna 150M · S/N 15078353Bishop Michael EN9653WPiper PA-28-140 · S/N 28-23114Built 1967 · Wohl Scott DN971TCSomma EPIC LT · S/N 048Built 2014 · Twin City Electricians Inc
Back to Clarkston, WA