# Registered aircraft: Latham, NY

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

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

- [N123EE](https://openairdocs.org/aircraft/N123EE.md): Glaser Dirks DG 300 · S/N 3E-54 · Built 1984 · Maverick Aviation LLC
- [N13SP](https://openairdocs.org/aircraft/N13SP.md): Cessna 172H · S/N 17256431 · Built 1967 · New York State Police
- [N19WR](https://openairdocs.org/aircraft/N19WR.md): Fairchild M-62A · S/N 9504AE · Mitchells & Mosquitos LLC
- [N200NY](https://openairdocs.org/aircraft/N200NY.md): Beech C-12C · S/N BC-25 · Built 1976 · New York State Police
- [N319AP](https://openairdocs.org/aircraft/N319AP.md): North American AT-6D · S/N 8815598 · Built 1943 · N319ap LLC
- [N34453](https://openairdocs.org/aircraft/N34453.md): Cessna 177B · S/N 17701814 · Porcaro James
- [N35SD](https://openairdocs.org/aircraft/N35SD.md): Cirrus Design SR20 · S/N 9937 · Built 2024 · N35sd LLC
- [N388LG](https://openairdocs.org/aircraft/N388LG.md): Pilatus PC-12/47E · S/N 2388 · Built 2024 · Lgav8 LLC
- [N3940M](https://openairdocs.org/aircraft/N3940M.md): Piper PA-28-161 · S/N 28-7816388 · Built 1978 · Condair Flyers Inc
- [N4200B](https://openairdocs.org/aircraft/N4200B.md): Piper PA-28-181 · S/N 2843319 · Built 2000 · Condair Flyers Inc
- [N430SP](https://openairdocs.org/aircraft/N430SP.md): Airbus Helicopters MBB-BK117 D-3 · S/N 21314 · Built 2025 · State Of New York
- [N444WE](https://openairdocs.org/aircraft/N444WE.md): Raytheon A36 · S/N E-3579 · Built 2004 · Liberty Steaks LLC
- [N518VA](https://openairdocs.org/aircraft/N518VA.md): Cirrus Design SR22 · S/N 11169 · Built 2026 · N518va LLC
- [N518VV](https://openairdocs.org/aircraft/N518VV.md): Cirrus Design SR20 · S/N 11174 · Built 2026 · N518vv LLC
- [N60DJ](https://openairdocs.org/aircraft/N60DJ.md): Canadian Car & Foundry HARVARD MK IV · S/N CCF-4-264 · Built 1952 · N60dj
- [N651SP](https://openairdocs.org/aircraft/N651SP.md): Cessna U206G · S/N U20606996 · Built 1986 · New York State Police
- [N65620](https://openairdocs.org/aircraft/N65620.md): Cessna 172P · S/N 17275787 · Built 1982 · Condair Flyers Inc
- [N67HP](https://openairdocs.org/aircraft/N67HP.md): Goodyear FG1D · S/N 92095 · Built 1945 · N67hp LLC
- [N749SP](https://openairdocs.org/aircraft/N749SP.md): Cessna U206G · S/N U20606957 · Built 1986 · New York State Police
- [N756VH](https://openairdocs.org/aircraft/N756VH.md): Cessna R182 · S/N R18201165 · Built 1979 · Condair Flyers Inc
- [N761NY](https://openairdocs.org/aircraft/N761NY.md): Sikorsky S-76D · S/N 761021 · Built 2013 · New York State Police
- [N7922C](https://openairdocs.org/aircraft/N7922C.md): Cessna 182Q · S/N 18266633 · Built 1978 · Kemmax Holdings LLC
- [N7946C](https://openairdocs.org/aircraft/N7946C.md): North American B-25N · S/N 44-28938 · Built 1944 · Proair Holding Company LLC
- [N854GW](https://openairdocs.org/aircraft/N854GW.md): Cessna 172S · S/N 172S8854 · Built 2001 · Condair Flyers Inc
- [N948SP](https://openairdocs.org/aircraft/N948SP.md): Kodiak KODIAK 100 · S/N 100-0360 · Built 2025 · State Of New York
- [N9570A](https://openairdocs.org/aircraft/N9570A.md): Cessna 182S · S/N 18280286 · Built 1998 · Upper Fifteen Inc
- [N9584Z](https://openairdocs.org/aircraft/N9584Z.md): Grumman TBM-3E · S/N 85882 · Built 1945 · N9584z LLC
- [N9594C](https://openairdocs.org/aircraft/N9594C.md): Piper PA-28R-201 · S/N 28R-7837209 · Built 1978 · Passino Nicholas J
- [N959SP](https://openairdocs.org/aircraft/N959SP.md): Kodiak KODIAK 100 · S/N 100-0359 · Built 2025 · State Of New York
- [N961DA](https://openairdocs.org/aircraft/N961DA.md): Piper PA-28-181 · S/N 2843034 · Built 1996 · Condair Flyers Inc
- [N988SP](https://openairdocs.org/aircraft/N988SP.md): Kodiak KODIAK 100 · S/N 100-0362 · Built 2025 · State Of New York
- [N9SP](https://openairdocs.org/aircraft/N9SP.md): Airbus Helicopters MBB-BK117 D-3 · S/N 21301 · Built 2025 · State Of New York

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

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