# Cancelled registrations: Andover, MA

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

Cancelled aircraft registrations in Andover, MA.

- [N921JA](https://openairdocs.org/deregistered/N921JA-2025-01-25.md): Robinson Helicopter R44 · S/N 1188 · Cancelled Jan 25, 2025 · Sale reported, canceled · Built 2002
- [N32028](https://openairdocs.org/deregistered/N32028-2024-11-02.md): Piper PA-28-140 · S/N 28-7525013 · Cancelled Nov 2, 2024 · Registration pending, canceled · Built 1974
- [N569BB](https://openairdocs.org/deregistered/N569BB-2018-12-10.md): Physical Sciences INSTANTEYE MK-2 GEN3 · S/N 0030200300668 · Cancelled Dec 10, 2018 · Registration expired, pending cancellation · Physical Sciences Inc
- [N569CB](https://openairdocs.org/deregistered/N569CB-2018-12-10.md): Physical Sciences INSTANTEYE MK-2 GEN3 · S/N 0030200300667 · Cancelled Dec 10, 2018 · Registration expired, pending cancellation · Physical Sciences Inc
- [N569FP](https://openairdocs.org/deregistered/N569FP-2018-12-10.md): Physical Sciences INSTANTEYE MK-2 GEN3 · S/N 0030200300656 · Cancelled Dec 10, 2018 · Registration expired, pending cancellation · Physical Sciences Inc
- [N569MP](https://openairdocs.org/deregistered/N569MP-2018-12-10.md): Physical Sciences INSTANTEYE MK-2 GEN3 · S/N 0030200300664 · Cancelled Dec 10, 2018 · Registration expired, pending cancellation · Physical Sciences Inc
- [N572KG](https://openairdocs.org/deregistered/N572KG-2018-12-10.md): Physical Sciences INSTANTEYE MK-2 GEN3 · S/N 0030210300022 · Cancelled Dec 10, 2018 · Registration expired, pending cancellation · Physical Sciences Inc
- [N572LP](https://openairdocs.org/deregistered/N572LP-2018-12-10.md): Physical Sciences INSTANTEYE MK-2 GEN3 · S/N 0030210300094 · Cancelled Dec 10, 2018 · Registration expired, pending cancellation · Physical Sciences Inc
- [N572MG](https://openairdocs.org/deregistered/N572MG-2018-12-10.md): Physical Sciences INSTANTEYE MK-2 GEN3 · S/N 0030210300028 · Cancelled Dec 10, 2018 · Registration expired, pending cancellation · Physical Sciences Inc
- [N573JG](https://openairdocs.org/deregistered/N573JG-2018-12-10.md): Physical Sciences INSTANTEYE MK-2 GEN3 · S/N 0030210300077 · Cancelled Dec 10, 2018 · Registration expired, pending cancellation · Physical Sciences Inc
- [N568ZZ](https://openairdocs.org/deregistered/N568ZZ-2018-06-26.md): Physical Sciences INSTANTEYE MK-2 GEN3 · S/N 0030200300669 · Cancelled Jun 26, 2018 · Registration pending, canceled
- [N573WG](https://openairdocs.org/deregistered/N573WG-2018-06-26.md): Physical Sciences INSTANTEYE MK-2 GEN3 · S/N 0030210300040 · Cancelled Jun 26, 2018 · Registration pending, canceled
- [N5749P](https://openairdocs.org/deregistered/N5749P-2018-06-26.md): Physical Sciences INSTANTEYE MK-2 GEN3 · S/N 0030210300032 · Cancelled Jun 26, 2018 · Registration pending, canceled
- [N574SD](https://openairdocs.org/deregistered/N574SD-2018-06-26.md): Physical Sciences INSTANTEYE MK-2 GEN3 · S/N 0030210300008 · Cancelled Jun 26, 2018 · Registration pending, canceled
- [N11180](https://openairdocs.org/deregistered/N11180-2012-02-14.md): Franklin Glider PS-2 · S/N 118 · Cancelled Feb 14, 2012 · Revoked, pending cancellation · Built 1931 · Lawrence Soaring Society Inc
- [N3997R](https://openairdocs.org/deregistered/N3997R-2002-08-19.md): Piper PA-28-180 · S/N 28-7105102 · Cancelled Aug 19, 2002 · Triennial form not returned · Built 1971 · Loring Stephen H
- [N905B](https://openairdocs.org/deregistered/N905B-1997-08-22.md): Let L-23 SUPER BLANIK · S/N 917905 · Cancelled Aug 22, 1997 · Rose Robert W
- [N9595Y](https://openairdocs.org/deregistered/N9595Y-1977-05-23.md): Beech 95-A55 · S/N TC-333 · Cancelled May 23, 1977 · Cronin Paul W
- [N2979N](https://openairdocs.org/deregistered/N2979N-1974-07-12.md): Cessna 140 · S/N 13237 · Cancelled Jul 12, 1974 · Von Rosenvinge James T
- [N2900H](https://openairdocs.org/deregistered/N2900H-1971-12-16.md): Ercoupe 415-C · S/N 3525 · Cancelled Dec 16, 1971 · Exported to Canada · Cutler Stephen J
- [N23649](https://openairdocs.org/deregistered/N23649-1971-01-19.md): Taylorcraft BC-65 · S/N 1380 · Cancelled Jan 19, 1971 · Small William Lawrence
- [N1295P](https://openairdocs.org/deregistered/N1295P-1966-07-14.md): Piper PA-23 · S/N 23-3332 · Cancelled Jul 14, 1966 · Albert L Richmond
- [N91129](https://openairdocs.org/deregistered/N91129-1965-05-24.md): North American NAVION · S/N NAV-4-26 · Cancelled May 24, 1965 · Bolten John Jr
- [N2791K](https://openairdocs.org/deregistered/N2791K-1956-01-04.md): Luscombe 8E · S/N 5518 · Cancelled Jan 4, 1956 · Exported to Canada · Schadlick Albert

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

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