OpenAirDocs.org
Columbia, IL

Registered aircraft · 22

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

N1002MCessna 172L · S/N 17259402Built 1970 · Schuler Mark EN123ACCessna 172D · S/N 17249624Built 1962 · Aerocareers NfpN142LCPacific Aviation Composites US LC 40-550FG · S/N 40003Built 1998 · Aerocareers NfpN250ALEmbraer Executive EMB-505 · S/N 50500595Built 2021 · Trs Transportation IncN257CCCape Copters M16 TANDEM TRAINER · S/N 16224054Registration pendingBuilt 2023N28650Grumman American Avn. AA-5B · S/N AA5B0723Built 1978 · Loseka Tiger LLCN2908EAeronca 7AC · S/N 7AC-6491Built 1946 · Bane Alan DN36600Aeronca 65-CA · S/N C-16991Built 1941 · Johnson Anthony LN3809BBeech F35 · S/N D-4072Built 1955 · N3809b LLCN413EMMooney M20R · S/N 29-0388Built 2005 · 413em LLCN4336QRans S-6ES COYOTE II · S/N 09021455Built 2002 · Schlemmer Aaron WN4760RSackman Randal D SACKMAN SPECIAL · S/N 003Built 2003 · Sackman Randal DN525CTCessna 525A · S/N 525A0397Built 2008 · Heartland Companies IncN5504RCessna 172F · S/N 17253075Built 1965 · Aerocareers NfpN581JJabiru USA Sport J250-SP · S/N 326Built 2006 · Loos GaryN610BMBuckeye BREEZE · S/N 16418Built 2004 · Mcdaniel Robert LN66CRRazer Chester RV-6A · S/N 24197Razer Chester RN814BMCessna 172H · S/N 17255216Built 1966 · Mcdaniel Robert LN815BBNanchang China CJ-6A · S/N 2951216Built 1969 · Schuler Mark EN89052Cessna 140 · S/N 8056Built 1946 · Gateway Tailwheel Club LLCN9446LAmerican AA-1A · S/N AA1A-0246Built 1971 · Narzinski DanielN97737Stinson 108 · S/N 108-737Built 1946 · Johnson Anthony L
Back to Columbia, IL