OpenAirDocs.org
Salinas, CA

Registered aircraft · 120

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

N107KPPeterman Keith A DR-107 · S/N 94-0167Built 1998 · Peterman Keith AN112LCMaule MX-7-180C · S/N 28014CBuilt 2001 · Jacobsen Jeffrey MN114PSAviat S-2C · S/N 6006Built 1998 · Pitts S2b LLCN1302BLuscombe 8E · S/N 5929Built 1948 · Sns Flyers LLCN1310XBell 47G-5 · S/N 7814Built 1966 · Wilbur-Ellis CoN1375NRatzlaff SPARROW · S/N ER-100Built 1956 · Jefferson Jacob KN1451DNorth American/Aero Classics P-51D · S/N 44-74446ABuilt 1944 · Teeters DavidN1557DBeech B36TC · S/N EA-494B36tc LLCN156DSMaule M-7-235B · S/N 23064CBuilt 2000 · Fanoe Nicholas JN158AECessna 172D · S/N 17249943Built 1962 · Robinson Bruce AN15TFBombardier BD-100-1A10 · S/N 20942Built 2023 · Taylor Fresh Foods IncN15WJAmerican Champion 8KCAB · S/N 824-99Built 1999 · Fleming Laurence ErikN167NBeech 95-C55 · S/N TE-137Gohman Charles ScottN180EEXag P150 · S/N 186324P18223443X1M77Wilbur-Ellis Company LLCN210ATCessna 210J · S/N 21059186Built 1969 · Teeters David AN2248WBell 47G-5 · S/N 7961Built 1969 · Wilbur-Ellis CoN2249WBell 47G-5 · S/N 7963Built 1969 · Wilbur-Ellis CoN22694Funk C · S/N 22Built 1939 · Bob Hoover Academy IncN2311NCessna 140 · S/N 12581Built 1947 · Teeters Chester Arthur JrN237BMHylio AG 230 · S/N 17906100230Monterey County Mosquito Abatement DistrictN237FMHylio AG 230 · S/N 17906100229Monterey County Mosquito Abatement DistrictN238TDTextron 525C · S/N 525C0238Built 2016 · Pacific International Vegetable Marketing IncN245LDXag P100 PRO · S/N 8219329VW223Wilbur-Ellis Company LLCN24904Piper J3C-65 · S/N 3527Built 1939 · Bob Hoover AcademyN254DBCirrus Design SR22 · S/N 0157Built 2002 · Burns Darryl EN2591VCessna 177RG · S/N 177RG0627Built 1974 · Livewire Holdings LLCN260SPOliver Steven R PITTS S-2S · S/N 1114CBuilt 1981 · Pitts S2b LLCN260STPiper PA-34-220T · S/N 34-8133047Built 1981 · Pitts S2b LLCN264WEXag P150 · S/N 186324P182235125H8D4Wilbur-Ellis Company LLCN2712DCessna 170B · S/N 25254Built 1952 · Blackwood R John TrusteeN273TALearjet 45 · S/N 525Built 2015 · Tanimura & Antle Fresh Foods IncN278EEXag P150 · S/N 186324P1822350841JV4Wilbur-Ellis Company LLCN2836HSchweizer SGS 1-26E · S/N 676Built 1978 · Pauda Jose MarioN28641Grumman American Avn. AA-5B · S/N AA5B0719Built 1978 · Cpr Pacific LLCN293NWXag P100 PRO · S/N 82193528PM12Wilbur-Ellis Co LLCN3038WHylio AG-272 · S/N 17906070289Wilbur-Ellis Company LLCN3058RRaytheon 58 · S/N TH-1870Built 1998 · On Top Aviation LLCN3285TBell 47G-5 · S/N 7964Built 1969 · Wilbur-Ellis CoN3298PPiper PA-23-160 · S/N 23-1248Built 1957 · Cross Albert B IIIN3325WPiper PA-32-260 · S/N 32-160Built 1965 · Guzman Ronald LeonardN3393TCessna 177 · S/N 17700693Built 1967 · Wilcox Russell JN339EEXag P150 · S/N 186324P18223508E459PWilbur-Ellis Company LLCN34DTBeech A45 · S/N G-114Built 1953 · Sutton William EN3528TBell 206B · S/N 3516Built 1981 · R&B Helicopters IncN363ALCessna 525B · S/N 525B-0409Built 2013 · Nunes Company IncN366MDMooney M20C · S/N 20-0015Built 1974 · N366md LLCN3705JBeech 58TC · S/N TK-132Built 1980 · Azuma CompanyN3XEPiper PA-30 · S/N 30-92Built 1963 · Serv Aero Engineering IncN400GPIsrael Aircraft Industries 1124 · S/N 423Icmc Idaho LLCN40635Maule M-4-220C · S/N 2153CBuilt 1972 · Yuan Andrew W
Back to Salinas, CA