Pratt & Whitney PW2037
Service difficulty reports · 12,810
Newest first. General aviation reporting is voluntary.
Query with SQL
duckdb -csv -c "SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE engine_model_key = 'PW2037' ORDER BY difficulty_date DESC"
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 sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE engine_model_key = 'PW2037' ORDER BY difficulty_date DESC
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.
SDR 2004UALA01059Frame · dentedAFT PIT STA 1440 FRAME DENTED AT STR 25L. INSTALLED J ANGLE REPAIR.SDR 2004UALA01066Skin · dentedEXTERIOR FUSELAGE SKIN AT STA 620 ABOVE STR 16L HAS 2 EACH DENTS. REMOVED EXISTING SKIN REPAIRS. REMOVED PORTION OF DAMAGED SKIN PANEL. ACCOMPLISHED A PARTIAL SKIN PANEL REPLACEMENT. SKIN PANEL SPLICED BY DOUBLER STRAPS AND TRIPLERS.SDR 2004UALA01114Frame · damagedFRAME AT BS 1400 STR 26L IS DAMAGED. CARGO PIT FRAME DAMAGE DUE TO CARGO HANDLING. FRAME SECTION REPLACED.SDR 2004UALA01052Frame · dentedAFT PIT FRAME DENTED AT STA 1540 BETWEEN STRINGERS 25L & 26L. INSTALLED NESTED J ANGLE REPAIR.SDR 2004UALA01053Frame · dentedAFT PIT FRAME DENTED AT STA 1600 ABOVE STR S25L. INSTALLED NESTED ANGLE REPAIR.SDR 2004UALA01054Frame · dentedAFT PIT FRAME DENTED AT STA 1580 ABOVE STRINGER S26L. INSTALLED NESTED ANGLE REPAIR.SDR 2004UALA01055Frame · dentedAFT PIT FRAME INNER FLANGE DENTED AT BS 1400 ABOVE STR 26L. INSTALLED J ANGLE REPAIR.SDR 2004UALA01056Frame · dentedAFT PIT FRAME INNER FLANGE DENTED AT BS 1320 ABOVE STR 26R. INSTALLED J ANGLE REPAIR.SDR 2004UALA01057Bear Strap · corrodedAFT PIT FUSELAGE SKIN AND BEAR STRAP WERE CORRODED. CORROSION WAS REMOVED AND EXTERNAL DOUBLER REPAIR WAS ACCOMPLISHED.SDR 2004UALA01107Frame · dentedAFT PIT FRAME DENTED AT STA 1480 BETWEEN STRINGERS S25L & S26L. REMOVED DAMAGED PORTION OF THE FRAME CAP. INSTALLED NESTED J ANGLE REPAIR.SDR 2004UALA01108Frame · dentedAFT PIT FRAME DENTED AT RT SIDE BETWEEN STRINGERS S25R & S26R. REMOVED DAMAGED FRAME CAP AND INSTALLED NESTED J ANGLE REPAIR.SDR 2004UALA01116Socket · faultyR-1 EXTERNAL EMERGENCY SLIDE ILLUMINATION LIGHT HAS A FAULTY SOCKET ASSEMBLY. REPLACED FAULTY SOCKET. PERFORMED SUCCESSFUL OPERATION CHECK OF LIGHT.SDR 2004UALA01117Wire · brokenR-2 DOOR EEL EXIT MARKER WIRE IS BROKEN. REPAIRED WIRE REF GNMM 2-0-15-001 AND OPS CHECKED.SDR 2004UALA01118Light · inoperativeR-2 DOOR EMERGENCY LIGHTS INTERIOR AND EXTERIOR INOP. REPLACED BATTERY PACK AND OPS CHECKED REF MM 33-51-00.SDR 2004UALA01049Frame · dentedAFT PIT FRAME INBOARD FLANGE DENTED AT STA 1520 ABOVE STR 26L. TYPICAL CARGO PIT DENT DAMAGE DUE TO CARGO LOADING. INSTALLED J ANGLE REPAIR.SDR 2004UALA01050Frame · dentedAFT PIT FRAME INNER FLANGE DENTED AT BS 1440 INBOARD OF STR 26L. TYPICAL CARGO PIT DENT DAMAGE. INSTALLED J ANGLE REPAIRS.SDR 2004UALA01051Frame · dentedAFT PIT FRAME INBOARD FLANGE DENTED AT BS 1320 BETWEEN STR 25L AND 27L. INSTALLED J ANGLE REPAIR.SDR 2004UALA01109Frame · dentedAFT PIT FRAME DENTED AT STA 1420 BETWEEN STRINGERS 25L & 26L. TYPICAL CARGO PIT DENT DAMAGE DUE TO CARGO LOADING. REMOVED DAMAGED FRAME CAP AND INSTALLED NESTED J ANGLE REPAIR.SDR 2004UALA01048Floorbeam · damagedCABIN FLOORBEAM CAP AT BS 324 RBL 44, RBL 48, AND RBL 62 IS CORRODED. SUPPLEMENTAL DATA UPDATE, TYPICAL FLOORBEAM CORROSION. REMOVED DAMAGE AND INSTALLED REPAIR ANGLES TO FLOORBEAMS.SDR 2005UALA00406Floorbeam · damagedFLOORBEAM AT STA 324 RBL 60 IS DAMAGED. MAJOR REPAIR ACCOMPLISHED. FABRICATED & INSTALLED FLOORBEAM CHORD SPLICE REPAIR.SDR 2004UALA01110Floorbeam · corrodedCABIN FLOORBEAM STA 1640 HAS CORROSION RBL 44 TO 52, UPPER CAP. CORRODED SECTION REMOVED AND A FLOORBEAM DOUBLER REPAIR WAS INSTALLED.SDR 2004UALA01115Skin · dentedRIGHT FWD FUSELAGE DENTED AND SCRATCHED APPROX 1 FT AFT OF JACKING POINT. REMOVED EXISTING TIME-LIMITED SKIN DOUBLER AND REPLACED WITH NEW DOUBLER AND FILLER REPAIR.SDR 2004UALA01119Floorbeam · buckledCARGO PIT FLOOR JUST IN FRONT OF DOORWAY IS SEVERELY BUCKLED.SDR 2004UALA01029Plate · corrodedAFT GALLEY AREA RT SIDE STA 1681-1691 RBL 52 GALLEY DECK PLATE UPPER SURFACE CORRODED. FABRICATED & INSTALLED DOUBLER REPAIR.SDR 2004UALA01030Floorbeam · corrodedCABIN FLOORBEAM CAP AT BS 310 CORRODED RBL 44. FABRICATED & INSTALLED NESTED ANGLE REPAIR WITH FILLERS & SHIMS.SDR 2004UALA01037A/C Pack · smokeCREW REPORTS SMOKE IN CABIN, ISOLATED TO RT PACK. ACM ON RT PACK HOT AFTER 15 MINS SHUTDOWN POSSIBLY DUE TO A FROZEN ACM. REPLACED ACM.SDR 2004UALA01040Proximity Sensor · inoperativeDOORS 2L AND 2R ARMED LTS DO NOT COME ON WITH DOORS ARMED. GIRT BAR ANN LIGHT L406 FOR DOOR 2R FOUND SHORTED - REPLACED LIGHT. 2R FORWARD AND REAR PROXIMITY SENSORS FOUND BAD - BOTH SENSORS REPLACED.SDR 2004UALA01033Slide · will not testEMERGENCY ESCAPE SLIDE 2 WILL NOT TEST. CYLINDER ASSEMBLY TEMPERATURE COMPENSATED PRESSURE SWITCH (TCPS) WAS DETERMINED TO HAVE BEEN DAMAGED DUE TO HANDLING.SDR 2004UALA01024Warning Light · illuminatedAPU SHUTDOWN IN DUE TO OIL QTY MESSAGE AND RIGHT GENERATOR OFF EICAS MESSAGE.SDR ASMF200411004Blade · nickedDURING OVERNIGHT SERVICE, BOROSCOPE INSPECTION WAS PERFORMED ON RIGHT ENGINE AND NICKS WERE DETECTED ON ONE BLADE OF 11TH STAGE, OUT OF LIMITS IAW MM 72-00-00. RIGHT ENGINE WAS REPLACED IAW MM 71-00-00, TEST CORRECT.SDR 2004UALA01017Floor Support · corrodedMAIN CABIN FLOOR SUPPORT CORRODED AT STA 1660 TO 1680 LBL 50 TO LBL 55. TYPICAL FLOOR STRUCTURE CORROSION. MAJOR REPAIR ACCOMPLISHED. REPLACED FLOOR SUPPORT.SDR 2004UALA01018Floor Support · corrodedMAIN CABIN FLOOR SUPPORT CORRODED AT STA 1640 TO 1660 LBL 50 TO LBL 55. TYPICAL FLOOR STRUCTURE CORROSION. REPLACED FLOOR SUPPORT.SDR DL75K041013Fan · failedAIRCRAFT DIVERTED WITH SMOKE IN CABIN. FOUND THE EQUIPMENT COOLING SUPPLY FAN BAD. REPLACED FAN.SDR 2004UALA01010Skin · puncturedPUNCTURED HOLE IN FUSELAGE AT STA 1862 UPPER LT SIDE. PUNCTURE DAMAGE. FABRICATED & INSTALLED REPAIR DOUBLER AND FILLER.SDR 2004UALA01003Brace · damagedNR 2 PYLON DIAGONAL BRACE HOLE BORES WERE FOUND MISLOCATED. ESTABLISHED CORRECT LOCATION OF DIAGONAL BRACE HOLE. MACHINED AND INSTALLED OVERSIZE BUSHING.SDR 2004UALA01004Frame · dentedSTATION 1500 STRINGER 25L FRAME DENTED AFT PIT. TYPICAL CARGO PIT DENT DAMAGE DURING CARGO LOADING. CUTOUT DAMAGE AND INSTALLED DOUBLER REPAIR.SDR 2004UALA00989Frame · dentedAFT PIT BODY FRAME DENTED AT STA 1340 BETWEEN STRINGERS 25R & 26R. MAJOR REPAIR ACCOMPLISHED. TYPICAL CARGO PIT DENT DAMAGE FROM CARGO LOADING. TRIMMED OUT DAMAGE & FABRICATED J-ANGLE REINFORCEMENT REPAIR.SDR 2004UALA01002Stringer · gougedCABIN STRINGER GOUGED ON LWR SIDE AT STA 620 STR 16L. DAMAGED DURING REPAIR TO SURROUNDING STRUCTURE. BLENDED OUT DAMAGE, FABRICATED HAT CHANNEL REPAIR.SDR DL757040995Fitting · damagedREPAIR OF OVERSIZED HOLE IN NR 2 PYLON SIDE LINK FITTING. REPAIRED IAW VA 69201AD.SDR 2004UALA00991Frame · dentedFRAME IS DENTED AT STATION 1440, STRINGER 25L, UPPER IB FLANGE. TYPICAL CARGO PIT DENT DAMAGE DUE TO CARGO LOADING. INSTALLED NESTED J-ANGLE REPAIR.SDR 2004UALA00992Skin · gougedFWD PIT DOOR EXTERNAL SKIN AFT BOTTOM EDGE GOUGED. FABRICATED & INSTALLED REPAIR DOUBLER.SDR 2004UALA00993Floorbeam · corrodedAFT MAIN CABIN FLOORBEAM CORRODED, BS 1660 MID-SECTION DOOR R-4, LOWER SILL. INSTALLED T-CAP SPLICE AND ANGLE REPAIR.SDR 2004UALA00990Floorbeam · corrodedAFT MAIN CABIN FLOORBEAM CORRODED BS 1640 JUST FWD OF R-2 DOOR LOWER SILL. MAJOR REPAIR ACCOMPLISHED. TYPICAL CORROSION DAMAGE. FABRICATED & INSTALLED T-CAP SPLICE SECTION AND REPAIR ANGLES.SDR 2004UALA00985Frame · dentedAFT CARGO PIT FRAME AT BS 1340 AND STR 26L DENTED UPPER INBD FLANGE. TYPICAL DENT DAMAGE FROM CARGO LOADING. REPAIRED FRAME WITH NESTED J-ANGLE REPAIR.SDR 2004UALA00986Sill · corrodedBS 1380-1442 RT AND STR 26R, DOOR SILL IS CORRODED AT TOP AND BOTTOM.SDR 2004UALA00987Pressure Panel · corrodedMAIN CABIN STA 1700 AFT PRESSURE DECK CORRODED. MAJOR REPAIR ACCOMPLISHED. TYPICAL CORROSION DAMAGE. FABRICATED & INSTALLED REPAIR DOUBLER.SDR AALA20041069Cable · disconnectedEMERGENCY FLOOR LIGHTING SYSTEM PLASTIC COVER BROKEN AND LIGHTING TRACK PULLED OUT AT ROW 12. REPLACED CONDUCTOR CABLE FROM ROW 7 TO ROW 16 FOR EMERGENCY FLOOR TRACK LIGHTING. ALSO REPLACED LIGHT ELEMENT AND SECURED COVER FOR EMERGENCY LIGHT AT ROW 12. SYSTSDR 2004UALA00977Crease Beam · corrodedCABIN FLOOR LT CREASE BEAM INNER CHORD ANGLE CORRODED STA 676 TO STA 680, LBL 64. FABRICATED & INSTALLED NEW CHORD ANGLE.SDR 2004UALA00984Proximity Sensor · malfunctionedDOOR 1L SLIDE LIGHT WILL NOT COME ON WHEN DOOR IS ARMED. REPLACED DEFECTIVE GIRT BAR PROXIMITY SENSOR.SDR 2004UALA00970Vibrator · malfunctionedFLIGHT DIVERTED TO ORD WITH A STANDBY ALTIMETER VIBRATOR.
Back to Pratt & Whitney PW2037