Walnut Creek, CA

Registered aircraft · 95

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 = 'WALNUT CREEK'
  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.

N111XWExtra Flugzeugbau EA-300 · S/N 064Built 1997 · United Air LLCN1407UCessna 172M · S/N 17267077Built 1976 · N R I Flying ClubN151BWNorth American/Aero Classics P-51D · S/N 44-74813124x LLCN155DGCessna T210N · S/N 21064815Built 1983 · Juliet Tango Flying Services LLCN156PCPilatus PC-6/B2-H2 · S/N 777Built 1976 · Idaho Skyworks LLCN159LGRob Holmes VANS RV-7 · S/N 75017Built 2024 · Holmes RobN166BJSanches William A RV-10 · S/N 40608Built 2014 · Buddy & Holly LLCN171KKParker Judson B SERIES 5 · S/N S9506-0130First renewal noticeDi Sessa Alexandre BN20506Mooney M20M · S/N 27-0238Built 1997 · Lim ArnoldN20BGGlodfelty W L CHRISTEN EAGLE II · S/N GLODFELTY 001Built 1984 · Hull Matthew EN21348Cessna 182P · S/N 18261578Built 1972 · Nri Flying Club IncN21SAMalecha A C VANS RV-7A · S/N 70739Built 2010 · Achelis ScottN23135Piper J-3 · S/N 2918Built 1939 · Scott Harry Jr TrusteeN232DEApex CAP 232 · S/N 39Built 2002 · Tentacle CorpN235TBPaul R Scott ZENITH CH 750 · S/N 75-10347Built 2018 · Scott Paul RN240HCBeech 58P · S/N TJ-221Built 1979 · Blodgett James RN2500KLuscombe 8E · S/N 5227Built 1947 · Schroder John Ted IVN2501CCessna 170B · S/N 26145First renewal noticeBuilt 1953 · Lloyd Peter MN2581VCessna 177RG · S/N 177RG0625Built 1974 · Mink Stephen EarlN2657YCessna 180E · S/N 18051157Built 1962 · Nagy Leslie SN2759KLuscombe 8E · S/N 5486Ott Edward CN2938UPiper PA-28-181 · S/N 28-7990574Built 1979 · Archer Two Aviation LLCN29488Cessna 177 · S/N 17700921Built 1968 · Luther Charles AN301DEExtra Flugzeugbau EA 300/L · S/N 041Built 1997 · Tentacle CorpN3100DCessna 180 · S/N 31898Built 1955 · Diel Mark AN32386Piper PA-28-140 · S/N 28-7525058Built 1974 · Rice Craig WN331JTCessna A185E · S/N 18501899Built 1972 · Juliet Tango Flying Services LLCN3455WPiper PA-32-260 · S/N 32-324Built 1966 · Clark James AN36XCCessna 182Q · S/N 18267223Built 1979 · Hangar C-403 LLCN375BFAviat S-2C · S/N 6071Built 2005 · Db Aviation LLCN3779NMooney M20F · S/N 680116Obrien Edward TrusteeN3781VCessna 140A · S/N 15202Built 1949 · Hammitt Thomas KN39007Grumman American Avn. AA-1C · S/N AA1C0181Built 1978 · Cooper Sean Patrick WhittingtonN398CCCubcrafters CC11-160 · S/N CC11-00398Built 2016 · Juliet Tango Flying Services LLCN3SZHearne Roy A GLASAIR III · S/N 1Built 1989 · Wiebens Peter MN4087RPiper PA-32-300 · S/N 32-40405Built 1967 · Watt Nathan AN417CCessna 525C · S/N 525C0021Built 2010 · Wing And A Prayer IncN422ESSimmons Gary F STOL CH 701 · S/N 7200Fedorov RomanN427CTFlight Design CTSW · S/N 07-03-10Built 2007 · Kite Hill Dreams LLCN43070Piper PA-32-300 · S/N 32-7440115Built 1974 · Wkb Aviation LLCN4568NCessna 340A · S/N 340A0549Built 1978 · Bergren Scott W TrusteeN45EACirrus Design SR20 · S/N 11097Built 2025 · Echo45 Aviation LLCN4651SBeech A36 · S/N E-766Built 1975 · Scranton ChristianN48525Piper J3C-65 · S/N 9441Built 1942 · Olson Lawrence GN4881SPiper PA-32-260 · S/N 32-7100005Built 1970 · Guerin Brian JN491ACCessna T210N · S/N 21063673Ew Pegasus LLCN5009KNanchang China CJ-6A · S/N 4132021Built 1985 · Concord Flyers LLCN51PTNorth American F-51D · S/N 44-72145Built 1958 · 124x LLCN5223ACessna T210N · S/N 21063316Built 1979 · General Plumbing IncN526STColumbia Aircraft Mfg LC41-550FG · S/N 41726Built 2007 · Sims Stuart P
Back to Walnut Creek, CA