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.

N3867MPiper PA-12 · S/N 12-2776Built 1947 · Boese Bruce AN4077FCessna 172 · S/N 36977Built 1958 · Solomon Joseph E JrN407SHBell Helicopter Textron Canada 407 · S/N 54501Built 2014 · Stanislaus CountyN408ARAmerican Legend AL3 · S/N AL-1144Built 2009 · Peters Ronald L TrusteeN419DHeddergott Klaus RV-6 · S/N 20419Built 1995 · Turner Spencer AN4328CChampion AERONCA 7EC · S/N 7EC-337Built 1955 · Welch Thomas RN444AZAgin Jeffrey T RV-4 · S/N 001Built 2000 · Glynn PatrickN4469KRyan NAVION · S/N NAV-4-1469Tidwell Gregery DN4596HPiper PA-17 · S/N 17-14Built 1948 · Azevedo Manuel JN46064Aeronca 0-58B · S/N 058B12203Built 1943 · Mount Glenn WN4696KCessna 182P · S/N 18263697Built 1975 · 96 Kilo LLCN4849JCessna A188B · S/N 18803773TBuilt 1981 · East Side Mosquito Abatement DistrictN4991RCessna A188B · S/N 18802479TBuilt 1975 · East Side Mosquito Abatement DistrictN4995Champion 7CCM · S/N 10-71Built 1971 · Stein David EN49XMCessna 177B · S/N 17701736Built 1972 · Mclean Michael DN5167ZPiper PA-22-108 · S/N 22-8825Built 1961 · Ramsdell EdmunN516KBDrewyor Kenneth KITFOX SERIES 7 · S/N S70202-007Built 2009 · Vanderhelm ArendN5298PPiper PA-24-250 · S/N 24-339Croasdale Terry LeeN549JTRumney Thomas G GLASTAR · S/N 5339Pas Aviation IncN552ZSBeech B36TC · S/N EA-343Built 1983 · Tuolumne Ridge LLCN5559MAero Commander 100 · S/N 096Built 1967 · Bertelson Chester JN55801Piper PA-28-140 · S/N 28-7325488Built 1973 · Jacobs Michael AN55CJCessna 525 · S/N 525-0298Built 1998 · N55cj LLCN56283Piper PA-28R-200 · S/N 28R-7335399Built 1973 · Stephens Donald KN5695CMooney M20J · S/N 24-1410Built 1983 · Aerial Avionics IncN579WAPilatus PC-12/47E · S/N 1579Built 2015 · Pacific Crest Air LLCN583TLCessna 560 · S/N 560-0583Built 2001 · 518mv Air LLCN5950XBrantly B-2 · S/N 89Welch Thomas RN6061GCessna 150K · S/N 15071561Built 1969 · Johnson Victor RN6100YCessna T210N · S/N 21064250Built 1981 · Ramsay Allan TrusteeN615MDKollen Robert S LIGHTNING · S/N 165Built 2015 · Kollen Robert SN62094Piper J3C-65 · S/N 8334Bautista Lance CN6278VBeech V35A · S/N D-8602Built 1968 · Montana Excursions LLCN6282VBeech D55 · S/N TE-463Built 1967 · Bautista Lance CN63480Boeing A75 · S/N 75-5023Azevedo Manuel JN647YDPiper PA-28-161 · S/N 287816499Faukner Andrew LN6499ECessna 172 · S/N 46599Built 1959 · Azevedo Manuel JN682TMHonda HA-420 · S/N 42000023Built 2016 · Ran Health Services IncN684VBeech 35-33 · S/N CD-108Built 1960 · Heyman Richard BN68970Piper J3C-65 · S/N 13198Cummins Michael VN696ALCessna R172K · S/N R1722047Pas Aviation IncN70063Cessna A188B · S/N 18801827TBuilt 1974 · Welch Thomas R DBAN701LDDelano ART Lee CH701 · S/N 6223Built 2008 · Delano Art LN7033ZPiper J3C-65 · S/N 17004Built 1946 · Crawford Michael SN726DDART Lee Delano SONEX · S/N 1674Delano Art LeeN727TMGulfstream American AA-5B · S/N AA5B1178Built 1979 · Modesto Vapor TrailsN736FVCessna R172K · S/N R1722500Built 1977 · Del Rio Advisors LLCN737TJCessna 172N · S/N 17269660Built 1977 · Stanislaus County Sheriffs DepartmentN73907Bell 47G-2A-1 · S/N 2857Built 1962 · Denlinger DarinN767WSCirrus Design SF50 · S/N 0261Built 2021 · Dbstorerair Lp
Back to Modesto, CA