OpenAirDocs.org
Marysville, CA

Registered aircraft · 19

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

N1219WBell 206B · S/N 1843Built 1975 · Moes Crop Dusting Service IncN15102Air Tractor AT-502 · S/N 502-0146Built 1991 · Moes Crop Dusting Service IncN257XPowrachute PEGASUS · S/N A511PEGBuilt 2015 · Vanover Tony LN3054WAir Tractor AT-802A · S/N 802A-0525Built 2013 · Moes Crop Dusting Service IncN321PPCessna 182Q · S/N 18265834Built 1977 · Mathews Aviation LLCN33596Piper J3C-65 · S/N 14073Built 1945 · Schultz Vaughn PN3564CCessna 170B · S/N 26608Built 1954 · Moe William AN6260PPiper PA-24-250 · S/N 24-1368Built 1959 · Larson Jeffery A TrusteeN6663HPiper J3C-65 · S/N 19868Messick Jon AN6681KGrumman Acft ENG Cor-Schweizer G-164C · S/N 20CMoes Crop Dusting Service IncN71300Cessna 182M · S/N 18259568Built 1969 · Finch Merry BN7211LPiper PA-25-235 · S/N 25-7405581Moes Crop Dusting Service IncN7378NCessna 182P · S/N 18263161Built 1974 · Whitmarsh Stephen CN802BHAir Tractor AT-802 · S/N 802-0797Built 2019 · Moes Crop Dusting Service IncN81566Aeronca 7AC · S/N 7AC-185Built 1945 · Whitmarsh Stephen CN86536Cessna 182P · S/N 18261942Built 1973 · Moes Crop Dusting Service IncN878KAVestal Edward S CHRISTAVIA MK 1 · S/N 1927Krzyminski Jakub MN90TDBeech F90 · S/N LA-183Built 1982 · Mike Russell Construction IncN9948VCessna R172K · S/N R1722356Built 1977 · Schultz Vaughn P
Back to Marysville, CA