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 JR2R20250924209Sill Drain · corrodedR/H MOP SILL BETWEEN FR88-FR90 IS CORRODED. OUT OF LIMITS. REPLACEDSDR JR2R20250924211Gusset · corrodedGUSSET AT FR90, RBL 10, IS CORRODED. OUT OF LIMITS. REPLACEDSDR IXXA2025F00024Skin · crackedUPPER SKIN OF PYLON IS CHAFED FWD LH SIDE UNDER PANEL 441ATSDR JR2R20250924210Doubler · corrodedTEXAS DOULBER AT FRAME 90, RBL 24, IS CORRODED. OUT OF LIMITS. REPLACEDSDR REXA2026052800848Intercostal · corrodedINITIAL INSPECTION: CORROSION ON INTERCOSTAL AT STGR 20LH BTW FS333.00 TO FS 349.00 INTERCOSTAL AT STGR 20LH BTW FS333.00 TO FS 349.00 WAS EVALUATED OUT LIMITS THEREFORE WAS REPLACED PER CRJ900 SRM 51-21-06-001-001-A01, SRM 51-42-06-001-001-A01 AND SRM 51-42SDR REXA2026052600635Web · crackedLEFT ELECTRICAL BAY WEB FLOOR FS 193.00 (BELOW ACCUMULATOR GAUGE INDICATOR) AT FWD EQUIPMENT COMPARTMENT LH ELECTRICAL BAY WEB FLOOR FS 193.00 (BELOW ACCUMULATOR GAUGE INDICATOR) AT FWD EQUIPMENT COMPARTMENT WAS REPAIRED PER CRJ900 SRM 53-11-43-201-001-A01SDR REXA2026052600633Fitting · corrodedCORROSION ON ATTACHEMENT POINT (2EAS) OF GALLEY 1 LOCATED BTW FS280/FS295 AND RBL 18 AND 38 AT FLOOR STRUCTURE OF CABIN PAX. CORROSION ON ATTACHMENT POINT (2EAS) OF GALLEY 1 LOCATED BTW FS280/FS295 AND RBL 18 AND 38 AT FLOOR STRUCTURE OF CABIN PAX WAS REMOVED SDR REXA2026052600632Skin · wornWEAR ON EXTERNAL FUSELAGE SKIN FS913.00 TP FS 927.00 BTW STGR 26LH TO STGR 26RH EXTERNAL FUSELAGE SKIN FS913.00 TP FS 927.00 BTW STGR 26LH TO STGR 26RH WAS REPAIRED PER REO 670-53-00-290 REV -ESDR SWIA2025092375386Hinge Arm · gougedLEFT OUTBOARD FLAP. INBOARD HINGE ARM (WS178.00) HAS GOUGES ON EDGE OF HOUSING FOR SPHERICAL BEARING. REPAIRED DAMAGE ON LH OUTBOARD FLAP. INBOARD HINGE ARM (WS178.00) IN COMPLIANCE WITH REO 670-57-53-428 REV-- DATED 2025-09-26. PERFORMED EDDY CURRENT INSPECTISDR SWIA2025092375359Floorbeam · corrodedLEFT & RIGHT BS 280, COCKPIT FLOOR POST REINFORCEMENT PLATE/SKIN HAS CORROSION. COMPLIED WITH REO 670-53-11-2182 REV--. DISPOSITION FOR RE-INCORPORATION OF BULKHEAD LOWER WEB REPAIR AT FS280.00 (LHS AND RHS) PER SRM TASK 53-11-10-201-004-A01 (GREO 670-53-11-5SDR SWI2025F01668Floorbeam · crackedFLOOR SUPPORT SHEAR BOX LBL9, FS280.00 OUTBOARD ATTACHING ANGLE IS CRACKED IN RADIUS FROM THE TOP TO BOTTOM. REMOVED & INSTALLED NEW FLOOR SUPPORT SHEAR BOX LBL9 FS280 OUTBOARD ATTACHING ANGLE IAW SRM 51-42-21-001-001-A01, & DWG CC670-34010, REV -K. COMPLIED SDR SWI2025F01667Slat Track · damagedLEFT WING SLAT TRACK 3-3 INTERNAL FACE BOTH SIDES OF SECTOR GEAR WITH ROLLER MARKS. BLENDED REPAIR AS REQUIRED PER REO 670-57-42-2268 REV -. COMPLIED WITH TASK CARD 51-900-1002-SKY. OPS CHECK GOOD AT THIS TIME.SDR SWI2025F01666Slat Track · damagedLEFT WING SLAT TRACK 2-3 INTERNAL FACE BOTH SIDES OF SECTOR GEAR WITH ROLLER MARKS. BLENDED REPAIR AS REQUIRED PER REO 670-57-42-2249 REV -- DATED 2025-10-07. COMPLIED WITH TASK CARD 51-900-1002-SKY. OPS CHECK GOOD AT THIS TIME.SDR SWI2025F01665Slat Track · corrodedLEFT WING SLAT TRACK 2-3 EXTERNAL FWD FACE WITH SUSPECT OF SURFACE CORROSION. BLENDED REPAIR AS REQUIRED LH SLAT TRACK 2-3 PER REO 670-57-42-2249 REV -- DATED 2025-10-07. COMPLIED WITH TASK CARD 51-900-1002-SKY. OPS CHECK GOOD AT THIS TIME.SDR SWI2025F01664Slat Track · corrodedLEFT WING SLAT TRACK 2-2 INTERNAL FACE WITH SUSPECT OF SURFACE CORROSION (TWO SPOTS). BLENDED REPAIR AS REQUIRED LH SLAT TRACK 2-2 PER REO 670-57-42-2248 REV A DATED 2025-11-21. COMPLIED WITH TASK CARD 51-900-1002-SKY. OPS CHECK GOOD AT THIS TIME.SDR SWI2025F01663Slat Track · damagedLEFT WING SLAT TRACK 1-1 INTERNAL FACE BOTH SIDES OF SECTOR GEAR WITH ROLLER MARKS. BLENDED REPAIR AS REQUIRED LH SLAT TRACK 1-1 PER REO 670-57-42-2245 REV -- DATED 2025-10-06. COMPLIED WITH TASK CARD 51-900-1002-SKY. OPS CHECK GOOD AT THIS TIME.SDR SWI2025F01662Housing · damagedGALLEY SERVICE DOOR EXTERNAL DOOR HANDLE HOUSING UPPER FORWARD EDGE HAS DAMAGE FROM THE OUTER HANDLE CHAFING. MARKED IN RED (C-CHECK RO 11/30/2025)REPLACED THE SERVICE DOOR HANDLE HOUSING AND HANDLE ASSY REF CRJ-700 CRJ-700 SRM 51-42-06-001-001-A01 AND DWG: CSDR SWI2025F01661Slat Track · wornLEFT WING SLAT TRACK 3-3 EXTERNAL FWD FACE WITH BARE METAL EXPOSED (AS MARKED) (C-CHECK RO 11/30/2025)BLENDED REPAIR AS REQUIRED PER REO 670-57-42-2268 REV -- DATED 2025-10-30. COMPLIED WITH TASK CARD 51-900-1002-SKY. OPS CHECK GOOD AT THIS TIME.SDR SWI2025F01660Slat Track · damagedLEFT WING SLAT TRACK 3-2 INTERNAL FACE WITH ROLLER MARKS (AS MARKED) (C-CHECK RO 11/30/2025)BLENDED REPAIR AS REQUIRED PER REO 670-57-42-2250 REV -- DATED 2025-10-07. COMPLIED WITH TASK CARD 51-900-1002-SKY. OPS CHECK GOOD AT THIS TIME.SDR SWI2025F01659Slat Track · damagedLEFT WING SLAT TRACK 1-3 INTERNAL FACE BOTH SIDES OF SECTOR GEAR WITH ROLLER MARKS (AS MARKED) (C-CHECK RO 11/30/2025)BLENDED REPAIR AS REQUIRED PER REO 670-57-42-2246 REV -- DATED 2025-10-06. COMPLIED WITH TASK CARD 51-900-1002-SKY. OPS CHECK GOOD AT THIS TSDR SWI2025F01658Slat Track · damagedLEFT WING SLAT TRACK 3-1 EXTERNAL FWD FACE WITH SUSPECT OF SURFACE CORROSION (AS MARKED) (C-CHECK RO 11/30/2025)BLENDED REPAIR AS REQUIRED PER REO 670-57-42-2251 REV -- DATED 2025-10-10. COMPLIED WITH TASK CARD 51-900-1002-SKY. OPS CHECK GOOD AT THIS TIME.SDR SWI2025F01657Slat Track · damagedLEFT WING SLAT TRACK 3-1 INTERNAL FACE BOTH SIDES OF SECTOR GEAR WITH ROLLER MARKS (AS MARKED) (C-CHECK RO 11/30/2025)BLENDED REPAIR AS REQUIRED LH SLAT TRACK 3-1 PER REO 670-57-42-2251 REV -- DATED 2025-10-10. COMPLIED WITH TASK CARD 51-900-1002-SKY. OPS CHSDR SWI2025F01656Slat Track · damagedLEFT WING SLAT TRACK 2-1 INTERNAL FACE BOTH SIDES OF SECTOR GEAR WITH ROLLER MARKS (AS MARKED) (C-CHECK RO 11/30/2025)BLENDED REPAIR AS REQUIRED PER REO 670-57-42-2244 REV -- DATED 2025-10-06. COMPLIED WITH TASK CARD 51-900-1002-SKY. OPS CHECK GOOD AT THIS TISDR SWI2025F01655Slat Track · corrodedLEFT WING SLAT TRACK 3-2 EXTERNAL AND INTERNAL FWD & AFT FACE WITH SUSPECT OF SURFACE CORROSION (AS MARKED) (C-CHECK RO 11/30/2025)BLENDED REPAIR AS REQUIRED LH SLAT TRACK 3-2 PER REO 670-57-42-2250 REV -- DATED 2025-10-07. COMPLIED WITH TASK CARD 51-900-100SDR SWIA202512010923Slat Track · damagedLEFT WING SLAT TRACK 2-2 INTERNAL FACE WITH ROLLER MARK. BLENDED REPAIR AS REQUIRED LH SLAT TRACK 2-2 PER REO 670-57-42-2248 REV -- DATED 2025-10-08. COMPLIED WITH TASK CARD 51-900-1002-SKY. OPS CHECK GOOD AT THIS TIME.SDR ASAA2025092362424Power Supply · inoperativeCUSTOMER WALK ITEM: LH AFT OVERWING HATCH EXTERNAL EMERGENCY EXIT LIGHT INOP. GROUNDED - YES. REMOVED AND REPLACED EMERGENCY LIGHT POWER SUPPLY MI675 AT L/H FWD ENTRY DOOR, OPS CHECK COMPLETED. OPS CHECK GOOD I.A.W. B737-800 AMM 31-51-06-960-806.WO: 2065538REFSDR IPXA2025101392852Rib · crackedMAJOR REPAIR - RIGHT WING, CENTER FLAP, TOP SKIN FLANGE, TWO CRACKS INDICATION NOTED AT RIB 11. ACCOMPLISHED PERMANENT REPAIR IAW EO-95369-REQ1 & VT-MAE EA 300-5750-27-A4159, REV -.SDR IPXA2025101391733Rib · crackedRIGHT WING, CENTER FLAP, TOP SKIN FLANGE, THREE CRACK INDICATIONS NOTED AT RIB 27. ACCOMPLISH PERMANENT REPAIR IAW EO-95120-REQ1 AND VT-MAE EA 300-5750-27-A4111.SDR IPXA2025100691954Rib · crackedLEFT WING, CENTER FLAP, TOP SKIN RIB FLANGE. ONE CRACK NOTED AT RIB 26. ACCOMPLISHED PERMANENT REPAIR IAW EO-95368-REQ1 AND VT-MAE EA 300-5750-27-A4158.SDR IPXA2025100691980Rib · crackedLEFT WING, CENTER FLAP, TOP SKIN RIB FLANGE. TWO CRACKS NOTED AT RIB 27. ACCOMPLISHED PERMANENT REPAIR IAW EO-95368-REQ1 AND VT-MAE EA 300-5750-27-A4158.SDR IPXA2025101392168Rib · crackedRIGHT WING, CENTER FLAP, TOP SKIN FLANGE, THREE CRACK INDICATION NOTED AT RIB 26. ACCOMPLISHED PERMANENT REPAIR IAW EO-95369-REQ1 AND VT-MAE EA 300-5750-27-A4159.SDR IPXA2025101392393Rib · crackedRIGHT WING, CENTER FLAP, TOP SKIN FLANGE, ONE CRACK INDICATION NOTED AT RIB 25. ACCOMPLISHED PERMANENT REPAIR IAW EO-95369-REQ1 AND VT-MAE EA 300-5750-27-A4159.SDR IPXA2025101392498Rib · crackedRIGHT WING, CENTER FLAP, TOP SKIN FLANGE, ONE CRACK INDICATION NOTED AT RIB 19. ACCOMPLISHED PERMANENT REPAIR IAW EO-95369-REQ1 AND VT-MAE EA 300-5750-27-A4159.SDR IPXA2025101392588Rib · crackedRIGHT WING, CENTER FLAP, TOP SKIN FLANGE, ONE CRACK INDICATION NOTED AT RIB 18. ACCOMPLISHED PERMANENT REPAIR IAW EO-95369-REQ1 AND VT-MAE EA 300-5750-27-A4159.SDR IPXA2025101392543Rib · crackedRIGHT WING, CENTER FLAP, TOP SKIN FLANGE, ONE CRACK INDICATION NOTED AT RIB 17. PERFORMED 2X CUTOUTS AT RIB 17 TO RIB 19 FROM REAR SAPR TO STR 2.1 IAW SRM-57-50-00 PARA 4E FIG 205 AND EA 300-5750-27-A4159, STEP 15. .ACCOMPLISHED PERMANENT REPAIR IAW EO-95369-RSDR IPXA2025101392772Rib · crackedRIGHT WING, CENTER FLAP, TOP SKIN FLANGE, 1 EA CRACK INDICATION NOTED AT RIB 12. CIRCLED IN RED.ACCOMPLISHED PERMANENT REPAIR IN ACCORDANCE WITH EO-95369-REQ1 AND VT-MAE EA 300-5750-27-A4159.SDR DALA2025110708140None · noneSHIP 9594 ER/A 628659-14AD REV ORIGINAL REQUIRES SECTION II FOLLOW-ON INSPECTIONS FOR CONTINUED AIRCRAFT AIRWORTHINESS. CORRECTIVE ACTION: COMPLIED WITH ERA 628659-14AD REV ORIGINAL REP INSPECTION II. (1215579)SDR ASAA2025092362032Floor Support · crackedINTERCOSTAL AT BL 0 BETWEEN FRAME 277 AND 294.5 CRACKED. GROUNDED - YES. REMOVED AND REPLACED INTERCOSTAL IAW BOEING 737-700 SRM 51-40-02-0G-0.SDR SWIA2025110400923Floorbeam · no discrepancyREQUEST TO PERFORM SPLICE REPAIR ON FLOOR BEAM BS 280, RBL12 FOR FOM. PERFORMED REPAIR ON FLOOR BEAM BS 280 RBL12 IAW REO 670-53-11-896 REV-, AND AMM 20-70-00.SDR SWAA2025103117544Support Angle · crackedCRACK SUPPORT ANGLE LOCATED BS 695 BL 0. REPLACED SUPPORT ANGLE LOCATED BS 695 BL 0 IAW SRM 51-40-02 AND DWG 273A9110 SHEET 6 REV A.SDR SWAA2025103117343Nut Plate · crackedCRACK ON RAIL NUT PLATE, OFSS 491 INTERNAL CAVITY LEADING EDGE, RT WING. REPLACED THE NUT PLATEIAW SRM 51-10-02-0G-0 ITEM 9; SRM 51-40-02-0G-0 AND DWG:112A4402; SHEET:13; REV - .SDR SWAA2025103117349Nut Plate · crackedCRACK ON RAIL NUT PLATE, OFSS 410, INTERNAL CAVITY LEADING EDGE LT WING. REPLACED THE RAIL NUT PLATE IAW SRM 51-40-02 AND DWG 112A4402 SHEET 13 REV - .SDR SWAA2025103117342Light · crackedCRACK ON PHOTOLUMINESCENT STRIP RIGHT SIDE AT PASSENGER CABIN 6 EA. REPLACED PHOTOLUMINESCENT STRIP IAW AMM-33-51-15-400-802.SDR SWAA2025103117354Light · crackedCRACK ON PHOTOLUMINESCENT STR LEFT SIDE AT PASSENGER CABIN 6 EA. REPLACED PHOTOLUMINESCENT LIGHT IAW AMM-33-51-15-400-802.SDR SWAA2025103117348Nut Plate · corrodedCORROSION ON RAIL NUT-PLATE LOCATED OFSS 330 INTERNAL CAVITY LEADING EDGE AT LT WING. REPLACED RAIL NUT-PLATE LOCATED OFSS 330 INTERNAL<BR>CAVITY LEADING EDGE AT LT WING IAW SRM 51-40, AND DWG 112A4402 SHEET 13 REV-.SDR REXA2025103100973Door Sill · corrodedAFT CARGO DOOR SILL IS CORRODED. REMOVED CORROSION ON AFT CARGO DOOR SILL IAW SRM 51-21-06-001-001-A01 UPON FURTHER INVESTIGATION FOUND AFT CARGO DOOR SILL TO BE OUT OF LIMITS IAW SRM 53-61-23-201-001-A01. NOMINAL THICKNESS .063", REMAINING THICKNESS .043", MASDR SWAA2025103017345Frame · crackedCRACK FRAME BS 727D, STRINGER 25L AFT CARGO, PERFORMED REPAIR ON FRAME IAW SRM 53-60-07-2R-2, REPAIR 2, ALTERNATIVE 2, FIGURE 205. REPAIR IS CATEGORY B.SDR VNAA202510300005Drag Angle · crackedCRACK ON LEFT VERTICAL STABILIZER TO FUSELAGE ATTACHMENT AFT DRAG ANGLE BTW 55.625% STGR DATUM TO 67.5% REAR SPAR DATUM (TRACE AT BL0.0). LEFT VERTICAL STABILIZER TO FUSELAGE ATTACHMENT AFT DRAG ANGLE BTW 55.625% STGR DATUM TO 67.5% REAR SPAR DATUM (TRACE ATSDR VNAA202510300003Hinge · crackedIN REFERENCE TO CARD TRFKE00EQGK4': 53-21-23-201-007-A01-PERM REPAIR - PASSENGER DOOR SURROUND STRUCTURE - HINGE REPLACEMENT REPLACE THE PASSENGER DOOR HINGE IN ACCORDANCE WITH CRJ900 SRM TASK 53-21-23-201-007-A01.// ENGINEERING COMMENTS: GENERATE NEW RFTS REQSDR VNAA202510300002Fitting · damagedREPAIR DAMAGED JACKING PAD HELICOIL INSERT LEFT, JACK FITTING LT WING WAS REPLACED PER SRM 51-42-21-001-001-A01.