OpenAirDocs.org
Elgin, 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 = 'ELGIN'
  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.

N123TAAshcraft Todd DR107 · S/N 001/199Ashcraft Todd WN1269ZBeech 95-55 · S/N TC-85Built 1961 · Childs Lowell RN1529LBeech F33A · S/N CE-1771Built 1994 · Saso Martin P IIIN221NJPiper J3C-65 · S/N 10403Built 1943 · Kowall Stephen JN25147Luscombe 8A · S/N 1071Built 1939 · Prairie Aero LLCN28832Ryan Aeronautical ST3KR · S/N 1007Built 1941 · Kresmery Marc GN29624Taylorcraft BC-65 · S/N 2466Built 1940 · Zielinski MattN3036ZPiper PA-22-160 · S/N 22-6990Built 1959 · Abell Alan RN31WGlobe GC-1B · S/N 408Built 1946 · Abell Alan RN325HPSimmons Noel D VAN'S RV-10 · S/N 40091Built 2005 · Kresmery MarcN3709TPiper PA-28R-180 · S/N 28R-30013Built 1967 · Judice Eric MN3828FPowrachute PEGASUS · S/N A187PEGBuilt 2003 · Miller Robert GN39JACirrus Design SR20 · S/N 8880Built 2022 · Msd Express IncN42LSRolladen-Schneider LS 7 · S/N 7082Ls7 LLCN46544Taylorcraft L-2M · S/N L5960Built 1944 · Beaudette Andre PN4680LCessna 172G · S/N 17254675Built 1966 · Wasilowski Steven PN47439Fairchild M-62A · S/N 5233AERegistration revokedBuilt 1943 · Welch RaymondN551GMEmbraer Executive EMB-505 · S/N 50500939Built 2026 · Mcgrath Air LLCN57559Mooney M20J · S/N 24-1462Built 1984 · N57559 LLCN599PGSensefly EBEE · S/N EB-03-942Hampton Lenzini And Renwick IncN61DRRausch Dean PULSAR XP · S/N 309Built 1995 · Rausch Dean WN6345CPiper PA-28R-201 · S/N 28R-7837158Built 1978 · Krajewski Jerry JN6562BMooney M20A · S/N 1232Built 1958 · Prairie Aero LLCN7215DPiper PA-22-150 · S/N 22-5039Built 1957 · Schmidt Wilfred L IIIN72307Cessna 140 · S/N 9484Dreamco Design LLCN74411Bellanca 14-13-2 · S/N 1524Schmidt Wilfred LN77767Globe GC-1B · S/N 1120Abell Alan RN789RBeech S35 · S/N D-7777Built 1965 · Domeracki Douglas PN7990HPiper PA-12 · S/N 12-898Abell Alan RN86238Enstrom F-28F · S/N 737Built 1985 · Crawford Thomas PN8636KCessna 340A · S/N 340A0562Built 1978 · M & J General Contractors IncN8638PPiper PA-24-260 · S/N 24-4079Built 1965 · Bartell John BN865MBCirrus Design SR22T · S/N 0655Built 2013 · Plasmatreat Trans IncN8962MScott David A PITTS S1S · S/N 001Built 2010 · Ashcraft Todd WN916HCHoward T Curran SLING HW · S/N 054GKTimberline Aviation LLCN9231JPiper PA-28-180 · S/N 28-3302Built 1966 · Leetz TomN9839ESchweizer SGS 1-26C · S/N 270Built 1965 · Walenda RichardN9880HPiper J5C · S/N 51434Built 1943 · Abell Alan R
Back to Elgin, IL