# Cancelled registrations: Northampton, MA

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

Cancelled aircraft registrations in Northampton, MA.

- [N9378](https://openairdocs.org/deregistered/N9378-2018-10-29.md): Wesson-Pine BENSEN B-8M · S/N 362-336 · Cancelled Oct 29, 2018 · Revoked, canceled · Built 1970 · Wesson Laurence N
- [N9001P](https://openairdocs.org/deregistered/N9001P-2018-01-17.md): Balloon Works FIREFLY 7 · S/N F7-463 · Cancelled Jan 17, 2018 · Registration expired, pending cancellation · Northamption Airport Inc DBA
- [N2036J](https://openairdocs.org/deregistered/N2036J-2018-01-16.md): Cameron Balloons V-65 · S/N 5377 · Cancelled Jan 16, 2018 · Registration expired, pending cancellation · Built 1989 · Kias Ltd
- [N3783M](https://openairdocs.org/deregistered/N3783M-2016-10-31.md): Piper PA-28R-201 · S/N 28R-7837137 · Cancelled Oct 31, 2016 · First renewal notice · Built 1978 · Hampden Aviation Services Inc
- [N8339A](https://openairdocs.org/deregistered/N8339A-2015-05-05.md): Cessna 170B · S/N 25191 · Cancelled May 5, 2015 · Registration expired, pending cancellation · Built 1952 · Ganim Rose B
- [N71533](https://openairdocs.org/deregistered/N71533-2013-10-21.md): Balloon Works FIREFLY 9B-15 · S/N F9B-022 · Cancelled Oct 21, 2013 · Registration expired, pending cancellation · Built 1999 · Northampton Aeronautics Inc
- [N7047U](https://openairdocs.org/deregistered/N7047U-2013-05-16.md): Balloon Works FIREFLY 8B-15 · S/N F8B-585 · Cancelled May 16, 2013 · Registration expired, pending cancellation · Built 1999 · Northhampton Aeronautics Inc
- [N26Q](https://openairdocs.org/deregistered/N26Q-2013-04-01.md): Lawrence DAVIS DA-2A · S/N 168 · Cancelled Apr 1, 2013 · Sale reported, canceled · Built 1977
- [N9112Y](https://openairdocs.org/deregistered/N9112Y-2013-03-18.md): Piper PA-31-310 · S/N 31-149 · Cancelled Mar 18, 2013 · Sale reported, canceled · Built 1967
- [N2437N](https://openairdocs.org/deregistered/N2437N-2012-08-14.md): Piper PA-38-112 · S/N 38-79A0842 · Cancelled Aug 14, 2012 · Sale reported, canceled · Built 1979
- [N7120F](https://openairdocs.org/deregistered/N7120F-2002-03-29.md): Balloon Works FIREFLY 7 · S/N F7-426 · Cancelled Mar 29, 2002 · Triennial form not returned · Northampton Airport Inc
- [N2135X](https://openairdocs.org/deregistered/N2135X-2001-07-11.md): Mooney M20M · S/N 27-0237 · Cancelled Jul 11, 2001 · Triennial form not returned · Silverscape Designs Inc
- [N3390R](https://openairdocs.org/deregistered/N3390R-1997-12-04.md): Piper PA-28-180 · S/N 285667 · Cancelled Dec 4, 1997 · Exported to Chile · Northampton Flyers
- [N37650](https://openairdocs.org/deregistered/N37650-1996-02-05.md): Balloon Works FIREFLY 7 · S/N F7159 · Cancelled Feb 5, 1996 · Northampton Airport Inc.
- [N2509D](https://openairdocs.org/deregistered/N2509D-1993-03-02.md): Piper PA-38-112 · S/N 3879A0346 · Cancelled Mar 2, 1993 · Mcair Co Inc
- [N33434](https://openairdocs.org/deregistered/N33434-1992-09-16.md): Piper PA-28-140 · S/N 287525191 · Cancelled Sep 16, 1992 · Triennial form not returned · Elm Corp
- [N29900](https://openairdocs.org/deregistered/N29900-1970-06-05.md): Waco UPF-7 · S/N 5397 · Cancelled Jun 5, 1970 · City Aviation
- [N86966](https://openairdocs.org/deregistered/N86966-1965-05-20.md): Ercoupe 415-C · S/N 139 · Cancelled May 20, 1965 · City Aviation Inc
- [N2664P](https://openairdocs.org/deregistered/N2664P-1960-04-26.md): Piper PA-22-150 · S/N PA-22-3004 · Cancelled Apr 26, 1960 · Built 1955 · Lange Frederick A
- [N16058](https://openairdocs.org/deregistered/N16058-1957-08-26.md): Cessna T-50 · S/N 6293 · Cancelled Aug 26, 1957 · City Aviation
- [N19808](https://openairdocs.org/deregistered/N19808-1951-04-17.md): Taylorcraft A · S/N 315 · Cancelled Apr 17, 1951 · Built 1937 · Arel Kenneth H
- [N36184](https://openairdocs.org/deregistered/N36184-1947-11-29.md): Taylorcraft DC-65 · S/N 4014 · Cancelled Nov 29, 1947 · Valley Flyers
- [N35137](https://openairdocs.org/deregistered/N35137-1943-11-01.md): Piper J3L-65 · S/N 6150 · Cancelled Nov 1, 1943 · Hood Air-Craft Sales Company

## 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 = 'NORTHAMPTON'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

This list as a web page: https://openairdocs.org/faa-place/MA/Northampton/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.