OpenAirDocs.org
Lawrenceville, IL

Registered aircraft · 28

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

N102KSchleicher KA 6 E · S/N 4108Built 1967 · Wabash Valley Soaring Association IncN104NSGrob-Werke TWIN ASTIR · S/N 3043Built 1978 · Wabash Valley Soaring Assn IncN11VEEiriavion PIK 20B · S/N 20150CBuilt 1976 · Klein Flying Service IncN180JHCessna 180 · S/N 31702Built 1955 · Klein Flying ServiceN2066JCessna T188C · S/N T18803356TBuilt 1978 · Klein Flying Service IncN243TDDJI AGRAS T30 · S/N 527BK4N001000MFly Apply LLCN244TDDJI AGRAS T30 · S/N 527BK4Q001007VFly Apply LLCN245TDDJI AGRAS T30 · S/N 527BK6P00100CLFly Apply LLCN252LFDJI T40 · S/N 64TBL63002005GOrlan Drone Service LLCN2SVPiper PA-24 · S/N 24-3428Built 1963 · Piper J DN30729Cessna 177B · S/N 17701428Built 1969 · Thompson William C IIIN311RZDJI AGRAS T30 · S/N 3U5BJ5E00100HXRegistration pending, pending cancellationN32691Piper PA-28-151 · S/N 28-7515218Built 1974 · Mid-American Pilot Association IncN33RBBarrows Robert E BEARHAWK · S/N 195699Built 1999 · Judy Charles EN4007USchleicher K 8 B · S/N 8393Built 1964 · Wabash Valley Soaring Association IncN4042GBell 206A · S/N 242Klein Flying Service IncN6096YAyres S2R-G5 · S/N G5-101Built 1993 · Klein Flying Service IncN6502WPiper PA-28-140 · S/N 28-20579Built 1965 · Mid American Pilot Association IncN6990ZPiper PA-25-235 · S/N 25-2740Built 1964 · Wabash Valley Soaring Association IncN713GBurkhart Grob Flugzeugbau ASTIR CS · S/N 1080Built 1975 · Wabash Valley Soaring Association IncN745LAAir Tractor AT-802A · S/N 802A-0745Built 2018 · Klein Flying Service IncN7745Schleicher AS-K13 · S/N 13084Built 1968 · Wabash Valley Soaring Assn IncN802BKAir Tractor AT-802A · S/N 802A-0892Built 2021 · Klein Flying Service IncN825BKAir Tractor AT-402 · S/N 402-0902Built 1993 · Klein Flying ServiceN8548QCessna A185F · S/N 18503730Built 1978 · Klein Flying Service IncN8740RSchleicher K 8 B · S/N 8189Built 1963 · Wabash Valley Soaring Assoc IncN95601Taylorcraft BC12-D · S/N 7901Built 1946 · Judy Charles EN998DFCirrus Design SR22T · S/N 0650Built 2013 · Thompson William III
Back to Lawrenceville, IL