OpenAirDocs.org
Santa Clara, CA

Registered aircraft · 41

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 = 'SANTA CLARA'
  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.

N1117UCessna 172M · S/N 17266852Built 1976 · Bhp AviationN117MQAeromot AMT-300 · S/N 300.106Carmel PaulN119CMOlson Calvin M CHRISTEN EAGLE II · S/N 00001Built 1987 · Sahm Ralph KN11KXPiper PA-32-301T · S/N 32-8224004Built 1981 · N11kx LLCN1287VSchleicher K 8 B · S/N 881Norris Eric BrentN12MKCessna 421C · S/N 421C0421Indus Health IncN176XBeech A36 · S/N E868Built 1976 · Club Turbo 176 LLCN223XPiper PA-34-200T · S/N 34-7970288Saleem Sandhu MN230DWBok Hans LAZER · S/N HB-1Built 1997 · Horwich Joshua BN272PSBeech F35 · S/N D-4056Normandie Air LLCN2982ACessna 180 · S/N 30182Built 1953 · Skywagon Pilots IncN32539Piper PA-28-180 · S/N 28-7505050Built 1974 · Orosz RyanN351HKHoffmann HK 36R SUPER DIMONA · S/N 36351Mann Richard AN405BALet L 33 SOLO · S/N 020605Norris Eric BN410HPPiper PA46-500TP · S/N 4697413S&W Air LLCN4352GPiper PA-28-161 · S/N 28-8416074Built 1984 · Bouza MarioN439AMMurray Aaron J VANS RV-6 · S/N 20439Built 2009 · Murray Aaron IN5024PPiper PA-24-180 · S/N 24-27Built 1958 · Sun Aviation IncN515MHCirrus Design SR22 · S/N 3841Built 2012 · Windward Aviation CorpN539CStinson 108-3 · S/N 108-3539Built 1947 · Murray Aaron JN53KPCessna 182T · S/N 18281541Built 2005 · Mateos Louise MN5493PPiper PA-24-250 · S/N 24-554Gear Up Aviation LLCN554TCessna 550 · S/N 550-1100Built 2005 · T & T Enterprises LLCN563DWCessna 560XL · S/N 560-6169Built 2014 · Dog Air LLCN572PSFouga CM 170 MAGISTER · S/N 472Built 1965 · Piednoel FrancoisN575TXCirrus Design SR22 · S/N 3520Built 2010 · Hu JianingN6743CBeech 58P · S/N TJ-269Built 1980 · Rocket Ems IncN714JCCessna 150M · S/N 15079203Built 1977 · Aries Flyers IncN717HWGregory Mazzola SLING HW · S/N 075GKBuilt 2025 · Stupid Temptation LLCN721TPCirrus Design SR20 · S/N 11306Built 2026 · Bytra Aviation LLCN74465Grumman American Avn. AA-5B · S/N AA5B-0237Built 1976 · Clarabut AlexanderN761SAeropro CZ A220 · S/N 34311Built 2011 · Fugal HansN7710Scheibe L SPATZ III · S/N 819Built 1966 · Carmel Paul AN79AUPiper PA-32R-301T · S/N 3257463Built 2007 · Epsman Kenneth AN8178Schleicher ASW-15 · S/N 15039Built 1970 · Carmel Paul AN8643VBellanca 7GCBC · S/N 817-75Built 1975 · Luvara Christopher JN86HWWalker Jj/Hull Da VANS RV-4 · S/N WHB-RV4-301Built 2009 · Walker James JN89ELBellanca 17-30A · S/N 89-301009Built 1989 · Horner James GN90478Satterlee Royce E GLASAIR SUPER II RG · S/N 2354Built 2003 · Right 360N9148WMooney M20M · S/N 27-0106Built 1991 · D & D Kaye IncN9171ZMooney M20R · S/N 29-0036Built 1995 · Hesterberg Brett
Back to Santa Clara, CA