OpenAirDocs.org
San Martin, CA

Registered aircraft · 79

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

N1105BChampion 7ECA · S/N 74Built 1965 · Agaliotis Paul EN1138HAeronca 15AC · S/N 15AC-149Built 1948 · Agaliotis Paul EN1181EAltizer J C CHRISTEN EAGLE II · S/N ALTIZER-0001Built 1984 · California Antique Aircraft MuseumN124YWaco RNF · S/N 3303Built 1930 · Haley Billie JoN15114Stinson SR-6B · S/N 9605Agaliotis Paul EN151KMNorth American P-51D · S/N 4474311Mcbride Kenneth BN15536Security National Acft S1-B · S/N 28Built 1938 · California Antique Aircraft MuseumN1581Pitts Special S-1C · S/N JD-1First renewal noticeCalifornia Antique Aircraft Museum DBAN1662EAeronca 7AC · S/N 7AC-5228Built 1946 · California Antique Aircraft Museum DBAN17330Volmer VJ21 · S/N 1Built 1945 · California Antique Aircraft MuseumN186NWestfall-Young BIPLANE · S/N 103Agaliotis Paul EN18GWGrumman SCAN TYPE 30 · S/N 35Built 1949 · Mcbride Kenneth BN21026Aeronca KM · S/N KM-2Built 1938 · Agaliotis Paul EN21083Aeronca KCA · S/N KCA-55Built 1938 · Agaliotis PaulN2298DCessna 170B · S/N 20450Built 1952 · Agaliotis Paul EN2334Waco EGC-8 · S/N 5065Built 1938 · Mcbride Kenneth BN2353JBeech 23 · S/N M-311Built 1963 · Wings Of History Air MuseumN23919Aeronca 65-C · S/N C-5839Agaliotis Paul EN23GPolytron SEA WIND 300 · S/N 07Built 1998 · Polytron CorporationN2549FChampion 7ECA · S/N 7ECA-141Built 1965 · Agaliotis Paul EN2575XCessna P206 · S/N P206-0075Built 1965 · 360 Solo LLCN27740Stinson 10 · S/N 7690Built 1940 · California Antique Aircraft MuseumN2788EAeronca 7AC · S/N 7AC-6371Built 1946 · Stout BrianN2813DGrumman SCAN TYPE 30 · S/N 29First renewal noticeBuilt 1956 · Mcbride Kenneth BN3127TCessna 340A · S/N 340A-0025South Valley Internet IncN3147NChampion 7ECA · S/N 350Agaliotis Paul EN31496Aeronca 65-TC · S/N C5720TAgaliotis Paul EN31499Aeronca 65-TC · S/N 5770TBuilt 1940 · Agaliotis Paul EN3161GNorth American TB-25N · S/N 44-30324ABuilt 1958 · Mcbride KenN31671Waco VKS-7F · S/N 6112Mcbride Kenneth BN3248BPiper PA-22 · S/N 22-2078Agaliotis Paul EN3329KGlobe GC-1B · S/N 1322Built 1946 · California Antique Aircraft Museum DBAN3458XMooney M20E · S/N 1140Built 1966 · Dalton Robert EN3474EAeronca 7AC · S/N 7AC6856Built 1947 · Agaliotis PaulN34SVCarlisle Christopher J KITFOX MODEL II · S/N 707First renewal noticeBuilt 1991 · Mcbride Kenneth BN3627NPiper J3C-65 · S/N 22879Built 1947 · Agaliotis Paul EN36354Taylorcraft DC-65 · S/N 4091Built 1941 · Agaliotis Paul EN36551Aeronca 65-CA · S/N C-16481Built 1941 · Agaliotis Paul EN36981Aeronca 65-TAC · S/N C-3132TABuilt 1942 · Agaliotis Paul Edwin OthaN38409Piper PA-28-181 · S/N 28-7790255Built 1977 · Straub Craig WN399QQuarnoccio Ross A AVID FLYER · S/N 399First renewal noticeBuilt 1990 · Mcbride Ken BN41719Culver LFA · S/N 436California Antique Aircraft MuseumN43083Taylorcraft BC12-D · S/N 6742Built 1946 · Haley Billie JoN43261Taylorcraft BC12-D · S/N 6920Built 1946 · Haley Billie JoN4548EAeronca 7DC · S/N 7DC-147Built 1948 · Agaliotis Paul EN456STCessna 414 · S/N 414-0810Built 1975 · Mcbride KenN4725EAeronca 7EC · S/N 7EC-68Built 1950 · Agaliotis Paul EN48088Taylorcraft DCO-65 · S/N 5294Built 1943 · Agaliotis Paul EN48603Taylorcraft DCO-65 · S/N 6305Built 1944 · Agaliotis Paul EN48824Aeronca L-3B · S/N 058B-4472Built 1942 · Agaliotis Paul E
Back to San Martin, CA