# Registered aircraft: Roscoe, IL

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

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

- [N10443](https://openairdocs.org/aircraft/N10443.md): Hoff-Corben Baby Ace C · S/N 1 · Stern Jason C
- [N12306](https://openairdocs.org/aircraft/N12306.md): Dart CW-3 · S/N 1 · Stern Jason C
- [N1265C](https://openairdocs.org/aircraft/N1265C.md): Cirrus Design SR20 · S/N 1291 · Built 2003 · Dbg Aviation
- [N172FM](https://openairdocs.org/aircraft/N172FM.md): Cessna 172K · S/N 17258008 · Built 1969 · Stern Jason C
- [N1903P](https://openairdocs.org/aircraft/N1903P.md): Brooks Kenyon D VANS RV-8 · S/N 80411 · Built 2015 · Brooks Kenyon D
- [N190VT](https://openairdocs.org/aircraft/N190VT.md): Cessna 190 · S/N 7171 · Built 1948 · Marshall Rodney E
- [N2037V](https://openairdocs.org/aircraft/N2037V.md): Cessna 120 · S/N 14250 · Built 1947 · Marshall Rodney E
- [N2194Y](https://openairdocs.org/aircraft/N2194Y.md): Piper PA-28RT-201T · S/N 28R-7931149 · Built 1979 · David Shawn M
- [N2638L](https://openairdocs.org/aircraft/N2638L.md): Cessna 172H · S/N 17255838 · Built 1967 · Morgan Todd W
- [N3032X](https://openairdocs.org/aircraft/N3032X.md): Cessna 150F · S/N 15064432 · Built 1966 · Magaruh George M
- [N3825](https://openairdocs.org/aircraft/N3825.md): Robert L Oconnor CORBEN BABY ACE C · S/N 1001 · Built 1972 · Mazeika Mckenzie
- [N5011M](https://openairdocs.org/aircraft/N5011M.md): Taylorcraft BC12-D · S/N 10-311 · Jones Michael S
- [N5035B](https://openairdocs.org/aircraft/N5035B.md): Beech F35 · S/N D-4312 · Bohdan Lebid
- [N507S](https://openairdocs.org/aircraft/N507S.md): Daniel L Syverson CH 750 CRUZER · S/N C75-11271 · Built 2022 · Syverson Daniel L
- [N6225T](https://openairdocs.org/aircraft/N6225T.md): Cessna 150E · S/N 15060925 · Built 1964 · Mohnacky Robert A
- [N6486C](https://openairdocs.org/aircraft/N6486C.md): Piper PA-32RT-300 · S/N 32R-7885029 · Built 1978 · 86 Charlie Corp
- [N65387](https://openairdocs.org/aircraft/N65387.md): Cameron Balloons US Z-77 · S/N 6707 · Built 2013 · Nelson Sarah
- [N7091R](https://openairdocs.org/aircraft/N7091R.md): Harold F L/Fink J W RV-8 · S/N 80784 · Built 2003 · Fink Jeffrey W
- [N82TL](https://openairdocs.org/aircraft/N82TL.md): Cessna 182P · S/N 18263775 · Registration pending, pending cancellation
- [N92166](https://openairdocs.org/aircraft/N92166.md): Piper J3C-65 · S/N 16608 · Built 1946 · Gerdeman Richard F III

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

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