OpenAirDocs.org
Effingham, IL

Registered aircraft · 41

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

N106MWDJI AGRAS T40 · S/N 64TBL1J002007AGreen Creek Drone Company LLCN106VWDJI AGRAS T40 · S/N 64TBL1X002008PGreen Creek Drone Company LLCN106YWDJI AGRAS T40 · S/N 64TBL1X002008XGreen Creek Drone Company LLCN106ZTDJI AGRAS T40 · S/N 64TBL1X002007AGreen Creek Drone Company LLCN121JTPiper PA-32R-301 · S/N 3246231Built 2005 · Effingham Eta LLCN1678JPiper PA-28-140 · S/N 28-24079Built 1967 · Cloudhoppers IncN169XXLively Richard A SONEX · S/N 992Built 2008 · Mason Benny FN17DNGiles F D RV4 · S/N 935Built 1999 · Mason Benny FN18345Taylorcraft A · S/N 78Built 1937 · Baker Lowell TN19SRDJI PHANTOM 2 · S/N PH645433751Effingham County Emergency Management AgencyN240JJPilatus PC-24 · S/N 150Built 2019 · Hg Air 1 LLCN250PQDJI AGRAS T40 · S/N 64TBK780010069Quadworx Drone Services LLCN252NADJI AGRAS T40 · S/N 64TBL4A0020073Green Creek Drone Company LLCN2819LIrwin Wayne R THORP T-18 · S/N 1116Mason Timothy FN29654Taylorcraft BC12-65 · S/N 2542Built 1941 · Baker Lowell TN303GCDJI AGRAS T40 · S/N 64TBL190020065Green Creek Drone Company LLCN394WGEa Vision EA J100 · S/N EAVUAV502485308Green Creek Drone Co LLCN403GCTalos Drones T60X · S/N 78KBN1L00A01F1Green Creek Drone Co LLCN4166Talos Drones T60X · S/N 78KBN1L00A01GGGreen Creek Drone Co LLCN44330Interplane USA SKYBOY · S/N 40/2001Niemann James JN471XBarkley Dale E ONEX · S/N ONX 0147Built 2015 · Mason Benny FN4752JTalos Drones TALOS T60X · S/N 78KBN1L00A016RGreen Creek Drone Company LLCN482VADJI AGRAS T50 · S/N 63YBM3N002004JA&P Drone Services LLCN4844GTalos Drones T60X · S/N 78KBN1L00A01FKGreen Creek Drone Company LLCN500FWPiper PA-28-181 · S/N 28-7990431Built 1979 · Wohltman Valerie A TrusteeN5249GDJI AGRAS T100 · S/N ASHCN7G001044EGreen Creek Drone Company LLCN544AGDJI AGRAS T40 · S/N 64TBL1V00200FMGreen Creek Drone Co LLCN547GCDJI AGRAS T40 · S/N 64TBK7H00100LQGreen Creek Drone Company LLCN5583JPiper PA-32-260 · S/N 32-1043Built 1968 · 5150 Ventures LLCN5894LAmerican AA-5 · S/N AA5-0094Built 1972 · Trueblood Terry LN618BVans RV-12 · S/N 120464Built 2014 · Bahrns Phyllis AlyeneN621HDDassault FALCON 2000EX · S/N 747Built 2019 · Xls Aviation LLCN62401Talos Drones T60X · S/N 78KWN6A00A5BH7Green Creek Drone Co LLCN7192FJames M Alsop SONERAI II · S/N 042413-1248Built 2015 · Mason Benny FN739KKatz Jerry L CHALLENGER II · S/N CH2 0190001RPBuilt 2006 · Katz Jerry LN8026TBeech A36 · S/N E-2701Built 1992 · Rdz Aircraft LLCN8178LCessna 172H · S/N 17256378Built 1967 · Malone Traci L MN8505GNorman C Y SMITH DSA1 · S/N THA01Built 1982 · Bailey JohnN868BBahrns Stanley D RV-7A · S/N 71067Built 2007 · Bahrns Phyllis AlyeneN9729CPiper PA-32-300 · S/N 32-7840115Built 1978 · Effingham Eta LLCN999CLPiper PA-28-180 · S/N 28-5829Built 1970 · Collette Dean R
Back to Effingham, IL