# Registered aircraft: New London, WI

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

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

- [N1472U](https://openairdocs.org/aircraft/N1472U.md): Cessna 172M · S/N 17267139 · Ebben Robert A
- [N2245N](https://openairdocs.org/aircraft/N2245N.md): Hempel-Herrmann/Herrmann David MXII SPRINT · S/N 003 · Built 2015 · Herrmann David R
- [N24372](https://openairdocs.org/aircraft/N24372.md): Piper PA-28-180 · S/N 28-5665 · Built 1970 · Curns James R
- [N26700](https://openairdocs.org/aircraft/N26700.md): Piper J4A · S/N 4-864 · Built 1940 · Harvey Aaron J
- [N28HK](https://openairdocs.org/aircraft/N28HK.md): Terry Short Aircraft Svcs HAWK ARROW II · S/N HK-434-TD · Poppy Wayne J
- [N2936H](https://openairdocs.org/aircraft/N2936H.md): Engineering & Research ERCOUPE 415-C · S/N 3561 · Built 1946 · Heideman Christopher M
- [N41949](https://openairdocs.org/aircraft/N41949.md): Piper PA-28-140 · S/N 28-7425301 · Built 1974 · Ferg Robert B
- [N56JS](https://openairdocs.org/aircraft/N56JS.md): Poppy Wayne J SA 300 STARDUSTER · S/N 1001 · First renewal notice · Poppy Wayne J
- [N5759E](https://openairdocs.org/aircraft/N5759E.md): Cessna 150 · S/N 17259 · Built 1959 · Harrison Gary L
- [N65018](https://openairdocs.org/aircraft/N65018.md): Romenesko James L SKY RANGER · S/N SKR0311403 · Built 2005 · Herrmann David R
- [N6580J](https://openairdocs.org/aircraft/N6580J.md): Piper PA-28-180 · S/N 28-5036 · Built 1968 · Poppy Wayne J
- [N71394](https://openairdocs.org/aircraft/N71394.md): Aerostar International RAVEN S-55A · S/N S55A-3066 · Built 1995 · Korth Brandon C
- [N755SD](https://openairdocs.org/aircraft/N755SD.md): Gallow Daniel A KITFOX CLASSIC IV · S/N C04050295 · Built 2012 · Gallow Daniel A
- [N765PT](https://openairdocs.org/aircraft/N765PT.md): Philip A Thompson GS-2 SPORTSMAN 2+2 · S/N 0007046 · Built 2005 · Thompson Philip A
- [N87MZ](https://openairdocs.org/aircraft/N87MZ.md): Harmening Mike HIGH FLYER · S/N 005923 · Built 1999 · Zabel Mark G
- [N9214S](https://openairdocs.org/aircraft/N9214S.md): Beech C23 · S/N M-1737 · Built 1975 · C&L Aviation LLC
- [N98320](https://openairdocs.org/aircraft/N98320.md): Piper PA-28-140 · S/N 28-26168 · Built 1969 · Flyg5 LLC
- [N99165](https://openairdocs.org/aircraft/N99165.md): Piper J3C-65 · S/N 16741 · Built 1950 · Poppy Wayne J

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

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