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 AALA202601228851Epsu · activation errorAIRCRAFT IN BASE MAINTENANCE: EPSU INT LOAD AFT L FAULT WHEN PERFORMING EMERGENCY LIGHT TEST. MAINTENANCE REPLACED EMERGENCY POWER SUPPLY UNIT 13WL IAW AMM 33-51-38.SDR AALA202601223618Epsu · activation errorPERFORMED EMERGENCY CABIN LIGHTING SYS TEST AND RECEIVED MESSAGE : ATA33-51-38 EPSU INT LOAD AFT L. MAINTENANCE REPLACED EMERGENCY POWER SUPPLY UNIT 13WL IAW AMM 33-51-38.SDR R61A2026011900013Crossbeam · corrodedWHILE ON HEAVY CHECK - CORROSION ON FR 84 CROSSBEAM OUTBOARD OF RT SEAT TRACK.SDR FDEA202601210079Bulb · dimL1 OVERHEAD EMERGENCY EXIT SIGN DIM. AMM: 33-51-01-2 REMOVED AND REPLACED 17 FAULTY BULBS AT THE L1 OVERHEAD EXIT SIGN AS PER ABOVE REF. OPS CHECK GOOD. (P/N OL3071BPEGPL) A/C OK FOR SERVICE.SDR AALA202601224449Battery · no testAIRCRAFT WAS GROUNDED: BATTERY FAULT FOR EMERGENCY POWER SUPPLY UNIT 14WL DISPLAYED DURING SYSTEM TEST. REPLACED BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-00.SDR AALA202601225819Flashlight · no testAIRCRAFT WAS NOT GROUNDED: INBOARD FLASHLIGHT AT 1L FOR FLIGHT ATTENDANT JUMPER IS INOPERATIVE. MAINTENANCE REPLACED FLASHLIGHT AS REQUIRED.SDR AALA202601225940Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R3 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202601223812Battery · no testAIRCRAFT WAS GROUNDED: BATTERY FAULT FOR EMERGENCY POWER SUPPLY UNIT 13WL DISPLAYED DURING SYSTEM TEST. REPLACED BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR R61A2026011900011Seat Track · corrodedWHILE IN HEAVY CHECK - FOUND CORROSION ON LT SEAT TRACK AT FRAME 84.SDR P5CA2026012000002Stringer · crackedCRACK DAMAGE ON THE STRINGER S-8R, AT FWD SIDE OF STA 2598. REPAIR DAMAGE AREA IAW W/S NO: 50870 (SRM 53-80-03-2R-2 REV: 47) JOB COMPLETED AND CONDITION CHECK NORMAL.SDR P5CA2026012000003Stringer · crackedCRACK DAMAGE ON THE STRINGER S-7R, AT FWD SIDE OF STA 2598. REPAIR DAMAGE AREA IAW W/S NO: 50869 (SRM 53-80-03-2R-2 REV: 47). JOB COMPLETED AND CONDITION CHECK NORMAL.SDR P5CA2026012000004Stringer · crackedCRACK DAMAGE ON THE STRINGER S-6R, AT FWD SIDE OF STA 2598. REPAIR DAMAGE AREA IAW W/S NO: 50868 (SRM 53-80-03-2R-2 REV: 47). JOB COMPLETED AND CONDITION CHECK NORMAL.SDR P5CA2026012000005Stringer · crackedCRACK DAMAGE ON THE STRINGER S-5L, AT FWD SIDE OF STA 2598. REPAIR DAMAGE AREA IAW W/S NO: 50867 (SRM 53-80-03-2R-2 REV: 47). JOB COMPLETED AND CONDITION CHECK NORMAL.SDR P5CA2026012000006Stringer · crackedCRACK DAMAGE ON THE STRINGER S-2L, AT FWD SIDE OF STA 2360. REPAIR DAMAGE AREA IAW W/S NO: 50876 (SRM 53-60-03-2R-8 REV: 47) AND EI T2026A53M-087 REV 1. JOB COMPLETED AND CONDITION CHECK NORMAL.SDR P5CA2026012000007Stringer · crackedCRACK DAMAGE ON THE STRINGER S-20R, AT AFT SIDE OF STA 2360. REMOVED AFFECTED FASTENERS TO GET ACCESS IAW SRM 51-40-02-0G-0 REV 47. REPAIR DAMAGE AREA IAW W/S NO: 50872 (SRM 53-80-03-2R-3 REV 47). INSTALLED FASTENERS IAW SRM 51-40-02-0G-0 REV 47 AND DWG NO:SDR P5CA2026012000008String · crackedCRACK DAMAGE ON THE STRINGER S-7R, AT FWD SIDE OF STA 2360. REPAIR DAMAGE AREA IAW W/S 50877 (SRM 53-60-03-2R-8 REV: 47). JOB COMPLETED AND CONDITION CHECK NORMAL.</P>)SDR P5CA2026012000009Stringer · crackedCRACK DAMAGE ON THE STRINGER S-7L, AT FWD SIDE OF STA 2360. REPAIR DAMAGE AREA IAW W/S NO: 50878 (SRM 53-60-03-2R-8 REV: 47). JOB COMPLETED AND CONDITION CHECK NORMAL.</P>)SDR P5CA2026012000010Stringer · crackedCRACK DAMAGE ON THE STRINGER S-9L, AT STA 930. REMOVED AFFECTED FASTENERS TO GET ACCESS IAW SRM 51-40-02-0G-0 REV 47. REPAIR DAMAGE AREA IAW W/S NO: 60010 (SRM 53-20-03-2R-1 REV 47) AND EI NO: T2026A53M-050 REV 1. INSTALLED FASTENERS IAW SRM 51-40-02-0G-0 SDR P5CA2026012000011Stringer Splice · crackedCRACK DAMAGE ON THE STRINGER AND STRINGER SPLICES S-10R, AT FWD AND FWD SIDE OF STA 2180. REPAIR DAMAGE AREA IAW W/S NO: 50871 (SRM 53-60-03-2R-3 REV: 47) AND EI NO: T2026A53M-076 REV 1. JOB COMPLETED AND CONDITION CHECK NORMAL.SDR P5CA2026012000012Stringer · crackedCRACK DAMAGE ON THE STRINGER S-3L, AT AFT SIDE OF STA 2360.(<P>1. REPAIR DAMAGE AREA IAW EI NO: T2026A53M-034 REV 1. 2. JOB COMPLETED AND CONDITION CHECK NORMAL.</P>)SDR P5CA2026012000013Battery Pack · no testFOUND EXTERIOR EMER LT (L6690) INOP. PERFORM WIRING CONTINUITY CHECK AND SYSTEM TROUBLESHOOTING IAW WDM 33-51-72 REV 35, FOUND M5168 BATTERY FUNCTION FAILED. PERFORM BATTERY REPLACEMENT AT M5168 IAW AMM 33-51-04-900-803 REV 49. CONDITION CHECK NORMAL AND PERSDR QMLA2026012120003Unknown · odorWHILE REPOSITIONING ACFT FROM GRIFFIN MX FACILITY BACK TO JASPER, NOTICED A BURNING ODOR IN THE COCKPIT. MADE TURNS TO BOTH SIDE FOR CREWMEMBERS TO SEE IF THERE WAS ANY SMOKE. KCNI WAS NEAR BY AS CREW MADE THE DECISION TO MAKE A PRECAUTIONARY LANDING THERE. MSDR AALA202601223423Unknown · odorAIRCRAFT WAS GROUNDED. FLIGHT DECK AND CABIN CREW NOTICED A VERY POTENT ODOR THROUGHOUT AIRCRAFT. NOTICED IT BELOW 10K FT DURING DESCENT AND REMAINED UNTIL SHUTDOWN AT GATE,. DESCRIBED AS A BURNING PLASTIC ODOR. (OPEN).SDR AALA202601229778Sign · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN FELL DOWN NEAR SEAT 10A. SECURED THE EMERGENCY EXIT SIGN IAW CMM 25-23-67.SDR AALA202601227779Track · looseAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY-D DOOR DIFFICULT TO OPEN. INSPECTED LAVATORY-D AND FOUND UPPER DOOR TRACK SCREWS LOOSE. RETIGHTENED SCREWS, OPS CHECK GOOD. PER AMM 25-40-14.SDR AALA202601229636Transmitter · faultyAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: UPON SELECTING FLAPS 15 ON APPROACH DEVELOPED A TRAILING EDGE ASYMMETRY; ONE FLAP NEEDLE STOPPED AT 7 DEGREES THE OTHER AT ABOUT 12 DEGREES. AIRCRAFT DIVERTED TO AND LANDED SAFELY AT JFK. REMOVED AND REPSDR AALA202601228764Fuel · out of balanceAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AT CRUISE NOTICED ENGINE #1 WAS IMBALANCED; EXPECTED FUEL AT DESTINATION WAS INDICATING 11K LBS AND WAS DROPPING FAST TO 10KLBS. AIRCRAFT DIVERTED TO AND LANDED SAFELY AT PHX. VERIFIED LEFT HAND FUEL QUASDR YENA2026012200062Unknown · odorFLT 37 BDL-MCO. WET SOCK ODOR AT ALT AND DESCENT. STARTED ABOUT 2 HRS INTO FLT. DID NOT SMELL IT ON THE FIRST LEG.; ONFO NOTICE 2017-T015M ACCOMPLISHED, BELLY INSP AND CLEANING, APU CLEANING OF THE AOS GEARBOX VENT, APU BAGGING PROCEDURE, AND LEVEL B DECONAMINSDR YENA2026012200061Outflow Valve · faultedFLT 115 JFK - SFO (ETOPS). VENT AVNCS SYS FAULT ON ECAM ( SKIN AIR OUTLET VALVE (AVIONICS) ).; (RESOLVED ON W/O: 1470897 TASKCARD: NR-00003 ) REMOVED AND REPLACED SKIN AIR OUTLET VALVE 22HQ W/ REF TO AMM 21-36-53 OPC600D. MDDR CLRD MX4 UPDATED PLACARD REMOVESDR DALA2026012200489Web · damagedELONGATED HOLE WEB FR 56 TO FR 57 AND STR 38L IN AFT CARGO BAY. REPLACED WEB AND FASTENERS LOC FR 56 TO FR 57 AND STR 38L IN AFT CARGO BAY IAW SRM 51-42- 11, SRM 51-72-11, AND DWG D53476318, ISSUE: N. (LP: 1413058)SDR DALA2026012200488Web · corrodedAFT FUSELAGE INTERNAL FLOOR STRUCTURE BTWN FR 69 & FR 70, S23L, WEB WITH CORRDED. REPLACED SHEAR PLATE IAW SRM 53-41-17-01A, FIGURE 001, ITEM 310A AND INSTALLED IAW DWG D534 74180, ISSUE U, SHEET 6.SDR CALA2026012213174Fuel Cap · missingFUEL CAP MISSING ON ARRIVAL. REPLACED THE FUEL CAP IAW AMM 28-25-41SDR CALA2026012213172Deck Plate · corrodedNUMEROUS AREAS OF HEAVY CORROSION ON AFT DECK PLATE FROM BS 1681 - 1720, LBL 60 - RBL 60. REMOVED, FABRICATED, & INSTALLED DECK PLATE IAW DWG 146N5318, & SRM 51-40-02.SDR CALA2026012213170Channel · crackedAFT CARGO BAY, RT ZEE CHANNEL HAD POSSIBLE CORROSION AND CRACKED BTW BS 727D & 727F. REPLACED THE ZEE CHANNEL BTW BS 727C - 727 G IAW SRM 51-40-02-0G-0, SRM 51-40-05-0G-0, SRM 51-40-08-0G-0, SRM 51-20-01-0G-0, & AMM 51-21-72-370-804.SDR CALA2026012213168Structure · corrodedAFT WET AREA, L2 DOOR INNER STRUCTURE HAD POSSIBLE CORROSION. REMOVED AND REPLACED L2 DOOR INNER STRUCTURE IAW SRM 51-40-02-0G-0, AND DWG 147A8501, REV B.SDR CALA2026012213166Transition Panel · corrodedAFT CARGO BAY, BS 1440 RT TRANSITION PANEL AND LOWER SPLICE HAD CORROSION. REMOVED AND REPLACED THE TRANSITION PANEL SPLICE IAW SRM 51-40-02-OG-0.SDR CALA2026012213164Transition Panel · corrodedAFT CARGO BAY, BS 1380-1440 RT TRANSITION PANEL LOWER & UPPER SURFACES HAVE CORROSION. REMOVED AND REPLACED THE TRANSITION PANEL BS 1380 - 1440, RBL 45 IAW SRM 51-40-02-OG-0.SDR CALA2026012213162Transition Panel · corrodedAFT CARGO BAY BS 1300-1320 RT TRANSITION PANEL LOWER SPLICE HAS EXFOLIATION. REMOVED AND REPLACED THE TRANSITION PANEL LOWER SPLICE BS 1310, RBL 45 - 50 IAW SRM 51-40-02-OG-0.SDR CALA2026012213160Transition Panel · corroded(SDR) 53-5300-1-0011: AFT CARGO COMPARTMENT STA 1480 LH TRANSITION PANEL LOWER SURFACE EXFOLIATED. REMOVED AND REPLACED TRANSITION PANEL IAW SRM 51-40-02-OG, & RESTORED SURFACE PROTECTION IAW SRM 5 1-21-01SDR CALA2026012213158Motor · bindingELETRIC TRIM MOTOR NOT WORKING MANUAL TRIM IS STIFF STAB TRIM MOTOR INOPERATIVE. REPLACED STAB TRIM MOTOR IAW AMM 27-41-71, OPS CHKD NORMAL. ACCOMPLISHED RII INSTALLATION AND OPERATIONAL TESTS.SDR CALA2026012213156Transition Panel · corrodedAFT CARGO COMPARTMENT BS 1200-1300 RT TRANSITIONAL PANEL UPPER & LOWER SURFACES HAD 10 SPOTS WITH CORRSION & 1 CRACK. REMOVED AND REPLACED THE TRANSITION PANEL IAW 51-40-01-0G & DRAWING 146N5391.SDR CALA2026012213154Transition Panel · corrodedAFT CARGO COMPARTMENT BS 1380 RT TRANSITION PANEL HAS EXFOLIATION. AFTER DETAIL INSPECTION, THE EXFOLIATION IS PRESENT IN 100% IAW SRM 51-10-08, REMOVED AND REPLACED TRANSITON PANEL IAW SRM 51-40-02-OG.SDR QMLA012120003Unknown · odorWHILE REPOSITIONING N325AM FROM MX FACILITY BACK TO JASPER, THE CREW NOTICED A BURNING ODOR IN THE COCKPIT. DISCUSSED PLACES TO LAND. MADE TURNS TO BOTH SIDE FOR CREWMEMBERS TO SEE IF THERE WAS ANY SMOKE. KCNI WAS NEAR BY AND AS A CREW, MADE THE DECISION TOSDR DALA2026012200478Wire · brokenEMERGENCY LIGHT AT SEATS 31 DEF & 33 DEF INOPERATIVE. REPAIRED BROKEN WIRES FOR EMERGENCY LIGHTS AT SEAT 31DEF & 33DEF IAW BSWPM 20. (LP 7356485)SDR DALA2026012200477Light · malfunctionedSEAT 19A OVERHEAD EMERGENCY LIGHT FLICKERING. ADJUSTED THE LIGHT IAW AMM 33-00. OPS CHKD GOOD. (LP 8581206)SDR 2026FA0000051Brake Disc · separatedWHILE TAXIIING AFTER LANDING THE PILOT APPLIED BRAKES AND THE AIRCRAFT VEERED LEFT OFF THE TAXI WAY AND INTO THE GRASS. MAINTENANCE REMOVED THE RIGHT WHEEL AND FOUND THE RIGHT BRAKE DISK HAD FULLY SEPARATED FROM THE MOUNTING FLANGE THAT BOLTS TO THE INNER WHEESDR SWAA2026012163401Battery Pack · inoperativeFOUND FWD LT EMERGENCY LIGHTS NOT WORKING. REMOVED AND REPLACED IAW AMM 33-51-06-960-802.SDR SWAA2026012163308Battery Pack · inoperativeAFT PAX DOOR EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED THE AFT LT BATTERY PACK (M1673) IAW MM 33-51-06 AND WDM 33-51-14-4.1. OPS CHECKED GOOD.SDR DALA2026012100463Seat Track · corrodedSEAT TRACK UPPER SURFACE FOUND CORRODED AT - Y953, FR 17 - FR 18. SEAT TRACK REPLACED IAW SRM 51-72-11-911-001. (1412491)SDR DALA2026012100462Seat Track · corrodedCABIN SEAT TRACK UPPER SURFACE FOUND CORRODED AT - Y2462, FR 61. SEAT TRACK REPLACED IAW SRM 51-72-11-911-001. (1412477)