Skip to content

Garrett TFE731 series

Registered aircraft · 694

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

N100AXApplied Underwriters Inc · Omaha, NEBuilt 1995 · S/N 155 N100CUJani King Aviation LLC · Addison, TXBuilt 1977 · S/N 104 N100FJAvw Equipment Co Inc · Maywood, ILS/N 118 N100KZLear 100kz LLC · Austin, TXBuilt 1999 · S/N 065 N100UPFj100 LLC · Waco, TXBuilt 1988 · S/N 44 N100YPJk LLC · Ridgeville, SCBuilt 1988 · S/N 222 N103JLThunderun Aviation Corp · Buffalo, NYBuilt 1990 · S/N 026 N104LRTri Aviation Inc · Venetia, PABuilt 1996 · S/N 258303 N105RHJem Aviation Solutions LLC · South River, NJBuilt 1984 · S/N 650-0055 N107CVRedbird Holdings LLC · Jensen Beach, FLBuilt 1982 · S/N 85 N108KCV1vr LLC · Wilmington, DEBuilt 1974 · S/N 8 N108PHYoung Family Aviation LLC · Sugar Grove, ILBuilt 1990 · S/N 87 N109BGAviation Leasing Group Inc · Wilmington, DEBuilt 1982 · S/N NA0310 N10FKing Leasing Corp · San Diego, CABuilt 1974 · S/N 12 N10FNGh Equipment LLC · Dover, DEBuilt 1975 · S/N 015 N10NCHayward Enterprises Inc · High Point, NCBuilt 1980 · S/N 172 N10TNPacific Rim Management LLC · Downey, CAS/N 257085 N110JDChandler Air LLC · Bossier City, LABuilt 1984 · S/N 414 N111FFabair LLC · Milwaukee, WIBuilt 1991 · S/N 650-0197 N111FJJfm Air LLC · Wilton Manors, FLBuilt 1993 · S/N 128 N11288Fly The Coop Aviation LLC · Willow Park, TXBuilt 1990 · S/N 650-0184 N116MAFsa Aerospace Inc Trustee · Wilmington, DEBuilt 1977 · S/N 029 N117HHZephyr Air LLC · Houston, TXBuilt 1993 · S/N 258249 N117JTColcot Aviation LLC · New York, NYBuilt 1992 · S/N 258205 N118CDFirst Aviation Service Corp · Wilmington, DEBuilt 1977 · S/N NA0212 N118MMBradley Flight LLC · Denver, COBuilt 1999 · S/N 650-7105 N119AKLegendary Aviation LLC · Spring, TXBuilt 1982 · S/N 76 N1210LElite Elevated Enterprises LLC · Las Vegas, NVBuilt 1997 · S/N 650-7078 N1210NTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1991 · S/N 105 N121BZSkyview LLC · Wilmington, DEBuilt 1983 · S/N 135 N121LJN121lj LLC · Elmira, NYBuilt 1996 · S/N 121 N122AVase Corp V · Doral, FLBuilt 1990 · S/N 88 N123EDFrench Fly LLC · San Jose, CAS/N 258366 N123RCBwa Westwind 2 LLC · Orlando, FLS/N 349 N125SBBay Venture Management LLC · Atlanta, GABuilt 1985 · S/N 258046 N125TKSupreme Sky LLC · Farmers Branch, TXBuilt 1994 · S/N 247 N126KLAircraft Fidelity Corp Trustee · Dover, DEBuilt 1984 · S/N 096 N127VLE D Santos & Associates LLC Trustee · Wilmington, DEBuilt 1991 · S/N 036 N129GBCapital Cost Corp · Wilmington, DEBuilt 1983 · S/N 650-0006 N12RPRoyal Air Freight Inc · Waterford, MIBuilt 1980 · S/N 278 N132CESouthern Energy Transport LLC · Shelbyville, TNBuilt 1995 · S/N 650-7061 N133EJHale William Trustee · Loveland, COBuilt 1977 · S/N 133 N135SHMed Air LLC · Wilmington, DEBuilt 1981 · S/N 335 N136JPCasmos LLC · Wilmington, DES/N 35A-359 N137SHDream Global Parts LLC · Lawrence, KSS/N 137 N13ADN13ad LLC · Dover, DES/N 030 N140WHVarney Aviation LLC · Bangor, MEBuilt 1991 · S/N 650-0195 N141AELake Superior College · Duluth, MNBuilt 1981 · S/N NA0306 N147GXAltair Aviation LLC · Missoula, MTBuilt 1987 · S/N 214 N14NAAnschutz Corp · Englewood, COBuilt 1992 · S/N 124

Back to Garrett TFE731 series