OpenAirDocs.org
Redding, CA

Registered aircraft · 193

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

N4771LPiper PA-28-180 · S/N 28-4103Built 1967 · Henderson Brian KN4847KRyan NAVION · S/N NAV-4-1847Rocha Julio CesarN487ALBell 407 · S/N 53150Built 1997 · Redding Air Service IncN488KCRobinson Helicopter R44 II · S/N 11383Built 2006 · Pterofranc Flight Services LLCN499BKDiamond Aircraft Ind DA 42 · S/N 42.AC099Built 2007 · Aero Leasing IncN4WLBeech A45 · S/N G-127Ostrich James TN500QBCessna 310B · S/N 35760Built 1958 · Anderson Dana RN5084QAaron James F RAF 2000 · S/N JAD-3Built 2007 · Story DarrellN50CMCessna 560 · S/N 560-0661Built 2004 · Wizard Aviation LLCN5182ACessna 172R · S/N 17281106Built 2002 · Iasco Flight Training IncN5190RCessna 172R · S/N 17281111Built 2002 · Iasco Flight Training IncN53020Cessna 172R · S/N 17281136Built 2002 · Iasco Flight Training IncN530RJay Charles Morgan MORGAN · S/N JM01Morgan Jay CN53XYSchwartz Kenneth G S17 STINGER · S/N 001Built 2009 · Pero Wayne MN543SHDonald E Haug BUSHCAT · S/N CH275CBuilt 2023 · Haug Donald EN5506WPiper PA-28-160 · S/N 28-593Built 1962 · Mchatton Dret AN5569DBeech H35 · S/N D-5123Built 1957 · Yniguez RudyN5608KBeech 35-B33 · S/N CD-750Built 1964 · Ryan Carroll MN5665RCessna 172F · S/N 17253299Built 1965 · Limmer Rita GN5685UPiper PA-28-140 · S/N 28-26482Built 1969 · Tres Amigos Flying Club LLCN56SJAmerican Champion 7GCBC · S/N 1267-99Built 1999 · Shaw Kenneth FN5705QMooney M20E · S/N 712Black David W TrusteeN5748JCessna 182P · S/N 18263515Built 1974 · Wallner Patrick JN5768MCessna 310P · S/N 310P0068Built 1968 · Heal Your Heart LLCN582DBAirborne EDGE · S/N 582-525Built 2002 · Wolf Chuck EN587JJPilatus PC-12/47E · S/N 2118Built 2021 · Shasta Sky Works LLCN6127ECessna 172 · S/N 46227Built 1958 · Cardan Aircraft Services IncN6198TCessna 150E · S/N 15060898Built 1964 · Lim RonaldN6291ECessna 182R · S/N 18268357Built 1983 · Wright Robert D TrusteeN6634XBeech C24R · S/N MC-685Built 1979 · Pierson Rodney K TrusteeN6647NTaylorcraft 15A · S/N 5-13047Built 1952 · Hooten James TN66NSCessna LC41-550FG · S/N 411122Built 2009 · Recker Rodney ThomasN6781PPiper PA-24-250 · S/N 24-1912Built 1960 · Demontigny Tyler RN6806GCessna 150L · S/N 15072306Built 1970 · Higley Paul DN68GSRaytheon 400A · S/N RK-391Friesen Group IncN6966UMooney M20E · S/N 326Built 1964 · Underhill Robert AN7045QCessna 182P · S/N 18262021Built 1973 · Davidson ParkerN7088AChocolas John S R-80 TIGER MOTH · S/N TM-27Built 2004 · Chocolas JohnN716KTCirrus Design SR22T · S/N 8536Built 2022 · Kstc Enterprises 2 LLCN731PWGregory Willard SLING HW · S/N 031GKBuilt 2024 · Willard Kyle PN737KQCessna 172N · S/N 17269480Built 1977 · Zuidema Herbert L TrusteeN7425NCessna 182P · S/N 18263203Built 1974 · Steiner Stephen TrusteeN747KTCessna 172R · S/N 17280020Built 1997 · Iasco Flight Training IncN7550BChampion 7FC · S/N 7FC-52Pomeroy Jess PN7570WPiper PA-28-180 · S/N 28-1513Built 1964 · Watkins Andrew BN77TKGlobe GC-1B · S/N 2062Built 1946 · Cc Motors LLCN781JGGreaves John P RV7A · S/N 70170Built 2008 · Greaves John PN80647Globe GC-1B · S/N 1052Built 1946 · Cc Motors LLCN80780Bell UH-1H · S/N 64-13820First renewal noticeGagnon Roger MN8079EBell UH-1H · S/N 65-09718First renewal noticeGagnon Roger M
Back to Redding, CA