OpenAirDocs.org
Joplin, MO

Registered aircraft · 54

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

N114DJJohnson Danny A ACRO SPORT II · S/N 455Built 1994 · Johnson Danny AN11749Cessna 150L · S/N 15075611Built 1974 · Adams Chad RN117LBPowrachute PEGASUS · S/N A026ULSBuilt 2005 · B13 Enterprises LLCN1803ZDJI AGRAS T40 · S/N 64TBL4E002000MDronology Advantage LLCN180JMCessna 180A · S/N 50121Built 1957 · N180jm LLCN1961FCessna 172N · S/N 17273051Built 1979 · Remove B4 Flight LLCN2087NPiper PA-28-161 · S/N 28-7916253Built 1979 · Rls Rental Co DBAN2441KCessna 441 · S/N 441-0053Built 1978 · Carpe Caelum LLCN2498KPowrachute PEGASUS · S/N A 157 PEGBuilt 2003 · George Kevin JN25020Powrachute PEGASUS · S/N A-038 PEGBuilt 2002 · Graves Charles LN284BALet L 33 SOLO · S/N 940312Built 1994 · Amiet Borys JN2893MPiper PA-28-161 · S/N 28-7816321Built 1977 · Rls Rental Co Inc DBAN2955MPiper PA-28-161 · S/N 28-7816326Built 1977 · Rls Rental Co DBAN3023VPowrachute PEGASUS · S/N A268PEGBuilt 2005 · Falkensten Richard F TrusteeN3049RPiper PA-28R-200 · S/N 28R-35603Built 1969 · Rls Rental Co DBAN32340Porterfield CP-55 · S/N 798Light Aircraft Services LcN36887Cessna 414A · S/N 414A0835Built 1982 · Aa Aircraft Adventure LLCN40363Robinson Helicopter R44 · S/N 2108Built 2011 · Raider LLCN4160PPiper PA-23-160 · S/N 23-1645Ogle Richard W JrN441LTCessna 441 · S/N 4410283Built 1981 · Homestead Steaks LLCN4679ACessna 180 · S/N 32276Built 1956 · Flying Bulldogs LLCN47393Piper PA-28-181 · S/N 28-7890065Built 1977 · R L S Rental Co DBAN481DMAmerican Champion 7GCBC · S/N 1307-2001Built 2001 · Edgewood Capital LLCN4824WRockwell International 114 · S/N 14154Built 1976 · Fmp Properties LLCN50064Cessna 150H · S/N 15069046Built 1968 · Graves Charles LN51061Powrachute PEGASUS · S/N A 063 PEGBuilt 2002 · Graham Joseph MN544RSRans Designs S-7LS · S/N 0907482Built 2007 · Rls Rental Co Inc DBAN5498BWinn Michael SKYSTR KITFOX 4-1200 · S/N JCU115Built 1996 · Bentley Michael DN552CADJI AGRAS T50 · S/N 63YBM4H002008BCreation Ag LLCN5755ACessna 172 · S/N 28355Built 1956 · Blue Sky Flyers IncN57CMSmith John D VANS RV-4 · S/N 3775Built 2000 · Fine Finish LLCN59ELLinhart Eugene ZODIAC 601XL · S/N 6-4345First renewal noticeBuilt 2012 · Harper Joseph EN619CDCirrus Design SR22 · S/N 1672Built 2005 · Simpson Walker Aviation LLCN6346WPiper PA-28-140 · S/N 28-20404First renewal noticeBuilt 1964 · Cottrill William M JrN6511WPiper PA-28-140 · S/N 28-20589Winkler FrankN65753Cessna 172P · S/N 17275858Built 1982 · Flying Bulldogs LLCN68CSSocata TB 10 · S/N 988Trojen Properties LLCN7027NPowrachute PEGASUS · S/N A-106 PEGBuilt 2003 · Bryant Bruce EN702HPCessna 182R · S/N 18268167First renewal noticeBuilt 1982 · Joplin Flyers IncN7226DPiper PA-22-160 · S/N 22-5747Adams Andrew VN724KMEvolution REVOLT · S/N 001042Built 2023 · Williams John RN7382JPiper PA-28-140 · S/N 28-24744Minor Air LLCN7446YPiper PA-30 · S/N 30-510Built 1964 · N7446y Aero LLCN767EMMartin Jacob E LANCAIR LEGACY L2K · S/N L2K-287Built 2006 · Goepfert Lease Company LLCN7809NPiper PA-28-180 · S/N 28-5260Built 1968 · Uninsured Justice Enterprises LLCN7833NPiper PA-28-180 · S/N 28-5287Built 1969 · Strait Brian CN8167ABeech A36 · S/N E-2594Built 1991 · Magic Aviation LLCN819WCubcrafters CC11-160 · S/N CC11-00255Built 2013 · Winkler FrankN8400BCessna 150F · S/N 15062500Edwards R DerylN875SHPiper PA46-500TP · S/N 4697174Built 2004 · Jrm Aero LLC
Back to Joplin, MO