OpenAirDocs.org
Concord, CA

Registered aircraft · 103

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

N1122YBeech B36TC · S/N EA-333Built 1982 · D&P Beech Aviation LLCN1128KLuscombe 8A · S/N 3855Built 1946 · Mitchell Peter JN143ELCessna 421C · S/N 421C0646Built 1979 · Premiere Aviation IncN1516QCessna 150L · S/N 15072816Built 1970 · Toth John RN15518Piper PA-28-140 · S/N 28-7325086Registration pendingBuilt 1972N1740GBeech 35-B33 · S/N CD-490Built 1962 · Oelrich Matthew AlanN18076Cessna 150L · S/N 15073776Angelos Mark AN211WWSling SLING LSA · S/N 423ABuilt 2024 · Trexair Planes LLCN212EECostruzioni Aeronautiche Tecna P2002 SIERRA · S/N 361Built 2008 · Nicolini JohnN24009Beech C24R · S/N MC-496Built 1977 · Business Aviation Insurance Services IncN241ULLeading Edge Aerial Tech PV40X · S/N 1937511445Contra Costa Mosquito And Vector Control DistrictN242ASCessna 680 · S/N 680-0084Built 2006 · Greenhaven Securities LLCN2436YPiper PA-28-161 · S/N 28-8516056Non-citizen corporation, flight hours not reportedBuilt 1985 · Alpha Flight AcademyN25169Wescott ICARUS II-B · S/N A18Registration revokedBuilt 1976 · Wescott Richard WilliamN261CHDassault FALCON 900EX · S/N 261Built 2011 · Seecon Builders IncN2624GCessna 182B · S/N 51924Built 1959 · Vietnam HelicoptersN26KHPilatus PC-12/45 · S/N 592Concord Jet Service IncN3069LPiper PA-28-181 · S/N 28-7990263Built 1979 · Grech George A TrusteeN339BCessna 680 · S/N 680-0058Built 2005 · Concord Jet Service IncN34ADCessna 421C · S/N 421C-0036Built 1975 · Premiere Aviation IncN360PSPilkenton Robin PITTS SPECIAL S1S · S/N 01Ellis Nigel RN3694NMooney M-20G · S/N 680039Built 1967 · Wheeler Kevin JN37RNRaymond W Nilson RV9A · S/N 90207Built 2014 · Cicero JohnN3PVCessna 172E · S/N 17251739Atkinson Russell MN415TBErcoupe 415-C · S/N 1612Built 1946 · Leuthold MikeN41LWPiper PA-32R-301T · S/N 32R-8329031Seccombe Stanley G IIIN41WTCessna 421C · S/N 421C1257Built 1982 · Premiere Aviation IncN421AWCessna 421C · S/N 421C0807Premiere Aviation IncN423RCTextron T206H · S/N T20609592Built 2019 · Concord Trailer World IncN427GSStofer Gerhard VANS RV-8 · S/N 80199Built 2004 · Stofer GerhardN43159Piper PA-28-151 · S/N 28-7415436Built 1974 · Peters PatN476VHBoeing CH-46E · S/N 156476Built 1969 · Vietnam HelicoptersN482LCLeading Edge Aerial Tech PV40X · S/N 11439Contra Costa Mosquito And Vector Control DistrictN4847WRockwell International 114 · S/N 14177Built 1976 · Iskin Jeffrey TrusteeN507EFErnst Freitag VANS RV-10 · S/N 40513Built 2011 · Freitag ErnstN569LGCessna 208 · S/N 20800569Built 2015 · Pacific Gas And Electric CompanyN600VYVolans-I C10 · S/N 8652-674-210-0042Volans-I IncN601VYVolans-I C10 · S/N 8652-674-210-0041Volans I IncN602VYVolans-I C10 · S/N 8652-674-210-0056Volans I IncN603VYVolans-I C10 · S/N 8652-674-210-0061Volans-I IncN604VYVolans-I C10 · S/N 8652-674-210-0066Volans-I IncN605VYVolans-I C10 · S/N 8652-674-210-0070Volans-I IncN606VYVolans-I C10 · S/N 8652-674-210-0069Volans-I IncN607VYVolans-I C50 · S/N SX02Volans I IncN610VYVolans-I M20 · S/N 8652-674-620-0007Volans-I IncN611VYVolans-I M20 · S/N 8652-674-620-0003Volans-I IncN613VYVolans-I M20 · S/N 8652-674-620-0005Volans I IncN614VYVolans-I C10 · S/N 8652-674-210-0044Volans-I IncN615VYVolans-I C10 · S/N 8652-674-210-0073Volans I IncN6168DPiper PA-22-150 · S/N 22-4815Built 1957 · Madison James E
Back to Concord, CA