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 AALA202512179538Lens · misinstalledAIRCRAFT IN BASE MAINTENANCE: INCORRECT EMERGENCY EXIT LENSE LAVATORY-D. INSTALLED CORRECT LIGHT LENS.SDR AALA202512175969Sensor · faultyAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AFTER TAKEOFF WHEN FLAPS WERE RETRACTED THE LEADING EDGE FLAPS TRANSIT LIGHT REMAINED ILLUMINATED AND THE NUMBER 2 SLAT TRANSIT LIGHT REMAINED ON. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT DFSDR DALA2025121709198Battery Pack · inoperativeDURING SVC FOUND ROW 26 TO 28 EMERGENCY LIGHT INOP. T/S PER B757 WDM 33-51-13 FOUND BATTERY PATH C/P UNSECURED. SECURED C/P PER B757 AMM 33-51 OPS CHECK NML. (7725037)SDR DALA2025121709196Door Frame · fodAT APPROX 16,000 - 17,000 FEET, L AFT ENT DOOR CAUTION MSG ILLUMINATED ON EICAS. CABIN PRESS NORMAL. OBSERVED EXCESS DEBRIS BUILD-UP ON L AFT ENTRY DOOR, CLEANED AS REQUIRED. REFERENCED QRH FOR CONFIG DEVIATIONS, NO DISCREPANCIES NOTED. (7692940)SDR DALA2025121709195Girt Bar · fodR1 DOOR SLIDE LIGHT DOESN`T LIGHT UP WHEN ARMED. FOD REMOVED FROM GIRT BAR. LIGHT WORKS NORMAL. (8497120)SDR IPXA2025121778168Slide · unwanted deployRIGHT UPPER DECK ESCAPE DOOR/SLIDE DEPLOYED. REINSTALLED NEW RH UPPER DECK ESCAPE SLIDE IAW AMM 25-68-01 UP TO AND INCLUDING STEP G. 9. VERIFIED SAFETY PINS REMOVED AND PROPER SYSTEM PRESSURES IAW AMM 25-68-01 AND GMM 04-02. COMPLETED REMAINING STEPS IAW AMM SDR IPXA2025121661336Fuel Sys · out of balanceDURING FLIGHT FUEL TRANSFERRED FROM RH TANK TO CENTER TANK. LOOKS ABOUT 200 LBS PER HOUR. NO EXTERNAL LEAKS FOUND, OBSERVED FUEL TRANSFERS FROM RIGHT TO CENTER. DEFERRED PER AMM 28-21-00-702-001 B(2)SDR IPXA2025121765208Slide · no discrepancyR1 SLIDE LOCK PIN INSTALLED INSTALLED LOCK PIN INTO REGULATOR/VALVE ASSY @ R1 SLIDE IRW MD11 AMM 25-61-15-000-801 STEP C (1) FOM SLIDE DEACTIVATION REF SUBTASK 10-10-07-550-008.SDR IPXA2025121779899Fuel Sys · out of balanceFUEL CONFIG EICAS MSG 2.5 HOURS INTO FLIGHT. LEFT TANK 2,000LBS HIGHER THAN RIGHT TANK. AIRCRAFT OK FOR SERVICE PER AMM 28-21-00-702-001. PERFORMED CROSSFEED LEAK CHECK PER AMM 28-22-02. NO LEAKS FOUND. OBSERVED PRESSURE REFUELING AND NO LEAKS FOUND AND NO FSDR IPXA2025121759362Fuel Sys · malfunctionedLANDED WITH NO CENTER FUEL. 10.8 ON SHUTDOWN. ADDED 69 GALS 400 LBS AND LT 9.1 C2.4 R7.8. LEAKING FUEL FROM RT TANK TO CENTER TANK. PERFORMED TANK TO TANK TRANSFER TO TRANSFER FUEL OUT OF THE CENTER IAW AMM 28-26-00-652-076. LEFT TANK IS AT 9.4, CENTER TANK ASDR LR7A2025121603798Rib · crackedDURING SCHEDULED B-2CHECK UNDER JOB CARD HB5303, FOUND RH FORWARD FUSELAGE RIB CRACKED AT FS156.75, RBL54, WL246. / REPAIRED IAW LOCKHEED SMP583 SRM, FIGURE 51-140-20. NR# 1001337203SDR LR7A2025121603797Window Frame · crackedDURING SCHEDULED B-2 CHECK UNDER JOB CARD HB5303, FOUND UNDOCUMENTED WINDOW FRAME REPAIR AT FS121-165, RBL28-54, WL237-260. / REPAIRED IAW LAC MEA 382-53-25-085. NR# 1001335934.SDR LR7A2025121603796Frame · crackedDURING SCHEDULED B-2 CHECK UNDER JOB CARD HB5303, FOUND CRACKED WINDOW FRAME AT FS151, RBL60, WL230. / REPAIRED IAW LOCKHEED SMP583 SRM, FIGURE 53-30-32. NR# 1001334880SDR LR7A2025121603795Bulkhead · crackedDURING SCHEDULED B-2 CHECK UNDER JOB CARD HB5302, FOUND LH FS1012 BULKHEAD OUTBOARD CAP CRACKED AT LBL70, WL271. / REPAIRED IAW LAC MEA 382-53-25-087. NR# 1001333438.SDR DALA2025121709192Spar · crackedA CRACK WAS FOUND ON THE RT WING REAR SPAR BETWEEN RIBS 4 AND 5. REPAIRED PER ERA 630537-14. (1354876)SDR DALA2025121709191Bottle · low pressureSHIP 3428 3R DOOR ASSIST BOTTLE LOW. SERVICED DOOR ASSIST BOTTLE PER A330 AMM 52-15. (8207216)SDR DALA2025121709190Stringer · deformedSTRINGER P'1 DEFORMED - RT FWD SIDE FR 63. CORRECTIVE ACTION: REPAIRED DAMAGED AREA PER ERA 628320-14 REV. ORIG. (1354812)SDR DALA2025121709189Bracket · damagedTOOLING DAMAGE ON BRACKET - LT AFT SIDE FR 62 STRINGER P4. REPAIRED PER ERA 628320-14 REV. ORIG. (1354549)SDR DALA2025121709188Support Bracket · damagedBS 40.1RT I/B LOWER RIVET ON SUPPORT BRACKET HEAD HAS TOOLING DAMAGE. REPAIRED PER ERA 628320-14 REV. ORIG. (1354896)SDR DALA2025121709185Wire · damagedEXIT LOCATION SIGN NEAR DOOR 4R IS INOPERATIVE. INSTALLED WIRES 3351-5186 AND 3351-5187 ON EXIT LOCATION SIGN 60WL PER A330 AWM 33-51-15, OPS CKS NORMAL PER A330 AMM 33-51. (7803735)SDR DALA2025121709184Wire · damagedEXIT LOCATION SIGN NEAR DOOR 4L IS INOPERATIVE. REPAIRED WIRING PER A330 AMM 33-51. OK FOR SERVICE. (7803734)SDR DALA2025121709179Bleed Air Sys · odorATB, RETURNED TO BNA CREW REPORTED DIRTY SOCK SMELL AFTER TAKEOFF. COMPLIED WITH TASK CARD 0550-2001. FOUND FAINT ODOR ONLY AT 20% N1 AND ABOVE. RT ENGINE BLEED DEFERRED. (LP# 7699534)SDR DALA2025121709181Unknown · odorVERY STRONG "DIRTY SOCKS" ODOR SMELLED IN CABIN BEFORE LANDING. FLIGHT DECK SMELLED VERY STRONG JUST AFTER LANDING. TURNED OFF BOTH ENGINE BLEEDS AND ODOR QUICKLY DISSIPATED. PREFORMED WORKCARD 0550-2001 UP TO STEP 8. PERFORMED P-TRK TEST ON #1 AND #2 ONLY AT SDR YENA2025121701228Engine · failedFLT # 1407 JFK-JFK (ETOPS). WHILE STARING ENG 2, ENG 1 FAILED.; REF TSI #78472 (NR-00001) ON W.O #1462918 FOR LPC BUFFER AIR VALVE / HPC BLEED VALVE/ DSU DATA DUMP ACCOMPLISHED. ALSO ACCOMPLISHED TEST NO. 4 - POWER ACCELERATION / DECELERATION TEST IAW AMM 71-SDR FDEA202512162258Actuator · failedLOUD THUD UPON GEAR EXTENSION COMING FROM NOSE WHEEL AND IT TOOK A LONG TIME FOR THE NOSE GEAR TO EXTEND AND THEN IT TOOK AN EVEN LONGER TIME FOR THE MAIN GEAR TO EXTEND WITH A THUD SOUND THEN ALL 3 WERE EVENTUALLY GREEN. (ABNORMALLY LONG, AND NOT IN SEQSDR AALA202512173069Engine · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO CLT DUE TO THE FLIGHT CREW REPORTING THAT WHILE CLIMBING THROUGH 6000 FEET THE #2 ENGINE FAILED. THE AIRCRAFT LANDED SAFELY AT CLT WITHOUT FURTHER INCIDENT. AFTER LANDING AND DURING SDR AALA202512176075Bottle · 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 AALA202512174228Wire · misinstalledAIRCRAFT WAS NOT GROUNDED: ROW 20 CEILING EMERGENCY LIGHT INOPERATIVE. MAINTENANCE CONFIRMED FAULT, FOUND WIRES IN WRONG POSITION, CORRECTLY POSITIONED THE WIRES AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER ESPM 20-40-00 AND AWM 33-51-02.SDR AALA202512177738Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202512176497Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR SIMA20251216001A/C Pack · failedPACK 1 FAIL AT ALTITUDE, RIGHT BEFORE FAILURE STRONG SMOKE SMELL, RAN QRH AND PACK FAILED 3 MINUTES AFTER ODOR DISSIPATED AFTER PACK FAIL FOLLOWING WORKSCOPE REQUEST AND FIM TASK 21-20-00-810-801-A PACK 2 OPERATING NORMALLY WITH NO NOTICEABLE SMELL PER EMB170 SDR CALA2025121712196Battery Pack · no testEMERGENCY LIGHT BATTERY M1675 FAILED A CAPACITY CHECK AND REQUIRES REPLACEMENT. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-51-06-960-805, OPS CHKD GOOD.SDR CALA2025121712194Battery Pack · no testEMERGENCY LIGHT BATTERY M1674 FAILED A CAPACITY CHECK AND REQUIRES REPLACEMENT. R & R THE BATTERY PACK IAW AMM 33-51-06-960-805 OPS CHK GOODSDR CALA2025121712192Skin · crackedNUMBER 2 PYLON INBD CANTILEVER SKIN HAS VERTICAL CRACK. REPAIRED NR 2 PYLON INBD CANTILEVER SKIN IAW SRM 54-52-12.SDR MASA2025121600101Light · missingPHOTOLUMINSCENT STRIP MISSING FWD CABIN. R & R PHOTOLUMIN STRIPS WITH RED MARKS.SDR MASA2025121600100Power Supply · faultedEMERGENCY LIGHT BATTERY FAULTED. R & R ELPU NR 3, OPS CHKD GOOD.SDR IPXA2025121600179Slide · no discrepancyL1 SLIDE LOCK PIN INSTALLED INSTALLED LOCK PIN INTO REGULATOR/VALVE ASSY @ L1 SLIDE IRW MD11 AMM 25-61-15-000-801 STEP C (1) FOM SLIDE DEACTIVATION REF SUBTASK 10-10-07-550-008. (T3F18E007XVZA STEP 10)SDR AALA202512162731Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT INOPERATIVE AT FLIGHT ATTENDANT SEAT L2 OTBD. REPLACED FLASHLIGHT AT FLIGHT ATTENDANT SEAT. PER AMM 25-64-00.SDR FDEA202512162256Battery Pack · no testL1 EMERGENCY EXIT LIGHT FAILS TO TEST DURING PRE-FLT. REMOVED AND REPLACED THE BATTERY PACK FOR THE L 1 DOOR EMERGENCY EXIT LIGHT IAW AMM 33-51-07-2 EMERGENCY EXIT LIGHT TEST NORMAL. BATTERY PACK RADIANT POWER CORP.SDR ABXA20251216342Smoke Detector · defectiveDURING MAINTENANCE INSPECTION, EICAS MSG AFT CARGO DET NR 1 ILLUMINATED. DEFERRED PER MEL 26-16-1-1-1. REMOVED AND REPLACED AFT CARGO SMOKE DETECTOR NR 1 PER AMM 26-16-01. CONFIG 1. OPS CHECK GOOD. AIRCRAFT RETURNED TO SERVICE.SDR DALA2025121609161Battery · inoperativeL1 DOOR EMERGENCY LIGHT INOPERATIVE. REPLACED BATTERY M1675 PER AMM 33-51.SDR DALA2025121609158Oxygen Mask · unwanted deployOXYGEN PANEL MASK DEPLOYED. RESECURED COMPARTMENT AT LAV 202 IAW AMM 35-21. (1353632).SDR DALA2025121609156Stringer · corrodedCORROSION STRINGER 41R LOC BTW FR63 TO FR64 IN AFT CARGO BAY. REPLACED STRINGER 41R IAW SRM 51-72-11 AND SRM 51-42-11. (1353612).SDR 2025FA0000831Proximity Switch · dirtyRIGHT MAIN LANDING GEAR WARNING LIGHT ILLUMINATED AFTER TAKE-OFF. RECYCLED THE GEAR AND LIGHT INDICATION WENT BACK TO NORMAL. PERFORMED VISUAL INSPECTION, CLEANED RIGHT MAIN LANDING GEAR SENSOR & TESTED PROXIMITY SWITCH. ELECTRONIC UNIT TESTED GOOD PER MD-80SDR 2025F00282Sensor · dirtyRIGHT MAIN LANDING GEAR ILLUMINATED RED AFTER TAKE-OFF. RECYCLED THE GEAR AND INDICATION WENT BACK TO NORMAL. PERFORMED VISUAL INSPECTION, CLEANED RIGHT MAIN LANDING GEAR SENSOR & TESTED PROXIMITY SWITCH ELECTRONIC UNIT TESTED GOOD IAW MD-80 AMM 32-60-04.SDR 2025FA0000830Beam · corrodedRT THRUST REVERSER OUTBOARD BEAM SHOWS SIGNS OF CORROSION.SDR 2025FA0000829Thrust Reverser · corrodedRT THRUST REVERSER INBOARD BEAM SHOWS SIGNS OF CORROSION.SDR 2025FA0000828Reverser Half · corrodedLEFT THRUST REVERSER UPPER DOOR SHOWS SIGNS OF CORROSION.SDR SWIA2025121577771Floor Support · damagedDAMAGE TO PRESSURE FLOOR SUPPORT AT BS 461.5, LBL 41, COMPLIED WITH A PERMANENT REPAIR ON LT PRESSURE FLOOR SUPPORT IAW REO 601R-53-41-3468, REV-. COMPLIED WITH ALL STEPS OF TASK CARD 51-90-1003-SKY.SDR SWIA2025121577770Frame · out of limitsINSPECTION OF LOWER FLANGE OF FRAME BEAM AT BS 513. COMPLIED WITH SB 601R-53-088, REV NC, REPAIRED THE BS 513 FRAME SECTOR LOWER FLANGE BTWN BL 27 & BL 45 LT & RT IAW REO 601R-53-41-3429, REV -. ALL STEPS COMPLIED WITH 1 THRU 17. COMPLIED WITH 51-900-1003 S