OpenAirDocs.org
Marstons Mills, MA

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 = 'MA' AND g.registrant_city = 'MARSTONS MILLS'
  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.

N174CSSchanche Carsten H RV-7A · S/N 70876Built 2012 · Schanche Carsten HN262MCessna 172N · S/N 17268356Built 1976 · Gordon BruceN29364Waco UPF-7 · S/N 5391Built 1940 · Mills Air Service IncN3116ACessna 170B · S/N 25760Built 1953 · Schanche Carsten HN3447MPiper PA-12 · S/N 12-2065Registration pendingBuilt 1947N3782MPiper PA-12 · S/N 12-2712Mills Air Service IncN3896DCessna 182A · S/N 34596Built 1957 · Mills Air Service IncN4005ZPiper PA-18-150 · S/N 18-7956Built 1963 · Mills Air Service IncN4103MPiper PA-12 · S/N 12-3000Built 1947 · Mills Air Service IncN4921DCessna 182A · S/N 51021Built 1958 · Mills Air Service IncN50606Cessna 150J · S/N 15069429Built 1968 · Siderwicz Christopher JN60010Cessna T-50 · S/N 3968Built 1943 · Siderwicz Christopher JN61981Douglas DC3A · S/N 2216Built 1940 · Siderwicz Christopher JN6377MWaco YMF · S/N F50016Built 1988 · Mills Air Service IncN738HJCessna 172N · S/N 17269987Built 1977 · Mcnamara Patrick JN755MAPiper J-3 · S/N 15785Mills Air Service IncN756TRCessna R182 · S/N R18201153Built 1979 · Sawyer Charles WN82DMAvions Mudry ET Cie CAP 10B · S/N 88Built 1978 · Perry Timothy WN86DGGlaser-Dirks Flugzeugbau DG-100G · S/N E-47 G-26Built 1980 · Charlton Arthur R
Back to Marstons Mills, MA