OpenAirDocs.org
Vineburg, CA

Registered aircraft · 17

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

N10613Hayden & Clark W-6 · S/N 1Built 1931 · Presten Eric AN131SKConstrucciones Aeronauticas C.A.S.A. 1.131 · S/N 2033Built 1953 · Presten Eric AN151RSMattson Ronald N S.H. GLASAIR RG I · S/N 228Sonoma Valley Aircraft IncN177FTSoko Factory Yogoslavia TYPE 522 · S/N 177Sonoma Valley Aircraft IncN18983Minx CAPEA · S/N 1Presten EricN303DMFouga CM 170R MAGISTER · S/N FM-81Built 1967 · Sonoma Valley Aircraft IncN3232GNorth American T-28A · S/N 49-1566Batte John HN34939Interstate S-1A · S/N 34Built 1941 · Meeks DavidN39109Presten Eric BLERIOT XI · S/N AB3Built 2009 · Presten Eric AN40HMConstrucciones Aeronauticas C.A.S.A. 1.131E · S/N E3B-525Built 1953 · Sonoma Valley Aircraft IncN45SFHawker SEA FURY TMK 20 · S/N 37724Sonoma Valley Aircraft IncN5875HPiper PA-16 · S/N 16-493Built 1949 · Presten Eric AN5LPCessna 170A · S/N 19695Built 1950 · Meeks TrevorN5WDDodd William J PITTS S-1-S · S/N 105DBuilt 1980 · Sonoma Valley Aircraft IncN6289ECessna 172 · S/N 46389Built 1959 · Maverick Jets LLCN6721ECessna 175 · S/N 56221Built 1959 · Sonoma Valley Aircraft IncN9748YNorth American T-28C · S/N 140551Batto John H
Back to Vineburg, CA