OpenAirDocs.org
Hayti, MO

Registered aircraft · 61

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

N10210Grumman G-164 · S/N 10Built 1939 · Mid Continent Aircraft CorpN135HCessna 170B · S/N 20829Built 1952 · Mid Continent Aircraft CorpN16XBoeing A75N1(PT17) · S/N 75-2192Built 1941 · Mid Continent Aircraft CorpN2315YPiper PA-36-375 · S/N 36-8002040Built 1980 · Mid Continent Aircraft CorpN234TUBeech A45 · S/N G-138Built 1953 · Mid Continent Aircraft CorpN2412XPiper PA-36-375 · S/N 36-8302001Built 1982 · Mid Continent Aircraft CorpN3571GCallair A-9 · S/N 1080Built 1964 · Mid Continent Aircraft CorpN44926Naval Aircraft Factory N3N-3 · S/N 1980Built 1940 · Mid Continent Aircraft CorpN45046Naval Aircraft Factory N3N-3 · S/N 2627Built 1940 · Mid Continent Aircraft CorpN4536Grumman Acft ENG Cor-Schweizer G-164A · S/N 1053Built 1973 · Mid Continent Aircraft CorpN45506Air Tractor AT-502 · S/N 502-0132Built 1991 · Mid Continent Aircraft CorpN476EAThrush S2R-H80 · S/N H80-190Built 2016 · Mid Continent Aircraft CorpN48442Grumman Acft ENG Cor-Schweizer G-164A · S/N 1646Built 1976 · Mid Continent Aircraft CorpN48445Grumman Acft ENG Cor-Schweizer G-164B · S/N 21BBuilt 1976 · Mid Continent Aircraft CorpN48664Grumman Acft ENG Cor-Schweizer G-164B · S/N 105BBuilt 1976 · Mid Continent Aircraft CorpN52640Cessna 177RG · S/N 177RG1224Built 1977 · Crawford Bill EN5505YBoeing A75N1(PT17) · S/N 75-4784Mid Continent Aircraft CorpN5507XBoeing A75N1(PT17) · S/N 75-1828Mid Continent Aircraft CorpN5526NBoeing E75 · S/N 75-8619Mid Continent Aircraft CorpN55713Piper PA-36-285 · S/N 36-7360007Built 1973 · Mid Continent Aircraft CorpN5635SBeech V35 · S/N D-8174Built 1966 · Rhodes StephenN5663XAero Commander S2R · S/N 1863RBuilt 1973 · Mid Continent Aircraft CorpN57830Piper PA-36-300 · S/N 36-7760003Built 1977 · Mid Continent Aircraft CorpN62429Cessna 172P · S/N 17275268Built 1981 · Fowler Cary DN62795Boeing A75N1(PT17) · S/N 75-3088Built 1942 · Mid Continent Aircraft CorpN62942Boeing A75N1(PT17) · S/N 75-1798Built 1941 · Mid Continent Aircraft CorpN65638Cessna 182T · S/N 18281467Built 2004 · Mid Continent Aircraft CorpN6609QGrumman Acft ENG Cor-Schweizer G-164B · S/N 136BBuilt 1976 · Mid Continent Aircraft CorpN660UGrumman G-164 · S/N 396Built 1966 · Mid Continent Aircraft CorpN6715QGrumman American Avn. G-164A · S/N 1709Mid Continent Aircraft CorpN6735KGrumman Acft ENG Cor-Schweizer G-164C · S/N 30CBuilt 1978 · Mid Continent Aircraft CorpN6792ZPiper PA-25-235 · S/N 25-2436Built 1963 · Mid Continent Aircraft CorpN703CGThrush S2R-510 · S/N 510-515Built 2023 · Mid Continent Aircraft CorpN7050ZPiper PA-25-235 · S/N 25-2818Built 1964 · Mid Continent Aircraft CorpN7093ZPiper PA-25-235 · S/N 25-2880Built 1964 · Mid Continent Aircraft CorpN7220Grumman Acft ENG Cor-Schweizer G-164A · S/N 896Built 1972 · Mid Continent Aircraft CorpN73006Air Tractor AT-400A · S/N 400A-0501Built 1985 · Mid Continent Aircraft CorpN7694Grumman Acft ENG Cor-Schweizer G-164A · S/N 986Built 1972 · Mid Continent Aircraft CorpN77CSBeech F33A · S/N CE-741Built 1977 · Ray Charles LN782MCThrush S2R-510 · S/N 510-537Sale reportedN7977ABoeing A75 · S/N 40-1686Mid Continent Aircraft CorpN8057KGulfstream-Schweizer A/C GULFSTREAM AM G-164D · S/N 4DMid Continent Aircraft CorpN8127ZPiper PA-32R-301T · S/N 32R-8029017Built 1979 · Crawford Oil Co IncN813MCThrush S2R-H80 · S/N H80-195Mid Continent Aircraft CorpN8515HGrumman Acft ENG Cor-Schweizer G-164A · S/N 1389Built 1974 · Mid Continent Aircraft CorpN8544LPiper PA-25-235 · S/N 25-5420Built 1971 · Mid Continent Aircraft CorpN8608SAir Tractor AT-301 · S/N 301-0164Built 1978 · Mid Continent Aircraft CorpN8642MBeech P35 · S/N D-7251Built 1963 · Rhodes Stephen LN877MCThrush S2R-510 · S/N 510-146Built 2025 · Mid Continent Aircraft CorpN8832LPiper PA-25-235 · S/N 25-5343Built 1971 · Mid Continent Aircraft Corp
Back to Hayti, MO