OpenAirDocs.org
Griffith, IN

Registered aircraft · 19

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 = 'IN' AND g.registrant_city = 'GRIFFITH'
  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.

N101GNPiper PA-28-151 · S/N 28-7615214Built 1976 · Great Northern Aircraft IncN1486XPiper PA-28R-200 · S/N 28R-7535291Midwest Investment CorpN157SKCessna 152 · S/N 15284820Built 1980 · Griffith Aviation IncN158SQBeech 76 · S/N ME-86Built 1978 · Griffith Aviation IncN1722TBeech P35 · S/N D-7139Noldin JohnN2009XBeech 76 · S/N ME-66Built 1978 · Griffith Aviation IncN2102CPiper PA-28-161 · S/N 28-7916130Built 1978 · Great Northern Aircraft IncN25852Cessna 152 · S/N 15280817Built 1977 · Griffith Aviation IncN350SQCessna 152 · S/N 15285152Built 1981 · Griffith Aviation IncN4358TPiper PA-28-161 · S/N 28-8416040Built 1984 · Griffith Aviation IncN438SLPiper PA-28-161 · S/N 28-7916276Built 1979 · Griffith Aviation IncN47321Piper PA-28-161 · S/N 28-7816057Built 1977 · Griffith Aviation IncN48SUCessna 152 · S/N 15285186Built 1981 · Griffith Aviation IncN513LCBell OH-58 · S/N 68-16745Lake County Sheriffs DeptN514LCBell UH-1H · S/N 74-22479Lake County Sheriffs DepartmentN7863UCessna 172F · S/N 17251863Built 1964 · Noldin Gregory PaulN8120BPiper PA-28-161 · S/N 28-8016134Built 1979 · Great Northern Aircraft IncN9080XPiper PA-46-310P · S/N 46-8608035Noldin JohnN918UCessna 152 · S/N 15285441Built 1981 · Griffith Aviation Inc
Back to Griffith, IN