OpenAirDocs.org
Acampo, CA

Registered aircraft · 18

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

N147DSLee THORPE T-18 · S/N 439Built 1973 · Davis BradyN19897Cessna 172M · S/N 17260844Built 1972 · Edwards Richard VN205EHBell 206L-3 · S/N 51060Built 1983 · Sacramento Executive Helicopters IncN206EHBell 206L-3 · S/N 51571Built 1992 · Sacramento Executive Helicopters IncN3391XMooney M20C · S/N 3386Built 1966 · Dunham Seth AaronN375CBCostruzioni Aeronautiche Tecna ASTORE · S/N 079Built 2023 · 5g Ag Management IncN407CMBell 407 · S/N 53722Built 2006 · Sacramento Executive Helicopters IncN407GPBell Helicopter Textron Canada 407 · S/N 54088Built 2011 · Sacramento Executive Helicopters IncN407JHBell Helicopter Textron Canada 407 · S/N 54317Built 2011 · Sacramento Executive Helicopters IncN407JTBell Helicopter Textron Canada 407 · S/N 53828Built 2008 · Sacramento Executive Helicopters IncN407RWBell Helicopter Textron Canada 407 · S/N 54355Built 2012 · Sacremento Executive Helicopters IncN523PCBell Helicopter Textron Canada 407 · S/N 53875Built 2008 · Sacramento Executive Helicopters IncN626DPCirrus Design SR22T · S/N 10376Built 2024 · Cockpitto LLCN68RACessna R172E · S/N R172-0119Edwards Richard VN704BMCessna 150M · S/N 15078482Built 1976 · Edwards Richard VN7282SCessna 150H · S/N 15067982Built 1967 · Davis Patrick IN8159WPiper PA-28-180 · S/N 28-2275Built 1965 · Downer Jesse SN8945XCessna 182D · S/N 18253345Built 1961 · Harty Arthur
Back to Acampo, CA