OpenAirDocs.org
Galesburg, IL

Registered aircraft · 26

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

N1117APearson Arthur E NIEUPORT 11 · S/N 01117Built 2001 · Lillie David WN1385YCessna 172C · S/N 17249085Caracci Sam V JrN195CWCessna 195B · S/N 16174Built 1954 · 3 Birds Aviation LLCN2415VCessna 140 · S/N 14661Built 1948 · Double T LLCN2439JCessna 150G · S/N 15065539Built 1966 · Henderickson Robert TN2568KBalloon Works FIREFLY 7-15 · S/N F7-873I-Review CorpN302CGBeech B200 · S/N BB-1112Kiowa Turbine LLCN406ATGalaxy Balloons GALAXY 7B · S/N GLX-1037BDunn JasonN4320KDernell William BOWERS FLY BABY · S/N 70-9Built 2000 · Baranowski Gary WN444GLLewis Gayle SONERIA II · S/N 759Built 1989 · Lewis Gayle AN52287Boeing B75N1 · S/N 75-1345Built 1941 · Vallero Brenda MN533EVans RV-12 · S/N 120533Built 2012 · Blake James DN579MCessna 550 · S/N 550-1133Built 2006 · Jet Air IncN60681Cessna 150J · S/N 15070496Hendrickson Robert TN6082KCessna 150M · S/N 15077516Built 1975 · Carlton David LN65123Lancair LC-40-550FG · S/N 40077Martin MichaelN681CABeech C90A · S/N LJ-1414Built 1995 · Jet Air IncN70784Balloon Works FIREFLY 7-15 · S/N F7-1085Built 2000 · Saul Greg BN7105KBalloon Works FIREFLY 7 · S/N F5-378Dunn Jason AN76915Cessna 140 · S/N 11357Built 1946 · M R G 2 LLCN7931DBeech C90 · S/N LJ-1049Built 1982 · Jet Air IncN824PMCessna 560XLS · S/N 560-5535Built 2005 · Jet Air IncN9091RBalloon Works FIREFLY 8 · S/N F8-353First renewal noticeBuilt 1990 · Dunn Jason AN91121Cessna 182P · S/N 18261954Built 1973 · Central Illinois Aviators IncN97VSCessna 560XL · S/N 560-5207Built 2001 · Flcr Express LLCN999VBBeech B200 · S/N BB-1506Built 1995 · Jet Air Inc
Back to Galesburg, IL