# Registered aircraft: Williamstown, NJ

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

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

- [N135CK](https://openairdocs.org/aircraft/N135CK.md): Cessna 208B · S/N 208B0776 · Built 1999 · Stellar Aviation LLC
- [N1536Y](https://openairdocs.org/aircraft/N1536Y.md): Cessna 172C · S/N 17249236 · Built 1962 · Ck Aviation LLC
- [N1721F](https://openairdocs.org/aircraft/N1721F.md): Cessna 172H · S/N 17255116 · Built 1966 · Centerline Flying Club Inc
- [N1965S](https://openairdocs.org/aircraft/N1965S.md): Beech S35 · S/N D-7653 · Built 1964 · N1965s LLC
- [N2741U](https://openairdocs.org/aircraft/N2741U.md): Cessna 172D · S/N 17250341 · Built 1963 · Nickel Aviation LLC
- [N336P](https://openairdocs.org/aircraft/N336P.md): Piper PA-31T · S/N 31T-7400003 · Built 1974 · N336p LLC
- [N34019](https://openairdocs.org/aircraft/N34019.md): Cessna 177B · S/N 17701599 · Built 1970 · Kortum Ronald L
- [N4992D](https://openairdocs.org/aircraft/N4992D.md): Cessna 182A · S/N 51092 · Built 1958 · Skydive Cross Keys LLC
- [N555KM](https://openairdocs.org/aircraft/N555KM.md): Beech V35 · S/N D-8361 · Built 1966 · Verrill Christopher R
- [N5653W](https://openairdocs.org/aircraft/N5653W.md): Piper PA-28-150 · S/N 28-840 · Built 1962 · Crump William J
- [N5785G](https://openairdocs.org/aircraft/N5785G.md): Cessna 150K · S/N 15071285 · Built 1969 · Brown Colin M
- [N6109H](https://openairdocs.org/aircraft/N6109H.md): Piper J3C-65 · S/N 19269 · Built 1946 · Skydive Cross Keys LLC
- [N6814H](https://openairdocs.org/aircraft/N6814H.md): Cessna 172M · S/N 17265594 · Built 1975 · Uniform Gulf Aviation LLC
- [N76112](https://openairdocs.org/aircraft/N76112.md): Cessna 140 · S/N 10509 · Built 1946 · Fanslau Nathaniel R
- [N780S](https://openairdocs.org/aircraft/N780S.md): Avions Mudry ET Cie CAP 10B · S/N 87 · Built 1978 · N780s LLC
- [N8051N](https://openairdocs.org/aircraft/N8051N.md): Piper PA-28-140 · S/N 28-25298 · Built 1969 · Sapienza Gregory T
- [N910KF](https://openairdocs.org/aircraft/N910KF.md): Ewing G/Boyer J SERIES 5 · S/N S9604-0173 · Built 1997 · Kortum Ronald L
- [N9801C](https://openairdocs.org/aircraft/N9801C.md): North American SNJ-5 · S/N 90-669 · Built 1943 · Mazure John T

## 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 = 'NJ' AND g.registrant_city = 'WILLIAMSTOWN'
ORDER BY g.n_number
```

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