OpenAirDocs.org
Lowell, MA

Cancelled registrations · 32

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

N6001TPdps Pzl-Bielsko SZD-51-1 JUNIOR · S/N B2189Cancelled Jun 29, 2023 · Exported to Canada · Built 1998 · Kram Paul RN607CSSchwartz Charles R SPEZIO SPORT · S/N CRS-DAS1-8788Cancelled Jan 25, 2018 · Registration expired, pending cancellation · Schwartz Charles RN2452VCessna 140 · S/N 14705Cancelled Aug 7, 2013 · Registration expired, pending cancellation · Built 1948 · Heffernan David WN72CSSchwartz Charles R PITTS S1S · S/N CRS-S1S-8790Cancelled Jul 3, 2013 · Registration expired, pending cancellation · Schwartz Charles RN92TSchwartz Charles R SMITH MINIPLANE DSA1 · S/N DSA-1-73TCancelled Apr 26, 2013 · Registration expired, pending cancellation · Schwartz Charles RN2799WRaven S55A · S/N S55A-1075Cancelled Aug 8, 2012 · Registration pending, canceled · Built 1985N5720RCessna 172F · S/N 17253384Cancelled Jun 7, 2012 · Registration pending, canceled · Built 1965N89465Corey Robert BC-1 · S/N 1Cancelled Oct 11, 1996 · Triennial form not returned · Corey Robert ON5857XCamacho Henry J SEAHAWK · S/N 111Cancelled Sep 8, 1993 · Triennial form not returned · Camacho Henry JN606EMoth 60G · S/N 1064Cancelled Oct 1, 1978 · Moth Aircraft CorpN13325Cessna 172M · S/N 17262670Cancelled Jul 13, 1977 · Built 1973 · Mcleod Roger DN63754Cons Vultee/Pittman BT13 · S/N 8844Cancelled Jan 4, 1971 · Turcotte Herman ON44331Taylorcraft BC12-D1 · S/N 10131Cancelled Jul 16, 1970 · Exported to Canada · Doucette Maurice DN4392HPiper PA-15 · S/N 15-176Cancelled Jun 29, 1970 · Built 1948 · Grimolizzi John JN9378HFairchild PT-19A · S/N T42-1559Cancelled Oct 19, 1955 · Moody J WiktotowiceN9188New Standard D-25 · S/N 127Cancelled Apr 12, 1932 · Built 1929 · Morrissette Zenon JrN234KMoth 60-GM · S/N 46Cancelled Aug 29, 1930 · Jones H SN3093Moth 60-GM · S/N 27Cancelled May 30, 1930 · Moth Aircraft CorporationN9345Moth 60-GM · S/N 28Cancelled May 21, 1930 · Moth Aircraft CorpN9346Moth 60-GM · S/N 29Cancelled May 21, 1930 · Moth Aircraft CorpN9347Moth 60-GM · S/N 30Cancelled May 21, 1930 · Moth Aircraft CorpN9348Moth 60-GM · S/N 31Cancelled May 21, 1930 · Moth Aircraft CorpN9349Moth 60-GM · S/N 32Cancelled May 21, 1930 · Moth Aircraft CorpN3092Moth 60-GM · S/N 26Cancelled May 14, 1930 · Moth Aircraft CorporationN913MMoth 60-GM · S/N 114Cancelled Mar 20, 1930 · Built 1929 · Moth Aircraft CorpN589EMoth GYPSY · S/N XACancelled Oct 4, 1929 · Moth Aircraft CorporationN830HMoth 60G · S/N 1-SCancelled Jul 8, 1929 · Moth Aircraft CorpN3091Moth 60-GM · S/N 25Cancelled Jul 5, 1929 · Moth Aircraft CorpN832EMoth 60G · S/N 1GCancelled Jul 1, 1929 · Moth Aircraft CorpN9704Moth 60-GM · S/N 814Cancelled Apr 25, 1929 · Moth Aircraft CorpN1842Boeing CL4S · S/N UNKNOWNCancelled Feb 20, 1928 · Built 1919 · Cleghorn Thomas JamesN2603Naval Aircraft Factory CURTIS MF FLYNG BOAT · S/N 5531Cancellation date not recorded · Potter Robert C
Back to Lowell, MA