OpenAirDocs.org
Modesto, CA

Registered aircraft · 134

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

N1009DCessna 195A · S/N 7617Built 1950 · Welch Thomas RN1064KLuscombe 8A · S/N 3791Built 1946 · Stein AndrewN119PPCessna 305A · S/N 22787Mount Glenn WN11SNBeech C90 · S/N LJ-1036Built 1982 · Ssj Holdings LLCN121TFPiper PA-32R-301T · S/N 3257351Built 2004 · Torres JuanN1224PCessna 182T · S/N 18281357Built 2004 · M3 West IncN125DJHawker Beechcraft 400A · S/N RK-531Built 2007 · N125dj LLCN130PTFairchild M-62C(PT-23A) · S/N 325H0Built 1942 · Mount Glenn WN143TTCessna LC41-550FG · S/N 411154Built 2010 · J&W Outdoors LLCN145ERRamsdell Edmun L BREEZY · S/N R-001Built 1989 · Welch Thomas RN14984Ryan Aeronautical ST-A · S/N 116Built 1936 · Monaco Donald F TrusteeN154WWillis Ramsdell RV4R · S/N 154Built 2017 · Ramsdell Willis LN1710ATextron G58 · S/N TH-2462Built 2016 · Bald Mtn LLCN184MTTerpstra Michael J VANS RV-8 · S/N 81241Built 2007 · Terpstra Michael JN1950VCessna 182Q · S/N 182-67632Built 1980 · Jenson Kenneth EN1953DBeech C35 · S/N D-3233Fox Christopher RN2063DBeech D35 · S/N D-3404Jolly Delbert BN206LWBell Helicopter Textron 206L-1 · S/N 45182Built 1978 · Stanislaus County Sheriffs DepartmentN2070LBeech 58 · S/N TH-753Built 1976 · Baron 70 Lima LLCN208MBBolkow BOLKOW JUNIOR 208 · S/N 538Webb Warren CN209PDGippsaero PTY GA8 TC-320 · S/N GA8-TC 320-12-186Built 2012 · Modesto Police DepartmentN2363VCessna 140 · S/N 14599Built 1948 · Terpstra Trevor WN24089Boeing 737-242C · S/N 20455Ploutz LloydN240RVKyle W Kinyon RV-4 · S/N 2771Built 2011 · Bauman Lance CN247AHDJI AGRAS T20P · S/N 1581F574B237A00101KTWest Coast Drone Application LLCN2568WMooney M20C · S/N 3272Sale reportedBuilt 1965N2654HEngineering & Research ERCOUPE 415-C · S/N 3279Built 1946 · De Vargas Norberto XN274ACAmerican Champion 7EC · S/N 1014-2007Built 2007 · Welch Thomas RN27GWMarflite CHRISTIAN EAGLE II · S/N 0002Built 1982 · Watson Gary RN2836UCessna 172D · S/N 17250436Built 1963 · Solymanbeyk WillardN2861DQuarton BABY ACE · S/N AGQ-1Built 1957 · Stein DaveN2887RCessna 182K · S/N 18258487Built 1967 · Naylor Michael ScottN3023BCessna 195B · S/N 7906Built 1952 · Welch Thomas RN302PSBeech 300 · S/N FA-213Built 1990 · F90x LLCN30742Azevedo Manuel J AVID ACFT MARK IV · S/N 1517DBuilt 2002 · Azevedo Manuel JN3074HEngineering & Research ERCOUPE 415-C · S/N 3699Built 1946 · Johnson Victor RN31JBCessna 172N · S/N 17273002Lucian Aviation LLCN332MMCirrus Design SR22 · S/N 10749Built 2025 · Ran Health Services IncN334ZPDJI T20 · S/N 64UBK7B00100M5Perez StephenN335SFCessna T210M · S/N 21062413Built 1977 · Ramont Ronald G Jr TrusteeN340EBCessna 340A · S/N 340A0090Built 1976 · Brunn Michael D TrusteeN341DGDJI AGRAS T50 · S/N 1581F6BUB233200101KPSale reported, pending cancellationN341EGDJI AGRAS T50 · S/N 1581F6BUB232E00100SJSale reported, pending cancellationN3501RCessna 206H · S/N 20608162Built 2001 · Stanislaus County Sheriffs DepartmentN35020Piper J5A · S/N 5-528Built 1941 · Spears Dennis R JrN3528Olson MINI-PLANE · S/N CGO-1Azevedo Manuel JN360EZSjostrand Gerald D WHEELER EXPRESS · S/N SJ2146Built 1995 · Turner Jeffrey KN365KVGulfstream Aerospace G-IV · S/N 1373Built 1999 · Kamboj Aviation Group IncN375UBBaumgart James STOL CH 701 · S/N 7-6843Built 2012 · Delano Art LN384PCPilatus PC-12/47E · S/N 1384Built 2012 · Jw Air LLC
Back to Modesto, CA