OpenAirDocs.org
San Ramon, CA

Registered aircraft · 37

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 = 'SAN RAMON'
  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.

N101PSCessna 425 · S/N 4250108Built 1982 · Jtech Solutions IncN11STChristensen Thomas C SONEX · S/N 702Built 2009 · Christensen Thomas CN1245BCessna 182P · S/N 18264060Built 1975 · Positive Flight LLCN133WAirborne Australia AIRBORNE XT-912 · S/N XT 016Built 2005 · Fuller DavidN1868HPiper PA-28-140 · S/N 28-7725165Built 1977 · Sodah One LLCN1920CMooney M20C · S/N 2686Built 1964 · Vanjara Gufran UN240RYM&D Flugzeugbau JS-MD 3 RES · S/N 3.MD240Built 2025 · Yanetz RamyN25672Balloon Works FIREFLY 7-15 · S/N F7-808Jennings Jay AN2756DCessna 170B · S/N 25298Built 1952 · Stewart James AN321TMMoore Thomas A Q-200 · S/N 2328Olson Bradley JN342MMCessna 182L · S/N 18258570Johnson Aaron MN349SAAmerican Champion 7GCAA · S/N 508-2006Built 2006 · Long Richard JN3547HCessna 172S · S/N 172S8886Cali Air LLCN3815FGreat Lakes 2T-1A-2 · S/N 0783Built 1977 · Orr Charles W IIIN40185Stinson 108 · S/N 108-115Built 1946 · Bosko Steven JN4636KCessna P210N · S/N P21000248Built 1979 · Advanced Database Designs LLCN4979SPiper PA-28R-200 · S/N 28R-35698Built 1970 · Dunn James JN4991TBoeing PT-13D · S/N 42-17614Built 1943 · Johnson Aaron MN5429MBeech C24R · S/N MC-575Built 1978 · Air Systems LLCN544YYoungblood John S RV-14A · S/N 140354Built 2021 · Youngblood John SN5790RCessna 172G · S/N 17253459Miller Cindy CN59CFGulfstream Aerospace GIV-X · S/N 4097Built 2007 · Tailwind Holdings LLCN6005EBeech K35 · S/N D5927Makiyama ToddN60116Cessna 150J · S/N 15070080Built 1968 · Winglers Aviation LLCN60756Cessna 150J · S/N 15070551Built 1969 · Vanjara Obaid UN736HDCessna R172K · S/N R1722532Built 1977 · Guthrie John AlexN7530VCessna 177RG · S/N 177RG0827Built 1976 · Nicolaou John GN7564XCessna 172B · S/N 17248064Sodah One LLCN7891TCessna 172A · S/N 47491Built 1960 · Donaldson Robert MN7965FPiper PA-28-181 · S/N 28-7790229Built 1976 · Lustig Barry JN807DPilatus PC-12/47 · S/N 807Built 2007 · Aero Tomasso LLCN814PMWynn Michael L RV-8 · S/N 82284Built 2014 · Wynn Michael LN8590KStinson 108-1 · S/N 108-1590Built 1947 · Bosko Steven JN9248WPiper PA-28-235 · S/N 28-10918Built 1967 · Meyers Andrew WN96LGCessna 180H · S/N 18051517Built 1965 · Taildragger LLCN97918Stinson 108-1 · S/N 108-918Built 1946 · Bosko Steven JN998TBTyler Ives SLING TSI · S/N 301SKBuilt 2023 · Leung Yiu Chung
Back to San Ramon, CA