OpenAirDocs.org
Gilroy, CA

Registered aircraft · 67

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

N11052Champion 7ECA · S/N 7ECA-66Built 1965 · Prather Carl LynnN11946Cessna 150L · S/N 15075724Built 1974 · Solari Michael RN131JMAviat A-1B · S/N 2150Built 2001 · Moffitt John SN1337VDejan Vucinic SUBORBITAL II · S/N 002Vicinic DejanN1353HAeronca 15AC · S/N 15AC397Built 1949 · Heredia Richard AN1457EAeronca 7AC · S/N 7AC-5020Built 1946 · Prather CarlN149TMChristen Industries PITTS S-2B · S/N 5165Boundless Action Sports LLCN15457Northwestern PORTERFIELD 35-70 · S/N 157Built 1950 · Prather Carl LynnN17040Porterfield 35-70 · S/N 240Built 1976 · Prather Carl LN17742Waco ZGC-7 · S/N 4580Built 1937 · Nurge Richard JN1826NCessna 120 · S/N 12070Built 1946 · Henry Dean RN224CRPilatus PC-24 · S/N 239Built 2021 · Christopher Ranch LLCN24631Beech C23 · S/N M-1459Built 1973 · San Jose Mixer IncN246TSC A Tecnam P2002 SIERRA · S/N 240Lander David WN286HMDJI AGRAS T40 · S/N 1581F574B226M00101VFM & T FarmsN28WKBeech D17S · S/N 4872Nurge Richard JN2912EAeronca 7AC · S/N 7AC-6495Built 1946 · Prather Carl LynnN306CSTextron T206H · S/N T20609225Built 2016 · Security Alert Aviation LLCN33746Piper PA-28-180 · S/N 28-7505175Built 1975 · Lynch RyanN36217Taylorcraft BL12-65 · S/N 3171Nurge Richard JN3687PPiper PA-18 · S/N 18-4588Sochan Mark GN36ECEngineering & Research ERCOUPE 415-C · S/N 3742Built 1946 · Garcia Raymond FN37406Interstate S-1A · S/N 249Built 1942 · Lander David WN37436Interstate S-1A · S/N 281Built 1942 · Lander David WN4013KBeech D17S · S/N 6885Nurge Richard JN40932Piper J3C-65 · S/N 7591Nurge Richard JN410NFCessna 414A · S/N 414A0102Built 1978 · Murphy Aviation IncN41STBeech B-60 · S/N P-340Built 1975 · Gavilan College FoundationN4305URaytheon A36 · S/N E-3305Built 2000 · Marshall Paul A TrusteeN45048Naval Aircraft Factory N3N-3 · S/N 2705Nurge Richard JN4514WWilkins Kenneth E #1 · S/N 226Built 2006 · Kontorinis Brandon CN45805Luscombe 8A · S/N 2332Built 1946 · Prather Carl LN4681LCessna 172G · S/N 17254676Omer SyedaN47486Taylorcraft DCO-65 · S/N 5083Built 1943 · Prather Carl LN47590Fairchild 24W-41A · S/N W41A509Nurge Richard JN4NVCessna 177RG · S/N 177RG0924Built 1976 · Endter VincentN51DNBeech E-90 · S/N LW-7Built 1972 · Djl Investments LLCN52474Boeing A75L300 · S/N 75-2350Built 1941 · Stearman Pilots LLCN5321HPiper PA-16 · S/N 16-126Nurge Richard JN5827DPiper PA-22-150 · S/N 22-4502Nurge RichardN618PRemonov Air EPIC LT · S/N 023Built 2009 · Air Mj LLCN6422WPiper PA-28-140 · S/N 28-20492Built 1964 · Domler Michael RN65013Baudrexl Rainer ENDURO · S/N 001Built 2007 · Kabai ImreN66620Taylorcraft DC-65 · S/N 6138Built 1942 · Prather Carl LN701EWaco ASO · S/N 1942Nurge Richard JN71056Piper J3C-65 · S/N 18077Built 1946 · Wilcher Trevor CN71298Cessna 182M · S/N 18259567Built 1969 · Belanger Patrick J TrusteeN734URCessna 172N · S/N 17269129Kastle Todd TrusteeN745TACostruzioni Aeronautiche Tecna ASTORE · S/N 045Built 2015 · Lander David WN75171Piper PA-28-235 · S/N 28-7610110Built 1976 · Horsepower Aviation LLC
Back to Gilroy, CA