OpenAirDocs.org
Windsor, CA

Registered aircraft · 29

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

N112DDDruen Daniel L CHALLENGER II · S/N CH2-0701-2117Built 2002 · Mccune Randall DN1166VCessna R172K · S/N R1722130Built 1976 · Clark John AN124DHVans RV-12 · S/N 120496Built 2013 · Heal David BN1675WBeech F33A · S/N CE-398Harper Jerad VincentN20230Cessna 172M · S/N 17261115Built 1972 · Cessna 20230 LLCN2115GCessna 182A · S/N 51415Built 1958 · Broeske Ian DN2434HErcoupe 415-C · S/N 3059Built 1946 · Bigham DylanN3371KGlobe GC-1B · S/N 1364Rengstorf LarryN340HCCessna 340A · S/N 340A0638Propjet 210 Aviation IncN344AAGulfstream Aerospace G-IV · S/N 1186Built 1992 · Absolutamente LLCN3691YCessna 210C · S/N 21058191Hunt Lynn C TrusteeN3943XPiper PA-28R-200 · S/N 28R-7535362Built 1975 · Suberg Valerie GN3987PPiper PA-18-150 · S/N 18-4747Built 1956 · Elliff TylerN416CGrumman HU-16C · S/N 131911Hunt Lynn CN4435TYakovlev YAK 52 · S/N 844810Built 1984 · Penning Steven GN5512YMaule MX-7-180AC · S/N 33003CPropjet 210 Aviation IncN556LUDiamond Aircraft Ind DA 40 · S/N 40.763Built 2007 · Oriens Flight LLCN56347Maule M-5-235C · S/N 7277CBuilt 1979 · Smith DaleN6203Curtiss Wright TRAVEL AIR 4000 · S/N 655Built 1928 · Penning Steven GN707TETyler V Elliff MEYERFLYER · S/N 00001Built 2025 · Elliff Tyler VincentN71833Cessna 182M · S/N 18259772Vega AlN7557BChampion 7FC · S/N 7FC-59Built 1957 · Tovani Michael ON7752CNaval Aircraft Factory N3N-3 · S/N 4353Built 1960 · Penning StevenN8187SCessna 150F · S/N 15061787Counter KevinN83GGBeech A36 · S/N E-2101Built 1983 · Cec Aviaiton Services LLCN91455North American NAVION · S/N NAV-4-100Built 1946 · Smith Thomas LN925GBLloyd Thomas W TWLRV8SP · S/N TWL01Built 2005 · Elliff Budd AN9318Waco UPF-7 · S/N 5345Elliff Bud AN987ABBeech E-90 · S/N LW-269Built 1978 · Dirty Joe Aviation LLC
Back to Windsor, CA