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.

N203XDavid R Williams D90 · S/N 3Williams David RN204UABoeing 777-222 · S/N 28713Built 1999 · United Airlines IncN204XDavid R Williams DIHEDRAL 90 · S/N 1Williams David RN205FPGulfstream Aerospace GVII-G500 · S/N 72015Built 2018 · Red Cloud LLCN206FPBombardier BD-100-1A10 · S/N 20220Built 2008 · Seguin Holdings LLCN206UABoeing 777-222 · S/N 30212Built 1999 · United Airlines IncN20904Boeing 787-8 · S/N 34824Built 2012 · United Airlines IncN209UABoeing 777-222 · S/N 30215Built 1999 · United Airlines IncN2107WBeech C23 · S/N M-1437Built 1973 · Iguana Aviation LLCN210UABoeing 777-222 · S/N 30216Built 2000 · United Airlines IncN21102Boeing 787-9 · S/N 68648Built 2026 · United Airlines IncN21108Boeing 757-224 · S/N 27298Built 1994 · United Airlines IncN21129Embraer EMB-145XR · S/N 145703Built 2003 · United Airlines IncN21144Embraer EMB-145XR · S/N 145741Built 2003 · United Airlines IncN21154Embraer EMB-145XR · S/N 145772Built 2003 · United Airlines IncN21197Embraer EMB-145XR · S/N 14500947Built 2006 · United Airlines IncN211UABoeing 777-222 · S/N 30217Built 2000 · United Airlines IncN212UABoeing 777-222 · S/N 30218Built 2000 · United Airlines IncN2135UBoeing 777-300ER · S/N 62646Built 2017 · United Airlines IncN2136UBoeing 777-300ER · S/N 62648Built 2017 · United Airlines IncN2138UBoeing 777-300ER · S/N 62649Built 2017 · United Airlines IncN213EPIsrael Aircraft Industries GALAXY · S/N 052Built 2001 · Jssi Parts LLCN213UABoeing 777-222 · S/N 30219Built 2000 · United Airlines IncN2140UBoeing 777-300ER · S/N 62651Built 2017 · United Airlines IncN2142UBoeing 777-300ER · S/N 63722Built 2017 · United Airlines IncN2147KPiper PA-32-300 · S/N 32-7940020Built 1978 · Agati IncN214UABoeing 777-222 · S/N 30220Built 2000 · United Airlines IncN215UABoeing 777-222 · S/N 30221Built 2000 · United Airlines IncN216PWPiper PA-32R-301T · S/N 3257304Built 2002 · Papa Whiskey LLCN216UABoeing 777-222 · S/N 30549Built 2000 · United Airlines IncN21723Boeing 737-724 · S/N 28790Built 1999 · United Airlines IncN217UABoeing 777-222 · S/N 30550Built 2000 · United Airlines IncN218UABoeing 777-222 · S/N 30222Built 2001 · United Airlines IncN219UABoeing 777-222 · S/N 30551Built 2001 · United Airlines IncN220SLNorth American T-6G · S/N 182-648Built 1951 · Lewis Samuel KN220UABoeing 777-222 · S/N 30223Built 2001 · United Airlines IncN221UABoeing 777-222 · S/N 30552Built 2001 · United Airlines IncN2223AMarchetti Frank AVENGER GYRO PLANE · S/N FM1-2000Built 1978 · Majestic AviaitonN222UABoeing 777-222 · S/N 30553Built 2001 · United Airlines IncN223UABoeing 777-222 · S/N 30224Built 2001 · United Airlines IncN2243UBoeing 777-300ER · S/N 63723Built 2017 · United Airlines IncN2248PPiper PA-23-150 · S/N 23-858Built 1957 · Dobrzynski Andrzej JN224UABoeing 777-222 · S/N 30225Built 2001 · United Airlines IncN2250UBoeing 777-300ER · S/N 66590Built 2019 · United Airlines IncN2251UBoeing 777-300ER · S/N 66591Built 2020 · United Airlines IncN225UABoeing 777-222 · S/N 30554Built 2001 · United Airlines IncN2263QPiper PA-28R-201 · S/N 28R-7737030Built 1977 · Ross Air Chicago LLCN226UABoeing 777-222 · S/N 30226Built 2002 · United Airlines IncN227SKDiamond Aircraft Ind DA 42 NG · S/N 42.N615Built 2026 · Alf Ix LLCN227UABoeing 777-222 · S/N 30555Built 2002 · United Airlines Inc
Back to Chicago, IL