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 AALA202507149220Power Supply · 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. (AALA202507141191) A SATISFACTORY OPERATSDR AALA202507140740Wire · brokenAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT ON PASSENGER SEAT 27 ABC INOPERATIVE. MAINTENANCE FOUND BROKEN WIRE AND REPAIRED THE WIRE PER ESPM 20-43-12.SDR AALA202507147263Wire · brokenAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT ON PASSENGER SEAT 28 ABC INOPERATIVE. MAINTENANCE FOUND BROKEN WIRE AND REPAIRED THE WIRE PER ESPM 20-43-12.SDR DALA2025071405285Engine · faultedSHIP 9558 - RTO - CREW REPORTED WITH AUTO-THROTTLE ENGAGED AT 60KNTS RIGHT THROTTLE RETARDED. P30 FAULT, INSPECTED FOR LEAKS/BLOCKAGE WITH NO FINDINGS. REPLACED RIGHT ENGINE EEC, NO HELP. REPLACED #2 ENGINE.SDR UIEA2025070600836Skin · delaminatedRHW I/B FORE FLAP L/E MID AND O/B AREA FOUND DELAMINATED.(<P>PERFORMED PERMANENT COMPOSITE REPAIR AS PER SRM 51-70-07, PAR.5.A.(1). NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025070600837Skin · delaminatedLHW I/B MID FLAP L/E MOST I/B AREA FOUND DELAMINATED.(<P>PERFORMED PERMANENT COMPOSITE REPAIR AS PER SRM 51-70-07, PAR.5.A.(1). NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025070600838Skin · delaminatedLHW I/B FORE FLAP O/B OF MID FORE FLAP TRACK APPROX 9" L/E AREA FOUND DELAMINATED.(<P>PERFORMED PERMANENT COMPOSITE REPAIR AS PER SRM 51-70-07, PAR.5.A.(1). NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025070600839Skin · delaminatedLHW I/B FORE FLAP L/E MOST I/B AREA FOUND DELAMINATED.(<P>PERFORMED PERMANENT COMPOSITE REPAIR AS PER SRM 51-70-07, PAR.5.A.(1). NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025070600840Skin · delaminatedLHW I/B FORE FLAP I/B OF FORE FLAP TRACK CUTOUT FOUND DELAMINATED.(<P>PERFORMED PERMANENT COMPOSITE REPAIR AS PER SRM 51-70-07, PAR.5.A.(1). NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025070600843Brace · chafedNO.1 PYLON DIAGONAL BRACE RH BELOW HYD DEPRESSURIZATION MODULE FOUND CHAFING.(<P>#1 PYLON DIAGONAL BRACE CHAFING AREA SMOOTHED AS PER RI-54-50-17750 REV.A. (AFTER SMOOTH OUT AREA MEASURED: L=2", W=1.25" & D=0.125"). NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025070700853Fairing · delaminatedDORSAL FAIRING FOUND DELAMINATED.(<P>PERFORMED REPAIR AT DELAMINATION AREA IAW RI-55-30-17752 REV.A. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025070900876Channel · crackedLH HORIZONTAL STABILIZER TIP FAIRING AFT SUPPORT U CHANNEL FOUND CRACKED.(<P>LH HORIZONTAL STABILIZER TIP FAIRING T/E WEDGE U CHANNEL REPLACED AS PER RI-55-10-17767 REV A. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025070900877Door · chafed#2 PYLON LH AFT FAIRING DOOR FOUND CHAFFING.(<P>PERFORMED REPAIR AT CHAFFING AREA IAW <SPAN>RI-54-50-17761, REV. A. NO FURTHER DEFECTS NOTED.</SPAN></P>)SDR UIEA2025070900882Skin · dentedFX STA 520-540 R/H S43R - S44R SKIN FOUND DENT.(<P>FX STA 520-540 R/H S43R-S44R SKIN DENT AREA REPAIRED AS PER SRM 53-00-01-2R-1 REQ 104. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025071000889Stiffener · crackedLHW L/E LOWER CENTER ZEE STIFFENER FOUND CRACKED.(<P>LHW L/E LOWER CENTER ZEE STIFFENER REPLACED AS PER RI-57-26-17755 REV A. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025071000890Panel · crackedNO.4 PYLON O/B #482KR PANEL FOUND CRACKED.(<P>NO.4 PYLON O/B #482KR PANEL REPLACED AS PER RI-54-50-17765 REV A. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025071000891Beam · damagedNO.4 PYLON AFT FAIRING AREA APPROX WAC STA 415 UPPER BEAM RH FASTENER HOLE FOUND ELONGATED(<P>OVERSIZE FASTENER HOLE AND INSTALL FREEZE PLUG PER RI-54-50-17760 REV A. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025071000892Rib · crackedLHW L/E #581HB PANEL RIB FOUND CRACKED.(<P>LHW L/E #581HB PANEL RIB REPLACED AS PER RI-57-51-17762 REV A. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025071000894Rib · crackedLHW L/E #581JB PANEL RIB FOUND CRACKED.(<P>LHW L/E #581JB PANEL RIB REPLACED AS PER RI-57-51-17769 REV A. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025071200937Fuel Tank · corrodedLWLG W/W CENTER TANK AFT B/H FUEL BONDING ATTACH AREA SURFACE CORROSION.(<P><SPAN>LWLG W/W CENTER TANK AFT B/H FUEL BONDING AREA </SPAN>CORROSION REMOVED AS PER SRM 51-10-02 AND REPROTECTED AS PER SRM 51-20-01. WITHIN ALLOWABLE DAMAGE LIMITS IAW SRM 57-10-10 ASDR IPXA2025071497375Cable · not reportedDOOR 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).SDR IPXA2025071490470Link · gougedCREW DOOR, AFT EDGE, LOCK CRANK LINK HAS GOUGE.SDR IPXA2025071490080Guide · gougedFUSELAGE, CREW DOOR CUT-OUT, FWD EDGE, LOWER SIDE, ROLLER GUIDE HAS GOUGE.SDR IPXA2025071490326Retainer · gougedCREW DOOR, AFT EDGE, LOWER SIDE, SEAL RETAINERS (2EA) HAVE GOUGE.SDR AALA202507144587Unknown · odorAIRCRAFT WAS GROUNDED: POSSIBLE FUME EVENT ON TAKEOFF. FAS IN AFT GALLEY DESCRIBED "DIRTY SOCK" ODOR ON TAKEOFF THAT DISSIPATED AFTER TAKEOFF. (OPEN)SDR CALA2025071406512Floor Support · corrodedFOUND CORROSION AFT WET AREA SUPPORT INTERCOTAL STA 951 RBL 51. (REF AAR N/R 97526756) FOUND CORROSION OUT OF LIMIT, REMOVED AND REPLACED, INSTALLED NEW INTERCOSTAL AT STA 947 TO STA 967 AS PER REF SRM 51-10-02-0G-0.SRM 51-40-02-0G-0, 53-70-51-1A-1 DETAL 4A FSDR CALA2025071406511Fuel Cap · missingPDA 2 UPON ARRIVAL TO DENVER, FLIGHT 1925, FUELER REPORTED REFUEL/DEFUEL COUPLING CAP MISSING. SDR AND SFR FLAGGED FOR REFUEL DEFUEL COUPLING CAP MISSING ON ARRIVAL, PART DEPARTING AIRCRAFT. CAP WAS REPLACED.SDR CALA2025071406510Oxygen Box · unsecureO2 MASK 27A NOT STOWED FOUND PASSENGER OXYGEN MASK CONTAINER SECURED AND STOWED MASKS NOT DROPPED. FOUND CONTAINER TRIM LOOSE RESECURED IN PLACE IAW AMM 35-21-43SDR CALA2025071406509Seat Track · corrodedFOUND CORROSION AT MAIN CABIN FLOOR L/H O/B SEAT TRACK UPPER CROWN STA 500E LBL 45.5 (REF AAR N/R 97526722) ACCOMPLISHED SEAT TRACK REPAIR AT MAIN CABIN BETWEEN STA 480 TO STA 500E+9,5" LBL 45.5" PER SRM 53-00-52-2R-4 AND DWG#143A5300.SDR CALA2025071406508Wire · brokenEMERGENCY LIGHTING SYSTEM OPERATIONAL CHECK. EMERGENCY LIGHT AT SEAT 26C INOP. WIRES DISCONNECTED CAPPED BROKEN WIRES AND SECURED IN RACEWAY UNDER SEATS 26AB. HARNESS P/N IS BR9635-120-24 M&E 29-3350-3-0010 PER CONFIG DWG 3350DD14743. NIS AT CLE. PAR# 29-335SDR DALA2025071405273Battery Pack · inoperativeSHIP 1813 50FG - 56FG EXIT LIGHTS INOP. CORRECTIVE ACTION: R/R EEPLS BATTERY PACK IAW B767 AMM 33-51-07. (7373748).SDR YENA2025071400725Light · failedFLT#8373, MAD-JFK. (ETOPS) "HZD LIGHT ON WX RADAR PANEL IS BURNED OUT. HZD FUNCTION WORKING PROPERLY; REMOVED AND REPLACED WEATHER RADAR CONTROL UNIT IAW AMM 34-41-12.OPS CHK GOOD."SDR YENA2025071400724Warning Message · illuminatedFLT 509, BOS-JAX. ETOPS AIR BLEED CLASS 2 MX MESSAGE, CLASS II MAINTENANCE MESSAGES DISPLAYED ON ECAM STATUS PAGE OF ECAM SYSTEM DISPLAY 1, FAULTS INDICATED BY AIR BLEED. PERFORMED BITE TEST OF EBAS PER TASK 36-11-00-740-802-A.TEST OK, NO FAULT PRESENT SDR KCSA2025071238Lock · faultedDOOR UPPER DECK FLIGHT LOCK. TRANSFERRED TO DMI 100259089 IAW MEL 52-23-6-2 CATEGORY C DUE. PLACARDS INSTALLED MAINTENANCE PROCEDURES COMPLIED WITH. 100259106 - PERFORMED ADJUSTMENT TEST OF UPPER DECK FLIGHT LOCK IAW B747-400 AMM 52-23-00. NO DEFECTS NOTED.SDR FDEA202507121185Floor Panel · crackedREWORK: MAIN DECK CARGO FLOOR PANEL P/N:152W8302-33 FOUND CRACKED AT STA1010 LBL85. MAIN DECK CARGO FLOOR PANEL P/N:152W8302-33 CRACKED AT STA1010 LBL85 DAMAGE SIZE: L=3.5" DAMAGE OUT OF ALLOWABLE LIMIT AS PER B777 SRM 53-00-50-1A ALLWABLE DAMAGE 1 FIGSDR FDEA202507121184Engine · failedAT FL360 STARTING THE DESCENT WE RECEIVED A LVL 2 SELECT FADEC ALTN ALERT ON ENG 2. STARTED THE QRH CHECKLIST WE RECEIVED A LVL 2 ENG 2 RPM LO ALERT. COMPLETED THE FADEC CHECKLIST AND GOT THE FADEC BACK. THEN COMPLETED THE ENG 2 RPM LO CHECKLIST WITH ASDR AALA202507143939Beam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN R1 DOOR HANDLE BOX ASSEMBLY BEAM. REPLACED BEAM PER AARD 51-00-05-1.SDR F3LA202507140267Skin · damagedDISCREPANCY: AC WAS PULLED OOS FOR THIS EVENT REFERENCE LOG PAGE LP585145 SUSPECTED TAIL STRIKE UPON LANDING.SDR DALA2025071305250O-Ring · leakingAIRCRAFT 5010, ON DESCENT INTO JFK, CREW REPORTED THE "DIRTY SOCK" ODOR TO JFK ATC, DECLARED AN EMERGENCY AND DONNED OXYGEN MASKS. T/S PER WORKCARD 0550-2002. FOUND OIL WETTING ON NBR 1 ENGINE SPINNER. REPLACED LPT PWGG ORING PER A321 AMM 72-11. (LP 7356906)SDR SWIA202511030711Floorbeam · corrodedFS280.00 FWD FLOOR SUPPORT ANGLE HAS EVIDENCE OF CORROSION. (S/N#00568) (C-CHECK RO 11/01/2025)REMOVED AND REPLACED NEW ANGLE FLOOR SUPPORT ON FS 280.00 FWD REF CRJ900 SRM 51-42-06-001-001-A01 AND SRM 51-42-21-001-001-A01 AND DWG# CC670-34326 REV -A COMPLIEDSDR JJBA20251024074Floor Support · corrodedLH FLOOR SEAL FROM FRAME 23 TO 35 HAS CORROSION. LH FLOOR SEAL FROM FRAME 23 TO 35 REMOVED AND INSTALLEDSDR AALA202508285422Shear Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO PASSENGER CABIN FLOOR STRUCTURE SHEAR WEB LOCATED FROM BS 1017 TO BS 1023 AND FROM RBL 31 TO RBL 37. REPLACED WEB PER AARD 51-00-05-1 AND EA 366680.SDR AALA202508283879Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER CHORD (T-CAP) LOCATED AT BS 947, RBL 26. REPAIRED UPPER CHORD PER SRM 53-70-51-2R-5.SDR AALA202508280958Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON R2 ENTRY LOWER SILL INNER CHORD (CREASE ANGLE) LOCATED AT BS 963, RBL 55. REPLACED CHORD PER AARD 51-00-05-1.SDR AALA202508255277Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER CHORD (T-CAP) LOCATED AT BS 947.5, FROM LBL 21 TO LBL 26. REPLACED UPPER CHORD PER SRM 53-70-51-2R.SDR AALA202508259251Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER CHORD (T-CAP) LOCATED AT BS 947.5, FROM LBL 6 TO RBL 11. REPLACED UPPER CHORD PER SRM 53-70-51-2R.SDR SWAA2025082290419Access Panel · elongatedELONGATED HOLES ON ACCESS PANEL 192HR BODY FAIRING AT FUSELAGE EXTERIOR 2025-447888<[01] EQUIPMENT P/N EPOCH 650; S/N 190776902; DUE DATE 15-OCT-25 WAS USED ON STEP 10;[02] TOOL USED: HUMIDITY/TEMPERATURE CHART RECORDER P/N: TH8P3/R250; S/N: 16240122 ; DUE DATSDR SWAA2025081590605Shear Web · corrodedCORROSION ON L/H SHEAR WEB AT BS 1026 LBL 22 WL 208<[01] SHEAR WEB FOUND TO BE OUT LIMITS; PART REMOVED AND REPLACED SHEAR WEB AT BS 1016 TO BS 1033 LBL0 TO LBL39 WL 208 PER I.A.W SRM 51-10-02-0G-0 PAR 9.C; SRM 51-40-02-0G-0 AND BOEING DWG 147A5600 REV:BSDR SWAA2025081590606Strap · corrodedCORROSION ON STRAP AT BS 1016 LBL 3 WL 208<[01] STRAP FOUND TO BE OUT LIMITS; PART REMOVED AND REPLACED AT BS 1016 TO BS 1029 LBL3 TO LBL39 WL 208 PER I.A.W SRM 51-10-02-0G-0 PAR 9.C; SRM 51-40-02-0G-0 AND BOEING DWG 147A5600 REV:B.SDR SWAA2025081590609Shear Web · corrodedCORROSION ON STRAP ON R/H SHEAR WEB AT BS 1028.5 RBL 18 WL 208. STRAP FOUND TO BE OUT LIMITS; PART REMOVED AND REPLACED BS 1016-BS1029 RBL18 WL 208 PER I.A.W SRM 51-10-02-0G-0 PAR 9.C; SRM 51-40-02-0G-0 AND BOEING DWG 147A5730 REV:C.