OpenAirDocs.org
Fitchburg, MA

Cancelled registrations · 36

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

N3241GMiller John M STEEN SKYBOLT · S/N L-5086-39Cancelled May 29, 2020 · Registration expired, pending cancellation · Built 1991 · Rintala LeoN43298Piper PA-28-140 · S/N 28-7425353Cancelled Sep 18, 2017 · Registration expired, pending cancellation · Built 1974 · Hill Jeffrey AN6975FCessna 150F · S/N 15063575Cancelled May 3, 2013 · Registration expired, pending cancellation · Built 1966 · Hathaway Henry LN50342Cessna 150H · S/N 15069239Cancelled Dec 10, 2012 · Sale reported, canceled · Built 1968N40CPRobinson Helicopter R22 BETA · S/N 0638Cancelled Oct 17, 2007 · Triennial form not returned · Four M Leasing IncN21072Piper PA-32-300 · S/N 32-7840183Cancelled Sep 15, 2004 · Built 1978 · Jan Co Holdings LLCN1516Jodel Baby D9R1 · S/N F-3075Cancelled Jun 19, 2001 · Exported to Canada · Rautio Lauri KN96273Cessna 172P · S/N 17276050Cancelled Jun 2, 2000 · Triennial form not returned · Fitchburg-Colonial Aviation IncN3EVPiper PA-23-150 · S/N 231084Cancelled Apr 8, 1998 · Fitchburg Colonial Aviation IncN6309FCessna 172N · S/N 17273187Cancelled Nov 17, 1992 · Triennial form not returned · Fitchburg Colonial Aviation IncN89705Cessna 152 · S/N 15282832Cancelled Apr 22, 1982 · Exported to United Kingdom · Fitchburg-Colonial AviationN9535BCessna 172RG · S/N 172RG-0861Cancelled Jul 6, 1981 · Exported to United Kingdom · Fitchburg-Colonial Aviation IncN53364Cessna 172P · S/N 17274730Cancelled May 13, 1981 · Exported to Netherlands · Fitchburg Colonial Aviation IncN4954PCessna 152 · S/N 15284857Cancelled Apr 27, 1981 · Exported to United Kingdom · Fitchburg Colonial Aviation IncN4822PCessna 152 · S/N 15284822Cancelled Mar 18, 1981 · Exported to United Kingdom · Built 1980 · Fitchburg Colonial Aviation IncN5094BCessna 152 · S/N 15283741Cancelled Mar 18, 1981 · Exported to United Kingdom · Fitchburg Colonial Aviation IncN1949FCessna 172N · S/N 17273039Cancelled Jul 30, 1980 · Exported to Netherlands · Built 1979 · Fitchburg-Colonial Aviation IncN96446Cessna 182Q · S/N 18266724Cancelled Jun 25, 1980 · Exported to United Kingdom · Fitchburg-Colonial Aviation IncN1283FCessna 172N · S/N 17272985Cancelled Jun 23, 1980 · Exported to United Kingdom · Built 1979 · Fitchburg Colonial Aviation IncN4889BCessna 152 · S/N 15283693Cancelled Apr 30, 1980 · Exported to United Kingdom · Built 1979 · Fitchburg Colonial Aviation IncN7518GCessna 150L · S/N 15074684Cancelled Jul 21, 1978 · Exported to United Kingdom · Fitchburg-Colonial Aviation IncN11370Cessna 150L · S/N 15075360Cancelled Mar 20, 1978 · Exported to United Kingdom · Fitchburg Aviation IncN2014GCessna 182A · S/N 51314Cancelled Jun 18, 1973 · Exported to Canada · Built 1958 · Fitchburg & Leominster Flying Club IncN2194MPiper J-3 · S/N 20983Cancelled Apr 3, 1958 · Ferdinard R MastrangeloN45770Luscombe 8A · S/N 2297Cancelled Mar 27, 1958 · Silver Wings CompanyN73709Cessna T-50 · S/N 3725Cancelled Feb 25, 1954 · Fitchburg Flying ServiceN87430Ercoupe 415-C · S/N 603Cancelled Oct 28, 1953 · Fitchburg Flying ServiceN93795Ercoupe 415-C · S/N 1118Cancelled Dec 13, 1951 · Dufour Robert JN51648Fairchild M-62A · S/N T43-5613Cancelled Jun 2, 1949 · Built 1943 · Wachusett Aviation IncN98074Piper J3C-65 · S/N 18223Cancelled May 12, 1949 · Built 1946 · Wachusett Aviation IncN96679Taylorcraft BC12-D · S/N 8979Cancelled May 11, 1949 · Holtz SigmundN19815Taylorcraft A · S/N 322Cancelled Aug 17, 1948 · Built 1937 · Kolazyk Stephe J Et AlN87461Republic RC-3 · S/N 11Cancelled Feb 6, 1948 · Paul K Dudley DBA Dudley Aviation Sales CoN866YKoivu Ernest/Toomey Bernard M PARASOL · S/N KT-1Cancelled Mar 15, 1936 · Koivu & ToomeyN935MMoth 60-GM · S/N 134Cancelled Nov 1, 1933 · Built 1930 · Johnson OscarN233KMoth 60-GM · S/N 45Cancelled Sep 10, 1930 · Crocker III C Thomas
Back to Fitchburg, MA