# Registered aircraft: Amherst, NY

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

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

- [N1355A](https://openairdocs.org/aircraft/N1355A.md): Piper PA-18-125 · S/N 18-1179 · Built 1951 · Stanton Fred H
- [N2139J](https://openairdocs.org/aircraft/N2139J.md): Piper PA-28-181 · S/N 28-7990220 · Built 1978 · Hotung Lisa M
- [N223FA](https://openairdocs.org/aircraft/N223FA.md): Sling SLING LSA · S/N 394A · Built 2024 · Niagara Automations And Controls LLC
- [N267HH](https://openairdocs.org/aircraft/N267HH.md): Cirrus Design SR22T · S/N 0878 · Built 2014 · Sankaran Mahesh
- [N327FR](https://openairdocs.org/aircraft/N327FR.md): Yuneec International Q500 4K TYPHOON · S/N YU15211473B04B01 · Federal Robotics LLC
- [N427FR](https://openairdocs.org/aircraft/N427FR.md): DJI INSPIRE 1 · S/N W13DCG10040878 · Federal Robotics LLC
- [N43381](https://openairdocs.org/aircraft/N43381.md): Taylorcraft BC12-D · S/N 7040 · Built 1946 · Smith Eric L
- [N44202](https://openairdocs.org/aircraft/N44202.md): Taylorcraft BC12-D1 · S/N 10002 · Smith Eric L
- [N4895W](https://openairdocs.org/aircraft/N4895W.md): Rockwell International 114 · S/N 14225 · Built 1977 · Taylor Mark W
- [N56386](https://openairdocs.org/aircraft/N56386.md): Mooney M20J · S/N 24-1595 · Airmooney LLC
- [N588ZR](https://openairdocs.org/aircraft/N588ZR.md): DJI PHANTOM 3 PROFESSION · S/N P76DCD22010362 · Rosenthal Stephen W
- [N6045L](https://openairdocs.org/aircraft/N6045L.md): American AA-5 · S/N AA5-0145 · Stoll Russell J
- [N715CH](https://openairdocs.org/aircraft/N715CH.md): Cirrus Design SR22T · S/N 2102 · Built 2020 · Shatkin Todd Ellis
- [N73WR](https://openairdocs.org/aircraft/N73WR.md): Rengert George W RV-4 · S/N 1272 · Built 1997 · Stanton Fred H
- [N80787](https://openairdocs.org/aircraft/N80787.md): Globe GC-1B · S/N 190 · Built 1946 · York Richard Alan
- [N80871](https://openairdocs.org/aircraft/N80871.md): Cessna 172M · S/N 17266783 · Built 1976 · Monnin Aviation LLC
- [N96383](https://openairdocs.org/aircraft/N96383.md): Taylorcraft BC12-D · S/N 8683 · Built 1946 · York Richard A

## 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 = 'AMHERST'
ORDER BY g.n_number
```

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