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.
N17436Boeing 737-9 · S/N 67748N17437Boeing 737-9 · S/N 43491N17438Boeing 737-9 · S/N 67668N17465Boeing 737-9 · S/N 67657N17477Boeing 737-9 · S/N 67669N17485Boeing 737-9 · S/N 67680N17487Boeing 737-9 · S/N 67725N17488Boeing 737-9 · S/N 67678N174GLCirrus Design SR22T · S/N 10740N17550Boeing 737-9 · S/N 64479N17557Boeing 737-9 · S/N 67584N17564Boeing 737-9 · S/N 67188N17565Boeing 737-9 · S/N 67186N17566Boeing 737-9 · S/N 67185N17574Boeing 737-9 · S/N 67608N17719Boeing 737-724 · S/N 28938N17730Boeing 737-724 · S/N 28798N17752Boeing 737-71Q · S/N 29048N17753Boeing 737-7V3 · S/N 30463N177LMNashner Lewis M RV-12IS · S/N 121441N177RZCessna 177RG · S/N 177RG0843N17963Boeing 787-9 · S/N 37812N18112Boeing 757-224 · S/N 27302N18119Boeing 757-224 · S/N 27561N18220Boeing 737-824 · S/N 28929N18223Boeing 737-824 · S/N 28932N18243Boeing 737-824 · S/N 28806N182UABoeing 747-422 · S/N 25279N1873HCessna 310C · S/N 35973N188AHTextron 172S · S/N 172S13467N1902UAirbus A320-232 · S/N 2714N19117Boeing 757-224 · S/N 27559N19130Boeing 757-224 · S/N 28970N19136Boeing 757-224 · S/N 29285N19141Boeing 757-224 · S/N 30354N1914UAirbus A320-232 · S/N 2223N1921ADassault FALCON 900EX · S/N 619N1922QCessna 177RG · S/N 177RG0322N1948HAero Z BUECKER 131 · S/N 238First renewal noticeN194UABoeing 747-422 · S/N 26892N195UABoeing 747-422 · S/N 26899N1960VCessna 120 · S/N 14171N197UABoeing 747-422 · S/N 26901N19951Boeing 787-9 · S/N 36402N19986Boeing 787-9 · S/N 66145N199FGDassault-Breguet FALCON 50 · S/N 231N19PLSchleicher ASW-19 · S/N 19138N1UESmith Silas F B-8M · S/N 107D-461W-C4767N200JCBombardier BD-100-1A10 · S/N 20791N201QMMooney M20J · S/N 24-0339
Back to Chicago, IL