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 AALA202511286199Light · no testAIRCRAFT IN BASE MAINTENANCE: LEFT HAND AFT OVERWING EMERGENCY EXIT LIGHT IS INOPERATIVE. REPLACED LIGHT AND ACCOMPLKISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-15.SDR AALA202511289901Light · no testAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND AFT OVERWING EMERGENCY EXIT LIGHT IS INOPERATIVE. REPLACED LIGHT AND ACCOMPLKISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-15.SDR AALA202511284966Light · no testAIRCRAFT IN BASE MAINTENANCE: LEFT HAND FORWARD OVERWING EMERGENCY EXIT LIGHT IS INOPERATIVE. REPLACED LIGHT AND ACCOMPLKISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-15.SDR AALA202511284137Light · no testAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND FORWARD OVERWING EMERGENCY EXIT LIGHT IS INOPERATIVE. REPLACED LIGHT AND ACCOMPLKISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-15.SDR SWAA2025112630874Battery Pack · inoperativeINOPERATIVE BATTERY PACK BELOW SIDEWALL PANEL 232YHW AT PASSENGER CABIN. REPLACED BATTERY PACK BELOW SIDEWALL PANEL 232YHW AT PASSENGER CABIN IAW AMM 33-51-06-960-805, EXCEPT TO STEP 4.E.(3)(A)(F) AND STEP 4.F.(1)(4) TEST IS OK.SDR SWAA2025112630873Battery Pack · inoperativeINOPERATIVE BATTERY PACK BELOW SIDEWALL PANEL 231YHW AT PASSENGER CABIN. REPLACED BATTERY PACK BELOW SIDEWALL PANEL 231YHW AT PASSENGER CABIN IAW AMM 33-51-06-960-805, TESTED OK.SDR SWAA2025112630866Battery Pack · inoperativeINOP BATTERY PACK OVER ENTRY LIGHT ON POSITION LT FWD GALLEY AREA. REPLACED BATTERY PACK OVER ENTRY LIGHT ON POSITION LT FWD GALLEY AREA IAW AMM 33-51-06-960-805, EXCEPT TO STEP 4. E. 3, F, G, AND STEP 4. F. 4, 5. TESTED OK.SDR SWAA2025112630867Battery Pack · inoperativeINOPERATIVE BATTERY PACK AND CHARGER ASSY ON POSITION CEILING. LOWERED PANEL LT AT AFT GALLEY AREA. REPLACED BATTERY PACK AND CHARGER ASSY ON POSITION CEILING AT AFT GALLEY AREA IAW AMM 33-51-06-960-805, EXCEPT TO STEP 4. E. 3, A, G, AND STEP 4 . F. 1, 5. SDR HNAA2025112500822Skin · gougedGOUGE UNDER GPU DOOR. REPAIRED DAMAGED UNDER GPU DOOR IAW EMB 145 SRM 53-12-01 ITEM 2 FIG 201. AND EO1-53-25 0424SDR SWIA2025112400001Intercostal · crackedINTERCOSTAL LOCATED AT LT STGR 4 BETWEEN FRAMES AT FS654.50 AND FS672.20 IS CRACKED AT THE FWD LWR CORNER. REMOVED AND REPLACED INTERCOSTAL LOCATED AT LH STGR 4 BETWEEN FRAMES AT FS654.50 AND FS672.20 IN REFERENCE TO CRJ 200 SRM 51-42-06 ALSO COMPLIED WITH SDR NACA2025110100011Blade · damagedNUMBER 2 ENG FAN BLADE HAS A NICK WITH A BURR ON L/E AT FAN BLADE TIP. REPAIRED NICK AT NR 2 ENG FAN BLADE ON L/E IAW AMM 72-31-02-308-003-N00. PERFORMED HFEC, NO CRACKS IAW AMM 72-31-02-206-100-N00. BLADE NR 23.SDR NACA2025110100010Blade · damagedNUMBER 2 ENGINE FAN BLADE HAS 2 DINGS APPROX 3.5" APART FROM EACH OTHER 1ST DING APPROX 2.5" FROM FAN BLADE TIP ON L/E OF FAN BLADE. REPAIRED THE 2 DINGS AT NR 2 ENG FAN BLADE 2.5" AND 6" FROM FAN BLADE TIP IAW AMM 72-31-02-308-N00. PERFORMED HFEC, NO CRACKSDR NACA2025110100009Blade · damagedNUMBER 2 ENGINE FAN BLADE HAS A DING APPROX .5" ON L/E FROM FAN BLADE TIP. REPAIRED THE DING AT NR 2 ENG FAN BLADE 5" ON L/E FROM FAN BLADE TIP IAW AMM 72-31-02-308-003-N00. PERFORMED HFEC, NO FOUND CRACKS IAW AMM 72-31-02-206-100-N00. BLADE NR 2.SDR NACA2025110100008Blade · nickedNUMBER 2 ENG FAN BLADE HAS A NICK APPROX 2.5" ON L/E FROM FAN BLADE TIP. REPAIRED THE NICK AT NR 2 ENG FAN BLADE 2.5" ON L/E FROM FAN BLADE TIP IAW 72-31-02-308003-N00. PERFORMED HFEC, NO CRACKS FOUND IAW AMM 72-31-02-206-100-N00. BLADE NR 3.SDR NACA2025110100007Blade · nickedNUMBER 2 ENG FAN BLADE AT L/E TO FAN BLADE TIP HAS A NICK AND TIP IS SLIGHTLY BENT OUT. REPAIRED THE NICK AT NR 2 ENG FAN BLADE L/E CORNER IAW AMM 72-31-02-208-003-N00. PERFORMED HFEC NO CRACKS FOUND IAW AMM 72-31-02-206-100-N00. BLADE NR 14.SDR NACA2025110100006Case · damagedNR 1 ENG. FAN CASE HAS GOUGES ON THE V-GROOVE FROM 8 O'CLOCK TO 9 O'CLOCK POSITION. REMOVED DAMAGED ON NR 1 ENG FAN CASE V-GROOVE FROM 8 O'CLOCK TO 9 O'CLOCK POSITION WAS FOUND WITHIN LIMITS IAW AMM 72-34-07, STEP 2.E, TABLE 801. REMOVED .030" DEPTH, MAXIMUMSDR NACA2025110100005Case · damagedNUMBER 1 ENG. FAN CASE HAS A GOUGE ON THE V-GROOVE AT 3 O'CLOCK POSITION. REMOVED DAMAGE ON NR 1 ENG FAN CASE V-GROOVE AT 3 O'CLOCK POSITION WAS FOUND WITHIN LIMITS IAW AMM 72-34-07 STEP 2. E, TABLE 801. REMOVED 0.090 DEPTH, MAXIMUM ALLOWED 0.125".SDR NACA2025110100004Blade · damagedNUMBER 1 ENG. FAN BLADE NR 12 HAS A DING APPROX. 1" ON L/E FROM BLADE TIP. THIS AREA WAS PREVIOUSLY BLENDED. REPAIRED DING AT NR 1 ENG FAN BLADE NR 12 1" ON L/E FROM BADE TIP AREA -A- IAW AMM 72-31-02-308-003-N00. PERFORMED HFEC, NO FOUND CRACKS AT THE AREA SDR NACA2025110100003Blade · damagedNUMBER 1 ENG. FAN BLADE NR 12 HAS A DING APPROX. 1" ON L/E FROM BLADE TIP. THIS AREA WAS PREVIOUSLY BLENDED. REPAIRED DING AT NR 1 ENG FAN BLADE NR 12 1" ON L/E FROM BADE TIP AREA -A- IAW AMM 72-31-02-308-003-N00. PERFORMED HFEC, NO FOUND CRACKS AT THE ARESDR NACA2025110100002Bladder · damagedNUMBER 1 ENG. FAN BLADE NR 27 HAS A DING APPROX. 1.75" ON L/E FROM BLADE TIP. EVALUATED DENT AT NR 1 ENG FAN BLADE NR 27 1.75" ON L/E FROM BLADE TIP FOUND TO BE IN LIMITS IAW AMM 72-31-02. PERFORMED HFEC, NO CRACKS FOUND IAW AMM 72-31-02-206-100-N00.SDR NACA2025112100001Blade · damagedNUMBER 1 ENG FAN BLADE NR 37 HAS A DING APPROX. 1.75" ON L/E FROM BLADE TIP. REPAIRED DING AT NR 1 ENG, FAN BLADE NR 37 1.75" ON L/E FROM BLADE TIP IAW AMM 72-31-02-308-003-N00. PERFORMED HFEC, NO FOUND CRACKS IAW AMM 72-31-02-206-100-N00.SDR R61A2025112000513Stringer · corrodedCORROSION ON STGR 28R AT FR88. REMOVED AND REPLACED STRINGER 28R FILLER SECTION FR 83-90 IAW ETD2025-170-931504REV A.SDR JJBA20251120091Skin · corrodedLH AILERON IB INTERNAL SKIN HAS CORROSION. NEW LH AILERON INSTALLED.SDR IPXA2025111570289Drag Fitting · crackedAFTER ACCOMPLISHING HFEC OPEN-HOLE INSP AT THE NR 2 PYLON WING SKIN FASTENER HOLES PER EO-88069-JIC12, HOLES 2,3,4, AND 9, HAS CORROSION INDICATIONS. ACCOMPLISH REPAIR PER EO-95741-REQ1 AND VT-MAE EA 757-5720-27-A4215, REV. -, PRIOR TO FURTHER FLIGHT.SDR SWAA2025111330742Battery Pack · inoperativeOVERWING FORWARD L/H AND R/H EMERGENCY ESCAPE HATCH LIGHTS INOPERATIVE. REMOVED AND REPLACED THE EMERGANCY LIGHT BATTERY PACK ON THE LT SIDE. OPS CHECKED GOOD IAW AMM 33-51-06.SDR DALA2025111308340Skin · damagedFWD CARGO DOOR, FWD SURROUNDING SKIN DAMAGED, GOUGED FOA FR20A / STGR 40 AND -41RH. REPAIRED IAW SRM 53-21-11-283-017. (7922745)SDR SWAA2025111230744Handle · out of adjustL1 DOOR, AIRFRAME ASSIST HANDLES UNSECURE. SECURED L1 DOOR AIRFRAME SIDE ASSIST HANDLES IAW AMM TASK 52-11-31-400-802.SDR SWAA2025111230746Handle · out of adjustR1 DOOR ASSIST HANDLE UNSECURE. SECURED R1 DOOR ASSIST HANDLE IAW AMM TASK 52-11-31-400-802.SDR SWAA2025111230745Handle · unsecureR1 DOOR, AIRFRAME ASSIST HANDLES UNSECURE. SECURED R1 DOOR AIRFRAME ASSIST HANDLES IAW AMM TASK 52-11-31-400-802.SDR SWI2025F01519Unknown · smokeDUE TO SMOKE FILLED CABIN ODI EVENT, MECHANICS RECOMENDED A COMP WASH DURING THE BORROSCOPE PROCEDURE. (FLIGHT 6512) TROUBLESHOT WRITE UP FOR CABIN SMOKE AND OR ELECTRICAL BURNING ODOR IAW FIM 21-21-00-810-806, FIM 21-22-00-810-806 AND FIM 79-30-00-810-821.SDR DALA2025111008168Proximity Sensor · faultedL1 DOOR INDICATES OPEN UNTIL BOTH ENGS. ARE RUNNING. SLIDE LIGHT FLASHES UNTIL BOTH ENGS ARE RUNNING. R&R PROX BOX DUE TO HISTORY IAW B767-300 AMM 32-09-04. OPS CK GOOD, (7925528)SDR AALA202511107385Battery Pack · inoperativeAIRCRAFT IN BASE MAINTENANCE: OFAR RH SIDE EMERGENCY LIGHT WONT ILLUMINATE. MAINTENANCE REPLACED OFAR RH SIDE EMERGENCY BATTERY PACK PER AMM 33-29-12, REV 250 01 OCT 2025.SDR ENHA20251101002Screw · looseAFTER SECURING LOOSE SCREW ON BUS 2 STANDBY POWER CIRCUIT BREAKER (LOG PAGE 263019)AND SUCCESSFUL CHECK FLIGHT THE AIRCRAFT WAS RETURNED TO SERVICE.SDR SWI2025F01518Spring · brokenFORWARD-PASSENGER-DOOR AFT EVACUATION SLIDE-FITTING HAS BROKEN SPRING (C-CHECK RO 11/06/2025)REMOVED AND REPLACED FORWARD PASSENGER DOOR AFT EVACUATION SLIDE FITTING SPRING PER ERJ 175 AMM 53-10-21SDR SWIA2025110700111Fitting · brokenFORWARD-SERVICE-DOOR FWD EVACUATION SLIDE-FITTING HAS BROKEN SPRING. REMOVED AND REPLACED FORWARD SERVICE DOOR FWD EVACUATION SLIDE FITTING SPRING PER AMM 53-10-25SDR DALA2025110708144Sign · damagedSHIP 9526 FORWARD CENTER OVERHEAD EXIT SIGN DAMAGED. CORRECTIVE ACTION: R/R FWD ISLE EMERGENCY LIGHT SIGN IAW B717 AMM 33-51. OPS CHECK GOOD. (7608370)SDR DALA2025110708132Slider · faultedESCAPE SLIDE GIRT BAR ENGAGEMENT LIGHT/S/AFT LEFT DOOR. CORRECTIVE ACTION: R/R BOTH PROX SENSOR SWITCHES AT 4L DOOR PER B757 AMM 25-66. REPLACED SLIDER PER B757 AMM 25-66. INSTALLED ACTUATOR ON THE GIRT BAR SLIDER. REINSTALLED SLIDER PER B757 AMM 25-66. REINSTSDR SWIA2025110600001Engine · dirtyAT NEXT MX OVERNIGHT, DUE TO ODI EVENT, TROUBLESHOOT L JET OVHT FAIL CAUTION MESSAGE AND L JETPIPE OVHT WARNING MESSAGE ON CLIMBOUT. DO NOT CARRY FORWARD WITHOUT APPROVAL FROM MCC. TROUBLESHOT WRITE UP FOR CABIN SMOKE AND OR ELECTRICAL BURNING ODOR IAW FIM 2SDR CALA2025110610971Skin · damagedLEFT FUSELAGE SKIN AT STA 103 5 TO STA 1042.5 DAMAGED. LT FUSELAGE SKIN EXTERNAL DOUBLER REPAIRED IAW PART 2 OF ECRA 5380-01432.SDR CALA2025110610970Skin · dentedFLIGHT CREW NOTICED SMALL DENT JUST FWD OF FUSELAGE BS 1040, STRINGERS 12L AND 13L, DENT MEASURES W=1.6,L=2.3,D=.087, DENT 1.0 FROM FRAME FASTENER AND 1.75 FROM STR.12 FASTENER. ACCOMPLISHED STEPS 1 AND 2 A THROUGH D AND ALSO STEP 2 DVI. ACCOMPLISHED HFEC INSDR CALA2025110610960Skin · crackedLEFT WING, SLAT NR 1, INNER SURFACE, ABOVE INBD TRACK, CLOSE TO WS 735, SKIN CRACKED. REMOVED, FABRICATED, & INSTALLED LT WING INNER SKIN IAW SRM 51-40-02, REINSTALLED SLAT NR 1 IAW AMM 27-81-02-424-021.SDR CALA2025110610958Skin · crackedLEFT WING, SLAT NR 2, INNER SURFACE, ABOVE OTBD TRACK, CLOSE TO WS 675, SKIN HAS A CRACK. REMOVED AND REPLACED THE INNER SKIN IAW SRM 51-40-02-0G-0. REINSTALLED THE NR 2 SLAT IAW AMM 27-81-02-024-001, & 27-81-02 424-021.SDR CALA2025110610956Stiffener · corrodedAFT CARGO COMP, FWD BULKHEAD, REAR SIDE, STIFFENER BS 1180, LBL 53.96 HAS EXFOLIATION ON LOWER AREA. REPAIRED IAW EC/RA 5340-02246 AND EA 757-5340-13-A4169 REV-.SDR CALA2025110610954Skin · crackedLEFT WING, SLAT 3, INNER SURFACE, ABOVE INBD TRACK, SKIN CRACKED. REMOVED, FABRICATED & INSTALLED LH WING SLAT #3 INNER SURFACE SKIN IAW SRM 51-40-02, & MAE TRAVELER T25/1836170. REMOVED AND REINSTALLED THE SLAT IAW AMM 27-81-02-024-001, & 27-81-02-424-021SDR DALA2025110508067Elec Connector · disconnectedSEAT 30 DEF, EMERGENCY LIGHT INOPERATIVE. DEFERRED AND PLACARD PER MEL 33-00-19A. MCC CONTACTED. FOUND ELECTRICAL CONNECTOR DISCONNECTED. RECONNECTED ELECTRICAL CONNECTOR IAW AMM 25-22-00-400-802 STEP 14. OPS CHECKED GOOD. MEL AND PLACARD REMOVED. (LP: 7SDR DALA2025110508064Battery Pack · inoperativeON WAKEUP FOUND SEAT EMERGENCY LIGHTS ROW 20-27 INOPERATIVE. R & R THE BATTERY PACK IAW 33-51, OPS CK GOOD. (LP: 8002102)SDR SWAA2025110430680Battery Pack · dischargedMEGAPHONE BATTERIES NEED CHANGED. REPLACED BATTERIES IN FWD AND AFT MEGAPHONE PER AMM 25-64-00. OPS CHECK GOOD.SDR SWAA2025110430971Girt Bar · out of adjustGIRT BAR ON L1 DOOR HARD TO GET ON AND OFF CLIPS. RESECURED GIRT BAR ON L1 DOOR PER AMM 25-66-01.SDR SWAA2025110430788Light · inoperativeSIDEWALL LIGHT AT RT OVER WING EXIT INOPERATIVE. OK TO CONTINUE ON MEL 33-2-03 SP#1B. RELAMPED THE RT OVERWING EXIT DOOR PER AMM 33-51-04. OP CHKD GOOD.SDR SWAA2025110430699Light · inoperativeCENTER AISLE; CENTER EMERGENCY LIGHT ASSEMBLY REQUIRES REPLACEMENT CENTER AISLE CENTER EMERGENCY LIGHT ASSEMBLY REQUIRES REPLACEMENT. REMOVED AND REPLACED CENTER AISLE EMERGENCY EXIT LIGHT ASSY IAW AMM 33-51-01 OPS CHECKED GOOD.