OpenAirDocs.org
Richland, WA

Registered aircraft · 85

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

N1007YLoberger Jim QUICKIE Q2 · S/N 2202Maxey RobbN1063ZThompson Corben Baby Ace B · S/N 43896Built 1962 · Davis Michael WN126BVSchweizer SGS 1-26D · S/N 422Built 1968 · Collins Dennis LN145SSBurkhart Grob Flugzeugbau G102 ASTIR CS · S/N 1371Built 1976 · Collins Dennis LN148UBeech V35 · S/N D-8437Built 1967 · Upmeyer Matthew DN168PCNavmar Applied Sciences TIGERSHARK BLKIII A2 · S/N 168US Department Of EnergyN177DENavmar Applied Sciences TIGER SHARK XP · S/N 177US Department Of EnergyN177MWCessna 177RG · S/N 177RG1134Built 1977 · Factourovich MaximN180BVPiper PA-28-180 · S/N 28-4161Garcia Karin MN1816ZBeech C23 · S/N M-232Built 1981 · Western Anesthesia AssnN192RARemos REMOS G-3/600 · S/N 192Built 2007 · Bitten ErnestN204BLOneil William Jerome ONEIL BERKUT 360 · S/N WJO 003Built 2012 · O'Neil William JeromeN2089BLuscombe 8F · S/N 6516Built 1948 · Hales Janell WN211USIndus T-211 THORPEDO · S/N 007SBuilt 2006 · Carpenter John DN21401Cessna 182P · S/N 18261612Built 1972 · Sterling Steven GN2147JPiper PA-28RT-201T · S/N 28R-7931011Built 1978 · Wolfe Stephen DN221AJMark Gehlen GEHLEN CARBON DUSTER · S/N A001MGBuilt 2024 · Gehlen Mark HN226CCAS+ AC 4 · S/N 20Built 1996 · Collins Dennis LN233JKCessna 560 · S/N 560-0797Built 2008 · Lcr Aviation LLCN2447AHegy Roberta ANN RV-7A · S/N 70966Built 2004 · Dyer Clifton RN262RPiper PA-28-140 · S/N 28-21931Built 1966 · 262r LLCN2634GChampion 7ECA · S/N 476Built 1967 · Davis Michael WN27207Porterfield CP-65 · S/N 704N27207 LLCN31495Maule MX-7-180A · S/N 20032CSuch Jason AN326ASchleicher Alexander ASH 26 E · S/N 26043Built 1995 · Greenwell Eric N TrusteeN354EMCirrus Design SR22 · S/N 2634Built 2007 · Srm Aviation Solutions LLCN362ZBeech M35 · S/N D-6522Built 1960 · Kinder JeffreyN368JHBeech A36 · S/N E-1920Built 1981 · Ursine L Attitudes LtdN36CGCessna 310P · S/N 310P0075Built 1969 · Day Edwin DanielN37743Porterfield CP-65 · S/N 963Built 1941 · Boast Mark RN37959Piper J5A · S/N 5-839Built 1941 · Collins Dennis LN3813VCessna 170 · S/N 18671Built 1948 · Tailwheelin LLCN38512Piper J3F-65 · S/N 7081Built 1941 · Bialas Bonnie LN3938NMooney M-20G · S/N 680065Built 1968 · Sundance Aviation IncN4054DCessna 182B · S/N 34754Built 1958 · Bass Edward JN40GWWaldsmith Gary R PITTS S-2E · S/N K-0025Abatt F GeorgeN431DMNanchang China CJ-6A · S/N 2851272Built 1972 · Hanoff Jeffrey ON444EXBlake Richards CCK-1865 · S/N CCK-1865-0066Built 2017 · Gehlen MarkN4753GDJI AGRAS T50 · S/N 1581F6BUB2468001PB8KRupp RandyN4893PPiper PA-23-250 · S/N 27-477Built 1961 · Tri-City Helicopter Services IncN48BMAeromot AMT-200(SUPR XIMNGO) · S/N 200057Built 1996 · Bing ManawaduN5396ZPiper PA-22-108 · S/N 22-9166Built 1961 · Collins Dennis LN560LWCessna 560 · S/N 5600053Built 1990 · Larry Aviation LLCN561PFCessna 560 · S/N 560-0048Built 1990 · N561pf LLCN56ASPdps Pzl-Bielsko SZD-45A OGAR · S/N B-758Built 1977 · Collins Dennis LN57YGlaser-Dirks DG-400 · S/N 4-142Allemann Rudolph TN625MSShiver James H WITTMAN TLWND W10/8 · S/N JS005Built 2002 · Williams JerryN63702Cessna 172P · S/N 17275471Built 1981 · Smith Brian E TrusteeN63NANorth American T-28B · S/N 138263Built 1955 · Urban Scott JN64270Cessna 172M · S/N 17265142Built 1975 · Sundance Aviation Inc
Back to Richland, WA