OpenAirDocs.org
Santa Rosa, CA

Registered aircraft · 256

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 ROSA'
  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.

N108SCBell Helicopter Textron Canada 407 · S/N 54728County Of SonomaN112MTEurocopter Deutschland EC 135 P2+ · S/N 1129Built 2013 · Reach Air Medical Services LLCN114GRAirbus Helicopters EC 130 T2 · S/N 9818Built 2025 · Reach Air Medical Services LLCN115CJCessna 525A · S/N 525A0115Conquest Services IncN12161Cessna 172M · S/N 17261851Built 1973 · Cessna 12161 LLCN12237Garland-Lincoln NIEUPORT · S/N 3Built 1936 · Mone Brent CN1226BJohnson Ernest P RV-6A · S/N 60508Built 2009 · Cameron BrianN130KJEurocopter EC 130 B4 · S/N 3873Built 2004 · Jackson Family Wines IncN1331DCessna 170A · S/N 19907Built 1951 · Sawyer Eugene MN133PCCessna 340A · S/N 340A0093Built 1976 · Gilco DistributorsN1378DCessna 170A · S/N 19954Built 1951 · Palmerlee John BN1414NPiper J3C-65 · S/N 22936Built 1947 · Mulhern Ronald RN1429Woodwind A · S/N 1Built 1969 · Rapalyea Eugene LN144XNelson James G F-1 ROCKET · S/N JGN001Built 2001 · Nelson James GN146TMPiper J3C-65 · S/N 22915Built 1946 · Long JamesN14QKQuicksilver Aeronautics L-S2S · S/N 10003Built 2014 · Shipway RaymondN1563SBeech 35-B33 · S/N CD-524Built 1962 · Miller Edward LN157ATCirrus Design SR22 · S/N 4157Built 2014 · Jasper DaneN173EXMartino Thomas G VELCITY 173 ELITE RG · S/N DMO-282Built 2004 · Hauck Brian AN1760CBRM Aero Sro BRISTELL S-LSA · S/N 206/2016Built 2016 · Blakeslee JeffreyN1765JPiper PA-28-140 · S/N 28-24185Built 1968 · May Olivia GN17LFPiper PA-28-140 · S/N 28-7325183Built 1972 · Brown-Elliott CandiceN183SBBarnes Steve BARNES STORMER · S/N 001First renewal noticeBuilt 2005 · Barnes Steven DN188PMPiper PA46-500TP · S/N 4697501Built 2012 · Cairn Vista Holdings LLCN1917NCessna 120 · S/N 12161Lozano BrianN1949BDehavilland DHC-2 MK. I(L20A) · S/N 71Built 1949 · Sail Rock Aviation LLCN2023YCessna 172C · S/N 17249523Built 1962 · Cassero Ronald VN203ETEtchell A/Etchell P/Etchell R ETCHELL CJ 6A · S/N 983151203Built 1969 · Etchell Russell AN2082ZCessna 150C · S/N 15059882Built 1963 · Ramirez Frank TorresN2086TPiper PA-28R-200 · S/N 28R-7135030Built 1970 · Ellis Amy EN2149CCessna 195B · S/N 16134Built 1954 · Young Marlon VN222CYBeech B200 · S/N BB-1370Built 1990 · Blue Star Gas Fleet Services CoN23248Cessna 150H · S/N 15068824Built 1968 · Kainu William MN234WDDrake William L RV-6A · S/N 25260Built 2006 · Bishop Gordon BN235BLBalony Kubicek Spol Sro BB40Z · S/N 938Built 2012 · Sonoma Ballooning Santa Rosa LLCN2413MCessna T182T · S/N T182087582021 Liberty Air LLCN24HBHoey Robert G BD-4 · S/N 578Built 1979 · Pacific Coast Air MuseumN252CFMooney M20K · S/N 25-1129Bowman Douglas G TrusteeN254EMAnderson Roger CORBYS CJ1 STARLET · S/N 224190CBuilt 1990 · Wilcox Ross LN257CDCirrus Design SR20 · S/N 1184Built 2002 · Pahlavan Benham AN2633SCessna 337C · S/N 337-0933First renewal noticeBuilt 1968 · Air Apparent LLCN26788Gulfstream American AA-5A · S/N AA5A0722Built 1978 · Redwood Aircraft LLCN2728LCessna 172H · S/N 17255928Built 1967 · Potter Mark HN274RDSchleicher ASW-27 · S/N 27019Built 1996 · Pillard Russell L JrN275JEMiddleton Keith LEGEND XL4 · S/N 3011Built 2005 · Ehm Joseph MN276CXGayda Russell D THATCHER CX4 · S/N 276Built 2014 · Gayda Russell DN27HCCanning SKYBOLT · S/N 1Cranston Courtland LN2843CCessna 170B · S/N 26386First renewal noticePacific Coast Air MuseumN284MYMarlon V Young VANS ACFT INC RV8 · S/N 83873Built 2026 · Young Marlon VN2866TPiper PA-28-140 · S/N 28-7225258Pacific Coast Air Museum
Back to Santa Rosa, CA