# Registered aircraft: Streator, IL

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

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

- [N1550E](https://openairdocs.org/aircraft/N1550E.md): Cessna 172N · S/N 17271043 · Built 1978 · Wilts George W
- [N22NA](https://openairdocs.org/aircraft/N22NA.md): North American T-6G · S/N 49-3222 · Built 1946 · Rothrock Cara
- [N2391P](https://openairdocs.org/aircraft/N2391P.md): Piper PA-22-150 · S/N 22-2782 · Built 1955 · Oberholtzer Robert H
- [N2485T](https://openairdocs.org/aircraft/N2485T.md): Navion NAVION G · S/N NAV-4-2485 · Built 1962 · Rothrock Virgil N
- [N32753](https://openairdocs.org/aircraft/N32753.md): Piper J3C-65 · S/N 5588 · Built 1940 · Wilts George W
- [N33538](https://openairdocs.org/aircraft/N33538.md): Piper J3C-65 · S/N 2366A · Built 1945 · Rothrock Cara
- [N38971](https://openairdocs.org/aircraft/N38971.md): Boeing A75N1(PT17) · S/N 75-4343 · Rothrock Cara J
- [N4135F](https://openairdocs.org/aircraft/N4135F.md): Cameron Balloons US N-105 · S/N 5710 · Rothrock Virgil N Jr
- [N43JC](https://openairdocs.org/aircraft/N43JC.md): Coonan James COONAN-GLASTAR · S/N 5338 · Coonan James Alexander
- [N4558N](https://openairdocs.org/aircraft/N4558N.md): Boeing A75 · S/N 75-8457 · Rothrock Cara
- [N4866V](https://openairdocs.org/aircraft/N4866V.md): Boeing E75 · S/N 75-5490 · Built 1949 · Rothrock Cara J
- [N49411](https://openairdocs.org/aircraft/N49411.md): Boeing A75N1(PT17) · S/N 75-554 · Built 1941 · Rothrock Cara J
- [N5034X](https://openairdocs.org/aircraft/N5034X.md): Croston Edward L RANS S6ES · S/N 06051668 · Built 2005 · Skroblus Todd
- [N51676](https://openairdocs.org/aircraft/N51676.md): Boeing E75 · S/N 75-2696 · Rothrock Cara J
- [N52212](https://openairdocs.org/aircraft/N52212.md): Boeing A75N1(PT17) · S/N 754229 · Built 1942 · Rothrock Cara J
- [N554RE](https://openairdocs.org/aircraft/N554RE.md): DJI T50 · S/N 1581F6BUB248U001X8R5 · Ejo Aerial Services LLC
- [N55639](https://openairdocs.org/aircraft/N55639.md): Boeing A75L3 · S/N 75-2106 · Rothrock Cara J
- [N55982](https://openairdocs.org/aircraft/N55982.md): Boeing A75N1(PT17) · S/N 75-110 · Rothrock Cara J
- [N59879](https://openairdocs.org/aircraft/N59879.md): Boeing A75L3 · S/N 75-1149 · Rothrock Cara J
- [N7505T](https://openairdocs.org/aircraft/N7505T.md): Cameron Balloons US N-77 · S/N 5766 · Built 1991 · Rothrock Virgil N Jr
- [N78594](https://openairdocs.org/aircraft/N78594.md): Piper PA-12 · S/N 12-3975 · Pyne James L
- [N83208](https://openairdocs.org/aircraft/N83208.md): Piper PA-28-161 · S/N 28-8116124 · Rothrock Cara J
- [N9015H](https://openairdocs.org/aircraft/N9015H.md): Boeing E75 · S/N 75-4958 · Rothrock Cara J
- [N9030H](https://openairdocs.org/aircraft/N9030H.md): Boeing B75N1 · S/N 757905 · Built 1941 · Rothrock Cara J
- [N9040H](https://openairdocs.org/aircraft/N9040H.md): Boeing B75N1 · S/N 75-6905 · Rothrock Cara J
- [N9053H](https://openairdocs.org/aircraft/N9053H.md): Boeing E75 · S/N 75-5192 · Rothrock Cara J
- [N994AC](https://openairdocs.org/aircraft/N994AC.md): Coonan James A JA30 SUPERSTOL · S/N JA395-07-14 · Built 2019 · Coonan James A

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

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