# Registered aircraft: Painted Post, NY

A list on [Painted Post, NY](https://openairdocs.org/faa-place/NY/Painted%20Post.md).

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

- [N113JG](https://openairdocs.org/aircraft/N113JG.md): Green James H VELOCITY (RG) · S/N DM0113 · Taveniku Mikael
- [N20CU](https://openairdocs.org/aircraft/N20CU.md): Cessna 172RG · S/N 172RG0323 · Built 1980 · Costa Flying Service Inc
- [N29ER](https://openairdocs.org/aircraft/N29ER.md): Cessna 172N · S/N 17269532 · Built 1977 · Costa Air Service LLC
- [N3230Y](https://openairdocs.org/aircraft/N3230Y.md): Cessna 182E · S/N 18254230 · Costa Flying Service Inc
- [N3313Y](https://openairdocs.org/aircraft/N3313Y.md): Cessna 182E · S/N 18254313 · Costa Flying Service Inc
- [N3898M](https://openairdocs.org/aircraft/N3898M.md): Piper PA-12 · S/N 12-2798 · Costa Air Service LLC
- [N4095T](https://openairdocs.org/aircraft/N4095T.md): Westwater Richard G VELOCITY · S/N DM0155 · Taveniku Mikael B
- [N4876F](https://openairdocs.org/aircraft/N4876F.md): Cessna 172N · S/N 17273094 · Built 1979 · Costa Air Service LLC
- [N50898](https://openairdocs.org/aircraft/N50898.md): Cessna 150J · S/N 15069626 · Costa Air Service LLC
- [N555WB](https://openairdocs.org/aircraft/N555WB.md): Cessna 172G · S/N 17253399 · Costa Air Service LLC
- [N607JH](https://openairdocs.org/aircraft/N607JH.md): Vans RV-12 · S/N 120051 · Built 2013 · Hand Mickey James
- [N6545D](https://openairdocs.org/aircraft/N6545D.md): Cessna 172N · S/N 17272856 · Built 1979 · Costa Flying Service Inc
- [N6621D](https://openairdocs.org/aircraft/N6621D.md): Cessna 172N · S/N 17272908 · Built 1979 · Costa Air Service LLC
- [N702MM](https://openairdocs.org/aircraft/N702MM.md): Errington John W MIDGET MUSTANG · S/N M-I-2178 · Built 2007 · Errington John W
- [N739MS](https://openairdocs.org/aircraft/N739MS.md): Cessna 172N · S/N 17270655 · Costa Flying Service Inc
- [N7401E](https://openairdocs.org/aircraft/N7401E.md): Cessna 210 · S/N 57101 · Built 1959 · Costa Air Service LLC
- [N7762F](https://openairdocs.org/aircraft/N7762F.md): Cessna 150F · S/N 15063862 · Costa Air Service LLC
- [N7877F](https://openairdocs.org/aircraft/N7877F.md): Cessna 150F · S/N 15063977 · Built 1966 · Costa Air Service LLC
- [N9116G](https://openairdocs.org/aircraft/N9116G.md): Cessna 182N · S/N 18260656 · First renewal notice · Built 1971 · Jones Brian E
- [N9593R](https://openairdocs.org/aircraft/N9593R.md): Beech M35 · S/N D-6202 · Built 1959 · Ward David C
- [N98923](https://openairdocs.org/aircraft/N98923.md): Cessna 172P · S/N 17276381 · Built 1985 · Costa Flying Service 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 = 'PAINTED POST'
ORDER BY g.n_number
```

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