# Registered aircraft: Potsdam, NY

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

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

- [N121B](https://openairdocs.org/aircraft/N121B.md): Beech E-90 · S/N LW-21 · Built 1972 · Argo Aviation LLC
- [N1408D](https://openairdocs.org/aircraft/N1408D.md): Cessna 170A · S/N 19991 · Built 1951 · Parks James M
- [N1473C](https://openairdocs.org/aircraft/N1473C.md): Piper PA-18 · S/N 18-2677 · Built 1953 · Go Aviation Inc
- [N2439V](https://openairdocs.org/aircraft/N2439V.md): Cessna 140 · S/N 14689 · Lavalley Asset Management Inc
- [N2551X](https://openairdocs.org/aircraft/N2551X.md): Cessna P206 · S/N P206-0051 · Built 1965 · Mcgrath Paul
- [N2938](https://openairdocs.org/aircraft/N2938.md): Robertson SCHREDER HP-11A · S/N 20 · Built 1970 · Robertson Raymond A
- [N323GS](https://openairdocs.org/aircraft/N323GS.md): Bellanca 7GCBC · S/N 416-72 · Built 1972 · Spengler Gregg R
- [N350JC](https://openairdocs.org/aircraft/N350JC.md): Cessna 310R · S/N 310R0606 · Built 1975 · Wear On Earth Aviation LLC
- [N3740F](https://openairdocs.org/aircraft/N3740F.md): Cessna 172H · S/N 17255235 · Built 1966 · Lavalley Asset Management
- [N4019J](https://openairdocs.org/aircraft/N4019J.md): Cessna 150G · S/N 15065319 · Built 1966 · Powell Edward H
- [N561DJ](https://openairdocs.org/aircraft/N561DJ.md): Cirrus Design SR22T · S/N 0871 · Built 2014 · Air Maresca LLC
- [N731GC](https://openairdocs.org/aircraft/N731GC.md): Cessna P210N · S/N P21000457 · Built 1979 · Lavalley Asset Management Inc
- [N733LL](https://openairdocs.org/aircraft/N733LL.md): Cessna 172N · S/N 17268374 · Built 1976 · Lavalley Asset Management Inc
- [N738TX](https://openairdocs.org/aircraft/N738TX.md): Cessna 172N · S/N 17270234 · Built 1978 · Lavalley Asset Management Inc
- [N786YB](https://openairdocs.org/aircraft/N786YB.md): James M Parks 1A · S/N 7322 · Built 2019 · Parks James M
- [N8138S](https://openairdocs.org/aircraft/N8138S.md): Cirrus Design SR22 · S/N 0681 · Built 2003 · Lavalley Asset Management Inc
- [N92953](https://openairdocs.org/aircraft/N92953.md): Commonwealth 185 · S/N 1686 · Built 1946 · Sherman Randy S
- [N98313](https://openairdocs.org/aircraft/N98313.md): Piper J3C-65 · S/N 18475 · Built 1946 · Thomas Kurtis E

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

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