Service difficulty reports
1,771,708 reports of malfunctions and defects, newest first. Air carriers must report; 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' 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' 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 SWIA2025102700017Door Frame · dentedDURING REPLACEMENT OF APU INLET DOOR FRAME SUPPORT 5-OFF OVERSIZED HOLES AND DENT DAMAGE WERE FOUND BETWEEN BS 654.5 - 672.2 AT S4L AFFECTING THE STACK UP OF S4L, BS 654.5 FRAME SECTOR, MTG FITTING AND CLIP. COMPLIED WITH REO 601R-53-61-8400 REV-, DATED 2025-1SDR IPXA2025102314177Skin · crackedFOUND CRACK AT FORWARD LOWER CARGO DOOR CUTOUT AFT LOWER CORNER. C/W EO 95458-REQ1.SDR AALA202510270712Wire · brokenAIRCRAFT WAS NOT GROUNDED: SEAT MOUNTED EMERGENCY LIGHT AT SEAT ROW 20 LEFT INOPERATIVE. **SUPPLEMENTAL REPORT FOR AALA202510210712: MAINTENANCE FOUND A BROKEN WIRE UNDER THE CARPET, REPAIRED WIRE AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK WITH NO ISSUESDR CALA2025102710554Bracket · crackedFITTING BROKEN BEHIND OF ACCESS PANEL 334NB, LT ELEVATOR. REPLACED BRACKET AT LT HORIZONTAL STABILIZER BEHIND PANEL 344NB IAW SRM 51-40-02-0G-0 & SRM 51-40-05-0G-0, DWG 183A7200-5 & DWG 183A7000. REPLACED BRACKET AT LT HORIZONTAL STABILIZER BEHIND PANEL 34SDR CALA2025102710552Skin · delaminatedLEFT WING OTBD AFT FLAP DISBOND AREA L=9INCH, W=7INCH AT LOWER SKIN TRAILING EDGE OF THE O/B AFT FLAP WEDGE. CLEANED, PREPPED, PERFORMED THE PERMANENT REPAIR AND RESTORED PAINT ON LT WING OTBD AFT FLAP OWER SKIN. ALL WORK DONE IAW SRM 57-53-01-1A-4, SRM 57-5SDR DALA2025102407822Door Sill · corroded1 REPORTED BY LINARES 00705131 MSP 17OCT25 ENTR 00532877 W FWD PAX DOOR - CORROSION NOTED AROUND MULTIPLE HOLES ALONG LOWER SILL AND SILL FLOOR (M)(P) LOG-PAGE UPDATED @ 17OCT25 1800 UTC 02 CORR BY REYNOLDS 00390101 MSP 17OCT25 ATA 5331 RII: N ENTR 00532877 W SDR DALA2025102407814Skin · corrodedFWD PAX DOOR - CORROSION NOTED ADJACENT TO LOWER SKIN HOLES 14OL , 13OL,10OL, AND 2OL. SSI:53-21-23-02 (M) SEE NR FOR ADDITIONAL INFORMATION 031-0001:5331-01297- 01A/001 00340 COMPLIED WITH PRI 629106-14 REV 0, 1, 2 AND ER/A 629106-14 REV O SECTION 1. SEE LOGSDR DALA2025102407813Skin · corrodedDURING H-CHECK IN MSP, MAINTENANCE WAS ACCOMPLISHING EO WORKCARD 5331-01297-01B (SB BD500-530010 ISSUE 004). DURING MODIFICATION , MAINTENANCE REPORTED CORROSION ON THE FWD RH SERVICE DOOR SCUFF PLATE AND DISCOVERED CORROSION COMMON TO SEVERAL OF THE FASTENER SDR DALA2025102407812Frame · corrodedINSPECT FORWARD SERVICING AREA PASSENGER COMPARTMENT, WITH GALLEY AND LAVATORY REMOVED. FRAME 17 AFT HOLE 5, 7, 8 HAVE CORROSION. LOG-PAGE UPDATED @ 17OCT25 1937 UTC 02 CORR BY GILMORE 00473815 MSP 17OCT25 ATA 5321 RII: N ENTR 00532877 W SUMMARY SEE NR FOR ADDSDR DALA2025102407811Door Sill · corrodedDURING H-CHECK IN MSP, MAINTENANCE WAS ACCOMPLISHING EO WORKCARD 5331-01297-01C (SB BD500-530010 ISSUE 004). DURING MODIFICATION , THE FWD CARGO DOOR SURROUND STRUCTURE C02313004-005 LOWER SILL , AND C02312110 BOTTOM SKIN WERE FOUND CORRODED AFTER SCUFF PLATE SDR DALA2025102407805Frame · corrodedINSPECT FORWARD SERVICING AREA PASSENGER COMPARTMENT, WITH GALLEY AND LAVATORY REMOVED. FRAME 20 FWD SIDE OF FRAME HOLE 1, 4, 5, 6, 7, 8. HAVE CORROSION. LOG-PAGE UPDATED @ 17OCT25 1934 UTC 02 CORR BY GILMORE 00473815 MSP 17OCT25 ATA 5321 RII: N ENTR 00532877 SDR AALA202510245086Skin · crackedAIRCRAFT IN BASE MAINTENANCE: FATIGUE CRACK 0.25" LONG FORWARD FROM FASTENER HOLE BETWEEN FR13 AND FR141.25" FORWARD OF FR14 HALFWAY BETWEEN Z780 & Z950, MAINTENANCE REPAIRED SKIN WITH A DOUBLER IAW EA 369009 AND SRM 53-11-11-300-041.SDR DALA2025102307765Skin · misrepairedSHIP 3314 AN EXISTING REPAIR INSTALLED ON THE RHW #4 SLAT WAS FOUND NOT MEETING A330 SRM 57-40-00-300-007 DISTANCE REQUIR EMENTS. CORRECTIVE ACTION: REPAIRED PER ERA 629693-14. (1257683)SDR CALA2025102310431Fitting · crackedNR 1 PYLON AFT TRAILING EDGE FAIRING O/B FITTING CRACKED. REMOVED AND REPLACED NR 1 PYLON T/E FAIRING IAW SRM 51-40-02 AND DWG 313A2700 REV-.SDR CALA2025102310430Intercostal · crackedMAIN CABIN FWD WET AREA INTERCOSTAL UPPER ANGLE CRACKED AT LBL 10" BETWEEN STA 380-400. INSTALLED NEW MAIN CABIN FWD WET AREA INTERCOSTAL UPPER ANGLE AT LBL 10" BETWEEN BS 380-400 IAW SRM 51-40-02-0G-0 & DWG 143A5400,SDR SWAA2025102225160Lamp · inoperativeEMERGENCY EXIT SIGN ON FWD LAV HAS ONE LAMP INOPERATIVE. REMOVED; REPLACED AND PERFORMED GOOD OPS CHECK OF THE EMERGENCY EXIT SIGN ON FWD LAV IAW AMM 33-51-01-960-801<BR><BR>COMPLETED TASK CARD.SDR WX0A2025102232607Oil System · leaking(AIRCRAFT NOT GROUNDED) FA'S REPORT DIRTY SOCK SMELL FWD CABIN IN THE DESCENT PHASE ROW 5 AND FORWARD, DID NOT SMELL ANY ODOR IN THE FLIGHT DECK / (RESOLVED ON W/O: 534158 TASKCARD: NR-00001 ) LEVEL II DECONTAMINATION COMPLETED. FOUND LEAK AT OIL COOLER FAN ASDR DALA2025102207718Battery Pack · inoperativeCREW REPORT EXIT SIGN F/C INOP (EMERRGENCY LIGHT). FOUND BATTERY PACK B5-259 INOP, REPLACED BATTERY PACK. OPS CHEC K GOOD, IAW B717AMM 33-51. (7585679)SDR DALA2025102207711Release Mech · out of positionIN REFERENCE AMDS 5352-4002 DURING INSTALL TAILCONE SLIDE WAS FOUND TAILCONE RELEASE MECHANIS CAM OUT POSITION. TAILCONE RELEASE MECHANISM CAM WAS ADJUSTED PER AMM 53-52-03 (1257600)SDR DALA2025102007653Motor · faultedCREW ELECTED DE DUE TO TE DISAGREE INDICATION DURING CRUISE. C/W QRH AND LANDED UNEVENTFULLY. LUBRICATED FLAP SYSTEM AND REPLACED TE ALT PDU MOTOR. FLAPS OPS GOOD IN HYD AND ALT ELEC.(7086116)SDR SCNA20251022400Carpet · peelingFORWARD ENTRY BASEBOARD CARPET IS PEELING OFF WALL, PLASTIC IS A TRIP HAZARD. OPENSDR DALA2025102207706Microphone · inoperativeFO O2 MASK MIC INOP. C/A: R&R'D FO'S 02 BOX OPS CK & LEAK CK GOOD PER AB320 AMM 35-10. (LP: 7372856)SDR ASAA2025101761733Channel · damagedDENT AND GOUGE ON RBL 8.10 RAIL-CHANNEL STRUCTURE UNDER AFT CARGO FLOOR PANEL STA727I + 6.5". GROUNDED - YES. TRIMMED DAMAGED RAIL SECTION, FABRICATED AND INSTALLED REPAIR CHANNEL REF SRM 53-00-53 REPAIR 2, EA 737-53EA-29439.SDR ASAA2025101761681Lens · detachedFA REPORTS AFT GALLEY L2 DOOR EXIT SIGN FELL OFF. GROUNDED - YES. REMOVED AND REPLACED L2 DOOR EMERGENCY EXIT SIGN LENS COVER AS REQUIRED. TAPE REMOVED. THIS CLEARS THIS PLT.SDR SWAA2025102125130Handle · looseFWD ENTRY DOOR UPPER ASSIST HANDLE LOOSE. RESECURED FWD ENTRY DOOR UPPER ASSIST HANDLE REF AMM 20-50-11.SDR SWAA2025102125098Seal · crackedLEFT HORIZONTAL STABILIZER FORWARD UPPER SLIDING SEAL CRACKED. R & R LEFT HORIZONTAL UPPER SLIDER IAW AMM CH.53-31-31. INSPECTED LEFT HORIZONTAL UPPER SLIDER PER AMM 53-31-31.SDR SWAA2025102125084Battery Pack · inoperativeALL EMERGENCY LIGHTS AFT OF STA 520 RIGHT/LEFT ARE INOP NEED REPLACE BATTERY PACKS M1673 M1672. PERFORMED TROUBLESHOOTING ALL EMERGENCY LIGHTS AFT OF STA 520 RIGHT/LEFT ARE INOP; FOUND BATTERY PACKS M1672; M1673; DO NOT WORK PROPERLY. REMOVED AND REPLACED BASDR SWAA2025102126408Battery Pack · inoperativeALL EMERGENCY LIGHTS AFT OF STA 520 RIGHT/LEFT HAND ARE INOP NEED REPLACE BATTERY PACKS M1673 M1672. PERFORMED TROUBLESHOOTING ALL EMERGENCY LIGHTS AFT OF STA 520 RIGHT/LEFT HAND ARE INOP; FOUND BATTERY PACKS M1672; M1673, DO NOT WORK PROPERLY. REMOVED AND RSDR SWAA2025102125385Light · inoperativeOUTSIDE EMERGENCY LIGHT AFT OF L1 DOOR INOPERATIVE. REPLACED AND PERFORMED GOOD INSTALLATION TEST OF SLIDE EMERGENCY LIGHT AT AFT L1 DOOR IAW AMM 33-51-04-960-801.SDR DALA2025102107703Battery Pack · inoperative(LOG 7884326) EMERGENCY AISLE LIGHTS INOPERATIVE ROW 18-24. REPLACED BATTERY PER AMM 33-51-06. OPS CHECKED GOOD.SDR CVGA20251021002Exhaust Stack · overtempEVIDENCE OF OVERHEATING ON RIGHT ENGINE IN FRONT OF INBOARD EXHAUST STACK. DECLARED EMERGENCY. GVI FOUND ORANGE STRIPING VISIBLE ON LOWER TORQUE MANIFOLD FITTING. REMOVED ORANGE TORQUE STRIPING AND APPLIED BLUE TORQUE STRIPING TO FITTING IAW KA SERIES STANDARDSDR AALA202510214860Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R2 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202510211558Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L3 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202510210330Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202510210942Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202510210709Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202510214964Light · no testAIRCRAFT WAS GROUNDED: SEAT ROW 28 OVERHEAD EMERGENCY LIGHT INOPERATIVE. REPLACED LIGHT 208WL AND ACCOMPLISED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-11.SDR AALA202510214837Deu · fault messageAIRCRAFT WAS GROUNDED: CHECK DOOR PRESSURE / CHECK SLIDE PRESSURE MESSAGE ON FLIGHT ATTENDANT PANEL ILLUMINATED. MAINTENANCE FOUND CFDS FAULT MESSAGE FOR DEU-B, REPLACED DEU-B AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 23-73-47.SDR AALA202510210712Light · inoperativeAIRCRAFT WAS NOT GROUNDED: SEAT MOUNTED EMERGENCY LIGHT AT SEAT ROW 20 LEFT INOPERATIVE. OPENSDR AALA202510211830Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202510216473Bottle · low pressureAIRCRAFT WAS GROUNDED: R2 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202510213091Bottle · low pressureAIRCRAFT WAS GROUNDED: L4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR YENA2025102101046Valve · brokenFLT#2220, LHR-JFK. (ETOPS) (AIRCRAFT PERFORMED AN AIR RETURN TO LHR) "AIR ENG 2 BLEED FAULT; FOUND FAN AIR VALVE ROD BROKEN REMOVED AND REPLACED FAN AIR VALVE REF AMM 36-11-54 ENG RUN OK NO FURTHER FAULTS NOTED A/C OK FOR SERVICE."SDR YENA2025102101044Ecs · contaminatedFLT#48, TPA-LGA. "ODOR EVENT-DIRTY SOCKS SMELL AFT GALLEY AND BACK FEW ROWS I WAS TOLD SLIGHTY BETTER WITH PACK 1 OFF THAN IT CAME BACK; C/W INFO NOTICE 2017-T015L. PERFORMED T/S IAW TSM 05-50-00-810-831-A. DETERMINED TO BE A TYPE 1 (APU). APU HAS BEEN PLACED SDR CALA2025102110356Light · inoperativeFOUND SEAT 44D & 54D EMER LT INOP. SEAT 44D EMER LIGHT ASSY REPLACED.LIGHT CHECK SATIS.RESTORED TO ORIGINAL CONFIG. SEAT 54D EMERGENCY LIGHT ASSY REPLCED AS PER B787-A-33-51-06-00A-520A-A/720A-A.OPERATIONAL CHECK ON SEAT 54D EMERGENCY LIGHT PASSED.SDR CALA2025102110351Packing · damagedHYD B RSVR LO LVL AT FL200 FOUND LEAK AT BLUE PRESSURE SWITCH 2074GJ, SUSPECT SEAL LEAKING. BLUE SYSTEM PRESSURE SWITCH WAS FOUND LOOSE AND HAD A CUT O-RING. INSTALLED A FRESH SEAL, REINSTALLED THE SWITCH, AND A PRESSURE CHECK CONFIRMS THERE IS NO MORE LEAK. SDR CALA2025102110350Egt Indication · false activationRTO 90 KTS. L EGT 807 DEG. NORMAL TEMP AT IDLE. BRAKE MAX TEMP BTMS 5. BRAKE TEMP BACK TO NORMAL AT THIS TIME. FOLLOWED FIM 71-05 FAULT TREE 819. LT ENGINE EGT EXCEEDENCE WITHIN LIMITS PER FIM 71-05 FAULT TREE 824, NO PROCEDURE NECESSARY. AS PRECAUTION LESDR CALA2025102110337Housing · brokenEXIT PATH LIGHT HANGING IN AISLE AT 33C RESECURED LIGHT AT 33C TO SEAT. COMPLIED WITH DEFERRAL PROCEDURES AND INSTALLED PLACARD MEL 3351G APPROVED. MX REPORT SINGLE WHITE LIGHT INOP. SECURED DEFERRED. REMOVED AND REPLACED SEAT 33C EMERGENCY LIGHT HOUSING REFSDR CALA2025102110336Fitting · damagedEA-3271-01017-001 TAIL SKID ASSEMBLY SUPPORT FITTING REPLACEMENT UNDER WORK INSTRUCTIONS STEP 7 (B)(4) PRE-EXISTING HOLE AT .250. COMPLETED ALL STEPS PER UAL ECRA 5380-01430 REV- FOR REPAIR.SDR CALA2025102110335Skin · corrodedEXTERNAL FUSELAGE SKIN FR34 STR 43 IS CHAFFED. PERFORMED INTERNAL & EXTERNAL DOUBLER REPAIR PER HAECO REO L2558 5 / ECRA 5321-02170. GENERATE DIP ACCOMPLISH A PERMANENT REPAIR AT FR34 STGR 41LH - 41RH FUSELAGE SKIN PANEL PER PART 3 OF THE L ATEST REVISION OF E