OpenAirDocs.org
Sonora, CA

Registered aircraft · 38

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

N100WACessna 172E · S/N 17251499Built 1964 · Alcorn Stanley RN135JLBeech G35 · S/N D-4419Built 1955 · Burhoe Aaron DN17RNPiper PA-28-181 · S/N 28-7790162Built 1976 · Ogopogo FoundationN1818NCessna 120 · S/N 12062Built 1946 · Firth Thomas H IVN2212GBoeing N2S-3 · S/N 75-7525Built 1942 · Segerstrom William CN2869QCessna 172L · S/N 17259869Built 1971 · Durnall Daniel JN2923LMooney M20F · S/N 670317Built 1967 · Hess Daniel GN2966NCessna 120 · S/N 13224Built 1947 · Segerstrom Erik MN36425Taylorcraft BC-65 · S/N 3241Built 1941 · Hayes James RN3747LCessna 172G · S/N 17253916Built 1965 · N3747l LLCN3CMCessna T337G · S/N P337-0025Built 1972 · Oxbow Investments LLCN3XSPrill Charles CP-6 · S/N C001Built 1996 · Brewer Joshua RyanN40763Piper J3C-65 · S/N 7476Built 1941 · Scheftner Tonya RN42484Cessna 182L · S/N 18259035Hiemstra Ralph WN4315BCessna 170B · S/N 26659Built 1955 · Mckamey Dave SN43526Piper PA-28R-200 · S/N 28R-7435277Built 1974 · Wittman Jeffrey AN477BPPeltola Brad H VANS RV-8 · S/N 80477Built 2005 · Wooden Rick DN4850LPiper PA-28-180 · S/N 28-4199Built 1967 · Upper Airway Aviation LLCN5280NBoeing E75 · S/N 755790Built 1949 · Bautista Mark SN5363QCessna T182T · S/N T18208203Built 2003 · Cary Gosney Crna IncN5895DPiper PA-18 · S/N 18-5404Built 1956 · Ogg KevinN61159Cessna 150J · S/N 15070847Built 1969 · Stenger D James TrusteeN6836XCessna 172A · S/N 47736Built 1960 · Nelson John DN69ZPhillips STEEN SKYBOLT · S/N 200-2Built 1977 · Mckamey Dave SN7160LGrumman American Avn. AA-5 · S/N AA5-0460Huntley Michael EN72398Cessna 140 · S/N 9584Built 1946 · Brewer Joshua RN7279BCessna 182S · S/N 18280542Bautista Mark SN735SWCessna 182T · S/N 18281240Built 2003 · 5 Sierra Whiskey LLCN77281Cessna 120 · S/N 11723Hiemstra Thomas RN80458Cessna 172M · S/N 17266597Built 1976 · Kolpack Glenn HN80SBLippert Barry M MA-5 CHARGER · S/N 0062Built 1980 · Brewer Renner L JrN8151ACessna 170B · S/N 25003Built 1952 · Hayes James RN8372UPiper PA-34-220T · S/N 34-8133070Built 1981 · Ogopogo FoundationN84029Aeronca 7AC · S/N 7AC-2716Built 1946 · Chase Michael DN8514YPiper PA-30 · S/N 30-1675Built 1967 · Mcnally RodneyN9122ZBell 212 · S/N 30716Built 1975 · Intermountain Helicopter IncN97986Stinson 108-1 · S/N 108-986Built 1946 · Steinbrink RobertN9934ECessna 182P · S/N 18263994Built 1975 · Stenger D James Trustee
Back to Sonora, CA