OpenAirDocs.org
Belleville, IL

Registered aircraft · 39

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

N133HEDJI AGRAS T40 · S/N 64TBK8H00100A9Eckerts IncN1421Hugh J Stoops RANS S-21 · S/N 09180014Stoops Hugh JN1432TPiper PA-28-180 · S/N 28-7205296Built 1972 · Smith DavidN17474Waco YKS-7 · S/N 4613Built 1937 · Harter Mark SN191DSGrumman American Avn. AA-5B · S/N AA5B-0363Blackston Robert LN201GRMooney M20J · S/N 24-0222Bischoff Roy H IIIN2031CLawrence William E CHRISTEN EAGLE II · S/N LAWRENCE0001Built 1988 · Shahen Michael A IIIN20784Piper PA-28-181 · S/N 28-7990025Built 1978 · Dbab LLCN20AXCessna 177RG · S/N 177RG1160Hehmann Richard JN2162Stits Skycoupe SA7D · S/N P546Built 1973 · Brammer Randall DN22YTKindig Richard SONEX · S/N 304Sneddon James DN2711DCessna 170B · S/N 25253Built 1952 · Spinner James CN2996HErcoupe 415-C · S/N 3621Built 1946 · Westlund Steven GN37256Cessna 310R · S/N 310R0977Built 1977 · Patriot Air IncN383SEDJI AGRAS T40 · S/N 64TBL2100200TCEckerts IncN45DDHornbeck Jourdan D VAN RV6/A · S/N 60302Built 2002 · Hart Ronald AN494RVKnapp R/Poole D RV-4 · S/N 0002Built 2006 · Berthold Myles AN505GLLoeser Gerry SPARROWHAWK · S/N SH20040016KBuilt 2005 · Loeser Gerry AN5160CBeech B35 · S/N D-2445Built 1950 · Collins Robert EN547MPHonda HA-420 · S/N 42000070Built 2017 · Cbga LLCN5794NPiper J3C-65 · S/N 13243Built 1945 · Renner David CN6052KCessna 150M · S/N 15077496Built 1975 · Collins Robert EN6084MCessna 152 · S/N 15284615Built 1980 · Grider Charles H IIIN6220SHanson Phillip E CHALLENGER II · S/N PH 1997Built 1998 · Phipps David MN6435UMooney M20C · S/N 2182Built 1962 · Stein Charles HN678RJDavis James CHALLENGER II · S/N CH2-1099-1914Acker William EN7229ACessna 172 · S/N 29329Sale reportedBuilt 1956N7449VMooney M20F · S/N 22-1226Built 1975 · Starns Rod JN799PCorrigan Peter H RV6A · S/N 001Built 2000 · Corrigan Michael LN80350Cessna 172M · S/N 17266541Built 1976 · Lobstein Michael RN82316Aeronca 7AC · S/N 7AC-946Built 1946 · Harter Mark SN8401UCessna 172F · S/N 17252301Built 1964 · Morales Jerardo SN876AHCirrus Design SR22T · S/N 9135Built 2023 · Mja Sr22t LLCN87EVErcoupe 415-C · S/N 958Built 1946 · Illinois Ercoupe Flyers LLCN913ENKeen Benjamin J RV-9 · S/N 90900Keen Benjamin JN9233VMooney M20F · S/N 690063Built 1969 · Renner David C JrN9369SBeech B24R · S/N MC-363Built 1975 · Lindauer Curt C IIIN976PMiller Jeffrey L PITTS S1S · S/N 97601Built 2003 · Shahen Michael A IIIN9867QCessna 172M · S/N 17265811Built 1975 · Johnson Barney
Back to Belleville, IL