OpenAirDocs.org
San Jose, CA

Registered aircraft · 374

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 = 'SAN JOSE'
  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.

N1021EBellanca 7ECA · S/N 1204-77Built 1977 · Young David SN1023WBeech F33A · S/N CE-421Built 1973 · Goldeagle Flyers IncN104TQCirrus Design SR22 · S/N 2304Built 2006 · Gtw Aviation LLCN105CTParadise USA PARADISE P-1 SLSA LW · S/N 0116Ahuja AshwiniN106DSPdps Pzl-Bielsko SZD-51-1 JUNIOR · S/N B1840Built 1988 · Bay Area Soaring Associates IncN1086WBeech B36TC · S/N EA-586Built 1996 · Thomas R Cave IncN1114ZRaytheon C90A · S/N LJ-1514Built 1998 · Carefree Air LLCN111LRC And H Aircraft Restoration I PITTS LR1 · S/N 001Built 2004 · Lo Jeffrey GN113DRCessna 172M · S/N 17265961Built 1975 · California In Nice IncN1143DCessna 140A · S/N 15706Built 1951 · Swanland Robert CN115SZCommander 114TC · S/N 20036Built 2000 · Three Greens LLCN11681Bellanca 7KCAB · S/N 308-72Built 1972 · Amelia Reid Aviation LLCN1181MCessna 172K · S/N 17258681Built 1969 · Chin DavidN120TASchempp-Hirth DISCUS CS · S/N 246 CSHagleitner GuntherN12234Cessna 172M · S/N 17261896Built 1973 · Amelia Reid Aviation LLCN12388Cessna 172M · S/N 17261962Built 1973 · Autry Lonnie EN123EDRaytheon HAWKER 800XP · S/N 258366French Fly LLCN126TWCessna 172M · S/N 17260900Built 1972 · Aerial Advertising ServicesN127FBeech 95-B55 (T42A) · S/N TC-869Built 1965 · California In Nice IncN127MMSchleicher ASW-27 · S/N 27228Built 2004 · Roach Brian LN12888Bell 47D · S/N 20Built 1947 · Suess Robert DN128SHTextron 172S · S/N 172S12457Built 2020 · California In Nice Inc DBAN1313BBellanca 14-19-2 · S/N 4072Built 1958 · Swanland Robert CN134AJCirrus Design SR22 · S/N 1511Built 2005 · Timmermans JamyN135NASchleicher Alexander ASH 26 E · S/N 26184Built 2001 · Wolf-Dietrich WeberN13SGSchempp-Hirth DISCUS B · S/N 69Built 1985 · Bay Area Soaring Associates IncN141WPJay Gilbert LANCAIR EVOLUTION · S/N EVO-0055Built 2014 · Jb Family Enterprise LLCN1455XPiper PA-28R-200 · S/N 28R-7535285Built 1975 · Aviation Capital Management LLCN146MAAmerican Champion 8KCAB · S/N 903-2002Built 2002 · Hong TedN147CCPiper PA-28RT-201T · S/N 28R-8131025Built 1980 · Bright Skies IncN14BBina Melvin J VELOCITY STANDARD RG · S/N DMO 157Feinberg Eugene MN150EHCessna 150J · S/N 15070883Built 1969 · Pouya HamidN1514RBalony Kubicek Spol Sro BB30D · S/N 1751Built 2020 · Thornton DanaN152TBeech P35 · S/N D-6956Built 1962 · Conrad Clayton MN155KMCirrus Design SR22T · S/N 0027Built 2010 · Mcintyre Kristen AlisonN1625UCessna T210N · S/N 21064710Built 1982 · Fly2k LLCN164DPPiper PA-28-161 · S/N 28-8016190Built 1979 · Aviation Capital Management LLCN1701HBellanca 7KCAB · S/N 454-74Built 1974 · Amelia Reid Aviation LLCN17639Beech A36 · S/N E-997Built 1977 · Peterson Eric SN17738Beech F33A · S/N CE-702Built 1977 · Lambert Michael CN1793VCessna 172M · S/N 17263753Built 1974 · Aviation Capital Management LLCN1806GChampion 7ECA · S/N 573Built 1968 · Amelia Reid Aviation LLCN1808BBernardo Fourcade SLING TSI · S/N 552SKBuilt 2025 · Fourcade Bernardo EN1819QCessna 177RG · S/N 177RG0219Built 1971 · Schmidt MarkN1823YBeech 77 · S/N WA-290Built 1981 · Spenner Herbert CN1824Cessna 182 · S/N 18260285Built 1970 · Luvara Michael SN183EJJohn Clear SPORTSMAN GS-2 · S/N 7464Built 2017 · Clear JohnN183USchempp-Hirth VENTUS-2C · S/N 30Built 1997 · Van Weersch Johannes MN18763Beech A36 · S/N E-1158Registration pendingBuilt 1977N1906SSocata TB-20 TRINIDAD · S/N 1906Built 1999 · Miskovic Dejan
Back to San Jose, CA