# Cancelled registrations: Madison, CT

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

Cancelled aircraft registrations in Madison, CT.

- [N424CS](https://openairdocs.org/deregistered/N424CS-2016-09-06.md): Israel Aircraft Industries 1124 · S/N 255 · Cancelled Sep 6, 2016 · Exported to Argentina · Built 1979 · Waterside Aircraft Marketing LLC
- [N5713P](https://openairdocs.org/deregistered/N5713P-2015-04-30.md): Piper PA-24-250 · S/N 24-787 · Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1959 · Hartman John S
- [N61060](https://openairdocs.org/deregistered/N61060-2014-11-19.md): Cessna 150J · S/N 15070772 · Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1969 · Griswold Air Service Inc
- [N2817M](https://openairdocs.org/deregistered/N2817M-2014-09-25.md): Piper PA-12 · S/N 12-1408 · Cancelled Sep 25, 2014 · Registration expired, pending cancellation · Built 1946 · Griswold Sherman H DBA
- [N6601B](https://openairdocs.org/deregistered/N6601B-2013-02-13.md): Cessna 310B · S/N 35701 · Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1958
- [N4647P](https://openairdocs.org/deregistered/N4647P-2012-12-11.md): Piper PA-23-250 · S/N 27-168 · Cancelled Dec 11, 2012 · Registration expired, pending cancellation · Built 1960 · Forte Victor H
- [N2387P](https://openairdocs.org/deregistered/N2387P-2012-09-06.md): Piper PA-38-112 · S/N 38-79A0972 · Cancelled Sep 6, 2012 · Registration expired, pending cancellation · Built 1979 · Shoreline Aviation Inc
- [N44VJ](https://openairdocs.org/deregistered/N44VJ-2007-10-02.md): Jones Virgil DOMINATOR · S/N 62244 · Cancelled Oct 2, 2007 · Triennial form not returned · Built 1993 · Hammer Alfred E III
- [N5065B](https://openairdocs.org/deregistered/N5065B-2006-10-17.md): Beech F35 · S/N D-4348 · Cancelled Oct 17, 2006 · Triennial form not returned · Built 1955 · Griswold Air Service Inc
- [N4814J](https://openairdocs.org/deregistered/N4814J-2006-08-16.md): Piper PA-28R-180 · S/N 28R-30606 · Cancelled Aug 16, 2006 · Triennial form not returned · Built 1968 · Connecticut Flyers Inc
- [N121BG](https://openairdocs.org/deregistered/N121BG-2000-08-31.md): Cessna 182R · S/N 18267740 · Cancelled Aug 31, 2000 · Triennial form not returned · Buell Donald S
- [N5280V](https://openairdocs.org/deregistered/N5280V-1992-12-28.md): Cessna 210L · S/N 21060895 · Cancelled Dec 28, 1992 · Triennial form not returned · Built 1975 · Thermtran Ltd
- [N4765F](https://openairdocs.org/deregistered/N4765F-1981-05-06.md): Piper PA-28-151 · S/N 28-7715066 · Cancelled May 6, 1981 · Air Ventures Inc
- [N974W](https://openairdocs.org/deregistered/N974W-1977-07-25.md): Siai-Marchetti S.205/22R · S/N 4-157 · Cancelled Jul 25, 1977 · Griswold Air Service Inc
- [N17565](https://openairdocs.org/deregistered/N17565-1974-11-22.md): Dehavilland DH82A · S/N 1000 · Cancelled Nov 22, 1974 · Exported to United Kingdom · Built 1969 · Dent Richard
- [N9373H](https://openairdocs.org/deregistered/N9373H-1965-05-25.md): Fairchild M-62A-3 · S/N FT-794 · Cancelled May 25, 1965 · George P Trahan
- [N4855A](https://openairdocs.org/deregistered/N4855A-1960-06-17.md): Piper PA-22-150 · S/N 22-4011 · Cancelled Jun 17, 1960 · Exported to United Kingdom · Logan Richard W
- [N92051](https://openairdocs.org/deregistered/N92051-1955-10-13.md): Piper J3C-65 · S/N 16484 · Cancelled Oct 13, 1955 · Clinton Flying Club
- [N84962](https://openairdocs.org/deregistered/N84962-1950-10-31.md): Aeronca 7AC · S/N 7AC-3685 · Cancelled Oct 31, 1950 · Richard B Hinman

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

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