# Cancelled registrations: Albion, NY

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

Cancelled aircraft registrations in Albion, NY.

- [N46403](https://openairdocs.org/deregistered/N46403-2018-09-13.md): Fairchild M-62A · S/N T43-5343 · Cancelled Sep 13, 2018 · Registration expired, pending cancellation · Built 1943 · Vintage Aircraft Group Inc
- [N18HK](https://openairdocs.org/deregistered/N18HK-2014-06-12.md): Steuber CGS HAWK · S/N 1 · Cancelled Jun 12, 2014 · Built 2008 · Steuber Edward P
- [N226PT](https://openairdocs.org/deregistered/N226PT-2010-04-23.md): Fairchild M-62A-3 · S/N FC213 · Cancelled Apr 23, 2010 · Exported to Canada · Built 1943 · Vintage Aircraft Group Inc
- [N3070U](https://openairdocs.org/deregistered/N3070U-1996-03-29.md): Cessna 172E · S/N 17250670 · Cancelled Mar 29, 1996 · Triennial form not returned · Crosswinds Inc
- [N23010](https://openairdocs.org/deregistered/N23010-1982-03-31.md): Luscombe 8A · S/N 933 · Cancelled Mar 31, 1982 · Built 1939 · Giard Arthur L
- [N9655V](https://openairdocs.org/deregistered/N9655V-1981-10-15.md): Cessna R172K · S/N R1722343 · Cancelled Oct 15, 1981 · Barre Aviation Inc
- [N4758A](https://openairdocs.org/deregistered/N4758A-1979-02-23.md): Piper PA-22-150 · S/N 22-3906 · Cancelled Feb 23, 1979 · Felstead Herbert
- [N7567T](https://openairdocs.org/deregistered/N7567T-1973-04-30.md): Cessna 172A · S/N 47167 · Cancelled Apr 30, 1973 · Exported to Canada · Freeman Donald F Judith T Freeman
- [N3610N](https://openairdocs.org/deregistered/N3610N-1971-08-25.md): Piper J3C-65 · S/N 22860 · Cancelled Aug 25, 1971 · Gennesee Valley Trust Company
- [N2156E](https://openairdocs.org/deregistered/N2156E-1971-08-02.md): Aeronca 7AC · S/N 7AC-5727 · Cancelled Aug 2, 1971 · Orleans Flying Club Inc
- [N3492N](https://openairdocs.org/deregistered/N3492N-1955-10-20.md): Piper J3C-65 · S/N 22719 · Cancelled Oct 20, 1955 · Built 1947 · Genesee Valley Trust Co
- [N1512E](https://openairdocs.org/deregistered/N1512E-1955-07-26.md): Aeronca 7AC · S/N 7AC-5075 · Cancelled Jul 26, 1955 · Whitting Cleon
- [N85140](https://openairdocs.org/deregistered/N85140-1952-09-16.md): Aeronca 7AC · S/N 7AC-3871 · Cancelled Sep 16, 1952 · Exported to Canada · Built 1946 · Higley Harold M
- [N3491N](https://openairdocs.org/deregistered/N3491N-1950-10-05.md): Piper J3C-65 · S/N 22716 · Cancelled Oct 5, 1950 · Genessee Valley Trust Company
- [N96858](https://openairdocs.org/deregistered/N96858-1950-05-11.md): Taylorcraft BC12-D · S/N 9158 · Cancelled May 11, 1950 · Built 1946 · Higley Harold M
- [N4907M](https://openairdocs.org/deregistered/N4907M-1949-05-31.md): Piper PA-11 · S/N 11-1648 · Cancelled May 31, 1949 · Built 1948 · Dragon Peter

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

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