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 SWAA2025091514491Unknown · odorF/AS REPORT UNUSUAL SMELL IN THE AFT GALLEY. TROUBLESHOT IAW FIM 21-00 TASK 806, UNABLE TO DUPLICATE UNUSUAL SMELL IN AFT GALLEY. INSPECTED AFT CABIN EQUIPMENT, RECIRCULATION FANS; LIGHT BALLASTS, AND GALLEY EQUIPMENT. NO LEAKS OR DEFECTS FOUND TO CAUSE UNUSDR SWAA2025091514457Strap · brokenSEAT 16C WEB STRAP BROKEN. REMOVED AND REPLACED IAW CMM 25-23-60-NG.SDR SWAA2025091514415Battery · not seatedLEFT SIDE INBOARD FLASHLIGHT IN AFT GALLEY INOPERATIVE. OK TO CONTINUE PER MEL 25-12-01 SP1B. REPLACED BATTERY, NO HELP. RESEATED INTERNAL BATTERY AND REATTACHED FLASHLIGHT TO CHARGING PORT IAW 25-64-00.SDR SWAA2025091514505Battery · no testFORWARD GALLEY FLASHLIGHT NOT TESTING. R & R FWD GALLEY FLASHLIGHT BATTERY INBD IAW AMM 25-64-00. CHECKS OK.SDR SWAA2025091514396Lamp · inoperativeAFT ENTRY DOOR ON THE LEFT SIDE EMERGENCY LIGHT INOPERATIVE. RELAMPED AFT ENTRY DOOR OUTER EMERGENCY LIGHT IAW AMM 33-51-04. OPS CHECK GOOD.SDR SWAA2025091514184Bulb · inoperativeL1 LOWER FWD EMERGENCY EXIT LIGHT HAS BULB OUT. REMOVED AND REPLACED L1 LOWER FWD EMERGENCY EXIT LIGHT BULB IAW AMM 33-51-01-960-801.SDR SWAA2025091514540Cover · missingEXIT ROW; RIGHT SIDE; EXIT PLACARD MISSING. REPLACED EMERGENFCY LIGHT COVER IAW AMM 33-51-01.SDR SWAA2025091514225Bracket · crackedRIGHT WING LOWER PANEL 651DB O/B FWD PANEL SUPPORT BRACKET CRACKED. REPLACED SUPPORT BRACKET IAW SRM 51-40-02.SDR SWIA2025091500013Hose · faultedHYD 3 LO PRESS CAUTION MSG. CHECKED HYDRAULICS PAGE AND SHOWED 0 % FLUID REMAINING. RAN QRH AND DIVERTED TO PHX AND LANDED WITHOUT INCIDENT. TOWED INTO GATE. (FLIGHT 6510 - FILED CLOSED) PLEASE REFERENCE AML 1703109 FOUND HYD HOSE IN BELLEY FARING NO.320 ONSDR AALA202509153247Battery · dischargedAIRCRAFT WAS GROUNDED: R4 DOOR AFT FACING F/A SEAT EMERGENCY FLASHLIGHT WON'T PRESS-TO-TEST. MAINTENANCE REPLACED BATTERY PAC R4 DOOR AFT FACING F/A SEAT EMERGENCY FLASHLIGHT IAW AMM 25-64-00.SDR DALA2025091506789Skin · not reportedCONFIRM DT EVALUATION FOR POSSIBLE FCS REPAIR EXTERNAL SKIN LOCATED BT W FR 5 TO FR 6 AT THE LAP SEAM AND 5 INCHES BELOW LH SIDE STRINGER L OWER FUSELAGE. COMPLIED WITH ER/A 574394-14. (1197223).SDR DALA2025091506788Support Fitting · corrodedCORROSION ON FITTING SUPPORT THE SPHERICAL BEARING TRACK 2 INBD FLAP LT WING. COMPLIED WITH ER/A 628405-14. (1197264).SDR DALA2025091506782Elec Connector · brokenBROKEN BACKSHELL ON ELECTRICAL CONNECTOR 205WLA AT PASSENGER CABIN. REPLACED BACKSHELL ON ELECTRICAL CONNECTOR 205WL-A AT PASSENGER CABIN IAW FAM AWM 33-51-02 AND IAW AIRBUS ESPM20-44-11. (1197407).SDR DALA2025091506781Window Post · crackedCRACK INDICATION ON RH WINDSHIELD CENTER POST UPPER ATTACHMENT AREA UPPER CORNER RADIUS. COMPLIED WITH ER/A 628084-14AD. (1197373).SDR DALA2025091506780Window Post · crackedCRACK INDICATION ON RH CONTINUITY FITTING AT WINDSHIELD CENTER POST LO WER ATTACHMENT AREA. COMPLIED WITH ER/A 628127-14AD. (1197365).SDR DALA2025091506779Window Post · crackedCRACK INDICATION ON RT WINDSHIELD CENTER POST UPPER ATTACHMENT AREA UPPER CORNER RADIUS. COMPLIED WITH ER/A 628084-14AD. (1197362).SDR DALA2025091506778Window Post · crackedCRACK INDICATION ON RT WINDSHIELD CENTER POST LOWER ATTACHMENT AREA L OWER CORNER RADIUS. COMPLIED WITH ER/A 628084-14AD. (1197182).SDR DALA2025091506777Window Post · crackedCRACK INDICATION ON LT WINDSHIELD CENTER POST LOWER ATTACHMENT AREA LOWER CORNER RADIUS. COMPLIED WITH ER/A 628084-14AD. (1197175).SDR DALA2025091506776Window Post · crackedCRACK INDICATION ON LH WINDSHIELD CENTER POST UPPER ATTACHMENT AREA UPPER CORNER RADIUS. COMPLIED WITH ER/A 628084-14AD. (1197169).SDR GTIA2025091539075Epsu · faultyDURING TASK CARD 256241-03-1 REMOVE DOOR ESCAPE SLIDE (7501MM) EPSU SYSTEM TEST FAILED (13WL)-R/R EPSU BATTERY(13WL) IAW AMM 33-51-38-000-002-A.EPSU SYSTEM TEST IS GOOD.SDR YENA2025091500932Unknown · odorFLT#1310, JAX-BOS. "ELECTRICAL BURING SMELL BETWEEN ROWS 19-24 REPORTED BY FLIGHT ATTENDANTS AND PAX. NO SMOKE VISIBLE DURING TROUBLESHOOTING FA TURNED OFF PED AND SMWLL DISSAPTED. BURNING SMELL LASTED APPROX 5 MIN DURING CRUISE. ( THALES-AVANT IFE (ENTIRE SYSDR YENA2025091500930Unknown · fumesFLT#1380, FLL-GUA. "INFLIGHT COMPLAINED ABOUT FUMES AFTER LANDING BOTH ENGINES OFF APU ON WITH APU BLEED NO NOTIFICATION DURING FLIGHT ( APU SYSTEM ).SDR SIMA20250913001A/C Pack · odorNAIL POLISH IN CRUISE SMELL. SHUT DOWN PACK 1 SMELL WENT AWAY FLIGHT CREW PLACARD DEFERRED PACK 1SDR SIMA20250913002Shutoff Valve · failedBLEED 1 OVER PRESSURE ON TAKEOFF RAN QRH DID NOT GO AWAY DIVERTED. LATER WENT AWAY AND RETURNED. STAYED ON FOR MOST THE FLIGHT WENT OFF SHORT FINAL. EMERGENCY DECLARED. MEL 36-1 AUTH 090733DM-C EXP 9-23-25. RAR NPRSOV PER AMM 36-11-03. OPS/LEAK CHECK GOOD.SDR DALA2025091506774Wire · pulledSR46 ABC THRU 50 ABC EEPLS INOP. FOUND WIRES PULLED FROM CONTACTS AT SR 46ABC AND 50 ABC. REPLACED CONTACTS PER A330 ESPM 20-48. EEPLS OPS GOOD. (6932680)SDR DALA2025091506772Bracket · damagedFR C62 AND C63 STR P1 AND P2 VIASAT BRACKET INSTALL HAS TOOLING MARKS. REPLACED BRACKET IAW AIRBUS DRAWING F5347982002400 AND A330 SRM 53-11. (1196944)SDR DALA2025091506771Bottle · low pressureR4 DOOR ASSIST BOTTLE LOW. SERVICED DOOR ASSIST BOTTLE PER A330 AMM 52-15. OK FOR SERVICE. (7360916)SDR DALA2025091506761Battery Pack · inoperative(LOG 7872705) EXIT SIGN AT ROW 20ABC AND EXTERIOR AFT 2 EMERGENCY DOOR LIGHTS INOP. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACK M1670 REF B737 AMM 33-51. CHECKS GOOD.SDR DALA2025091506760Battery Pack · inoperativeEMER LIGHTS OUTS FROM ROW 22 THROUGH 27. T/S EMER LIGHTS PER B737 FIM 33-50-00-810-801 FOUND BP M1671 BAD R/R BP PER AMM 33-51. OPS CK NORMAL.SDR DALA2025091506759Floorbeam · corrodedCORROSION ON FLOORBEAMS STA 328 RBL50 AT CPAX. FLOOR BEAM STA 328 RBL50 AT CPAX PER WAS REPAIRED B737-800 SRM 53-10-51-2R PROCEDURE 8 REPAIR 8.SDR DALA2025091506758Floorbeam · corrodedCORROSION ON FLOOR BEAMS STA 294 BL0 AT CPAX. FLOOR BEAM STA 294 BL0 AT CPAX WAS REPAIRED PER B737-800 SRM 53-10-51-2R PROCEDURE 14 REPAIR 14.SDR DALA2025091506751Oil System · leakingDIVERTED TO SAV DUE TO SWEET DIRTY SOCK SMELL. FOUND OIL BEHIND LEFT ENGINE SPINNER, REPLACED SAME. PERFORMED DUCT BURN. (LP 7590070, 1195522)SDR CALA2025091508913Control Unit · faultedANTI-SKID INOPERATIVE PILOT STATES AUTO BRAKE LIGHT & ANTI-SKID LIGHT CAME ON DURING TAKEOFF ROLL, PILOT ALSO STATES THAT LIGHT STAYED ON DURING THE WHOLE FLIGHT UNTIL PARKING BRAKE WAS SET AUTO BRAKE LIGHT AND ANTI-SKID LIGHT STAYED ON DURING WHOLE FLIGHT. NOSDR CALA2025091508877Battery Pack · inoperativeEMERGENCY FLOOR PROXIMITY LIGHT ON ROWS 1 THRU 4 DO NOT COME ON. REMOVED AND REPLACED BATTERY PACK FWD POWER SUPPLY IAW AMM TASK 33-51-06-960-805. PERFORMED TEST AND LIGHTS WORK AS INTENDED.SDR CALA2025091508876Power Supply · no testEPSU UNIT RT MESSAGE AFTER EMERGENCY LIGHTS TEST NEEDS REPLACED. R & R RT ESPU. REF: AMM TASK 33-51-38-000-002-A & TASK 33-51-38-400-002-A. OP CHECK TEST OKAY, IAW AMM TASK 33-51-00-710-001-A.SDR F3LA202509150290Battery · failedAIRCRAFT WAS NOT GROUNDED AND IS IN CHECK FOR SCHEDULED MX. DURING OPS CHK, FOUND EPSU BATTERY 12WL INOPERATIVE, REPLACEMENT REQUIRED IAW AMM-33-51-38-400-002-A REV.103. REPLACED EPSU BATTERY 12WL IAW AMM 33-51-38-400-002-A REV.103.SDR F3LA202509150289Battery · failedAIRCRAFT WAS NOT GROUNDED AND IS IN CHECK FOR SCHEDULED MX. DURING OPS CHK, FOUND EPSU BATTERY 11WL INOPERATIVLE. REPLACEMENT REQUIRED IAW AMM-33-51-38-400-002-A REV.103.
REPLACED EPSU BATTERY 11WL IAW AMM 33-51-38-400-002-A REV.103.SDR DALA2025091406750Case · looseALTERNATE GEAR EXT USED AFTER LT HYD SYS LOSS DURING APPROACH. FOUND LT ENG HYD CASE DRAIN FILTER DPI MISSING. REPLACED LEFT ENGINE FILTER MODULE DPI, HYDRAULIC POWER TRANSFER UNIT, LEFT ALTERNATING CURRENT PUMP, LEFT ENGINE DRIVEN PUMP, EDP CASE FILTER, PRESDR DALA2025091406749Battery Pack · inoperativeAIRCRAFT 5804, DURING SERVICE CHECK, FOUND R2 DOOR EXIT SIGN AND SEAT 14 THROUGH 20 EMERGENCY PATH LIGHT OUT. CORRECTIVE ACTION: REPLACED M11612 POWER SUPPLY BATTERY PACK AND CHECKED NORMAL PER B757 AMM 33-51. (LP 7855458)SDR ABXA20250913226Extinguisher · low pressureDURING SERVICE CHECK FOUND COCKPIT PORTABLE FIRE EXTINGUISHER GETTING LOW REMOVED AND REPLACED PORTABLE FIRE EXTINGUISHER IAW B767 AMM 26-26-02-024-015-001/26-26-02-434-020-001. RETURNED AC TO SERVICE.SDR DALA2025091306746Cover · detachedEXIT SIGN MISSING ON CEILING OVERWING EXITS POSITION. REINSTALLED EMER EXIT SIGN LENS COVER AS REQUIRED. (LP 7819786)SDR IXXA20250913001Former · crackedWHILE GETTING OK TO INSTALL FIXED LE SKIN BEHIND #9 SLAT, FOUND NOSE FORMER @ APPX WS 642 TO BE CRACKEDSDR KCSA202509131157Reveal · crackedFOUND DOOR REVEAL TO BE CRACKED AS MARKED AT R2 DOOR BETWEEN STR 25 AND 24SDR 2026FA0000627Pushrod · scoredTHIS HELICOPTER IS FACTORY NEW FROM MANUFACTUER AND THE SECOND HELICOPTER WE FOUND THIS SAME ISSUE ON. ALL OF THE ROCKER ARMS AND PUSHROD CAPS WERE FOUND TO HAVE SIGNIFICANT SCORING WHERE THE MAKE CONTACT WITH EACH OTHER DURING ITS FIRST 100HR INSPECTION WHILESDR 7CUR07152026Fitting · crackedCENTER WING LOWER RAINBOW FITTING CRACKED ON RIGHT HAND SIDE AT WING STA 220.SDR REXA2026052800846Door Frame · crackedCRACK ON UPPER FRAME AT AFT RH/LH & FWD RH OVERWING EMERGENCY EXIT DOOR. UPPER FRAME AT AFT RH/LH & FWD RH OVERWING EMERGENCY EXIT DOOR WERE REPAIRED PER REO 670-52-21-103 REV. - -SDR SCNA20250917377SFloor Panel · brokenBROKEN FLOOR PANEL 221QF AT W1, PASSENGER CABIN. DURING EMERGENCY LIGHTING SWITCH OPERATIONAL TEST EMERGENCY LIGHT CEILING AFT AND EMERGENCY LIGHT L1 EXT. AND INT. DON`T TURN ON. FAULT ISOLATION PROCEDURE AT LIGHT CEILING AFT AND EMERGENCY LIGHT L1 EXT. WAS SDR SWI2025F01884Slat Track · damagedRIGHT WING SLAT TRACK 2-1 HAS MULTIPLE GROOVE MARKS ON SURFACE. REMOVED AND INSTALLED NEW RT WING 2-1 SLAT TRACK WITH NEW IAW AMM 27-81-41-400-801-A01.OPS CHECKS GOOD.SDR SWI2025F01883Stringer · corrodedSTRINGER 26R BETWEEN FS613.00 AND FS 629.00 IS CORRODED. (MARKED) (S/N#00872) (C-CHECK RO 12/24/2025)REMOVED CORROSION ON STRINGER 26R BETWEEN FS613.00 AND FS 629.00 REF. CRJ900 SRM 51-21-06-001-001-A01. AFTER ENGINEERING EVALUATION, THE REWORKED CONDITION ISSDR SWI2025F01882Slat Track · damagedLH WING SLAT TRACK 2-1 UNDERSIDE HAS GROOVES/WEAR. BLENDED AND TREATED THE WEAR/GROOVES ON THE UNDERSIDE OF THE LT WING SLAT TRACK 2-1 PER REO 690-57-42-1326 REV-. ALL STEPS OF THE REO COMPLIED WITH. SKYCARD 51-900-1002-SKY COMPLIED WITH.