OpenAirDocs.org
Beverly, MA

Cancelled registrations · 29

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

N599SRBombardier BD-700-1A10 · S/N 9014Cancelled Sep 7, 2023 · Built 1999 · C&S Global Express 1 LLCN55861Consolidated Vultee BT-13A · S/N 9811Cancelled May 1, 2020 · Revoked, canceled · Built 1943 · Eastern Avia IncN17145Stinson SR-9D · S/N 5218Cancelled Nov 29, 2019 · Revoked, canceled · Built 1937 · Bryne Edward R JrN912SPP&M QUIK · S/N 8634Cancelled Jun 4, 2019 · Exported to South Africa · Built 2012 · Pattinson Stephen CN6410DNorth American SNJ-5 · S/N 8819555Cancelled Apr 5, 2018 · Revoked, canceled · Deschenes Constr Co IncN23315Piper J4A · S/N 4584Cancelled Oct 28, 2017 · Revoked, canceled · Built 1939 · Eastern Avia IncN8365MPiper PA-28-161 · S/N 28-8116193Cancelled Jun 15, 2017 · Registration expired, pending cancellation · Built 1981 · High Flight IncN85332Aeronca 7AC · S/N 7AC4071Cancelled Feb 4, 2017 · Revoked, canceled · Built 1946 · Eastern Aviation IncN55EBBurnett William Howard JR KITFOX IV · S/N ECU039Cancelled Feb 2, 2017 · First renewal notice · Burnett William H JrN84409Aeronca 7AC · S/N 7AC-3103Cancelled Sep 17, 2013 · Registration expired, pending cancellation · Built 1946 · Scofield Aviation IncN47967Fairchild M-62A · S/N T40388Cancelled Jul 16, 2013 · Revoked, canceled · Built 1940 · Donlon JohnN5398KHunter Alfred J III PHANTOM TWIN · S/N 227Cancelled Jul 15, 2013 · Registration expired, pending cancellation · Hunter Alfred J IIIN3985WPiper PA-32-260 · S/N 32-956Cancelled Sep 27, 2012 · Sale reported, canceled · Built 1967N47147Cessna 152 · S/N 15283179Cancelled Aug 23, 2012 · Sale reported, pending cancellation · Built 1979N8260DPiper PA-28-161 · S/N 288116027Cancelled Dec 28, 1990 · Exported to United Kingdom · Am Zweil Real Estate IncN5991YPiper PA-23-250 · S/N 27-3165Cancelled Jul 20, 1973 · New England Flyers Air Service IncN83022Aeronca 7AC · S/N 7AC-1677Cancelled May 18, 1973 · New England Flyers Air Service IncN3937NMooney M-20G · S/N 680064Cancelled Jan 28, 1971 · Exported to Canada · Built 1967 · New England Flyers Air Service IncN2612WMooney M20E · S/N 958Cancelled Sep 22, 1970 · Built 1966 · Demarkis John P EtalN84076Aeronca 7AC · S/N 7AC-2763Cancelled Feb 23, 1956 · Eastern Aviation IncN84151Aeronca 7AC · S/N 7AC-2837Cancelled Feb 23, 1956 · Eastern Aviation IncN24819Piper J3L · S/N 3465Cancelled Oct 7, 1955 · Built 1939 · King Bruce WN80987Globe GC-1B · S/N 1180Cancelled Jul 11, 1955 · Built 1946 · Hoaglund PeterN2424EAeronca 7AC · S/N 7AC-6003Cancelled May 16, 1955 · Exported to Canada · Built 1946 · Eastern Aviation IncN5060CBeech B35 · S/N D-2322Cancelled Dec 4, 1951 · Exported to Brazil · Atlantic Aviation CorpN5314KRyan NAVION B · S/N NAV-4-2214-BCancelled Mar 20, 1951 · North Atlantic Airways IncN9221HFairchild M-62A-3 · S/N FN-397Cancelled Jun 7, 1950 · North Atlantic Airways IncN89350Cessna 140 · S/N 8378Cancelled Nov 22, 1948 · Eastern Aviation IncN9400KStinson 108-2 · S/N 108-2400Cancelled Sep 17, 1947 · Eastern Aviation Inc
Back to Beverly, MA