OpenAirDocs.org
Columbia, MO

Registered aircraft · 164

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

N103ADDJI AGRAS T100 · S/N 1581F8ZLC259T002MG98American Drone Network LLCN103GLPiper PA-31-325 · S/N 31-7912023Built 1978 · Naylor Aviation LLCN104ADDJI AGRAS T100 · S/N 1581F8ZLC25B6002K9C5American Drone Network LLCN11680Bellanca 8KCAB · S/N 21-72Built 1972 · Adams JonathanN117ADDJI AGRAS T100 · S/N 1581F8ZLC25B4002E2NPAmerican Drone Network LLCN121ADDJI AGRAS T100 · S/N 1581F8ZLC25AB002JTX8American Drone Network LLCN123CCMooney M20J · S/N 24-0138Built 1977 · Columbia Mooney LLCN124ADDJI AGRAS T100 · S/N 1581F8ZLC25AD0022M08American Drone Network LLCN1252DCessna 551 · S/N 551-0476Built 1983 · Aeroelite Aviation LLCN125ADDJI AGRAS T100 · S/N 1581F8ZLC25AU002V44XAmerican Drone Network LLCN137ADDJI AGRAS T100 · S/N 1581F8ZLC25AU002D8KNAmerican Drone Network LLCN1439FCessna 172H · S/N 17254934Built 1966 · Hallock Lloyd EN147ADDJI AGRAS T100 · S/N 1581F8ZLC25B3002LV64American Drone Network LLCN150STS.O.C.A.T.A. RALLYE 150 ST · S/N 2996Built 1977 · Miles Donald CN152ADDJI AGRAS T100 · S/N 1581F8ZLC25AC0023169American Drone Network LLCN157ADDJI AGRAS T100 · S/N 1581F8ZLC25B6002ECPQAmerican Drone Network LLCN16MNRaytheon G36 · S/N E3658Little Dixie Construction Co LLCN1713KLuscombe 8E · S/N 4440Registration pendingN177AXAeromot AMT-200S · S/N 200.177Built 2010 · Xim LLCN186DMTextron B200GT · S/N BY-357Built 2019 · Ess Power LLCN18950Beech C24R · S/N MC-535Built 1977 · Osgood James GN190EZArbc Inc DBA Lindstrand 90A · S/N 5568Built 2014 · Taylor Brian GN1971CCirrus Design SR22T · S/N 10363Built 2024 · Andrews Aviation LLCN1978YMooney M20E · S/N 265Built 1964 · Meinert Matthew AN2011GSirgo Joseph R AQUILLA · S/N 33-466-15Built 2001 · Gortmaker Mark FN2130MPiper J3C-85 · S/N 20916Built 1946 · Miles DonaldN24HRRoss Herbert E CHRISTEN EAGLE-II · S/N ROSS-0001Built 1981 · Campbell LanceN2805QCessna 172L · S/N 17259805Built 1971 · A L Hollandsworth LLCN28LTTextron 525C · S/N 525C0403Built 2023 · Falcon Cou LLCN3109BArbc Inc DBA Lindstrand 77A · S/N 5613Built 2016 · Aerial Advantage IncN3116CPiper PA-32R-301 · S/N 3246233Northfork Aviation LLCN3124ZHead Balloons AX9-118 · S/N 483Aerial Advantage IncN3134FPiper PA46R-350T · S/N 4692183Built 2012 · Signature Aviation Group LLCN314CWTextron 560XL · S/N 560-6504Built 2025 · R & B Aviation LLCN3163BCessna 170B · S/N 25405Built 1952 · Lewis Blake CN3281KBeech 58 · S/N TH-1006Built 1979 · Wallace Architects LLCN32889Balloon Works FIREFLY 7-15 · S/N F71008Built 1997 · Columbia Air Sports IncN331TCCessna 414 · S/N 414-0943On Trend Homes LLCN36QMBeech A36 · S/N E-1553Built 1979 · Flight Solutions LLCN3720WBalloon Works FIREFLY 7 · S/N F7-302Built 1986 · Gibbs Dennis GN375FCTextron B200GT · S/N BY-310Built 2018 · Endless Horizons LLCN3862PCessna P210N · S/N P21000065Brown Travis TrusteeN3925FCessna 172 · S/N 36825Built 1958 · Doles Joseph EN39MZRaytheon B300 · S/N FL-277Built 2000 · Tiger Takeoff LLCN402ADTalos Drones T60X · S/N 2104F7EZW2567001GR40American Drone Network LLCN406NTravel Air D-4000 · S/N 1337Dickerson Harman CN4219TPiper PA-32-300 · S/N 32-7240037Built 1971 · 19t LLCN424CMTextron 525C · S/N 525C0330Built 2020 · Falcon Cou LLCN427SERaytheon C90GT · S/N LJ-1797Ess Power LLCN431WPiper PA-28R-200 · S/N 28R-35277Built 1969 · Rettenmaier Kim J
Back to Columbia, MO