# Registered aircraft: Amsterdam, NY

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

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

- [N1081D](https://openairdocs.org/aircraft/N1081D.md): Cessna 190 · S/N 7693 · Built 1951 · Milton William H
- [N119H](https://openairdocs.org/aircraft/N119H.md): North American F-51D · S/N 44-73275 · Built 1944 · Mmc Inc
- [N12JT](https://openairdocs.org/aircraft/N12JT.md): Cessna 150L · S/N 15073955 · Built 1972 · Hines Thomas J
- [N2116C](https://openairdocs.org/aircraft/N2116C.md): Cessna 195B · S/N 16101 · Milton William W
- [N2140C](https://openairdocs.org/aircraft/N2140C.md): Cessna 195B · S/N 16125 · Milton William H
- [N234MD](https://openairdocs.org/aircraft/N234MD.md): Beech T34 MENTOR · S/N 58-12093 · Built 1958 · Murphy David F
- [N27PJ](https://openairdocs.org/aircraft/N27PJ.md): Aviat A-1A · S/N 1401 · Built 1998 · Hines Thomas J
- [N300DV](https://openairdocs.org/aircraft/N300DV.md): Glaser Dirks DG 300 · S/N 3E-55 · Built 1984 · Bosov Gregory
- [N32HU](https://openairdocs.org/aircraft/N32HU.md): Aviat A-1A · S/N 1402 · Mdc Aviation Corp Inc
- [N335SR](https://openairdocs.org/aircraft/N335SR.md): Brunet Raymond A CHALLENGER II · S/N CH2-0106-CW-2715 · Built 2009 · Visco Anthony L
- [N34307](https://openairdocs.org/aircraft/N34307.md): Meyers OTW-160 · S/N 51 · Built 1941 · Trek Aviation LLC
- [N404G](https://openairdocs.org/aircraft/N404G.md): Cessna 560 · S/N 560-0095 · Built 1991 · Cushing Stone Company Inc
- [N4280Q](https://openairdocs.org/aircraft/N4280Q.md): Cessna A185F · S/N 18502230 · Built 1973 · Hines Thomas J
- [N4310N](https://openairdocs.org/aircraft/N4310N.md): Cessna 195 · S/N 7100 · Built 1948 · Milton William H
- [N43RQ](https://openairdocs.org/aircraft/N43RQ.md): Beech F33A · S/N CE-716 · Built 1977 · Christman George Myron
- [N4420C](https://openairdocs.org/aircraft/N4420C.md): Cessna 195B · S/N 16005 · Built 1952 · Milton William H
- [N4434E](https://openairdocs.org/aircraft/N4434E.md): Aeronca 7DC · S/N 7DC-68 · Built 1948 · Hines Thomas J
- [N4700X](https://openairdocs.org/aircraft/N4700X.md): Cessna 150G · S/N 15064750 · Built 1966 · Cerasia Steven S
- [N47GR](https://openairdocs.org/aircraft/N47GR.md): Bell 47G-3B-1 · S/N 3423 · Built 1974 · Murphy Airport Inc
- [N51509](https://openairdocs.org/aircraft/N51509.md): Piper J3C-65 · S/N 10080 · Built 1943 · Murphy Airport Inc
- [N51ML](https://openairdocs.org/aircraft/N51ML.md): Raytheon A36 · S/N E-3105 · Built 1997 · Trek Aviation LLC
- [N540KY](https://openairdocs.org/aircraft/N540KY.md): Lewis Norman RV-8 · S/N 80560 · First renewal notice · Built 2001 · Anikin Aviation Inc
- [N664U](https://openairdocs.org/aircraft/N664U.md): Grumman G-164 · S/N 400 · Built 1966 · Murphy Airport Inc
- [N7211C](https://openairdocs.org/aircraft/N7211C.md): North American AT-6D · S/N 42-85142 · Murphy Airport Inc
- [N72851](https://openairdocs.org/aircraft/N72851.md): Cessna 120 · S/N 10038 · Built 1946 · Milton William H
- [N91BM](https://openairdocs.org/aircraft/N91BM.md): Fleet FLEET 16B · S/N 1037 · Milton William H
- [N93834](https://openairdocs.org/aircraft/N93834.md): Ercoupe 415-C · S/N 1157 · Built 1946 · Logerfo Richard
- [N9795T](https://openairdocs.org/aircraft/N9795T.md): Cessna 172A · S/N 47595 · White Cap Aviation LLC

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

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