OpenAirDocs.org
Cahokia, IL

Registered aircraft · 32

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

N10TVBell 206L-3 · S/N 51399Built 1990 · Helicopters IncN11TVBell 206-L4 · S/N 52289Built 2004 · Helicopters IncN12BQBell 206-L4 · S/N 52012Built 1993 · Helicopters IncN1791MCessna T337F · S/N 33701391Built 1971 · A & S Helicopters IncN260MPBell OH-58C · S/N 71-20517A & S Helicopters IncN2684NCessna 120 · S/N 12942Built 1947 · Air & Sea Leasing IncN2895BBell 47J · S/N 1572Built 1957 · A And S Helicopters IncN29SBell 206B · S/N 4378Built 1995 · Helicopters IncN331DYNaval Aircraft Factory N3N-3 · S/N 4411Built 1941 · Yates Daniel AN45972Luscombe 8A · S/N 2499Built 1946 · Schertz Edward JN4CQBell 206-L4 · S/N 52088Built 1994 · Helicopters IncN55SLBell Helicopter Textron Canada 206L-4 · S/N 52347Built 2007 · Helicopters IncN56BLBell 206B · S/N 3502Built 1982 · Helicopters IncN5QPBell 206B · S/N 3457Built 1981 · Helicopters IncN5QVBell 206B · S/N 3098Helicopters IncN62TVBell Helicopter Textron Canada 206L-4 · S/N 52369Built 2008 · Helicopters IncN651FTPiper PA-28-151 · S/N 28-7415369Built 1974 · St Louis Flight Training LLCN69FBell 407 · S/N 53025Built 1996 · Helicopters IncN6QPBell 206-L4 · S/N 52191Helicopters IncN6UXEurocopter AS 350 B3 · S/N 3749Built 2003 · Helicopters IncN757LXCessna 152 · S/N 15279835Built 1977 · St Louis Flight Training LLCN788FTCessna 172F · S/N 17252288Built 1964 · St Louis Flight Training LLCN82FBell 206B-III · S/N 4240Built 1992 · Helicopters IncN8YJBell 206B · S/N 4485Built 1998 · Helicopters IncN90450Robinson Helicopter R22 · S/N 0120Built 1981 · Air & Sea Leasing IncN92NBell 407 · S/N 53093Built 1997 · Helicopters IncN93DDBell 407 · S/N 53030Built 1996 · Helicopters IncN970FTEvektor-Aerotechnik A S HARMONY LSA · S/N 2023 2218Built 2023 · St Louis Flight Training LLCN972FTEvektor-Aerotechnik A S HARMONY LSA · S/N 20232219Built 2023 · St Louis Flight Training LLCN974FTEvektor-Aerotechnik A S HARMONY LSA · S/N 20242221Built 2024 · St Louis Flight Training LLCN975FTEvektor-Aerotechnik A S HARMONY LSA · S/N 20242250Built 2024 · St Louis Flight Training LLCN9BQBell 206-L4 · S/N 52049Built 1993 · Helicopters Inc
Back to Cahokia, IL