OpenAirDocs.org
Richvale, CA

Registered aircraft · 34

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

N10KXBell 206B · S/N 1628Built 1975 · Whirly Leasing IncN164GCGrumman Acft ENG Cor-Schweizer G-164C · S/N 2CBuilt 1977 · Avag IncN168XClement James CLEMENT TAILWIND · S/N JC7Book Paul AN212NBBell 212 · S/N 30599A&P Helicopters IncN216APBell 212 · S/N 30576Built 1973 · A&P Helicopters IncN2677MPiper PA-12 · S/N 12-1095Built 1946 · L & L FarmsN2956FBell UH-1B · S/N 63-12950Avag IncN3286NPiper J3C-65 · S/N 22482Built 1946 · Whirly Leasing IncN3657EAeronca 7AC · S/N 7AC-6968Built 1947 · Book Paul AN403APBell 407 · S/N 53424Built 2000 · A & P Helicopters IncN404APBell 407 · S/N 53228Built 1997 · A & P Helicopters IncN406APBell Helicopter Textron Canada 407 · S/N 53357Built 1999 · A&P Helicopters IncN407APBell 407 · S/N 53370Built 1999 · A & P Helicopters IncN408APBell Helicopter Textron Canada 407 · S/N 53197Built 1997 · A & P Helicopters IncN409APBell 407 · S/N 53126Built 1997 · A&P Helicopters IncN410APBell 407 · S/N 53091Built 1997 · A&P Helicopters IncN4610KCessna P210N · S/N P21000235Built 1979 · Avag IncN461CCBell UH-1H · S/N 67-17162Built 1967 · Avag IncN5146TChampion 7ECA · S/N 118Mattson RandallN51KSSodergren Kit MIDGET MUSTANG · S/N 626Book Paul AN5382BCessna 182 · S/N 33382Book Paul AN5395Grumman Acft ENG Cor-Schweizer G-164A · S/N 1149Built 1973 · Avag IncN602KAAir Tractor AT-602 · S/N 602-1160A&P Helicopters IncN623RBAir Tractor AT-602 · S/N 602-1166Built 2008 · Avag IncN633SCBell UH-1H · S/N 67-17633Built 1967 · Avag IncN63EGrumman Acft ENG Cor-Schweizer G-164B · S/N 305BBuilt 1977 · Avag IncN6676KGrumman Acft ENG Cor-Schweizer G-164B · S/N 17 CAvag IncN6868QGrumman/Schweizer G-164D · S/N 1DBuilt 1978 · Avag IncN710WDWilliams Helicopter UH-1H · S/N 65-09761A&P Helicopters IncN735DFCessna 182Q · S/N 18265337Built 1976 · Hd Legacy LLCN7699SWilliam F Stone SUPER STOL · S/N JA329-11-13Built 2013 · Stone William FN8516HGrumman Acft ENG Cor-Schweizer G-164A · S/N 1391Built 1975 · Compton Gerald HN85797Aeronca 7AC · S/N 7AC-4547Built 1945 · Morgan Leonard E JrN91320Bell UH-1B · S/N 62-1887Built 1962 · Avag Inc
Back to Richvale, CA