OpenAirDocs.org
Sebastopol, CA

Registered aircraft · 38

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

N12095Cessna 177B · S/N 17702385Built 1975 · Ciddio Mark SN1298DCessna 170A · S/N 19874Built 1951 · Glaser Gerald AN140JHCessna 140 · S/N 10223Built 1946 · Ohlin Christian AN149LFFord L M/Ford G R GLASAIR SH-2R · S/N 395Ford Larry MN15473Piper PA-28R-200 · S/N 28R-7335061Cerniglio Dominic AntonioN166DDelano Dan VANS RV-6 · S/N 20222Built 1991 · Joyce Michael PN175DMCub Crafters CC19-215 · S/N CC19-0084Built 2023 · Delmar EricN188EUEurocopter AS 350 B3 · S/N 7188Built 2011 · Lashinski Robert D TrusteeN234ABBeech F33A · S/N CE-1562Built 1991 · Bachteal Paul ShearN321WERobinson Helicopter R66 · S/N 0177Built 2012 · 321we Airtour LLCN33MCPiaggio P180 · S/N 1051Built 2001 · Twin Rivers Aircraft LLCN3544SCessna 172E · S/N 17250744Built 1963 · Tucker NicholasN35792Cessna 172I · S/N 17256964Drerup Henry JN459FJohn R Fitt KOLB FIRESTAR · S/N FS II-459Built 2019 · Fitt John RN460YRHawker Beechcraft G36 · S/N E-3890Built 2009 · Mathias Lee R TrusteeN4674UCessna T210N · S/N 21064802Built 1983 · Klein DavidN523FPCook Ernest W KITFOX SUPER SPORT · S/N KA07167109Built 2022 · Cook Ernest WN550AWWerback Andrew R LANCAIR LEGACY · S/N L2K-112Built 2010 · Werback Andrew RN6089HPiper PA-28R-201T · S/N 28R-7803088Built 1977 · Gromer Gerald MN63GHDiamond Aircraft Ind DA 42 NG · S/N 42.N182Built 2015 · Diatus LLCN6992ECessna 175A · S/N 56492Built 1960 · Mikkelsen John PN69RNRockwell WITTMAN TAILWIND W-8 · S/N 412Built 1980 · Leong Peng HN7090XCessna 150A · S/N 15059190Built 1961 · Goodrich Dianna LN7201NBeech V35A · S/N D-8815Built 1968 · Williams Evan HN725XCessna 140 · S/N 9723Built 1946 · Frank De NiroN7771GCessna 172L · S/N 17259471Built 1970 · Empire Aero Club IncN79506Cessna 172K · S/N 17258138Built 1969 · Allen Michelle EN8074TPiper PA-28-181 · S/N 28-8090062Built 1979 · Williams Evan HN8256EPiper PA-28-161 · S/N 28-8116014Built 1980 · Williams Evan HN8329HEmigh TROJAN A-2 · S/N 32Built 1948 · Larose TimothyN83BFPiper PA-23-250 · S/N 27-7654171Built 1976 · Hayssen Arthur HN848JPAircove RV 7A · S/N 71421Built 2009 · Holt Otis TrusteeN8613BCessna 172 · S/N 36313Built 1957 · Grieve David AN879APiper PA-22 · S/N 22-204Built 1951 · Kirwan CaseyN9163GCessna 182N · S/N 18260703Built 1971 · Hayssen Arthur HN927ASSivaslian Armen H THORP T-18 · S/N 927Built 1981 · Zlotnick Quincy J P AN93BLSocata TBM 700 · S/N 1198Built 2017 · Lashinski Robert D TrusteeN9744QBeech C23 · S/N M-1314Built 1970 · Long Richard
Back to Sebastopol, CA