OpenAirDocs.org
Oscoda, MI

Registered aircraft · 28

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

N127KLWilson Kenneth D LIGHTNING · S/N 97Built 2010 · Taylor Lane SN13586Cessna 172M · S/N 17262860Built 1973 · Oreilly Thomas PN1640HPiper PA-28-181 · S/N 28-7790321Archer 1640h LLCN185SCessna A185F · S/N 18503230Built 1976 · O'Reilly Thomas PN1925YMooney M20D · S/N 220Built 1964 · Mapes Peter BN23GDCessna 172N · S/N 17270903Built 1978 · Phoenix Composite Solutions LLCN2569JCessna 150E · S/N 15061069Mapes Peter BN33465Piper J3F-65 · S/N 5976Built 1940 · Mcclintock Matthew PatrickN3569NMooney M20F · S/N 680100Built 1967 · Php Air LLCN3904DCessna 182A · S/N 34604Oreilly Thomas PN42463Piper J3C-65 · S/N 14730Built 1945 · Phoenix Composite Solutions LLCN4339BCessna 170 · S/N 26683Built 1955 · Currie Andrew CN4485UCessna 150D · S/N 15060485Built 1964 · Mapes Peter BN46DACzajka C/Alexander D C RV 4 · S/N 1556Built 1993 · Potts Timothy WN503TPPotts Timothy W CHALLENGER 2 · S/N CH2-0897-1646Built 1998 · Potts Timothy WN61943Cessna 172M · S/N 17264903Built 1975 · Phoenix Composite Solutions LLCN6425XCessna 180D · S/N 18050925Built 1960 · Gary Equipment Leasing LLCN6518TCessna 150 · S/N 17918Mcclintock MatthewN6590FCessna 150F · S/N 15063190Built 1966 · Mapes Peter BN7694KPiper PA-20 · S/N 20-517Kingsley Jacob RN8381TCessna 175C · S/N 17557081Mapes Peter BN8548CPiper PA-22 · S/N 22-1251Built 1953 · Mapes Peter BN855TWCessna 150G · S/N 15065657Mapes Peter BN89073Cessna 152 · S/N 15282618Built 1978 · O Reilly Thomas PN8948FHughes 269A-1 · S/N 15-0024Built 1965 · O Reilly Thomas PN9206ACessna 170A · S/N 18967Built 1949 · Currie Andrew CN9787TCessna 172A · S/N 47587Built 1960 · Mapes Peter BN9921WPiper PA-28-140 · S/N 28-23443Phoenix Composite Solutions LLC
Back to Oscoda, MI