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 FDEA202512202266Stringer · corrodedAFT CARGO BAY STRINGER 29L BTW BS 1460 TO 1480, FOUND CORRODED. REPAIRED THE STRINGER IAW SRM 51-40-020-G, AND DWG 146N3110, REV B.SDR FDEA202512202265Skin Panel · crackedRIGHT WING OTBD LEADING EDGE SLAT NR 10 INTERNAL LOWER MAIN TRACK SLAT HAS POSSIBLE CRACKED. REMOVED DAMAGED COVE SKIN AT RT WING OTBD LEADING EDGE SLAT 10 IAW SRM 51-40-02-0G, AND INSTALLED NEW FORMED COVE SKIN IAW B. DRAWING 114N4075 REV -, AND PL 114N40SDR DALA2025122209278Oil System · leakingDIV TO MSY DUE TO CREW REPORTS ODOR IN AFT GALLEY. PERFORMED BSI OF NR 2 ENGINE LCP AND HPC PER W/C 7100-2018. FOUND OIL WETTING EVIDENCE AT HPC STAGE 4 & 5. REPLACED NR 2 ENGINE. (LP 7987638)SDR CALA2025122112282Gauge · faultedFYI LT FUEL TANK GAUGE BLANK WITH ASSOCIATED STATUS MESSAGE FUEL QTY IND THIS ITEM IS CLEARED REF 7345418.SDR CALA2025122112280Light · no testSEAT 36C EMERGENCY LIGHT IS OUT. EMERGENCY LIGHTS - OPS CHECKED EMERGENCY LIGHTS, REMOVED AND REPLACED EMERGENCY LIGHT ASSY. AT SEAT 36C IAW AMM 33-51-15.SDR CALA2025122112276Unknown · odorELECTRICAL SMOKE SMELL COCKPIT AND FWD GALLEY PERFORMED FIM DMC-B787-A-21-20-F5-72A-421A-A AND INSPECTED FWR GALLEY AND MAIN E/E. NO FAULT FOUND. ACFT GOOD FOR SERVICE.SDR DALA2025122209273Oil System · leakingON ARRIVAL DESCENT WE NOTICED A MUSTY ODOR FROM PACKS. THE SMELL WOULD COME AND GO. THE ODOR LEFT AND THEM CAME BACK AND WE NOTICED THE ODOR AT THE GATE AFTER SHUTDOWN. FA'S IN THE CABIN NOTICED IT THE MOST IN FWD GALLEY. C/A: C/W W/C 0550-2002. FOUND APU INLESDR ABXA20251220348Fire Loop · warning messageMAIN DECK CARGO LOOP 2 STATUS MSG ILLUM AFTER LANDING MTX, GROUNDED A/C AND DEFERRED MAIN DECK LOOP2 FOR DEPARTURE IAW MEL ABX-26-16-2-1 .AND RETURNED A/C TO SERVICESDR SWIA2025121977092Skin · corrodedPAINT DAMAGED AND POSSIBLE CORROSION FOUND ON SKIN FROM BS 559 - 559+80, STR 24L - 24R. REMOVED CORROSION ON BELLY SKIN FROM BS 559 - 559+80 BTWN STR 24L-24R IAW SRM 51-21-06. DAMAGE FOUND TO BE WITHIN ALLOWABLE LIMITS IAW REO 601R-53-00-930 REV--. REMOVED ASDR DALA2026082104774Shear Tie · corrodedCORROSION ON 2 SKIN CLIPS AT FRAME 908, LEFT AND RIGHT OF LONGERON 30, CORRECTIVE ACTION: REPAIRED SKIN CLIPS PER B717-200SRM 53-00-06-2R. (1358889) (AIRCRAFT GROUNDED).SDR REXA2026052600677Stringer Splice · corrodedCORROSION ON STGR SPLICE LOCATED BTW STGR-25R FROM FS329.00 TO FS339.00. STGR SPLICE LOCATED BTW STGR-25R FROM FS329.00 TO FS339.00. WAS REPLACED PER CRJ-900 SRM 51-42-21-001-001-A01SDR REXA2026052600665Stringer · corrodedSECONDARY NRC FROM NRC 00183: CORROSION ON STGR-25R FROM FS339.00 TO FS364.00. CORROSION ON STGR-25R FROM FS339.00 TO FS364.00 WAS EVALUATED OUT LIMITS PER CRJ900 SRM 53-21-03-101-006-A04 THEREFORE WAS REPLACED PER CRJ-900 SRM 51-42-06-001-001-A01SDR SWIA2025121975902Rib · crackedRIGHT WING L/E RIB AT WS 58.41 CRACKED. PERFORMED REPAIR ON RT WING L/EDGE RIB AT WS58.41 IAW SRM 51-42-15, AMM 57-41-32, REO 690-57-41-582 REV--(P1), REO 690-57-41-582, REV-. PERFORMED INSPECTION.SDR SWIA2025121975900Rib · crackedLEFT L/E RIB AT WS 58.41 CRACKED. PERFORMED REPAIR AT LT LE RIB IAW SRM 53-24-15, 51-25-16, AMM 57-41-32, &REO 690-57-41-581, REV -. PERFORMED NDT INSPECTION.SDR SWIA2025121975857Mount · crackedAPU DOOR LINEAR ACTUATOR MOUNTING STRUCTURE CRACKED. REMOVED AND REPLACED THE APU DOOR LINEAR ACTUATOR SUPPORT, REF SRM 51-42-06-00 AND DWG 601R35210 REV -M. COMPLIED WITH TASK CARD 51-900-1003-SKY,SDR SWIA2025121975736Fastener · misinstalledDURING AUDIT OF RA48003 REPAIR TO THE AFT FUSE SKIN BTWN FS682-FS718 & STR20R- 22R IN REF TO REO 601R-53-61-6966, REV--, WAS FOUND THAT THERE ARE TWO EXTRA FASTENERS INSTALLED FORWARD OF FS 700 AT STRINGER 20R. EVALUATED REPAIR AT AFT FUSELAGE SKIN BETWEEN SDR 2026FA0000183Shear Pin · brokenLAY SHAFT SHEAR PIN BROKEN INSIDE STARTERSDR AALA202603026499Stringer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION STRINGER 43L BTW FR 56 AND FR 58 IN AFT CARGO COMPARTMENT. L=6.139 INCH; W=0.741 INCH; D=0.005 INCH. MAINTENANCE ACCOMPLISHED PERMANENT REPAIR (PART STRINGER) LOC STRINGER 43L BTW FR56 TO FR58 IN AFT CARGO COMPARTMENT SDR VNAA20260205004Fitting · brokenDURING GAPS MEASSUREMENT ON REPLACEMENT OF RUDDER PRIMARY FEEL UNIT SHAFT IN REF TO_27-079-001-20-REQ, PIN FITTING LH SIDE WAS BROKEN. PIN FITTING LH SIDE WAS REPLACED PER CRJ-700 SRM 51-42-06-001-001-A01 AND CRJ-700 SRM 51-42-13-001-001-A01 AND (ET) HFEC ISDR VNAA20260205003Lug · corrodedCORROSION WAS FOUND AT LOWER LUG 5 (1EA) AT RH AILERON. LOWER LUG 5 (1EA) AT RH AILERON WAS REPAIRED PER REO 670-57-61-237 REV--.SDR VNAA20260205002Hinge · corrodedNICKS AND CORROSION WERE FOUND AROUND OF INTERNAL LUG ON HINGE #1 ALSO CORROSION INSIDE BORE. LUG ON HINGE #1 WAS REPAIRED PER REO 670-57-51-678 REV --SDR JJBA20260130066Floor Support · corrodedCORROSION 3 LOCATIONS STR 16 R FRAME 19 TO 20. PERFORMED BLEND OUT ON 3 LOCATIONS AT STR 16 R, FRAME 19 TO 20. AT SPOTS 1 & 2 NO CORROSION WAS PRESENT. AT SPOT 3 INSTALLED FABRICATED DOUBLER FOR FWD FLOOR SILL REPAIR.SDR SWAA2026012753842Scuff Plate · crackedCRACKED SCUFF PLATE IN THE AFT CARGO BAY. REPAIRED FWD CORNER SCUFF PLATE IAW SRM 53-60-15-2R-1, REPAIR 1, AND BAC 5975.SDR SWAA2026012753843Scuff Plate · crackedCRACKED SCUFF PLATE IN THE AFT CARGO BAY. REPAIRED THE SCUFF PLATE IAW SRM 53-60-15-2R-1, REPAIR 1, AND BAC 5975.SDR SWAA2026012654126Strap · corrodedCORRODED STRAP BTW BS 827 - 847, S25 - 26R, WL 155. REPLACED THE STRAP IAW SRM 51-40-02, AND SRM-51-10-02-0G-0, ITEM 9, DWG 146A8340, SHEET 28, REV -.SDR SWAA2026012354124Shield · corrodedCORROSION ON SHIELD WEB, BTW BS 767 TO BS 794.2, RBL 21, WL 156.1 IN THE AFT CARGO BAY, INSTALLED SHIELD WEB LOCATED IAW SRM 51-10-02, PARAGRAPH 9, AND DWG 146A0081, SHEET 49, REV A.SDR SWAA2026012354129Web · crackedCRACKED WEB LOCATED BTW BS 927 TO 947.5, STR 25R IN THE AFT CARGO BAY. REPLACED WEB IAW SRM 51-10-02-0G, ITEM 9, SRM 51-40-02-0G, DWG: 147A7500, SHEET 36, & 37, REV - AND DWG 149A8110, SHEET 13 REV B.SDR CALA2026012213134Rib · crackedRIGHT HORIZONTAL STAB INBD SIDE OF RIB AT HSS 101.90 IS CRACKED AT THE LOWER TRANSITION RADIUS OF THE NR 1 VERTICAL STIFFENER. REPAIRED THE NR 1 VERTICAL STIFFENER INBD SIDE OF RIB IAW SRM 55-10-09-2R-4, TABLE 201, REPAIR 4.SDR CALA2026012213132Rib · crackedRIGHT HORIZONTAL STAB INBD SIDE OF RIB AT HSS 92.70 CRACKED AT THE LOWER TRANSITION RADIUS OF THE NR 4 VERTICAL STIFFENER. REPAIRED NR 4 VERTICAL STIFFENER INBD SIDE OF RIB IAW SRM 55-10-09-2R-4, TABLE 201, REPAIR 4.SDR CALA2026012213130Rib · crackedRIGHT HORIZIZONAL STAB INBD SIDE OF RIB AT HSS 92.70 IS CRACKED AT THE LOWER TRANSITION RADIUS OF THE NR 3 VERTICAL STIFFENER. REPAIRED THE NR 3 VERTICAL STIFFENER INBD SIDE OF RIB AT HSS 92.70 IAW SRM 55-10-09-2R-4, TABLE 201, REPAIR 4.SDR SWAA2026012154120Support · crackedCRACKED CARGO LINER SUPPORT. BS 727B, LBL 50 IN THE AFT CARGO BAY. PERFORMED PERMANENT REPAIR ON LINER SUPPORT LOCATED BTW BS 727A +15 INCHES TO BS 727B +7 INCHES, LBL 50 IAW SRM 51-70-11-2R-0, REPAIR GENERAL.SDR SWI2026F00084Rib · crackedRIGHT HORIZONTAL RIB 11 UPPER FLANGE SUSPECTED CRACK. REMOVED AND REPLACED RT HORIZONTAL RIB 11 REF SRM 51-40-08. NO CHANGE IN WEIGHT AND BALANCE, PART REPLACED WAS OEM PART. SEE CONTINUATION CARD FOR WORK PERFORMEDON TASK CARD 27-31-05-001-SKY-U, THE FOLLOWISDR SWIA20251219Rib · crackedLEFT HORIZONTAL RIB 12 UPPER FLANGE SUSPECTED CRACK (C-CHECK RO 01/16/2026)PERFORMED FLANGE REINFORCING REPAIR ON LH HORIZONTAL RIB 12 UPPER FLANGE REF ETD2026-170-000257. NO CHANGE TO WEIGHT AND BALANCE. SEE CONTINUATION CARD FOR WORK ACCOMPLISHED.ON TASK CASDR CALA2026010212591Floor Support · corrodedBULK CARGO, BETWEEN BS 1500 - 1520, FLOOR SUPPORTS HAVE CORROSION AT NUTPLATES AREA (4 PLACES). PART FABRICATED REMOVED AND REPLACED FLOOR SUPPORT AT AFT CARGO COMP BS 1500 TO 1520 IAW SRM 51-40-02-0G-0.SDR AALA202512309359Bolt · looseAIRCRAFT IN BASE MAINTENANCE: RIGHT-HAND FORWARD OVERWING ESCAPE HATCH CUTOUT AFT UPPER STOP BOLT LOOSE. MAINTENANCE TIGHTENED THE STOP BOLT PER AMM 52-22-00.SDR SWAA2025122953763Access Panel · damagedACCESS PANEL 553ET FASTENER HOLE ELONGATED. LOCATED, DRILLED, AND INSTALLED A NEW ACCESS PANEL IAW SRM 51-40-02.SDR DALA2025122909454Door Frame · gougedAFT CARGO DOOR AND FRAME: UNIDENTIFIED BLEND OUT AT DOOR FWD FRAME CUTOUT HAS GOUGE AND DAMAGE. REPAIRED PER B717-200 SRM 53-20-15-2R. (1359038).SDR DALA2025122909452None · noneERA 631006-14. : DAMAGE TOLERANCE EVALUATION IS REQUIRED IN ACCORDANCE WITH PROCEDURES ESTABLISHED IN FAA ADVISORY CIRCULAR 120-93. ASSOCIATED ER/A 00-631006 (1359454)SDR CALA2025122912465Crossbeam · wornNUMBER 1 ENG PNEUMATIC FLEX LINE CHAFING DEEPLY INTO FWD ENG MOUNT LT THRUST LINK AND MOUNT CROSSBEAM OTBD EDGE RADIUS. REMOVED AND REPLACED ENGINE 1 FWD MOUNT IAW AMM 71-21-1 2-000-011-A, AND AMM 71-21-12-400-011-A.SDR CALA2025122912463Beam · crackedAFT CARGO DOOR, INTERNAL BEAM ASSEMBLY 146A6117-8 IS CRACKED AT FASTENER HOLE. REMOVED AND REPLACED BEAM IAW DWG 146A6110 REV C, BAC DWG 146A6117 REV A, AND SRM 51-40-02 REF AAR GSO.SDR DALA2025122809436Unknown · odorDIV- TO TPA DUE TO SMOKE SMELL IN FWD GALLEY. INSPECTED ELEC PANELS, GALLEY AREAS AND EQUIP, LAVS WITH NO TROUBLE FOUND. RAN ENGINES AND PACKS WITH NO SMELLS.(7789980 )SDR DALA2025122809432Skin · crackedFASTENER NR 3 & 4 A CRACK WAS FOUND DURING NDT INSPECTION. REPAIR IS REQUIRED PRIOR TO FURTHER FLIGHT. AMOC TO AD 24-05-03 MAY BE REQUIRED. REPAIRED FWD SERVICE DOOR CUTOUT AFT LOWER CORNER IAW B767 SRM 53-10-01-2R-1. (1359506)SDR DALA2025122809431Door Frame · crackedCUSTOMER CARD#5331-01288-01. AT FASTENER NR 3 CRACK WAS FOUND DURING NDT INSPECTION. REPAIRED FWD ENTRY DOOR CUTOUT AFT LOWER CORNER IAW SRM 53- 10-01-2R-1. (1359430)SDR DALA2025122809427Dampener · failedDONT PASS TEST DOOR DAMPER ON PASSENGER CREW DOOR 841 (REFFER TO AMDS CARD 5210-7089-RF). REMOVED DOOR DAMPER ON PASSENGER CREW DOOR 841 P/N FE174-0011 S/ N 1526 ON UNSERVICEABLE CONDITION AS PER A320 FAM AMM 52-11-14- 000-001-A JOB IN PROGRESS. REPLACED DAMSDR DXTA2025122306203Battery · inoperativeCABIN EMERGENCY LIGHTS ARE ILLUMINATED WITH THE AIRCRAFT BATTERIES ON AND THE EMER LIGHT SWITCH IN THE ARMED POSITION. EMER LT NOT ARM CAS MESSAGE STAYS ILLUMINATED WITH SWITCH IN THE ARMED POSITION. DUE TO CABIN EMERGENCY LIGHTS ARE ILLUMINATED WITH THE ACFT SDR CALA2025122412389Rib · crackedRIGHT HORIZONTAL STAB INBD SIDE OF RIB AT HSS 101.90 WAS CRACKED AT THE LOWER TRANSITION RADIUS OF THE NR 2 VERTICAL STIFFENER. REPAIRED NR 2 VERTICAL STIFFENER AND INBD SIDE OF RIB AT STA 101.90 R/H HORIZ STAB IAW B737-800 SRM 55-10-09-2R-4 TABLE 201 REPAIR SDR ASAA2025121963243Lamp · inoperativeEXTERIOR EMERGENCY EXIT LIGHTS AFT OF THE WING ARE INOPERATIVE ON BOTH SIDES. GROUNDED - YES. TRANSFERRED ITEM TO MIG-5 S/N OK448557 ITEM #7 OF MIG-85 INFO ONLY RELAMPED LT & RT SLIDE LIGHT IAW AMM 33-51-04-960-801. OPS CHECKED GOOD.SDR ASAA2025121963228Door · no discrepancyL2 DOOR WOULD NOT OPEN WHEN CATERING TRIED TO OPEN IT. GROUNDED - YES. PERFORMED OPS TEST OF L2 DOOR WITH INTERIOR AND EXTERIOR DOOR HANDLE OPS CHECK GOOD IAW AMM 52-13-00.SDR SWAA2025122354264Pressure Switch · faultyAPU LOW OIL PRESSURE LIGHT ILLUMINATED. APU SHUTDOWN AUTOMATICALLY FC. OK TO CONTINUE IAW MEL 49-1-01 SP1. R & R APU LOW OIL PRESSURE SWITCH IAW AMM 49-94-22, OPS CHKD GOOD.SDR AALA202512237111Strut · fault messageAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED INTO DFW DUE TO THE FLIGHT CREW REPORTING THAT ON APPROACH A FLIGHT CONTROL FLAPS LOCKED / ALIGNMENT FAULT DISPLAYED. THE FLIGHT CREW ACCOMPLISHED QRH PROCEDURES AND LANDED SAFELY AT DFW WHERE IT TAXIED TO THE G