OpenAirDocs.org
Ada, MI

Registered aircraft · 32

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

N100JPBeech 58 · S/N TH-1683Aviation Consulting LLCN111TWBeech V35A · S/N D-8641Built 1967 · Scott Hersmon Builder IncN122WAMaule MX-7-180 · S/N 11075CNagle Derek TN1315LBuckeye DREAM MACHINE · S/N 3276Built 1995 · Verburg Thomas CN133MCCirrus Design SR20 · S/N 2054Built 2010 · Mohawk Flying Club IncN1834WBeech V35B · S/N D-9429Built 1973 · Tri-Aero Of Grand RapidsN18HMBeech 58 · S/N TH-651Built 1975 · Young CraigN19PDGuldi James WAG AIR SPRTSMN 2+2 · S/N 1048Built 2003 · Apd Aviation LLCN221ALCirrus Design SR22T · S/N 8538Built 2022 · Aardvark Ventures LLCN2337SCessna T337B · S/N 337-0637Built 1967 · Moore John AN24929Piper J4A · S/N 4-763Built 1939 · N24929 LLCN29170Piper PA-32-300 · S/N 32-7940131Built 1979 · Kuhlmann ConnorN30DMBeech A36 · S/N E-1536Built 1979 · Nagle DerekN370STStrahl Jerry SONEX · S/N 0370Built 2004 · Wells David MN403PKCessna 182Q · S/N 18265475Built 1977 · N403pk LLCN4191KNorth American NAVION · S/N NAV-4-1191Wells David MN421RPCessna 421C · S/N 421C0626Built 1979 · Xmountain Holdings LLCN474AWCessna P210N · S/N P21000652Built 1981 · Centurion Aviation LLCN51STPitts S-2A · S/N 2253Built 1981 · Cnc Aerobatics LLCN524ACGulfstream Aerospace GV-SP (G550) · S/N 5433Built 2013 · Pegasus Leasing LLCN540XCCubcrafters CC11-160 · S/N CC11-00430Built 2019 · Open Skies LLCN5898LAmerican AA-5 · S/N AA5-0098Built 1972 · Lamer Benjamin WN61994Cessna 172M · S/N 17264944Built 1975 · Mohawk Flying Club IncN627KCBeech F33A · S/N CE-1480Built 1990 · Horsehead LLCN66BHPiper PA-32-300 · S/N 32-7940067Built 1979 · Lj Air LLCN712BHBombardier BD-100-1A10 · S/N 20615Built 2016 · Project Finance IncN7222QCessna 172L · S/N 17260522Built 1972 · Mohawk Flying Club IncN759BJCessna 182Q · S/N 18265860Built 1977 · Mohawk Flying Club IncN822JPPiper PA-32R-301T · S/N 32R-8429022Built 1984 · Takacs MarkN861TBeech S35 · S/N D-7507Built 1964 · Hersman ScottN915MTAmerican AA-5 · S/N AA5-0153Built 1972 · Mcnutt William EN9456CCessna 180 · S/N 31854Built 1955 · Coaker Martin
Back to Ada, MI