OpenAirDocs.org
Mill Valley, CA

Registered aircraft · 25

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 = 'MILL VALLEY'
  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.

N1190XAmerican General Acft AG5B · S/N 10010Built 1991 · Kashtan David L TrusteeN123JLDehavilland DHC-2 MK. I(L20A) · S/N 1140Built 1957 · Seaplane Adventures LLCN2170WCessna T182T · S/N T18208441Built 2005 · Sacks MartinN2370WCessna 182S · S/N 18280405Built 1998 · Sall LLCN2461FCessna T206H · S/N T20608119Built 1999 · Dietz ThomasN265JPCirrus Design SR22 · S/N 0888Built 2004 · N265jp LLCN2976ACessna 180 · S/N 30176Built 1953 · Gore Thomas HN299RRRichard D Rider CCK-1865 · S/N CCK-1865-0052Built 2014 · Rider Richard TrusteeN32MBBeech 36 · S/N E-160Built 1969 · Marin Airmen IncN425DGGugger David RV-7A · S/N 71782Built 2007 · Eshelman RodneyN460AKGulfstream Aerospace G-IV · S/N 1413Built 2000 · Tangier Services LLCN49388North American T-6G · S/N 49-3066Built 1950 · Seaplane Adventures LLCN518TDCirrus Design SR22T · S/N 2342Built 2021 · Shasta Way LLCN5220GDehavilland BEAVER DHC-2 MK.1 · S/N 833Built 1955 · San Francisco Seaplane Tours IncN527RSRaytheon A36 · S/N E3222Built 1999 · Lookout Mountain LLCN5423KCessna 172P · S/N 17274105Built 1980 · Randel James B IIIN5709HPiper PA-16 · S/N 16-320Smith Zac AN6216VBeech V35 · S/N D-8574Built 1967 · Westphal Robert S TrusteeN7048NBeech V35A · S/N D-8636Built 1967 · Bonanza Enterprises LLCN7264DCessna 206H · S/N 20608062Built 1999 · Gravity & Grace LLCN737ADAmerican Champion 8KCAB · S/N 941-2003Built 2004 · De Zafra AaronN7702MMooney M20C · S/N 670120Built 1967 · Cullen William EdwardN7788HBeech A36 · S/N E-2436Built 1988 · Teodoro Financial Group IncN8584SCessna 182H · S/N 18256684Built 1965 · Rider Richard TrusteeN900GMCessna T310R · S/N 310R1249Built 1977 · Kashtan David L
Back to Mill Valley, CA