OpenAirDocs.org
Olivehurst, CA

Registered aircraft · 21

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

N12246Cessna 172M · S/N 17261906Built 1973 · Bowles Thomas MN136LCCoen Laurence W COEN-VLCTY STD/RG-E · S/N DM0316Built 2005 · Jewell David SN142DGBlackwood Cosby G PITTS S2-E · S/N BB-01Built 1981 · Yuba Sutter AviationN177MF177mf PITTS MODEL 12 · S/N 299Built 2009 · Yuba-Sutter Aviation IncN182YSCessna 182F · S/N 18254845Built 1963 · Yuba-Sutter Aviation IncN341MGaidousek Eugene J RV6A · S/N 22178Built 1999 · Hensley Jerry WN357CCox-Edman STARDUSTER TOO SA300 · S/N 327Built 1975 · Yuba - Sutter Aviation IncN398SBAmerican Champion 8KCAB · S/N 821-98Built 1998 · Yuba Sutter Aviation IncN4530GFly Products Trike MONSTER · S/N MC-123Built 2000 · Jewell David SN50323Cessna 150H · S/N 15069228Got Valentin LN70798Collins-Harold STARDUSTER TOO SA300 · S/N 1064Built 1979 · Yuba Sutter Aviation IncN7147NBeech V35A · S/N D-8681Built 1967 · Hall Michael WN7720ACessna 180 · S/N 32617Built 1956 · Krueger Eric JN839MFDornier UH-1D · S/N 8458Rice Aircraft Services IncN839NFDornier UH-1D · S/N 8162Rice Aircraft Services IncN839PFDornier UH-1D · S/N 8232Built 1970 · Rice Aircraft Services IncN839QFDornier UH-1D · S/N 8369Rice Aircraft Services IncN839UFDornier UH-1D · S/N 8196Built 1969 · Rice Aircraft Services IncN839VFDornier UH-1D · S/N 8227Rice Aircraft Services IncN8579BCarl E Bolton KIT FOX SPEEDSTER IV · S/N E33ADBuilt 2019 · Jewell David SN8622VBellanca 8KCAB · S/N 172-75Built 1975 · Honeycutt Aviation Inc
Back to Olivehurst, CA