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 FDEA202509221759Floor Panel · damagedMAIN DECK CARGO COMPARTMENT, FLOOR PANEL 222CFF HAS NUMEROUS DENTS. JM33. REPAIRED MAIN CARGO COMPT. DENTED DAMAGED AREAS AT STA:285-412, RBL 54.75-77.5, PNL# 222CFF, MPN: 141T5856-116 TOP SKIN OF FLOORBOARD. IN REF. TO B767 SRM 53-00-50-2R FIG. 201 SHEET.SDR FDEA202509221758Floor Panel · damagedMAIN DECK CARGO COMPARTMENT, FLOOR PANEL 221DFF HAS NUMEROUS DENTS. JM29 REPAIRED MAIN CARGO COMPT. DENTED DAMAGED AREAS AT STA:285-400, LBL 11- 33, PNL# 221DFF, MPN: 141T5856-117 TOP SKIN OF FLOORBOARD. IN REF. TO B767 SRM 53-00-50-2R FIG. 201 SHEET.2 REPSDR FDEA202509221757Floor Panel · damagedMAIN DECK CARGO COMPARTMENT, FLOOR PANEL 221DFF HAS NUMEROUS DENTS. JM29 REPAIRED MAIN CARGO COMPT. DENTED DAMAGED AREAS AT STA:285-400, LBL 11 - 33, PNL# 221 DFF, MPN: 141T5856-117 TOP SKIN OF FLOORBOARD. IN REF. TO B767 SRM 53-00-50-2R FIG. 201 SHEET.2 RSDR FDEA202509221756Floor Panel · damagedMAIN DECK CARGO COMPARTMENT, FLOOR PANEL 222BF HAS NUMEROUS DENTS. FABRICATED NEW FLOOR PANEL 222BFF, MPN: 141T5856-106, RBL 33 RBL 77.50, STATION 285-412 IN REF TO BOEING DWG 141T5856-106. SEE JPF FOR ALL WORK PERFORMED. THIS IS A MAJOR REPAIR. INSTALLATISDR DALA2025092206925Light · inoperativeROW 17 D, E, F WHITE EMERGENCY LIGHT INOP. R & R WHITE EMERGENCY LIGHT IAW A319 AMM 33-51. (7318128).SDR DALA2025092206901Oil System · leakingON DESCENT BELOW 11,000 FEET STRONG DIRTY SOCK SMELL DISSIPATED ON GROUND WHEN SWITCHING BLEEDS TO APU. PERFORMED AND C/W MUST DO LOG 1210407 FOUND OIL PUDDLED AT BASE OF FAN HUB ON # 1 ENGINE REMOVED SPINNER AND FAN SHAFT COVER PER A321 AMM 72-11 INSTALLED SDR K11A2025092200349Cabin Pressure · faultedAUTO FAIL LIGHT ILLUMINATED AFTER TAKE-OFF, CABIN ALTITUDE NOT CONTROLLABLE IN AUTO OR STANDBY MODES. FOUND L1 DOOR AJAR UPON RETURNING TO GATE. OPS CHECK L1 DOOR IAW B737 AMM 52-11-00, NO DEFECTS NOTED. PERFORMED OPS CHECK OF CABIN PRESSURIZATION CONTROL SYSTSDR SCNA20250922387Cover · unsecure1R DOOR PANEL COVERING SLIDE GAUGE FELL DOWN INSIDE PANEL. RESECURED ESCAPE SLIDE COVER WINDOW REF AMM 25-66-01. OK FOR SERVICESDR REXA2026052800850Rub Strip · wornOUT OF SCOPE': WEAR ON RUB STRIPS OF LOWER AND UPPER FORWARD CORE COWL AT RH ENGINE/LH ENGINE WEAR ON RUB STRIPS OF LOWER AND UPPER FORWARD CORE COWL AT RH ENGINE AND UPPER FORWARD CORE COWL LH ENGINE WERE REPLACED PER CRJ-900 SRM 54-23-00-201-006-A01, RUB STSDR REXA2026052800849Rub Strip · wornOUT OF SCOPE': WEAR ON RUB STRIPS OF LOWER AND UPPER FORWARD CORE COWL AT RH ENGINE/LH ENGINE WEAR ON RUB STRIPS OF LOWER AND UPPER FORWARD CORE COWL AT RH ENGINE AND UPPER FORWARD CORE COWL LH ENGINE WERE REPLACED PER CRJ-900 SRM 54-23-00-201-006-A01, RUB STRSDR REXA2026052600637Access Panel · corrodedCORROSION ON SETTLEMENT AREA OF HYDRAULIC ACCESS PANEL 195AB. STRAP ON SETTLEMENT AREA ON ACCESS PANEL 195AB WAS FOUND TO EXCESSIVE DAMAGE THEREFORE WAS FABRICATED AND INSTALLED PER CRJ900 SRM 53-82-55-101-002-A02, SRM 51-42-13-001-001-A01 AND EA CRJ953-20441SDR REXA2026052600625Support Angle · crackedCRACK AT LOWER SUPPORT ANGLE OF EXTERNAL SERVICE PANEL. CRACKED LOWER SUPPORT ANGLE OF EXTERNAL SERVICE PANEL WAS REPLACED IAW SRM 51-42-06-001-001-A01SDR 9WGA2026010354682Spar · corrodedDURING HEAVY MAINTENANCE AREA INSIDE THE LH HORIZONTAL STAB HAS (1) SPOT OF POSSIBLE CORROSION ON THE SPAR WEB LOWER MID SECTION @ APPROXIMATELY (XE-217.500) JUST BELOW THE FASTENER ROWS. AFTER FURTHER EVALUATION OF AREA AT INSIDE THE LH HORIZONTAL STABILIZERSDR SWI2025F01672Frame · corrodedCORROSION ON FS349.00 FRAME FORWARD WEB OUTBOARD OF STGR26R. REPAIRED FS 349 FRAME BETWEEN STR26R TO STR25R. REF CRJ 700 SRM 53-00-06-201-004-A01, SRM 51-42-06-001-001 A01. COMPLIED WITH ALL STEPS OF TASK CARD 51-900-10002-SKY. SEE CONTINUATION CARD FOR DETASDR SWI2025F01671Striker · corrodedSERVICE DOOR SURROUND LOWER SEAL STRIKER HAS CORROSION AROUND MULTIPLE FASTENER HOLES. (C-CHECK RO 11/30/2025)REPLACED GALLEY SERVICE DOOR LOWER SEAL STRIKER REF DWG: SH670-31950 REV Y, CRJ-700 SRM 51-42-06-001-001-A01. COMPLIED WITH TASK CARD 51-900-1002-SSDR SWI2025F01670Support Angle · corrodedSERVICE DOOR SURROUND HAS CORROSION ON 3EA STEP PLATE SUPPORT ANGLES. (MARKED) (C-CHECK RO 11/30/2025)REMOVED & REPLACED 03 EA. STEP PLATE SUPPORT ANGLES PN: SH670-31982-1 AT SERVICE DOOR SURROUND REF CRJ700 SRM 51-42-06-001-001-A01.COMPLIED WITH 51-900-1002SDR SWIA202512010921Angle · corrodedGALLEY SERVICE DOOR SURROUND HAS CORROSION ON THE KICK ANGLE. (MARKED) (C-CHECK RO 11/30/2025)REPLACED GALLEY SERVICE DOOR LOWER KICK ANGLE AND MOUNTING ANGLE REF DWG SH670-31950 REV Y, CRJ700 SRM 51-42-06-001-001-A01, REV 38, JUL 25/2020, CRJ-700 SRM 51-42-SDR AALA202511134613Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT RIGHT PASSENGER, CREW DOOR CUTOUT LOWER SILL BETWEEN FR 66 AND FR 68 AT S23R. REPLACED SILL PER SRM 51-42-11.SDR AALA202511073567Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION INTERNAL STRUCTURE LOWER CORNER FITTING FR66 RH SIDE IN PASSENGER CABIN MEASURE CORROSION ARE L=1.43 INCH W=1.22 INCH D=0.002 INCH. MAINTENANCE REPLACED CORNER FITTING LOC ON INTERNAL STRUCTURE LOWER FR66 RH AT LEVEL STRSDR SWAA2025103016913Rib · crackedDURING INSPECTION FOUND CRACK AT NR 4 RIB STA 120.30 STIFFENER NR 2. REPAIRED IAW SRM 55-10-09-2R-5.SDR BAGA2025092300003Skin · damagedPREVIOUS SUBMISSION UPDATED WITH CORRECTIVE ACTION ---VERY LOUD BAND SOUND HEARD DURING CLIMB. UPON LANDING, FOUND EVIDENCE OF LARGE BIRD STIKE OVER FLIGHT DECK AREA. TEMP DOUBLER REPAIR TO BIRD STRIKE DAMAGE ON THE FUSELAGE CANOPY SKIN BETWEEN THE LT WINDSHIESDR SWAA2025102416886Floor Panel · pulledPASSENGER CABIN FLOOR PANEL#241AF HAS EXPOSED SURFACE FIBERS. REMOVED AND REPLACED PASSENGER CABIN FLOOR PANEL# 241AF PER AMM 53-21-00.;[02] C/W INSPECTION.SDR SWAA2025102416895Floor Panel · pulledPASSENGER CABIN FLOOR PANEL#231XF HAS EXPOSED SURFACE FIBERS.<[01] REMOVED AND REPLACED PASSENGER CABIN FLOOR PANEL# 231XF PER AMM 53-21-00.;[02] C/W INSPECTION.SDR IPXA2025101660290Support Frame · crackedFAULT-STR-#1 PYLON-ZONE400: NO.1 PYLON PANEL 413BL FWD SUPPORT FRAME CRACKED. REMOVE SUPPORT FRAME PYLON N.1 PANEL 413BL -ZONE400 IAW A300-600 SRM 51-40-21. ++INSTALLED FRAME SUPPORT WITH THE SAME FASTENER AT -#1 PYLON-ZONE400: NO.1 PYLON PANEL 413BL FWD SDR IPXA2025101660368Support Frame · crackedNR 1 PYLON PANEL 413BL AFT SUPPORT FRAME LH SIDE END WORN THRU. REMOVED AFT SUPPORT FRAME LH SIDE #1 PYLON-ZONE400 IAW SRM 51-40-21. INSTALLED FRAME SUPPORT WITH THE SAME FASTENER AT #1 PYLON-ZONE400: NO.1 PYLON PANEL 413BL AFT IAW A300-600 SRM 51-40-21.SDR GTIA2025101439130Panel · corrodedCORROSION UPPER SURFACE LOC. BTW RIB 5 TO RIB 6 REAR SPAR AREA ON RH WING RAF 3525563-02 GENERATED -PERFORMED PERMANENT REPAIR UPPER SURFACE LOC. BTW RIB 6 REAR SPAR AREA ON RH WING I.A.W EA #57-0095-25. THIS REPAIR IS CATEGORY A AND NOT REQUIRED FUTURE INSPECSDR GTIA2025101439129Panel · corrodedCORROSION UPPER SURFACE LOC. BTW RIB 4 TO RIB 6 REAR SPAR AREA ON LH WING RAF 3525563-01 CREATED SEE APPENDIX 3525563-01-PERFORMED PERMANENT REPAIR LOC. ON UPPER SURFACE BTW RIB 4 TO RIB 6 REAR SPAR AREA ON LH WING I.A.W EA # 57-0097-25. THIS REPAIR IS CATEGORSDR GTIA2025101439128Panel · corrodedCORROSION UPPER SURFACE LOC. BTW RIB 4 TO RIB 5 REAR SPAR AREA ON RH WING RAF-01 3525564-01 GENERATED -PERFORMED PERMANENT REPAIR UPPER SURFACE LOC. BTW RIB 4 TO RIB 5 REAR SPAR AREA ON RH WING I.A.W EA #57-0095-25. THIS REPAIR IS CATEGORY A. AND NOT REQUIRED SDR GTIA2025F00008Panel · corrodedCORROSION UPPER SURFACE LOC. BTW RIB 4 TO RIB 6 REAR SPAR AREA ON LH WING RAF 3525563-01 CREATED SEE APPENDIX 3525563-01-PERFORMED PERMANENT REPAIR LOC. ON UPPER SURFACE BTW RIB 4 TO RIB 6 REAR SPAR AREA ON LH WING I.A.W EA # 57-0097-25. THIS REPAIR IS CATEGORSDR GTIA2025F00007Panel · corrodedCORROSION UPPER SURFACE LOC. BTW RIB 4 TO RIB 5 REAR SPAR AREA ON RH WING RAF-01 3525564-01 GENERATED -PERFORMED PERMANENT REPAIR UPPER SURFACE LOC. BTW RIB 4 TO RIB 5 REAR SPAR AREA ON RH WING I.A.W EA #57-0095-25. THIS REPAIR IS CATEGORY A. AND NOT REQUIRED SDR REXA2025101400947Rib · crackedAFTER REMOVAL OF WING ACCESS PANEL 521BL AT LEFT WING TO PERFORM LUBRICATION OF SLAT TORQUE TUBES, CRACK ON MACHINED RIB LEADING EDGE SS57.16 AT LEFT WING MACHINED RIB LEADING EDGE SS57.16 AT LEFT WING WAS REPAIRED PER REO 690-57-41-549 REV.--SDR FDEA202509211943Profile · corrodedBULK CGO COMPT FLOOR BEAM PROFILE UPPER SKIN CORRODED AT FR66 - FR67, Y-805 POSITION. INSTALLED THE FABRICATION PROFILE WITH FASTENERS AT BULK CARGO COMPARTMENT FR66 - FR67, Y-805 IAW SRM 53-17-15-001, CONFIG-3, PAGE.80 AND 90, FIG.8(SHEET-1) & 51-41-21-001,SDR FDEA202509211942Profile · corrodedBULK CARGO COMPT FLOORBEAM PROFILE UPPER SKIN CORRODED AT FR67 - FR68, Y46.7 POSITION. INSTALLED FABRICATION PROFILE WITH FASTENERS AT BULK CARGO COMPARTMENT FR67 - FR68, Y46.7 IAW SRM 53-17-15-001, CONFIG-3, PAGE.80 & 90, FIG.8(SHEET-1) & 51-41-21-001, PARASDR FDEA202509211939Profile · corrodedBULK CARGO COMPT FLOORBEAM PROFILE UPPER SKIN CORRODED AT FR67 - 68, Y625 POSITION. INSTALLED THE FABRICATION PROFILE WITH FASTENERS AT BULK CARGO COMPARTMENT FR 67 - 68, Y625 IAW SRM 53-17-15-001, CONFIG-3, PAGE.82 AND 90, FIG.8 (SHEET-1), & 51-41-21-001, PARSDR ASAA2025092161462Plate · corrodedAFT CARGO L/H SIDEPLATE HAS MULTIPLE AREAS OF CORROSION BETWEEN STA 727+4 TO STA 767. GROUNDED - YES. REMOVED CORR, FOUND TO BE OUT OF LIMITS REPAIRED SIDEPLATE IAW B737-700 SRM 53-00-53-2R-5W= 1.25 O= .040 R= .000 L= 3.75 D= .040.SDR ASAA2025092161329Plate · corrodedFWD CARGO RT SIDEPLATE HAS MULTIPLE AREAS OF CORROSION BETWEEN STA 500 AND STA 500D. GROUNDED - YES. REMOVED CORROSION, FOUND TO BE OUT OF LIMTIS IAW B737-700 SRM 53-00-53-1A-2. REPAIRED SIDE PLATE IAW B737-700 SRM 53-30-53-01-2 AND SRM 51-40-02-0G-0 W= 1.25 OSDR SWAA2025100216838Battery Pack · failedBATTERY PACKS M1670 AND M1672 FAIL TO LIGHT.SDR SWAA2025100220548Battery Pack · failedBATTERY PACKS M1670 AND M1672 FAIL TO LIGHT.SDR SWAA2025100216902Latch · damagedFSD SLIDE COVER ASSY CLOSE-OUT LATCH (BLOCK ASSY) DAMAGED WILL NOT RE-ENGAGE. REMOVED AND REPLACED WITH NEW FSD SLIDE COVER ASSY CLOSE-OUT LATCH (BLOCK ASSY) IAW AIPC 25-66-00-14 AND SOPM 20-50-01.SDR AALA202509303499Lens · crackedAIRCRAFT IN BASE MAINTENANCE: G7 EMERGENCY PROXIMITY LIGHTS LENS ARE CRACKED. REMOVED, REPLACED, AND PERFORMED SATISFACTORY INSTALLATION TEST OF THE G7 FLOOR PROXIMITY LIGHT. PER 737-NG AMM 33-51-14.SDR SWIA2025F01394Cover · crackedPOST REMOVAL - FWD PAX DOOR SLIDE COMPOSITE CRACKED AT UPPER MOUNTING BOLT (C-CHECK RO 09/28/2025)REPLACED FWD PAX DOOR SLIDE. REF CP 30842860 FOR FINAL INSTALLATION.SDR SWIA2025092900021Thermocouple · faultedBRAKE OVHT WARNING IN FLIGHT FL37 DESCENDED RAN QRH MESSAGE CLEARED. MEL 32-46-1DCAT C. BRAKE OVHT WARNING IN FL37 DESCENDED RAN QRH MESSAGE CLEARED (FLIGHT 4820) UPON ARRIVAL TO ACFT PERFORMED MAIN WHEEL OVERHEAT - INSPECTION/CHECK IAW AMM 05-51-09. NOSDR AALA202509291004Bottle · low pressureAIRCRAFT IN BASE MAINTENANCE: R3 EMERGENCY DOOR PRESSURE IS LOW. MAINTENANCE SERVICED R3 EMERGENCY DOOR DAMPER IAW AMM 52-22-00-614-002-A.SDR ASMF2025092700255Controller · inoperativeUPON FLIGHT DECK ARRIVAL STATUS MSG DISPLAYED: PASSENGER ADDRESS AND CABIN INTERPHONE / CSC CONTROLLER INOPERATIVESDR SWIA2025092600021Slide · out of limitsFWD SERVICE DOOR (RH) EMERGENCY EVACUATION SLIDE SYSTEM CYLINDER PRESSURE GAUGE INDICATOR IS IN THE RED. (FILED CLOSED)REMOVED AND REPLACED FWD SERVICE DOOR (RH) EMERGENCY EVACUATION SLIDE ASSEMBLY IN REFERENCE TO ERJ 175 AMM 25-65-01.SDR SWAA2025092616871Scuff Plate · corrodedCORROSION ON CORNER PLATE (2EA) OF THRESHOLD SCUFF PLATE AT AFT CARGO COMPARTMENT. REPLACED CORNER PLATE (2EA) OF THRESHOLD SCUFF PLATE AT AFT CARGO COMPARTMENT IAW B737-700 SRM 51-10-02; ITEM 9 AND DWG 453A2611; SHEET 1; REV C.SDR AALA202509264664Bottle · low pressureAIRCRAFT IN BASE MAINTENANCE, L1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR CALA2025092609286Light · no discrepancyEMERGENCY EXIT LIGHT INOPERATIVE AT 20DEF. EMERGENCY SIGN AT 20DEF WORKS. PERFORMED EMERGENCY LIGHT TEST, VERIFIED 200DEF OVERWING HATCH HANDLE LIGHT WORKS NORMAL. OPS CHECKS OK MEL REMOVED.SDR AALA202509254327Oil System · leakingAIRCRAFT WAS GROUNDED: THIS APU IS LEAKING OIL INTO THE DUCTS AND CAUSED AN SOMKE ODORFUMES EVENT. MAINTENANCE REPLACED THE APU.SDR SWAA2025092516864Flashlight · no testREAR FLASHLIGHTS WILL NOT TEST. OK TO CONTINUE PER MEL 25-64-02A. PERFORMED FLASHLIGHTS OP CHECK. OP CHECKED GOOD PER AMM 25-64-00.