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 SWIA202512010925Stringer · corrodedSTRINGER 25R , BS 280 - 333 HAS CORROSION ON ATTACH FLANGE. REPLACED S25R, BS 280 - 333 IAW DWG SH670-31630, REV K. AND SRM 51-42-06-001-001-A01; SRM 51-42-21-001-001-A01. LEAK CHECKED GOOD.SDR AALA202511286704Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INTERNAL STRUCTURE FR68 UPPER CORNER LH SIDE MEASURE CRACK L : 0.388 INCH. MAINTENANCE PERFORMED PERMANENT REPAIR LOC ON INTERNAL STRUCTURE FR68 UPPER CORNER LH SIDE THIS REPAIR IS CATEGORY B IAW A320 SRM 53-41-12-300-012 SDR AALA202511289375Skin Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT WING TRAILING EDGE TOP SKIN PANEL LOWER SURFACE AT RIB 10. REPAIRED SKIN PANEL PER EA 369289.SDR VNAA202511270011Lug · corrodedTO PERFORM OVERSIZE BEARING INSTALLATON REWORK LH AILERON LUG L4 TO INSTALL BEARING P/N: KSC432409B-03. NEW BEARING (1EA) (LUG 4) PN:KSC432409B-03 AT AILERON LH WAS INSTALLED PER REO 670-57-61-457 REV -ASDR VNAA202511270007Lug · corrodedAFTER BEARINGS AND BUSHINGS REMOVAL IN REF. TASK CARD 271500-RH-PSA-AILERON, CORROSION AND SCRATCHES WAS FOUND ON CENTER FITING LUGS R1, R2, R5 AND R6. AT RH AILERON. CENTER FITING LUGS R1, R2, R5 AND R6. AT RT AILERON WERE REPAIRED IAW REO 670-57-61-237 REV SDR VNAA202511270006Lug · corrodedCORROSION AND SCRATCHES ON OUT FITTING AND CENTER FITING LUGS L1,L2, L5 AND L6. AT LH AILERON WAS FOUND. CENTER FITING LUGS L1,L2, L5 AND L6. WERE REPAIRED PER REO 670-57-61-237 REV. - - PAR F AND OUT FITTTING LUGS WERE CLEANED PER PER CRJ-700 SRM 51-26-00-00SDR VNAA202511270005Frame · corrodedCORROSION ON FRAME FS1015.00 BTW STGR 21LH TO STGR 24RH AT INTERNAL STRUCTURE AFT CARGO COMPARTMENT. CORROSION ON FRAME BS 1015.00 BTW STGR 21LH TO STGR 24RH AT INTERNAL STRUCTURE AFT CARGO COMPARTMENT WAS EVALUATED OUT LIMITS IAW SRM 53-61-06-101-001-A01 ANSDR VNAA202511270004Floorbeam · corrodedCORROSION ON FLOOR BEAM LBL 27 BTW FS 1000.00 TO FS 1069.00 AT FLOOR STRUCTURE AFT CARGO COMPARTMENT. CORROSION ON FLOOR BEAM LBL 27 BTW FS 1000.00 TO FS 1069.00 AT FLOOR STRUCTURE AFT CARGO COMPARTMENT WAS EVALUATED EXCESSIVE DAMAGE IAW SRM 53-61-43-101-001SDR VNAA202511270003Canister · crackedCRACK IN CANISTER WELDED NO.3, ON WS148.019 OF INTERNAL RH MAIN FUEL TANK. CANISTER WELDED NO.3, ON WS148.019 OF INTERNAL RH MAIN FUEL TANK WAS REPAIRED PER REO 670-57-42-577 REV. --SDR VNAA202511270002Seat Track · corrodedCORROSION ON SEAT RAIL RBL27.00 BTW FS977.00 TO FS1005.00 AT PASSENGER CABIN. DUE TO EXCESSIVE DAMAGE ON SEAT RAIL RBL27.00 BTW FS977.00 TO FS1005.00 AT PASSENGER CABIN WERE EVALUATED OUT OF LIMITS PER SRM 53-51-49-101-001-A01 AND WERE REPLACED PER CRJ700 AMMSDR AALA202511243952Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INTERNAL STRUCTURE FR68 UPPER CORNER RH SIDE AT AFT GALLEY AREA. CRACK. L=0.141 INCH. MAINTENANCE PERFORMED TIME LIMITED REPAIR LOC ON FR68 BTW S-8RH/S-9RH-AFT UPPER CORNER IAW EA# 368628 AND A320 SRM 53-41-12-300-012.SDR AALA202511131440Shear Tie · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FORWARD CARGO COMPARTMENT SHEAR TIE AT FR35.4 BETWEEN S40R AND S41R. REPLACED SHEAR TIE PER SRM 51-42-11.SDR VNAA20251110004Hinge Fitting · corrodedCORROSION ON LUG BORE OF L1, L2, L3, L5 AND L6 OF CENTER HINGE FITTINGS AND OUTB HINGE FITTINGS UPPR/LWR OF LEFT AILERON. LUGS WERE CLEANED PER CRJ-900: SRM: 51-26-00-001-001-A01 AND REPAIRED PER REO: 670-57-61-237 REV - AND PER REO 690-57-61-454 REV -.SDR JJBA20251109016Floorbeam · corrodedSURFACE CORROSION FLOORBEAM. LOCATION: 232BF. (FWD SERVICE DOOR AREA) REMOVED 1EA DAMAGED FLOOR RECESS ( ON 145-22466-009 ), INSTALLED 1EA NEW FLOOR RECESS UNDER FOOR PANEL 232BF( PN 145-22466-009 )SDR JJBA20251109015Seat Track · corrodedCORROSION FOUND ON SEAT TRACK MEGA BIN STRUCTURE ( UNDERNEATH FLOORBOARD 232DF) BETWEEN FRAMES 25 AND 30 ). REMOVED GUSSET AND INSTALLED NEW FROM STOCK GUSSET ON OMEGA BEAM STRUCTURE UNDERNEATH FLOORBOARD 242DF BETWEEN FR 30 AND FR 35SDR JJBA20251109014Floor Support · corrodedCORROSION FOUND UNDERNEATH FLOORBOARD 232DF AT FRAME 17 RIGHT ON THE GUSSET. INSTALLED NEW FROM STOCK GUSSET (145-21725-025) AFT OF SERVICE DOOR AND UNDERNEATH FLOORBOARD 232DF.SDR AALA202511061323Profile · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO DOOR CUTOUT LOWER SEALING PROFILE BETWEEN FR 55 AND FR 56. REPLACED SEALING PROFILE PER SRM 51-42-11.SDR ASAA2025092561976Seat Track · corrodedSEAT TRACK AT BL 0 MULTIPLE AREAS OF CORROSION STA 540 TO 727B. GROUNDED - YES. REMOVED AND REPLACED NEW SEAT TRACK IAW B737-700 SRM 51-40-02-0G-0. REMOVED CORROSION, FOUND TO BE OUT OF LIMITS IAW B737-700 SRM 53-00-52-1A-1W=1.25 O=.146 R=.123 L=2.75 D=.023.SDR ASAA2025092561975Keelbeam · corrodedKEEL BEAM FROM STA 540 TO STA 663 HAS NUMEROUS AREAS OF CORROSION ALL ALONG THE LOWER CHORD AS WELL AS THE LOWER 'WEB'. GROUNDED - YES. REMOVED CORROSION FOUND TO BE OUT OF LIMITS FROM STA 620 TO STA 663 IAW B737-700 SRM 53-00-12-1A-1. REPAIRED IAW B737-700 SRSDR SWAA2025110318359Web · corrodedCORROSION ON AFT CARGO BAY SUB WEB THRESHOLD AT BS 794 - 847, RBL 25, WL 155. REMOVED AND REPLACED ACB SUB THRESOLD WEB IAW SRM 51-40-02 AND DWG 146A8120 REV: E.SDR SWAA2025103118223Floor Support · crackedCRACK WEB - INTERCOSTAL FLOOR STRUCTURE LOCATED BS277 TO BS 294.5 AND BL 0 FWD GALLEY AND LAV. REPLACED FLOOR SUPPORT IAW SRM 51-40-02-0G AND DWG 141A5400 SHEET 20 REV -.SDR SWAA2025103118230Floor Support · crackedCRACK WEB - INTERCOSTAL FLOOR STRUCTURE LOCATED BS 344 TO BS 360 AND LBL 12 FWD GALLEY AND LAV. REPLACED THE FLOOR SUPPORT IAW SRM 51-10-02-0G-0 ITEM 9; SRM 51-40-02-0G-0 AND DWG: 141A5400 SHEET: 46 REV A.SDR SWAA2025103118233Support Angle · corrodedCORRODED SUPPORT ANGLE, BS 947.5, S25L TO S25R, WL 156. REPLACED SUPPORT ANGLE AND FASTENERS IAW SRM 51-10-02 ITEM 9, SRM 51-40-02, DWG 149A8117, SHEET 6, REV - & DWG 149A8110, SHEET 13, REV B.SDR SWAA2025103118234Support Bracket · crackedCRACKED SUPPORT BRACKET, BS 947.5, STR25L. REPLACED SUPPORT BRACKET, BS 947.5, STR25L IAW SRM 51-10-02-0G-0 ITEM 9, SRM 51-40-02-0G-0, AND DWG 149A8103 SHEET: 7 REV A .SDR SWAA2025103118368Tie Clip · crackedCRACKED TIE CLIP, BS 277 AND S-10R. REPLACED THE TIE CLIP IAW SRM 51-40-02 AND DWG 141A8380 SHEET 21 REV- AND 141A1110 SHEET 18 REV-.SDR SWAA2025103118366Angle · crackedCRACKED ANGLE LOCATED BS 294.5 AND S-13L. REPLACED THE ANGLE LOCATED BS 294.5 AND S-13L IAW SRM 51-10-02 ITEM 9, AND DWG 141A1311 SHEET 1, REV C.SDR SWAA2025103118371Beam · crackedCRACKED BEAM ORSS 297 TRAILING EDGE AT LT WING. REPLACED THE BEAM ORSS 297 TRAILING EDGE AT LT WING IAW SRM 51-10-01 ITEM 9; SRM 51-40-02 AND DWG: 115A3700, SHEET 30, REV - .MEASUREMENT OF CRACK: 0.9390 IN.SDR SWAA2025103118225Cargo Track · crackedCRACKED TRACK RBL 13.84 BS 747 AFT CARGO COMPARTMENT. PERFORMED REPAIR ON TRACK LOC. RBBL 13.84 BS 727D TO BS 767 AFT CARGO COMPARTMENT IAW SRM 53-00-53-2R-3 REPAIR 3; ALTERNATIVE 1 FIGURE 203.SDR SWAA2025103118227Frame · crackedCRACK FRAME ON BS 947.5 BETWEEN STRINGER 25L TO STRINGER 26L AFT CARGO COMPARTMENT. PERFORMED HFEC AND ROTOTEST INSPECTION ON HOLE LOCATED ON LBL 8.10 STA 947.5 AND NOT FOUND CRACK INDICATION AS PER 737 NDT MANUAL; PART 6; 51-00-00 PROCEDURE 23 AND AS PER NDTSDR ASAA2025092561931Battery · inoperativeBOTH L1 AND R1 EE LIGHT BATTERIES ARE DEAD. GROUNDED - YES. REMOVED AND REPLACED BOTH L1 AND R1 EE LIGHT BATTERIES, OPS CHECK GOOD IAW B737-800 AMM 33-51-06-960-805 STEPS 4.E (1-2) (4)(A,F)(5-6)(7)(A)(B)1)F.(1,4). (S/N 462625, 514985)SDR VNAA202510300007Web · crackedCRACK ON ELECTRICAL BAY FLOOR WEB FS 193.00 (BELOW ACCUMULATOR GAUGE INDICATOR) AT FWD EQUIPMENT COMPARTMENT WAS REPAIRED PER CRJ900 SRM 53-11-43-201-001-A01SDR SWAA2025103018367Stub Frame · crackedCRACKED STUB FRAME LOCATED BS 294.5, S17R. REPLACED STUB FRAME AND FASTENERS IAW SRM 51-10-02 ITEM 9, SRM 51-40-02, AND DWG 141A8370, SHEET 16, SHEET 19, & 20, REV-, DWG 141A8430, SHEET 5, REV -.SDR SWAA2025103018372Support Angle · crackedCRACK SUPPORT ANGLE BS 663.75 AND LBL 8. REPLACED ANGLE IAW SRM 57-10-10-2R-5, REPAIR 5, STEP 4.L (1) UP TO (7); DWG 111A1000 SHEET 259 REV.SDR SWAA2025103018228Floor Support · crackedCRACKED FLOOR SUPPORT BS 312 - 328, LBL 46. REPLACED THE FLOOR SUPPORT IAW SRM 51-40-02 AND DWG 141A5400 SHEET 26 REV -.SDR SWAA2025103018226Web · corrodedCORROSION SHIELD WEB BETWEEN BS 767 TO BS 794 AND RBL 22 WL 156 AFT CARGO COMPARTMENT. REPLACED SHIELD WEB AND FASTENERS LOCATED BETWEEN BS 767 TO BS 794 AND RBL 22 WL 156 IAW SRM 51-10-02 ITEM 9; SRM 51-40-02 AND DWG: 146A0081 SHEET: 37 REV: - .SDR SWAA2025103018360Intercostal · corrodedCORROSION ON AFT CARGO BAY INTERCOSTAL AT BS 767 - 807, RBL 6, WL 150. OPENSDR SWAA2025103018356Sidewall Support · corrodedCORROSION ON AFT CARGO BAY FLOOR TO SIDEWALL SUPPORT AT BS 727C - 787, LBL 21, WL 155. REMOVED & REPLACED THE FLOOR TO SIDEWALL SUPPORT IAW SRM 51-40-02-0G-0 & DWG 146A7500, REV B.SDR SWAA2025103018361Sidewall Support · corrodedCORROSION ON AFT CARGO BAY FLOOR TO SIDEWALL SUPPORT AT BS 727C - 787, RBL 21, WL155. REMOVED & REPLACED FLOOR TO SIDEWALL SUPPORT IAW SRM 51-40-02, & DWG 146A7500 ID: 0085 REV A.SDR SWAA2025103018004Scuff Plate · crackedCRACKED SCUFF PLATE AFT CORNER, IN AFT CARGO BAY. REPAIRED THE SCUFF PLATE IAW SRM 53-60-15-2R-1, REPAIR 1, AND 5975.SDR SWAA2025103018224Web · crackedCRACK WEB BS 947.5, S25R. REPLACED THE WEB IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, DWG: 147A7500, SHEET 28 REV -& DWG 147A7500, SHEET 29 REV - .SDR SWAA2025103018365Web · crackedCRACKED WEB, BS 294.5 - 303.9, S16L. REPLACED WEB IAW SRM 51-40-02-0G-0, AND DWG 141A8180, SHEET 27, SHEET 28 REV C, & SHEET 30, REV C.SDR SWAA2025103018376Support Angle · crackedCRACK SUPPORT ANGLE, BS 663.75, RBL 8, WL 168. REPAIRED THE ANGLE IAW SRM 57-10-10-2R-5, REPAIR 5, STEP 4L 1 UP TO 7, DWG 111A1000, SHEET 259, REV A, & DWG 144A7100, SHEET 76, REV-.SDR SWAA2025103018375Skin · crackedCRACK FOUND ON RT HORIZONTAL STABILIZER LOWER IN-SPAR SKIN AT HSS 193.90, RIB 17.5 INCHES FROM FRONT SPAR. INBD SIDE OF RIB LENGTH APPROX= 1.130 INCHES. PERFORMED REPAIR ON RT HORIZONTAL STABILIZER LOWER IN-SPAR SKIN IAW SRM 55-10-01-2R-11, REPAIR 11.SDR AALA202510303899Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT RIGHT PASSENGER / CREW DOOR CUTOUT LOWER SILL BETWEEN FR 66 AND FR 68 AT S23R. REPLACED LOWER SILL PER SRM 51-42-11.SDR 3EJA2025102400002Trim System · faultedAS THE NOSE CLIMBED ABOVE THE FLIGHT DIRECTOR USED THE ELECTRICAL NOSE DOWN TRIM BUT WAS NOT ABLE TO GET THE AIRCRAFT NOSE DOWN. THEN ATTEMPTED TO PUSH THE CONTROL YOKE FORWARD AND HAD A HARD TIME GETTING THE NOSE DOWN AND SAW THE CAS MESSAGE “ELECTRICAL TRIM SDR SWAA2025102218192Vapor Barrier · crackedBS 663 VAPOR BARRIER HAS A CRACK INDICATION AT APPROXIMATELY RBL 9. CUT AND REMOVED CRACKED SECTION OF VAPOR BARRIER ATTACH ANGLE PER SRM 57-10-10-2R.;[02] CW INSPECTION OF STEP #1. FABRICATED REPAIR ANGLE PER SRM 57-10-10-2R-5, C/W INSPECTION OF LINE #3 FABSDR SWAA2025102218305Rib · damagedLEFT WING TRAILING EDGE SHELF PANEL ABOVE DEFLECTION RIB HAS ELONGATED BOLT HOLES ON SERRATED PLATE AND SHELF PANEL BRACKET.<[01] REMOVED SERRATED PLATES AND HARDWARE THAT ATTACH DEFLECTION CONTROL RIB AT TAB TO UPPER BEAM.;[02] REMOVED DAMAGE ON UPPER BEAM ATSDR SWAA2025102218303Bracket · crackedRIGHT WING; DEFLECTION CONTROL RIB; INBOARD FIXED TRAILING EDGE UPPER PANEL BRACKET CRACKED. (M)<[01] REMOVED CRACKED WEB ANGLE BRACKET PER SRM 51-40-02.;[02] LOCATED; DRILLED AND DEBURRED REPLACEMENT WEB ANGLE BRACKET PER SRM 51-40-05.;[03] INSPECTED WORK IN SDR ASAA2025092561672Seat Track · corrodedSEAT TRACK AT RBL 45.50 MULTIPLE AREAS OF CORROSION STA 540 TO 727B. GROUNDED - YES. EVALUATED SEAT TRACK LT RBL 45.50, STA 540 TO 727B, FOUND TO BE OUT OF LIMITS, IAW B737-700 SRM 53-00-52-1A-1. REMOVED AND REPLACED SEAT TRACK IAW B737-700 SRM 51-40-02-0G-0 WSDR ASAA2025092561671Seat Track · corrodedSEAT TRACK AT LBL 60.70 MULTIPLE AREAS OF CORROSION STA 540 TO 627.5. GROUNDED - YES. REMOVED CORROSION FOUND TO BE OUT OF LIMITS. REMOVED AND REPLACED SEAT TRACK IAW B737-700 SRM 51-40-05-0G-0 & 51-40-02-0G-0W: 2" O: .146 R: .111 L: 4: D: .035.