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 AALA202507161945Skin Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT WING TRAILING EDGE UPPER SKIN PANEL UPPER SURFACE AT RIB 3 AT THE INNER REAR SPAR. REPAIRED SKIN PANEL PER EA 363852.SDR 3EJA2025071600225Tire · puncturedLH MAIN TIRE APPEARED TO ROLL OVER FOD ON LANDING ROLL-OUT ON RUNWAY AND WENT FLAT AND CAME APART.SDR CALA2025071606632Bracket · looseDOOR 1R SLIDE COVER BRACKET LOOSE. ADJUSTED BRACKET TENSION OF GIRT BAR RETAINER. BAR SNAPS SECURLY INTO PLACE. OPS CHECK OKSDR CALA2025071606631Warning Light · false activationDOOR WARNING ANNUNCIATOR IS ON EQUIP VERIFY DOOR IS CLOSED AND LOCKED , APPLY MEL 5203G PERFORMED OPEN THE ELECTRONIC EQUIPMENT DOOR WHEN THE DOOR HANDLE WILL NOT MOVE IAW AMM 52-48-41-010-801 & PERFORMED ELECTRONIC EQUIPMENT ACCESS DOOR INDICATION SWITCH TESSDR CALA2025071606625Battery Pack · inoperativeDOOR 2R EMERGENCY POWER ASSIST SYSTEM BATTERY INOP. REMOVED AND REPLACED DR 2R EPAS BATTERY OPS CHECK GOOD REF. AMM 52-11-20.SDR CALA2025071606622Seal · faultedNR 1 ENGINE HAS EXPERIENCED AN INCREASE IN OIL CONSUMPTION. ACCOMPLISH A SNIFF CHECK OF OIL FOR FUEL ODOR, IAW AMM 12-13-01-130-803-002, STEP F.(1). ACCOMPLISH FIM 71-05 TASK 805, STEPS D.(1) TO D.(4) TO TROUBLESHOOT FOR HOC. PERFORMED TEST NR 6, PART POWER SDR VNAA20250715034Skin · gougedGOUGES AT HOLE COUNTERSINK TO LH WING FIXED L/E PANEL AT SLAT STA. 144.94. GOUGES AT HOLE COUNTERSINK TO LH WING FIXED L/E PANEL AT SLAT STA. 144.94 WAS REPAIRED PER REO 690-57-41-522 REV. - - .SDR SWAA2025071590692Lens · brokenEXIT LIGHT COVER LENS BY L1 DOOR BROKEN. R&R EXIT LIGHT COVER LENS IAW AMM 33-51-02SDR SWAA2025071590632Battery Pack · inoperativeFOUND MULTIPLE EMERGENCY LIGHTS INOP<[01] REMOVED AND REPLACED R/H FWD AND AFT BATTERY PACK REF AMM 33-51-06. OPS CHECK GOODSDR SWAA2025071590687Light · inoperativeFIRST 12-14 OF FLOOR STRIP LIGHTING LEFT SIDE NOT WORKING AIRCRAFT LEFT.<[01] REPLACED PHOTOLUMINESCENT FLOOR STRIP LEFT SIDE REF AMM 33-51-15.SDR SWAA2025071590770Glowstrip · deterioratedDUE TO REPORTS OF PHOTOLUMINESCENT STRIP LOCATED ON CENTER ISLE F/O'S SIDE FROM ROW 1 - 5 NOT GLOWING AS BRIGHT AS ADJACENT STRIPS; REPLACE THIS SECTION PER AMM 33-51-15.SDR SWAA2025071590691Glowstrip · deterioratedFIRST 5 SEATS OF EMERGENCY CARPET GLOW STRIP ON F/O'S SIDE IS NOT GLOWING. CW CLEANING OF FLOOR PHOTOLUMINESCENT STRIP PER AMM 33-51-15 OPS CK GOOD.SDR SWAA2025071590689Slide · looseFORWARD ENTRY DOOR ESCAPE SLIDE LOOSE. TIGHTEN/SECURED GRIT BAR STOW ENDS; PER AMM 25-66-00.SDR DALA2025071505333Girt Bar · disconnectedSHIP 6710 3L DOOR WILL NOT ARM. CORRECTIVE ACTION: FOUND GIRT BAR DISCONNECTED FROM ARM. ATTACHED GIRT BAR REF B757 AMM 25-66. (7281926)SDR AALA202507154291Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED UPPER CORNER FRAME AT FR 68 AND S8R. REPLACED UPPER CORNER FRAME PER SRM 51-72-11.SDR IPXA2025071597375Door · inoperativeDOOR 1L WILL NOT SHUT CORRECTLY ENOUGH TO ARM THE DOOR. COMPLETED INSTALLATION OF THE FORWARD PASSENGER DOOR DRIVE CABLES REF AMM 52-11-03 THRU STEP E. (9). SPECTED,OK TO REINSTALL L1 DOOR ESCAPE SLIDE , REF GMM 04-01-01. FINISHED INSTALLATION OF FORWARD PASSDR DALA2025071505325Receiver · out of adjust(LOG 6402398) L1 DOOR WILL NOT CLOSE / LATCH. ADJUSTED UPPER 2 RECEIVER'S 2 TEETH AND LOWER 2 RECEIVER'S 1 TOOTH, IN AN ALL 4. DOOR OP CK'S GOOD. ALL PER B737 AMM 52-11-00-820-801.SDR DALA2025071505324Hinge · out of adjustSHIP 3759 -ATB/DE- DUE TO L1 DOOR SQUEAL. CORRECTIVE ACTION: LOWER HINGE COVER CONTACTING FORWARD LAVATORY WALL. ADJUSTED HINGE AND PERFORMED DOOR RIG PRECAUTIONARY. OPS CHECK GOOD.SDR DALA2025071505323Seat Track · worn(LOG 1078996) WORN SEAT TRACK LBL 24 STA 520 WITH ORIGINAL THICKNESS CROWN IS 0.146IN AND REMAINING THICKNESS IS 0.080IN. SEAT TRACK LBL 24 FROM STA 500H TO STA 500H +10IN WAS REPAIRED PER B737-800 SRM 53-00-52-2R PROCEDURE 4 REPAIR 4.SDR DALA2025071505322Seat Track · worn(LOG 1078985) WEAR ON SEAT TRACK RBL 24, FSTA 520 AT PASSENGER CABIN STRUCTURE. SEAT TRACK RBL 24, FSTA 520 AT PASSENGER CABIN STRUCTURE WAS REPAIRED PER B737-800 SRM 53-00-52-2R PROCEDURE 4.SDR DALA2025071505321Floorbeam · corroded(LOG 1078644) CORROSION OUT OF LIMITS IN REF. NRC 0471: CORROSION ON FLOOR BEAM BTW STA 986 BL 0 TO LBL49. FLOOR BEAM BTW STA 986 BL 0 TO LBL49 WAS REPAIRED PER ER/A 464736-14MA REV A.SDR DALA2025071505320Frame · not reported(LOG 1077578) ACCOMPLISH AMDS 5311-01251-02B - RIGHT HAND STA 727 FRAME INNER CHORD 737 SECTION 02. ACCOMPLISHED AMDS 5311-01251-02B - RIGHT HAND STA 727 FRAME INNER CHORD, 737 REPAIR; RII; SECTION 02.SDR DALA2025071505319Frame · not reported(LOG 1077573) ACCOMPLISH AMDS 5311-01251-02A - LEFT HAND STA 727 FRAME INNER CHORD 737 REPAIR SECTION 02. ACCOMPLISHED AMDS 5311-01251-02A - LEFT HAND STA 727 FRAME INNER CHORD, 737 REPAIR; RII; SECTION 02.SDR DALA2025071505318Computer · faultedSHIP 3252 - MISC - DECLARED EMERGENCY FOR SUSPECTED FUEL LEAK. CENTER TANK QUANTITY FLUCTUATING. MEL ALREADY APPLIED FOR CENTER TANK AUTO FEED SYSTEM. CORRECTIVE ACTION: REPLACED FQIC. (LP: 7745944)SDR VNAA20250715027Panel · gougedGOUGES AT HOLE COUNTERSINK TO LH WING FIXED L/E PANEL AT SLAT STA. 144.94. GOUGES AT HOLE COUNTERSINK TO LH WING FIXED L/E PANEL AT SLAT STA. 144.94 WAS REPAIRED PER REO 690-57-41-522 REV. - - .SDR DALA2025071505305Sensor · faultedSHIP 3420 DOOR 1R INDICATES OPEN DESPITE BEING CLOSED+LATCHED. CORRECTIVE ACTION: R/R 10MJ PER A330 AMM 52-71. OPS CHK GOOD. BITE TEST GOOD. (7435136)SDR SIMA20250712003Door · no discrepancyGATE AGENTS HAVING ISSUES WHEN OPENING MAIN PASSENGER DOOR L1. OPENED DOOR IAW GHC, FOUND DOOR OPENS AND CLOSES AS INTENDED.SDR SIMA20250712001Light · out of alignmentCENTER AISLE PHOTOLUMINESCENT EMERGENCY LIGHT STRIP MISALIGNED. REALIGNED PHOTOLUMINESCENT EMERGENCY LIGHT IAW PS CHECK.SDR SIMA20250712002Unknown · odorPACK 1 EMITS STRANGE SMELL OF DEPARTURE THAN CAME BACK ON ARRIVAL ITEM DEFERRED PER MEL 21-44 . PERFORMED OPC OF COOLING PACKS IAW AMM 21-51-00. COULD NOT DUPLICATE SMELL ON EITHER PACK. OPC GOOD. MEL RESTOREDSDR DXTA2025071504227Sign · inoperativeDURING POWER-ON CHECK DISCOVERED EMERGENCY EXIT SIGN ABOVE SEAT 9 INOP. FOUND BROKEN WIRE AT SPLICE CRIMPED NEW PIN AND INSTALLED NEW SPLICE. OPS CHECK GOOD PER AMM 33-50-00.SDR DXTA2025071504228Light · inoperativeEXIT SIGN OVER SEAT 7 WILL NOT ILLUMINATE DURING PRE-FLIGHT EMERGENCY LIGHTING TEST. ATTEMPTED TO CHARGE BATTERY PACK PER TEXTRON PROCEDURE WITH NO RESULTS. MAIN CABIN DOOR EMERGENCY LIGHTS ARE ALL FUNCTIONING NORMALLY AS REQUIRED PER MEL 33-50-03. REMOVED DSDR UIEA2025071200934Flashlight · inoperativeFLASHLIGHT NEAR R1 DOOR INOP. REMOVED AND REPLACED FLASHLIGHT IAW AMM 25-64-01, OPS CHECK GOOD. THIS CLEARS MDDR 234035.SDR ASAA2025071259392Battery Pack · inoperativeDURING T/C 78233008 FOUND EXT OVERWING EMERGENCY EXIT LT FOR LH WING INOP. GROUNDED - YES. THERE WERE SEVERAL EMERGENCY LIGHTS OUT. REMOVED AND REPLACED BATTERY PACK M2335 IAW AMM 33-51-06-960-805, OPS CHECKS GOOD. CLEARS MEL 33-14C, SEAMC NOTIFIED. NO AIRCRAFSDR SWAA2025071490529Scuff Plate · crackedFWD CARGO DOOR CENTER SCUFF PLATE IS CRACKED. REMOVED AND REPLACED FWD CARGO DOOR CENTER SCUFF PLATE AND APPLIED FILLET SEALANT PR-1826 B1/2 IAW AMM 53-11-02-420-801; AMM 51-31-00-390-804 AND SOPM 20-50-11.SDR SWAA2025071490530Scuff Plate · crackedFWD SERVICE DOOR SCUFF PLATE IS CRACKED. REMOVED AND REINSTALLED FWD SERVICE SCUFF PLATE IAW AMM 53-11-01-000-801 AND 53-11-01-420-801.SDR QXEA2025071400277Throttle · malfunctionedFLIGHT 2233. AUTOTHROTTLE FAILED ON CLIMBOUT . PLACED ON MEL 22-30-00B. MEL CLEARED BY INTERROGATED CMC FOUND FAULT CODE 22310078TA2 REPLACED THRUST CONTROLER QUADRANT I.A.W E175 AMM TASKS 76-11-01-000/400-801-A OPS TEST GOOD RETURNED TO SERVICE.SDR QXEA2025071400276Fadec · malfunctionedREPLACE #2 FADEC DUE TO ECMP REQUEST. FADEC REPLACED.SDR SWIA2025071400012Wire Harness · brokenGEAR DISAGREE AFTER TAKEOFF. CLEARED VIA CHECKLIST. NOSE WHEEL WAS THE AFFECTED DOWN (FLIGHT 5555 - FILED CLOSED)THIS DISCREPANCY WAS TRANSFERRED TO CAMP ITEM 30474800 WITH THE FOLLOWING CORRECTIVE ACTION: "FOUND NOSE LANDING GEAR ELECTRICAL HARNESS ASSY. BRSDR DALA2025071405283Ecs · odorSHIP 3161 FA'S REPORTED A DIRTY SOCK, GYM BAG SMELL IN CABIN FROM ARRIVAL TO GATE. PERFORMED LEVEL A DECON OF ECS PER AMDS CARD 2100-2001. RECIRC FILTERS CHANGED. (7459769).SDR DALA2025071405281Protector · faultedSHIP 3136 L/G SYS DISAGREE ECAM MSG AFTER LANDING. COMPLETED INSP AND TARGET CLEARANCE ON NLG PROX SENSOR 25GA IAW A319AMM 32-31-73-200-002-A. R/R 25GA PROX SENSOR REF A319 AMM 32-31.SDR DALA2025071405298Structure · corrodedSHIP 3130 WHILE INSPECTING PER JIC 2750-1020-RT CORROSION FOUND IN THE INB'D AND OUTB'D ALUMINUM PLATES. REPAIRED PER ER/A 627155-14.SDR DALA2025071405277Roller · looseSHIP 3155 LOOSE CRUISE ROLLER OB FLAP ON LH WING. REPLACED CRUISE ROLLER OB FLAP ON LH WING AS PER AIRBUS CMM 57- 53-21 TASK 57-53-21-000-810-A01.SDR DALA2025071405297Oxygen Mask · unwanted deploySHIP 3309 OXYGEN MASKS AT SEAT 41 C,D,E,F DROPPED DURING TAKEOFF. RESECURED ALL OXYGEN MASKS PER A330 AMM 35-21 MASKS GOOD FOR SVC. (6603398)SDR DALA2025071405295Oxygen Mask · damagedSHIP 3413 CREW REST BUNK 4 OXY MASK DAMAGED / OUT OF PLACE. RE-PACKED MASKS PER A330 AMM 35-23. OK FOR SERVICE.SDR AALA202507143084Sensor · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO DFW DUE TO THE FLIGHT CREW REPORTING A VENT SKIN VALVE FAULT ON ECAM. THE AIRCRAFT LANDED SAFELY AT DFW AND TAXIED TO THE GATE UNDER ITS OWN POWER. MAINTENANCE REPLACED THE SKIN EXCHSDR AALA202507141191Cids · no testAIRCRAFT WAS NOT GROUNDED: CLASS 1 FAULT ON CIDS FOR EMERGENCY POWER SUPPLY UNIT 13WL. MAINTENANCE REPLACED EMERGENCY POWER SUPPLY UNIT 13WL PER AMM 33-51-38 (AALA202507139220) AND THE #1 CIDS DIRECTOR PER AMM 23-73-34. ( ) A SATISFACTORY OPERATIONAL CHECK WASSDR AALA202507149384Outflow Valve · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO DFW DUE TO THE FLIGHT CREW REPORTING A VENT SKIN VALVE FAULT ON ECAM. THE AIRCRAFT LANDED SAFELY AT DFW AND TAXIED TO THE GATE UNDER ITS OWN POWER. MAINTENANCE REPLACED THE SKIN EXCHSDR AALA202507143970Battery · no testAIRCRAFT WAS NOT GROUNDED: BATTERY FAULT MESSAGE FOR EMERGENCY POWER SUPPLY UNIT 16WL DISPLAYED DURING OPERATIONAL TEST OF THE EMERGENCY LIGHTING SYSTEM. REPLACED BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR AALA202507145018Proximity Sensor · faultedAIRCRAFT WAS GROUNDED: LEFT WING OVERWING HATCH SHOWS UNLOCKED. REPLACED LEFT HAND OVERWING EMERGENCY EXIT DOOR SENSOR 33WN1 AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 52-71-13.SDR AALA202507145806Bottle · no testAIRCRAFT IN BASE MAINTENANCE: PASSENGER CREW DOOR 831, DOOR DAMPER AND EMERGENCY OPERATION CYLINDER DOES NOT PASS THE DOOR DAMPING FUNCTION OPERATIONAL TEST. REPLACED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-11-14.