Skip to content

Alliedsign TFE731-60

Registered aircraft · 45

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 ('02504')
  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 ('02504')
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.

N110EXKm 900 LLC · Chesterfield, MOBuilt 2000 · S/N 71 N11WMRegistered aircraftBuilt 1999 · S/N 58 N124GDDino Corporation LLC · Wilmington, DEBuilt 1998 · S/N 29 N1904S1904 LLC · Elyria, OHBuilt 1999 · S/N 053 N205WPAviation Resource Group Inc · Fort Lauderdale, FLBuilt 1974 · S/N 306 N28NPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1999 · S/N 118 N321AJM Hixson Aviation LLC · Denton, TXBuilt 2000 · S/N 77 N321AKSnails Pace Aviation LLC · New York, NYBuilt 2008 · S/N 222 N361DDWeco West LLC · Catarina, TXBuilt 2000 · S/N 72 N382KUMaverick Aire LLC · New Castle, COBuilt 1999 · S/N 47 N3BMMorris Communications Co LLC · Augusta, GABuilt 1999 · S/N 280 N404FWcf Aircraft LLC · Detroit, MIBuilt 1999 · S/N 49 N41MBRivers Equipment LLC · Nashville, TNBuilt 1998 · S/N 32 N42NFCest La Vie LLC · Piedmont, OKBuilt 1997 · S/N 12 N47LPKalitta Charters LLC · Ypsilanti, MIBuilt 1981 · S/N 457 N510HWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2009 · S/N 234 N522EECenergistic LLC · Dallas, TXBuilt 1999 · S/N 282 N55HSRapid Leasing Inc · Cedar Rapids, IABuilt 1998 · S/N 276 N615MSMss Falcon 900 LLC · Denver, COBuilt 2006 · S/N 160 N62NWE7 Alpha LLC · Austin, TXBuilt 2009 · S/N 233 N66FJAlpha Mike Aviation LLC · Murfreesboro, TNBuilt 2000 · S/N 66 N711WHKcm Ventures Whitefish 2 LLC · Arlington, TXBuilt 1999 · S/N 56 N718RRMac 800xp LLC · Wilmington, DEBuilt 1999 · S/N 258428 N720MLNorthwestern Mutual Life Insurance Co · Milwaukee, WIBuilt 2009 · S/N 231 N78CYWkc Corp · Saint Louis, MOBuilt 2000 · S/N 79 N808SFTgs Logistics LLC · Dover, DEBuilt 1997 · S/N 013 N81SNK S Blackwood Properties II LLC · Midland, TXBuilt 1999 · S/N 41 N826KAircraft Fidelity Corp Trustee · Dover, DEBuilt 1998 · S/N 36 N831MCClements Aviation LLC · White Oak, TXBuilt 1999 · S/N 112 N83TYTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1999 · S/N 288 N882CAPere Marquette Group LLC · Grand Rapids, MIBuilt 2001 · S/N 155 N89TVBqn Flights Corp · San Juan, PRBuilt 2001 · S/N 89 N900EFHarrison Rosemary J · Houston, TXBuilt 1999 · S/N 59 N900ELTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 200 N900FJEmmanuel Group · North Wilkesboro, NCBuilt 1998 · S/N 37 N900WGGreenleaf Corp · Saegertown, PABuilt 1998 · S/N 33 N901HDN27ax LLC · Tulsa, OKBuilt 2001 · S/N 149 N912BDBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 162 N918JM999 Aviation LLC · Northbrook, ILBuilt 2008 · S/N 199 N96LABank Of Utah Trustee · Salt Lake City, UTBuilt 1999 · S/N 61 N977JPQuattro Navarro Farms LLC · Spicewood, TXBuilt 1997 · S/N 140 N98MHMh Air LLC · Nashville, TNBuilt 2001 · S/N 76 N990PMBlue Sky Aviation Group LLC · Oakwood, OHBuilt 2000 · S/N 70 N990WMBear Cub Aviation LLC · Billings, MTBuilt 1998 · S/N 40 N9GBCardinal Capital Partners Inc · Dallas, TXBuilt 2009 · S/N 624

Back to Alliedsign TFE731-60