Skip to content

Allison T63-A-700

Registered aircraft · 16

Aircraft with this engine in the FAA registry, by N-number.

Query with SQL

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE engine_model_code IN ('03086')
  ORDER BY 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.

SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE engine_model_code IN ('03086')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N1045CReynolds Darryl G · Wills Point, TXBuilt 1972 · S/N 71-20527 N160DAWehring Justin DBA · Clute, TXBuilt 1969 · S/N 391115 N206KLWolfhawk Aviation LLC · Safety Harbor, FLBuilt 1971 · S/N 71-20701 N24171Commerce Rotorcraft LLC · Commerce, TXBuilt 1973 · S/N 72-21201 N259BKCavanaugh Collections Inc · Addison, TXBuilt 1970 · S/N 301376 N27LCCrosby Michael J · Waco, TXBuilt 1973 · S/N 73-21872 N369DRReynolds Darryl G · Wills Point, TXBuilt 1967 · S/N 67-16647 N51741Reynolds Darryl G · Wills Point, TXBuilt 1970 · S/N 70-15438 N51747Mid South Aviation Institute · Black Rock, ARBuilt 1971 · S/N 71-20691 N5623MHagglund Carl D · Pendleton, ORS/N 907-001 N5869YMid South Aviation Institute · Black Rock, ARBuilt 1971 · S/N 44001 N605LAWestbrookville Helicopter Services LLC · Wilmington, DEBuilt 1972 · S/N 71-20605 N707EEEngler Eric M DBA · Cass City, MIBuilt 1972 · S/N 72-21159 N7242USl Jet H LLC · Franklin, NCBuilt 1972 · S/N 44038 N8525YGrove Karl P · Redlands, CABuilt 1969 · S/N 67-16493 N911FCMomentum Foundation Inc · Tullahoma, TNBuilt 1972 · S/N 72-21212

Back to Allison T63-A-700