OpenAirDocs.org
Columbia, MS

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

N10DGulfstream Aerospace GVII-G600 · S/N 73194Built 2025 · Southern Tire Aviation LLCN147RTAtec V O S ATEC 321 FAETA NG · S/N FNG451024ABuilt 2024 · Cooper Billy PaulN196LVolmer Amphibian VJ22-CL · S/N 196Beets Larry JN20735Cessna 182P · S/N 18261165Built 1972 · Porter H TomN2073GCessna 182A · S/N 51373Built 1958 · Shepard Brothers LLCN221SMCessna 172M · S/N 17267274Built 1976 · Mccain Stephen MN22561Cessna 150H · S/N 15068362Built 1968 · Buckley Holli RN2288QPiper PA-32R-300 · S/N 32R-7780242Built 1977 · Midnight 30 LLCN2533VCessna 177RG · S/N 177RG0605Built 1974 · Hasselvander Brian KN26DTCessna 525 · S/N 525-0814Built 2013 · Mdr Construction IncN318SBellanca 17-31A · S/N 76-32-164Pace Glen MN320JKCessna 320E · S/N 320E0048Built 1966 · Tru-Point Tactical LLCN333WABeech 36 · S/N E-176Built 1969 · Powell JayN3849XBeech A36 · S/N E-1829Built 1981 · Breland Quin HN3938QCessna 172L · S/N 17260038Built 1971 · Green Carl PN3STLearjet 45 · S/N 487Built 2014 · Southern Tire Aviation LLCN41614Piper PA-28-151 · S/N 28-7415294Cartier Edward J JrN433DBPiper PA-31P · S/N 31P-7400228Built 1974 · Barnes Creek Drilling LLCN44048Beets Larry Joe PROTECH PT2 · S/N 1998Built 1998 · Beets Larry JN4475ZPiper PA-18-150 · S/N 18-8825Shepard Brothers LLCN5109ACessna 150J · S/N 15069450Pace Glen MN6455JPiper PA-28-180 · S/N 28-4876Built 1968 · Cartier Edward J JrN6585GCessna 150L · S/N 15072085Built 1970 · Pace Glen MN7275TCessna 172A · S/N 46875Built 1959 · Beets Larry JoeN7331XCessna 150B · S/N 15059431Porter H TomN79318Cessna 172K · S/N 17258043Built 1969 · Pace Glen MN80436Cessna 172M · S/N 17266585Built 1976 · N80436 LLCN869RRCessna 152 · S/N 15283698Built 1979 · Cooper Billy P
Back to Columbia, MS