San Carlos, CA

Registered aircraft · 44

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

N111RKCessna 152 · S/N 15280874Built 1977 · San Carlos Flight Center IncN1128RCirrus Design SR22T · S/N 2338Built 2021 · Peninsula Research LLCN1163GMooney M20J · S/N 24-1292Built 1982 · Russon Tyler GN146ARCessna 510 · S/N 510-0413Built 2012 · Jet Stream LLCN1483LCessna 182T · S/N 18281960Built 2007 · 83l Ventures LLCN182WDCessna TR182 · S/N R18200848Built 1979 · Lewis W D IIIN21591Cessna 172S · S/N 172S9658Built 2004 · Kohn Aviation LLCN21CEConterno John M CHRISTEN EAGLE II · S/N CONTERNO 0001Built 1982 · Alaimo Frank VN236SPCessna 172S · S/N 172S8213Built 1999 · 83l Ventures LLCN296MECessna 172S · S/N 172S8554Built 2000 · Jwl Aviation LLCN3242KGlobe GC-1B · S/N 1235Built 1946 · Porter Thomas GN330ZZExtra Flugzeugproduktions EA 300/SC · S/N SC067Built 2016 · Combs Christopher Kevin TrusteeN3487XMooney M20C · S/N 3424Built 1966 · Krzeminski Paul AN3717Robertson William C ROBERTSON SNS-7 · S/N 001Taylor Charles RN3829SCessna 172E · S/N 17251029Built 1963 · Hagler Bennett JN39ABJonker Sailplanes JS3 · S/N 03-051Built 2019 · Aero Systems Associates LLCN3MTEclipse EA500 · S/N 000135Built 2008 · Brodersen Robert TrusteeN40THelio HT-295 · S/N 1702Built 1974 · Dobel Robert F II TrusteeN410GRTom Ritchey RITCHEY EXPRESS · S/N 2004001RRd Leasing LLCN432SCessna 180A · S/N 32879Built 1957 · Ulman MorrisonN466CCCessna T206H · S/N T20608835Built 2008 · Kohn AndresN49RTRichard Treanor VANS RV-7A · S/N 72191Built 2023 · Flying 7 PartnersN54JACessna 172R · S/N 17280607Built 1998 · San Carlos Flight Center IncN5537VBeech B36TC · S/N EA-506Built 1990 · Wheelzup LLCN5656CCessna 140A · S/N 15612Scully Michael JN57133Cessna T206H · S/N T20608522Built 2005 · Grove Ronald DBAN616PJCessna 182Q · S/N 18267121Built 1979 · Larson Paul SN6232VBeech 36 · S/N E-4Built 1968 · Wallace John BN642NDTextron 172S · S/N 172S11616Built 2015 · Pelican Flight Training LLCN6514MSchleicher ASW-20C · S/N 20801Built 1985 · Colton Daniel RN653NDCessna 172S · S/N 172S11469Built 2014 · Pelican Flight Training LLCN66FCirrus Design SR22T · S/N 1931Built 2019 · Vector Victor LLCN702TBSocata TB-20 TRINIDAD · S/N 2030Built 2000 · Goshen ShmuelN72KHHester-Chow Stewart K RV-7A · S/N 71381Built 2005 · Staton Kenneth LN7867WPiper PA-28-180 · S/N 28-1888Built 1964 · Gilmore John JN7869WPiper PA-28-180 · S/N 28-1891Built 1964 · Lichtenstein James EN8143ZCessna 210-5(205) · S/N 205-0143Built 1962 · Moojens LLCN8225RPiper PA-32R-301T · S/N 32R-8029100Built 1980 · Norris Craig AN842LADiamond Aircraft Ind DA 40 NG · S/N 40.NC132Built 2021 · Tribal Aviation LLCN872LDAndy Delk RV-8 · S/N 81850Built 2018 · Beacon Ai IncN9094GCessna 182N · S/N 18260634Built 1971 · Ricks Thomas CN916KTTextron 172S · S/N 172S12763Built 2021 · Pelican Flight Training LLCN9456DCessna 172RG · S/N 172RG1171Built 1984 · Majka MarcN962TFVans RV-12IS · S/N 121033Built 2020 · Flying 12 Club LLC
Back to San Carlos, CA