OpenAirDocs.org
Sonoma, CA

Registered aircraft · 157

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 = 'SONOMA'
  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.

N1029PBoeing A75N1(PT17) · S/N 75-813Prevost ChristopherN1047Trone Dennis R LINCOLN SPORT · S/N 101Built 2008 · Bowe Walter C TrusteeN110MRHerald-Ladue SKYBOLT · S/N HL10Built 1988 · Kertz Ryan EN11241Waco QCF · S/N 3453Built 1931 · Bowe Walter C TrusteeN11271Cessna 177B · S/N 17702330Built 1975 · No Coop Cardinal LLCN11293Aeronca C-3 · S/N A-125Bowe Walter C TrusteeN11473Waco QDC · S/N 3514Built 1931 · Bowe Walter CN1151PLarson Midget MUSTANG · S/N L2First renewal noticePapich George JN11795Monocoupe 90A · S/N A-719Built 1937 · Gallarate Raymond DN11936Cessna 150L · S/N 15075714Built 1974 · West Yayoi MN120NVBalony Kubicek Spol Sro BB34Z · S/N 1096Built 2014 · Sonoma Ballooning Adventures LLCN121SCBeech D18S · S/N A-85Built 1946 · North Bay Air MuseumN12332Curtiss Wright TRAVEL AIR B-14-B · S/N 2010Bowe Walter C TrusteeN12452Cessna 172M · S/N 17261992Built 1973 · Cj Aviation LLCN12988Bowe Walter PIETENPOL AIR CAMPER · S/N 1Built 2005 · Bowe Walter C TrusteeN131LVBucker Jungmann C.A.S.A. 1.131 · S/N E3B-480Built 1954 · North Bay Air MuseumN1337Luscombe 4 · S/N 403Built 1938 · Price Ronald WN133JWCASA BUCKER 1.133C · S/N ES-1-42North Bay Air MuseumN136WLincoln Page 1928 · S/N 259Built 1930 · Bowe Walter C TrusteeN13705Lockheed VEGA 5C · S/N 203Built 1933 · Bowe Walter C TrusteeN14866Rose PARRAKEET A-1 · S/N 106Built 1936 · Bowe Walter C TrusteeN14919Pasped SKYLARK W1 · S/N 1Built 1935 · Bowe Walter C TrusteeN14963Kinner PLAYBOY R · S/N 228Bowe Walter C TrusteeN1499Curtiss Wright TRAVEL AIR 4000 · S/N 164Berwick Robert GN1502SBeech P35 · S/N D-6899Makiva SashaN154TBEmerson/Smith CUBY · S/N TB001Built 1985 · Berwick Robert GN1558DCessna 195 · S/N 7780Belden George B TrusteeN1562KLuscombe 8A · S/N 4289Built 1946 · Clark Stephen RN16039Ryan Aeronautical ST-A · S/N 128Built 1936 · Bowe Walter C TrusteeN1625BLuscombe 11A · S/N 11-131Built 1948 · Price Ronald WN170DWCessna 170A · S/N 19154Built 1949 · Belden George BN17469Waco DQC-6 · S/N 4544Built 1937 · Bowe Walter C TrusteeN179KMonocoupe MONOPREP · S/N 6077Built 1929 · Bowe Walter C TrusteeN1826Waco ASO · S/N 914Built 1927 · Bowe Walter C TrusteeN18629Monocoupe 110 · S/N 6W00Bowe Walter C TrusteeN18764Arrow Aircraft & Motors ARROW SPORT M · S/N 105Built 1938 · Bowe Walter C TrusteeN19342Cessna 150L · S/N 15074352Built 1973 · Wojciechowski CalvinN204MWaco DSO · S/N 3003Bowe Walter C TrusteeN206YEaglerock A-1 · S/N 981Bowe Walter C TrusteeN209VFairchild KR-21 · S/N 1032Built 1930 · Bowe Walter C TrusteeN2125YCessna 172D · S/N 17249625Built 1962 · Palmer Ronald Everett TrusteeN221MFairchild KR-34C · S/N 390Bowe Walter C TrusteeN22973Piper J3C-65 · S/N 2870Built 1939 · Bowe Walter C TrusteeN22ZGInskeep George W G-202 · S/N 001Built 2002 · Inskeep George WN245NSBalony Kubicek Spol Sro BB51Z · S/N 863Built 2011 · Spear JeffreyN24UMUltramagic S A N-300 · S/N 300/129Built 2025 · Sonoma Ballooning Adventures LLCN2533FChampion 7ECA · S/N 155Built 1965 · Macdonald Craig RN258YAero Antiques IMIT TRVLAIR R TYPE · S/N LAA-362-14892Built 2012 · Bowe Walter C TrusteeN261RECessna 310 · S/N 35284Peterson Randy JN2628PPiper PA-22-150 · S/N 22-2965Craig Richard L
Back to Sonoma, CA