# Registered aircraft: Williamsville, NY

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

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

- [N1006W](https://openairdocs.org/aircraft/N1006W.md): Mooney M20J · S/N 24-1069 · Built 1980 · Fadem Justin Andrew
- [N10357](https://openairdocs.org/aircraft/N10357.md): Schweizer SGU 2-22CK · S/N 85 · Built 1960 · Niagara Soaring Club
- [N142JH](https://openairdocs.org/aircraft/N142JH.md): Deloach Harry RV-10 · S/N 40454 · Built 2008 · Paroaria LLC
- [N2390Y](https://openairdocs.org/aircraft/N2390Y.md): Aeronca 7BCM · S/N 7BCM-477 · Strong James R
- [N2441W](https://openairdocs.org/aircraft/N2441W.md): Schweizer SGS 2-33 · S/N 9 · Built 1967 · Niagara Soaring Club Inc
- [N300WZ](https://openairdocs.org/aircraft/N300WZ.md): Robinson Helicopter R44 II · S/N 11622 · Built 2007 · Nicholas Christopher
- [N41927](https://openairdocs.org/aircraft/N41927.md): Piper PA-28-151 · S/N 28-7415360 · Built 1974 · Budziejko David C
- [N4549R](https://openairdocs.org/aircraft/N4549R.md): Piper PA-28-140 · S/N 28-21255 · Built 1965 · Hamburg Airport 1 LLC
- [N4KC](https://openairdocs.org/aircraft/N4KC.md): Schweizer SGS 1-26C · S/N 295 · Built 1965 · Niagara Soaring Club
- [N520CT](https://openairdocs.org/aircraft/N520CT.md): Cirrus Design SR22T · S/N 0924 · Built 2014 · 85 Galileo Aviation LLC
- [N815B](https://openairdocs.org/aircraft/N815B.md): Luscombe 8F · S/N 6745 · Built 1950 · Strong James R
- [N8510H](https://openairdocs.org/aircraft/N8510H.md): North American NAVION · S/N NAV-4-510 · Built 1947 · Wobschall Eric D DBA Buffalo Skyline
- [N8548L](https://openairdocs.org/aircraft/N8548L.md): Piper PA-25-235 · S/N 25-4968 · Built 1969 · Niagara Soaring Club Inc
- [N8677R](https://openairdocs.org/aircraft/N8677R.md): Schweizer SGS 1-26B · S/N 211 · Built 1963 · Niagara Soaring Club Inc
- [N9109Z](https://openairdocs.org/aircraft/N9109Z.md): Piper PA-28-236 · S/N 2811002 · Built 1986 · O'Neill Erik M
- [N9617C](https://openairdocs.org/aircraft/N9617C.md): Piper PA-32RT-300 · S/N 32R-7885060 · Built 1978 · Pete And Pete Sales Inc
- [N99LB](https://openairdocs.org/aircraft/N99LB.md): Piper PA-24 · S/N 24-2265 · Built 1960 · Volz Laura M Trustee

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

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