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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N24990Boeing 787-9 · S/N 38276N24993Boeing 787-9 · S/N 38269N25201Boeing 737-824 · S/N 28958N2525AGeorge M Dunn III REV X · S/N X1022N252BBCessna 195A · S/N 7571N252EJCessna 182S · S/N 18280044N2534UBoeing 777-300ER · S/N 62645N253TSTextron 172S · S/N 172S13470N253TXCessna 680 · S/N 680-0253N256AAPiper PA-44-180 · S/N 4496476N25705Boeing 737-724 · S/N 28766N25982Boeing 787-9 · S/N 66139N2606LPiper PA-38-112 · S/N 38-79A0778N26141Embraer EMB-145XR · S/N 145733N26208Boeing 737-824 · S/N 30580N26210Boeing 737-824 · S/N 28770N26215Boeing 737-824 · S/N 28775N26226Boeing 737-824 · S/N 28935N26232Boeing 737-824 · S/N 28942N2639UBoeing 777-300ER · S/N 62650N263ADassault FALCON 7X · S/N 263N2644UBoeing 777-300ER · S/N 63724N2645UBoeing 777-300ER · S/N 64989N26902Boeing 787-8 · S/N 34822N26906Boeing 787-8 · S/N 34829N26909Boeing 787-8 · S/N 34827N26910Boeing 787-8 · S/N 34826N26952Boeing 787-9 · S/N 36403N26960Boeing 787-9 · S/N 36408N26966Boeing 787-9 · S/N 60143N26967Boeing 787-9 · S/N 60144N26970Boeing 787-9 · S/N 60146N26996Boeing 787-9 · S/N 68624N27015Boeing 777-224 · S/N 28678N27152Embraer EMB-145XR · S/N 145759N27190Embraer EMB-145XR · S/N 14500934N27200Embraer EMB-145XR · S/N 14500956N27205Boeing 737-824 · S/N 30577N27213Boeing 737-824 · S/N 28773N27239Boeing 737-824 · S/N 28951N27246Boeing 737-824 · S/N 28956N27267Boeing 737-8 · S/N 67522N27268Boeing 737-8 · S/N 67523N27269Boeing 737-8 · S/N 67524N27270Boeing 737-8 · S/N 67525N27271Boeing 737-8 · S/N 67526N27273Boeing 737-8 · S/N 67528N27274Boeing 737-8 · S/N 67529N27276Boeing 737-8 · S/N 64611N27277Boeing 737-8 · S/N 64612
Back to Chicago, IL