OpenAirDocs.org
Troy, AL

Registered aircraft · 30

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

N134KCBeech A45 · S/N G-78Built 1953 · Kw PlasticsN14112North American T-28A · S/N 174-395Built 1951 · Wiley Sanders Truck Lines IncN144NBBeech E18S · S/N BA-39Built 1955 · Wiley C Sanders JrN17865Beech V35B · S/N D-10021Built 1977 · Wcs IncN17KWGulfstream Aerospace G-IV · S/N 1361Built 1999 · Wcs IncN1854RBeech 58 · S/N TH-1345Built 1982 · Sellers William G IIIN18KWCessna 680 · S/N 680-0323Built 2011 · Wcs IncN24EKHawker Beechcraft G58 · S/N TH-2248Built 2008 · Murphree Bridge CorpN29939North American AT-6D · S/N 49-3034Built 1943 · Wiley Sanders Truck Lines IncN3211URaytheon 58 · S/N TH-1911Hc LLCN37WMCessna 305A · S/N 21690Built 1951 · Sanders Wiley C JrN403SARaytheon A36 · S/N E-3407Built 2001 · Calk Mark CN415KCLett J Ray AIR CAM · S/N AC0123Built 2004 · Pike Aviation IncN451KWBellanca 8KCAB · S/N 451-78Built 1978 · Kw PlasticsN500BARaytheon 58 · S/N TH-1814Built 1997 · Kw PlasticsN516JLStinson 108-3 · S/N 108-4016Built 1947 · Alabama Tailwheels LLCN51WBNorth American-Skurich P-51D · S/N 44-15757Built 1944 · Wiley Sanders Truck Lines IncN5262VNorth American B-25J-32-NC · S/N 44-86785Wiley Sanders Truck Lines IncN53KWGrumman American Avn. G-1159 · S/N 028Wiley Bob Inc TrusteeN55902Boeing PT-17 · S/N 75-4632Built 1943 · Kw PlasticsN582KHTiger AUSTFLIGHT DRIFTER · S/N SB582-9869Built 1998 · Pike Aviation IncN7133YRaytheon G36 · S/N E-3733Sanbuck IncN717MLPiper J3C-65 · S/N 22411Built 1946 · Alabama Tailwheels LLCN728GDouglas DC3C · S/N 4359Built 1942 · Kw Plastics IncN77SLPiper PA-30 · S/N 30-1654Built 1967 · Sanders Wiley C JrN7925DBeech H35 · S/N D-5209Built 1957 · Bowers Christian RN84252Aeronca 7AC · S/N 7AC-2944Built 1946 · Calk Mark CN9066WPiper PA-28-235 · S/N 28-10665Built 1965 · Kurtz BrianN9150YPiper PA-32R-301 · S/N 32R-8513009Built 1985 · Tyler Transport LLCN91935Douglas AD-4N · S/N 124156West Indies Investments Ltd
Back to Troy, AL