OpenAirDocs.org
Springfield, 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 = 'SPRINGFIELD'
  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.

N93241Commonwealth 185 · S/N 1746Cancelled Jan 14, 2019 · Revoked, canceled · Built 1946 · Tulip William FN50QJBritish Aerospace BAE 125 SERIES 800A · S/N NA0469Cancelled Apr 18, 2018 · Registration expired, pending cancellation · Churchill Jets LLCN8676UCessna 172F · S/N 17252579Cancelled Oct 24, 2013 · Registration expired, pending cancellation · Built 1965 · Deyampert Thomas HN71CTRaven S-50A · S/N S50A158Cancelled Dec 9, 1998 · Triennial form not returned · Hadank Walter RN4472SWoodworth Morton F BENSEN B8M · S/N 016263189Cancelled Sep 1, 1993 · Triennial form not returned · Woodworth Morton FN163BBell 47D1 · S/N 17Cancelled Feb 25, 1992 · Triennial form not returned · Associated Air Services IncN9744DPiper PA-22-160 · S/N 22-6657Cancelled Oct 3, 1978 · Exported to Canada · Pioneer Valley Aircraft IncN5260BMooney M20 · S/N 1123Cancelled Mar 28, 1974 · Built 1956 · Arnold William PN98414Piper J3C-65 · S/N 18601Cancelled Dec 29, 1959 · Exported to Switzerland · Frank GustavN45727Luscombe 8A · S/N 2254Cancelled Nov 27, 1957 · Exported to Canada · Quinn Daniel EN14992Lockheed ELECTRA 10-B · S/N 1051Cancelled Feb 17, 1956 · Built 1935 · Zilkan SamN81347Fairchild 24W-46 · S/N W46247Cancelled Oct 25, 1955 · Built 1946 · Quinn Daniel EN90367Globe GC-1A · S/N 381Cancelled Oct 13, 1955 · Willaim D GallantN9450HBeech D17S · S/N 6764Cancelled Feb 25, 1954 · Springfield Feeder Lines IncN2352BTemco GC-1B · S/N 3652Cancelled Jul 11, 1951 · Exported to Venezuela · Bowen Dexter PN51823Fairchild M-62A · S/N T42-1411Cancelled Feb 10, 1949 · Built 1945 · Houser John AN51812Boeing A75N1 · S/N 75-1922Cancelled Nov 29, 1948 · Built 1945 · Frank GustavN51840Fairchild PT-19A · S/N T43-5068Cancelled Nov 29, 1948 · Built 1945 · Frank GustavN1331Miller MILLER Z · S/N 1Cancelled Jul 12, 1948 · Built 1937 · Miller Aircraft CorporationN21436Piper J-3 · S/N 2294Cancelled Jun 15, 1948 · Built 1942 · Gray Clarence R JrN36498Douglas DC3C · S/N 12527Cancelled Apr 28, 1948 · Built 1942 · Bruning Aviation IncN49695Consolidated Vultee PBY-5A · S/N 925Cancelled Feb 27, 1948 · Bruning Aviation IncN9619Stinson SM-2 · S/N 1033Cancelled Jun 1, 1941 · Frank GustavN13905Stearman 4E · S/N 4001Cancelled Dec 13, 1939 · Built 1929 · Wheeler Rostell CedricN2100Granville Brothers GEE BEE SPORTSTER D · S/N R-1Cancelled Jul 27, 1933 · Built 1932 · Springfield Air Racing Association IncN10104Alexander PRIMARY GLIDER · S/N 122Cancelled Jun 17, 1933 · Built 1930 · Massachusetts Airways CorpN46VGranville Brothers E · S/N 7Cancelled Sep 7, 1932 · Granville Brothers Aircraft IncN6691Command-Aire 3C-3 · S/N 516Cancelled Nov 3, 1931 · Built 1928 · Springfield Airport & Aeronautical School IncN49VGranville Brothers GEE BEE · S/N 1GBACancelled Sep 29, 1931 · Brinton & Bayles Flying Service IncN1369American Eagle A-1 · S/N 39Cancelled Sep 4, 1931 · Carl Rolf & Crawford Hogg & Hector B FoleyN5591Command-Aire 3C-3 · S/N 505Cancelled Jan 16, 1930 · Sale Reported To Carl MartensN1109Sikorsky S-38-B · S/N 850Cancelled Oct 7, 1927 · Built 1927 · Day Winsor B
Back to Springfield, MA