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 CALA2025102810668Speed Brake · faultedSPEEDBRAKE DO NOT ARM LIGHT ILLUMINATED AT 70KTS DURING TAKEOFF. REQ MEL 2707F. VERIFIED MANUAL SPEEDBRAKE DEPLOYED AND STOWED. OPENED AND COLLARED C/B PER THE MEL. PLACARD APPLIED. PERFORMED FIM TASK 27-62 TASK 802 STEP E (2) . NO FURTHER ACTION REQUIRED . NSDR CALA2025102810645Anti-Ice Valve · faultedCOWL VALVE OPEN LIGHT STAYS ON BRIGHT WHEN THE ENG ANTI-ICE SWIT CH IS MOVED TO ON ENG-1 ENG1 COWL VALVE OPEN LIGHT STAYS ON W AMBER TAI ON MFD WHEN AI S ELEC TED ON REMOVED E1 COWL ANTIICE VALVE SN 1365C AND INSTALLED A NEW SERVICEABLE VALVE SN 875C PER AMM TSDR CALA2025102810643Egt Indication · illuminatedENG 1 EGT EXCEEDENCE ON CLIMB OUT. NORMAL IND. WITH REDUCED POW ER NO EXCEEDANCE FOUND IN ENGINE 1 EXCEEDANCE. ENG TEMP WAS AT 942 CELCIUS FOR 84 SECONDS. PERFORMED AMM 71-00-00-800-804-F00 INSPECTION AFTER ENGINE OPS ABOVE LIMITS AND HIGH ENGINE STRESS STESDR CALA2025102810626Slide · dislodgedRIGHT FWD ENTRY DOOR SLIDE HANGING OUT INSPECTED GIRT AND GIRT BAR, GIRT IS SECURED AND GIRT BAR OPERATES NORMAL. REF AMM 25-66-01.SDR CALA2025102810624Lamp · burned outLEFT UPPER LIGHT ON DOOR STATUS PANEL BURNED OUT. VERIFIED BOTH EQUIPMENT DOORS ARE CLOSED AND PLACED LIGHT ON MEL 5271W. VERIFIED BOTH EQUIPMENT DOORS ARE CLOSED AND PLACED LIGHT ON MEL 5271W. DEFERRED DIRECTLY BY TOMC RELAMPED UPPER DOOR STATUS INDICTATIOSDR CALA2025102810622Girt Bar · bindingDOOR 1L GIRT BAR IS VERY DIFFICULT TO STOW AND RELEASE FOR ARMIN G AND DISARMING ADJUSTED DOOR 1L GIRT BAR SPRING CLIP. GIRT BAR STOWS & RELEASES NORMAL. REF AMM 25-66-01.SDR CALA2025102810621Arming Lever · stiffDOOR 4L ARM LEVER DOESNT MOVE FULLY INTO DISARM POS. DOOR SHOWS DISARMED CREW REPORTED DOOR 4R HARD TO DISARM. CYCLED GIRT BAR, NO DEFECT NOTED REF AMM 25-66-01SDR CALA2025102810620Slide · out of adjustSLIDE AT 2R IS HANGING TO LOW READJUSTED THE SLIDE GIRT BAR ON 2R DOOR IAW AMM 25-66-01-200-802, OPS CHECK GOOD, OKAY TO CONTINUE.SDR SCNA20251028412Battery Pack · dischargedEMERGENCY BATTERY PACK FOR L2 DOOR SIDE FAILED TEST. R&R EMERGENCY BATTERY PACK FOR L2 DOOR SIDE REF AMM 33-51-06. EMERGENCY BATTERY PACKS NEED TO RECHARGE TILL 0522L. PERFORMED OPS CHECK FOR EMERGENCY BATTERY PACKS REF AMM 33-51-06. OPS CHECK GOOD. DEEP CYCLSDR YENA2025102801062Wire Harness · failedFLT#31, BOS-AMS. (ETOPS) "REF LP # 4482219 ITEM #1 (REMOVED AND REPLACED ENG#2 EEC WIRING HARNESS W03 REF AMM 73-21-63. OPS CHK AND IDLE RUNS NORMAL NO FAULTS NOTED A/C OK TO RETURN TO SVC) ENG #2 FADEC FAULT; PFR SHOWS N2 SPEED SENSOR AS PRECAUTIONARY REMOVESDR YENA2025102801059Unknown · odorFLT#373, BOS-AUA. CR3 ALERT. INFLIGHT CREW MEMBERS REPORTED FUMES EVENT ON DESCENT INTO AUA TO INBOUND CAPT ON GND DURING DEPLANING ( PACKS ); PERFORMED LEVEL B DECONTAMITATION OF ECS PER TASK CARD A320-21-00-00-615-803-A. THIS CLEARS MDDR. MX-4 UPDATED. PLASDR HALA20251027328Latch · damagedETOPS - RH T/R #1 LATCH HANDLE ASSY DAMAGED. REMOVED AND REPLACED RH T/R #1 LATCH HANDLE ASSY PER AMM 78-32-45. OPS CHECK GOOD, A/C OK FOR SVC.SDR HALA20251027327Wire Harness · faultedETOPS - ANTI-ICE DUCT LEAK/OVERHEAT DETECTORS ACTIVE FAULT. REMOVED AND REPLACED ENGINE ANTI-ICE ELECTRICAL HARNESS W35 ON NR 2 ENG PER AMM B787-A-30-21-09-00A. OPS CHECK GOOD. NO FAULTS NOTED. OK FOR SVCSDR SWAA2025102729004Pump · leaking45 MIN INTO FLIGHT, ENG 2 HYD PUMP LOW PRESSURE LIGHTILLUMINATED. ELEC 1 LOW PRESSURE LIGHT ALSO ILLUMINATED. RAN PROCEDURE IAW QRH & EXTENDED FLAPS VIA ALT FLAP SYS TO FLAPS 15 LANDING. REMOVED & REPLACED ENG. NR 2 EDP REF. AMM 29-11-11. OPS TEST GOOD, NO SDR SWAA2025102728412Pump · leaking45 MIN INTO FLIGHT. ENG 2 HYD PUMP LOW PRESSURE LIGHTILLUMINATED. ELEC 1 LOW PRESSURE LIGHT ALSO ILLUMINATED. RAN PROCEDURE IAW QRH & EXTENDED FLAPS VIA ALT FLAP SYS TO FLAPS 15 LANDING. REMOVED & REPLACED ENG NR 2 EDP IAW AMM 29-11-11. OPS TESTED GOOD, NO LSDR QXEA2025102700333Structure · no discrepancyFLIGHT 2264. BIRD STRIKE ON TAKEOFF ROLL, LARGE BIRD ABOVE WINDSHIELD. APPROXIMATELY 100 KTS. REJECTED TAKEOFF. REMOVED FROM SERVICE. INSPECTED FUSELAGE ABOVE WINDSHIELDS AND DID NOT SEE ANY EVIDENCE OF A BIRDSTRIKE. NO SNARGE OR DENTS NOTED. ALL OTHER ARESDR SWI2025F01464Flow Valve · faultedRIGHT BLEED DUCT WARNING WENT TO CAUTION DURING CLIMB. (FLIGHT 5923) INTERROGATED MDC AND FOUND B1- 349538 TROUBLE SHOT IN REF TO FIM 36-21-03. LEAK DETECTED AT MT145 AT 10% PERFORMED GVI & LEAK CHECK OF AREA AND FOUND A BLEED LEAK COMING FROM RT FLOW CONTRSDR SWI2025F01463Sink · cloggedLAV TOILET AND SINK STOPPED WORKING MID FLIGHT W/ASSOCIATED ELECTRICAL SMELL IN CABIN. SMELL WENT AWAY AFTER A COUPLE OF MINUTES (FLIGHT 6384) PLEASE REFERENCE AML 1734688. PLEASE REFERENCE AML 1734705.OPS CHECK OF AFT LAV TOILET PER CRJ 700 AMM 38-31-00. SDR SWIA2025102700025Floorbeam · damagedDAMAGE HOLE TP RBL9.00 FLOOR BEAM LOWER FLANGE BTWN FS 677.00 & FS692.00. (FILED OPEN)SDR AALA202510278954Fuel Filter · cloggedAIRCRAFT WAS NOT GROUNDED: NUMBER 1 FUEL FILTER BYPASS LIGHT ILLUMINATED SHORTLY AFTER TAKEOFF. REMOVE AND REPLACED THE NUMBER 1 ENGINE FUEL FILTER. PER AMM 73-11-02. OPS & LEAK CHECK GOOD.SDR AALA202510272092Locking Cam · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANTS ARE EXPERIENCING TROUBLE REMOVING THE GIRT BAR FROM ITS BRACKETS ON THE 1R DOOR. CLEANED AND LUBRICATED R1 SLIDE GIRT BAR RETAINER CLIPS. PER AMM25-66-00.SDR AALA202510273430Door Latch · stuckAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR DOES NOT OPEN, WHEN THE CODE IS ENTERED. THE LIGHT TURNS GREEN AFTER APPROXIMATELY 1 MINUTE, THE NORMAL AUDIBLE SOUNDS ARE NOT HEARD AND THE DOOR WILL NOT OPEN. CLEANED DOOR JAM AND LATCH ASSEMBLY DOOR AND ELECTRIC LSDR AALA202510273750Girt Bar · looseAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS GIRT BAR ON FORWARD RIGHT DOOR IS LOOSE. RESECURED R1 DOOR AFT GIRT BAR BRACKET. PER AMM 25-66-02. OPERATIONAL TEST GOOD.SDR AALA202510273827Door Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR LOCK IS DIFFICULT TO SLIDE AND PRONE TO GETTING STUCK. ADJUSTED AND LUBRICATED LEFT AFT LAVATORY DOOR AND LOCK MECHANISM. PER AAMM 25-40-00. OPERATIONAL CHECK GOOD.SDR AALA202510273610Girt Bar · bindingAIRCRAFT WAS NOT GROUNDED: FORWARD ENTRY GIRT BAR DIFFICULT TO DISARM. CLEANED FORWARD ENTRY GIRT BAR FITTINGS. PER AMM 25-00-00. OPERATIONAL CHECK GOOD.SDR AALA202510278370Girt Bar · lack of lubeAIRCRAFT WAS NOT GROUNDED: GIRT BAR HOOKS NEED ADJUSTED, TOO TIGHT TO ARM AND DISARM. CLEANED AND LUBRICATED GIRT BAR FITTINGS ON ALL DOORS. OPERATIONAL CHECK GOOD.SDR IPXA2025102755348Window · crackedDIVERSION, 1R WINDOW CRACKED IN CRUISE FLT AT FL390. OPENSDR IPXA2025102751899Door · faultedFORWARD ENTRY DOOR WILL NOT CLOSE USING EXTERIOR HANDLE. THE HANDLE BREAKS OVER WITH SMALL PRESSURE. OPERATED EXTERIOR DOOR HANDLE FLAP SEVERAL TIMES TO CLEAR ANY POSSIBLE DEBRIS IN MECHANISM. PERFORMED DOOR CLOSING WITH EXTERIOR HANDLE PER AMM 52-10-11/501SDR GTIA2025102739154Unknown · odorFLIGHT ATTENDANT CALLED DURING APPROACH AND REPORTED A DIRTY SOCK AND MUSTY SMELL. NO SMELLED IN COCKPIT. DESCRIPTION OF ODOR/FUMES: TEMPORARY, DIRTY SOCKS/MUSTY DRY SMELL. APPARENT CABIN SOURCE: UNKNOWN. FWD CABIN, MID CABIN, AND AFT CABIN. NO VISIBLE SMOKE/HSDR GTIA2025102739153Megaphone · inoperativeMEGAPHONE BY L1 DOOR INOP-REPLACED MEGAPHONE IAW AMM 25-65-51. MOC # 119285SDR GTIA2025102739152Limiter · trippedFTCL SLAT FAULT. RAN ECAM AND LANDED FLAPS 3-PERFORMED T/S IAW TSM 27-81-00-810-810-A, FOUND TORQUE LIMITER AT 6037CM POPPED. NO DAMAGE OF TORQUE SHAFT OR STEADY BEARING ASSY NOTED, PERFORMED RESET OF TORQUE LIMITER IAW AMM 27-80-00 PER TFU 27.80.00023, PERFORSDR GTIA2025102739151Unknown · odorFA'S SMELLED STRONG, SWEET ODOR AT GEAR EXTENSION INTO LAX. DESCRIPTION OF ODOR/FUMES: TEMPORARY, MOLDY SMELL. APPARENT CABIN SOURCE: UNKNOWN, AFT CABIN/GALLEY(LAV). NO VISIBLE SMOKE/HAZE. NO MEDICAL ATTENTION REQUIRED.--SDR GTIA2025102739150Unknown · odorFA REPORTED DIRTY FEET SMELL JUST ABOUT 5 MINS TO LANDING AT MCO -PERFORMED TSM 05-50-00-810-831 COULD NOT DUPLACATE SMELL. LEVEL A COMPLETEDSDR DALA2025102707895Seal · leakingAIRCRAFT 5039, SHORTY AFTER TAKEOFF FA SMELLED TO REPORT CHEMICAL/ELECTRICAL SMELL ALL PAX AND FS SMELLED IT. RAN SMOKE AND FUMES CHECKLIST SMELL DISAPATED AFTER PILOTS SMELLED ACRID SMELL FOR A MOMENT AS WELL. CORRECTIVE ACTION: T/S PER AMDS W/C 0550-2002 FOUSDR DALA2025102707893Acm · leakingATB - DUE TO A RT WING BLEED LEAK MESSAGE AT FL350. WING A/I WAS NOT BEING USED. LEAK FOUND IN RT PACK BAY. REPLACED RT ACM OUTLET JOINT SEALS. (LP 8025030)SDR DALA2025102707892Unknown · odorAIRCRAFT 5034, ON TAKEOFF TO 3000FT FAINT ACRID ODOR. @33000 FEET 54 MIN INTO FLIGHT STRONG SOCK/ACRID ODOR FOR 2MIN DURING AIRCRAFT SLOWING. ON DESCENT 18000FT -14000FT STRONG ODOR AGAIN. APPEARS TO BE RELATED TO THURST CHANGES. CORRECTIVE ACTION: PERFORMING SDR DALA2025102707889Engine · making metalDIV/IFSD- DIVERTED TO KEF DUE TO LEFT ENGINE FAILURE. MAINTENANCE FOUND METAL IN TAIL PIPE. REPLACED LEFT ENGINE. (7922122) ENGINE: PWA, PW4060.SDR DALA2025102707886Skin · crackedSHIP 193 NBR 1 PYLON-CRACK ON INBOARD SIDE OF PYLON COMING FROM AFT UPPER CORNER OF PYLON ACCESS PANEL 416BR. CORRECTIVE ACTION: C/W TIME LIMITED REPAIR INSTRUCTIONS REF ERA 628915-14 (1271020)SDR DALA2025102707875Unknown · odorATB/SMOKE- PERFORMED AIR TURN BACK DUE TO CREW REPORTS OF ODOR IN FLIGHT DECK. T/S PER A330 05-50-810-829-A. NO EVIDENCE OF OIL LEAK. NO SMELL OF CONTAMINATION. PERFORMED ENGINE RUN AND LEAK CHECK. (LP# 7972910,1269341,1268168)SDR DALA2025102707874Light · detachedSHIP 3301 2R OVERHEAD EMERGENCY LIGHT BROKEN AND HANGING. CORRECTIVE ACTION: REPLACED OVERHEAD EMERGENCY LIGHT AT 2R IAW A330 AMM 33-51. OPS GOOD. (7953219)SDR DALA2025102707864Seat Track · corrodedSHIP 3317 SEAT TRACK - CABIN SEAT RAIL UPPER SURFACE FOUND CORROSION AT FR75 TO FR76, -Y1137.1. CORRECTIVE ACTION: REPLACED SEAT TRACK PER ERA 629578-14 REV ORIGINAL. (1270449)SDR DALA2025102707863Seat Track · corrodedSHIP 3317 SEAT TRACK - CABIN SEAT RAIL UPPER SURFACE FOUND CORROSION AT FR74 TO FR75, Y794.3. CORRECTIVE ACTION: REPLACED SEAT TRACK PER ERA 629576-14 REV ORIGINAL. (1270275)SDR DALA2025102707862Seat Track · corrodedSHIP 3317 SEAT TRACK - CABIN SEAT RAIL UPPER SURFACE FOUND CORROSION AT FR74 TO FR75, -Y794.3. CORRECTIVE ACTION: REPLACED SEAT TRACK PER ERA 629576-14 REV ORIGINAL. (1270261)SDR DALA2025102707858Bottle · low pressureSHIP 6702 2L DOOR SLIDE PRESS GAUGE INDICATES OUT OF THE GREEN BAND. CORRECTIVE ACTION: REF LOG #1271463 FOR 2L DOOR ESCAPE SLIDE R/R. RII'S C /W ON W/C 2566-9001-2L. (8150576)SDR DALA2025102707855Girt Bar · faultedAFTER MAIN CABIN DOOR CLOSE, GIRT BAR DOORS CIRCUIT BREAKER POPPED AGAIN AFTER MAINTENANCE PREVIOUSLY PUSHED BACK IN. OPENED P34 JUNCTION BOX AND REPLACED K256 AND K257 RELAYS. REPLACED S10225 SWICH, FOUND TERMINALS DAMAGED AND SHORTING ON L00404 R2 GIRT DOOSDR DALA2025102707854Arming Lever · bindingR1 SLIDE ARM LEVER STICKY. DOOR WAS SHOWING DISARMED BUT INDICATED ARM DURING OPEN LEVER MOVEMENT. "FWD" LEFT GIRT BAR NOT ENGAGING ON 1R. CORRECTIVE ACTION: FOUND 1R GIRT BAR FWD SLIDER OUT OF POSITION. REPOSITIONED & IR DOOR NOW ARMS/DISARMS NORMALLY. REF. BSDR DALA2025102707852Indicator · damagedSHIP 6823 REF LOG 7616234 FOUND R2 DOOR GIRT BAR ARMED LIGHT DAMAGED. CORRECTIVE ACTION:R AND R R2 DOOR GIRT BAR ARMED LIGHT REF B757 AMM 33-51 OPS CK GOOD. (7616235)SDR DALA2025102707850Battery Pack · no testSHIP 651 LT OVERWING EMERGENCY LIGHT OUT. CORRECTIVE ACTION: REMOVED AND INSTALLED THE SAME BATTERY PACK CHECK VOLTS FOR THE BATTERY AND THE POWER SUPPLY AND FOUND GOOD. OPS CHECK THE LIGHT AND FOUND GOOD. REF AMM 33-51. (7000191)SDR DALA2025102707849Not Reported · not reportedSHIP 658 WORKING PRI ER/A 591128-14AD ER/A REV B PRI REV 0. CORRECTIVE ACTION: C/W PRI ER/A 591128-14AD ER/A REV. B PRI REV. 0. C/W PRI ER/A 591128-14AD ER/A REV. B PRI REV. 0. ACCOMPLISHED ER/A 591128-14AD REV B. (1271534)SDR DALA2025102707876Fuse · inoperativeSHIP 6805 WHITE EMERGENCY LIGHTS IN SEATS 1-4 INOP. CORRECTIVE ACTION: T/S PER B757 WDM 33-52-12. FOUND P2 CONNECTOR UNDER ROW 2 DISCONNECTED. SWAPPED PICO FUSE (F1) ON BATTERY CHARGER ASSY. M731. OPS CHK OK. (7956812)