OpenAirDocs.org
Sterling, IL

Registered aircraft · 19

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

Query with SQL
duckdb -csv -c "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"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

N1366GCapigatti Andrew C SONEX · S/N 0717Built 2008 · Blazquez Angel RN1462JRockwell International 112A · S/N 462Built 1976 · Wilson Donald RN23463Piper J3C-65 · S/N 3198Built 1939 · Colmark Bruce AN298FADJI PHANTOM 4 · S/N 07DJD9HOC11845Advanced Crop Care IncN325HXXag P100 PRO · S/N 82193487X69EPeabudys IncN410BWIorg William C RV-4 · S/N 106Heffelfinger Darin WN44489Blazquez A R/Nudd B C CHALLENGER II · S/N CH II 1097 1676Blazquez Angel RN581KFSchuch Andrew T KITFOX II · S/N 581Built 1992 · Vesel Stewart JN6162LCox Kermit R TUKAN · S/N 001Built 2000 · Cox Kermit RN693LTDJI INSPIRE 1 · S/N W13DCE15030065Advanced Crop Care IncN693MTDJI INSPIRE 1 · S/N W130CG21040024Advanced Cropt Care IncN737GZCessna 172N · S/N 17269419Built 1977 · Sauk Valley Aviation IncN7552ADJI PHANTOM 3 PROFESSION · S/N P76DCG31011587Advanced Crop Care IncN756QADJI PHANTOM 3 PROFESSION · S/N P76DCG30016831Advanced Crop Care IncN803ESDJI PHANTOM 4 · S/N 07DJD9FOC10178Advanced Crop Care IncN803FADJI PHANTOM 4 · S/N 07DJD9FOC10356Advanced Crop Care IncN803HADJI PHANTOM 4 · S/N 07DJD9COC10382Advanced Crop Care IncN98SKKrueger Scott CHALLENGER II · S/N CH2-0298-B-1715Koster DanielN99955Ercoupe 415-C · S/N 2578Built 1946 · Cox Kermit R
Back to Sterling, IL