OpenAirDocs.org
Maryville, MO

Registered aircraft · 38

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

N1049SPorterfield-Rankin CP-65 · S/N 951Built 1953 · Rankin Bradley WN13706Turben Frank W KR-2 · S/N 470672Built 1982 · Baumli JohnN1483VCessna 172D · S/N 17250241Rankin KevinN1575VCessna 172M · S/N 17263675Built 1974 · Missouri Reliability Services LLCN16129Cessna 150L · S/N 15073498Built 1972 · Rankin KevinN1668TCessna 414 · S/N 414-0461Built 1973 · Kevu Aviators LLCN175WPiper PA-22-150 · S/N 22-3910Built 1956 · Myrick Charles HenryN17PHPoynter Phillip M VANS RV-9A · S/N 92120Built 2022 · Poynter Phillip MN18126Cessna 150L · S/N 15073804Built 1972 · Harroun Charles GN1KRBaby Great Lakes C65 · S/N 6905-N-203BBuilt 1972 · Rankin Kevin JN204STWoolery T A/Woolery R W KITFOX V SPEEDSTER · S/N S-94120082Built 2001 · Woolery Timothy AN2522EPiper PA-11 · S/N 11-843Rankin KevinN27300Cessna 172R · S/N 17280551Built 1998 · Rankin Kevin JN2968PPiper PA-22-150 · S/N 22-3242Built 1955 · Rankin KevinN3225LCessna 172H · S/N 17256125Built 1967 · Wing Nuts IncN357MPPiper PA-28-180 · S/N 28-7505103Built 1974 · Ensminger Edward CN36661Aeronca 65-CA · S/N C-17351Built 1941 · Rankin Kevin JN4348CAeronca 7EC · S/N 7EC-367Built 1955 · Rankin Kevin JN440RSSchoennauer Rene M KITFOX IV · S/N 1440Schieffer Payton AlexN4653XCessna 150G · S/N 15064703Built 1966 · Rankin KevinN46600Cessna 172K · S/N 17257376Baker Matthew CN4745HPiper PA-11 · S/N 11-604Built 1948 · Tally Agribusiness IncN48372Grumman Acft ENG Cor-Schweizer G-164B · S/N 12BBuilt 1976 · Farrell Drew MN518DWEnsminger Joseph/Ensminger EDW ZENITH 750 STOL · S/N 75-7764Ensminger Joseph EN5217LPiper PA-28-180 · S/N 28-4510Built 1967 · Kenny Tommy DN5219RCessna 172M · S/N 17263433Built 1974 · Coston Mace CN562YCDJI AGRAS T100 · S/N ASHCN5Q00101AKRegistration pendingN6445FCessna 150F · S/N 15063045Built 1966 · Walk MasonN6887HPiper J3C-65 · S/N 20109Built 1946 · Farrell Drew MN752SBCirrus Design SR22 · S/N 0773Built 2003 · Kevu Aviators LLCN7560JPiper PA-28R-180 · S/N 28R-30938Built 1968 · Rankin Kevin JN7832WPiper PA-28-180 · S/N 28-1849Built 1964 · Rankin Kevin JN7961HPiper PA-12 · S/N 12-866Built 1946 · Cox James D TrusteeN82764Aeronca 7AC · S/N 7AC-1411Built 1946 · Jo E RankinN92226Piper J3C-65 · S/N 16671Built 1946 · Rankin KevinN9830SPiper J3C-65 · S/N 18469Rankin Jo EN98365Piper PA-28-140 · S/N 28-26190Built 1969 · Woolery Timothy AN98656Piper J3C-65 · S/N 18877Rankin Kevin J
Back to Maryville, MO