Skip to content

Pratt & Whitney Canada PT6A-64

Registered aircraft · 95

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

N123ZCJasper Industries Ltd · Mokena, ILBuilt 2002 · S/N 229 N12MAForest Hill Management LLC · Forest Hill, MDBuilt 2005 · S/N 318 N148UMUnverferth Manufacturing Co Inc · Kalida, OHBuilt 2004 · S/N 297 N160RMLjwms Partners Inc Trustee · Wilmington, DEBuilt 1992 · S/N 63 N180MFPapa Sierra Holdings LLC · Dover, DEBuilt 2000 · S/N 172 N183TBBluesky Tb Corp Trustee · Wilmington, DEBuilt 1992 · S/N 3 N188SJDaxen Logistic LLC · Chino, CABuilt 1993 · S/N 69 N210CLPark Rapids Avionics Inc · Park Rapids, MNBuilt 2004 · S/N 303 N217TMRegistration Pending · Boise, IDRegistration pendingBuilt 2001 · S/N 217 N227CHBlue Altitude LLC · Raleigh, NCBuilt 2005 · S/N 334 N265BNN265bn LLC · Waterloo, NEBuilt 2003 · S/N 240 N278MP277wt LLC · Jackson, TNBuilt 2003 · S/N 256 N300AZBka Leasing LLC · Kennett, MOBuilt 2004 · S/N 300 N302JGJag2021 Inc Trustee · Wilmington, DEBuilt 2004 · S/N 302 N317WCCambusmoon Inc · Glenview, ILBuilt 2005 · S/N 317 N402KWSoutheastern Tank & Tower Inc · Lake Park, GABuilt 2000 · S/N 180 N418AZafl LLC · Bloomington, INBuilt 2004 · S/N 292 N428ZGxy Transport LLC · Greeley, COBuilt 2004 · S/N 289 N479HNspace LLC · Spicewood, TXBuilt 2005 · S/N 344 N488PTBot II Logistics LLC · Kodak, TNBuilt 1991 · S/N 17 N48UMZafl LLC · Bloomington, INFirst renewal noticeBuilt 2004 · S/N 299 N495PCAviation Tools Inc · Bedminster, NJBuilt 2003 · S/N 261 N51YLTbm 330 Inc Trustee · Wilmington, DEBuilt 2005 · S/N 330 N522ATHedley Kenneth G · Glen Ellyn, ILBuilt 1999 · S/N 145 N550NPMissouri Aviation Services LLC · Perryville, MOBuilt 2002 · S/N 219 N626DMStraight Aero LLC · Cleveland, OHBuilt 2000 · S/N 170 N6272BH&S Aircraft Holdings Inc · Hazelwood, MOBuilt 2005 · S/N 328 N693MACurrie Partners Inc · San Diego, CABuilt 2004 · S/N 293 N700ADRkefs LLC · Big Lake, MNS/N 250 N700BFFoxtrot Transportation LLC · Saint Charles, MOBuilt 1992 · S/N 53 N700BMMason Amelia Holdings LLC · Boerne, TXBuilt 2003 · S/N 270 N700BQMjm Aviation LLC · Fowler, CABuilt 2004 · S/N 298 N700CLJupiter Equipment Leasing Inc · Garland, TXBuilt 2003 · S/N 266 N700DMClearance Clarence LLC · Lubbock, TXBuilt 2004 · S/N 305 N700DZTwo Oscar Three LLC · Saint Helena, CABuilt 2004 · S/N 295 N700EJLyv 26 Inc Trustee · Wilmington, DEBuilt 2004 · S/N 291 N700ENLantech.Com LLC · Louisville, KYBuilt 2005 · S/N 329 N700EVAl & Zal Corp · Wilmington, DEBuilt 2004 · S/N 287 N700EZDbw Aviation LLC · Anaheim, CABuilt 2004 · S/N 307 N700FPGa Holdings LLC · Moffett Field, CABuilt 1999 · S/N 142 N700GEArdmore Aviation LLC · Russell Twp, OHBuilt 2003 · S/N 255 N700GKPeterson Air LLC · Austin, TXBuilt 2005 · S/N 320 N700GTJdr Logitstics LLC · Tucson, AZBuilt 2003 · S/N 276 N700GVE6 Aviation LLC · Scott City, KSBuilt 2004 · S/N 290 N700HLDoss Michael G · Spicewood, TXFirst renewal noticeBuilt 2004 · S/N 281 N700JVBouliaga Fly Inc Trustee · Wilmington, DEBuilt 2003 · S/N 257 N700KHHttrr LLC · Austin, TXBuilt 2003 · S/N 274 N700LGJackson Aviation Inc · Louisville, MSBuilt 2003 · S/N 264 N700LTEvans Rock Aviation LLC · Morehead City, NCBuilt 2005 · S/N 316 N700NDGriffin Aero LLC · Fargo, NDBuilt 2005 · S/N 335

Back to Pratt & Whitney Canada PT6A-64