# Registered aircraft: Ashville, NY

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

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

- [N1617V](https://openairdocs.org/aircraft/N1617V.md): Cessna 172M · S/N 17263694 · Built 1974 · Cook Timothy D
- [N1983P](https://openairdocs.org/aircraft/N1983P.md): Piper PA-18 · S/N 18-4218 · Built 1955 · Carlson Andrew J
- [N215JM](https://openairdocs.org/aircraft/N215JM.md): Maitland John C CUBBY II · S/N J.M.3 · Built 1997 · Maitland John C
- [N221E](https://openairdocs.org/aircraft/N221E.md): Glasflugel STANDARD LIBELLE · S/N 123 · Built 1970 · Rensel Daniel J
- [N3251Y](https://openairdocs.org/aircraft/N3251Y.md): Cessna 182E · S/N 18254251 · Built 1962 · Carlson Andrew J
- [N3926Z](https://openairdocs.org/aircraft/N3926Z.md): Piper PA-18-150 · S/N 18-7752 · Built 1961 · Carlson Jeffrey D
- [N4359K](https://openairdocs.org/aircraft/N4359K.md): Maitland John C SUPER ACRO I · S/N 219 · Built 1993 · Maitland John C
- [N4886A](https://openairdocs.org/aircraft/N4886A.md): Piper PA-18 · S/N 18-4987 · Built 1956 · Cook Timothy D
- [N5019V](https://openairdocs.org/aircraft/N5019V.md): Aerostar International RXS-8 · S/N RXS8-3119 · Built 2002 · Sky Sail Balloons Inc
- [N501WP](https://openairdocs.org/aircraft/N501WP.md): Piper PA-32R-300 · S/N 32R-7780476 · Built 1977 · True Course Aviation LLC
- [N6120W](https://openairdocs.org/aircraft/N6120W.md): Dart Robert G DART SPECIAL · S/N 2007-2 · Built 2007 · Peterson Steven W
- [N737FN](https://openairdocs.org/aircraft/N737FN.md): Balony Kubicek Spol Sro BB30Z · S/N 1137 · Sky Sail Balloons Inc
- [N7982K](https://openairdocs.org/aircraft/N7982K.md): Piper PA-18A 150 · S/N 18-6565 · Carlson Jeffrey D
- [N81A](https://openairdocs.org/aircraft/N81A.md): Berkshire Mfg. CONCEPT 70 · S/N 10 · Built 1973 · Rensel Daniel
- [N87D](https://openairdocs.org/aircraft/N87D.md): Cessna 172F · S/N 17253345 · Registration pending · Built 1965
- [N9GJ](https://openairdocs.org/aircraft/N9GJ.md): Jones Gary B TEAM MINIMAX 1500R · S/N 604 · Peterson Steven W

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
WHERE g.registrant_state = 'NY' AND g.registrant_city = 'ASHVILLE'
ORDER BY g.n_number
```

This list as a web page: https://openairdocs.org/faa-place/NY/Ashville/aircraft

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.