OpenAirDocs.org
Kennewick, WA

Registered aircraft · 69

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

N1038BStinson 108-1 · S/N 108-1020Built 1946 · Cooper Gerald WN1135RDyer SR Rickey L KITFOX III · S/N 1135Wiser Kurtis EN127DSDiamond Aircraft Ind DA 40 NG · S/N 40.NC018Built 2018 · C J Aviation LLCN1389BCessna T182T · S/N T18208455Built 2005 · Columbia Safety Medical LLCN138SFPiper PA-28-140 · S/N 28-20998Underwood Mark AN1572TBorgaes / Martin / Elliott AVID FLYER C MODEL · S/N 766Barry Rowdy EN177JACessna 177RG · S/N 177RG1278Built 1977 · Frye Richard E TrusteeN1809ZCessna 210-5(205) · S/N 205-0009Built 1962 · Cleared For Departure LLCN18129Cessna 177B · S/N 17702530Built 1976 · Loftics LLCN1897JPiper PA-28-140 · S/N 28-24343Built 1968 · Grimes Joseph DanielN18CCHawker Siddeley HS.125 SERIES 700A · S/N NA0222Tamcar Aviation LLCN1NLCessna 550 · S/N 550-0857Built 1998 · Neil F Lampson IncN20WMCessna 172M · S/N 17261658Built 1973 · Mcdonald John PN2176Ferraris Paul J TORNADO II · S/N D97912 SOHK 0292Built 1998 · Ferraris Paul JN233JLLivingston Jean B THROP T-18 · S/N 1301Built 1984 · Mitchell Charles GN2515DCessna 170B · S/N 20667Built 1952 · Cooper Gerald WN3011EAeronca 7AC · S/N 7AC-6597Built 1946 · Double Dose LLCN3183CCessna R182 · S/N R18200251Built 1978 · Wide Open Aviation LLCN3297BPiper PA-18A-135 · S/N 18-3299Stevens Lance RN331ZADJI AGRAS T50 · S/N 1581F6BUB2448001XX9NAltitude Agri Services LLCN367ZMAvid AVID HEAVY HAULER UL · S/N 492Barry RowdyN3705NBeech 35 · S/N D-911Built 1947 · Rogers Laurin AN38440Piper PA-28R-201T · S/N 28R-7703218Built 1977 · Decoria Dustin EN387LCCoon Richard W GLASTAR · S/N 54821Built 2000 · Cooper Gerald WN391JCCooper Gerald W SH2R GLASAIR · S/N 508Cooper Gerald WN3992JCessna 150G · S/N 15065290Built 1967 · Sabin Ronny LN40HDDrollinger Howard LANCAIR · S/N 040Built 1987 · Drollinger David HN4179NCessna 140 · S/N 13650Gauntt Stephen RN448DMDJI AGRAS T50 · S/N 1581F6BUB236U001004UAltitude Agri Services LLCN454WAWalker W H/Walker J ZENTH ZODIAC CH601XL · S/N 64527Built 2003 · Walker Weston HN49ARCessna 421B · S/N 421B0563Moore Thomas AN502JCFish/Cooper/Mitchell BUSH MASTER JJC · S/N 001Built 1999 · Cooper Jerry AN509SMCessna 172M · S/N 17263807Built 1974 · Compton StephenN509TDTeddy J Woodcock CHALLENGER II · S/N CH2-1200-CW-2037Woodcock Teddy JN5108FCessna 172F · S/N 17252727Built 1965 · Cooper Gerald WN517VAPowrachute AIRWOLF 912ULS · S/N A207ULSBuilt 2014 · Phillips Danny LN51MYDrollinger Lynn H 0360 · S/N 267Built 1990 · Drollinger David HN553DBDehavilland DHC-1 SERIES 22 · S/N C1-0573Mitchell Thomas HN5570BCessna 182 · S/N 33570Davis LucasN56288Piper PA-28-140 · S/N 28-7325604Cole Douglas WN5758CCessna 170A · S/N 19712Built 1952 · Four Mound LLCN60039Zenith STOLCH701 · S/N 76154Built 2007 · Cole Douglas WN6297UMooney M20 · S/N 2136Built 1962 · Beasley Curtis LN6359LAmerican AA-1A · S/N AA1A-0359Cole Douglas WN6791MStinson 108-3 · S/N 108-4791Built 1949 · Cooper Gerald WN7108MAerostar International S53A · S/N S53A-3010Built 1995 · Adams Tyler JN7323CEagle Balloons C-7 · S/N E85778Built 1985 · Rogers Laurin AN7327KCessna R172K · S/N R1722057Cooper Jerry AN7464ACessna 172 · S/N 29564Built 1956 · Notch Paul LN7561SCessna 182Q · S/N 18265210Built 1976 · Quality Fliers LLC
Back to Kennewick, WA