OpenAirDocs.org
Chicago, IL

Registered aircraft · 1,567

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

N12145Embraer EMB-145XR · S/N 145745Built 2003 · United Airlines IncN12157Embraer EMB-145XR · S/N 145787Built 2004 · United Airlines IncN12160Embraer EMB-145XR · S/N 145799Built 2004 · United Airlines IncN12163Embraer EMB-145XR · S/N 14500811Built 2004 · United Airlines IncN12167Embraer EMB-145XR · S/N 14500834Built 2004 · United Airlines IncN12172Embraer EMB-145XR · S/N 14500864Built 2004 · United Airlines IncN12175Embraer EMB-145XR · S/N 14500878Built 2004 · United Airlines IncN12195Embraer EMB-145XR · S/N 14500943Built 2005 · United Airlines IncN12201Embraer EMB-145XR · S/N 14500959Built 2006 · United Airlines IncN12216Boeing 737-824 · S/N 28776Built 1998 · United Airlines IncN12218Boeing 737-824 · S/N 28778Built 1998 · United Airlines IncN12221Boeing 737-824 · S/N 28930Built 1998 · United Airlines IncN12225Boeing 737-824 · S/N 28934Built 1998 · United Airlines IncN12238Boeing 737-824 · S/N 28804Built 1999 · United Airlines IncN1228PBeech A36 · S/N E-2577Built 1990 · Papa Aviation LLCN122UABoeing 747-422 · S/N 29168Built 1999 · United Airlines IncN1252SJeff Soowal JA30 SUPERSTOL · S/N JA343-01-14Built 2015 · Flying Felix One LLCN1256RCameron Balloons US Z-160 · S/N 6423Midwest Ballooning Adventures IncN12754Boeing 737-7V3 · S/N 30464Built 2002 · United Airlines IncN1280ADassault FALCON 900EX · S/N 221Built 2008 · Thrasher Sky LLCN128HMMignet HM 1000 · S/N 128Campbell Donald PN13013Boeing 787-10 · S/N 40931Built 2020 · United Airlines IncN13014Boeing 787-10 · S/N 40940Built 2023 · United Airlines IncN13018Boeing 787-10 · S/N 66987Built 2022 · United Airlines IncN1310CWatson Thomas STEEN SKYBOLT · S/N TW-1Built 1981 · Graupman GeraldN13110Boeing 757-224 · S/N 27300Built 1994 · United Airlines IncN13113Boeing 757-224 · S/N 27555Built 1995 · United Airlines IncN13124Embraer EMB-145XR · S/N 145689Built 2003 · United Airlines IncN13132Embraer EMB-145XR · S/N 145708Built 2003 · United Airlines IncN13133Embraer EMB-145XR · S/N 145712Built 2003 · United Airlines IncN13138Boeing 757-224 · S/N 30351Built 1999 · United Airlines IncN1313WBeech A36 · S/N E-1440Built 1979 · Second Kitchen LLCN13161Embraer EMB-145XR · S/N 14500805Built 2004 · United Airlines IncN13202Embraer EMB-145XR · S/N 14500962Built 2006 · United Airlines IncN13227Boeing 737-824 · S/N 28788Built 1999 · United Airlines IncN133KKCanadair T-33 · S/N T33-556Built 1956 · Whirlpool Services IncN134PGCirrus Design SR20 · S/N 1935Registration pendingBuilt 2008N13716Boeing 737-724 · S/N 28787Built 1998 · United Airlines IncN13718Boeing 737-724 · S/N 28937Built 1999 · United Airlines IncN13720Boeing 737-724 · S/N 28939Built 1999 · United Airlines IncN13750Boeing 737-724 · S/N 28941Built 1999 · United Airlines IncN1380UCessna 172M · S/N 17267051Built 1976 · Sky Clear LLCN138CACessna 550 · S/N 550-0900Built 1999 · Presidio Citation Bravo LLCN13954Boeing 787-9 · S/N 36405Built 2015 · United Airlines IncN1395FRicks Albert W STEEN SKYBOLT · S/N 578 38 8392Moquin ChristopherN13QMAviat A-1C-180 · S/N 3042Herrick EugeneN14001Boeing 787-10 · S/N 40936Built 2018 · United Airlines IncN14011Boeing 787-10 · S/N 40934Built 2019 · United Airlines IncN14016Boeing 787-10 · S/N 66985Built 2022 · United Airlines IncN14019Boeing 787-10 · S/N 66988Built 2022 · United Airlines Inc
Back to Chicago, IL