OpenAirDocs.org
Detroit, MI

Registered aircraft · 69

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

N10877Cessna 150L · S/N 15075101Built 1973 · Tuskegee Airmen National Historical MuseumN129WMRobinson Helicopter R44 II · S/N 10564Built 2004 · Sky Solutions LLCN1360ECessna 172N · S/N 17270968Built 1978 · Tuskegee Airmen National Historical Museum IncN136XSAeromot AMT-200S · S/N 200.136Built 2002 · Tuskegee Airmen National Historical Museum IncN19MFRaytheon 390 · S/N RB-19Built 2001 · Sky Solutions LLCN20189Cessna 172M · S/N 17261081Detroit Public Schools Community DistrictN206TJRobinson Helicopter R44 II · S/N 11097Built 2006 · Sky Solutions LLCN2083FCessna 172R · S/N 17280671Detroit Public Schools Community DistrictN20FHRobinson Helicopter R44 II · S/N 12348Built 2008 · Sky Solutions LLCN211YPBrocato Barry J GLASAIR SPORTSMANGS2 · S/N 7084Bell Ian TimothyN2167YCessna 172D · S/N 17249667Built 1962 · Kyriacou NickN22760Piper PA-28-140 · S/N 28-7425211Tuskegee Airmen National Historical MuseumN235EFBombardier BD-100-1A10 · S/N 20434Built 2013 · Eaf Air LLCN255AXAirspace Experience Tech SIGMA SIX B0 · S/N 0-001Airspace Experience Technologies IncN26AFSchweizer SGM2-37 · S/N 6Built 1983 · Tuskegee Airmen National Historical Museum IncN28061Bellanca 17-30A · S/N 78-30864Built 1978 · Jug Aviation IncN283PHGulfstream Aerospace GV-SP (G550) · S/N 5505Built 2015 · Global Services Detroit LLCN284PHGulfstream Aerospace GV-SP (G550) · S/N 5480Built 2014 · Global Services Detroit LLCN285PHGulfstream Aerospace GV-SP (G550) · S/N 5522Built 2015 · Global Services Detroit LLCN3003ECessna 172N · S/N 17271400Built 1978 · Tuskegee Airmen National Historical MuseumN313TRBoeing 737-8HX · S/N 36434Fly 737 800 II LLCN3228LCessna 172H · S/N 17256128Built 1967 · Woodson Marcus LN348MWCirrus Design SF50 · S/N 0084Built 2018 · Ww Air LLCN357EBRobinson Helicopter R44 II · S/N 10452Built 2004 · Sky Solutions LLCN37491Piper PA-32-300 · S/N 32-7340177Tuskegee Airmen National Historical Museum IncN39AFSchweizer Acft SCHWEIZER SGM 2-37 · S/N 9Built 1983 · Tuskegee Airmen National Historical Museum IncN404FDassault FALCON 900 EX · S/N 49Built 1999 · Wcf Aircraft LLCN405DDassault FALCON 2000EX · S/N 101Built 2006 · Dillon Aviation LLCN435JFDassault FALCON 2000 · S/N 47Built 1997 · Jf Aircraft LLCN444YGPilatus PC-12/47E · S/N 2186Built 2022 · Pilatus Pc-12 2025 LLCN469TLRobinson Helicopter R44 II · S/N 13151Built 2011 · Sky Solutions LLCN4HACessna T303 · S/N T30300283Built 1984 · Arrington Harold MN500HGulfstream Aerospace GVII-G500 · S/N 72012Built 2018 · Gulfstream 500 N313wa LLCN5109VUltralight Engineering TRIMAR AIR · S/N 001Built 2001 · Tuskegee Airmen National Historical Museum IncN51165Cessna 150J · S/N 15069808Built 1968 · Detroit Public Schools Community DistrictN511PDBell 407 · S/N 53292Built 1998 · City Of DetroitN513PDBell OH-58C · S/N 70-15129City Of DetroitN514PDBell OH58A · S/N 72-21154City Of DetroitN534MFRobinson Helicopter R44 II · S/N 11534Built 2006 · Sky Solutions LLCN55625Boeing A75N1(PT17) · S/N 75-3453Tuskegee Airmen National Historical MuseumN559LCGulfstream Aerospace G-IV · S/N 1259Built 1995 · Olympia Aviation LLCN56598Piper PA-28R-200 · S/N 28R-7435016Built 1973 · Avalos Alberto Hernandez JrN5810VBoeing E75 · S/N 75-5893Built 1944 · Tuskegee Airmen National Historical MuseumN5867PPiper PA-24-250 · S/N 24-950Built 1959 · Wickenheiser Kevin JohnN618TMCessna 172N · S/N 17273346Built 1979 · Tuskegee Airmen National Historical MuseumN628RPTextron 750 · S/N 750-0532Built 2018 · Global Services Detroit LLCN62AEIai GULFSTREAM G280 · S/N 2041Built 2014 · Air Eagle LLCN635EGulfstream Aerospace GIV-X (G450) · S/N 4355Built 2016 · Pla Aircraft LLCN63HHRobinson Helicopter R44 II · S/N 13490Built 2013 · Sky Solutions LLCN66383Cessna 150M · S/N 15076007Tuskegee Airmen National Historical Museum
Back to Detroit, MI