# Cancelled registrations: Springfield, MA

A list on [Springfield, MA](https://openairdocs.org/faa-place/MA/Springfield.md).

Cancelled aircraft registrations in Springfield, MA.

- [N93241](https://openairdocs.org/deregistered/N93241-2019-01-14.md): Commonwealth 185 · S/N 1746 · Cancelled Jan 14, 2019 · Revoked, canceled · Built 1946 · Tulip William F
- [N50QJ](https://openairdocs.org/deregistered/N50QJ-2018-04-18.md): British Aerospace BAE 125 SERIES 800A · S/N NA0469 · Cancelled Apr 18, 2018 · Registration expired, pending cancellation · Churchill Jets LLC
- [N8676U](https://openairdocs.org/deregistered/N8676U-2013-10-24.md): Cessna 172F · S/N 17252579 · Cancelled Oct 24, 2013 · Registration expired, pending cancellation · Built 1965 · Deyampert Thomas H
- [N71CT](https://openairdocs.org/deregistered/N71CT-1998-12-09.md): Raven S-50A · S/N S50A158 · Cancelled Dec 9, 1998 · Triennial form not returned · Hadank Walter R
- [N4472S](https://openairdocs.org/deregistered/N4472S-1993-09-01.md): Woodworth Morton F BENSEN B8M · S/N 016263189 · Cancelled Sep 1, 1993 · Triennial form not returned · Woodworth Morton F
- [N163B](https://openairdocs.org/deregistered/N163B-1992-02-25.md): Bell 47D1 · S/N 17 · Cancelled Feb 25, 1992 · Triennial form not returned · Associated Air Services Inc
- [N9744D](https://openairdocs.org/deregistered/N9744D-1978-10-03.md): Piper PA-22-160 · S/N 22-6657 · Cancelled Oct 3, 1978 · Exported to Canada · Pioneer Valley Aircraft Inc
- [N5260B](https://openairdocs.org/deregistered/N5260B-1974-03-28.md): Mooney M20 · S/N 1123 · Cancelled Mar 28, 1974 · Built 1956 · Arnold William P
- [N98414](https://openairdocs.org/deregistered/N98414-1959-12-29.md): Piper J3C-65 · S/N 18601 · Cancelled Dec 29, 1959 · Exported to Switzerland · Frank Gustav
- [N45727](https://openairdocs.org/deregistered/N45727-1957-11-27.md): Luscombe 8A · S/N 2254 · Cancelled Nov 27, 1957 · Exported to Canada · Quinn Daniel E
- [N14992](https://openairdocs.org/deregistered/N14992-1956-02-17.md): Lockheed ELECTRA 10-B · S/N 1051 · Cancelled Feb 17, 1956 · Built 1935 · Zilkan Sam
- [N81347](https://openairdocs.org/deregistered/N81347-1955-10-25.md): Fairchild 24W-46 · S/N W46247 · Cancelled Oct 25, 1955 · Built 1946 · Quinn Daniel E
- [N90367](https://openairdocs.org/deregistered/N90367-1955-10-13.md): Globe GC-1A · S/N 381 · Cancelled Oct 13, 1955 · Willaim D Gallant
- [N9450H](https://openairdocs.org/deregistered/N9450H-1954-02-25.md): Beech D17S · S/N 6764 · Cancelled Feb 25, 1954 · Springfield Feeder Lines Inc
- [N2352B](https://openairdocs.org/deregistered/N2352B-1951-07-11.md): Temco GC-1B · S/N 3652 · Cancelled Jul 11, 1951 · Exported to Venezuela · Bowen Dexter P
- [N51823](https://openairdocs.org/deregistered/N51823-1949-02-10.md): Fairchild M-62A · S/N T42-1411 · Cancelled Feb 10, 1949 · Built 1945 · Houser John A
- [N51812](https://openairdocs.org/deregistered/N51812-1948-11-29.md): Boeing A75N1 · S/N 75-1922 · Cancelled Nov 29, 1948 · Built 1945 · Frank Gustav
- [N51840](https://openairdocs.org/deregistered/N51840-1948-11-29.md): Fairchild PT-19A · S/N T43-5068 · Cancelled Nov 29, 1948 · Built 1945 · Frank Gustav
- [N1331](https://openairdocs.org/deregistered/N1331-1948-07-12.md): Miller MILLER Z · S/N 1 · Cancelled Jul 12, 1948 · Built 1937 · Miller Aircraft Corporation
- [N21436](https://openairdocs.org/deregistered/N21436-1948-06-15.md): Piper J-3 · S/N 2294 · Cancelled Jun 15, 1948 · Built 1942 · Gray Clarence R Jr
- [N36498](https://openairdocs.org/deregistered/N36498-1948-04-28.md): Douglas DC3C · S/N 12527 · Cancelled Apr 28, 1948 · Built 1942 · Bruning Aviation Inc
- [N49695](https://openairdocs.org/deregistered/N49695-1948-02-27.md): Consolidated Vultee PBY-5A · S/N 925 · Cancelled Feb 27, 1948 · Bruning Aviation Inc
- [N9619](https://openairdocs.org/deregistered/N9619-1941-06-01.md): Stinson SM-2 · S/N 1033 · Cancelled Jun 1, 1941 · Frank Gustav
- [N13905](https://openairdocs.org/deregistered/N13905-1939-12-13.md): Stearman 4E · S/N 4001 · Cancelled Dec 13, 1939 · Built 1929 · Wheeler Rostell Cedric
- [N2100](https://openairdocs.org/deregistered/N2100-1933-07-27.md): Granville Brothers GEE BEE SPORTSTER D · S/N R-1 · Cancelled Jul 27, 1933 · Built 1932 · Springfield Air Racing Association Inc
- [N10104](https://openairdocs.org/deregistered/N10104-1933-06-17.md): Alexander PRIMARY GLIDER · S/N 122 · Cancelled Jun 17, 1933 · Built 1930 · Massachusetts Airways Corp
- [N46V](https://openairdocs.org/deregistered/N46V-1932-09-07.md): Granville Brothers E · S/N 7 · Cancelled Sep 7, 1932 · Granville Brothers Aircraft Inc
- [N6691](https://openairdocs.org/deregistered/N6691-1931-11-03.md): Command-Aire 3C-3 · S/N 516 · Cancelled Nov 3, 1931 · Built 1928 · Springfield Airport & Aeronautical School Inc
- [N49V](https://openairdocs.org/deregistered/N49V-1931-09-29.md): Granville Brothers GEE BEE · S/N 1GBA · Cancelled Sep 29, 1931 · Brinton & Bayles Flying Service Inc
- [N1369](https://openairdocs.org/deregistered/N1369-1931-09-04.md): American Eagle A-1 · S/N 39 · Cancelled Sep 4, 1931 · Carl Rolf & Crawford Hogg & Hector B Foley
- [N5591](https://openairdocs.org/deregistered/N5591-1930-01-16.md): Command-Aire 3C-3 · S/N 505 · Cancelled Jan 16, 1930 · Sale Reported To Carl Martens
- [N1109](https://openairdocs.org/deregistered/N1109-1927-10-07.md): Sikorsky S-38-B · S/N 850 · Cancelled Oct 7, 1927 · Built 1927 · Day Winsor B

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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
```

This list as a web page: https://openairdocs.org/faa-place/MA/Springfield/earlier

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.