OpenAirDocs.org
Mexico, 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 = 'MEXICO'
  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.

N104ZZDubbert Roger ZODIAC CH 650B · S/N 65-8250Built 2011 · Dubbert RogerN11177Champion 7ECA · S/N 7ECA-93Built 1965 · Raleigh JamesN199LHHatfield Lary ZENITH CH 640 · S/N 0045Built 2010 · Dubbert Roger DN211JRRaleigh James F RALEIGH KR2S · S/N 001Built 2007 · Raleigh James FN225AMRobinson Helicopter R44 II · S/N 12221Built 2008 · Nordwald Aviation Services LLCN28233Piper J4A · S/N 4-1156Built 1952 · Riley Glenn RN285YTDJI AGRAS T40 · S/N 1581F574B226H00104HWKendrick Jared DN28784Luscombe 8A · S/N 1545Built 1940 · Dubbert Roger DN323JMPiper PA-28-140 · S/N 28-7125096Built 1970 · Dubbert Roger DN3242EAeronca 11AC · S/N 11AC-1592Built 1947 · Riley Glenn RN40RLRobinson Helicopter R66 · S/N 0301Built 2013 · Nordwald Aviation Services LLCN4219QCessna 172L · S/N 17260119Audrain Flying Club IncN442BTEa Vision EA J100 · S/N 85674Talley Vincent CN4466Robinson Helicopter R44 II · S/N 10374Built 2004 · Nordwald Aviation Services LLCN463AXEavision EA-J150 · S/N JMZKJ150UAV602595143Agri-Maxx Spray Drones LLCN504KCRobinson Helicopter R22 BETA · S/N 1461Built 1990 · Nordwald Aviation Services LLCN5569FInfinity Power Parachutes INFINTY 2004 · S/N IPP4-260Built 2004 · Jacobi Joseph LN55943Stinson VULTEE V-77 · S/N 7776Built 1946 · Jacobi Joseph L IIN5595GCessna 150J · S/N 15071095Zortman Micky PN5731MCessna 310P · S/N 310P0031Zortman Micky PN57984Piper J3C-65 · S/N 17841Jacobi JosephN584WKDJI AGRAS T40 · S/N 1581F574B238F0010029Kendrick Jared DN60470Cessna 150J · S/N 15070333Built 1969 · Lowry John RN6128QDubbert Roger CH 701 STOL · S/N 73707Built 1998 · Dubbert RogerN6206RCessna 150E · S/N 15061506Built 1965 · Hagan Steve PN6221PPiper PA-24 · S/N 24-1323Licata Paul ZN6521MStinson 108-3 · S/N 108-4521Built 1948 · Jacobi Joseph L IIN6852BPiper PA-22-150 · S/N 22-4151Built 1956 · Taylor David LN71686Luscombe 8A · S/N 3113Built 1946 · Dubbert RogerN73515Taylorcraft DCO-65 · S/N L4760Built 1943 · Jacobi Joseph LN736MMMahorney Kenneth R STOL CH-701 · S/N 7-8943Built 2016 · Dubbert Roger DN750YNRoger Dubbert CH 750 · S/N 75-10706Built 2017 · Dubbert RogerN750ZWRoger Dubbert CH 750 · S/N 75-8779Built 2013 · Dubbert RogerN75CDRoger Dubbert CH 750 · S/N 75-12139Dubbert RogerN766SBeech S35 · S/N D-7818Built 1965 · Qualls Shannon DN797ZAHeintz Chris STOL CH 801 · S/N 8-2802Built 1999 · Zenith Aircraft CoN8436SJames D Stuckey ZENITH STOL CH 701 · S/N 7-10826Dubbert Roger DN8628JCessna 150G · S/N 15066528Built 1967 · Jacobi JosephN92674Piper J3C-65 · S/N 17052Built 1946 · Joseph L JacobiN93930Ercoupe 415-C · S/N 1253Built 1946 · Dubbert Roger DN95463Piper PA-28-140 · S/N 28-25704Built 1969 · Licata Paul ZN956TTaylor David L WAG A BOND · S/N 1852Built 2010 · Jacobi Joseph LN96679Cessna 182Q · S/N 18266807Built 1979 · Jacobi Joseph L
Back to Mexico, MO