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 AALA202508146370Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #2 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR FDEA202508041364Floor Panel · dentedMAIN DECK COMP. AT APOX. STA 350 & LBL33 TO LBL11 FLOORBOARD PANEL 221DFF ABOVE SURFACE SKIN HAS INDENTATION (MARKED) REPAIRED DENTED FLOOR PANEL# 221DFF MPN#141T5856-117 LBL 11- LBL 33 STA 285-400 IN REF TO B767 SRM 53-00-50-2R 4.B.SEE JPF FOR ALL WORK STSDR AALA202508136700Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #4 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202508137917Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON SUPPORT AT BS 986.5, RBL 40. REPLACED SUPPORT PER AARD 51-00-05-1.SDR AALA202508126855Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #6 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR CALA2025081207631Housing · gougedAFT CARGO DOOR EXTERIOR HANDLE HOUSING GOUGED. REMOVED AND REPLACED AFT CARGO DOOR EXTERIOR HANDLE HOUSING PER SRM 51-40-02-0G-0 AND DWG 146A6110.SDR CALA2025081207630Structure · crackedCRACK FOUND ON LT HORIZ STAB LEADING EDGE, AT RIB OF LE HSS 95.96. REF AAR N/R 97525091. REMOVED AND REPLACED L/H HORIZONTAL STAB LEADING EDGE RIB AT L/E STA 95.96 REF 51-40-02-0G-0 AND DWG 186A1001.SDR CALA2025081207629Skate Angle · wornLEFT BODY-TO-VERTICAL FIN FAIRINGS FLANGE HAS CHAFING WORN DAMAGE FOR REF AAR N/R 97525018. REMOVED AND REPLACED SKATE ANGLE AT LT BODY TO VERTICAL FIN AFT SECTION REF SRM 51-40-02-0G-0 AND DWG 148A8300.SDR AALA202508111629Guide · gougedAIRCRAFT IN BASE MAINTENANCE: R1 DOOR CUTOUT, AFT DOOR FRAME, LOWER SIDE CENTERING GUIDE CASTING GOUGED. REPLACED CENTERING GUIDE CASTING PER AARD 51-00-05-1.SDR AALA202508110927Apu · contaminatedAIRCRAFT WAS GROUNDED: DIRTY SOCK SMELL ON DESCENT IN FLIGHT DECK. MAINTENANCE ACCOMPLISHED SMOKE / ODOR / FUME APU TROUBLESHOOTING TASK CARD 26L00021002 AND A DECONTAMINATION OF THE ENVIRONMENTAL CONTROL SYSTEM PER TASK CARD 26L00021014 WITH NO ODORS NOTED. SDR JJBA20250811034Skin · crackedRF 1 FUSE SKIN AT FR 75 AND AT STR 2R CRACKED. REPAIR DOUBLER ON RH REAR FUSE I SKIN AT FR 75 AND AT STR 2RSDR JJBA20250811032Skin · crackedRF1 FUSE SKIN AT FR 75 AND AT STR 2L CRACKED. REPAIR DOUBLER ON LH REAR FUSE I SKIN AT FR 75 AND AT STR 2LSDR JJBA20250811028Skin · scratchedREAR FUSELAGE I, SCRATCH FOUND ON BELLY SKIN AT FR 71 AND BTW STR 20L-21L. REAR FUSELAGE I, BELLY SKIN AT FR 71 BTW STR 20L-21L. SCRATCH ON BELLY SKIN FR 71 BTW STR 20L-21L FOUND OUT OF LIMIT. BELLY SKIN AT FR 71 BTW STR 20L-21L CUT OUT PERFORMED AND REPAIR PASDR DALA2025081105962Torque Box · damagedLEFT PYLON FWD TORQUE BOX UPPER SKIN FOUND EXISTING REPAIR AT NAC STA 221.25 TO NAC STA 237.5. REPAIR DESCRIPTION IN ER/A 581828-14.SDR SWIA2025080800004Winglet · ground damageIMPACT DAMAGE TO LT WINGLET. WINGLET LEADING EDGE TRANSITION FAIRING DWG: CC670-15356, HAS BEEN PUNCTURED & DEFORMED, WING TIP LENS CLOSING SPAR DWG CC670-15156, MACHINED FLANGE, HAS BEEN DEFORMED. REF EAML 1671206. FLIGHT 6325. TRANSITION FAIRING R & R SDR DALA2025080805953Elec Connector · corrodedCORROSION ON ELECTRICAL CONNECTOR LOC. POWER SUPPLY UNIT. REPLACED PSU IN THS COMPARTMENT AS PER AIRBUS ESPM 20-52- 12.SDR AALA202508087634Solenoid Valve · faultyAIRCRAFT WAS GROUNDED: FLIGHT CREW REPORTED THAT WHILE AT FL340 IN SMOOTH AIR, #1 ENGINE EXPERIENCED AN ENGINE STALL. THE ECAM WAS ACCOMPANIED BY A BRIEF AND ISOLATED "BUMP" SIMILAR TO TURBULENCE. NO NOTICEABLE DECREASE IN THRUST WAS EXPERIENCED AND ENGINE PARSDR AALA202508084484Door · crackedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND SERVICE DOOR UPPER AFT STOP PAD CRACKED. REPLACED DOOR STOP PAD PER AMM 52-41-01SDR AALA202508087419Guide · wornAIRCRAFT IN BASE MAINTENANCE: L1 DOOR CENTERING GUIDE PLATES WORN ON THE AFT DOOR FRAME. REPLACED AND ADJUSTED THE L1 DOOR CENTERING GUIDE TRACK PER AMM 52-11-00. A SATISFACTORY OPERATIONAL CHECK WAS ACCOMPLISHED.SDR AALA202508081953Solenoid Valve · faultyAIRCRAFT WAS GROUNDED: FLIGHT CREW REPORTED THAT WHILE AT FL340 IN SMOOTH AIR, #1 ENGINE EXPERIENCED AN ENGINE STALL. THE ECAM WAS ACCOMPANIED BY A BRIEF AND ISOLATED BUMP SIMILAR TO TURBULENCE. NO NOTICEABLE DECREASE IN THRUST WAS EXPERIENCED AND ENGINE PARAMSDR JJBA20250808020Floor Support · crackedLH OMEGA BEAM AT FR22 FOUND CRACKED. REPAIR DOUBLER ON CF I LH OMEGA BEAM ON INBD VERTICAL FLANGE AT FR 22.SDR CALA2025080807517Thrust Reverser · damagedFOUND HOLE ON #2 ENGINE OUTBOARD TR MEASURING 10X11 IN. ESTIMATED TO BE LESS THAN 2.2 LBS BUT GREATER THAN 3.5OZ OF MATERIAL LOSS.DAMAGE IS AROUND 2 OCLOCK POSITION ON TR HALF FLAGGED SDR IDT REQUIRED FOR DAMAGE VERFICATION PER MANAGEMENT REQUEST VERIFED DAMAGSDR JJBA20250808017Scuff Plate · corrodedAFTER REMOVAL OF SCUFF PLATE, FOUND AFT CARGO LOWER THRESHOLD TO HAVE CORROSION IN NUMEROUS SCREW HOLES. REMOVED AND REPLACED AFT CARGO LOWER THRESHOLD BEAM.SDR CALA2025080807490Stiffener · corrodedAFT CARGO BS 1180 S23. BULKHEAD LT O/B VERTICAL LWR SUPPORT FITTING HAS EXFOLIATION CORROSION. REMOVED DAMAGED STIFFENER IAW SRM 51-40-02, FABRICATED N EW STIFFENER IAW DWG 144N25-10 AND SRM 51-40-05, INSTALLED NEW STIFFENER IAW SRM 51-40-02.SDR JJBA20250808014Floor Support · mechanic errorRH OMEGA BEAM REPAIR BETWEEN FR 59 AND 61 MISDRILLED . CORROSION FOUND ON BOTH OMEGA BEAMS FR 59 AND FR61 UNDER GUSSETS. REMOVED CORROSION AND REPAIRED CENTER AND RH OMEGA BEAMS BETWEEN FR59 AND FR61 UNDER GUSSETS.SDR 2025F00176Drag Brace · brokenLEFT MAIN LANDING GEAR DRAG BRACE ASSEMBLY P/N EA1570-501 WAS FOUND CRACKED IN THE UPPER PORTION OF THE DRAG BRACE. CRACK WAS FOUND DURING A PRE FLIGHT INSPECTION. THE CRACK IS IN AN AERA THAT TWIN COMMANDER SL 376 ADDRESSES FOR NDT INSPECTION. CRACKED DRAG BRSDR SWAA2025080798217Flashlight · inoperativeFWD GALLEY FLASHLIGHT INOPERATIVE. R & R FWD GALLLEY FLASHLIGHT BATTERY FOR F/A PER AMM 25-64-00. CKS OK.SDR SWAA2025080798516Flashlight · no testFWD GALLEY FLASH LIGHT WONT TEST. REPLACED FLASH LIGHT IAW AMM 25-64-00.SDR SWAA2025080798159Flashlight · inoperativeAFT EMERGENCY FLASHLIGHT DOES NOT WORK<[01] R&R AFT EMERGENCY FLASHING AS PER AMM 25-64-00. R & R AFT EMERGENCY FLASHLIGHT IAW AMM 25-64-00. OPS CHECK GOOD.SDR SWAA2025080798489Flashlight · inoperativeAFT GALLEY CAPTS SIDE OTBD FLASHLIGHT INOP. REMOVED AND REPLACED AFT GALLEY CAPT SIDE OUTBOARD FLASHLIGHT ASSY IAW AMM 25-64-00. OPS CHECK GOOD.SDR SWAA2025080798501Air Filter · odorSTRONG SEWAGE SMELL DURING CLIMB OUT FROM ROW 20 TO AFT OF AIRCRAFT. FA AND PASSENGER COMPLAINTS. INSPECTED AFT TOILET SYSTEM AND POTABLE WATER SUPPLY / GRAY WATER DRAIN LINE. NO LEAK AND ANY ABNORMALITY NOTED PER AMM 38-32-00. FURTHER T/S REQ'D. INSPECTEDSDR AALA202508071521Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY HINGE ARM END FITTING ELEVATOR #2 ON RH HORIZONTAL STABILIZER. MAINTENANCE REPLACED HINGE ARM 2 ELEVATOR ON RH HORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR GTIA2025080739035Unknown · odorFA REPORTS DIRTY SOCKS SMELL WHEN LANDING GEAR COMES OUT -ACCOMPLISHED TSM 05-50-00-810-831-A PERFORMED GENERAL VISUAL OF ENGINES AND APU FOR LEAKAGES / SERVICING , NO DEFECTS NOTED . APPLIED. ODOR REPORTING SHEET TO DECISION TABLE AND ISOLATED CAUSE OF ODSDR DXTA2025080704462Hydraulic Line · leakingON TAKEOFF, THE MLG WOULD NOT RETRACT AND STAB MIS COMP ANNUNCIATOR ILLUMD. EXECUTED MLG WOULD NOT RETRACT RED GEAR UNLOCKED LIGHT REMAINS ON QRH & STAB MIS COMP QRH, NEITHER CHECKLIST CORRECTED PROBLEM. ON LANDING APPLIED NORMAL BREAKING, & DID NOT APPEAR SDR DXTA2025080704467Seal · faultedCLIMBING THROUGH 9000FT WE STARTED HEARING A LOUD WHISTLING WIND NOISE ALL THE WAY UP TO FL210. FIRST OFFICER WENT BACK AROUND 12,000FT AND SAID HE COULD SEE LIGHT THROUGH THE DOOR ON THE TOP LEFT HAND CORNER. THIS WAS FOLLOWED BY A FEW POPPING SOUNDS BELIEVEDSDR DXTA2025080704476Door Seal · defectiveSHORTLY AFTER REACHING CRUISE FLIGHT AT FLIGHT LEVEL 350, WE HAD A DOOR SEAL ANNUNCIATOR ILLUMINATE, AND A FLASHING MASTER CAUTION LIGHT. REMOVED AND REPLACED MED INFLATABLE SEAL WITH REF TO CE-560XLS AMM 52-10-04, OPS AND LEAK CHECKS GOOD. PN ON: 9914195-4 SSDR DALA2025080705936Cap · inoperative4L SLIDE LIGHT INOP. FOUND FAULTY CAP. REMOVED AND REPLACED CAP PER AMM 33-51. OPS CHK OK.SDR DALA2025080705927Skin · gougedAFT SERVICE DOOR- EXTERIOR SKIN HAS 2 SMALL GOUGES AT THE DOOR HANDLE CUTOUT FROM THE HANDLE CONTACTING THE SKIN. "M" SEE PIC. SCEPTRE LOG PAGE ENTERED FOR SDR REPORTING. SUMMARY SEE NR FOR ADDITIONAL INFORMATION 001-0819:5246-2004/002 00275 REPAIRED PER PRIS SDR YENA2025080700815Fire Loop · defectiveFLT#20, LHR-JFK. (ETOPS) ENG 2 PYLON LOOP B 4WD2 DEFECTIVE; REPLACED ENG 2 PYLON LOOP B 4WD2 IAW AMM 26-12-16 OPS CHKS REQD REF LP 3504569-1 FOR OPS CHKS.SDR YENA2025080700814Wire Harness · shortedFLT#20, LHR-JFK. (ETOPS) ENG 2 PYLON LOOP B STUD A HARNESS 41WD2 DEFECTIVE SHORT TO GND; REPLACED ENG 2 PYLON LOOP B HARNESS 41WD2 IAW AMM 26-12-63. OPS CHKS REQD REF LP 3504569-1 FOR OPS CHKS.SDR YENA2025080700813Warning Message · false activationFLT$20, LHR-JFK. (ETOPS) "AIR BLEED CLASS 2 MSG ( CLASS II MAINTENANCE MESSAGES DISPLAYED ON ECAM STATUS PAGE OF ECAM SYSTEM DISPLAY 1) FAULT(S) INDICATED BY AIR BLEED ); (RESOLVED ON W/O: 1433886 TASKCARD: NR-00003) PERFORMED FIM TASK 36-11-0-810-993-A. TEST SDR FDEA202508041385Seat Track · no discrepancyAIRCRAFT REPAIR ASSESSMENT : EXISTING REPAIR ANGLE FOUND ON MDCC SEAT TRACK BTW FR60~61,-Y450 COMPLIED WITH ATTACHMENT B OF EO: E6-5100-7-5000 D7 PT1, TITLE: STRUCTURES - REPAIR CATALOG - A300/A310 REPAIR IDENTIFICATION & TRACKING REQUIREMENTS 14 CFR 121.7SDR FDEA202508041384Doubler · no discrepancyEXISTING DOUBLER REPAIR FOUND ON RH O/B FLAP UPR SKIN BTW RIB3~4,S-1.2 ~ FRONT SPAR COMPLIED WITH ATTACHMENT B OF EO: E6-5100-7-5000 D7 PT1, TITLE: STRUCTURES - REPAIR CATALOG - A300/A310 REPAIR IDENTIFICATION & TRACKING REQUIREMENTS 14 CFR 121.707, INSPSDR FDEA202508041382Skin · ground damageDURING STORM IN DFW , TRUCK CAN PUNCTURED AIRCRAFT . DAMAGE IS 4" LONG BY 2 " WIDE . SEE PICTURES INSTALLED SKIN DOUBLER, TRIPLER AND FILLER REF MD11 SRM 53-00-01-2R. E. A. 1-5330-T0384438 PT1 AND PT2 .FUSELAGE- PLATES & SKINS- SKI AND FRAME REPAIR AT STASDR SCNA20250807298Control Valve · lockedNUMBER 1 ENG UNRESPONSIVE AFTER TOUCH DOWN N1 STUCK AT 20% WITH NO CHANGE IN N1, N2, FF WITH THRUST LEVER INCREASE. REVERSER LIGHT YELLOW WITH INABILITY TO ENGAGE NR 1 REVERSER ON LANDING. TAKE OFF CONFIG LIGHT ILLUMINATES WITH THRUST LEVER INCREASE MX NOTIFIESDR SCNA20250807297Cover · missingEMERGENCY LIGHT ON CEILING BETWEEN 1&2 MISSING COVER. R & R EMER LIGHT ON CEAILING BETWEEN 1 & 2 ROW REF AMM 33-51-00.SDR CALA2025080707447Brake · faultedLARGE SWERVE AT 90KTS, REJECTED. SUSPECT BRAKE GRABBED. REMOVED AND REPLACED LT OTBD BRAKE IAW AMM TASK 32-42-27-400-001-A. OPS CHECKED GOOD.SDR CALA2025080707430Angle · gougedAPU DOOR AFT RIGHT SIDE DEEP GOUGE . REMOVED AND REPLACED APU DOOR Z EDGE ANGLE REF SRM 51-40-02-0G-0 AND DWG 148A6350.SDR CALA2025080707429Skate Angle · worn{B737-06-3-0068} RH BODY-TO-VERTICAL FIN FAIRINGS FLANGE HAS CHAFFING WORN DAMAGE. REMOVED AND REPLACED AFT RIGHT BODY TO VERTICAL FIN ANGLE (SKATE ANGLE) REF SRM 51-40-02-0G-0 AND DWG 148A8300. REMOVED AND REPLACED AFT RIGHT BODY TO VERTICAL FIN ANGLE (SKSDR CALA2025080707423Housing · faulty26C AISLE PATH SEAT MOUNTED EMERGENCY ESCAPE PATH MARKING SYSTEM, LIGHT ASSY BROKEN. REMOVED AND REPLACED SEAT MOUNTED FLOOR PROXIMITY LIGHT HOUSING IAW CMM 25-22-59.