OpenAirDocs.org
Chelsea, MI

Registered aircraft · 27

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

N1047VPiper PA-18-135 · S/N 18-3911Built 1954 · Poulter Thomas RN1097HAeronca 15AC · S/N 15AC-117Built 1948 · Poulter Thomas RN110JPPoulter James Alfred RV-8 · S/N 001Built 2004 · Poulter James AN11337Great Lakes 2T-1A · S/N 250Harris Hayden HN205BZMooney M20R · S/N 29-0411Built 2005 · Embedded Advantage LLCN2089LPhantom Aeronautics X1 · S/N 00134Built 1984 · Sell Charles FN241TPiper PA-18-105 SPECIAL · S/N 18-2355Built 1953 · Jenison Lawrence EN268BSDJI AGRAS T40 · S/N 1581F574B226D001009NSky Spray LLCN27EXSchwartz Andrew ROTORWAY EXEC 162F · S/N 3055Built 2003 · Jackson Robert CN2823UCessna 172D · S/N 17250423Built 1963 · Powell Mark JN307CAviat A-1B · S/N 2098Built 2000 · Embedded Advantage LLCN492CZPratt Bruce R COZY III · S/N 492Built 2022 · Pratt Bruce RN5768VBeech A23-24 · S/N MA-21Built 1966 · Skyzure LLCN5924BCessna 182A · S/N 33924Built 1956 · Zarinnia AnthonyN61749Cessna A185F · S/N 18504249Built 1981 · Kellogg Wade AN62588Cone Brooks T BEARHAWK PATROL · S/N P303Built 2025 · Cone Brooks TN6326CPiper PA-32-300 · S/N 32-7840079Built 1978 · Bridges Gerald LloydN6510HPiper J3C-65 · S/N 19696Registration pendingBuilt 1946N6909MUniversal Stinson 108-3 · S/N 108-4909Built 1948 · Zarinnia AnthonyN6ZPitts Special S-1C · S/N JM-2Built 1980 · Harris Hayden HN7117BPiper PA-22-150 · S/N 22-4334Sale reportedBuilt 1956N727CJRockwell International 114 · S/N 14181Built 1976 · Mgr Aviation LLCN730RVSissom Larry R RV-7A · S/N 73640Built 2022 · Sissom Larry RN738BKCessna TR182 · S/N R18200907Built 1979 · Schatzle Gregory EN83957Aeronca 7AC · S/N 7AC-2643Built 1946 · Poulter ThomasN8443UCessna 172F · S/N 17252343Napieralski Todd AllanN908CDCirrus Design SR20 · S/N 2322Built 2016 · Meadows Gregory S
Back to Chelsea, MI