Skip to content

Pratt & Whitney Canada PT6A-67B

Registered aircraft · 277

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

N100JADolce Vita Assets LLC · Saint Petersburg, FLBuilt 2007 · S/N 865 N107HMSterling Air Service LLC · Corpus Christi, TXBuilt 1999 · S/N 248 N108JCR J Young Co · Nashville, TNBuilt 2008 · S/N 883 N10FBRad Runner LLC · Newton, NCBuilt 2006 · S/N 748 N112VFVictor Foxtrot LLC · Scott City, KSBuilt 2008 · S/N 882 N1130DDevonair Enterprises LLC · Rockford, MIBuilt 2007 · S/N 823 N116SKAir Methods LLC · Greenwood Village, COBuilt 1995 · S/N 116 N11898Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 456 N1211AStar Child 3 LLC · Sanibel, FLBuilt 2005 · S/N 663 N1245XKalinin Partners LLC · Juneau, AKBuilt 2003 · S/N 496 N125PZStraight Flight Nevada Commercial Leasing LLC · Sparks, NVBuilt 1998 · S/N 209 N126ALShort Hop LLC · Bellevue, WABuilt 2007 · S/N 863 N1273ATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 603 N12DZJmp Aircraft Service LLC Trustee · Wasilla, AKBuilt 2001 · S/N 390 N146PCLmco · Vandenberg Afb, CAFirst renewal noticeBuilt 1996 · S/N 146 N14RDLiftwing Aircraft Holdings LLC · Bellevue, WABuilt 2001 · S/N 384 N175ACBank Of Utah Trustee · Salt Lake City, UTBuilt 2004 · S/N 566 N178MHRegistered aircraftBuilt 2008 · S/N 875 N17DPWde Aviation LLC · Atlanta, GABuilt 2005 · S/N 648 N18007Stancil Builders Inc · Angier, NCBuilt 2000 · S/N 377 N190ASInterport Aviation LLC · Newark, NJBuilt 2006 · S/N 727 N190PEUS Department Of The Interior · Boise, IDBuilt 1997 · S/N 190 N201LFFreedom 2026 LLC · Minneapolis, MNBuilt 1996 · S/N 147 N207STTwo Bells Aviation LLC · Rockville, MDBuilt 1994 · S/N 107 N209PBValiair Limited Co Trustee · Casper, WYBuilt 2005 · S/N 609 N214CSHinterland Holdings LLC · Anchorage, AKBuilt 2006 · S/N 766 N220JPDragonglass LLC · Denver, COBuilt 2006 · S/N 787 N224TWBedford Partners LLC · Oxford, CTBuilt 1997 · S/N 196 N226AALegacy Air 03 LLC · Grand Forks, NDBuilt 2003 · S/N 471 N227NSDolce Vita Assets LLC · Saint Petersburg, FLBuilt 2006 · S/N 715 N228JDValiair Limited Company Trustee · Casper, WYBuilt 1998 · S/N 220 N22LPAir Pilatus 22lp LLC · Spanish Fork, UTBuilt 2001 · S/N 402 N236APWestview Payroll Services Inc · Northbrook, ILBuilt 2007 · S/N 804 N238VMGuardian Flight LLC · Lewisville, TXBuilt 1998 · S/N 238 N242MA242ma LLC · Chicago, ILBuilt 2000 · S/N 306 N247LCRegistered aircraftBuilt 1999 · S/N 247 N251JJTvpx Ars Inc Trustee · North Salt Lake, UTS/N 701 N25WAir Watkins LLC · Alpharetta, GABuilt 2002 · S/N 476 N269LGCoffin Simon P · RemseckBuilt 2005 · S/N 633 N2727KRegistered aircraftBuilt 2002 · S/N 480 N273SMGuardian Flight LLC · South Jordan, UTBuilt 2002 · S/N 475 N281HSterling Air Service LLC · Corpus Christi, TXBuilt 2007 · S/N 799 N287PCBank Of Utah Trustee · Salt Lake City, UTBuilt 1999 · S/N 287 N312PCPacific Real Estate Consulting LLC · Irvine, CABuilt 1996 · S/N 141 N313NGPwc Aviation LLC · Omaha, NEBuilt 2011 · S/N 1313 N316TRTristar Leasing LLC · Poteet, TXBuilt 1996 · S/N 142 N321MWW Aviation LLC · Dover, DEBuilt 2001 · S/N 393 N323VBKickin Tires Aviation II LLC · Lake Wales, FLBuilt 2003 · S/N 513 N325FSBridger Aerospace Group LLC · Belgrade, MTBuilt 2006 · S/N 746 N326PACone Air LLC · Omaha, NEBuilt 2000 · S/N 362

Back to Pratt & Whitney Canada PT6A-67B