OpenAirDocs.org
Chicago, IL

Registered aircraft · 1,559

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.

N100BMGulfstream Aerospace GIV-X (G450) · S/N 4020Built 2005 · Bateleur Eagle Holdings II LLCN10156Embraer EMB-145XR · S/N 145786Built 2004 · United Airlines IncN1020Aeronca C-2 · S/N A-71Built 1930 · Lewis Samuel KN1098UCessna 172M · S/N 17266847Built 1976 · Kane PatrickN109SBRockwell International NA-265-80 · S/N 380-20Sabre DirectN11106Embraer EMB-145XR · S/N 145650Built 2002 · United Airlines IncN11107Embraer EMB-145XR · S/N 145654Built 2002 · United Airlines IncN11113Embraer EMB-145XR · S/N 145662Built 2002 · United Airlines IncN11119Embraer EMB-145XR · S/N 145677Built 2002 · United Airlines IncN11121Embraer EMB-145XR · S/N 145683Built 2003 · United Airlines IncN11127Embraer EMB-145XR · S/N 145697Built 2003 · United Airlines IncN11140Embraer EMB-145XR · S/N 145732Built 2003 · United Airlines IncN11150Embraer EMB-145XR · S/N 145756Built 2003 · United Airlines IncN11164Embraer EMB-145XR · S/N 14500817Built 2004 · United Airlines IncN11165Embraer EMB-145XR · S/N 14500819Built 2004 · United Airlines IncN11176Embraer EMB-145XR · S/N 14500881Built 2004 · United Airlines IncN11181Embraer EMB-145XR · S/N 14500904Built 2005 · United Airlines IncN11184Embraer EMB-145XR · S/N 14500917Built 2005 · United Airlines IncN11187Embraer EMB-145XR · S/N 14500927Built 2005 · United Airlines IncN11189Embraer EMB-145XR · S/N 14500931Built 2005 · United Airlines IncN11191Embraer EMB-145XR · S/N 14500935Built 2005 · United Airlines IncN11192Embraer EMB-145XR · S/N 14500936Built 2005 · United Airlines IncN11193Embraer EMB-145XR · S/N 14500938Built 2005 · United Airlines IncN11194Embraer EMB-145XR · S/N 14500940Built 2005 · United Airlines IncN11199Embraer EMB-145XR · S/N 14500953Built 2006 · United Airlines IncN111HZDassault FALCON 7X · S/N 137Built 2011 · Skyhigh 7x LLCN111TTCirrus Design SR22 · S/N 0830Built 2004 · Land Of Lincoln Aviators LLCN11206Boeing 737-824 · S/N 30578Built 2000 · United Airlines IncN119PRRisley Philman W RANS S19 · S/N 031300118Built 2015 · Mcmanus RussellN119VEAgusta Aerospace AW119 MKII · S/N 14737Trixie Racer LLCN11PNCirrus Design SR22T · S/N 1445Built 2016 · Ivlje LLCN12003Boeing 787-10 · S/N 40935United Airlines IncN12004Boeing 787-10 · S/N 60139Built 2019 · United Airlines IncN12005Boeing 787-10 · S/N 40937Built 2019 · United Airlines IncN12006Boeing 787-10 · S/N 60140Built 2019 · United Airlines IncN12010Boeing 787-10 · S/N 40926Built 2019 · United Airlines IncN12012Boeing 787-10 · S/N 60145Built 2020 · United Airlines IncN12020Boeing 787-10 · S/N 66989Built 2022 · United Airlines IncN12021Boeing 787-10 · S/N 66990Built 2022 · United Airlines IncN120DRBombardier BD-100-1A10 · S/N 20846Built 2020 · Clo Equipment II LLCN120DSDiamond Aircraft Ind DA 40 · S/N 40.220Built 2002 · Element Aero LLCN120UABoeing 747-422 · S/N 29166Built 1999 · United Airlines IncN12109Boeing 757-224 · S/N 27299Built 1994 · United Airlines IncN12114Boeing 757-224 · S/N 27556Built 1995 · United Airlines IncN12116Boeing 757-224 · S/N 27558Built 1996 · United Airlines IncN12122Embraer EMB-145XR · S/N 145684Built 2003 · Untied Airlines IncN12125Boeing 757-224 · S/N 28967Built 1998 · United Airlines IncN12135Embraer EMB-145XR · S/N 145718Built 2003 · United Airlines IncN12136Embraer EMB-145XR · S/N 145719Built 2003 · United Airlines IncN12142Embraer EMB-145XR · S/N 145735Built 2003 · United Airlines Inc
Back to Chicago, IL