OpenAirDocs.org
San Clemente, CA

Registered aircraft · 40

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 CLEMENTE'
  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.

N10YUGulfstream Aerospace G-IV · S/N 1030Built 1987 · Nutrawise CorpN112WGCirrus Design SR22T · S/N 9785Built 2024 · Griswold Aviation LLCN136NDiamond Aircraft Ind DA 40 · S/N 40.1156Built 2012 · Guthrie Richard DN1517KDJI INSPIRE 1 · S/N W13DCE15030779California State ParksN15DJohnson STARDUSTER JSA 1 · S/N G&H-1Built 1962 · Asp Annika LN16JNGulfstream Aerospace G-IV · S/N 1292Built 1996 · Sonance Rocket LLCN18716Cessna 150L · S/N 15074056Built 1972 · Gem LLCN223JLewis Jacob S RV-7 · S/N 73246Built 2012 · Lewis Jacob SN226MECessna T206H · S/N T20608191Built 2000 · Lawson TimN228PTFairchild M-62C(PT-23A) · S/N 230SLCousineau Paul JN241PCAmerican Champion 7GCBC · S/N 1385-2005Built 2005 · Plucinski David JN292CMIrvani Suzanne RV-10 · S/N 40772Built 2009 · Irvani SuzanneN2988BBen J Oliver BUSHWAGON 2 · S/N 1002Built 2012 · Longobardo AnthonyN3118QCessna 182K · S/N 18258118Built 1967 · Vercoe TrevorN3763QBeech V35 · S/N D-8399Built 1967 · Orr RobertN433SBCessna 182M · S/N 18259876Built 1969 · Rico Kermot Aviation LLCN43BGBeech B300 · S/N FL-117Built 1994 · Right Brothers LLCN471HBCessna 414 · S/N 414-0923Built 1977 · Myers Ralph EN5212DCessna 180A · S/N 50110Built 1957 · Vanderpool Celia CN57387Consolidated Vultee BT-13A · S/N 3075Built 1942 · Cousineau Paul JN6222JPiper PA-32R-300 · S/N 32R-7680335Built 1976 · Safaero IncN622FMDJI PHANTOM 3 PROFESSION · S/N P76DCF18011124Mixon Edgar AN63EEQuicksilver Mfg SPORT 2S · S/N 0001Built 1999 · Mitchell Graham CharlesN644BLBeech B36TC · S/N EA492Built 1989 · Gahan MatthewN703RQDJI PHANTOM 3 PROFESSION · S/N P77DCG18016907C2 CollaborativeN705MRRobinson Helicopter R66 · S/N 0904Built 2018 · Destinations Unlimited LLCN72420Powrachute AIRWOLF 912 ULS · S/N A420ULSBuilt 2023 · Precision Aeronautics IncN72422Powrachute AIRWOLF 912ULS · S/N A421ULSBuilt 2023 · Precision Aeronautics IncN72427Powrachute AIRWOLF 912 ULS · S/N A451ULSBuilt 2025 · Precision Aeronautics IncN72428Powrachute AIRWOLF 912 ULS · S/N A452ULSBuilt 2025 · Precision Aeronautics IncN72429Powrachute AIRWOLF 912 ULS · S/N A453ULSBuilt 2025 · Precision Aeronautics IncN735DBCessna 182Q · S/N 18265333Built 1977 · Sailsbery Brett EN776JJones Henry Sherk PULSAR · S/N 105Foster Clark BN7827TCessna 172A · S/N 47427Toler Gary PN7HYFolland GNAT T 1 · S/N FL529Built 1962 · Asp HeikeN8964MBeech 35-B33 · S/N CD-720Built 1963 · Plucinski David JN92NPPlucinski David J RANS S-7S COURIER · S/N 0911564Built 2011 · Plucinski David JN949PMEpic E1000 · S/N K028Built 2022 · Wcr Diversions LLCN9565VCessna R172K · S/N R1722332Built 1977 · Hijazi Sakher SamirN975PCCessna 182P · S/N 18263546Built 1975 · Beck Steven
Back to San Clemente, CA