# Registered aircraft: Hamburg, NY

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

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

- [N1743F](https://openairdocs.org/aircraft/N1743F.md): Cessna 172H · S/N 17255138 · Built 1966 · Little Bird Airways LLC
- [N287JS](https://openairdocs.org/aircraft/N287JS.md): Estumkeda Ltd DBA Micco Acft MAC-145A · S/N 307 · Gillman Robert H
- [N291FA](https://openairdocs.org/aircraft/N291FA.md): Powrachute AIRWOLF 912ULS · S/N A447ULS · Built 2024 · Safety Management Training LLC
- [N3063U](https://openairdocs.org/aircraft/N3063U.md): Cessna 172E · S/N 17250663 · Built 1963 · Little Bird Airways LLC
- [N34376](https://openairdocs.org/aircraft/N34376.md): Meyers MAC-145 · S/N 219 · Gillman Robert H
- [N3664W](https://openairdocs.org/aircraft/N3664W.md): Piper PA-32-260 · S/N 32-572 · Built 1966 · Suffoletto Gregory
- [N45595](https://openairdocs.org/aircraft/N45595.md): Luscombe 8A · S/N 2122 · Built 1946 · Gillman Ryan J
- [N5569Z](https://openairdocs.org/aircraft/N5569Z.md): Piper PA-22-108 · S/N 22-9273 · Built 1962 · Levandowski Joseph
- [N5816R](https://openairdocs.org/aircraft/N5816R.md): Cessna 172G · S/N 17253485 · Built 1965 · Little Bird Airways LLC
- [N58698](https://openairdocs.org/aircraft/N58698.md): Consolidated Vultee BT-13A · S/N 5836 · Valiant Air Group LLC
- [N6338A](https://openairdocs.org/aircraft/N6338A.md): Cessna 182 · S/N 33138 · Built 1956 · Little Bird Airways LLC
- [N657DM](https://openairdocs.org/aircraft/N657DM.md): Cessna 560 · S/N 560-0810 · Built 2009 · Hamburg Aero Leasing LLC
- [N7156E](https://openairdocs.org/aircraft/N7156E.md): Cessna 182B · S/N 52156 · Built 1959 · Little Bird Airways LLC
- [N7357F](https://openairdocs.org/aircraft/N7357F.md): Cessna 150G · S/N 15066920 · Little Bird Airways LLC
- [N8140D](https://openairdocs.org/aircraft/N8140D.md): Piper PA-22-160 · S/N 22-5631 · Built 1957 · Mckellar John T
- [N8278W](https://openairdocs.org/aircraft/N8278W.md): Piper PA-28-180 · S/N 28-2434 · Built 1965 · Chamberlain Mark S
- [N8868J](https://openairdocs.org/aircraft/N8868J.md): Piper PA-28-140 · S/N 28-24354 · Built 1968 · Gannon Robert M
- [N9422X](https://openairdocs.org/aircraft/N9422X.md): Cessna 210A · S/N 21057722 · Built 1962 · Little Bird Airways 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 = 'HAMBURG'
ORDER BY g.n_number
```

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