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.
N203XDavid R Williams D90 · S/N 3N204UABoeing 777-222 · S/N 28713N204XDavid R Williams DIHEDRAL 90 · S/N 1N205FPGulfstream Aerospace GVII-G500 · S/N 72015N206FPBombardier BD-100-1A10 · S/N 20220N206UABoeing 777-222 · S/N 30212N20904Boeing 787-8 · S/N 34824N209UABoeing 777-222 · S/N 30215N2107WBeech C23 · S/N M-1437N210UABoeing 777-222 · S/N 30216N21102Boeing 787-9 · S/N 68648N21108Boeing 757-224 · S/N 27298N21129Embraer EMB-145XR · S/N 145703N21144Embraer EMB-145XR · S/N 145741N21154Embraer EMB-145XR · S/N 145772N21197Embraer EMB-145XR · S/N 14500947N211UABoeing 777-222 · S/N 30217N212UABoeing 777-222 · S/N 30218N2135UBoeing 777-300ER · S/N 62646N2136UBoeing 777-300ER · S/N 62648N2138UBoeing 777-300ER · S/N 62649N213EPIsrael Aircraft Industries GALAXY · S/N 052N213UABoeing 777-222 · S/N 30219N2140UBoeing 777-300ER · S/N 62651N2142UBoeing 777-300ER · S/N 63722N2147KPiper PA-32-300 · S/N 32-7940020N214UABoeing 777-222 · S/N 30220N215UABoeing 777-222 · S/N 30221N216PWPiper PA-32R-301T · S/N 3257304N216UABoeing 777-222 · S/N 30549N21723Boeing 737-724 · S/N 28790N217UABoeing 777-222 · S/N 30550N218UABoeing 777-222 · S/N 30222N219UABoeing 777-222 · S/N 30551N220SLNorth American T-6G · S/N 182-648N220UABoeing 777-222 · S/N 30223N221UABoeing 777-222 · S/N 30552N2223AMarchetti Frank AVENGER GYRO PLANE · S/N FM1-2000N222UABoeing 777-222 · S/N 30553N223UABoeing 777-222 · S/N 30224N2243UBoeing 777-300ER · S/N 63723N2248PPiper PA-23-150 · S/N 23-858N224UABoeing 777-222 · S/N 30225N2250UBoeing 777-300ER · S/N 66590N2251UBoeing 777-300ER · S/N 66591N225UABoeing 777-222 · S/N 30554N2263QPiper PA-28R-201 · S/N 28R-7737030N226UABoeing 777-222 · S/N 30226N227SKDiamond Aircraft Ind DA 42 NG · S/N 42.N615N227UABoeing 777-222 · S/N 30555
Back to Chicago, IL