OpenAirDocs.org
Waukegan, IL

Registered aircraft · 21

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

N128WHWarbird Heritage Foundation WHF NIEUPORT 28 · S/N WHF128Warbird Heritage FoundationN172WFCessna 172S · S/N 172S8167Built 1999 · Stick & Rudder Club IncN1845Dassault FALCON 6X · S/N 030Built 2025 · Brunswick CorpN2383FPiper PA-38-112 · S/N 38-79A0411Built 1978 · Laminar Aerospace LLCN454JZDJI AGRAS T40 · S/N 1581F574B235B001031KIntegrated Lakes Management DBAN49WHDouglas/Goessling A4-B · S/N 11366Built 1957 · Warbird Heritage FoundationN50WHGulfstream Aerospace GV-SP (G550) · S/N 5589Built 2019 · White Wing Holdings LLCN519ERCessna 172S · S/N 172S9107Built 2002 · Stick & Rudder Club IncN5232KCessna 172P · S/N 17274024Built 1980 · Stick & Rudder Club IncN5597BCessna 182 · S/N 33597Built 1956 · Bucher Burton WN6116CCessna 310R · S/N 310R1283Built 1978 · Waukegan Flyers LLCN632CStinson 108-3 · S/N 108-3632Pearson Greg WN677RHCessna 305A · S/N 22677Warbird Heritage Foundation IncN7291JPiper PA-28-140 · S/N 28-24643Built 1968 · Centerline Equipment CorpN73753Cessna 172N · S/N 17267652Built 1976 · Stick And Rudder Club IncN7378RBeech F33A · S/N CE-516Built 1974 · Larson Aviation LLCN748REDassault FALCON 2000EX · S/N 708Built 2013 · Hawk Air LLCN900LCDassault MYSTERE FALCON 900 · S/N 186Built 2000 · Mid Central Leasing LLCN919WTDassault MYSTERE-FALCON 50 · S/N 313Built 2001 · Air Waukegan LLCN9584VCessna 172M · S/N 17264386Built 1974 · Stick & Rudder Club IncN97VACessna 172S · S/N 172S9906Built 2005 · Camps Bay Aviation LLC
Back to Waukegan, IL