# Registered aircraft: Sterling, IL

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

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

- [N1366G](https://openairdocs.org/aircraft/N1366G.md): Capigatti Andrew C SONEX · S/N 0717 · Built 2008 · Blazquez Angel R
- [N1462J](https://openairdocs.org/aircraft/N1462J.md): Rockwell International 112A · S/N 462 · Built 1976 · Wilson Donald R
- [N23463](https://openairdocs.org/aircraft/N23463.md): Piper J3C-65 · S/N 3198 · Built 1939 · Colmark Bruce A
- [N298FA](https://openairdocs.org/aircraft/N298FA.md): DJI PHANTOM 4 · S/N 07DJD9HOC11845 · Advanced Crop Care Inc
- [N325HX](https://openairdocs.org/aircraft/N325HX.md): Xag P100 PRO · S/N 82193487X69E · Peabudys Inc
- [N410BW](https://openairdocs.org/aircraft/N410BW.md): Iorg William C RV-4 · S/N 106 · Heffelfinger Darin W
- [N44489](https://openairdocs.org/aircraft/N44489.md): Blazquez A R/Nudd B C CHALLENGER II · S/N CH II 1097 1676 · Blazquez Angel R
- [N581KF](https://openairdocs.org/aircraft/N581KF.md): Schuch Andrew T KITFOX II · S/N 581 · Built 1992 · Vesel Stewart J
- [N6162L](https://openairdocs.org/aircraft/N6162L.md): Cox Kermit R TUKAN · S/N 001 · Built 2000 · Cox Kermit R
- [N693LT](https://openairdocs.org/aircraft/N693LT.md): DJI INSPIRE 1 · S/N W13DCE15030065 · Advanced Crop Care Inc
- [N693MT](https://openairdocs.org/aircraft/N693MT.md): DJI INSPIRE 1 · S/N W130CG21040024 · Advanced Cropt Care Inc
- [N737GZ](https://openairdocs.org/aircraft/N737GZ.md): Cessna 172N · S/N 17269419 · Built 1977 · Sauk Valley Aviation Inc
- [N7552A](https://openairdocs.org/aircraft/N7552A.md): DJI PHANTOM 3 PROFESSION · S/N P76DCG31011587 · Advanced Crop Care Inc
- [N756QA](https://openairdocs.org/aircraft/N756QA.md): DJI PHANTOM 3 PROFESSION · S/N P76DCG30016831 · Advanced Crop Care Inc
- [N803ES](https://openairdocs.org/aircraft/N803ES.md): DJI PHANTOM 4 · S/N 07DJD9FOC10178 · Advanced Crop Care Inc
- [N803FA](https://openairdocs.org/aircraft/N803FA.md): DJI PHANTOM 4 · S/N 07DJD9FOC10356 · Advanced Crop Care Inc
- [N803HA](https://openairdocs.org/aircraft/N803HA.md): DJI PHANTOM 4 · S/N 07DJD9COC10382 · Advanced Crop Care Inc
- [N98SK](https://openairdocs.org/aircraft/N98SK.md): Krueger Scott CHALLENGER II · S/N CH2-0298-B-1715 · Koster Daniel
- [N99955](https://openairdocs.org/aircraft/N99955.md): Ercoupe 415-C · S/N 2578 · Built 1946 · Cox Kermit R

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

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