OpenAirDocs.org
Ovid, MI

Registered aircraft · 31

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 = 'MI' AND g.registrant_city = 'OVID'
  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.

N1002UCessna 150L · S/N 15072624Built 1971 · Csapos Larry GN101VTNorth American AT-6C · S/N 88-13384Built 1958 · Aas LLCN1025AAir Tractor AT-502 · S/N 502-0075Built 1990 · Aas LLCN1158YCessna 150B · S/N 15059558Built 1962 · Aas LLCN1436DCessna 170A · S/N 20019Built 1951 · Ask Worldwide LLCN144KSAir Tractor AT-400 · S/N 400-0640Built 1986 · Aas LLCN20034Taylor J-2 · S/N 1834Built 1937 · Aas LLCN254BColonial C-1 · S/N 14Built 1957 · Aas LLCN2671GChampion 7ECA · S/N 316Built 1967 · Aas LLCN28PUBoeing B75N1 · S/N 75-5736Schiffer Albert EN2PPBoeing A75N1(PT17) · S/N 75-3412Built 1942 · Aas LLCN3193NCessna 120 · S/N 13451Built 1947 · Aas LLCN3661CCessna 180 · S/N 31160Built 1954 · Aas LLCN38070Piper J5A · S/N 5-857Built 1941 · Aas LLCN42801Cessna 182L · S/N 18259195Built 1968 · Aas LLCN444ASAir Tractor AT-400 · S/N 400-0438Built 1982 · Aas LLCN444MSAir Tractor AT-400 · S/N 400-0444Aas LLCN445MSAir Tractor AT-502B · S/N 502B-0237Built 1994 · Aas LLCN45000North American AT-6 · S/N 90787Built 1943 · Aas LLCN5019ZPiper PA-22-108 · S/N 22-8634Csapos Garry AN5023YPiper PA-23-250 · S/N 27-2027Built 1962 · Aas LLCN6084DPiper PA-22-150 · S/N 22-4738Built 1957 · Csapos Larry GN6230LSchweizer SGU 2-22E · S/N 182Built 1964 · Aas LLCN6330HPiper J3C-65 · S/N 19512Built 1946 · Aas LLCN6424WPiper PA-28-140 · S/N 28-20494Built 1964 · Csapos Larry GN65669Boeing B75N1 · S/N 75-7045Built 1943 · Aas LLCN6939Waco GXE · S/N 1758Built 1928 · Aas LLCN7307TAir Tractor AT-400 · S/N 400-0610Built 1985 · Aas LLCN759JMCessna 182Q · S/N 18266031Built 1977 · Aas LLCN8213ENorth American SNJ-5 · S/N 88-17400Epke Robert MN899DHHarmon Richard C VANS RV-4 · S/N 4517Built 2010 · Schiffer Patrick M
Back to Ovid, MI