OpenAirDocs.org
Chehalis, WA

Registered aircraft · 50

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

N103AMCessna A185F · S/N 18502615Built 1974 · N103am LLCN11772Cessna 150L · S/N 15075624Built 1974 · Pope John PN119TMD Helicopters 369HS · S/N 760844SBuilt 1976 · Taylor Robert TN135LKSportine Aviacija IR Ko LAK-17B FES MINI · S/N 013Built 2018 · Esoaring LLCN1861JPiper PA-28-140 · S/N 28-24299Built 1968 · Jordan Walter BN2065HErco 415-C · S/N 2688Anderson Nancy LN206YYBell 206A · S/N 132Built 1968 · Mshr Helicopter Service LLCN222WFCessna 210-5(205) · S/N 205-0220Built 1963 · Bailey SteveN224PJCirrus Design SR22 · S/N 2281Built 2006 · Leng Jason WN235XASteven W Bailey RV-14 · S/N 140560Built 2024 · Bailey Steven WN2455DCessna 170B · S/N 20599Built 1952 · Burton Douglas MN2471KLuscombe 8E · S/N 5198Built 1947 · Mainero Tanner RN26769Piper J3L · S/N 4165Built 1940 · Cascade Aerial Services LLCN26PEHiller UH-12D · S/N 1327Mshr Helicopter Service LLCN30496Piper J-3 · S/N 6627Built 1941 · Burton Douglas MN313HPBell Helicopter Textron Canada 206L-3 · S/N 51341Built 1990 · Mshr Helicopter Services LLCN335FDDanielson Fred D RV-4 · S/N 335Built 1989 · Roy Martin PN3520WPiper PA-32-260 · S/N 32-404Built 1966 · Lyttle John W JrN370MRCessna 525B · S/N 525B0385Built 2012 · Pacific Cataract And Laser Institute Inc PcN4013JCessna 150G · S/N 15065313Built 1966 · Macomber DanielN4047JAerovodochody L-29 DELFIN · S/N 491119Keller DarinN44HSCirrus Design SR22T · S/N 9996Built 2024 · Amor Fati Aviation LLCN46287Cessna 172I · S/N 17257157Built 1968 · N46287 LLCN4746NCessna 182Q · S/N 18267334Built 1979 · Denham Stacy LN5029PPiper PA-24 · S/N 2432Built 1958 · Jordan Walter BN510DVCessna 510 · S/N 510-0461Pacific Cataract And Laser Institute Inc PcN523DVCessna 525B · S/N 525B0415Built 2014 · Pacific Cataract & Laser Institute Inc P CN529DVCessna 525B · S/N 525B0358Built 2011 · Pacific Cataract & Laser Institute Inc PcN5509BCessna 182 · S/N 33509Korn AntonyN5588FPiper PA-28-140 · S/N 28-24921Built 1968 · Rckr Aviation LLCN5626JThode Roger D PC2000 · S/N A-159 POWBuilt 2001 · Thode Roger DN61QCRoy Martin P SONERAI IIL · S/N 01488Built 2006 · Martin Roy PN6409ECessna 172 · S/N 46509Built 1959 · Chehalis Skies Aircraft LLCN6907BPiper PA-22-150 · S/N 22-4182Built 1956 · Jordan Walter BN701ADFurrer James I ZENITH CH701 · S/N 7-6940Nixon JerryN737WFCessna 170B · S/N 25346Built 1952 · Mainero Tanner RN7569FChampion 7ECA · S/N 731-70Built 1969 · Mainero Tanner RN7580HPiper PA-12 · S/N 12-460Built 1946 · Furjesi Steve JN77741Mcclish FUNK B85C · S/N 371Built 1946 · Wirt Christopher WN77948Luscombe 8A · S/N 3675Built 1946 · Keys TrevorN8122CPiper PA-22-135 · S/N 22-2268Built 1954 · Jordan Walter BN822WYMccreery Alvin L RV-6 · S/N 24684Built 2003 · Young JamesN829KAPiper PA 46-350P · S/N 4636530Built 2012 · Mccallum Aviation LLCN8362SRobinson Helicopter R44 · S/N 0429Taylor Robert TN8848RRoy Kevin B GLASAIR SH-2R · S/N 2458Built 2012 · Roy Kevin BN9008BWoolums Darrell E BABY ACE D · S/N 79Built 1979 · Mainero Tanner RN920HAHiller UH-12D · S/N 1361Built 1962 · Mshr Helicopter Service LLCN9308BCessna 175 · S/N 55108Built 1958 · Korn AntonyN95193Taylorcraft BC12-D · S/N 9593Built 1946 · Mason ToddN9849KStinson 108-2 · S/N 108-2849Built 1947 · Furjesi Steven J
Back to Chehalis, WA