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 VNAA20260303007Rib · crackedCRACKED LT WING L/E RIB SS 15.50. THE RIB WAS REPAIRED IAW REO 690-57-41-580, REV-.SDR CALA2026022614064Structure · corrodedAFT WET AREA, R2 DOOR INNER CHORD POSSIBLE CORROSION BETWEEN BS 947 & 986. REMOVED AND INSTALLED NEW INNER STRUCTURE AT THE R2 DOOR. BS 887 - 1006, RBL 55 IAW SRM 51-40-02-0G-0 AND DWG 147A8501, REV A.SDR IPXA2026021200615Rib · crackedLT WING 475AL HAS CRACKED RIB 7TH FROM FWD END AT BOTTOM-QC 109-VWV REMOVED CRACKED RIB ON 475AL PANEL IAW A300-600F SRM 51-40-21. INSTALLED RIB 7 AND DOUBLER AT RIB 7 USING FASTNERS P/N NAS1097DD-6 B# 0004244840, P/N MS20426DD5-7 B# 0004372118 IAW A300-600-SRSDR IPXA2026021200748Angle · damaged475AL HAS MISSING HALF L ANGLE AT BOTTOM OF 7TH RIB FROM FWD END. REMOVED L ANGLE IAW SRM 51-40-21, WHEN REMOVING FOUND LOWER LONGERON WITH CRACK INSTALLED PANEL 475AL IAW AMM 54-55-00/401SDR SWAA2026021861332Angle · crackedCRACKED ANGLE, BS 500H, S26R. REPLACED THE ANGLE IAW SRM 51-10-02-0G-0, ITEM 9, & DWG 143A7505, SHEET 137, & 138, REV-.SDR SWAA2026021861333Angle · crackedCRACKED ANGLE, BS 500H, S26R. REPLACED THE ANGLE IAW SRM 51-10-02-0G-0, ITEM 9, & DWG 143A7505, SHEET 137, & 138, REV-.SDR SWAA2026021861331Angle · crackedCRACKED GUSSET ANGLE, BS 500I, S21L, IN THE FWD CARGO BAY. REPLACED THE GUSSET ANGLE & FASTENERS IAW SRM 51-40-02-0G, & DWG-143A7902, SHEET 256, REV B.SDR SWAA2026021861448Angle · crackedCRACKED GUSSET ANGLE, 500I, S19R, IN THE FWD CARGO BAY. REPLACED THE GUSSET ANGLE & FASTENERS IAW SRM 51-40-02-0G, & DWG-143A7902, SHEET 256, REV B.SDR SWAA2026021861334Scuff Plate · crackedCRACKED SCUFF PLATE AFT CORNER, IN THE AFT CARGO BAY. REPAIRED THE SCUFF PLATE IAW SRM 53-60-15-2R-1, REPAIR 1; & BAC 5975.SDR SWAA2026021861449Flashlight · inoperativeLAVATORY D FLASHLIGHT INBD INOPERATIVE. REPLACED THE FLASHLIGHT IAW CMM 25-60-02, REV 10, FIGURE 1, ITEM 17, PAGE 10006, & PAGE 10007.SDR SWAA2026021861447Access Panel · crackedCRACKED ACCESS PANEL 191D, LOWER FUSELAGE. REPAIRED THE ACCESS PANEL PANEL 191D IAW SRM 51-70-05-2R-2, REPAIR 2.SDR ASAA2026011462868Apu · odorDMI 545540 - STRONG SOCK SMELL FROM APU BLEED AIR ( APU BLEED AIR SUPPLY SYSTEM (APU AIR NOT AVAILABLE; WILL NEED GRND AIR CON AND AIR START CART) ). GROUNDED - YES. REMOVED AND REPLACED AUXILIARY POWER UNIT, S/N: P-1400, PER T/C 330-49-HWI-02. OPERATIONAL CHSDR AALA202602134436Receiver · gougedAIRCRAFT IN BASE MAINTENANCE: FORWARD GALLEY SERVICE DOOR AFT FRAME MOUNTED LOWER LATCH TRACK FITTING HAS A GOUGE AT LOWER INBOARD SIDE. REMOVED AND REPLACED FORWARD GALLEY SERVICE DOOR FUSELAGE CUTOUT STRUCTURE AFT FRAME MOUNTED LOWER LATCH RECEIVER. PER B737SDR AALA202602131878Fitting · gougedAIRCRAFT IN BASE MAINTENANCE, FORWARD GALLEY SERVICE DOOR FUSELAGE CUTOUT STRUCTURE AFT FRAME MOUNTED UPPER LATCH TRACK FITTING HAS A GOUGE, ON LOWER INBOARD SIDE. REMOVED AND REPLACED FORWARD GALLEY SERVICE DOOR FUSELAGE CUTOUT STRUCTURE AFT FRAME MOUNTED UPPSDR ASAA2026011464294Rib · crackedR/H HORIZONTAL STAB RIB AT STAB STA.111.10 3RD VERTICAL STIFFNER CRACKED. GROUNDED - YES. REPAIRED R/H HORIZ STAB RIB 3RD VERT STIFFNER AT STAB STA 111.10 USING PN:BAC1490-2793 7075-T62 PO:1137296.1, PN:BAC1505-100962 7075-T73511 PO:1137296.2 IAW B737-800 SRM SDR ASAA2026011464293Rib · crackedR/H HORIZONTAL STAB RIB AT STAB STA. 138.70 3RD VERTICAL STIFFNER CRACKED. GROUNDED - YES. REPAIRED R/H HORIZ STAB RIB 3RD VERT STIFFNER AT STAB STA.138.70 USING PN:BAC1490-2793 7075-T62 PO:1137296.1, PN BAC1505-100962 7075-T73511 PO:1137296.2 IAW B737-800 SRMSDR IPXA2026021107234Angle · crackedRH FRAME 47 OF CWB LOWER ANGLE FITTING; CRACK INDICATION NOTED AT HOLE H IN ALL LAYERS. ACCOMPLISHED NDT ROTO INSPECTION OF HOLE H IAW NTM 51-10-01 PART 6. CRACK INDICATION NOTED. T95868 ACCOMPLISH REPAIR IN ACCORDANCE WITH EO-96345-REQ1 AND VT-MAE EA 300-57SDR IPXA2026021107176Angle · crackedRH FR47 OF CWB LOWER ANGLE FITTING; CRACK INDICATION NOTED AT HOLE Z IN ALL LAYERS. VERIFIED ACCOMPLISHED NDT ROTO INSPECTION ON HOLE Z ON ALL LAYERS IAW STEP 20. OF E.A.300-5710-27-A4292 PRELIMINARY 4 AND NTM 51-10-01 PART 6, AND THE INTERNAL FITTING LAYER ISDR SWAA2026020961567Seal · crackedRIGHT HORIZONTAL STAB UPPER SLIDE SEAL IS CRACKED. REMOVED AND REPLACED THE RIGHT STABILIZER TO BODY UPPER FRONT SPAR SLIDING SEAL PLATE IAW AMM 53-31-31-000-802 AND AMM 53-31-31-400-802.SDR SWAA2026020661460Support Bracket · crackedCRACK ON SUPPORT BRACKET LOCATED BS 259.5 AFT SIDE AND S8L AT PASSENG ER CABIN. REPLACED SUPPORT BRACKET LOCATED BS 259.5 AFT SIDE AND S8L AT PASSENGER CABIN AND FASTENERS IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, AND DWG 141A0720, SHEET 46, REV -.SDR CALA2026020613624Window Frame · crackedFOUND CRACKS AT 3RD AND 4TH LOWER CORNER FASTENER HOLES ON LH SIDE NR 3 WINDOW FRAME CRACKED AT 3RD HOLE IS AT 12 O'CLOCK AND 4TH HOLE IS AT 3 O'CLOCK. REPAIRED THE L3 WINDOW FRAME WITH FREEZE PLUGS, EXTERNAL DOUBLER & TRIPLER, INTERNAL DOUBLER REPAIRS IAW RESDR AALA202602051575Latch · gougedAIRCRAFT IN BASE MAINTENANCE: AFT ENTRY DOOR FUSELAGE CUTOUT STRUCTURE FORWARD FRAME MOUNTED UPPER LATCH TRACK FITTING HAS A CHAFE AND GOUGE. REMOVED AND REPLACED AND PERFORMED SATISFACTORY ADJUSTMENT CHECK OF AFT ENTRY DOOR FUSELAGE CUTOUT STRUCTURE FORWARD FSDR AALA202602059680Latch · chafedAIRCRAFT IN BASE MAINTENANCE: FORWARD ENTRY DOOR FORWARD FRAME MOUNTED LOWER LATCH TRACK FITTING HAS A CHAFE. REMOVED AND REPLACED AND PERFORMED SATISFACTORY ADJUSTMENT CHECK OF FORWARD ENTRY DOOR FORWARD LOWER LATCH RECEIVER. PER B737NG SRM 51-40-02 AND AMM 5SDR SOKF2026013001Fire Warning · false activationFLIGHT AV653, DURING TAKEOFF ROLL, AFTER APPLICATION OF TAKEOFF THRUST, AN APU FIRE ECAM IND TRIGGERED, FLT CREW PERFORMED A LOW-SPEED ATO IAW OPS & SAFETY PROCEDURES. ECAM MESSAGE & RED APU FIRE WARNING LIGHT EXTINGUISHED, AS A PRECAUTION, AIRPORT FIRE SERSDR SWAA2026012861029Seal · crackedFUSELAGE TO STAB RT FWD UPPER SLIDING SEAL CRACKED. R & R THE RT SLIDER SEAL IAW AMM 53-31-31. REMOVED BLADE SEAL IAW AMM 53-31-31. OPS CHKD GOODSDR SWAA2026012761025Angle · crackedBS 867, LBL 12, WASTE COMPARTMENT PANEL POST ANGLE CRACKED. VERIFIED CRACK IAW NDT 51-00-00, PT 6, PROCEDURE 23. REMOVED AND REPLACED THE ANGLE IAW SRM 51-40-02.SDR SWAA2026012661012Lamp · inoperativeFWD ENTRY DOOR ESCAPE SLIDE LIGHT (L731) INOPERATIVE. REPLACED THE LAMPS IAW MM 33-51-04. OPS CHECKED NORMAL.SDR IPXA2026012494466Washer · missingMAJOR REPAIR, FOUND AFT CARGO DOOR NOISE DURING OPERATION. (REPLACE) 23. REPLACED THE FORWARD ROTARY ACTUATOR OF AFT CARGO DOOR I.A.W AMM 52-37-04-004-001 REV.147 AND AMM 52-37-04-404-009 REV.147. 24. PERF'D OP TEST OF THE AFT CARGO DOOR I.A.W AMM 52-37-04-40SDR AALA202601256605Support Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK SUPPORT ANGLE ELEVATOR HINGE ARM 5 REAR SPAR ON RH HORIZONTAL STABILIZER. MAINTENANCE REPLACED SUPPORT ANGLE ELEVATOR HINGE ARM 5 REAR SPAR ON RH HORIZONTAL STABILIZER IAW A320 FAM AMM-55-16-42-400-001-A STEPS 4.A. 1 THRU 6SDR IPXA2026012304472Web · damagedSTA 1200 UPPER WEB HAS A DAMAGED HOLE. AFTER FURTHER EVALUATION FOUND 4 DOUBLE HOLE AT THE TOP OF THE WEB. FOUND OUT OF LIMITS IAW B757-200 SRM 53-00-71-1A-1 AD1. CUT AND REMOVE DAMAGED SECTION OF WEB. IAW B757-200 SRM 51-70-13-0G-0 STEP 1. ++INSTALLED REPAIRSSDR SWAA2026012261346Wedge · delaminatedLEFT INBD FLAP TRAILING EDGE WEDGE FOUND DELAMINATED AT TRAILING EDGE. REPAIRED THE LT INBD FLAP TRAILING EDGE WEDGE IAW SRM 57-53-01-2R-7, AND 51-70-10-2R-4.SDR DALA2026012200513Stringer · gougedFUSELAGE STR 1R FR 60-FR 64 DENT, GOUGE, DAMAGED FASTENER HOLES. REPAIRED PER ERA 627744-14 REV A. (1402097)SDR AALA202601228365Hinge Fitting · wornAIRCRAFT IN BASE MAINTENANCE: WEAR ON DOOR FWD HINGE FITTING UNDER BOLT HEAD AT LH MAIN LANDING GEAR. MAINTENANCE PERFORMED PERMANENT REPAIR ON DOOR FWD HINGE FITTING ON LH MAINLANDING GEARIAW EA 370766 AND A320 SRM 51-42-11-801.SDR AALA202601229049Light · inoperativeAIRCRAFT IN BASE MAINTENANCE: FOUND AFT RIGHT HAND ENTRY DOOR EMERGENCY LIGHT L1191 INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHT L1191. PER B737 AMM 33-51-01.SDR CALA2026012213142Attach Angle · crackedCRACKED CENTER SECTION VAPOR BARRIER ATTACH ANGLE AT BS 663.75, RBL 9. REPAIR ACCOMPLISHED IAW SRM 57-10-10-2R-5, REPAIR 5, FIGURES 201-202.SDR AALA202601213687Stringer · corrodedAIRCRAFT IN BASE MAINTENANCE, PERFORMED A REPAIR ON STRINGER 42R BETWEEN FR33 TO FR34 FWD CARGO COMPARTMENT TO ACCOMPLISH EA 370487. MAINTENANCE REWROKED FASTNER HOLES IAW EA 370487.SDR AALA202601212600Stringer · corrodedAIRCRAFT IN BASE MAINTENANCE, PERFORMED A REPAIR ON STRINGER 43R BETWEEN FR33 TO FR34 FWD CARGO COMPARMENT TO ACCOMPLISH EA 370487. MAINTENANCE REWORKED FASTNER HOLES IAW EA 370487.SDR DALA2026012100449Skin · delaminatedVERTICAL STABILIZER RT FIXED PANEL INNER SKIN BETWEEN FRONT SPAR AND AUX SPAR AT VSS 93 TO VSS 145, FOUND DELAMINATED. DAMAGED AREA REPAIRED IAW SRM 55-30-01-2R-1, SRM 51-70-10-2R-4, & SRM 51-70-10 (1400953)SDR DALA2026012100448Skin · delaminatedVERTICAL STABILIZER LT PANEL SKIN AT VSS 170- VSS 195, BETWEEN AUX SPAR & FRONT SPAR FOUND DELAMINATION. DAMAGED AREA REPAIRED IAW SRM 55-30-01-2R-1, SRM 51-70-10-2R-4, & SRM 51-70-10. (1400951)SDR DALA2026012100447Skin · dentedRIGHT WING INBD T/E LOWER FLAP LOWER SURFACE FOUND DENTED AT WS 255.4. DAMAGED AREA REPAIRED IAW SRM 57-53-01-2R-1, SRM 51-70-10-2R-3, SRM 51-70-10-2R-4, AND SRM 51-70-10. (1400937)SDR ASAA2026011463825Seat Track · wornFUSELAGE INTERIOR, COCKPIT, PILOT AND FIRST OFFICERS INBD AFT SEAT TRACK LOCK PIN HOLES ARE OUT OF LIMITS. GROUNDED - YES. R & R THE SEAT TRACKS (2EA) AFT INBD OF THE PILOT AND FIRST OFFICERS SEATS AT COCKPIT IAW CMM 25-11-39, AMM 25-11-01-400-801, 25-11-01-SDR ASAA2026011463824Seat Track · wornFUSELAGE INTERIOR, COCKPIT, PILOT AND FIRST OFFICERS INBD AFT SEAT TRACK LOCK PIN HOLES ARE OUT OF LIMITS. GROUNDED - YES. R & R THE SEAT TRACKS (2EA) AFT INBD OF THE PILOT AND FIRST OFFICERS SEATS AT COCKPIT IAW CMM 25-11-39, AMM 25-11-01-400-801, 25-11-01-4SDR SWAA2026012061084Skin Panel · debondedSKIN PANEL 193CL LOWER FWD CORNER OUTER SKIN HAS A DEBONDED DENT. SKIN PANEL 193CL LOWER FWD CORNER OUTER SKIN WITH A DISBONDED DENT WAS REPAIRED IAW SRM 51-70-05-2R-2.SDR DALA2026012000416Wire · damagedSHIP 651 DURING SVC CHK, FOUND EMERGENCY LIGHT ABOVE 10AB INOPERATIVE. REMOVED AND REPLACED EMERGENCY HOUSING AND BULB. REPINED WIRING AT POWER SUPPLY AS PER SWPM 20-10. OPS CHK OK. (7664264)SDR SIMA2026012014001Floorbeam · corrodedSSI 53-23-005 AFT GALLEY LH CENTER FLOOR BEAM CORRODED BTWN FR 88-89. (MAJOR REPAIR) (LEVEL 2 CORROSION) REMOVED AND REPLACED AFT GALLEY LH CENTER FLOOR BEAM BTWN FR 88-89 IAW ERJ 175 SRM 51-40-08.SDR JJBA20260120043Support Angle · crackedRF1, CARGO ENTRANCE SUPPORT ANGLE ON POST AT FR67 AND BTW STR 15L-16L FOUND CRACKED. RF1, CARGO ENTRANCE, SUPPORT ANGLE ON POST AT FR67 BTW STR 15L-16L REMOVED AND REPLACED.SDR JJBA20260120042Link · crackedON BOTH ELEVATOR, THE TOP SKIN OF ELEVATOR AT SERVO TAB FAIL SAFE LINK IS CRACKED. ON BOTH ELEVATOR, THE TOP SKIN OF ELEVATOR AT SERVO TAB FAIL SAFE LINK TRIM PERFORMED.SDR CALA2026011913086Pin · corrodedNR 1 ENGINE AFT MOUNT LOWER INBD, CENTER,OTBD INNER PINS & OTBD UPPER INNER PIN ARE CORRODED [04 PINS]. REPLACED NR 1 ENG AFT LOWER & UPPER, INNER PINS (INBD, CENTER & OTBD (4 PINS) IAW AMM 71-22-400-010-A.SDR G1IA202601194102Outflow Valve · failedRAPID DECOMPRESSION AT FL310, IMMEDIATE LOSS OF CABIN PRESSURE TO A CABIN ALTITUDE AROUND 17,000 FT. DIFFERENTIAL SLOWLY DECREASED FROM THERE UNTIL THE DIFFERENTIAL WAS AT ZERO. WE WERE REQUIRED TO USE THE OXYGEN MASKS AND DESCEND TO 10,0000 FT. DURING DECENT SDR SWAA2026011960998Flashlight · out of positionAFT RIGHT F/A FLASHLIGHT FOUND OFF MOUNT AND DISCHARGED. OKAY TO CONTINUE IAW MEL 25-64-02A SP1B. AUTHORIZATION 301973. RESEATED FLASHLIGHT IN MOUNT& ESEALED-OPS CCS GOOD IAW AM 25-64-00