OpenAirDocs.org
Martinez, CA

Registered aircraft · 26

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

N1258GCessna 310Q · S/N 310Q1109Built 1974 · Conroy Bruce MN1346ECessna 172N · S/N 17270964Built 1978 · Monillas Peter CN23HLBeech A36 · S/N E-1509Built 1979 · Wood Douglas KN283DSDiamond Aircraft Ind DA 40 · S/N 40.956Built 2008 · 3ds Holdings LLCN29MVAerovodochody L-29 DELFIN · S/N 591312Lawrence Robert SN3657YCessna 210C · S/N 21058157Built 1963 · Sims Daniel GN369FSGarris David B VANS ACFT RV9A · S/N 90810Built 2005 · One Tango Mike LLCN407CCBell 407 · S/N 53090Built 1997 · County Of Contra CostaN408CCBell Helicopter Textron Canada 407 · S/N 54542Built 2014 · County Of Contra CostaN40JHBeech A36 · S/N E-772Built 1975 · Johnson Sean MN44145Nance Mark A HUMMEL BIRD · S/N 82055-1Sale reportedBuilt 2004N4632BCessna 180 · S/N 31530Built 1955 · Rowbotham JamesN5205RCessna 172M · S/N 17263422Built 1974 · Valley Pilots Flying Club IncN55RHCessna P206D · S/N P206-0584Built 1969 · Mccarthy Michael EN5616ECessna 172N · S/N 17271902Built 1978 · Dhl Skyhawk IncN561DECessna 172M · S/N 17265572Built 1975 · Flynn John MN5998BCessna 182A · S/N 33998Built 1956 · Conroy Bruce MN612SRHonda HA-420 · S/N 42000173Built 2019 · Bay Area/Diablo Petroleum CoN62BRRudolph Robert E WITTMAN W-10 · S/N 03-1017Built 2011 · Rudolph Robert EN7255ECessna 182B · S/N 52255Built 1959 · Valley Pilots Flying Club IncN7351JPiper PA-28-140 · S/N 28-24702Built 1968 · Rudolph Robert EN7604NBeech 36 · S/N E-72Built 1968 · Friedman David BN80PDPiper PA-28-180 · S/N 28-4044Built 1967 · Gatpandan Grace Michele VN8847DRichard D Pullman RV-8A · S/N 83629Built 2019 · Pullman Richard DN91559North American NAVION · S/N NAV-4-336Fuenzalida Roberto EN9333UCessna 150M · S/N 15078282Built 1976 · Roe Russell M
Back to Martinez, CA