# Registered aircraft: Gardiner, NY

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

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

- [N123FX](https://openairdocs.org/aircraft/N123FX.md): Dehavilland DHC-6-200 · S/N 200 · Built 1969 · Freefall Express
- [N14LG](https://openairdocs.org/aircraft/N14LG.md): Piper-Green-Lewis J-3 CUBY · S/N 401 · Built 1981 · Richards William
- [N1902M](https://openairdocs.org/aircraft/N1902M.md): Boeing/Mountain View Air Rep A75N1 · S/N 75-1902 · Richards William
- [N2137R](https://openairdocs.org/aircraft/N2137R.md): Cessna 182G · S/N 18255337 · Built 1964 · Freefall Express Inc
- [N2185M](https://openairdocs.org/aircraft/N2185M.md): Pilatus PC-6/B1-H2 · S/N 687 · Built 1968 · Freefall Express
- [N286](https://openairdocs.org/aircraft/N286.md): Cessna 501 · S/N 501-0104 · Built 1979 · Freefall Express Inc
- [N355FF](https://openairdocs.org/aircraft/N355FF.md): Aerospatiale AS 355F1 · S/N 5133 · Built 1982 · Richards William
- [N3818Q](https://openairdocs.org/aircraft/N3818Q.md): Cessna 172L · S/N 17259918 · Built 1972 · Ranch Hand Flying Club Inc
- [N40269](https://openairdocs.org/aircraft/N40269.md): Dehavilland DHC-6-200 · S/N 152 · Built 1968 · Freefall Express Inc
- [N40605](https://openairdocs.org/aircraft/N40605.md): Piper J3C-65 · S/N 7350 · Built 1941 · Richards William
- [N4819K](https://openairdocs.org/aircraft/N4819K.md): Ryan NAVION A · S/N NAV-4-1819 · Built 1949 · Smith Lance O
- [N716NC](https://openairdocs.org/aircraft/N716NC.md): Dehavilland DHC-6 TWIN OTTER · S/N 110 · Built 1968 · Freefall Express Inc
- [N854RM](https://openairdocs.org/aircraft/N854RM.md): Navion NAVION G · S/N NAV-4-2444 · Built 1962 · Wordjuice Inc
- [N8884S](https://openairdocs.org/aircraft/N8884S.md): Cessna 150F · S/N 15062184 · Built 1965 · Mechin Jean-Michel S
- [N92175](https://openairdocs.org/aircraft/N92175.md): Cessna 182N · S/N 18260074 · Built 1969 · Richards Joseph
- [N927N](https://openairdocs.org/aircraft/N927N.md): Cessna 182N · S/N 18260320 · Built 1970 · Blue Sky Business Services Inc

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

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