# Registered aircraft: Freeville, NY

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

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

- [N1026](https://openairdocs.org/aircraft/N1026.md): Stinson SM-8A · S/N 4017 · Built 1930 · Bellamy John Mark
- [N104AW](https://openairdocs.org/aircraft/N104AW.md): Wsk-Pzl Warzawa-Okecie PZL-104 WILGA 80 · S/N CF21940942 · Built 1994 · Bellamy Mark A
- [N10SY](https://openairdocs.org/aircraft/N10SY.md): Maule M-5-235C · S/N 7487C · Bellany Mark A
- [N23095](https://openairdocs.org/aircraft/N23095.md): Air Tractor AT-301 · S/N 301-0356 · Built 1981 · Bellamy Mark A
- [N284JW](https://openairdocs.org/aircraft/N284JW.md): Beech V35B · S/N D-9495 · Built 1973 · Ordway Jepson
- [N31WY](https://openairdocs.org/aircraft/N31WY.md): Aviat A-1C-180 · S/N 3108 · Built 2010 · Bellamy Mark A
- [N3662X](https://openairdocs.org/aircraft/N3662X.md): Aero Commander S2R · S/N 1890R · Built 1974 · Bellamy Mark A
- [N4264J](https://openairdocs.org/aircraft/N4264J.md): Cessna 310R · S/N 310R0201 · Built 1975 · Bellamy Mark A
- [N460Z](https://openairdocs.org/aircraft/N460Z.md): Siai-Marchetti SM 1019 · S/N 029 · Built 1976 · Bellamy John Mark
- [N5625Z](https://openairdocs.org/aircraft/N5625Z.md): Piper PA-22-108 · S/N 22-9437 · Built 1962 · Bellamy John Mark
- [N5644X](https://openairdocs.org/aircraft/N5644X.md): Aero Commander S2R · S/N 1844R · Built 1973 · Bellamy Mark A
- [N5922Z](https://openairdocs.org/aircraft/N5922Z.md): Piper PA-22-108 · S/N 22-9791 · Built 1964 · Bellamy John Mark
- [N81576](https://openairdocs.org/aircraft/N81576.md): Aeronca 7AC · S/N 7AC-195 · Built 1945 · Bellamy John-Mark
- [N83369](https://openairdocs.org/aircraft/N83369.md): Aeronca 7AC · S/N 7AC-2036 · Bellamy John-Mark
- [N8388K](https://openairdocs.org/aircraft/N8388K.md): Grumman Acft ENG Cor-Schweizer G-164B · S/N 679B · Bellamy Mark A
- [N9192C](https://openairdocs.org/aircraft/N9192C.md): Cessna 180 · S/N 31291 · Built 1955 · Bellamy Mark A
- [N9753V](https://openairdocs.org/aircraft/N9753V.md): Cessna 188 · S/N 188-0203 · Built 1966 · Bellamy Mark A
- [N97703](https://openairdocs.org/aircraft/N97703.md): Stinson 108 · S/N 108-703 · Built 1946 · Bellamy John Mark

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

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