Skip to content

TCM Cont TSIO-520 series

Registered aircraft · 49

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

N123MCNelson Isaac · Saint Croix Falls, WIS/N 21063578 N124MDKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 1981 · S/N TJ374 N184TMYates Christopher R · Huntington Beach, CABuilt 1956 · S/N 32302 N1961UMccarthy Trevor William · Addison, TXBuilt 1974 · S/N U20602312 N203JLJfra LLC · Miami, FLBuilt 1981 · S/N 414A0670 N206BSBlue Star Gas Fleet Services Co · Central Point, ORBuilt 1968 · S/N P206-0434 N210TYRiley Charles · Littleton, COBuilt 1979 · S/N P210-00252 N224MHFeely Daniel R · Pasadena, CABuilt 1978 · S/N P21000089 N22VXDo Good Things LLC · Port Orange, FLBuilt 1978 · S/N TJ-171 N239ELDingman Marine LLC · Orlando, FLBuilt 1975 · S/N 414-0808 N2498SKatz Michael R Trustee · Merritt Island, FLBuilt 1976 · S/N 21061306 N303HLLao Che Airfreight LLC · North Weymouth, MABuilt 1982 · S/N T30300038 N303KJBrother Michael Andrew · Bedford, TXBuilt 1984 · S/N T303-00301 N303PBPlane Fun Inc Tr Trustee · Snellville, GABuilt 1984 · S/N T30300290 N316MLJump N316ml LLC · East Berlin, PABuilt 1969 · S/N P2060549 N3279NTips Frederick J III · San Antonio, TXBuilt 1974 · S/N 21060452 N340AHEden On Broad LLC · Cookeville, TNBuilt 1977 · S/N 340A0333 N340DFWyatt Barbara · Cheyenne, WYBuilt 1973 · S/N 340-0229 N340DWSilver David Scott · Brookings, ORBuilt 1978 · S/N 340A-0497 N340LMCrawford William K · Indianapolis, INBuilt 1978 · S/N 340A0478 N350GMCannonball Trucking Inc · Houston, TXBuilt 1978 · S/N 414A-0120 N3737Qualitair LLC · MichelstadtBuilt 1985 · S/N 468508060 N3HKInternational Air Services Inc Trustee · Carson City, NVBuilt 1975 · S/N 340-0538 N431CELegacy Aviation LLC · Ann Arbor, MIBuilt 1973 · S/N 414-0431 N47WTDoucet Lucius J III · Baton Rouge, LABuilt 1966 · S/N D-8217 N501KPWasson Ronald L · Colleyville, TXBuilt 1974 · S/N TJ-21 N512KZotec Partners LLC · Carmel, INBuilt 1978 · S/N 414A0054 N5762JJonesco Acquisitions LLC · Bixby, OKBuilt 1971 · S/N 21059462 N5870MMcdonald Brian L · Van Alstyne, TXBuilt 1972 · S/N 3400058 N5PAFinal Design Group LLC · Hurricane, UTBuilt 1981 · S/N EA-251 N6227YWest Brook Group Inc · Pleasant Hill, IABuilt 1981 · S/N 21064301 N6419XPernat Frank J Trustee · Chaska, MNBuilt 1980 · S/N U20605877 N6855RD & N Holdings Inc · Boca Raton, FLBuilt 1967 · S/N T210-0255 N714DBIpiranga Inc · Houston, TXBuilt 1996 · S/N EA-585 N73TBMagic Leasing LLC · Peotone, ILBuilt 1981 · S/N 414A0474 N740CAHyannis Air Service Inc · Hyannis, MABuilt 1980 · S/N 402C0277 N741DFSeeding Operations And Atmospheric Res (Soar) LLC · San Angelo, TXBuilt 1975 · S/N 414-0633 N74ESValiair Ltd Co Trustee · Casper, WYBuilt 1979 · S/N P21000279 N7584NCarto Flight Inc · Willoughby, OHBuilt 1977 · S/N U20603689 N789BDTroy Farms Lp · Delano, CAFirst renewal noticeBuilt 1973 · S/N 310Q0922 N7983QLorenso Walker Institute Of Technology · Naples, FLBuilt 1971 · S/N 401B0202 N799KTAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1976 · S/N U20603580 N82AWQualitair LLC Trustee · MichelstadtBuilt 1978 · S/N 414A0064 N920GGAbbott Air Inc · Hydro, OKBuilt 1976 · S/N 21061545 N93362Bouvier Ellis C · Prineville, ORBuilt 1974 · S/N 21060377 N954PWWeckbacher Paul J Jr · Inverness, FLBuilt 1981 · S/N U20606288 N959RHRd Holdings LLC · Las Vegas, NVBuilt 1978 · S/N 414A0217 N9632ZAngelone Inc · Elkhart, INS/N U20606585 N9TFBender Glenn Steven · Lovell, MEBuilt 1948 · S/N NAV-4-1396

Back to TCM Cont TSIO-520 series