OpenAirDocs.org
Red Bluff, CA

Registered aircraft · 90

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 = 'CA' AND g.registrant_city = 'RED BLUFF'
  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.

N106MAAviat A-1B · S/N 2228Built 2003 · Waits Kevin AN11323Cessna 150L · S/N 15075329Built 1973 · Huckabay Timothy JN12653Cessna 172M · S/N 17262148Built 1973 · Bryant JeffreyN1269TJoey Cheek MONSTER CUB · S/N 001Built 2019 · Cheek Joey FN1269WChristopher Cheek MONSTER CUB JR · S/N 002Cheek Christopher JN126PJAmerican Eurocopter AS350B3 · S/N 7039Built 2010 · Helibro LLCN127PJEurocopter AS 350 B3 · S/N 7180Built 2011 · Helibro LLCN134PJCessna 172S · S/N 172S9187Built 2002 · Helibro LLCN136PJBeech A36 · S/N E-1314Built 1978 · Pj HelicoptersN1394EAeronca 7AC · S/N 7AC-4956Griffin Nathan KN140PJAirbus Helicopters AS350B3 · S/N 8646Helibro LLCN141PJAirbus Helicopters AS350B3 · S/N 9368Built 2023 · Helibro LLCN17542Piper J-2 · S/N 1042Built 1936 · Griffin Lauriane TrusteeN185MCCessna A185F · S/N 18503347Campillo Mark AN2045NPiper PA-18-150 · S/N 186771Built 1958 · Christensen Tyler RN22HMMooney M20M · S/N 27-0037Built 1990 · Petrzelka IvanN232PJBell Helicopter Textron 212 · S/N 30826Built 1977 · Helibro LLCN253PJColumbia Helicopters CH-47D · S/N 90-0198Built 1991 · Pj Helicopters IncN254PJColumbia Helicopters CH-47D · S/N 89-0138Built 1990 · Pj Helicopters IncN257PJBoeing CH-47D · S/N 89-0132Built 1989 · Pj Helicopters IncN259PJBillings Flying Service CH-47D · S/N 90-0184Built 1990 · Pj Helicopters IncN26MFCessna 177B · S/N 177014252nd Amendment Consulting And Design LLCN2866FCessna 182J · S/N 18256966Howell Thomas FN2879EAeronca 7BCM · S/N 7AC-6462Built 1946 · Griffin Douglas TrusteeN30558Piper J3L-65 · S/N 4928Cardan Aircraft Services IncN3206SCessna 182 · S/N 18255706Built 1964 · Hall David JN3351TCessna 177 · S/N 17700651Taylor Gail LN3713UCessna 182G · S/N 18255113Built 1963 · Daggy Curt L IIIN400PJBell 407 · S/N 53705Built 2006 · Helibro LLCN402PJBell 407 · S/N 53195Built 1997 · Helibro LLCN403PJBell 407 · S/N 53256Built 1998 · Helibro LLCN406GGCessna A185E · S/N 185-1154Built 1967 · Cedar Creek CorpN406PJBell 407 · S/N 53466Built 2000 · Helibro LLCN407PJBell 407 · S/N 53469Built 2001 · P J Helicopters IncN408PJBell 407 · S/N 53286Built 1998 · Helibro LLCN409PJBell Helicopter Textron Canada 407 · S/N 53301Built 1998 · Helibro LLCN411PJBell 407 · S/N 53045Built 1996 · Helibro LLCN414PJBell Helicopter Textron Canada 407 · S/N 53989Built 2010 · Helibro LLCN417PJBell 407 · S/N 53493Helibro LLCN418PJBell Helicopter Textron Canada 407 · S/N 54025Built 2010 · Helibro LLCN424PJBell Helicopter Textron Canada 429 · S/N 57113Built 2012 · Helibro LLCN426PJBell Helicopter Textron Canada 429 · S/N 57057Built 2011 · Helibro LLCN4420ZPiper PA-18-150 · S/N 18-8756Ruff Gregory ZN4567UCessna 150D · S/N 15060567Waits Kerry SN4694CCessna 170B · S/N 25638Built 1953 · Christensen Tyler RN491PJBell Helicopter Textron Canada 407 · S/N 53944Built 2009 · Helibro LLCN492PJBell 407 · S/N 53756Built 2007 · Helibro LLCN493PJBell Helicopter Textron Canada 407 · S/N 53936Built 2009 · Helibro LLCN494PJBell 407 · S/N 53694Built 2006 · Helibro LLCN495PJBell Helicopter Textron Canada 407 · S/N 53949Built 2009 · Twin Equipment LLC
Back to Red Bluff, CA