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.

SDR REXA2026052800845Drag Angle · crackedINITIAL INSPECTION: CRACK ON LEFT VERTICAL STABILIZER TO FUSELAGE ATACHMENT AFT DRAG ANGLE BTW 55.625% STGR DATUM TO 67.5% REAR SPAR DATUM (TRACE AT BL 0.00). CRACK ON LEFT VERTICAL STABILIZER TO FUSELAGE ATACHMENT AFT DRAG ANGLE BTW 55.625% STGR DATUM TO 67.5Sep 19, 2025 · N605LR · Cndair CL6002D24 · Fuselage, Stabilizer Attach FittingsSDR REXA2026052800844Angle · corrodedCORROSION ON WEB FLOOR PROTECTOR THEIR ANGLES (8 EAS) AT SERVICE DOOR SURROUND STRUCTURE BTW FS 319.70 TO FS 349.00. CORROSION ON WEB FLOOR PROTECTOR THEIR ANGLES (8 EAS) AT SERVICE DOOR SURROUND STRUCTURE BTW FS 319.70 TO FS 349.00. WAS REMOVED PER CRJ900 SRSep 19, 2025 · N605LR · Cndair CL6002D24 · Fuselage Miscellaneous StructureSDR REXA2026052800843Angle · corrodedCORROSION ON FWD, MID AND AFT ANGLE CAP (3 EAS) AT PASSENGER DOOR SURROUND STRUCTURE BTW FS 310.00 TO FS 349.00 OVER STGR 18L. DUE TO EXCESSIVE CORROSION ON MID AND AFT ANGLE CAP WERE EVALUATED OUT LIMITS THEREFORE WERE REPLACED PER CRJ-900 SRM 51-21-06-001-00Sep 19, 2025 · N605LR · Cndair CL6002D24 · Fuselage Miscellaneous StructureSDR REXA2026052800842Angle · corrodedCORROSION ON FWD, MID AND AFT ANGLE CAP (3 EAS) AT PASSENGER DOOR SURROUND STRUCTURE BTW FS 310.00 TO FS 349.00 OVER STGR 18L. DUE TO EXCESSIVE CORROSION ON MID AND AFT ANGLE CAP WERE EVALUATED OUT LIMITS THEREFORE WERE REPLACED PER CRJ-900 SRM 51-21-06-001-00Sep 19, 2025 · N605LR · Cndair CL6002D24 · Fuselage Miscellaneous StructureSDR REXA2026052800840Drag Angle · crackedINITIAL INSPECTION: CRACK ON RIGHT VERTICAL STABILIZER TO FUSELAGE ATACHMENT AFT DRAG ANGLE BTW 55.625% STGR DATUM TO 67.5% REAR SPAR DATUM (TRACE AT BL 0.00) CRACK ON RIGHT VERTICAL STABILIZER TO FUSELAGE ATACHMENT AFT DRAG ANGLE BTW 55.625% STGR DATUM TO 67Sep 19, 2025 · N605LR · Cndair CL6002D24 · Fuselage, Stabilizer Attach FittingsSDR SWIA2026030975437Floor Support · corrodedCORROSION AT LONGITUDINAL FLOOR SUPPORT LBL9.00 BTW FS1015.00 TO FS1051.31 UPPER SURFACE. REMOVED DAMAGED SECTION AND REPAIRED FLOOR BEAM AT STA 1031 LBL 9 IN REF TO CRJ900 SRM 51-25-16-001-001-A01, 53-00-41-201-001-A03 FIG. 53-00-41-995-829 , AND REO 690-Sep 19, 2025 · N245LR · Cndair CL6002D24 · Fuselage Miscellaneous StructureSDR SWIA2026030975435Floor Support · corrodedCORROSION AT LONGITUDINAL FLOOR SUPPORT LBL 27.00 BTW FS1000.00 TO FS 1051.30. REMOVED DAMAGED LONGITUDINAL FLOOR SUPPORT BS 1025-1037 AND REPAIRED IAW REO 690-53-61-1706 AND SRM 53-00-41-201-001-A01 FIG. 53-00-41-995-829. REMOVED AND REPLACED DAMAGED COMPSep 19, 2025 · N245LR · Cndair CL6002D24 · Fuselage Miscellaneous StructureSDR SWIA2025120800919Hinge Fitting · looseRUDDER CENTER HINGES BEARING (TOP & BOTTOM) ON VERTICAL STABILIZER SIDE HAS EXCESSIVE PLAY. INSTALLED NEW UPPER AND LOWER RUDDER CENTER HINGE FITTINGS P/N AV670-21081-015 AND (1EA) AND P/N AV670-21081-013 (1EA) PER DWG.AV670-21200 REV H AND REF.CRJ/700 SRM. Sep 19, 2025 · N633SK · Cndair CL6002C10 · Rudder Miscellaneous StructureSDR VNAA202511250002Access Panel · corrodedCORROSION ON SETTLEMENT AREA OF ACCESS PANEL: 642BZ. CORROSION ON SETTLEMENT AREA OF ACCESS PANEL: 642BZ WAS EVALUATED EXCESSIVE DAMAGE PER SRM 53-00-00-101-001-A01 AND REPLACED PER CRJ-700 SRM 51-42-21-001-001-A01.Sep 19, 2025 · N527EA · Cndair CL6002C10 · Wing, Plate/SkinSDR IPXA2025110744499Skin · damagedMAIN CARGO DOOR LOWER FORWARD SIDE OUTTER SKIN DIMPLE FROM MECHANICAL FAILURE OF PUSHROD. ACCOMPLISDED REPAIR I.A.W UPS EO-95155-REQ2 REV.1 AND EGAT EI NO.F2025A52M-2554 REV.2 REVIEWED TASK PER GMM-MTX 09.05.01.09.Sep 19, 2025 · N609UP · Boeing 7478F · Cargo/Baggage DoorsSDR 2025FA0000763Arm · brokenARM ASSEMBLY - CONNECTOR (PART NUMBER 6661-000) BROKE WHERE ASSEMBLY MATES WITH THE RUDDER PEDAL ASSEMBLY (PART NUMBER 63459-019) WHILE A FLIGHT INSTRUCTOR AND STUDENT PILOT WERE FIGHTING OVER PEDALS. ALTHOUGH THE PART FAILED BY FORCE A VISUAL INSPECTION OF TSep 19, 2025 · N3024M · Piper PA28181 · Rudder Control SystemSDR ASAA2025091962075Skin · corrodedAFT CARGO DOOR, INNER SKIN CORRODED AROUND BLANKET ATTACHMENT SNAPS AND BLIND FASTENERS ON LOWER EDGE OF THE DOOR MARKED WITH DOTS. GROUNDED - YES. UPON FURTHER EVALUATION INNER SKIN FOUND TO HAVE 100% MAT LOSS. REMOVED AND REPLACED INNER SKIN IAW B737-700 SRMSep 19, 2025 · N626AS · Boeing 737790 · Cargo/Baggage DoorsSDR SWAA2025103016496Stringer Clip · no discrepancyFUSELAGE STRINGER CLIP BS 706, S10L CRACKED. HFEC INSPECTED AREA IAW NDTM PART 6, 51-00-00, PROCEDURE 23. NO CRACKS NOTED.Sep 19, 2025 · N7862A · Boeing 73779P · Fuselage Main, Attach FittingsSDR SWAA2025103016497Stringer Clip · no discrepancyFUSELAGE STRINGER CLIP BS 727A S15L CRACKED. HFEC INSPECTED AREA IAW NDTM PART 6; 51-00-00, PROCEDURE 23. NO CRACKS NOTED.Sep 19, 2025 · N7862A · Boeing 73779P · Fuselage Main, Attach FittingsSDR SWAA2025102716473Skin · delaminatedLEFT HAND OUTBOARD AFT FLAP IS DELAMINATED AT AFT INBOARD CORNER. REMOVED AND REPLACED LT OTBD AFT FLAP PER AMM 27-51-22. RII INSPECTED LT OUTBOARD AFT FLAP PER AMM 27-51-22.Sep 19, 2025 · N8504G · Boeing 7378H4 · Trailing Edge FlapsSDR HNAA2025102100719Shear Tie · crackedF072027 FR 61 SHEAR CLIP AT STR 7L HAS POSSIBLE CRACK. RAR SHEAR CLIP ON FRAME 61 AT STR 7L IAW EMB-145 SRM 51-40-02.Sep 19, 2025 · N691AE · Emb EMB145LR · Fuselage Internal Mounting StructureSDR HNAA2025102100714Floor Support · corrodedF072225 LH FLOOR SILL #3 HAS CORROSION IN MULTIPLE AREAS. RAR LH FLOOR SILL #3 IAW EMB 145 SRM 51-40-02.Sep 19, 2025 · N691AE · Emb EMB145LR · Fuselage Miscellaneous StructureSDR HNAA2025102100713Seat Track · corrodedF072219 LH UPPER #2 SEAT TRACK HAS CORROSION IN MULTIPLE AREAS. RAR LH UPPER #2 SEAT TRACK IAW EMB 145 AMM 53-01-06.Sep 19, 2025 · N691AE · Emb EMB145LR · Fuselage, Seat/Cargo Attach FittingsSDR HNAA2025102100712Seat Track · corrodedF072070 CORROSION ON LH OTBD #1 SEAT TRACK. REMOVED AND REPLACED LH OTBD #1 SEAT TRACK IAW EMB 145 AMM 53-01-06.Sep 19, 2025 · N691AE · Emb EMB145LR · Fuselage, Seat/Cargo Attach FittingsSDR HNAA2025102100711Floor Support · corrodedF072008 LAV LH OTBD FLOOR SILL AFT END HAS 1 SPOT OF CORROSION. REMOVED & REPLACED LAV LH OTBD FLOOR SILL IAW EMB-145 SRM 51-40-02.Sep 19, 2025 · N691AE · Emb EMB145LR · Fuselage Miscellaneous StructureSDR HNAA2025102100710Door Sill · corrodedCORROSION ON CARGO DOOR CUT-OUT LOWER SILL. RAR CARGO DOOR CUT-OUT LOWER SILL IAW EMB 145 SRM 51-40-02.Sep 19, 2025 · N691AE · Emb EMB145LR · Fuselage Main, StructureSDR ASAA2025091961622Baffle · crackedFWD CARGO BAFFLE CLIP CRACKED FWD SIDE STA 500K RBL 30. GROUNDED - YES. REMOVED AND REPLACED BAFFLE CLIP IAW B737-900ER SRM 51-40-02-0G-0.Sep 19, 2025 · N434AS · Boeing 737990ER · Fuselage Miscellaneous StructureSDR AALA202510164181Fitting · wornAIRCRAFT IN BASE MAINTENANCE: AFT AVIONIC COMPARTMENT RACK 80VU LEFT HAND LATERAL FITTING WORN BETWEEN FR 23 AND FR 24 AT +Y1263. REPLACED LEFT HAND LATERAL FITTING PER EA 368345.Sep 19, 2025 · N581UW · Airbus A321231 · Fuselage Internal Mounting StructureSDR AALA202510166160Fitting · wornAIRCRAFT IN BASE MAINTENANCE: AFT AVIONIC COMPARTMENT RACK 80VU RIGHT HAND LATERAL FITTING WORN BETWEEN FR 23 AND FR 24 AT -Y1263. REPLACED RIGHT HAND LATERAL FITTING PER EA 368345.Sep 19, 2025 · N581UW · Airbus A321231 · Fuselage Main, Attach FittingsSDR HNAA2025100800686Shear Tie · crackedSHEAR CLIP CRACKED AT FR80 BTW STR5-7L. RAR SHEAR CLIP IAW SRM 51-40-02Sep 19, 2025 · N922AE · Emb EMB145LR · Fuselage Internal Mounting StructureSDR AALA202510075829Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN R1 DOOR SURROUND STRUCTURE ANGLE FROM BS 291.5 TO BS 315, AT RBL 58. REPLACED ANGLE PER SRM 53-10-15-2R-7.Sep 19, 2025 · N975AN · Boeing 737823 · Fuselage Miscellaneous StructureSDR AALA202510070373Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM BS 500B PLUS 11 INCHES TO BS 500I AT LBL 24. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.Sep 19, 2025 · N975AN · Boeing 737823 · Fuselage Miscellaneous StructureSDR AALA202510078752Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM BS 500B PLUS 11 INCHES TO BS 500I AT RBL 24. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.Sep 19, 2025 · N975AN · Boeing 737823 · Fuselage Miscellaneous StructureSDR ASAA2025091961320Transition Panel · corrodedAFT CARGO TRANSITION CORRODED STA 787 TO 727B RBL 30. GROUNDED - YES. REMOVED CORROSION TRANSITION FOUND TO BE OUT OF LIITS, REMVOED AND REPLACED TRANSITION IAW B7370900ER SRM 53-00-53-2R-5 W=1" O= .040 R= 0 L= 2" D= .040.Sep 19, 2025 · N434AS · Boeing 737990ER · Fuselage Main, StructureSDR ASAA2025091961319Rail · corrodedFWD CARGO AFT BULKHEAD LOWER SUPPORT CORRODED STA 500L RBL 30 TO LBL 30. GROUNDED - YES. REMOVED CORROSION ON LOWER RAIL FOUND TO BE OUT OF LIMITS, REMOVED AND REPLACED LOWER RAIL SUPPORT ON FWD CARGO AFT BULKHEAD AT STA 500L, RBL30 TO LBL 30 IAW B737-900ER SRSep 19, 2025 · N434AS · Boeing 737990ER · Fuselage Main, StructureSDR ASAA2025091961318Transition Panel · corrodedAFT CARGO TRANSITION CORRODED STA 787 TO 727B LBL 30. GROUNDED - YES. REMOVED CORROSION TRANSITION FOUND TO BE OUT OF LIMITS, REMOVED AND REPLACED TRANSTITION PANEL IAW B737-900ER SRM 53-00-53-2R-5W= 1" O= .040 L= 2" R= 0 D= .040.Sep 19, 2025 · N434AS · Boeing 737990ER · Fuselage Miscellaneous StructureSDR CALA2025100609635Spar · corrodedFOUND CORROSION ON RIGHT WING INBD OF REAR SPAR SKIN NEXT TO FUEL BOOST PUMP LOWER BONDONG CABLE. ACCOMPLISHED REPAIR ON RIGHT WING REAR SPAR WEB IN ACCORDANCE WITH AAR-MIA ESR-WI #2023803-44-12877 REV IR, AND UNITED EC/RA 5720-03566 REV.Sep 19, 2025 · N33284 · Boeing 737824 · Wing SparSDR AALA202510045947Floorbeam · delaminatedAIRCRAFT IN BASE MAINTENANCE: DELAMINATION TO PASSENGER CABIN FLOOR SUPPORT BREAK ASSEMBLY PANEL AT BS 540 FROM RBL 47 TO RBL 64. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-01.Sep 19, 2025 · N976AN · Boeing 737823 · Fuselage Main, Floor BeamSDR SIMA20250919002Floorbeam · corrodedAFT WET AREA FLOOR STRUCTURE BEAM FASTENERS CORRODED AT FR 86-87 Y-10" LEVEL 2 CORROSION BLENDED CORROSION AT AFT WET AREA FLOOR BEAM IAW EMB 175 SRM 51-10-03. BLEND MEASURES L=1.4" W=.6" H=.018" AND IS OUT OF LIMITS IAW EMB 175 SRM 53-23. LOCATED, DRILLED ANDSep 19, 2025 · N249NN · Emb ERJ170200LR · Fuselage Main, Floor BeamSDR CALA2025100309600Handle · gougedAFT CARGO DOOR EXTERNAL OPENING HANDLE INNER SURFACE GOUGED. AFT CARGO COMPARTMENT DOOR HANDLE HAD GOUGE THAT EXCEEDED MANUFACTURES LIMITS. REPAIRED PER EC/RA 5320-02296.Sep 19, 2025 · N14118 · Boeing 757224 · Cargo/Baggage DoorsSDR ASAA2025091961184Web · corrodedAFT CARGO SCUFF PLATE WEB CORRODED STA 847 TO 787 RBL 40. GROUNDED - YES. REMOVED CORROSION ON AFT CARGO DOOR SCUFF PLATE WEB AND FOUND TO BE OUT OF LIITS IAW B737-900ER SRM 53-60-15-1A-1 AND REMOVED AND REPLACED IAW B737-900ER SRM 51-40-02-0G-0 W= 2" O= .050"Sep 19, 2025 · N434AS · Boeing 737990ER · Fuselage Miscellaneous StructureSDR ASAA2025091961183Shield · corrodedAFT CARGO FWD SHEILD CORRODED STA 787 TO 767 RBL 30. GROUNDED - YES. REMOVED AND REPLACED AFT CARGO FWD SHIELD AT STA 787 TO 767 RBL 30 IAW BOEING 737-900ER SRM 51-40-02-0G-0. W= 1" O= .050" R= .041" L= 1" D= .009".Sep 19, 2025 · N434AS · Boeing 737990ER · Fuselage Miscellaneous StructureSDR SWAA2025093016392Filler · missingEGPR DOOR CUTOU REPAIR FILLER IS MISSING, REPLACED MISSING FILLER ON EXISTING EGPR SURROUND DOUBLER REPAIR IAW B737-800 SRM 53-10-15-2R-4.Sep 19, 2025 · N8660A · Boeing 7378H4 · Fuselage Main, StructureSDR SWAA2025093016460Flashlight · inoperativeAFT L/H WINDSCREEN UPPER FLASHLIGHT INOPERATIVE. REPLACED BATTERY OF UPPER FLASHLIGHT INOP IAW AMM 25-64-00-900-806.Sep 19, 2025 · N909WN · Boeing 7377H4 · Emergency EquipmentSDR SWAA2025093016091Power Supply · inoperativeFOUND EMERGENCY LIGHTS AT SEAT ROW LEFT 8 AND SEAT ROW LEFT 11 INOPERATIVE. INSTALLED POWER SUPPLY AND BATTERY PACK (M1670) AND PERFORMED GOOD OPS EMERGENCY LIGHT TEST IAW AMM 33-51-06-960-806.Sep 19, 2025 · N909WN · Boeing 7377H4 · Emergency LightingSDR SWAA2025093019791Battery Pack · inoperativeFOUND EMERGENCY LIGHTS AT SEAT ROW LEFT 8 AND SEAT ROW LEFT 11 INOPERATIVE. INSTALLED POWER SUPPLY AND BATTERY PACK (M1670) AND PERFORMED GOOD OPS EMERGENCY LIGHT TEST IAW AMM 33-51-06-960-806.Sep 19, 2025 · N909WN · Boeing 7377H4 · Emergency LightingSDR SWAA2025092916384Handle · looseL1 DOOR ASSIST HANDLE LOOSE AT DOOR FRAME AND LOWER DOOR LINER. SECURED L1 DOOR ASSIST HANDLES AT UPPER AND LOWER DOOR LINER IAW B737-800 AMM TASK 52-11-31.Sep 19, 2025 · N8660A · Boeing 7378H4 · Passenger/Crew DoorsSDR SWAA2025092916387Handle · looseR1 DOOR ASSIST HANDLE LOOSE FRAME SIDE. SECURED R1 DOOR ASSIST HANDLE IAW B737-800 AMM 52-41-31.Sep 19, 2025 · N8660A · Boeing 7378H4 · Service DoorsSDR SWAA2025092916389Handle · looseR2 DOOR ASSIST HANDLE LOOSE FRAME SIDE. SECURED R2 DOOR ASSIST HANDLE IAW B737-800 AMM TASK 52-13-31.Sep 19, 2025 · N8660A · Boeing 7378H4 · Service DoorsSDR IPXA202509254499Skin · damagedMAIN CARGO DOOR LOWER FORWARD SIDE OUTTER SKIN DIMPLE FROM MECHANICAL FAILURE OF PUSHROD. DEFERRED IAW EO-95155 FOR 24 MONTHS, REF T3F18E007GPAX FOR COMPLIANCE WITH TEMP REPAIR.Sep 19, 2025 · N609UP · Boeing 7478F · Cargo/Baggage DoorsSDR IPXA2025092442805Bracket · crackedLEFT PACK EXTERNAL SURFACE, AFT BRACKET HAS A CRACK. REMOVED AND REPLACED 1 EA AFT BRACKET IAW SRM 51-40-21.USED SAME FASTENERS REMOVED.VERIFIED NEW PART INSTALLED.JOB COMPLETESep 19, 2025 · N173UP · Airbus A300F4622R · Fuselage Main, Attach FittingsSDR JJBA20250929045Support · corrodedCFI, LH SILL BTW FR 18-24 FOUND CORRODED. AT CF1, LH SILL BTW FR 18-24 SILL FOUND CORRODED OUT OF LIMITS. SILL REMOVED AND NEW SILL INSTALLEDSep 19, 2025 · N16149 · Emb EMB145XR · Fuselage Miscellaneous StructureSDR FDEA202509191842Shear Plate · crackedMAIN DECK FLOOR SHEAR WEB CRACK APPROX 1" AT FR79 PLUS 5", Y1620. REPLACED CRACK SHEAR WEB WITH NEW ONE I.A.W A300-600F SRM 51-72-10-001, PAGE.2 AND 51- 40-21-001, PARA.6, PAGE.7B-23. THIS REPAIR CLSSSIFIED AS MINOR PER GMM 6-2-100. AT MAIN DECK FLOOR FR79Sep 19, 2025 · N690FE · Airbus A300F4605R · Fuselage Miscellaneous StructureSDR FDEA202509191841Shear Web · damagedMAIN DECK FLOOR SHEAR WEB BROKEN AT FR77 Y-1900 REPLACED BROKEN SHEAR WEB WITH NEW ONE I.A.W A300-600F SRM 51-72-10-001, PAGE.2 AND 51-40-21-001, PARA.6, PAGE.7B-23. THIS REPAIR CLASSIFIED AS MINOR PER GMM 6-2-100. AT MAINDECK FLOOR FR77 Y-1900 POSITION.Sep 19, 2025 · N690FE · Airbus A300F4605R · Fuselage Miscellaneous StructureSDR CALA2025092909364Skin · dentedAPU ACCESS DOOR 316AR EXTERNAL SURFCE I/B EDGE CTR AREA HAS A DAMAGE. REPAIRED RT APU ACCESS DOOR EXTERNAL SKIN BETWEEN STA 1900.342 T O STA 1907.696 BL 0 IAW EC/RA#5240-02158. RII CW ST NR LP 6333209.Sep 19, 2025 · N57868 · Boeing 75733N · Auxiliary Power Unit (APU) Doors