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 SCNA20251201453Wire · shortedINTERMITTENT SMELL OF SHORTING WIRE OR ELECTRICAL NEAR CAPTAINS SIDE MASTER CAUTION DURING FLIGHT PERFORMED AMM TASK 21-00 TASK 801 NO SMELL NOTED AT THIS TIMESDR ABXA20251127309Warning Message · illuminatedDURING TAXI OUT LT AFT FUEL PUMP EICAS, QRH COMPLETE. ACFT RETURNED TO THE GATE (BTB) AND MTX GROUNDED A/C. MTX DEFERRED LEFT AFT FUEL PUMP IAW MEL ABX-28-22-1 . AND RETURNED A/C TO SERVICE .SDR AALA202511287407Door · no discrepancyAIRCRAFT WAS NOT GROUNDED: FORWARD RIGHT EMERGENCY COMPARTMENT DOOR NUMBER 4, WILL NOT OPEN. OPENED AND LUBED COMPARTMENT DOOR ON FORWARD RIGHT WITH EMERGENCY EQUIPMENT INSIDE. OPENS AND CLOSES NORMALLY.SDR AALA202511287744Power Supply · no testAIRCRAFT WAS NOT GROUNDED: 4 ROWS IN FIRST CLASS HAS EMERGENCY LIGHTS OUT. REMOVE AND REPLACED EMERGENCY EXIT LIGHT POWER SUPPLY M1674. PER AMM 33-51-06.SDR AALA202511287618Light · inoperativeAIRCRAFT WAS NOT GROUNDED: EXTERIOR EMERGENCY LIGHT BEHIND R1 DOOR INOPERATIVE. RELAMPED BLUB AT R1 SLIDE OVERWING LIGHT. PER AMM 33-51-04.SDR AALA202511281293Sign · dislodgedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT AT ROW 12C IS HANGING BY THE WIRES. REATTACHED LIGHT ASSEMBLY ON SEAT ROW 12C. PER AMM 25-22-00.SDR F3LA202511280332Clamp · unsecureENGINE NR 2 FIRE ON TAKEOFF. NO AGENT DISCHARGED. ENGINE NR 2 IN FLIGHT SHUTDOWN. CLAMP AT THE 6 0'CLOCK POSITION ON THE BLEED DUCT WAS LEFT REMOVED. R & R CLAMP & ECS DUCTING IAW AMM 36-11-49-400-827A STEPS 4-A(6) AND MULTIPLE HARNESSES IAW AMM 71-52-43-00SDR N6WA2025112806Frame · crackedFRAME 333 CRACKED AT FREE FLANGE TO LIGHTNING HOLE STGR1R-2R. REMOVED AND REPLACED FRAME AT FS333 IAW CRJ SRM 51-42-06SDR DALA2025112808728Power Supply · no testEPSU FAILS SYSTEM TEST ATA 25624 ESCAPE SLIDE LT SW/EPSU (12WL) DOOR 1. REPLACED EPSU POWER SUPPLY AND BATTERY PER A330 AMM 33-51. BITE TEST GOOD. (LP 7911614)SDR SWIA2025112800007Windshield · damagedFO FRONT WINDSHIELD CAUGHT FIRE AT 3000 FEET QRH COMPLETE (FLIGHT 3726) AFTER INSPECTION, FOUND RH FO WINDSHEILD OUTBOARD AND MID GLASS PANES TO BE CRACKED WITH SIGNS OF ARCHING AT THE TERMINAL BLOCK. INBOARD GLASS PANES REMAIN INTACT. REF AML #1757968SDR FDEA202511272214Idg · failedR GEN DRIVE EICAS IN-FLIGHT. ACCOMPANIED BY ILLUMINATED R GEN DRIVE SWITCH LIGHT. COMPLIED WITH QRH. EMERGENCY DECLARED. PERFORMED RT ENG RUN TEST BER AMM 71-00-00-5-3, FOUND RT GEN CONT OFF LIGHT ON. BITE OF BPCU FOUND FAULT RT ENG GEN MPU/WIRING. WIRSDR FDEA202511272213Skin · dentedNR 1 SLAT WEDGE HAS DENT 53.5"- 56" FROM I/B EDGE, 7-8.5" FROM AFT EDGE. MWT REPAIRED LEFT WING NR 1 SLAT WEDGE DENT 53.5"- 56" FROM I/B EDGE, 7-8.5" FROM AFT EDGE. PCW ON NR 313 IN REF. TO B767 SRM 57-43-02-2R, SHT 1-2 DETAIL 1 & 2, B767 SRM 51-70-10-2R, SDR FDEA202511272212Skin · dented#1 SLAT WEDGE HAS DENT 58.5" FROM I/B EDGE, 10" FROM AFT EDGE. MWT REPAIRED LEFT WING #1 SLAT WEDGE DENT 58.5" FROM I/B EDGE, 10" FROM AFT EDGE. PCW ON NR# 313 IN REF. TO B767 SRM 57-43-02-2R, SHT 1-2 DETAIL 1 & 2, B767 SRM 51-70-10-2R, AND AMM 51-21-10-7.SDR FDEA202511272211Skin · dented#1 SLAT WEDGE HAS DENT 58.5" FROM I/B EDGE, 10" FROM AFT EDGE. MWT REPAIRED LEFT WING #1 SLAT WEDGE DENT 58.5" FROM I/B EDGE, 10" FROM AFT EDGE IN REF. TO B767 SRM 57-43-02-2R, SHT 1-2 DETAIL 1 & 2, B767 SRM 51-70-10-2R, AND AMM 51-21-10-7. THIS IS A MAJORSDR FDEA202511272210Skin · dented# 1 SLAT WEDGE HAS DENT 60.5" FROM I/B EDGE, 8" FROM AFT EDGE. MWT REPAIRED LEFT WING #1 SLAT 60.5" FROM I/B EDGE, 8" FROM AFT EDGE IN REF. TO B767 SRM 57- 43-02-2R, SHT 1-2 DETAIL 1 & 2, B767 SRM 51-70-10-2R, AND AMM 51-21-10-7. THIS IS A MAJOR REPAIR. SSDR AALA202511281798Warning Light · illuminatedAIRCRAFT WAS NOT GROUNDED: ENGINE 1 FIRE AGENT 2 DISCHARGE LIGHT ILLUMINATED DURING CRUISE. MAINTENANCE REPORTED THAT THE LIGHT WAS NO LONGER ILLUMINATED UPON ARRIVAL AT AIRCRAFT. MAINTENANCE NOTED NO FAULTS DURING A REVIEW OF THE POST FLIGHT REPORT, A BITE CHSDR AALA202511289243Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L3 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202511284843Diaphragm · leakingAIRCRAFT WAS NOT GROUNDED: L4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE AT 0 PSI, MAINTENANCE CONFIRMED THE DAMPER AND EMERGENCY OPERATION CYLINDER WAS LEAKING AND REPLACED THE DIAPHRAGM IN THE PERCUSSION MECHANISM OF THE DAMPER AND EMERGENCY OPERASDR DALA2025112808709Hook · out of adjustOUT ADJUSTMENT HOOK OF INNER CONTROL HANDLE ON PASSENGER CREW DOOR 832. PERFORMED ADJUSTMENT HOOK OF INNER CONTROL HANDLE ON PASSENGER CREW DOOR 832 IAW FAM AMM 52-13-21-400-001-A. (1324678).SDR DALA2025112808708Roller · deterioratedDETERIORATED ROLLER FROM PASSENGER CREW DOOR 842 ON UPPER AND LOWER POSITION AT FWD AND AFT SIDE OF THE DOOR. REPLACED ROLLER FROM PASSENGER CREW DOOR 842 ON UPPER AND LOWER POSITION AT FWD AND AFT SIDE OF THE DOOR IAW FAM AMM-52- 13-31-000-002-A AND FAM AMSDR DALA2025112808707Roller · deterioratedDETERIORATED ROLLER OF PASSENGER CREW DOOR 841 FROM UPPER AND LOWER POSITION AND FWD AND AFT SIDE OF THE DOOR. REPLACED ROLLER OF PASSENGER CREW DOOR 841 FROM UPPER AND LOWER POSITION AND FWD AND AFT SIDE AS PER A320 FAM AMM 52-11-31-000- 002-A AND AS PER A3SDR DALA2025112808706Roller · deterioratedDETERIORATED ROLLER FROM PASSENGER CREW DOOR 832 ON UPPER AND LOWER POSITION AND FWD AND AFT SIDE OF THE DOOR. REPLACED ROLLER ON PASSENGER CREW DOOR 832 ON UPPER AND LOWER POSITION AND FWD AND AFT SIDE OF THE DOOR IAW FAM AMM52-13-31-000-002-A AND AS PER FASDR DALA2025112808705Hook · out of adjustOUT OF ADJUSMENT HOOK INNER CONTROL OF PASSENGER CREW DOOR 842. PERFORMED ADJUSMENT HOOK INNER CONTROL OF PASSENGER CREW DOOR 842 IAW FAM AMM 52-13-21-400-001-A. (1324634).SDR YENA2025112801125Ecs · contaminatedFLT#87, ALB-FLL. "DURING DESCENT AT 600FT MILD TO MEDIUM DIRTY SOCKS ODOR; PLEASE REF LOG PAGE # 4523813, ITEM # 1 (IDENTIFIED THE APU AS THE CAUSE OF THE ODOR IRW TSM 05-50-00-810-831-A. PERFORMED A LEVEL A DECOMTAMINATION OF THE ECS IRW AMM 21-0000-615-802. SDR CALA2025112811562Light · inoperativeLAV T, AFT EMERGENCY PROX LIGHT INOPERATIVE. REMOVED AND REPLACED LAV T PROX EMERG LIGHT ASSY REF AMM 33-51-14 OPS CHECK GOOD.SDR CALA2025112811560Battery · no testOFCR EMERGENCY POWER SUPPLY BATTERY PACK 1 (M33118) FAIL TEST. BATTERY PACK REPLACED. INSTALLATION TEST CARRIED OUT FOR BATTERY PACK (M33118) IAW AMM33-51-00, FOUND WORKING SATISFACTORY.SDR CALA2025112811558Battery · no testOFCR EMERGENCY POWER SUPPLY BATTERY PACK 2 (M33145) FAIL TEST. BATTERY PACK REPLACED. INSTALLATION TEST CARRIED OUT FOR BATTERY PACK (M33145) IAW AMM 33-51-00,FOUND WORKING SATISFACTORY.SDR CALA2025112811556Battery · no testOFCR EMERGENCY POWER SUPPLY BATTERY PACK RH (M33142) FAIL TEST. BATTERY PACK REPLACED. INSTALLATION TEST CARRIED OUT FOR BATTERY PACK (M33142) AS PER AMM33-51-00, FOUND WORKING SATISFACTORY.SDR MASA2025111800095Light · inoperativePHOTOLUMINESCENT STRIPS NOT ILLUMINATED. CLEANED AND INSPECTED PHOTOLUMINESCENT STRIPS. OPS CHECK GOODSDR DALA2025112708703Seat Track · corrodedCABIN SEAT TRACK FOUND CORROSION AT Y1959 BETWEEN FR 37.1 AND FR 37.3. SEAT TRACK REPLACED AS PER A330 SRM51-72-11 REV127.03-NOV-16-2025. (LP 1324255)SDR DALA2025112708702Seat Track · corrodedCABIN SEAT TRACK FOUND CORROSION AT Y-2462 BETWEEN FR 51 AND FR 53.2. SEAT TRACK REPAIRED IAW SRM53-31-15-300-001 REV 127.02-OCT-09-2025. (LP 1324245)SDR DALA2025112708701Seat Track · corrodedSEAT TRACK-CABIN SEAT TRACK FOUND CORROSION AT Y-1456 BETWEEN FR 35 AND FR 36. SEAT TRACK REPAIRED AS PER A330 SRM 53-21-15-300-002 REV 127.02-OCT-09-2025. (LP 1324236)SDR DALA2025112708700Seat Track · corrodedSEAT TRACK-CABIN SEAT TRACK FOUND CORROSION AT Y450 BETWEEN FR 14A AND FR 15A. SEAT TRACK REPLACED AS PER A330 SRM51-72-11 REV 127.02-OCT-09-2025. (LP 1324221)SDR DALA2025112708699Seat Track · corrodedSEAT TRACK-CABIN SEAT TRACK FOUND CORROSION AT Y-2462 BETWEEN FR 44 AND FR 46. SEAT TRACK REPAIRED AS PER A330 SRM 53-31-15-300-001 REV 127.02-OCT-09-2025. (LP 1324201)SDR DALA2025112708698Seat Track · corrodedSEAT TRACK-CABIN SEAT TRACK FOUND CORROSION AT Y1552.5 BETWEEN FR 53.5 AND FR 53.6. SEAT TRACK REPAIRED AS PER A330 SRM 53-31-15-300-001 REV 127.03-NOV-16-2025. (LP 1324188)SDR DALA2025112708697Seat Track · corrodedSEAT TRACK-CABIN SEAT TRACK FOUND CORROSION AT Y-2462 BETWEEN FR 37.1 AND FR 37.2. SEAT TRACK REPAIRED AS PER A330 SRM 53-21-15-300-002 REV 127.02-OCT-09-2025. (LP 1324087)SDR DALA2025112708696Seat Track · corrodedSEAT TRACK-CABIN SEAT TRACK FOUND CORROSION AT Y-450 BETWEEN FR 37 AND FR 37.1. SEAT TRACK REPAIRED AS PER A330 SRM 53-21-15-300-002 REV 127.02-OCT-09-2025. (LP 1324049)SDR DALA2025112708695Seat Track · corrodedCABIN SEAT TRACK FOUND CORROSION AT Y-2462 BETWEEN FR 35 AND FR 37.1. SEAT TRACK REPAIRED AS PER A330 SRM 53-21-15-300-002 REV 127.02-OCT-09-2025. (LP 1324042)SDR DALA2025112708694Seat Track · corrodedCABIN SEAT TRACK FOUND CORROSION AT Y450 BETWEEN FR 60 AND FR 62. SEAT TRACK REPAIRED AS PER A330 SRM53-41-15-300-002 REV 127.02-OCT-09-2025. (LP 1323929)SDR DALA2025112708693Seat Track · corrodedSEAT TRACK-CABIN SEAT TRACK FOUND CORROSION AT Y1959 BETWEEN FR 33 AND FR 34. SEAT TRACK REPAIRED AS PER A330 SRM53-21-15-300-002 REV 127.02-OCT-09-2025. (LP 1323923)SDR DALA2025112708692Seat Track · corrodedCABIN SEAT TRACK FOUND CORROSION AT Y450 BETWEEN FR 37 AND FR 37.1. SEAT TRACK REPAIRED AS PER SRM53-21-15-300-002 REV 127.02-OCT-09-2025. (LP 1323913)SDR DALA2025112708691Seat Track · corrodedCABIN SEAT TRACK FOUND CORROSION AT Y-953 BETWEEN FR 35 AND FR 37. SEAT TRACK REPAIRED AS PER SRM53-21-15-300-002 REV 127.02-OCT-09-2025. (LP 1323910)SDR DALA2025112708690Seat Track · corrodedCABIN SEAT TRACK FOUND CORROSION AT Y2462 BETWEEN FR 53.4 AND FR 53.5. SEAT TRACK REPAIRED AS PER SRM53-31-15-300-001 REV 127.03-NOV-16-2025. (LP 1323856)SDR DALA2025112708689Seat Track · corrodedCABIN SEAT TRACK FOUND CORROSION AT Y-1552.5 BETWEEN FR 53.5 AND FR 53.6. SEAT TRACK REPAIRED AS PER SRM53-31-15-300-001 REV 127.03-NOV-16-2025. (LP 1323848)SDR DALA2025112708688Seat Track · corrodedCABIN SEAT TRACK FOUND CORROSION AT Y-B1 BETWEEN FR 73 AND FR 74. SEAT TRACK REPLACED AS PER SRM 51-72-11 REV 127.02-OCT-09-2025. (LP 1323824)SDR DALA2025112708687Seat Track · corrodedCABIN SEAT TRACK FOUND CORROSION AT Y2462 BETWEEN FR 71 AND FR 73. SEAT TRACK REPLACED AS PER A330 SRM 51-72-11 REV 127.03-NOV-16-2025. (LP 1323816)SDR DALA2025112708686Seat Track · corrodedCABIN SEAT TRACK FOUND CORROSION AT YA BETWEEN FR 73 AND FR 74. SEAT TRACK REPLACED AS PER A330 SRM 51-72-11 REV 127.03-NOV-16-2025. (LP 1323806)SDR DALA2025112708685Seat Track · corrodedCABIN SEAT TRACK FOUND CORROSION AT YB1 BETWEEN FR 73 AND FR 74. SEAT TRACK REPLACED AS PER A330 SRM 51-72-11 REV 127.02-OCT-09-2025. (LP 1323799)SDR DALA2025112708684Seat Track · corrodedCABIN SEAT TRACK FOUND CORROSION AT YB BETWEEN FR 72 AND FR 74. SEAT TRACK REPLACED AS PER SRM 51-72-11 REV 127.02-OCT-09-2025. (LP 1323776)SDR DALA2025112708683Seat Track · corrodedCABIN SEAT TRACK FOUND CORROSION AT Y1447.8 FR 78. REPLACED SEAT TRACK PER A330 SRM 51-72-11 REV 127.03-NOV-16-2025. (LP 1323762)