# Registered aircraft: Bay Shore, NY

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

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

- [N1561H](https://openairdocs.org/aircraft/N1561H.md): Cessna 177RG · S/N 177RG0735 · Built 1975 · Torpey Richard T
- [N3257F](https://openairdocs.org/aircraft/N3257F.md): Mooney M20E · S/N 670050 · Built 1967 · Brandon M Ten Hoopen
- [N43158](https://openairdocs.org/aircraft/N43158.md): Piper PA-28-151 · S/N 28-7415435 · Built 1974 · N43158 LLC
- [N4317T](https://openairdocs.org/aircraft/N4317T.md): Piper PA-28-181 · S/N 28-8490002 · Built 1983 · Spanku LLC
- [N4487C](https://openairdocs.org/aircraft/N4487C.md): Cessna 195B · S/N 16071 · Built 1953 · Baldeo Kessho I
- [N5241E](https://openairdocs.org/aircraft/N5241E.md): Cessna 172N · S/N 17271792 · Built 1978 · Baldeo Kessho I
- [N53292](https://openairdocs.org/aircraft/N53292.md): Boeing D75N1 · S/N 75-3856 · Built 1942 · Cifelli Michael
- [N5390Q](https://openairdocs.org/aircraft/N5390Q.md): Cessna 150L · S/N 15073290 · Ignarro Jessie
- [N5448U](https://openairdocs.org/aircraft/N5448U.md): Beech 56TC · S/N TG-14 · Built 1967 · Mathews Roy
- [N6605X](https://openairdocs.org/aircraft/N6605X.md): Beech F33A · S/N CE-1016 · Built 1983 · Cifelli Michael A
- [N661KB](https://openairdocs.org/aircraft/N661KB.md): Cessna 210L · S/N 21060292 · Built 1974 · Baldeo Kessho I
- [N67286](https://openairdocs.org/aircraft/N67286.md): Cessna 152 · S/N 15281725 · Built 1978 · Mars Aerospace Inc
- [N729SP](https://openairdocs.org/aircraft/N729SP.md): Cessna 172S · S/N 172S8666 · Built 2000 · Mars Aerospace Inc
- [N76BS](https://openairdocs.org/aircraft/N76BS.md): Mularadelis TEEMIE TWO · S/N 5-10002 · Built 1977 · Mularadelis James B
- [N8625Q](https://openairdocs.org/aircraft/N8625Q.md): Beech 95-B55 (T42A) · S/N TC-779 · First renewal notice · Corona Robert Jr Dr
- [N918PM](https://openairdocs.org/aircraft/N918PM.md): Cessna 172RG · S/N 172RG0602 · Built 1980 · Mathews Roy
- [N9625Q](https://openairdocs.org/aircraft/N9625Q.md): Cessna 172M · S/N 17265709 · Built 1975 · Mars Aerospace Inc
- [N99207](https://openairdocs.org/aircraft/N99207.md): Ercoupe 415-D · S/N 1830 · Built 1946 · Silvagnoli Miguel

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

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