OpenAirDocs.org
Walnut, IL

Registered aircraft · 45

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

N1014LAir Tractor AT-401A · S/N 401A-0733Sale reported, pending cancellationBuilt 1989N109BRobinson Helicopter R44 · S/N 1743Built 2007 · Rotorwing LLCN131MDBeech K35 · S/N D-5978Built 1959 · Woodley Aerial Leasing LLCN1531GAir Tractor AT-402 · S/N 402-0850Built 1992 · Woodley Aerial Leasing LLCN159RPRobinson Helicopter R44 · S/N 0342Built 1997 · Headings Norman DN17260Cessna 150L · S/N 15073696Woodley Aerial Leasing LLCN23416Air Tractor AT-400A · S/N 301-0385Built 1981 · Woodley Aerial Leasing LLCN2602MAir Tractor AT-602 · S/N 602-0645Built 2002 · Woodley Aerial LeasingN279DCDJI AGRAS T40 · S/N 64TBL9C00200G5Allen Nick VN2807ACessna 180 · S/N 30007Built 1953 · Woodley Aerial Leasing LLCN3160XAir Tractor AT-400A · S/N 301-0479Built 1983 · Woodley Aerial Leasing LLCN3650DAir Tractor AT-400A · S/N 302-0240Built 1980 · Woodley Aerial Leasing LLCN3655BAir Tractor AT-400A · S/N 301-0291Built 1980 · Woodley Aerial Leasing LLCN402CSAir Tractor AT-402A · S/N 402A-0816Built 1991 · Woodley Aerial Leasing LLCN41068Air Tractor AT-402B · S/N 402B-1174Woodley Aerial Leasing LLCN411GSAir Tractor AT-602 · S/N 602-0466Built 1998 · Woodley Aerial Leasing LLCN432WAAir Tractor AT-400 · S/N 400-0435Woodley Aerial Leasing LLCN4532FAir Tractor AT-402 · S/N 401-0769Built 1990 · Woodley Aerial Leasing LLCN4539BAir Tractor AT-401 · S/N 401-0763Built 1990 · Woodley Aerial Leasing LLCN4540FAir Tractor AT-402 · S/N 402-0784Built 1990 · Woodley Aerial Leasing LLCN45492Air Tractor AT-401 · S/N 401-0801Built 1991 · Woodley Aerial Leasing LLCN476NHRobinson Helicopter R44 II · S/N 10138Built 2003 · Headings Norman DN502MHAir Tractor AT-502 · S/N 502-0164Built 1992 · Woodley Aerial Leasing LLCN5094HAir Tractor AT-802A · S/N 802A-0067Built 1998 · Woodley Aerial Leasing LLCN5189RAir Tractor AT-602 · S/N 602-0525Built 1998 · Woodley Aerial Leasing LLCN550BHAir Tractor AT-302 · S/N 302-0184Woodley Aerial Leasing LLCN5785BCessna 182 · S/N 33785Built 1956 · Woodley Aerial Leasing LLCN602DNAir Tractor AT-602 · S/N 602-1127Built 2004 · Woodley Aerial Leasing LLCN602TJAir Tractor AT-602 · S/N 602-0446Built 1997 · Woodley Aerial Leasing LLCN6174HAir Tractor AT-402B · S/N 402B-0994Built 1995 · Woodley Aerial Leasing LLCN6905XCessna 175B · S/N 17556903Built 1960 · Woodley Aerial Leasing LLCN692MPAir Tractor AT-502A · S/N 502A-0182Built 1992 · Woodley Aerial Leasing LLCN73085Air Tractor AT-400A · S/N 301-0636Built 1985 · Woodley Aerial Leasing LLCN731GDCessna A188B · S/N 18802877TRegistration pendingBuilt 1977N747GSBellanca 8KCAB · S/N 258-76Built 1976 · Midwest Thermal Optics LLCN76014Cessna 140 · S/N 10408Strader Frank LN7786JRobinson Helicopter R44 · S/N 0521Built 1998 · Headings Norman DN7935KBeech 35-B33 · S/N CD-762Midwest Thermal Optics LLCN801DBBurkey Dale R SONEX ONEX · S/N ONX0197Built 2020 · Burkey Dale RN802QAAir Tractor AT-802A · S/N 802A-0194Built 2004 · Woodley Aerial Leasing LLCN8552VBellanca 7KCAB · S/N 493-75Built 1974 · Burkey DaleN8791SAir Tractor AT-400A · S/N 301-0194Built 1979 · Woodley Aerial Leasing LLCN8907SAir Tractor AT-400A · S/N 301-0230Built 1979 · Woodley Aerial Leasing LLCN9119BAir Tractor AT-802 · S/N 802-0100Built 2000 · Woodley Aerial Leasing LLCN9196CAir Tractor AT-402A · S/N 402A-0937Built 1994 · Woodley Aerial Leasing LLC
Back to Walnut, IL