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 DALA2025071505329Girt Bar · detachedSHIP 6710 ESCAPE SLIDE GIRT BAR ENGAGEMENT LIGHT/S/ 3L INOP. CORRECTIVE ACTION: FOUND 3L DOOR GIRT BAR NOT ATTACHED TO ARM ADJ IAW B757 AMM 25-66 OPS CHKS GOOD. (1076876)SDR DALA2025071505328Drag Fitting · gougedSHIP 651 A.D.//A.A. DAMAGES WERE FOUND ON OPEN HOLES AT RH ENG DRAG FTG CLAMP-UP & DIAG BRACE AS FOLLOW; HOLE # 11 CORROSION ON SKIN AND FITTING BTW 5 TO 8 O'CLOCK POSITION, HOLE # 12 CORROSION ON SKIN AND FITTING BTW 6 TO 8 O'CLOCK POSITION, HOLE # 16 CORROSISDR DALA2025071505327Drag Fitting · gougedSHIP 651 A.D.//A.A. DAMAGES WERE FOUND ON OPEN HOLES AT LH ENG DRAG FTG CLAMP-UP & DIAG BRACE AS FOLLOW; HOLE #3 GOUGE ON FITTING BTW 3 TO 5 O'CLOCK POSITION, HOLE #4 CORROSION ON SKIN AND FITTING BTW 1 TO 4 O'CLOCK POSITION, HOLE #5 CORROSION ON FITTING BTW 1SDR AALA202507155010Pressure Deck · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CENTER FUSELAGE PRESSURE DECK MEMEBRANE FASTENER HOLES AT FR 36 AND +Y1292. REPAIRED PRESSURE DECK MEMBRANE PER EA 364444.SDR R61A202507110031Windshield · crackedFO WINDSHIELD SHATTERED IN DESCENT. EICAS MSG OF WINDSHIELD HEAT FAIL. DECLARED EMERGENCY, LANDED WITHOUT INCIDENT. REMOVED AND REPLACED RH WINDSHIELD.SDR REXA2025071500725Stringer · corrodedSTRINGER AT 19R IS CORRODED BETWEEN FS 394.00 AND 409.00. RECEIVED AND COMPLIED WITH ENDEAVOR AIR EA CRJ753-19649 REV IR DATED 7-1-2025SDR ABXA20250711157Escape Reel · unwanted extendTHREE INERTIAL ESCAPE REELS DISCOVERED DROPPED TO FLOOR AFTER LANDING. DEFERRED INERTIAL ESCAPE REELS IAW MEL 25-61-1-1. REMOVED AND REPLACED 3 INERTIAL ESCAPE REELS AT F/D POS. #2, SN 20994, POS. #4, SN 17656, POS. #6 SN 17681, REF AMM 25-61-00. DI CLEAREDSDR SIMA20250711001Door · stuckLH PAX DOOR STUCK CLOSED AFTER LANDING. NUMEROUS ATTEMPTS TO OPEN FROM OUTSIDE UNSUCCESSFUL. AFTER NUMEROUS ATTEMPTS, DOOR FINALLY OPENED. PERFORMED GVI AND OPS CHECK OF DOOR OPERATION IAW AMM 52-11-00. NO SIGN OF DEFECTS. OPS CHECK GOOD.SDR CALA2025071406529Skin · damagedLAVATORY TOILET OUTLET HAS CORROSION AND DAMAGE. PERFORMED HFEC INSP OF TRIMMED OUT AREA AND AREA UNDER EXISTING REPAIR +1"WITH NO RELEVANT INDICATION. REF NDT PT 6-51-00-00-PR23 AND AVO15023 REV A STEP 1 AND PREVDOUBLER REP STEP 4. REF STEP 3 OF AVO 15023 RESDR UIEA2025071100925Structure · no discrepancyAT APPROXIMATELY 310 KIAS, APPROXIMATELY 10 KNOTS OVERSPEED WITH OVSPD WARNING WHILE IN DESCENT 0 FLAPS ADVISE FLT LEVEL 200. WORK WITH MCC AND PER AMM 05-51-08. COMPLETED PHASE 1 INSPECTION, NO DAMAGE WAS FOUND. LOG ITEM CLOSED.SDR UIEA2025071200941Oxygen Mask · unwanted deployUNCOMMANDED DEPLOYMENT OF PAX O2 MASKS OVER SEATS 17HK.(<P>REPACKED AND STOWED O2 MASKS AT SEATS 17HK IAW AMM 35-21-14. OPS CHK OK.</P>)SDR ASAA2025071159393Light · faultedFA REPORTED THAT AFTER LANDING THE EMERGENCY EXIT LIGHTS ILLUMINATED FOR ABOUT 15 SECONDS ON LANDING. GROUNDED - YES. OPS CHECK EMERGENCY EXIT LIGHTS THROUGHOUT CABIN, OPS CHECK AS NORMAL. AT R2 DOOR CHECKED FOR FLICKERING OR LIGHTS TO GO OFF IN ILLUMINATED POSDR SWAA2025071490655Valve · faultyANTI-SKID AND PARKING BRAKE LIGHTS ILLUMINATED ON TAKEOFF. REMOVED AND REPLACED ANTI-SKID VALVE PER AMM. 32-42-31. OPS AND LEAK CHECK SATISFACTORY. REF# TTG8Q013P7MC CONDITIONAL INSPECTION. REMOVED AND REPLACED PARKING BRAKE VALVE ON NON-ROUTINE REF. TTG8Q01SDR SWAA2025071490332Winglet · delaminatedDELAMINATION DAMAGE ON THE R/H WINGLET LOWER BLADE. REMOVED R/H WINGLET LOWER BLADE PER AMM 57-31-21. REMOVED AND REPLACED PER AMM 57-31-21-400-802-MAX (WINGLET LOWER BLADE INSTALLATION - PERMANENT)SDR SWAA2025071490461Tailpipe · fireA/C BEHIND REPORTED TAIL PIPE FIRE NR 1 ENGINE. INSPECTED NR 1 ENG IAW FIM 71-05 TASK 811. NO ABNORMAL ACCUMULATION OF OIL IN EXHAUST PLUG AND NO ABNORMAL OIL CONSUMPTION RECORDED. A/C OK FOR SERVICE.SDR SWAA2025071490656Door · crackedLH MLG INNER DOOR CRACKED. REMOVED AND REPLACED LEFT MLG INNER DOOR PER AMM. 32-13-11. ADJUSTMENT AND TEST SATISFACTORY.SDR SWAA2025071490326Elec Connector · disconnectedFWD LEFT ENTRY DOOR OVER DOOR EXIT SIGN LIGHT INOPERATIVE. TROUBLESHOOT PER WDM 33-51-12 AND AMM 33-51-06. REPLACED FUSE NO HELP. FUSE BACK TO NORMAL REPLACED BATTERY NO HELP BATTERY BACK TO NORMAL. FOUND D40040P CONNECTOR WAS DISCONNECTED. CONNECTED THE CSDR SWAA2025071490460Lens · brokenOVERHEAD EMERGENCY EXIT SIGN BROKEN IN MID CABIN. RESECURED OVERWING EMERGENCY EXIT LENS IAW AMM REF 33-21-00 OPS CHECKS GOOD.SDR SWAA2025071490409Battery Pack · failedPASSENGER CABIN; BATTERY PACK M1670 FAILED CAPACITY TEST. R&R PASSENGER CABIN BATTERY PACK M1670 IAW AMM 33-51-06.SDR SWAA2025071490375Lamp · inoperativeL2 EXTERIOR EMERGENCY LIGHT INOPERATIVE. RELAMPED IAW AMM 33-51-04. OPS CHECK GOOD.SDR HALA20250714211Actuator · faultedATB - AFTER TAKE OFF FUEL TRIM LINE FAULT. FAULTING TRIM TANK INLET VLV. CHANGED / R&R SINGLE MOTOR ACTUATOR IAW AMM 28-27-52-400-801-A. AC OK FOR SVC.SDR SWIA2025071400011Valve · brokenLG WOW SYS FAIL EICAS MESSAGE (FLIGHT 5408 - FILED CLOSED)THIS DISCREPANCY WAS TRANSFERRED TO CAMP ITEM 30470009 WITH THE FOLLOWING CORRECTIVE ACTION: "TROUBLESHOT WITH FAULT CODE 32611306PSS FIM 32-61-00, DURING INITIAL EVALUATION FOUND IF 32611306PSS NLG WOSDR GTIA2025071438989Control Unit · faultedIN CRUISE WX RADAR INOP NO GREEN LIGHTS ON CONTROL HEAD -REMOVED AND REPLACED CONTROL WEATHER RADAR UNIT IAW AMM 4-41-33 OPS CHECK GOOD NO DEFECTS NOTED AT THIS TIME A/C OK FOR SVCSDR DALA2025071405276Access Door · dentedSHIP 3130 DENTS ON ACCESS DOOR 314AR EXTERNAL SKIN LOC. AT 6 INCH OF FWD EDGE AT LOWER FUSELAGE. COMPLIED WITH ER/A 626939-14.SDR DALA2025071405275Access Door · dentedSHIP 3130 DENT EXTERNAL SKIN ACCESS DOOR 314AR AT LOWER FUSELAGE. COMPLIED WITH ER/A 626939-14.SDR DALA2025071405274Frame · crackedSHIP 3126 CRACK INDICATION WAS FOUND ON FR20LH AT HOLE IDENTIFIED AS HOLE 6. COMPLIED WITH ER/A V-14AD.SDR DALA2025071405294Bottle · emptySHIP 3403, 4R DOOR OPENING ASSIST BOTTLE DEPLOYED/EMPTIED OUT. R/R 4R DOOR OPENING ASSIST BOTTLE FRANGABLE DISK PER A330 AMM 52 -10. SERVICED ASSIST BOTTLE TO FULL AND SAFTIED PER A330 AMM 52-10. OK FOR SERVICE.SDR DALA2025071405291Bearing · failedSHIP 3403 4R DOOR HARD TO OPEN AND CLOSE AND ARM/DISARM LEVER. R/R BEARING ON LOWER RIGHT SIDE OF 4R DOOR PER A330 AMM 52-12-16. OK FOR SERVICE. (1076925)SDR DALA2025071405290Girt Bar · faultedSHIP 3403 4R DOOR HARD TO SET. CORRECTIVE ACTION: REPLACED GIRT BAR PER A330 AMM 52-12. OK FOR SERVICE. (1076910)SDR YENA2025071400727Unknown · odorFLT#887, JFK-SXM. "STRONG ODOR DIRTY SOCK SMELL ON APPROACH AT 7500 FEET; C/W INFO NOTICE 2017-T015 SECTION A, ISOLATED FAULT TO TYPE 10 ODOR ENVIRONMENTAL. NO 30-DAY HISTORY. PERF LEVEL A ECS DECON IAW TSM 05-50-00-810-085-B. A.C OK FOR SVC. MCC LEO NOTIFIED.SDR AALA202507142632Terminal · disconnectedAIRCRAFT IN BASE MAINTENANCE: EVACUATION SIGNALING SYSTEM RESET SWITCH FOR THE R2 DOOR IS INOPERATIVE. MAINTENANCE FOUND TERMINAL 1 ON PUSH BUTTON SWITCH 2064VU4 DISCONNECTED AND WAS RECONNECTED PER ASM 23-73-27 AND AWM 23-73-54 A SATISFACTORY OPERATIONAL CHESDR AALA202507147046Wire · damagedAIRCRAFT WAS NOT GROUNDED: SEAT ROW 24ABC SEAT MOUNTED RED EMERGENCY LIGHT INOPERATIVE. REPAIRED DAMAGED WIRING UNDER SEAT AT ROW 24ABC AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-00.SDR AALA202507144257Fan · faultedAIRCRAFT WAS GROUNDED: VENT EXTRACT FAULT ECAM DURING DESCENT. SLIGHT VIBRATION AND ODOR JUST PRIOR TO ECAM. MAINTENANCE REPLACED EXTRACT BLOWER FAN (18HQ) AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 21-26-51 WITH NO FAULTS NOTED.SDR AALA202507144956Coffeemaker · sparksAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORT BURNING SMELL AND VISIBLE SPARK FROM FORWARD GALLEY COFFEE MAKER #2. MAINTENANCE VERIFIED CM FAULTY AND REPLACED.SDR AALA202507149840Light · inoperativeAIRCRAFT WAS NOT GROUNDED: OVER WING EMERGENCY EXIT LIGHT (2R) DOES NOT ILLUMINATE. MAINTENANCE REPLACED EMERGENCY "EXIT" LIGHT PLATE IAW AMM 33-51-17.SDR CALA2025071406567View Port · damaged4R SLIDE VIEW PORT IS EXCESSIVELY SCUFFED/ SCRACHED-DIFFICULT TO SEE SLIDE GUAGE CLEARLY NUTPLATE FOR 4R SLIDE VIEW PORT STRIPPED AND WONT HOLD SCREWS FOR VIEW PORT LENS TO STAY INPACT. REQUIRES NEW DOOR COVER PART NIS IN LAX. ACCOMPLISH REPETITIVE INSPECTIONSDR CALA2025071406566Slide · no discrepancyDOOR 1R ESCAPE SLIDE NEEDS TO BE REMOVED FOM. REMOVED DOOR 1R ESCAPE SLIDE REF MM TASK 25-66-01-004-001. ENTRY DOOR R1 ESCAPE SLIDE WAS REINSTALLED IN REF AMM 25-66-01-404-072. VERIFIED DOOR R1 ESCAPE SLIDE INSTALLATION IAW AMM 25-66-01-404-072, AND GMM 09-25SDR CALA2025071406564Wire · unsecureDOOR 2L LOOSE WIRE HANGING BELOW GIRT BAR LEFT SIDE. STOWED BENCH TEST CONNECTOR BACK BEHIND THE SLIDE. OK TO CONTINUE.SDR CALA2025071406561Power Supply · no testWHILE PERFORMING EMERGENCY LIGHT CHECK FOUND AFT #4 RH DOOR EMERGENCY EXIT SIGN NOT ILLUMINATING PERFORMED REPLACED THE LAMP OF #4 R/H AFT DOOR EMERGENCY EXIT SIGN AS REQUIRED. NO HELP. REQUIRES FURTHER T/S. R & /R BATTERY ASSEMBLY AND BATTERY CHARGER IAW AMMSDR CALA2025071406560Power Supply · faultedEPSU EXT LOAD EMER R FAULT. REPLACED 12W EPSU REF AMM 33-51-38-401. OPS CHECKS GOOD.SDR CALA2025071406526Smoke Detector · false activationAFT LAV SMOKE DETECTOR ACTIVATED. NO INDICATION OF SMOKE OR FUMES INSPECTED LAVATORY, FOUND STATUS INDICATOR LIGHT ON SMOKE DETECTOR SOLID GREEN, NO SIGNS OF SMOKE, NO ALARM. NO HISTORY OF ISSUE. REF.AMM 26-14-00.SDR CALA2025071406525Light · inoperativeAFT L/H SLIDE EMERGENCY EXT LIGHT INOPERATIVE. R&R AFT L/H SLIDE EMERGENCY EXT LIGHT IN REF TO AMM 33-51-04, OPS CHECK GOOD.SDR CALA2025071406523Lamp · inoperativeAMBER EMER EXIT LIGHTS NOT ARMED LIGHT NEEDS TO BE RELAMPED. RELAMPED AND OPS CHECK WAS GOOD. REF: AMM 33-18-00.SDR CALA2025071406522Fault Message · false activationTE FLAP DISAGREE DUE TO FLAP MANIPULATION WHILE IN TRANSIT. RAN QRH LEFT FLAPS DWN POST LANDING DEBRIEFED CREW, CREW STATED FLAP LEVER WAS INADVERTENTLY MOVED. QRH WAS FOLLOWED DEBREIF THE CREW PILOT AGREE THAT SHE WAS ASK TO FLAP DOWN 25 AND MISTAKELY MOVE TOSDR CALA2025071406521Motor · faultedSTABILIZER TRIM SWITCHES DO NOT OPERATE TRIM UP AND TRIM DOWN CA PTAIN'S STARTED FIM TASK27-41-TASK 804. PERFORMED STM LOGIC CARD RESET. NO HELP. CHECKED R64 RELAY CKD GOOD. CHECKED FOR PWR AT STM (M1659) PWR AVAILABLE AT PIN 1,2,3 PER FIM. STAB MOTOR NEEDS RESDR CALA2025071406520Engine · faultedRT ENG OVRHT LIGHT ILLUMINATED ON CLIMBINSPECTED CORE AREA OF #2 ENGINE FOUND CORE UPPER FIRE LOOP TOUCHING SENSE LINE TO PRSOV, ADJUSTED POSITION OF CLAMP, RAN ENGINE. OVERHEAT LIGHT CAME ON AFTER 3 MINUETS AT 85% N1, WENT OUT AFTER THROTTLE BACK TO 83%, THENSDR CALA2025071406507Frame · corrodedSEVERAL SPOTS CORROSION AT RIGHT INNER CHORD BETWEEN STA 947 TO STA 1016. REF. AAR N/R:97526633 REMOVED CORROSION AT R/H INNER CHORD R2 DOOR BETWEEN STA 947 TO STA 1016 FOUND TO BE OUT OF LIMITS, REMOVED AND REPLACED INNER CHORD FROM STA 892 TO986 IN REF B 737SDR CALA2025071406506Battery Pack · no testPASSANGER CABIN EMERGENCY LIGHTS M1675 FAILS BATTERY CHECK. (REF AAR NR 1000039554) REPLACED BATTERY PACK M1675 IAW B737 AMM 33-51-06-960-805. OPS CHEK GOOD. EMERGENCY BATTERY PACK M1675 FAILED FUNCTIONAL CHECK DURING THE D CHECK IN RFD. REPLACED BATTERY PACKSDR CALA2025071406505Oxygen Box · no testSEAT 21DEF OXYGEN MASK COMPARTMENT DID NOT OPEN DURING OPERATIONAL REST. REMOVED OXYGEN BOX AT SEAT 21DEF, REF AMM 35-21-41. READY FOR INSPECTION PART NUMBER VERIFICATION AND CLEARANCE TO INSTALL. PART VERIFICATION AND CLEARANCE NOT REQUIRED FOR INSTALLATIOSDR CALA2025071406504Attach Angle · crackedMAIN WHEEL WELL STA 663.75 RBL 7" VAPOR BARRIER UPPER ANGLE CRACK (REF AAR N/R 97526547) REMOVED AND REPLACED MAIN WHEEL WELL STA 663.75 RH VAPOR BARRIER UPPER ATTACH ANGLE PER DWG 111A1000 ,DWG 111A1322 AND SRM 51-40-02-0G-0. REMOVED AND REPLACED MAIN WHEEL