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 AALA202509229050Shade · inoperativeAIRCRAFT WAS NOT GROUNDED: 14 F EMERGENCY EXIT WINDOW SHADE WILL NOT OPEN. (OPEN)SDR AALA202509226781Slide Raft · fault messageAIRCRAFT WAS GROUNDED: REF MIC# 1534536 FAULT "EPSU EXT LOAD FWD L" FOUND ON SYS TEST.BITE CHECK OF EPSU PER MM 33-51-00 FOUND RED LIGHT ILLUMINATED FOR "EXTERIOR LIGHTS FAULT". PER TSM 33-51-00-810-822-A WILL REQAVI WIRE CHECKS.SDR AALA202509222161Power Supply · fault messageAIRCRAFT WAS GROUNDED: REF MIC# 1534536 FAULT "EPSU EXT LOAD FWD L" FOUND ON SYS TEST,AND ALL ADDITIONAL MX CONDUCTED. MAINTENANCE REPLACED EPSU(10WL) UNIT FWD LH SIDE PER AMM 33-51-38.SDR AALA202509223914Light · incorrectAIRCRAFT WAS NOT GROUNDED: SEAT MOUNTED EMERGENCY LIGHT WAS IN WRONG CONFIGURATION AT ROW 1(RED), SHOULD BE WHITE COLORED LIGHT. MAINTENANCE REPLACED RED EPL WITH WHITE EPL PER CMM 25-20-85, OPS CHECK GOOD.SDR AALA202509222012Wire · brokenAIRCRAFT WAS GROUNDED: SEAT MOUTED EMERGENCY LIGHT AT ROW 14 (RED) AND ROW 27 (WHITE) INOP. MAINTENANCE REPAIRED BROKEN WIRE AT PLUG IAW ESPM 20-48-21 AT ROW 27. RESEATED PLUG AT ROW 14, BOTH OPS CHECKED GOOD IAW AMM 33-51-00.SDR AALA202509221397Bottle · no testAIRCRAFT WAS GROUNDED: DONT PASS OPERATIONAL TEST OF OF THE DOOR DAMPER AND EMERGENCY OPERATON CYLINDER AT DOOR 832. MAINTENANCE REPLACED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER AT DOOR 832 I.A.W AMM52-13-14-000-001-B AND AMM 52-13-14-400-001-B REFER TO ISDR AALA202509222834Sign · inoperativeAIRCRAFT WAS NOT GROUNDED: XAISLE EXIT SIGN FWD FACING AT ROW 10 BELOW LIMITS. MAINTENANCE REPLACED EXIT SIGN LIGHT ASSY AMM 33-51-00 OPS OK.SDR AALA202509222060Sign · inoperativeAIRCRAFT WAS NOT GROUNDED: X AISLE EXIT SIGN L1 DOOR BELOW LIMITS FOR INDIVIDUAL LIGHTS INOP. MAINTENANCE REPLACED LIGHT ASSY EXIT SIGN L1 OVER DOOR IAW AMM 33-51-16.SDR AALA202509222280Sign · degradedAIRCRAFT WAS NOT GROUNDED: L2 DOOR EXIT SIGN OVERDOOR LIGHTING DEGRADED. MAINTENANCE REPLACED EMERGENCY EXIT SIGN IAW AMM 33-51-17.SDR AALA202509221683Sign · degradedAIRCRAFT WAS NOT GROUNDED: X AISLE EXIT SIGN AFT FACING AT ROW 10 HAS LIGHTING DEGRADED. MAINTENANCE REPLACED EMERGENCY EXIT SIGN IAW AMM 33-51-17.SDR AALA202509222592Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN REAR SPAR VAPOR BARRIER SUPPORT ANGLE LOCATED AT BS 663, RBL 3. REPAIRED ANGLE PER EA 367672.SDR AALA202509221988Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN SECTION REAR SPAR VAPOR BARRIER SUPPORT ANGLE, OUTBOARD SIDE, LOCATED AT BS 663, LBL 3. REPLACED ANGLE PER SRM 57-10-10-2R-5.SDR DALA2025092206929Skin · dentedWHILE PERFORMING DENT DOT MONITOR INSPECTION FOR LOG PAGE 6784736, FOUND ADDITIONAL DAMAGE AT DENT LOCATION 13" AFT OF STA 1197+66 AND 3" BELOW STR 35L. REPAIRED PER B767 SRM 53-00-01-2R-12 DETAIL I. REPAIR IS CAT B. (1205512)SDR R61A2025092200413Skin · dentedBIRD STRIKE CAUSING DENT ON FWD FUSELAGE BETWEEN FR. 5-6 STR 10R-12R. CUTOUT DAMAGE AND INSTALLED A 2 ROW DOUBLER.SDR MASA202509180075Brake · inoperativePARKING BRK NOR RELEASED CTN INFLT/REPLACED EMER PARK BRAK VALVE, LEAK/OPS CHECK GOOD.SDR YENA2025092200951Unknown · odorFLT#1255, FLL-GYE. "CABIN CREW IN FWD CABIN REPORTS ODOR FROM INTIAL CLIMB OUT. AND AGAIN ON APPROACH TO LANDING. DESCRIBE AS CHEMICAL NOT DIRTY SOCK.SDR DALA2025092206918Wire · chafedEMERGENCY LIGHTS ILLUMINATE WITH OVERHEAD PANEL EMER EXIT LIGHTS SWITCH IN THE ARMED POSITION. CHAFING OF WIRING (W3142-0404-22 AND W3142-0403-22) WAS CORRECTED AT STA 727C+13 PER BOEING ALL SWPM 20-10-13.SDR DALA2025092206910Bracket · unsecureRIGHT OVERWING SLIDE WILL NOT TEST. FOUND GRD BRAKET NOT SECURED. SECURED GRD BRACKET GD03012D. ALL CHECKS GOOD PER B757 AMM 25-61. (7330118)SDR DALA2025092206907Guide Arm · separatedL2 DOOR NOT CLOSING. FOUND GUIDE ARM SERATED PLATE BOLTS LOOSE AND GUIDE ARM SERATED PLATE NOT IN CORRECT POSITION. PERFORMED RIG OF GUIDE ARM / SERATED PLATE AND SECURED ALL SERATED PLATE BOLTS PER B757 AMM 52-11 L-2 DOOR CKS GOOD. (7714890)SDR DALA2025092206903Plate · missingL4 DOOR UPPER FWD BEARING PLATE MISSING. INSTALLED NEW BEARING PLATE PER B757 AMM 52-11. (5694265)SDR UIEA2025091801240Windshield · failedRIGHT FORWARD OUTER WINDSHIELD BROKE. R & R RIGHT FORWARD WINDSHIELD ASSY IAW AMM 56-11-00. OPS CHK OK.SDR SWAA2025092216415Battery Pack · inoperativeFO SIDE AFT FLASHLIGHT TEST LIGHT NOT WORKING. R&R BATTERY PACK PER M/M SIPSDR SWAA2025092216293Flashlight · inoperativeFLASHLIGHT AFT GALLEY FO'S SIDE INOPERATIVE. R & R RT AFT GALLEY FLASHLIGHT REF AMM 25-64-00. OPS CHECK GOODSDR SWAA2025092215998Slide · looseFWD SVC DOOR EMER SLIDE LOOSE. REMOVED AND REINSTALLED FWD SVC DOOR SLIDE AS REQUIRED REF MT 725-61-06.SDR SWAA2025092216314Cover · missingEXIT SIGN COVER MISSING ON EXIT ROW AIRCRAFT RIGHT. REPLACED IGHT ASS PER AMM 33-51-01. OPS CK GOOD.SDR SWAA2025092215809Bracket · crackedL/H WING UPPER TRAILING EDGE SHELF PANEL BETWEEN #5  SPOILER LOWER CENTER SUPPORT BRACKET CRACKED<[01] REMOVED AND REPLACED L/H WING TRAILING EDGE SUPPORT WEB BRACKET P/N 115A2982-9 ON UPPER FIXED PANEL PER AMM 20-50-11 AND SRM 51-10-02 PARAGRAPH 9 REPAIRABSDR SWAA2025092216320Girt Bar · stuckCREW REPORTS R1 DOOR GIRT BAR STUCK IN SLIDE PACK.<[01] FREED R1 DOOR GIRT BAR AND CHECKED FIT IN FLOOR FITTINGS. NO ISSUES NOTED REF AMM 25-66-00.SDR CALA2025092209096Beam · gougedLEFT AFT EMERGENCY HATCH INTERNAL STRUCTURE ABOVE WINDOW HAS 2 GOUGES WITH EVIDENCE OF CORROSION. REMOVED AND REPLACED L/H AFT EMERGENCY HATCH BEAM SUPPORT IAW A320 SRM 51-42-11.SDR CALA2025092209095Beam · gougedLH FWD EMERGENCY EXIT HATCH UPPER HORIZONTAL BEAM HAS 2 NOTCHES AND GOUGES FROM CHAFING ON LINER FASTENERS. REMOVED AND REPLACED L/H FWD EMERGENCY HATCH SUPPORT BEAM IAW A320 SRM 51-42-11.SDR CALA2025092209094Oil System · leakingWHILE RUNNING THE APU BLEED THERE IS A STRONG ODOR IN THE CABIN. TS APU FOR SOUCE OF ODOR/OIL LEAKS. ACCOMPLISHED AMM 21-00-01-002-001 REMOVAL OF OIL CONTAMINATION FROM THE AIR CONDITIONING AND PNEUMATIC SYSTEMS. RAN PACK FOR SEVERAL HOURS. ODOR IS NO LONGER SDR CALA2025092209093Skin · dentedDAMAGE NOTED FWD OF D2LREF SRM 53-030-01-1A-2, VERTICAL DENT MEASURED AT 7.25" WITH A MAX MEASURED DEPTH OF 0.019". DENT LOCATION MEASURED TO BE 17" AFT OF STA 655. TOP OF DENT MEASURED TO BE 24" BELOW S24L. FOR 4X PREVIOUS DENTS, SEE LP 3269188 ADD EMP:U33028SDR CALA2025092209092Beam · gougedAFT LH EMERGENCY HATCH INTERNAL STRUCTURE HAS CORROSION AT THE SECOND FROM THE BOTTOM SUPPORT STRUCTURE. R & R SUPPORT BEAM AT AFT L/H EMERGENCY HATCH IAW A320 SRM 51-42-11.SDR CALA2025092209091Beam · gougedRIGHT FWD EMERGENCY HATCH INTERNAL STRUCTURE ABOVE WINDOW HAS 2 GOUGES WITH EVIDENCE OF CORROSION. R AND R BEAM SUPPORT AT RH FWD EMERGENCY HATCH INTERNAL STRUCTURE IAW A320 SRM 51-72-11.SDR CALA2025092209075Power Supply · no testEMERGENCY LIGHTING SYSTEM OPERATIONAL CHECK, FOUND FLOOR PROXIMITY LIGHTS INOPERATIVE IN EXIT ROWS 15,20 AND 21. REMOVED AND REPLACED EMERGENCY LIGHT POWER SUPPLY. OPS CHECKED GOOD.SDR CALA2025092209074Battery Pack · inoperativeEMERGENCY LIGHTS ON SEATS 7-14 INOPERATIVE. REMOVED & REPLACED BATTERY PACK FOR SECTION, ALL LIGHTS OPERATIVE IAW AMM 33-51-06-960-805.SDR AALA202509216976Elec Connector · damagedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHT CONNECTOR UNDER SEATS 8ABC IN P2 POSITION IS DAMAGED. REPLACED CONNECTOR PER SWPM 20-61-28. ACCOMPLISHED SATISFACTORY EMERGENCY LIGHTING OPERATIONAL CHECK PER AMM 33-51-00.SDR 2025FA0000660Smoke Detector · defectiveDEPARTING KSRQ 9/18/25, THE CREW NOTICED THE CABIN FIRE WARNING LIGHT ILLUMINATED. THE SYSTEM SENSOR IS IN THE CABIN AREA BAGGAGE COMPARTMENT. THE CAPTAIN INSTRUCTED THE FO TO GO BACK AND VISUALLY INSPECT THE BAGGAGE COMPARTMENT. NO SMOKE WAS NOTICED. THE CAPTSDR AALA202509209771Brake Assy · vibrationAIRCRAFT WAS GROUNDED: EXTREME VIBRATION WHEN BRAKING, ESPECIALLY ONCE THE BRAKES GET HOT. REMOVED AND REPLACED NUMBER 2 MLG TIRE (AALA202509205254) AND NUMBER 2 MLG BRAKE (AALA202509205401), PER AMM 32-45-11 AND 32-41-41. BLEED HYDRAULICS BRAKE SYSTEM-A AND-SDR AALA202509208866Fuel Sys · malfunctionedAIRCRAFT WAS GROUNDED: DURING CRUISE FUEL IN WOULD MOVE INTO THE CENTER TANKS WHILE FUEL PUMPS WERE OFF. (OPEN).SDR AALA202509207052Wheel · vibrationAIRCRAFT WAS GROUNDED: EXTREME VIBRATION WHEN BRAKING, ESPECIALLY ONCE THE BRAKES GET HOT. REMOVED AND REPLACED NUMBER 2 MLG TIRE (AALA202509205254) AND NUMBER 2 MLG BRAKE (AALA202509205401), PER AMM 32-45-11 AND 32-41-41. BLEED HYDRAULICS BRAKE SYSTEM-A AND-BSDR AALA202509203794Slide · faultyAIRCRAFT WAS GROUNDED: L1 DOOR GIRTBAR IS EXTREMELY HARD TO DISARM. REMOVED AND REPLACED L1 EMERGENCY SLIDE. PER J/C 08L22125001.SDR AALA202509205552Door Seal · fodAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AFTER TAKEOFF LOUD SQUEAL COMING FROM THE DOOR POSSIBILITY OF A LEAK AT THJE FORWARD RIGHT SERVICE DOOR. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT MIA. INSPECTED R1 DOOR AND FOUND DEBRIS LODSDR HALA20250919284Line · leakingETOPS - ENG #2 OIL CONSUMPTION OUT OF LIMITS. PERFORMED INSP. FOR EXT LEAKS PER TSM 79-31-00-810-832-A, FOUND LEAKAGE AT HP/LP OIL FEED TUBE. REMOVED, INSPECTED AND REPLACED OIL FEED TUBE PER AMM 70-51-00-910-802, OPS AND LEAK CHECK GOOD.SDR HALA20250919283Bmc · damagedETOPS - AIR L WING LEAK DET FAULT ON ECAM. FOUND BMC 2 BOX DAMAGED. REMOVED AND REPLACED BMC 2 PER AMM 36-11-34. CONDITION SAME. REMOVED BMC 1 & BMC 2 OPEN C/B'S C73 & T34. LOOP CONNECTORS AT 382HF DISCONNECTED PER AMM 36-22-00-810-909-A. 382HF 275OHMS TO BMC SDR ASAA2025091860955Power Supply · inoperativeCABIN EMERGENCY LIGHTS FAILED OPS CHECK. GROUNDED - YES. REPLACED EMERGENCY LIGHTS BATTERIES, ON CARD 1023360-9000-0001, OPS CHECK GOOD IAW B737-900 AMM 33-51-00-710-801.SDR ASAA2025091860954Power Supply · inoperativeCABIN EMERGENCY LIGHTS FAILED OPS CHECK. GROUNDED - YES. REPLACED EMERGENCY LIGHTS BATTERIES, ON CARD 1023360-9000-0001, OPS CHECK GOOD IAW B737-900 AMM 33-51-00-710-801.SDR ASAA2025091860953Power Supply · no testCABIN EMERGENCY LIGHTS FAILED OPS CHECK. GROUNDED - YES. REPLACED EMERGENCY LIGHTS BATTERIES, ON CARD 1023360-9000-0001, OPS CHECK GOOD IAW AMM 33-51-00-710-801.SDR SWAA2025091915879Battery Pack · inoperativeEMERGENCY EXIT LIGHTS ARE INOP AT THESE LOCATIONS: BOTH EXTERIOR OVER WING EXIT LIGHTS; INTERIOR OVER WING LOWER EXIT SIGN AT SEATS 15CBA; 15ED. REMOVED AND REPLACED EMERGENCY BATTERY PACKS AT M1670; AND M1695. OPS CHECKS GOOD. IN REF TO AMM 33-51-06.SDR SWAA2025091915881Light · inoperativeEMERGENCY EXIT LIGHTS ARE INOP AT THESE LOCATIONS: COCKPIT DOME LIGHT; L1 DOOR LOWER INTERIOR EXIT SIGN; L1 DOOR EXTERIOR LIGHT; AND OVERHEAD EXIT SIGN ABOVE COCKPIT DOOR.<[01] 01 - REMOVED AND REPLACED M1675 PER AMM 33-51-06-960-805-NG. OPS CK GOODSDR SWAA2025091915880Battery Pack · inoperativeEMERGENCY EXIT LIGHTS ARE INOP AT THESE LOCATIONS: ROW 14FED; AND 15ED WINDOW LIGHT EMERGENCY LIGHTS; OVERHEAD BIN EMERGENCY LIGHTS FROM ROWS 5CBA THROUGH 23CBA. REMOVED AND REPLACED EMERGENCY BATTERY PACK AT M2335. OPS CHECKS GOOD. IN REF TO AMM 33-51-06.