OpenAirDocs.org
Mattoon, IL

Registered aircraft · 26

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

N164RKRobinson Helicopter R44 II · S/N 11467Built 2006 · Aerinova IncN225PTPiper PA-31T2 · S/N 31T-8166032Built 1981 · Curry Construction IncN23618Air Tractor AT-400 · S/N 400-0402Built 1981 · Aerinova Aerial LLCN2561PSkyranger STOLL SKYRANGER · S/N SKR0701774Built 2007 · Stoll Kerwyn PN28WJCessna 172N · S/N 17270054Built 1978 · Aerinova IncN31065Piper J3L-65 · S/N 5305Rasmussen William J IIIN31731Buckeye BREEZE · S/N 16264Built 2002 · Annis LarryN33772Piper PA-28-180 · S/N 28-7505180Built 1975 · Land Of Lincoln Flying Club IncN339WSCirrus Design SR22T · S/N 0710Built 2014 · Golf Stream Aviation LLCN3689UBeech A36 · S/N E-1733Built 1980 · Leonard Robert EN41411Robinson Helicopter R44 II · S/N 12429Built 2008 · Aerinova IncN482ATAir Tractor AT-402B · S/N 402B-1280Built 2013 · Aerinova Aerial LLCN504ATAir Tractor AT-504 · S/N 504-4054Built 2024 · Aerinova Aerial LLCN582YMDJI AGRAS T30 · S/N 527BJ9A0010051Aerinova Aerial LLCN5969RCessna 172G · S/N 17253638Built 1965 · Frederick Clint AN630ESPiper PA 46-350P · S/N 4636740Built 2019 · Jez Farms LLCN680RKCessna 680 · S/N 680-0547Built 2015 · Midwest Jet Charter IncN6818FCessna 150F · S/N 15063418Built 1966 · Bell Douglas WN68NGolden Eagle CHIEF · S/N 803Rasmussen William J IIIN77512Piper J3C-65 · S/N 22004Rhoads Gary LN802GTRobinson Helicopter R66 · S/N 1034Built 2021 · Midwest Jet Charter IncN8194KPiper PA-32R-301 · S/N 32R-8013095Built 1980 · Lawair LtdN84898Cessna 172K · S/N 17258660Built 1969 · Coles County Airport AuthorityN889LBTextron 525C · S/N 525C0290Built 2019 · Midwest Jet Charter IncN92821Piper PA 46-350P · S/N 4636081Built 1997 · Aerinova IncN99GMPilatus PC-12/47E · S/N 1923Built 2019 · Midwest Jet Charter Inc
Back to Mattoon, IL