OpenAirDocs.org
Carthage, MO

Registered aircraft · 43

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

N1171RMooney M20J · S/N 24-1320Built 1982 · Hillier Jared ChristianN117JHBaxter James AVID FLYER · S/N AF 586Built 1992 · Sneddon Dale RN1447FCessna 172H · S/N 17254942Built 1966 · Cook David FN1950RSixchuter SR7 · S/N SR7XL-2732Baugh CalebN2059NCessna 140 · S/N 12295Dance Bruce BN208GWTextron B200GT · S/N BY-247Built 2015 · Williams Marketing Services IncN240SMMccabe James L MCPITTS · S/N 1-185Built 1985 · Dance Bruce BN2674EPowrachute PEGASUS · S/N A 164 PEGBuilt 2003 · Baugh CalebN3050ACessna 170B · S/N 25694Built 1953 · Block Harlan TN308GWHawker Beechcraft HAWKER 900XP · S/N HA-0157Built 2010 · Williams Marketing Services IncN318LUDJI AGRAS T20P · S/N 1581F574B237W00100WDDronevantage LLCN34703Rearwin 175 · S/N 1540Built 1941 · Henry Gary PN3502ZPowrachute PEGASUS · S/N A161 PEGBuilt 2003 · Baugh Israel AN372GEBuckeye Industries DREAM MACHINE · S/N 3637Registration pendingBuilt 1997N3826MPiper PA-12 · S/N 12-2568Built 1947 · Baugh CalebN4058UPowrachute AIR WOLF 912 · S/N A073ULSBuilt 2006 · Eliasen Anthony JN419AFPowrachute PEGASUS · S/N A305PEGBuilt 2006 · Lee Gary LN43827Taylorcraft BC12-D · S/N 7486Built 1946 · Cas Aerobatic LLCN441EECessna 441 · S/N 4410083Built 1978 · Alamo Ventures LLCN460DMDJI AGRAS T50 · S/N 63YBM4S002002FErwin Ag And Environmental LLCN46742Cessna 172K · S/N 17257463Built 1968 · Barlet Richard DN4949LPiper PA-28-180 · S/N 28-4318Built 1967 · Lim Young KeunN4998HPiper PA-11 · S/N 11-893Built 1949 · Bartosh Jared FN54941Boeing A75N1(PT17) · S/N 752705Built 1941 · Waller DavidN59770Boeing A75N1(PT17) · S/N 75-2508Templeton Michael LN5KFFrancis Kenneth V COZY · S/N 65Built 1986 · Sneddon Dale RN673DTPiper PA-28-235 · S/N 28-7410038Built 1973 · Air Henry LLCN68WBoeing B75N1 · S/N 75-2587Built 1941 · Cas Aerobatic LLCN701LGMichael Lingenfelter ZENITH 701 · S/N 7-11132Built 2022 · Lingenfelter Michael JN7126KPiper PA-18 · S/N 18-344Built 1958 · Waller DavidN81279Fairchild 24W-46 · S/N W46179Built 1946 · C A S Aerobatic LLCN82748Piper PA-18-150 · S/N 18-6838Built 1959 · Templeton Marie K TrusteeN829TLDJI AGRAS T50 · S/N 1581F6BUB248D00130TBLambeth Aerial Drone Services LLCN83823Aeronca 7AC · S/N 7AC-2503Built 1946 · Thompson Chase MN8504YBoren Cory A PEGASUS · S/N A347PEGBaugh Dan AN8700JJones Rod W EAA BI-PLANE P-2 · S/N 48752Jones Rod WN879TLDJI AGRAS T50 · S/N 1581F6BUB249200171LFLambeth Aerial Drone Services LLCN927PGPowrachute/Sahni Irvin PEGASUS · S/N A-088PEGBuilt 2002 · Baugh Caleb GN946DMTalos Drones TALOS T60X · S/N 78KBN1L00A016USale reportedN9503Waco ASO · S/N 24Built 1928 · C A S Aerobatic LLCN9541Waco ASO · S/N A-41Built 1928 · C A S Aerobatic LLCN9592SClough Allen PEGASUS · S/N A320PEGBaugh ZaneN990ADDJI AGRAS T40 · S/N 64TBKBJ002008BNutr Hedges LLC
Back to Carthage, MO