OpenAirDocs.org
Castro Valley, CA

Registered aircraft · 53

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 = 'CASTRO VALLEY'
  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.

N122EZBenard Augusto LONG EZ · S/N 1297Lawley Frederick Ellsworth IIIN14008Cessna 172S · S/N 172S9886Built 2005 · Suburban Air CorpN182BGCessna 182T · S/N 18281536Suburban Air CorpN1937FCessna 172N · S/N 17273027Built 1979 · A2 Flight Leasing LLCN20259Cessna 172M · S/N 17261136Built 1972 · Mackin Robert MichaelN2053CNorth American T-28B · S/N 55-138366Built 1953 · Doyle Duane S TrusteeN210MPCessna T210N · S/N 21063193Built 1979 · Franklin RobertN21263Cessna 172S · S/N 172S9429Built 2003 · Suburban Air CorpN2672VCessna 177RG · S/N 177RG0649Built 1974 · White RobeN273RARemos REMOS G-3/600 · S/N 234Built 2007 · Lowe Franklin PN2802MPiper PA-28-161 · S/N 28-7816312Built 1977 · Skyone Aero Services LLCN2890QCessna 172L · S/N 17259890Built 1971 · Carrick Christopher AN311JBCessna P210N · S/N P21000539Jack Brain And Associates IncN314RBRay Darryl A RAY BROTHERS CR3 · S/N 001Ray Darryl AN3252TCessna 177 · S/N 17700552Built 1967 · Fugfugosh Mahdi AN328TACessna 172S · S/N 172S9328Built 2003 · Suburban Air CorpN334FSNorth American/Aero Classics P-51D · S/N 44-72907Built 1944 · Doyle Duane S TrusteeN360HBU.L.B. Of Florida LANCAIR FB 360 · S/N 92-602Horejsi Michael EN362RBBall BABY GREAT LAKES · S/N 123288117Built 1975 · Millsap Christopher JN43045Grouleff Greg HARMON ROCKET II · S/N 13Built 1998 · Lewis Ethel MN44BVSchempp-Hirth VENTUS C · S/N 496Built 1991 · Richlife Quest AN4524NGulfstream American AA-5B · S/N AA5B1103Built 1979 · Horejsi Michael EN45631Luscombe 8 · S/N 2158Poluton DougN48HTTurner Robert E RV-10 · S/N 40745Built 2011 · Turner Robert EN50166Goodyear FG1D · S/N 92642Doyle Duane TrusteeN5018RGoodyear FG1D · S/N 92463Doyle Duane SN5064KBellanca 7ECA · S/N 1335-80Built 1979 · Shin Harry K JrN527TDCirrus Design SR20 · S/N 1360Built 2003 · Dino Aviation LLCN54LJGalpin Harry PITTS SPECIAL S1C · S/N 001Built 1969 · Poulton Douglas EN5949JCessna A150L · S/N A1500401Built 1973 · Anderson Brian EN5959ZCruikshank Bruce M BCH750 · S/N 04Built 2012 · Cruikshank Bruce MN59CVNorth American Rockwell Group T-2C · S/N 158313Built 1971 · Doyle Duane S TrusteeN6033SCessna 172S · S/N 172S10191Built 2006 · Suburban Air CorpN629AHCessna 172S · S/N 172S9301Built 2003 · Suburban Air CorpN64912Cessna 152 · S/N 15281473Built 1978 · Suburban Air CorporationN66025Cessna 172S · S/N 172S9777Suburban Air CorpN6827XCessna 172A · S/N 47727Built 1960 · Calderon Daniel CN68CVNorth American Rockwell NA-352 · S/N 352-12Doyle Duane S TrusteeN69ELCessna 182E · S/N 18254060Built 1962 · Lewis Ethel MN714SWCessna 152 · S/N 15279406Built 1977 · Mackin Robert MN7171KGoodyear FG1D · S/N 76628Doyle Duane S TrusteeN74613Grumman American Avn. AA-5B · S/N AA5B-0284Lindstrom Richard TN757JDCessna 152 · S/N 15279769Built 1977 · Suburban Air CorpN765MJCessna 182K · S/N 18258116Built 1967 · Busch RenardN83627Aeronca 7BCM · S/N 7AC-2305Built 1946 · Flagg Robert FN868FAMooney M20J · S/N 24-0980Cardoza Todd JN89FMMooney M20M · S/N 27-0268Radia LLCN8MSPiper PA-23-160 · S/N 23-1993Built 1961 · Flagg Robert FN92321North American FJ-3 · S/N 001FJ3-DDoyle Duane S TrusteeN943GMaule M-7-260C · S/N 30038CBuilt 2005 · Downing John Brent
Back to Castro Valley, CA