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.

N17436Boeing 737-9 · S/N 67748Built 2026 · United Airlines IncN17437Boeing 737-9 · S/N 43491Built 2026 · United Airlines IncN17438Boeing 737-9 · S/N 67668Built 2026 · United Airlines IncN17465Boeing 737-9 · S/N 67657Built 2026 · United Airlines IncN17477Boeing 737-9 · S/N 67669Built 2026 · United Airlines IncN17485Boeing 737-9 · S/N 67680United Airlines IncN17487Boeing 737-9 · S/N 67725United Airlines IncN17488Boeing 737-9 · S/N 67678United Airlines IncN174GLCirrus Design SR22T · S/N 10740Aviation Services LLCN17550Boeing 737-9 · S/N 64479United Airlines IncN17557Boeing 737-9 · S/N 67584Built 2023 · United Airlines IncN17564Boeing 737-9 · S/N 67188Built 2023 · United Airlines IncN17565Boeing 737-9 · S/N 67186Built 2023 · United Airlines IncN17566Boeing 737-9 · S/N 67185Built 2023 · United Airlines IncN17574Boeing 737-9 · S/N 67608Built 2023 · United Airlines IncN17719Boeing 737-724 · S/N 28938Built 1999 · United Airlines IncN17730Boeing 737-724 · S/N 28798Built 1999 · United Airlines IncN17752Boeing 737-71Q · S/N 29048Built 1999 · United Airlines IncN17753Boeing 737-7V3 · S/N 30463Built 2002 · United Airlines IncN177LMNashner Lewis M RV-12IS · S/N 121441Nashner Lewis MN177RZCessna 177RG · S/N 177RG0843Built 1976 · Cardinal Investigative Alliance LtdN17963Boeing 787-9 · S/N 37812Built 2016 · United Airlines IncN18112Boeing 757-224 · S/N 27302Built 1995 · United Airlines IncN18119Boeing 757-224 · S/N 27561Built 1997 · United Airlines IncN18220Boeing 737-824 · S/N 28929Built 1998 · United Airlines IncN18223Boeing 737-824 · S/N 28932Built 1998 · United Airlines IncN18243Boeing 737-824 · S/N 28806Built 1999 · United Airlines IncN182UABoeing 747-422 · S/N 25279Built 1991 · United Airlines IncN1873HCessna 310C · S/N 35973Built 1952 · Blue Canoe Aviation LLCN188AHTextron 172S · S/N 172S13467Built 2026 · Alf Ix LLCN1902UAirbus A320-232 · S/N 2714Built 2006 · United Airlines IncN19117Boeing 757-224 · S/N 27559Built 1996 · United Airlines IncN19130Boeing 757-224 · S/N 28970Built 1998 · United Airlines IncN19136Boeing 757-224 · S/N 29285Built 1999 · United Airlines IncN19141Boeing 757-224 · S/N 30354Built 2000 · United Airlines IncN1914UAirbus A320-232 · S/N 2223United Airlines IncN1921ADassault FALCON 900EX · S/N 619Built 2008 · Condor Sky LLCN1922QCessna 177RG · S/N 177RG0322Built 1972 · Lendor Jason CN1948HAero Z BUECKER 131 · S/N 238First renewal noticeBuilt 1948 · Meyer William MN194UABoeing 747-422 · S/N 26892Built 1997 · United Airlines IncN195UABoeing 747-422 · S/N 26899Built 1997 · United Airlines IncN1960VCessna 120 · S/N 14171Built 1947 · Krasemann Keith WN197UABoeing 747-422 · S/N 26901Built 1997 · United Airlines IncN19951Boeing 787-9 · S/N 36402Built 2014 · United Airlines IncN19986Boeing 787-9 · S/N 66145Built 2021 · United Airlines IncN199FGDassault-Breguet FALCON 50 · S/N 231Built 1992 · Pops Racer LLCN19PLSchleicher ASW-19 · S/N 19138Built 1977 · Garbacz Christina BN1UESmith Silas F B-8M · S/N 107D-461W-C4767Majestic Aviation IncN200JCBombardier BD-100-1A10 · S/N 20791Built 2019 · Clo Equipment LLCN201QMMooney M20J · S/N 24-0339Built 1977 · Nordica Group Ltd
Back to Chicago, IL