Pratt & Whitney Canada JT15D-4 series
Registered aircraft · 357
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 ('52112')
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 ('52112')
ORDER BY n_numberRun 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.
N100DSCascade Peaks Aviation LLC · Springfield, ORN102DRCloud 9 LLC · Lafayette, LAN102HBBuzz-Air Of Indiana Inc · Michigan City, INN103HCEstar Aerospace Corp · Columbus, OHN106SRSafari Intl LLC · Lewes, DEN107EEBlandco LLC · Greenville, SCN109GAFinancial Mistake Air LLC · Uvalda, GAN109JCL&F Aviation LLC · Dallas, TXN10EGJarcav LLC · The Woodlands, TXN10LYAir & Water Research Corp · Wilmington, DEN10TCGardner Aviation LLC · Hot Springs, ARN111AFWings Aloft Inc · Portland, ORN111GJMalik Hassan · Richfield, OHN111LJSourek Trail Co Inc · Barberton, OHN111SGAir Orlando Helicopters And Leasing · New Smyrna Beach, FLN1163MNew World Aviation LLC · Edinburg, TXN116KCRa Aviation LLC · Dover, DEN1200NCoulson Aviation (USA) Inc · Portland, ORN121HLAircraft Holding Solutions LLC Trustee · Newark, DEN121KMWings By Dkw LLC · Lake Charles, LAN121MJIal Corp · Lewes, DEN123TLN919cs LLC · Colts Neck, NJN1249PTrns Solutions LLC · Lewes, DEN1250VAquila Air LLC · Cincinnati, OHN1252DAeroelite Aviation LLC · Columbia, MON12549Surdex Corp · Chesterfield, MON1255KCypress Aircraft Sales LLC · Clermont, FLN125RGAero South Florida Corp · West Palm Beach, FLN127CLWyoming Aviation LLC · Sheridan, WYN127JMN127jm LLC · Clovis, NMN12JEProfessional Pilot Training Inc · Eagle Lake, TXN14RM29foxtrot LLC · Wilmington, DEN153TN153t LLC · Kalispell, MTN163JN163j LLC · Smithfield, NCN168ESNext Generation Aviation LLC · Beloit, WIN16PLSolitaire Development LLC · Temecula, CAN16RPRose Aviation LLC · Sarasota, FLN16TSCypress Aircraft Sales LLC · Clemont, FLN173AAInterstate Health Solutions LLC · Orlando, FLN174DRIal Corp · Lewes, DEN177RJL&S Enterprises LLC · Daytona Beach, FLN181EBSportsmed Aviation LLC · Gulf Breeze, FLN181GMid South Agricultural Products Inc · Lafayette, LAN18HJFanac LLC · Palestine, TXN191TFCci Air LLC · Gary, INN197PRGoodnights Spruce Goose LLC · Harmony, NCN1SVJtl Leasing Co LLC · Kalispell, MTN200NCMidwest Jet LLC · Lynd, MNN204CFCorporate Flight Inc · Waterford, MIN204PMDodson International Parts Inc · Rantoul, KS
Back to Pratt & Whitney Canada JT15D-4 series