# Cancelled registrations: Haverhill, MA

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

Cancelled aircraft registrations in Haverhill, MA.

- [N5741H](https://openairdocs.org/deregistered/N5741H-2020-04-10.md): Piper PA-16 · S/N 16-354 · Cancelled Apr 10, 2020 · Revoked, canceled · Built 1949 · Obrien Linc Jr
- [N678AL](https://openairdocs.org/deregistered/N678AL-2018-03-02.md): Piper PA-30 · S/N 30-639 · Cancelled Mar 2, 2018 · Registration expired, pending cancellation · La Rosa Antonio
- [N375AL](https://openairdocs.org/deregistered/N375AL-2018-03-01.md): Socata Group Aerospatiale TB9 · S/N 1370 · Cancelled Mar 1, 2018 · Registration expired, pending cancellation · Larosa Antonio
- [N20473](https://openairdocs.org/deregistered/N20473-2012-08-22.md): Cessna 172M · S/N 17261316 · Cancelled Aug 22, 2012 · Registration expired, pending cancellation · Built 1972 · Andrea Aviation Inc
- [N302SB](https://openairdocs.org/deregistered/N302SB-2006-02-28.md): Mooney M20J · S/N 24-0933 · Cancelled Feb 28, 2006 · Triennial form not returned · Built 1979 · Calascibetta Salvatore
- [N9258S](https://openairdocs.org/deregistered/N9258S-1994-10-06.md): Beech B24R · S/N MC388 · Cancelled Oct 6, 1994 · Triennial form not returned · Vest Air Leasing Inc
- [N21869](https://openairdocs.org/deregistered/N21869-1984-08-11.md): Cessna 172M · S/N 17264037 · Cancelled Aug 11, 1984 · Administratively canceled · Sawyer Aldrich W
- [N2HD](https://openairdocs.org/deregistered/N2HD-1982-07-26.md): Piper PA-23 · S/N 23-362 · Cancelled Jul 26, 1982 · Built 1955 · Dutton Flying Service Inc
- [N5708T](https://openairdocs.org/deregistered/N5708T-1981-12-24.md): Cessna 172E · S/N 17251608 · Cancelled Dec 24, 1981 · Dutton Donald H DBA Dutton Flying Service
- [N86770](https://openairdocs.org/deregistered/N86770-1977-08-19.md): Bellanca 8KCAB · S/N 114-74 · Cancelled Aug 19, 1977 · Dutton Donald
- [N4CQ](https://openairdocs.org/deregistered/N4CQ-1977-05-26.md): Pitts S-2A · S/N 2007 · Cancelled May 26, 1977 · Exported to Belgium · Built 1971 · Dutton Howard F
- [N91968](https://openairdocs.org/deregistered/N91968-1972-03-15.md): Piper J3C-65 · S/N 16399 · Cancelled Mar 15, 1972 · Dutton Howard F
- [N42405](https://openairdocs.org/deregistered/N42405-1970-09-23.md): Piper J3C-65 · S/N 14665 · Cancelled Sep 23, 1970 · Auclair Raymond H
- [N301T](https://openairdocs.org/deregistered/N301T-1960-06-17.md): Piper PA-18 105 · S/N 18-2415 · Cancelled Jun 17, 1960 · Exported to Germany · Dutton Howard
- [N3959E](https://openairdocs.org/deregistered/N3959E-1960-05-09.md): Aeronca 11BC · S/N 11BC-43 · Cancelled May 9, 1960 · Exported to Canada · Slavit Evelyn M
- [N64879](https://openairdocs.org/deregistered/N64879-1956-03-12.md): Cessna T-50 · S/N 3426 · Cancelled Mar 12, 1956 · Dutton Howard F
- [N33597](https://openairdocs.org/deregistered/N33597-1956-02-20.md): Piper J3C-65 · S/N 14074 · Cancelled Feb 20, 1956 · Dutton Howard F
- [N6235K](https://openairdocs.org/deregistered/N6235K-1956-02-03.md): Republic RC-3 · S/N 438 · Cancelled Feb 3, 1956 · Slavit William J
- [N8588](https://openairdocs.org/deregistered/N8588-1955-11-14.md): Waco CSO · S/N A96 · Cancelled Nov 14, 1955 · Built 1930 · Slavit Evelyn
- [N7484H](https://openairdocs.org/deregistered/N7484H-1955-10-05.md): Piper J-3 · S/N 20750 · Cancelled Oct 5, 1955 · Hodgkins Florence N
- [N98082](https://openairdocs.org/deregistered/N98082-1949-06-14.md): Piper J3C-65 · S/N 18237 · Cancelled Jun 14, 1949 · Built 1946 · Walker Dutton Airport
- [N74670](https://openairdocs.org/deregistered/N74670-1949-02-21.md): Cessna T-50 · S/N 3435 · Cancelled Feb 21, 1949 · Walker Dutton Airport
- [N69567](https://openairdocs.org/deregistered/N69567-1949-02-02.md): Cessna T-50 · S/N 2697 · Cancelled Feb 2, 1949 · Built 1943 · Walker Dutton Airport
- [N32507](https://openairdocs.org/deregistered/N32507-1941-07-18.md): Piper J3F-65 · S/N 5405 · Cancelled Jul 18, 1941 · Built 1940 · Pressey Milton A
- [N11899](https://openairdocs.org/deregistered/N11899-1934-09-15.md): Curtiss Wright JR CW1 · S/N 1269 · Cancelled Sep 15, 1934 · Rachel H Bartlett

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

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