OpenAirDocs.org
East Boston, MA

Cancelled registrations · 24

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 = 'EAST BOSTON'
  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.

N19RLLeftwich William S LM-1X · S/N LM-1X-1001Cancelled Mar 11, 2020 · Lockyer RobertN4530PPiper PA-23-250 · S/N 27-34Cancelled Oct 9, 2014 · Registration expired, pending cancellation · Built 1960 · Sabia Joseph EN186CMPiper J3C-65 · S/N 20340Cancelled Sep 10, 2014 · Registration expired, pending cancellation · Built 1946 · Cravotta Phillip SN204EDehavilland DHC-6 TWIN OTTER · S/N 108Cancelled Nov 8, 1971 · Exported to Canada · Executive Airlines IncN90670Convair 240-2 · S/N 90Cancelled Jun 30, 1970 · Northeast Airlines IncN90659Convair 240 · S/N 34Cancelled Feb 10, 1959 · Exported to Brazil · Northeast Airlines IncN53RCessna 172 · S/N 29044Cancelled Jun 23, 1958 · Exported to Canada · Atlantic Aviation CorpN33889Aeronca 65-TL · S/N L9831TCancelled Aug 13, 1948 · Inter City Aviation IncN17166Stinson SR-9B · S/N 5151Cancelled Apr 29, 1948 · Northeast Airlines IncN12121Stinson U · S/N 9009Cancelled Sep 3, 1938 · Mayflower Airlines IncN15849Beech C17B · S/N C17B-92Cancelled Nov 15, 1936 · Built 1936 · Shobe Aairlines IncN4964American Eagle A-1 · S/N 135Cancelled Feb 19, 1936 · Bay State Flying ServiceN965MCurtiss Wright Flying Service FLEDGLING · S/N B-102Cancelled Nov 9, 1931 · Built 1931 · Curtiss Wright Flying ServiceN87KIreland N 2 B · S/N 42Cancelled Mar 10, 1931 · Built 1929 · Curtiss Wright Flying Service IncN56MMoth 60-GM · S/N 72Cancelled Jan 23, 1931 · Built 1929 · Curtiss Wright Flying Service Inc A Me CorpN660KStearman C3-R · S/N 5008Cancelled Jan 5, 1931 · East Coast Aircraft CorpN5458Fairchild Airplane Mfg FC-2 · S/N 91Cancelled Nov 24, 1930 · Built 1928 · Curtiss Flying Service Of New England IncN266HCurtiss Wright FLEDGLING · S/N B-43Cancelled Sep 10, 1930 · Built 1929 · Curtiss Flying Service Of New England IncN831EMoth 60-GM · S/N 1-FCancelled Jul 15, 1930 · Built 1929 · Skyways IncN4791Avro TRAINING · S/N 1Cancelled Jul 9, 1930 · Croce Thomas JrN2779Stinson SB-1 · S/N 108Cancelled Jul 1, 1930 · Curitss Flying Service Of New England IncN374HMoth 60G · S/N 1-MCancelled Apr 18, 1930 · Built 1929 · Skyways IncN223Curtiss Wright TRAVEL AIR 2000 · S/N 139Cancelled Jan 10, 1930 · Built 1926 · Curtiss Flying ServiceN6604Curtiss JN4D · S/N 5219Cancelled Oct 17, 1929 · Built 1918 · Curtiss Flying Service Of New England Inc
Back to East Boston, MA