OpenAirDocs.org
West Chicago, IL

Registered aircraft · 38

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 = 'WEST 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.

N1256PCessna 208B · S/N 208B0564Built 1996 · Planemasters LtdN190PMBeech 1900C · S/N UB66Built 1986 · Planemasters LtdN191CZBeech 1900C · S/N UB-59Built 1986 · Planemasters LtdN193CZBeech 1900C · S/N UC-73Built 1989 · Planemasters LtdN201UJMooney M20J · S/N 24-0389Built 1977 · 787 P&G 201 LLCN2122MCessna 172S · S/N 172S10442Built 2007 · Halsted Aviation LLCN21UGulfstream Aerospace GV-SP (G550) · S/N 5379Given To Fly Holdings LLCN274PMCessna 208B · S/N 208B0705First renewal noticeBuilt 1998 · Planemasters LtdN279PMCessna 208B · S/N 208B0623Built 1997 · Planemasters LtdN281PMCessna 208B · S/N 208B-0902Planemasters LtdN282PMCessna 208B · S/N 208B0981Built 2002 · Planemasters LtdN283PMCessna 208B · S/N 208B0774Built 1999 · Planemasters LtdN286PMCessna 208B · S/N 208B0631Built 1997 · Planemasters LtdN290PMBeech 1900C · S/N UB71Built 1987 · Planemasters LtdN309TTGulfstream Aerospace GVI (G650ER) · S/N 6012Built 2012 · T-Bird Aviation LLCN311JEPiper PA-23-250 · S/N 27-7754053Jps Aviation LLCN3274JCessna 150G · S/N 15065974Built 1966 · Ogrady John ThomasN3324WPiper PA-32-260 · S/N 32-158Built 1965 · Thompson Mark DN390PMBeech 1900C · S/N UC-110Built 1990 · Planemasters LtdN43DLSchempp-Hirth VENTUS-B · S/N 103Cornelis Reindert Van De KlippeN4402RCessna 172M · S/N 17263152Built 1974 · Avel Aircraft IncN500DRBeech A45 · S/N G-31Built 1954 · Fox 2 IncN508DKCirrus Design SR22 · S/N 0309Built 2002 · Travel Express Aviation LLCN6125FCessna 210H · S/N 21059025Built 1968 · Parker Richard AN6985JPiper PA-34-200T · S/N 34-7670309Built 1976 · Avel Aircraft IncN704LBIai GULFSTREAM G280 · S/N 2197Built 2019 · Rhcp 280 LLCN720PMBeech B-60 · S/N P-449Built 1977 · Peter J Messina & Associates LtdN731JPRaytheon 58 · S/N TH-2064Parker Aviation LLCN8059RPiper PA-28-181 · S/N 28-8290081Built 1981 · Travel Express Aviation LLCN808APAirborne Windsports PTY EDGE XT-912-L · S/N XT-912-0592Built 2020 · Meyers Ronald JN8346SPiper PA-28-181 · S/N 28-8190182Built 1981 · Travel Express Aviation LLCN853LBCirrus Design SR20 · S/N 1449Built 2004 · Chicago Aviation Services LLCN8979VCessna 172M · S/N 17264335Built 1974 · Avel Aircraft IncN9098GPiper PA-28-161 · S/N 28-8616024Built 1985 · Travel Express Aviation LLCN924KWIsrael Aircraft Industries GULFSTREAM 200 · S/N 168Built 2007 · Apd Aero LLCN928MSmith Michael N KITFOX SER 5 · S/N S96070186Built 1996 · Smith Michael NN94316Ercoupe 415-C · S/N 1539Built 1946 · Nowicki John WN96BDBeech 58 · S/N TH457Built 1974 · Roberts Aircraft Inc
Back to West Chicago, IL