# Registered aircraft: New Athens, IL

A list on [New Athens, IL](https://openairdocs.org/faa-place/IL/New%20Athens.md).

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

- [N139D](https://openairdocs.org/aircraft/N139D.md): Douglas DC3A · S/N 2165 · Built 1939 · Schaller Lee
- [N14104](https://openairdocs.org/aircraft/N14104.md): North American T-28B · S/N 51-3620 · Schaller Lee W
- [N17261](https://openairdocs.org/aircraft/N17261.md): Taylor J-2 · S/N 927 · Built 1936 · Schaller Lee W
- [N2592S](https://openairdocs.org/aircraft/N2592S.md): Piper PA-18-150 · S/N 18-7909166 · Schaller Lee
- [N2891V](https://openairdocs.org/aircraft/N2891V.md): Cessna 150M · S/N 15076314 · Built 1974 · Schaller Lee
- [N30040](https://openairdocs.org/aircraft/N30040.md): Cessna 177 · S/N 17701043 · Built 1968 · Schaller Neil J
- [N31498](https://openairdocs.org/aircraft/N31498.md): Aeronca 65-TC · S/N 5760T · Built 1940 · Kearns Gary W
- [N34342](https://openairdocs.org/aircraft/N34342.md): Meyers OTW · S/N 87 · Built 1943 · Schaller Lee W
- [N4901M](https://openairdocs.org/aircraft/N4901M.md): Piper PA-11 · S/N 11-422 · Built 1947 · Schaller Lee
- [N5032H](https://openairdocs.org/aircraft/N5032H.md): Infinity 2006 PPC · S/N IPP6-340 · Built 2006 · Hall Donald R
- [N5074N](https://openairdocs.org/aircraft/N5074N.md): Beech D17S · S/N 6680 · Schaller Lee W
- [N51443](https://openairdocs.org/aircraft/N51443.md): Boeing A75N1(PT17) · S/N 75-4434 · Built 1943 · Schaller Lee W
- [N5648N](https://openairdocs.org/aircraft/N5648N.md): Maule M-6-235 · S/N 7434C · Built 1982 · Albert Daniel L
- [N5952P](https://openairdocs.org/aircraft/N5952P.md): Piper PA-24-250 · S/N 24-1043 · Built 1959 · Schau Kenneth
- [N6117](https://openairdocs.org/aircraft/N6117.md): Travel Air Mfg 2000 · S/N 615 · Built 1928 · Schaller Lee W
- [N6203H](https://openairdocs.org/aircraft/N6203H.md): Piper J3C-65 · S/N 19370 · Built 1946 · Schaller Neil J
- [N69176](https://openairdocs.org/aircraft/N69176.md): Boeing B75N1 · S/N 75-6985 · Built 1942 · Schaller Neil J
- [N70016](https://openairdocs.org/aircraft/N70016.md): Aerostar International S-60A · S/N S60A-3196 · Built 1994 · Albert Daniel L
- [N7558F](https://openairdocs.org/aircraft/N7558F.md): Champion 7GCBC · S/N 226-70 · Built 1969 · Schaller Lee
- [N91GK](https://openairdocs.org/aircraft/N91GK.md): Kearns Gary W VANS RV7 · S/N 70184 · Built 2008 · Kearns Gary W
- [N9445C](https://openairdocs.org/aircraft/N9445C.md): Cessna 180 · S/N 31843 · Built 1955 · Schaller Lee W
- [N9857P](https://openairdocs.org/aircraft/N9857P.md): North American/Aero Classics P-51D · S/N 44-84962 · Built 1944 · Schaller Lee W

## 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 = 'IL' AND g.registrant_city = 'NEW ATHENS'
ORDER BY g.n_number
```

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