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 JR2R20250713761Frame · corrodedRIGHT HAND FLOOR BEAM AT FRAME 14 BETWEEN RBL10 AND RBL 48 IS CORRODED OUT OF LIMITS. REPAIRED.SDR MASA2025071300057Light · inoperativeEMER CEILING LIGHT 2, 3, AND 4 INOP.SDR SWI2025F01805Slider · chafedRIGHT TRANSCOWL LOWER OTBD SLIDER IS CHAFED. RECEIVED AND COMPLIED WITH ALL STEPS OF REO 670-54-21-1751 REV -.SDR SWI2025F01804Slider · chafedRIGHT TRANSCOWL UPPER INBD SLIDER IS CHAFED. RECEIVED AND COMPLIED WITH ALL STEPS OF REO 670-54-21-1750 REV -.SDR SWI2025F01803Slider · chafedRIGHT TRANSCOWL LOWER INBD SLIDER IS CHAFED. RECEIVED AND COMPLIED WITH ALL STEPS OF REO 670-54-21-1751 REV -.SDR SWI2025F01802Slider · chafedRIGHT TRANSCOWL UPPER OB SLIDER IS CHAFED. RECEIVED AND COMPLIED WITH ALL STEPS OF REO 670-54-21-1750 REV -.SDR SWI2025F01801Slider · chafedLEFT TRANSCOWL LOWER OTBD SLIDER IS CHAFED. RECEIVED AND COMPLIED WITH ALL STEPS OF REO 670-54-21-1749 REV -.SDR SWIA202512090712Slider · chafedLEFT TRANSCOWL LOWER IB SLIDER IS CHAFED. RECEIVED AND COMPLIED WITH ALL STEPS OF REO 670-54-21-1749 REV -.SDR SWI2025F01492Hinge · gougedR/H O/B FLAP HAS A GOUGE ON THE HINGE ASSEMBLY BELOW THE HINGE APEX AT WS178.00 (MARKED). (S/N#00633) (C-CHECK RO 11/01/2025)REPAIRED R/H O/B FLAP HINGE ASSEMBLY BELOW THE HINGE APEX AT WS178.00 PER REO 690-57-53-181 REV-- DATED: 2025-07-23 STEPS 1 - 4 ( SESDR SWI2025F01491Frame · corrodedCORROSION FOUND ON FRAME 597 BETWEEN STRINGERS 18L AND 19L. (S/N#00610) (C-CHECK RO 11/01/2025)REPLACED FRAME 597 BETWEEN STRINGERS 18L AND 19L REF DWG SH690-33750 REV. AF AND CRJ900 SRM 51-42-06-001-001-A01, AND CRJ900 SRM 51-42-21-001-001-A01. LEAK CHECK GOSDR SWI2025F01490Frame · corrodedCORROSION FOUND ON FRAME 533 BETWEEN STRINGERS 17L AND 18L. (S/N#00608) (C-CHECK RO 11/01/2025)REPAIRED FRAME 533 BETWEEN STRINGERS 17L AND 18L REF REO 690-53-31-1044 REV -- DATED 2025-07-30 COMPLIED WITH 51-900-1002-SKYSDR SWI2025F01489Stringer · corrodedCORROSION FOUND ON STRINGER 18R BETWEEN FS517 AND 533. (S/N#00600) (C-CHECK RO 11/01/2025)REPAIRED STRINGER 18R BETWEEN FS477 AND FS606 REF CRJ900 SRM 51-42-06-001-001-A01, DWG SH690-33101 REV. M, AND DWG SH670-30006 REV. A. LEAK CHECK GOOD. COMPLIED WITH TASSDR SWI2025F01488Skin · gougedR/H O/B FLAP HAS A GOUGE ON THE HINGE ASSEMBLY BELOW THE HINGE APEX AT WS220.00 (MARKED). (S/N#00634) (C-CHECK RO 11/01/2025)REMOVED DAMAGE ON R/H OUTBOARD HINGE ASSY BELOW HINGE APPROX. WS220.00 REF CRJ-900 SRM 51-12-00-001-001-A01 AND PERFORMED REPAIRS PERSDR SWI2025F01487Frame · corrodedCORROSION FOUND ON FRAME 645 BETWEEN STRINGERS 17L AND 18L. (S/N#00612) (C-CHECK RO 11/01/2025)REPLACED FRAME 645 BETWEEN STGRS 18L AND 14L REF CRJ900 SRM 53-00-06-201-001-A03, AND DWG SH690-33100 REV. N. LEAK CHECK GOOD. COMPLETED SKYWEST TASK CARD 51-900-1SDR SWI2025F01486Skin · chafedL/H AILERON HAS SIGNS OF CHAFFING ACROSS THE UPPER LEADING EDGE. (S/N#00627) (C-CHECK RO 11/01/2025)REMOVED AND REPLACED L/H AILERON UPPER LEADING EDGE REF CRJ900 SRM TASK 51-23-00-001-001-A01 , SRM TASK 51-42-21-001-001-A01 & SRM TASK 51-42-06-001-001-A01 SDR SWIA202511030712Frame · corrodedCORROSION FOUND ON FRAME 613 BETWEEN STRINGERS 17L AND 18L. (S/N#00611) (C-CHECK RO 11/01/2025)REPAIRED FRAME 613 BETWEEN STGRS 18L TO 14L REF CRJ900 SM 53-00-06-201-001-A01 AND DWG SH690-33100 REV. N. LEAK CHECK GOOD. COMPLETED 51-900-1002-SKY.SDR AALA202509095512Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INDICATION FOUND ON CONTINUITY FITTING OF WINDSHIELD LOWER ATTACHMENT AREA RH INTERNAL SIDE. CRACK L= 0.200 INCH. MAINTENANCE REPLACEMENT OF CONTINUITY FITTING RHS LOC. AT Y0 FR2 SEE EO 5319Y017-002 MT80.SDR IPXA2025082790569Door · damagedCREW DOOR AT MIDDLE TO LOWER SIDE HAS AFT EDGE DAMAGE. BLENDED AREA ON CREW DOOR AT MIDDLE TO LOWER SIDE HAS AFT EDGE IAW A300-600 SRM 51-73-10, ORIGINAL THICKNESS IS 0.098" MAXIMUM LOSS OF MATERIAL 0.003" AND THE MAXIMUM PERMIT REWORKED IS 0.009" THEREFORE ISDR IPXA2025082790470Lock · gougedCREW DOOR, AFT EDGE, LOCK CRANK LINK HAS GOUGE. BLENDED LOCK CRANK LINK ON CREW DOOR AFT EDGE IAW A300-600 SRM 51-73-10, NOMINAL THICKNESS IS 1" MATERIAL LOSS IS 0.050", REMAINING THICKNES 0.950", THE MAXIMUM PERMIT REWORK IS 0.050" THEREFORE IS WITHIN LIMITS SDR IPXA2025082790326Retainer · gougedCREW DOOR, AFT EDGE, LOWER SIDE, SEAL RETAINERS (2EA) HAVE GOUGE. THIS JOB WAS PERFORMED WITH TASK CARD T3F18E00714QS.SDR IPXA2025082790080Door Frame · gougedFUSELAGE, CREW DOOR CUT-OUT, FWD EDGE, LOWER SIDE, ROLLER GUIDE HAS GOUGE. DOT 103-09 (ATTACHED PHOTOS) REMOVED MINOR GOUGE AT FUSELAGE, CREW DOOR ROLLER GUIDE IAW A300-600 SRM 51-73-10 AND ORIGINAL THICKNESS 0.115" AND MATERIAL LOSS IS 0.008" REMAINING THICKSDR SWAA2025082290835Floorbeam · crackedCRACK BREAK PANEL ASSY LOCATED BS540 BETWEEN BL 0 T0 LBL 24.75 AT PASSENGER CABIN 2025-447949<[01] REPLACED BREAK PANEL ASSY LOCATED BS540 BETWEEN BL 0 T0 LBL 24.75 AT PASSENGER CABIN IAW B737-700 SRM 51-10-02-0G ITEM 9; SRM 51-40-02-0G AND DWG: 143A0060; SHEESDR SWAA2025082290832Floor Support · crackedCRACK ANGLE FLOOR STRUCTURE STA 695 AND RBL 24.75 AT PASSENGER CABIN 2025-447948<[01] REPLACED ANGLE FLOOR STRUCTURE STA 695 AND RBL 24.75 AT PASSENGER CABIN I.A.W B737-700 SRM 51-40-02-0G-0; B737-700 SRM 51-10-02-0G-0 AND DWG 273A9110 SHEET: 6 REV: A.<BR>SEE SDR SWAA2025082290836Floorbeam · crackedCRACK BREAK PANEL ASSY LOCATED BS 540 BETWEEN BL 0 TO RBL 24.75 AT PASSENGER CABIN 2025-447947<[01] REPLACED BREAK PANEL ASSY LOCATED BS 540 BETWEEN BL 0 TO RBL 24.75 AT PASSENGER CABIN IAW B737-700 SRM 51-10-02-0G; SRM 51-40-02-0G AND DWG: 143A0060; SHEET: 46SDR SWAA2025082190733Floor Panel · damagedELONGATED HOLES ON FLOOR PANEL 140BF IN AFT CARGO COMPARTMENT. REPLACED THE FLOOR PANEL 140BF IAW SRM 51-10-02-0G-0, ITEM 9, AND SRM 51-40-05, DWG 453A2610, SHEET 20, REV E.SDR SWAA2025082190734Floor Panel · abnormalELONGATED HOLES ON FLOOR PANEL 140AF IN AFT CARGO BAY. REPLACED THE FLOOR PANEL 140AF IAW SRM 51-10-02-0G-0, ITEM 9, AND SRM 51-40-05, DWG 453A2610, SHEET 22, REV B .SDR SWAA2025081590853Angle · crackedCRACKED ANGLE AT BS 380 - 400 RBL 11 WL 208<[01] REMOVED; REPLACED; AND INSTALLED A NEW ANGLE AT BS 380-400; RBL11; WL 208 IAW SRM 51-40-02 AND BOEING DWG 143A5400 SH 105 REV:-;[02] STEP 1 COMPLETED.SDR CALA2025081407748Frame · crackedCABIN FRAME CRACKED AT BS 312 ABOVE L1 DOOR FWD CORNER. REPAIRED FRAME AT MAIN CABIN STA 312 ABOVE L1 DOOR FWD CORNER IAW SRM 53-10-07-2R-1 & SRM 51-40-02-0G-0. CATEGORY "B" REPAIR.SDR ASAA2025071260012Skin · corrodedMULTIPLE AREAS OF SURFACE CORROSION ON EXT SKIN AROUND VAC WASTE EXHAUST PORT. GROUNDED - YES. REMOVED CORROSION FOUND TO BE OUT OF LIMITS, REPAIRED IAW E.A. 800-53EA-29104. W= 2" O= .125 R= .104 L= 2" D= .021.SDR IPXA2025080596626Shear Tie · crackedRIGHT WING, REAR SPAR, BY RIB 10, SKIN SUPPORT IS CRACKED. REMOVED SKIN SUPPORT IAW IAW SRM 51-40-21. FABRICATED NEW SKIN SUPPORT AT RT WING IAW GMM 09-08-01-04, LOCATED AND DRILLED NEW SKIN SUPPORT FOR RT WING REAR SPAR IAW SRM 51-40-21. INSTALLED IAW SRMSDR AALA202508059173Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: PER CPCP 53-050-00 AT AFT BULKHEAD BS 727 IN BETWEEN LBL 15 - RBL15 LOWER ANGLES CORRODED. REMOVED THE CORROSION FROM LOWER ANGLE. PER B737NG SRM 53-60-71-1A. SRM 51-20-01, AMM 51-21-73.SDR SWAA2025072490748Handle · looseCR RR R1 DOOR ASSIST HANDLE NEEDS SECURED. SECURED R1 DOOR ASSIST HANDLE IAW AMM 52-41-31;[02] SECURED R1 DOOR ASSIST HANDLE IAW AMM 52-41-31SDR SWAA2025072490747Lamp · inoperativeLEFT AFT OVERWING DOOR EXIT EMERGENCY LIGHT JUST AFT OF THE DOOR HALF. REPLACED THE LAMP AND OP CHECKED THE SIGN IAW AMM 33-51-01-960-801. EXIT SIGN OP CHECKS GOOD.SDR SWAA2025072490742Handle · looseL1 DOOR ASSIST HANDLE UNSECURE. SECURED L1 DOOR ASSIST HANDLE IAW AMM 52-11-31.SDR AALA202507243654Attach Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND ELEVATOR TAB CONTROL MECHANISM SPRING ATTACH POINTS LOWER HARDWAR EHAVE EVIDENCE OF CORROSION. REMOVED AND REPLACED AFT RIGHT HAND ELEVATOR TAB CONTROL MECHANISM RETURN SPRINGS LOWER ATTACHING POINT BUSHING, PERFORMED SSDR AALA202507247140Attach Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND ELEVATOR TAB CONTROL MECHNISM RETURN SPRINGS LOWER ATTACHING POINTS HAS EVIDENCE OF CORROSION. REMOVED AND REPLACED AFT LEFT HAND ELEVATOR TAB CONTROL MECHANISM RETURN SPRINGS LOWER ATTACHING POINT BUSHING, PERFORMED SATSDR IPXA2025071398635Heat Exchanger · inoperativeDURING CLIMB LEFT ENG OIL TEMP IN AMBER BAND. QRH PROCEDURE WITH THROTTLE ALMOST IDLE LOWERED TEMP TO NORMAL RANGE. COMPLETED K ALERT ON BAR CODE T3F18E0071FDT. PERFORMED HIGH POWER ENG RUN RFEF 757 M/M 71-00-00- 501. LEFT ENG OIL TEMP CHKED WITHIN LIMITS.SDR 2025FA0000511Pump · damagedAIRCRAFT WAS FLYING AN EXTERNAL LOAD OPERATION WHEN THE PILOT NOTICED THE RED LOW HYDRAULIC WARNING IND LIGHT WAS ILLUMINATED. THE PILOT WAS ABLE TO SAFELY SET LOAD ON THE GROUND AND LAND BACK AT THE HELI-PAD. UPON VISUAL INSPECTION OF THE HYDRAULIC PUMP , THESDR ASAA2025071259470Battery · inoperativeEMERGENCY LIGHT BATTERY M1675 INOP. GROUNDED - YES. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY M1675 IAW B737 AMM 33-51-06-960-806. (S/N 82958)SDR ASAA2025071259469Power Supply · inoperativeEMERGENCY LIGHT BATTERY M1676 INOP. GROUNDED - YES. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY M1676 IAW B737 AMM 33-51-06-960-806. (S/N 129042)SDR DALA2025071705372Unknown · odorPRIOR TOD AT FL 340 STRONG SMELL OF BURNING ELECTRICAL. THE SMELL DISSIPATED 5 MINUTES LATER. OXYGEN MASKS WERE DEPLOYED IN THE COCKPIT. REF LP#: 1077551 FOR T/S & ODI COMPLETION. T/S PER A220 EFIM. FOUND ALL (5) AFDS DIRTY & CAKED W/ DUST. CLEANED PER AMP 31-SDR CALA2025071706656Battery Pack · dischargedEMERGENCY CABIN LIGHTS M1670 FAILS BATTERY CAPACITY CHECK. REPLACED BATTERY PACK M1670 IAW B737 AMM 33-51-06-960-805. OPS CHECK GOOD. BATTERY PACK FAILED FUNCTIONAL CHECK DURING D CHECK IN RFD.SDR SWAA2025071690761Apu · trippedJUST PRIOR TO BRAKE RELEASE; APU TRIPPED OFFLINE AND GOT A STRONG ACIDIC SMELL IN THE FLT DECK AND THROUGHOUT THE ENTIRE AIRCRAFT. OK TO CONTINUE 49-11-01 SP 1 AND SP 2. P6-4 APU CONT COLLARD P6-5 INLET DOOR COLLARD. APU OPS CHECKS OK. NO HISTORY. RAN APU SDR SWAA2025071690900Light · malfunctionedCREW REPORTS RH FWD OVERWING SIDEWALL EXIT LIGHT FLICKERING. OK TO CONTINUE PER MEL 33-21-01A SP # 1B. OPS CHECK GOOD PER AMM 33-51-00.SDR AJXA2025071600032Gcu · unserviceableDURING FLIGHT AT FL450 AIRCRAFT LOST POWER ON EICAS DISPLAY UNITS, 1 ,2, AND 3 CAUSED DUE TO A POWER LOSS ON THE NR 1 POWER BUSS. THE LOSS OF ONE THE NR 1 BUSS WAS CAUSED BY A FAILED GENERATOR CONTROL UNIT. THE LOSS OF POWER ON THE NUMBER ONE BUS ALSO CAUSED TSDR HALA20250715215Valve · faultedETOPS - FUEL ENG 2 LP VALVE FAULT. REMOVED & REPLACED LP FUEL VALVE ACTUATOR IAW A330 AMM 28-24-51-000/400-803-A. PERFOMED OPS CHECK IAW A330 AMM 28-24-00-710-803-A, OPS CHECK GOOD, FAULT CLEARED.SDR AALA202507169729Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR RUBBING ON BOTTOM FLOOR METAL TRIM. DOOR HARD TO OPEN AND CLOSE. ADJUSTED FORWARD LAVATORY DOOR. PER AMM 70-51-00.SDR AALA202507163141Bracket · bentAIRCRAFT WAS NOT GROUNDED: R1 DOOR GIRT BAR BRACKET BENT. REPOSITIONED R2 GIRT BAR BRAKET. OPERATIONAL CHECK NORMAL.SDR AALA202507161320Sign · missingAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTANDENT REPORT EMERGENCY EXIT COVER FOR LIGHTS MISSING BY THE FORWARD SERVICE DOOR. REMOVED AND REPLACED EMERGENCY LIGHT AND LENSE. PER AMM 33-51-01.OPERATIONAL CHECK GOOD.SDR VNAA20250716004Lug · corrodedCORROSION ON LUGS L1 AND L6 AT LH AILERON. LUGS WERE REPAIRED PER REO 670-57-61-237 REV. - -