OpenAirDocs.org
Boston, MA

Cancelled registrations · 217

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

N2905MPiper PA-12 · S/N 12-1319Cancelled Jun 29, 1970 · Banner Advertising CorpN4114ARepublic F-84E · S/N 50-1145RCancelled Jun 8, 1970 · Wentworth InstituteN34417Douglas DC3A · S/N 7337Cancelled Aug 6, 1969 · Northeast Airlines IncN7341UCessna 411 · S/N 411-0041Cancelled Jan 28, 1969 · First Electronics CorpN380NEFairchild FH-227 · S/N 517Cancelled Nov 12, 1968 · Built 1966 · Northeast Airlines IncN4118ARepublic F84G · S/N 511269ACancelled May 22, 1965 · Boston UniversityN23681Taylorcraft BC-65 · S/N 1415Cancelled May 21, 1965 · Built 1939 · Spring Roy LN82196Aeronca 7AC · S/N 7AC-824Cancelled Feb 27, 1964 · Foster Walter SeymourN6592CVickers VISCOUNT 797 · S/N 234Cancelled Dec 17, 1963 · Northeast Airlines IncN91238Convair 240-13 · S/N 158Cancelled Nov 4, 1963 · Northeast Airlines IncN90666Convair 240 · S/N 67Cancelled Feb 10, 1959 · Exported to Brazil · Northeast Airlines IncN7450DPiper PA-22-150 · S/N 22-5216Cancelled Jan 8, 1959 · Exported to Jamaica · Boston Bay Co IncN7104BPiper PA-22-150 · S/N 22-4320Cancelled Jan 2, 1959 · Le Trappeur IncN6595CBristol BRITANNIA 305 · S/N 12920Cancelled Jul 23, 1958 · Northeast Airlines IncN6596CBristol BRITANNIA 305 · S/N 12921Cancelled Jul 23, 1958 · Northeast Airlines IncN6597CBristol BRITANNIA 305 · S/N 12922Cancelled Jul 23, 1958 · Northeast Airlines IncN6598CBristol BRITANNIA 305 · S/N 12923Cancelled Jul 23, 1958 · Northeast Airlines IncN6599CBristol BRITANNIA 305 · S/N 12924Cancelled Jul 23, 1958 · Northeast Airlines IncN65779Douglas A-26B · S/N 1136Cancelled Mar 14, 1956 · Built 1945 · Howes Ernest GrantN60522Cessna T-50 · S/N 4975Cancelled Feb 15, 1956 · Colman Robert J And Liss Irving EN51465Cessna T-50 · S/N 5997Cancelled Oct 20, 1955 · New England Central Airways System IncN22248Taylorcraft BC · S/N 1195Cancelled Oct 19, 1955 · Melvin ComptonN39759Waco UPF-7 · S/N 5892Cancelled Mar 31, 1955 · Sky-Ads IncN638DBeech C35 · S/N D-2902Cancelled Feb 21, 1955 · Gardiner William TudorN80981Globe GC-1B · S/N 1174Cancelled Oct 26, 1953 · Flagg Bracket And Durgin IncN20588Taylorcraft A · S/N 600Cancelled Sep 28, 1950 · John B SlateN3836MPiper PA-12 · S/N 12-2764Cancelled Jun 20, 1950 · Bisland TheodoreN91241Convair 240 · S/N 161Cancelled Sep 8, 1949 · Northeast Airlines IncN9223HFairchild M-62A-4 · S/N T-42-4040Cancelled Jun 16, 1949 · Earle Arthur HN49780Cessna T-50 · S/N 6693Cancelled Jun 3, 1949 · New England Central Airways System IncN49832Cessna T-50 · S/N 5863Cancelled Jun 3, 1949 · New England Central Airways System IncN1548Fokker UNIVERSAL · S/N 420Cancelled Mar 8, 1948 · Exported to Honduras · Tela Railroad CompanyN16076Lockheed 12A · S/N 1202Cancelled Sep 9, 1943 · Tela Railroad CoN16187Stinson SR-8D · S/N 9769Cancelled Sep 15, 1941 · Northeast Airlines IncN429YStinson SM-6000 AIRLINER · S/N 5011Cancelled Mar 15, 1941 · Built 1930 · Boston-Maine Airways IncN18470Barkley - Grow T8P-1 · S/N 7Cancelled Aug 22, 1940 · Byrd Richard EN14054Waco CJC · S/N 3899Cancelled Aug 1, 1939 · Boardman Earl GN13295Nestor Ernest Toran TORAN GLIDER · S/N 1Cancelled Jul 1, 1938 · Nestor Ernest ToranN14265Northrop DELTA 1D · S/N 40Cancelled Apr 6, 1938 · Built 1934 · Danforth William HN5084Stearman C3-B · S/N 123Cancelled Aug 29, 1937 · Built 1928 · Bowen William SN12636Bellanca CH400 SKYROCKET · S/N 627Cancelled Oct 14, 1936 · Compainia Agricola De Ulua IncN976WStinson SM-6000 AIRLINER · S/N 5007Cancelled Apr 8, 1936 · National Airways IncN12384Curtiss Wright T-32-S CONDOR · S/N 41Cancelled Oct 15, 1934 · Byrd Antarctic ExpeditionN331NFokker AF-14-B · S/N 1411Cancelled Oct 15, 1934 · Byrd Richard EN1892Aeromarine 39-B · S/N A581Cancelled Sep 8, 1934 · Built 1927 · Mosher George FN624KTravel Air S-6000-B · S/N 6B2011Cancelled Nov 1, 1933 · Inter City Airlines IncN254HCurtiss Wright FLEDGLING · S/N B-35Cancelled Oct 1, 1933 · Built 1929 · Chinese Patriotic Flying CorpsN96KAmphibions P-2 PRIVATEER · S/N 65Cancelled Jul 28, 1933 · Built 1930 · Stearns Marine Company IncN793WCurtiss Aircraft & Motor SEAGULL · S/N 4Cancelled Feb 14, 1933 · Massachusetts Air Ferries Inc/Arthur SullivanN32VViking Flying Boat KITTY HAWK B-4 · S/N 16Cancelled Jan 11, 1933 · Ames-Skyways Inc
Back to Boston, MA