# Cancelled registrations: Dansville, NY

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

Cancelled aircraft registrations in Dansville, NY.

- [N90870](https://openairdocs.org/deregistered/N90870-2018-03-07.md): Let BLANIK L-13 · S/N 025801 · Cancelled Mar 7, 2018 · Registration expired, pending cancellation · Built 1974 · Finger Lakes Soaring Club
- [N66FL](https://openairdocs.org/deregistered/N66FL-2018-03-06.md): Let L-13 BLANIK · S/N 026346 · Cancelled Mar 6, 2018 · Registration expired, pending cancellation · Built 1975 · Finger Lakes Soaring Club Inc
- [N3313](https://openairdocs.org/deregistered/N3313-2018-02-13.md): Nagle David R 333 · S/N 179 · Cancelled Feb 13, 2018 · Registration expired, pending cancellation · Built 1999 · Nagle David R
- [N8154T](https://openairdocs.org/deregistered/N8154T-2018-01-09.md): Let BLANIK L-13 · S/N 026736 · Cancelled Jan 9, 2018 · Registration expired, pending cancellation · Built 1976 · Finger Lakes Soaring Club Inc
- [N14AS](https://openairdocs.org/deregistered/N14AS-2018-01-02.md): Let BLANIK L-13 · S/N 027061 · Cancelled Jan 2, 2018 · Registration expired, pending cancellation · Built 1978 · Finger Lakes Soaring Club Inc
- [N530FH](https://openairdocs.org/deregistered/N530FH-2012-08-14.md): Fairchild Hiller FH-1100 · S/N 30 · Cancelled Aug 14, 2012 · Revoked, canceled · Built 1967 · Robert C Robards Enterprises
- [N3643C](https://openairdocs.org/deregistered/N3643C-2001-04-11.md): Raven Industries RALLY RX7 · S/N RX7-3254 · Cancelled Apr 11, 2001 · Triennial form not returned · Smith Jo Ellen
- [N3503C](https://openairdocs.org/deregistered/N3503C-1974-02-13.md): Cessna 170B · S/N 26546 · Cancelled Feb 13, 1974 · Exported to Canada · Built 1955 · Baust John G
- [N2737Z](https://openairdocs.org/deregistered/N2737Z-1970-06-08.md): Schweizer SGU 2-22E · S/N 184 · Cancelled Jun 8, 1970 · Exported to Canada · Dansville Soaring Club Inc
- [N4214H](https://openairdocs.org/deregistered/N4214H-1970-04-29.md): Piper PA-14 · S/N 14-17 · Cancelled Apr 29, 1970 · Exported to Canada · Genesee Aviation Inc
- [N32719](https://openairdocs.org/deregistered/N32719-1954-08-16.md): Piper J3L-65 · S/N 5553 · Cancelled Aug 16, 1954 · Built 1940 · Dansville Flying Service Inc
- [N74114](https://openairdocs.org/deregistered/N74114-1949-02-08.md): Dansaire D-1 · S/N 1 · Cancelled Feb 8, 1949 · Dansaire Corp
- [N30718](https://openairdocs.org/deregistered/N30718-1943-05-10.md): Piper J3C-65 · S/N 5061 · Cancelled May 10, 1943 · Built 1940 · Danville Flying Service Inc
- [N13574](https://openairdocs.org/deregistered/N13574-1943-04-15.md): Waco UIC · S/N 3830 · Cancelled Apr 15, 1943 · Built 1933 · Dansville Flying Service Inc
- [N2007](https://openairdocs.org/deregistered/N2007-1936-04-15.md): Day Charles Healey A · S/N 1 · Cancelled Apr 15, 1936 · Built 1931 · Day Charles Healy
- [N872Y](https://openairdocs.org/deregistered/N872Y-1933-06-17.md): Albert D/Hamsher J/Ott L PRIMARY GLIDER · S/N 1 · Cancelled Jun 17, 1933 · Built 1930 · Albert Dan

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

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