San Rafael, CA

Registered aircraft · 53

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 = 'SAN RAFAEL'
  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.

N1223BCessna 425 · S/N 425-0201Conquest Technology Associates LLCN122PRDassault FALCON 2000 · S/N 57Built 1998 · Handshake Management LLCN124ATSmith Noah E QUICKIE Q-2 · S/N 2178Smith David DN129DGCessna 525B · S/N 525B0269Built 2008 · Dutra GroupN133DVCanadair CT-33 · S/N 133610Built 1959 · Ace Maker Aviation LLCN133HHCanadair CT-33 · S/N 133452Built 1954 · Ace Maker Aviation LLCN146AGCostruzioni Aeronautiche Tecna P2002 SIERRA · S/N 416Built 2010 · RthalheimerllcN153KCSeamax Aircraft Ltda SEAMAX M-22 · S/N 153Built 2019 · Carlomagno KentN18861Beech C23 · S/N M-1953Built 1977 · Phillips Gary ON199MTRans S-19LS · S/N 05080004LSBuilt 2010 · Zimmerman IanN20LTMaule M-7-260 · S/N 26015CBuilt 2003 · Seagull Services LLCN21JDNorth American SNJ-5 · S/N 90996Built 1959 · Ace Maker Aviation LLCN248LFCirrus Design SR22T · S/N 2128Built 2020 · Lima Foxtrot IncN260MTSiai-Marchetti F.260 · S/N 3-80Built 1972 · Carlomagno Kent GeneN26KBAir Creation CLIPPER 912 · S/N T03088Built 2003 · Krishnan Sunil GN2AKCirrus Design SF50 · S/N 0581Built 2024 · Tangier Services LLCN303JDPilatus PC-12/45 · S/N 303Lisgar II LLCN305AFCessna/Inland Valley Avia 305 C · S/N 305AFBuilt 1999 · Plaskon Kate TrusteeN317DBucker BU-133 · S/N 45Built 1940 · Carter Colin PN32503Piper J3C-65 · S/N 5398Built 1940 · Robison James BN3649RPiper PA-28-180 · S/N 28-5746Built 1969 · Cummings Jason MN373Piper PA-30 · S/N 30-1374Built 1966 · Clayland WalterN3749JCessna 150G · S/N 15065049First renewal noticeBuilt 1966 · Love Duane AnthonyN3754NBeech 35 · S/N D-973Built 1947 · Colyer Gregory WN3796MPiper PA-28R-201T · S/N 28R-7803194Built 1978 · Roth Jacques AN3HVMiller F P/Weitman D GLASAIR III SH-3R · S/N 3103Joseph MatthewN400VBPiper PA-42-1000 · S/N 42-5527002Built 1985 · Kelleher CorporationN4042ABeech V35B · S/N D-9102Built 1970 · Rogden Aviation IncN415XTPilatus PC-12/47E · S/N 2144Built 2021 · X-Ray Tango IncN488MAAnderson Mike PHOENIX X1A · S/N RB-01-4-88Built 1988 · King John RN49ERCirrus Design SR20 · S/N 10013Built 2024 · 49air LLCN5017DCessna 182A · S/N 51117Graham Thomas VN5145NBoeing B75N1 · S/N 75-7474Built 1943 · Ace Maker Aviation LLCN5468PPiper PA-24-250 · S/N 24-525Built 1958 · Thompson Kevin AN57471Taylorcraft TG-6 · S/N 6090Built 1942 · Ace Maker Aviation LLCN5753FPiper PA-28-140 · S/N 28-25056Built 1968 · Rauch JackN5804ZPiper PA-22-108 · S/N 22-9657Built 1963 · Colyer Gregory WN6140FCessna A150L · S/N A1500425Fluno John IN6304RPiper PA-28-140 · S/N 28-21469Built 1966 · Bastida William MN6731UMooney M20C · S/N 2463Built 1963 · Gondouin Francis PN741FLPiper PA-28-140 · S/N 28-7225578Built 1972 · Ferrario Michael RN7439ACessna 172 · S/N 29539Built 1956 · Alsterlind Stephen WN759BUCessna 182Q · S/N 18265870Built 1977 · Marin County Sheriffs OfficeN76747Beech A36TC · S/N EA-41Built 1979 · Walter Timothy AndrewN7766NPiper PA-28-180 · S/N 28-5212Built 1969 · Kenealy Ian PatrickN777WTPeter Eisele AL18 · S/N AL-337Built 2020 · Eisele PeterN78024Globe GC-1B · S/N 2024Robison James BN7826TLouie Kenneth G STOL CH701 · S/N 7-6513Built 2010 · Louie Kenneth GN883TFCirrus Design SR22 · S/N 4609Built 2018 · Whamola IncN892XRDJI MAVIC 2 ZOOM · S/N 0M6CH69 R0A0WPSVan Der Wal Ross
Back to San Rafael, CA