OpenAirDocs.org
Ellsinore, MO

Registered aircraft · 29

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

N12445Waco PBA · S/N 3598Built 1932 · Old Style Aircraft LLCN13625Flagg F-13 · S/N 1Built 1933 · Cournoyer John JN144YWaco RNF · S/N 3319Old Style Aircraft LLCN15676Piper E-2 · S/N 341Built 1935 · Cournoyer John JN17457Waco ZKS-7 · S/N 4600Built 1937 · Cournoyer John JN17470Waco ZPF-6 · S/N 4383Old Style Aircraft LLCN2073Ryan M-1 · S/N 7Built 1926 · Cournoyer John JN2091KWaco UBF · S/N 3608Built 1932 · Cournoyer John JN245WStinson SM-8A · S/N 4064Built 1930 · Cournoyer John JN25894Piper J3L-65 · S/N 3750Built 1939 · Old Style Aircraft LLCN261MWaco BSO · S/N A-159Old Style Aircraft LLCN2701CMonocoupe 90A · S/N AF-826Cournoyer John JN280WWaco CTO · S/N A-3596Built 1932 · Old Style Aircraft LLCN3615Fairchild KR-31 · S/N 119Built 1927 · Cournoyer John JN369HMonocoupe 90AL-115 · S/N 863Old Style Aircraft LLCN392VZenith Z6A · S/N 3Built 2004 · Cournoyer John JN4444Spartan 7W · S/N 18Built 1939 · Old Style Aircraft LLCN5533Waco ATO · S/N A-7Built 1928 · Old Style Aircraft LLCN71068Travel Air 16-E · S/N 3548Built 1936 · Cournoyer John JN741EAWaco ATO · S/N A-75Old Style Aircraft LLCN7666ACessna 180 · S/N 32563Built 1956 · Cournoyer Constance LN78851Aircraft Manufacturing TEXAS BULLET 205 · S/N 105Built 1951 · Old Style Aircraft LLCN82LNDehavilland TIGER MOTH DH-82C · S/N 1847Built 1941 · Cournoyer John JN86570Universal Moulded Products MONOCOUPE D-145 · S/N D-122Built 1935 · Cournoyer John JN906HWaco ATO · S/N A-103Built 1929 · Old Style Aircraft LLCN90HWaco AVN-8 · S/N 5114Built 1938 · Old Style Aircraft LLCN9384Fairchild 24 C8A · S/N 2514Built 1933 · Cournoyer John JN951BSaint Louis C-2-110 · S/N C-106Built 1929 · Old Style Aircraft LLCN9899YChampion 7GCB · S/N 7GCB-139Built 1962 · Old Style Aircraft LLC
Back to Ellsinore, MO