OpenAirDocs.org
Redstone Arsenal, AL

Registered aircraft · 25

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 = 'AL' AND g.registrant_city = 'REDSTONE ARSENAL'
  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.

N112AHAirbus Helicopters MBB-BK 117 C-2 · S/N 9684Built 2014 · US ArmyN1298MCessna 182P · S/N 18264280Built 1975 · Redstone Arsenal Flying ActivityN1344LTextron B300 · S/N FL-1344Built 2024 · U S ArmyN1346KTextron B300 · S/N FL-1346Built 2025 · U S ArmyN1349KTextron B300 · S/N FL-1349Built 2025 · U S ArmyN1351KTextron B300 · S/N FL-1351Built 2025 · U S ArmyN2108ECessna 172N · S/N 17271159Built 1978 · Redstone Arsenal Flying ActivityN29RMPiper PA-28R-200 · S/N 28R-7535269Built 1975 · Redstone Arsenal Flying ActivityN35553Cessna 172I · S/N 17256830Built 1968 · Redstone Arsenal Flying ActivityN48610Cessna 152 · S/N 15280922Built 1977 · Redstone Arsenal Flying ActivityN4884TPiper PA-28R-200 · S/N 28R-7235131Built 1972 · Redstone Arsenal Flying ActivityN52057Cessna 172R · S/N 17281116Built 2002 · Redstone Arsenal Flying ActivityN5697ECessna 172N · S/N 17271922Built 1978 · Redstone Arsenal Flying ActivityN67428Bell 206B · S/N 5149Built 1994 · United States ArmyN67669Bell 206B · S/N 5189Built 1994 · United States ArmyN67784Bell 206B · S/N 5207United States ArmyN67950Bell 206B · S/N 5229Built 1995 · United States ArmyN67968Bell 206B · S/N 5235Built 1995 · United States ArmyN736ZXCessna R182 · S/N R18200813Built 1978 · Redstone Arsenal Flying ActivityN737VNCessna 172N · S/N 17269710Built 1977 · Redstone Arsenal Flying ActivityN739VECessna 172N · S/N 17270834Built 1978 · Redstone Arsenal Flying ActivityN89358Cessna 152 · S/N 15282724Built 1978 · Redstone Arsenal Flying ActivityN95556Cessna 152 · S/N 15285922Built 1984 · Redstone Arsenal Flying ActivityN9791FCessna 172R · S/N 17280062Built 1997 · Redstone Arsenal Flying ActivityN984SPCessna 172S · S/N 172S8188Built 1999 · Redstone Arsenal Flying Activity
Back to Redstone Arsenal, AL