OpenAirDocs.org
Pittsfield, MA

Cancelled registrations · 34

Query with SQL
duckdb -csv -c "SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code
  WHERE d.registrant_state = 'MA' AND d.registrant_city = 'PITTSFIELD'
  ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id"

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.

N614APBritish Aerospace BAE 125 SERIES 800A · S/N 258057Cancelled Jan 8, 2022 · Registration expired, pending cancellation · Lyon Aviation IncN22268Taylorcraft BF · S/N 1217Cancelled Sep 16, 2019 · Revoked, pending cancellation · Built 1939 · Whipple Walter LeightonN70NEBritish Aerospace BAE 125 SERIES 800A · S/N NA0407Cancelled Apr 5, 2019 · Berkshire Leasing LLCN76842Schultz Michael PARASCENDER II · S/N 220072Cancelled Feb 23, 2018 · Registration expired, pending cancellation · Built 1996 · Shufelt David JN3831ADestiny D 2000 · S/N 3C0431Cancelled Feb 13, 2018 · Registration expired, pending cancellation · Built 2007 · Betit James AN5045FFairchild Hiller FH-1100 · S/N 191Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Built 1970 · Mazzeo Helicopters IncN4214FCessna 172 · S/N 46114Cancelled Jul 3, 2017 · Registration expired, pending cancellation · Built 1958 · Spurlin EdgarN102RRPetiletky Strojirny Prvni NP L-13 BLANIK · S/N 172530Cancelled Jun 21, 2017 · Registration expired, pending cancellation · Built 1963 · Mohawk Soaring Club IncN49107Cessna 152 · S/N 15283420Cancelled Sep 16, 2013 · Registration expired, pending cancellation · Built 1979 · Zuber Peter JN2NSPiper PA-31-350 · S/N 31-7305077Cancelled May 29, 2012 · Exported to Canada · Built 1973 · Ams Productions LLCN79356Earthstar THUNDERGULL ODYSSEY · S/N E012DMCancelled Jul 22, 2008 · Exported to Mexico · Built 2002 · Sullivan Robert JN8646NCoon Robert V RUTAN VARIEZE · S/N 1930Cancelled Oct 23, 1996 · Coon Robert VN9044JPiper PA-28-180 · S/N 283075Cancelled Mar 29, 1994 · Triennial form not returned · Tamarack Flying Club IncN9363JPiper PA-28-180 · S/N 28-3462Cancelled Feb 9, 1982 · Tamarack Flying ClubN44330Taylorcraft BC · S/N 10130Cancelled May 6, 1981 · Built 1946 · Kaminiski MieczyslawN1095LAerofab LAKE LA-4-200 · S/N 688Cancelled Jul 10, 1980 · Built 1975 · Sandick HerbN8575PPiper PA-24-260 · S/N 24-4032Cancelled Feb 16, 1978 · Irving SiegelN2409WSchweizer SGS 1-26B · S/N 352Cancelled May 21, 1974 · Built 1966 · Berkshire Soaring Society IncN2744ZSchweizer SGU 2-22E · S/N 196Cancelled May 21, 1974 · Berkshire Soaring Society IncN2799ZSchweizer SGS 1-26C · S/N 280Cancelled May 21, 1974 · Berkshire Soaring Society IncN4362UCessna 150D · S/N 15060362Cancelled Oct 3, 1973 · Pittsfield Flight Service IncN93484Engineering & Research 415-C · S/N 807Cancelled Jun 11, 1970 · Defino Donald D & Nicholas DefinoN30306Piper J3F-60 · S/N 4781Cancelled May 21, 1965 · Built 1940 · Mieczylaw KaminskiN7600PPiper PA-18-150 · S/N 18-7796Cancelled Nov 5, 1963 · Exported to Canada · Conway L ON43872Taylorcraft BC12-D · S/N 7531Cancelled Jan 20, 1956 · Fairweather Paul BN46085Taylorcraft L-2M · S/N 5547Cancelled Nov 17, 1955 · Maslak TheodoreN92064Piper J-3C · S/N 16497Cancelled Feb 5, 1954 · Built 1946 · Greylock Airways IncN716BBeech A35 · S/N D1723Cancelled Nov 13, 1950 · Greylock Airways IncN92857Curtiss Wright C-46A · S/N 30506Cancelled Aug 22, 1949 · Strato Freight IncN24424Taylorcraft BC-65 · S/N 1760Cancelled Jul 11, 1942 · Berkshire Flyers IncN859YEverest Alfred Wallace PRIMARY GLIDER · S/N 1Cancelled Jun 17, 1933 · Built 1930 · Everest Alfred WallaceN1541Standard J-1 · S/N N-135Cancelled Sep 13, 1932 · Lowden UrbanN5589Command-Aire 3C-3 · S/N 503Cancelled Nov 14, 1929 · Berkshire Flying Service IncN60056Cessna T-50 · S/N 3618Cancellation date not recorded · Built 1943 · Francis Harry L/Cockrell Alfred O
Back to Pittsfield, MA