OpenAirDocs.org
Roscommon, MI

Registered aircraft · 39

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

N1321MDJI MAVIC 3 · S/N 1581F45TB21CE2AE05N7State Of MichiganN13747Cessna 177B · S/N 17702466Built 1976 · Namund LLCN170TUCostruzioni Aeronautiche Tecna P2006T · S/N 170/USBuilt 2016 · Michigan Department Of Natural ResourcesN1917MDJI MATRICE 350 · S/N 1581F6GKB2365004001YState Of MichiganN200JKPiper PA-28R-200 · S/N 28R-7435255Built 1974 · Ruiz VictorN2463BCessna 182T · S/N 18281735Built 2005 · Michigan Dept Of Natural ResourcesN2570HRoberts Robert L HIGHLANDER · S/N JAESC 0070Built 2005 · Roberts Robert LN262HMFreefly Systems ALTA X · S/N 757142State Of MichiganN2775FCessna 182J · S/N 18256875Built 1966 · Jock Carl A TrusteeN3117FCessna 182J · S/N 18257217Built 1966 · Brya TroyN334UKDJI AGRAS T40 · S/N 5X5BLCP002084SState Of Michigan Department Of Natural ResourcesN3373MDJI AGRAS T25 · S/N 1581F6BUB2448001RUY4State Of MichiganN338EMDJI AGRAS T25 · S/N 1581F6BUB2455001U7JUState Of Michigan Department Of Natural ResourcesN357MECessna 182S · S/N 18280854Built 2000 · Michigan Dept Of Natural ResourcesN3696SKolb MARK III · S/N 81Built 1992 · Spangler Roy VN4329RMcintire John P SKYRANGER · S/N 481Built 2002 · Socia Jared RN5101UCessna 182T · S/N 18282156Built 2009 · Michigan Department Of Natural ResourcesN5198JCessna 182T · S/N 18282147Built 2009 · Michigan Dept Of Natural ResourcesN5512LNew Kolb STARFIRE · S/N 45Built 1985 · Spangler Roy VN582MNDJI MATRICE 600 PRO · S/N M80DGBH0039S5WState Of MichiganN585SXHensley Ronald D SONEX · S/N 0585Built 2007 · Socia Jared RN6275SCessna 182T · S/N 18282100Built 2008 · Michigan Dept Of Natural ResourcesN664YAABZ Innovation L30-V2 · S/N 1759FABZL30V22500050State Of MichiganN664ZAABZ Innovation L30-V2 · S/N 1759FABZL30V22500077State Of MichiganN665DPPiper PA-28-180 · S/N 28-5817Built 1970 · Pflum David RN668DPDavid R Pflum VANS RV-7A · S/N 73132Built 2017 · Pflum David RN73199Cessna 172M · S/N 17267326Built 1976 · Performance Polymer Technologies LLCN851DPDJI AGRAS T40 · S/N 64TBL2100200G7State Of MichiganN865WCessna 206H · S/N 20608352Built 2013 · Michigan Dept Of Natural ResourcesN876QMDJI MAVIC 2 PRO · S/N 163DG1N00191Y6Michigan Department Of Natural ResourcesN879RMDJI MATRICE 210 V1 · S/N 17TDG8301376FCMichigan Department Of Natural ResourcesN892YFDJI MAVIC 2 PRO · S/N 163DG1M00178E1State Of MichiganN8952HNorth American NAVION · S/N NAV-4-952Built 1947 · Moore Carter RN919DMDJI MATRICE 300 · S/N 1ZNBJ6F00C00GXState Of MichiganN9231GCessna 182N · S/N 18260771Built 1971 · Jock CarlN948LMDJI MAVIC 3 · S/N 1581F45TB21CC1BE08KTState Of MichiganN950WSDJI MAVIC 3 · S/N 1581F45TB21CE2AE06TKState Of MichiganN9884MDJI MATRICE 210 V2 · S/N 17T3K7G002U015State Of Michigan Department Of Natural ResourcesN9943YChampion 7GCB · S/N 143Built 1962 · Dehlin James M
Back to Roscommon, MI