# Registered aircraft: Seaford, NY

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

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

- [N144JK](https://openairdocs.org/aircraft/N144JK.md): Piper PA-34-220T · S/N 34-8133010 · Built 1981 · Long Island Aviators LLC
- [N2097S](https://openairdocs.org/aircraft/N2097S.md): Cessna 182T · S/N 18281308 · Built 2004 · Long Island Aviators LLC
- [N21394](https://openairdocs.org/aircraft/N21394.md): Cessna 172S · S/N 172S10449 · Built 2007 · Long Island Aviators LLC
- [N21412](https://openairdocs.org/aircraft/N21412.md): Piper PA-28-181 · S/N 28-7990045 · Built 1978 · Long Island Aviators LLC
- [N522JW](https://openairdocs.org/aircraft/N522JW.md): Piper PA-28-181 · S/N 2843461 · Built 2001 · Long Island Aviators LLC
- [N5251R](https://openairdocs.org/aircraft/N5251R.md): Cessna 172M · S/N 17263465 · Long Island Aviators LLC
- [N526ER](https://openairdocs.org/aircraft/N526ER.md): Cessna 172S · S/N 172S9110 · Built 2002 · Long Island Aviators LLC
- [N5416B](https://openairdocs.org/aircraft/N5416B.md): Cessna 152 · S/N 15283867 · Long Island Aviators LLC
- [N587MA](https://openairdocs.org/aircraft/N587MA.md): Piper PA-28-181 · S/N 2843517 · Built 2002 · Long Island Aviators LLC
- [N6059D](https://openairdocs.org/aircraft/N6059D.md): Cessna 172S · S/N 172S10275 · Built 2006 · Long Island Aviators LLC
- [N6372C](https://openairdocs.org/aircraft/N6372C.md): Piper PA-28R-201T · S/N 28R-7803223 · Built 1978 · Fair Skies LLC
- [N65199](https://openairdocs.org/aircraft/N65199.md): Cessna 152 · S/N 15284323 · Built 1980 · Long Island Aviators LLC
- [N723GA](https://openairdocs.org/aircraft/N723GA.md): Grumman American Avn. GA-7 · S/N GA7-0021 · Built 1978 · Long Island Aviators LLC
- [N727AC](https://openairdocs.org/aircraft/N727AC.md): Piper PA-28-181 · S/N 28-7890128 · Built 1977 · Long Island Aviators LLC
- [N733LY](https://openairdocs.org/aircraft/N733LY.md): Cessna 172N · S/N 17268386 · Built 1976 · Long Island Aviators LLC
- [N75270](https://openairdocs.org/aircraft/N75270.md): Piper PA-28-151 · S/N 28-7615277 · Built 1976 · Long Island Aviators LLC
- [N757AD](https://openairdocs.org/aircraft/N757AD.md): Cessna 152 · S/N 15279578 · Built 1977 · Long Island Aviators LLC
- [N769GA](https://openairdocs.org/aircraft/N769GA.md): Grumman American Avn. GA-7 · S/N GA7-0056 · Built 1978 · Long Island Aviators LLC
- [N828Y](https://openairdocs.org/aircraft/N828Y.md): Cessna 172N · S/N 17268168 · Built 1976 · Long Island Aviators LLC
- [N935DE](https://openairdocs.org/aircraft/N935DE.md): Piper PA-28-181 · S/N 28-7990146 · Built 1978 · Long Island Aviators LLC
- [N9410V](https://openairdocs.org/aircraft/N9410V.md): Mooney M20C · S/N 700036 · Built 1969 · Rlangone Inc
- [N99709](https://openairdocs.org/aircraft/N99709.md): Cessna 172P · S/N 17276498 · Built 1985 · Long Island Aviators 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 = 'SEAFORD'
ORDER BY g.n_number
```

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