OpenAirDocs.org
Joliet, IL

Registered aircraft · 32

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

N11283Cessna 150L · S/N 15075297Built 1973 · J F Aviation IncN112KVKaitis Keye V PITTS 12 · S/N 005Kaitis Keye VN1161JAero Commander 112 · S/N 161Built 1974 · Mnd Services LLCN14KVKaitis Keye V HIGHLANDER · S/N 006Built 2021 · Kaitis Keye VN164BRMcnamara Brent R RANS S-6ES · S/N 07001381ESBuilt 2011 · Cummings KevinN169DMAviat PITTS S-2B · S/N 5330Built 1995 · Most Toys Wins LLCN2545PPiper PA-22-150 · S/N 22-2908Built 1955 · Matter Steven SN284BMSchempp-Hirth VENTUS B/16.6 · S/N 226Built 1984 · Sielicki TomaszN3031RCessna 310D · S/N 39115Built 1960 · Search GordonN305PJMooney M20K · S/N 25-1020Built 1986 · Bradley Alana JN329JFCessna 172M · S/N 17265835Built 1975 · J F Aviation IncN3336WPiper PA-32-260 · S/N 32-173Built 1965 · Buck BrothersN3646FNorth American AT-6F · S/N 112071Built 1947 · Brothers BuckN3875KTemco GC-1B · S/N 3575Built 1948 · Lemke BrianN38TETurbinegroup TURBINE · S/N TB-1Turbine Group LLCN40650Maule M-4-220C · S/N 2166CBuilt 1973 · Palmer Paul WN4174DPiper PA-34-220T · S/N 3449178Built 2000 · B L Duke IncN4318FParadrome PPG BARNEY · S/N 0001Built 2001 · Para Drome Ppg IncN509WTNorth American T-28B · S/N 138292Built 1955 · Positive Rate IncN5719KBeech S35 · S/N D-7517Built 1964 · Johns RickyN57MSBoily Gilles WAGGERO-SUPER CUBY · S/N GB-2Built 1999 · Streitz MarkN630MRSchilf R F/Allen-Schilf M K KITFOX IV 1200 · S/N 1768Built 1992 · Kitfox LLCN6517DCessna 172N · S/N 17272839Slaboszewski Donald W JrN65DKArv10 RV-10 · S/N 40305Arv10 LLCN683GGrumman TBM-3E · S/N 53768Built 1943 · Buck Thomas DBAN735ELCessna 182Q · S/N 18265365Built 1977 · Brown Aaron PN765BFVans RV8 · S/N 80212Built 2006 · 4 For Fun IncN7722XCessna 172B · S/N 17248222Built 1960 · Leasure Everett DN77GVBeech S35 · S/N D-7693Built 1964 · Bon Vol LtdN8034LCameron Balloons US C-100 · S/N 6294Bridon BalloonsN80389Cessna 172M · S/N 17266565Built 1976 · J F Aviation IncN815MSMark Streitz LOCKWOOD AIRCAM · S/N AC-201Built 2024 · Streitz Mark
Back to Joliet, IL