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 CALA2025110510917Cover · puncturedPUNCTURE IN SLIDE RAFT COVER AT DOOR 4R. INTERIM REPAIR PER EC/RA 2560-03751 REV 0 PART 1 PERFORMED. INSPECTION PER PART 2 PERFORMED. NO FURTHER DISCREPANCIES NOTED. OK FOR DIP. OKAY TO CARRY FORWARD WITH AN INTERIM REPAIR ACCOMPLISHED ON THE R4 DOOR SLIDE BUSDR CALA2025110510916Fairing · damagedHUMMING NOISE COMING FROM ENG 2 SIDE EXIT ROW AT CRUISE. ENG AND PRESS INDICATIONS NORMAL, OK TO PLACE ON CARRY PER MT -53-004 ACCOMPLISHED INTERIM REPAIR AND APPLIED SPEED TAPE TO WING TO BODY PANEL RIGHT SIDE 192DT.SDR CALA2025110510915Bustle · gougedR2 DOOR SLIDE BUSTLE GOUGED. DAMAGE IS 25 INCHES IN LENGTH, .75 INCHES WIDE AND .09375 INCHES AT ITS DEEPEST POINT PERFORMED ECRA 2562-01173 PART 1 INTERIM REPAIR .SDR CALA2025110510914Slide · no discrepancyDISARM THE OVERWING DOORS OFF-WING ESCAPE SYSTEM. REF. EA 5100-01711 REV AB STEP 2.A.7. TRANSFER REF. NON-ROUTINE 7017956 REARMED OVERWING DOORS PER A320 AMM 52-21-10SDR CALA2025110510913Guard · unsecureEMERGENCY LIGHT SWITCH GUARD IS LOOSE SECURED EMERGENCY LIGHT SWITCH GUARD .SDR CALA2025110510912Wire · damagedEMERGENCY ROW LIGHT AT SEAT 31C INOP DEFER. REPLACED LIGHT ASSY ON SEAT. NO HELP. MEL 3350C APPROVED, ONLY ONE LIGHT INOP DEFERRED. FOUND BLACK WIRE RUNNING TO THE EMERGENCY LIGHT AT ROW 31C BROKEN AND LAYING UNDER SEAT. WIRE NEEDS REPAIR. SECURED WIRE OUTSDR CALA2025110510911Packing · not reportedREF LOGPAGE 6827952. REQUIRED TO COMPLETE IDLE POWER TEST REF AMM 71-00-00-720-811-A DUE TO FAN SHAFT COVER PACKING REPLACEMENT IAW AMM 72-15-00-960-801-A. PERFORMED IDLE AND HIGH POWER RUN NO FOUL FOWL SMELL NOTED.SDR CALA2025110510910Unknown · odorFOWL SMELL ON CLIMB & CRUISE. SEEMED LIKE WAS EVERYTIME WENT THRU IMC CONDITIONS. CAPT STATED ODOR WAS INTERMITTENT & OCCURS WHEN FLYING THROUGH MOISTURE OR CLOUDS. ODOR WAS PRESENT WITH ANTI ICE ON OR OFF. ISOLATED APU & APU BLEED WITH PACKS ON, OFF & INDISDR CALA2025110510909Vapor Barrier · crackedCENTER WING REAR SPAR VAPOR WEB IN RT WHEEL WELL HAS CRACK RUNNING DIAGONALLY ACROSS PANEL DIRECTLY FWD OF HYDRAULIC HAND PUMP BRACKET. CRACK IS 8.5" LONG & TERMINATES AT TOP LT HOLE. PANEL IS FIBERGLASS & IS LOCATED BETWEEN RBL 45.64 AND 54.21. CRACK MEETS ASDR CALA2025110510908Elec Connector · shortedTECH SUPPORT UPDATE ON CHRONIC MX AND SPOILER LIGHT W/AHM LOGGING FAULT 27-01620 A COUPLE TIMES SPOILER 9 NOT FOLLOWING COMMANDED SIGNAL FROM SCE. PERF FIM TASK 27-61-T850 DO THE WIRING CHKS FROM SCE TO 9 SPOILER PCU SHAKE HARNESS DOWN WHERE POSSIBLE ENSURE GSDR 2025FA0000742Rotor · crackedOWNER NOTICED A NOISE FROM THE MAIN GEAR AND SOME VIBRATION. UPON INSPECTION THE RIGHT BRAKE ROTOR WAS CRACKED AT THE MOUNTING FLANGE 90% AROUND. LEFT ROTOR WAS BEGINNING TO CRACK AT THE SAME LOCATION. BOTH BRAKE ROTORS WERE REPLACED AT THE JUNE 2025 ANNUAL INSDR IXXA20251105002Skin · corrodedRIGHT WING LOWER SURFACE SKIN PANEL NO 1, WSTA 95.0-177.5 CORROSION GRID NR 2.SDR IPXA2025110521634Switch · brokenEMERGENCY LIGHT SWITCH PANEL, KORRY SWITCH BROKEN €˜UNARMED€? ANNUNCIATOR KORRY LIGHT BROKEN. NIL SPARE AVAILABLE. REMOVED AND REPLACED EMERGENCY LIGHTS CONTROL PANEL IAW AMM 33-51-08 / 401, REV 146. FUNCTION CHECKS SATIS.SDR IXXA20251105001Skin · corrodedRIGHT WING LOWER INBD SURFACE, AFT OUTBD OF FUSELAGE HAS AREA OF CORROSION WSTA, 95.0-177.5SDR AALA202511053090Battery · no testAIRCRAFT IN BASE MAINTENANCE: BATTERY FAULT FOR EMERGENCY POWER SUPPLT UNIT 13WL DISPLAYED DURING SYSTEM TEST. REPLACED BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR AALA202511054671Battery · no testAIRCRAFT WAS NOT GROUNDED: MID FLIGHT ATTENDANT FLASHLIGHT INOPERATIVE. REPLACED FLASHLIGHT BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 25-60-00.SDR DALA2025110508069Power Supply · no testDURING SVC CHECK, FOUND MULTIPLE PATHWAY EMERGENCY LIGHTS OUT IN AFT CABIN. BITE TEST FAULTED EPSU (11WL). REPLACED 11WL EMERGENCY POWER SUPPLY UNIT, REF A321 AMM 33-51. OPS CHECK GOOD. (LP 7659343)SDR FDEA202511052126Skin · damagedFOUND A LIGHTNING STRIKE DAMAGE AT RUDDER LH SURFACE AT RUD STA 487 & 4" FWD OF RUDDER TRAILING EDGE. REPAIRED A LIGHTNING STRIKE DAMAGE AT RUDDER LH SURFACE AT RUD STA 487 AS PER B777 SRM 55-40-01-2R-1 FIGURE 202, SRM 51-70-04-2R-1 FIGURE 201, SRM 51-6SDR FDEA202511052125Floor Panel · damagedUPPER MAIN CARGO COMPARTMENT FAR L/H FLOOR PANEL AT STATION 880 HAS SMALL PUNCTURE. MARKED WITH ORANGE DOT. REPAIRED FLOOR PANEL 241KFF, MPN: 145T5876-8, LBL 77.50- LBL 87.50, STA. 875.90- 933 IN REF. TO B767 SRM 53-00-50-2R, FIG 201, REPAIR 1, SHEET 2, ANSDR FDEA202511052124Frame · crackedVERTICAL STABILIZER REAR CENTER SPAR STIFFENER CRACKED AT STATION 2122 5 O' CLOCK AREA. CRACKED STIFFENER AT EMPENNAGE VERTICAL STABILIZER REAR CENTER SPAR AT STATION 2122 5 O' CLOCK AREA REPAIRED AS PER EA# 1-5530-T0385238 P1 TITLE: STABILIZERS - VERTICALSDR CALA2026090119130Skin · crackedCRACK FOUND ON RT HORIZONTAL STAB LOWER SKIN AT HSS 101.90, 10" FROM REAR SPAR, INBD ROW. CRACK LENGTH 1IN?. REPAIRED THE RT HORIZONTAL STAB LOWER SKIN IAW SRM 55-10-01-2R-11.SDR AALA202601150368Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT SHIELD ASSEMBLY FROM BS 767 TO BS 793, AT S25R. REPLACED SHIELD PER AARD 51-00-05-1.SDR AALA202601155605Tie Down · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L1 DOOR FLOOR MOUNTED AFT GIRT BAR TIEDOWN AT BS 344, LBL 59. REPLACED TIEDOWN PER AARD 51-00-05-1.SDR AALA202601151926Tie Down · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L1 DOOR FLOOR MOUNTED AFT GIRT BAR TIEDOWN AT BS 360, LBL 42. REPLACED TIEDOWN PER AARD 51-00-05-1.SDR AALA202601156914Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL FROM BS 727H TO BS 807 AT LBL 25. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA202601151916Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT BS 950, LBL 24. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR SWI2025F01846Floorbeam · crackedTRANSVERSE FLOOR BEAM @ FS. 589 FOUND TO BE CRACKED IN MULTIPLE LOCATIONS WHERE AFT CARGO DOOR LOWER SILL SITS. REPAIRED TRANSVERSE BEAM AT FS 589.00 IAW MHIRJ REO 601R-53-61-8412 REV--. COMPLETED TASK CARD 51-900-1003-SKY. REFERENCE CONTINUE CARD FOR WORK PESDR SWIA2025121901104Door Sill · corrodedAFT CARGO DOOR LOWER SILL, CORRODED IN MULTIPLE LOCATIONS AND BENT, EVAL REQUIRED. REMOVED AND REPLACED CARGO DOOR LOWER SILL IAW SRM 51-42-21, 51-40-11, 51-42-06, 51-42-13, REV. 39B, AND REO 601R-53-61-8412, REV--. COMPLETED TASK CARD 51-900-1003-SKY. RSDR ASAA2025110463110Skin · dentedDENT ON BELLY SKIN AT STATION 400. GROUNDED - YES. (RESOLVED ON W/O: 2071370 TASKCARD: N/R-00026 ) ACCOMPLISHED REPAIR IAW EA 700-53EA-29631.SDR SWAA2025121531736Bear Strap · crackedCRACK INDICATION ON BEAR STRAP FORWARD GALLEY DOOR BETWEEN BS 291 TO BS 294.5 AND BETWEEN S-8R TO S-9R. CRACK LENGTH 0.250 IN. APPROX. REPAIRED BEAR STRAP EXTERNAL SKIN IAW SRM 53-10-01-2R-6, AND EA M-25-153-01539.SDR SWAA2025121531738Stub Frame · crackedCRACK INDICATION ON STUB FRAME, BETWEEN BS 294.5 - 296.5, BTW S8 - 9R IN THE FWD GALLEY DOOR AREA, CRACK LENGTH 0.437 IN. REPLACED THE STUB FRAME IAW SRM 51-10-02, ITEM 9, DWG 141A8370, SHEET 9, REV-, AND DWG 141A8370, SHEET 10, REV-.SDR SWAA2025121531620Access Panel · crackedCRACKED ACCESS PANEL 561BB ON LT WING. REPAIRED THE ACCESS PANEL 561BB IAW SRM 51-70-04-2R-10, REPAIR 10.SDR SWAA2025121246375Battery Pack · inoperativeINOPERATIVE BATTERY PACK ON POWER SUPPLY M1669 IN PAX CABIN. REPLACED THE BATTERY PACK IAW AMM 33-51-06-960-805, TESTED OK.SDR SWAA2025121243257Battery Pack · inoperativeINOPERATIVE BATTERY PACK ON POWER SUPPLY M1668 IN PAX CABIN. REPLACED THE BATTERY PACK IAW AMM 33-51-06-960-805, TESTED OK.SDR SWAA2025121243258Battery Pack · inoperativeINOPERATIVE BATTERY PACK ON POWER SUPPLY M1670 IN PAX CABIN. REPLACED THE BATTERY PACK IAW AMM 33-51-06-960-805, TESTED OK.SDR SWAA2025121243256Battery Pack · inoperativeINOPERATIVE BATTERY PACK ON POWER SUPPLY M1669 AT PAX CABIN. REPLACED THE BATTERY PACK IAW AMM 33-51-06-960-805, TESTED OK.SDR SWAA2025121031762Access Panel · delaminatedDELAMINATED ACCESS PANEL 542EB AT LT WING. REPLACED BY A NEW ACCESS PANEL 542EB IAW AMM 27-51-18-400-802, STEP 5.G(5).SDR SWAA2025121046456Access Panel · delaminatedDELAMINATED ACCESS PANEL 542EB AT LT WING. REPLACED DELAMINATED ACCESS PANEL 542EB DUE TO WAS FOUND OUT OF LIMIT IAW AMM 27-51-18-400-802 STEP 5.G5.SDR 2025FA0000813Seat Track · corrodedCORROSION FOUND ON SEAT TRACK CROWN LOCATION Y1959 BETWEEN FR53.3 TO FR53.4. SEAT TRACK REPLACED.SDR 2025FA0000812Seat Track · corrodedCORROSION FOUND ON SEAT TRACK CROWN LOCATION Y1959 BETWEEN FR53.3 TO FR53.4. SEAT TRACK REPLACED.SDR 2025FA0000811Seat Track · corrodedCORROSION FOUND ON SEAT TRACK CROWN LOCATION Y450 BETWEEN FR59 TO FR60. SEAT TRACK REPLACED.SDR 2025FA0000810Seat Track · corrodedCORROSION FOUND BELOW SEAT TRACK CROWN LOCATION Y1959 BETWEEN FR26 TO FR37.4. SEAT TRACK REPLACED.SDR 2025FA0000809Seat Track · corrodedCORROSION FOUND BELOW SEAT TRACK CROWN LOCATION Y1552.5 BETWEEN FR31 TO FR35. SEAT TRACK REPLACED.SDR 2025FA0000808Seat Track · corrodedCORROSION FOUND BELOW SEAT TRACK CROWN LOCATION Y1522.5 AT FR33. SEAT TRACK REPLACED.SDR 2025FA0000804Seat Track · corrodedCORROSION FOUND ON SEAT TRACK CROWN LOCATION Y953 BETWEEN FR11 TO FR18. SEAT TRACK REPLACED.SDR 2025FA0000803Web · corrodedCORROSION FOUND ON WEB LOCATION Y2462 AT FR17. WEB REPLACED.SDR SIMA20251104002Pin · corroded55-10-021-0150 CORROSION ON LH HORIZONTAL STAB PIN. (MAJOR REPAIR)) (LEVEL 2 CORROSION). REMOVED AND REPLACED WITH NEW LH HORIZONTAL EXTERNAL HINGE PIN P/N 170-62007-001 HSTA OP CHECKED GOOD IAW E175 AMM 27-41-03. AMM 27-40-00. HORIZONTAL STABILIZER OP CHECKEDSDR AALA202512048811Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOORBEAM PANEL AT BS 540 FROM RBL 45 TO RBL 65. REPLACED IAW AARD 51-00-05-1 .SDR AALA202512044792Flashlight · no testAIRCRAFT IN BASE MAINTENANCE: FLASHLIGHT AT LAVATORY D IS INOPERATIVE. REPLACED FLASHLIGHT PER TASK CARD 26C22025010.SDR ASAA2025110462621Pan · gougedR2 DOOR, EXTERNAL HANDLE PAN, INSIDE DIAMETER CUT OUT IS GOUGED. GROUNDED - YES. REMOVED DAMAGED GOUGED HANDLE PAN ASSY AND INSTALLED NEW 147A6137U4 HANDLE PAN ASSY IAW B737-800 SRM 51-40-02 AND BAC DWG 147A6502 REV A.