OpenAirDocs.org
Hannibal, MO

Registered aircraft · 25

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

N1232WMooney M20C · S/N 670088Built 1967 · Milam David NN2194RCessna 182G · S/N 18255394Built 1964 · Jacobson Aviation LLCN230EDXag P100 PRO · S/N 8219314S78R1Drone Deploy Crop Application LLCN234MPMooney M20F · S/N 680183Built 1968 · Baugher Gregory VN2559WMooney M20C · S/N 3268Built 1965 · Highfill Randall WN292GRXag P100 PRO 2023 · S/N 8219352X6J13Drone Deploy Crop Application LLCN301NPDJI MAVIC 3M · S/N 1581FKD23A700D9683Drone Deploy Crop Application LLCN301SZDJI MAVIC 3M · S/N 1581F5FKD22CM00CJ5Q5Drone Deploy Crop Application LLCN3139LBeech F33A · S/N CE-1143Built 1987 · On Premise LLCN36733Piper PA-32RT-300T · S/N 32R-7887072Built 1978 · Speedz Enterprizes LLCN4120SPiper PA-32R-301T · S/N 3257045Built 1998 · Bukstein Michael JN44980Beech A36 · S/N E-1658Built 1980 · Evans Jeffrey TN4520TPiper PA-28-180 · S/N 28-7105216Built 1971 · Brummell Colten AndrewN486MBXag P150 · S/N 186324P18223508N7Y06Drone Deploy Crop Application LLCN486NDXag P150 · S/N 186324P182235084U9M5Drone Deploy Crop Application LLCN4965LPiper PA-28-180 · S/N 28-4336Current JimN509PRaytheon 58 · S/N TH-1947Built 2000 · Tailwindsbikelyft LLCN509VHHylio HYL-150 · S/N 17906110526Sale reportedN51776Beyer Walter A GN1 AIR CAMPER · S/N 1Built 1992 · Pennewell Ollie LeeN656MDXag P150 MAX · S/N 186325P1822954MN572Drone Deploy Crop Application LLCN6593SCessna 150H · S/N 15067393Built 1967 · Milam David NN74709Robinson Helicopter R22 BETA · S/N 3947Built 2005 · Schulz VinceN765NAHylio HYL-150 · S/N 17906110527Sale reportedN9447NPiper PA-28R-200 · S/N 28R-35162Built 1969 · Evans Jeff WN986YHDJI AGRAS T40 · S/N 64TBK8R00100ASHulse Christopher R
Back to Hannibal, MO