OpenAirDocs.org
Centralia, IL

Registered aircraft · 36

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 = 'CENTRALIA'
  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.

N10922Cessna 150L · S/N 15075136Built 1973 · Van Horne Robert EN1102MCessna 172L · S/N 17259492Built 1970 · Els Dennis JN132PLPavel Samuel R SONEX · S/N 0001Built 2003 · Stover Brennan DN172MSCessna 172M · S/N 17263928Built 1974 · Airgo IncN2012ECessna 172N · S/N 17271117Built 1978 · Airgo IncN2204XPiper PA-44-180 · S/N 44-7995281Built 1979 · Airgo IncN229JMArbc Inc DBA Lindstrand 90A · S/N 5463Smith Eric MN2314ECessna 172N · S/N 17271230Built 1978 · Airgo IncN23744Air Tractor AT-400 · S/N 400A-0429Built 1982 · Van Horne Robert EN251JBChampion 7GCAA · S/N 21Built 1965 · Van Horne Robert EN3082ECessna 172N · S/N 17271435Built 1978 · Airgo IncN3181PNational Ballooning 858 · S/N 169Built 2010 · Smith Eric MN341KTSchmitt Robert J-6 KARATOO · S/N 6532Built 1987 · Stover Brennan DN45247Cessna 150M · S/N 15076804Built 1975 · Airgo IncN47KWPiper PA-34-200T · S/N 34-7970230Airgo IncN4859GCessna 172N · S/N 17273406Built 1979 · Airgo IncN49ATPiper PA-44-180T · S/N 44-8107041Built 1981 · Airgo IncN5243BAerostar International RXS-8 · S/N RXS8-3128Built 2004 · Markus Gregory AN5344DCessna 172N · S/N 17272532Built 1979 · Airgo IncN5381QCessna 150L · S/N 15073281Built 1972 · Airgo IncN6424KCessna 150M · S/N 15077698Built 1975 · Airgo IncN66739Cessna 150M · S/N 15076243Built 1974 · Airgo IncN704JRCessna 150M · S/N 15078652Built 1976 · Airgo IncN714FFCessna 150M · S/N 15079137Built 1976 · Airgo IncN714MZCessna 150M · S/N 15079293Built 1977 · Airgo IncN7171BAerostar International RX 8 · S/N RX8-3272Sale reportedN733WSCessna 172N · S/N 17268612Built 1977 · Airgo IncN750QTDennis W Shaw ZENITH CH-750 · S/N 7893Built 2012 · Shaw Dennis WN7539UCessna 150M · S/N 15077735Airgo IncN82549Piper PA-44-180T · S/N 44-8107015Airgo IncorporatedN9315BCessna 175 · S/N 55115Built 1958 · Van Horne Robert EN9347UCessna 150M · S/N 15078296Built 1976 · Airgo IncN9494UCessna 150M · S/N 15078442Built 1976 · Airgo IncN9626BCessna 172RG · S/N 172RG0927Built 1981 · Airgo IncN9767PPiper PA-25-260 · S/N 25-7556039Built 1974 · Vanhorne Robert EN99141Cessna 172P · S/N 17276409Built 1985 · Airgo Inc
Back to Centralia, IL