JASC 5310
Service difficulty reports · 38,573
Reports filed under 5310 · Fuselage Main, Structure, newest first.
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' WHERE jasc_code = '5310' 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' WHERE jasc_code = '5310' 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 FDEA201102180623Angle · corrodedRT MAIN WHEEL WELL REAR SPAR CAP ANGLE (APB7080-2) HAS 2 CRACKS (2' CRACK INDICATION AFTER BLEND OUT) REMOVED AND INSTALLED REPAIR ANGLE. SRM 53-40-00, FIG 11.SDR COEA2011021829805Crease Beam · corrodedHEAVY CHECK / COE / LEVEL 2 CORROSION: RT CREASE BEAM WEB LOWER SURFACE BETWEEN FRAMES 12 & 13 HAS CORROSION. (LENGTH 5.7", WIDTH 2.6", DEPTH .011"). REMOVED RT CREASE BEAM WEB AND REPLACED WITH OEM PART IAW ATR72 SRM.SDR IPXA1565102Doubler · gougedINSPECTION TYPE:C3, MAIN CARGO BAY DOUBLER IS GOUGED ON UPPER SURFACE AT BS 1681, RBL 53, RBL 56, WL 208. R & R IAW SRM 51-40-02-0G, SRM 53-60-13-0I-1, SRM 51-10-02-0G.SDR QXEA2011022100172Structure · corrodedC6 CHECK - DURING INSP, FOUND CORROSION ON STR 25L AT FS 280, FS 310. REMOVED ALL CORROSION AND FOUND FS 280-FS 295 TO BE IN NO DAMAGE ALLOWED AREA. PERFORMED FPI IAW NDTM 51-20-08, NO EVIDENCE OF CRACK FOUND. FABRICATED REPAIR PARTS IAW REO 670-53-21-643SDR AALA20110217TUL21Pan · crackedFORWARD LOWER WINDOW PAN TAB CRACKED STATION 984 RIGHT. INSTALLED REPAIR ANGLE PER AARD 53-10-00-25.SDR AALA20110217TUL20Pan · crackedFORWARD LOWER WINDOW PAN TAB CRACKED STATION 984 LEFT. INSTALL REPAIR ANGLE PER AARD 53-10-00-25.SDR AALA20110217TUL17Pan · crackedRIGHT STATION 845 FORWARD UPPER WINDOW PAN EAR IS CRACKED. REPAIRED PER AARD 53-10-00-25.SDR AALA20110217TUL16Pan · crackedRIGHT STATION 946 FORWARD LOWER WINDOW PAN EAR IS CRACKED. REPAIRED PER AARD 53-10-00-25.SDR AALA20110217TUL15Pan · crackedRIGHT STATION 946 FORWARD UPPER WINDOW PAN EAR IS CRACKED. REPAIRED PER AARD 53-10-00-25.SDR SWAA111030Crease Beam · corrodedDURING SCHEDULED 12Y CHECK, FOUND L1 DOOR CREASE BEAM CHORD CORRODED BETWEEN BS 328 TO BS 344, LBL 60. REMOVED AND REPLACED BEAM PER SRM.SDR SWAA111029Crease Beam · corrodedDURING SCHEDULED 12Y CHECK, FOUND RT CREASE BEAM CORRODED BETWEEN BS 951 TO BS 992. REMOVED AND REPLACED BEAM PER SRM AND BAC DWG.SDR QXEA2011021600160Beam · damagedC6 CHECK - FWD LINTEL BEAM ON AFT BAGGAGE BAY SURROUND IS CHAFED. REMOVED LINTEL BEAM AND DISASSEMBLED IAW SRM 51-42-06-001-001-A01 AND 51-42-21-001-001-A01. BLENDED DAMAGED AREA IAW SRM 51-12-00-001-001-A01. PERFORMED LPI OF AFFECTED AREAS, NO DEFECTS NOTESDR V0XR2011020600021Support Beam · corrodedSUPPORT BEAMS AT Y0.0 AND RY 479.0 CORRODED BEYOND LIMITS. R & R BEAM.SDR USAA2011022890889Stop Fitting · crackedCLT - MAJOR REPAIR - Q2 CHECK - R2 DOOR STOP FITTING AT BS 332.1, S8R CRACKED. REPLACED R2 DOOR STOP FITTING AT BS 332.1, S8R IAW B737 SRM 51-10-02.SDR UALA2011021600808Crease Beam · corrodedMAIN CABIN T-CHORD HAS CORROSION FROM STA 1030 TO 1040 AT RBL 70. MAJOR REPAIR ACCOMPLISHED: AFTER CORROSION WAS REMOVED IT WAS FOUND TO BE BEYOND LIMITS AT INBD CHORD AT FS1021, 1025 AND 1029 AT RBL 63. A NEW CHORD CREASE BEAM WAS INSTALLED WITHOUT DEVIATIOSDR ASOA201100282Post · crackedFS409+128, BULKHEAD, LBL18.00 VERTICAL POST CRACKED THRU LOWER OTBD ATTACH FASTENER PROPAGATING INTO RADIUS. REPAIRED IAW REO 601R-53-41-056.SDR C2XA11SH042Door Frame · corrodedSHV - DURING C-CHECK CARGO DOOR LOWER CUTOUT CORRODED. REPLACED CARGO DOOR LOWER CUTOUT IAW EMB 145 SRM 51-40-02. AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR COEA2011021424805Crease Beam · corrodedHEAVY CK / COE / LEVEL 2 CORROSION: UPPER AND LOWER SURFACES OF RT CREASE BEAM WEB FR 14-15 HAS MANY AREAS OF CORROSION. REMOVED RT CREASE BEAM WEB AND REPLACE WITH OEM PART PER ATR72 SRM.SDR ASAA1149239Door Frame · corrodedCORROSION ON R2 DOOR OPENING LOWER INNER CHORD. REMOVED CORROSION FOUND OUT OF LIMITS IAW B737 400 SRM 53 60 51 FIG 101. REMOVED AND REPLACED WITH NEW INNER CHORD IAW B737 400 SRM 51 40 02.SDR ASAA1149238Door Frame · corrodedCORROSION ON L 2 DOOR OPENING LOWER INNER CHORD. REMOVED AND REPLACED IAW B737 400 SRM 51 40 02.SDR IPXA1564966Strap · corrodedINSPECTION TYPE:C2, APU INLET DOOR HOUSING CUTOUT, FWD ATTACH STRAP HAS CORROSION AT SEVERAL NUTPLATE HOLES. FOUND DAMAGE TO BE OUT OF LIMITS IAW SRM 53-00-01-1A, REMOVED STRAP, FABRICATED REPLACEMENT STRAP IAW SRM 51-40-03-0G, SRM 51-40-06-0G, SRM 51-40-08-0SDR F3LA2011021700601Shear Plate · corrodedC-CHECK: NON ROUTINE N0284; RT AFT FUSELAGE SHEAR PLATE BETWEEN FRAMES 69R AND 70R HAS 4 SQUARE INCHES OF CORROSION. EO AO-53EO-31434 SHEAR PLATE NEEDS TO BE REPLACED WITH NEW CONFIGURATION. REPLACED RT SHEAR PLATE BETWEEN FRAMES 69R AND 70R WITH NEW CONFIGUSDR IPXA1565044Door Frame · wornINSPECTION TYPE:C2, RT APU DOOR NR 316AR FWD INNER FLANGE WORN AT OTBD EDGE. R & R FRAME IAW SRM 51-40-05-0G, SRM 51-20-01-0G AND AMM 51-20-00-0.SDR UALA2011021400756Door Frame · crackedDOOR 2L FWD CLOSURE FRAME UPPER HINGE CUTOUT HAS A .5 INCH CRACK AT RADIUS THROUGH PREVIOUS REPAIR DOUBLER. MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGED REPAIR DOUBLER ON FWD FRAME, ACCOMPLISHED HFEC INSP OF HOLES & FRAME WEB IAW NDT. FABRICATED A NEW REPAIR SDR DALA1110329857Door Frame · corrodedFUSELAGE EXTERIOR FORWARD AIR STAIR DOOR FRAME INTERIOR HAS CORROSION. REMOVED AND REPLACED DOOR FRAME IAW DC-9 SRM 51-30-1 AND 51-30-2. REMOVED AND INSTALLED DOOR ASSEMBLY FOR ACCESS IAW MM 52-62-00. PRESSURE LEAK CHECK TO BE ACCOMPLISHED ON SDR SWAA110808Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND SUBFRAME CRACKED AT LOWER SIDE OF R1 DOOR. REMOVED AND REPLACED SUBFRAME PER SRM AND BAC DWG.SDR SWAA110750Crease Beam · crackedDURING SCHEDULED 18Y CHECK, FOUND LT OVERWING CREASE BEAM WEB CRACKED AT BS 637, STR 17L. REPAIRED WEB PER SRM.SDR ASOA201100266Structure · corrodedFOUND CORROSION AT FS 364.00 AND BETWEEN S26R AND 25R. BLENDED CORROSION AT FS 364 BETWEEN STR 26R & 27R REF SRM 51-21-06. THIS IS A MAJOR REPAIR.SDR DALA1110265530Crease Beam · corrodedCREASE BEAM ASSY HAS CORROSION STA 1400-1420, RBL 63. COMPLIED WITH ERA 489013-14 REV ORIGINAL. COMPLETED INSPECTION.SDR AALA20110211TUL06Angle · corrodedCORROSION ON CREASE ANGLE AT 1020 AND BUTTLINE 64. REMOVED DAMAGED AREA AND COMPLETED SPLICE REPAIR PER EA B757-53-015258 AND AARD 53-30-13-1 REPAIR 1.SDR DALA1121086904Door Frame · gougedFWD EQUIP COMPT DOOR CUTOUT STA 231 BL 0 FRAME AND LATCH FITTING IS GOUGED 77-30. ACCOMPLISHED ERA 489479-14 REV ORIG AT SAA DURING HMV ON NR CARD 172513.SDR QXEA2011021400147Structure · damagedC1 CHECK - ACCOMPLISH TASK CARD RD8/4-53-3447/3: TEMP REPAIR FOR LIGHTNING STRIKE DAMAGE TO LWR FUSELAGE. COMPLIED WITH RD 8/4-53-3449/3.SDR DALA1116779877Door Frame · corrodedFWD CARGO DOOR SILL, CORRODED FRAME STA 408, BETWEEN WEB AND FRAME. REMOVED FASTENERS FROM FRAME IAW DC-9 SRM 51-30-05. BLENDED CORROSION IAW SRM 51-10-3, PG 46, PARA 26. FRAME FOUND TO BE OUT OF LIMITS IAW DC-9 SRM 53-01, FIG 1, SHT 3. REMOVED DAMAGED SECSDR ASOA201100249Structure · corrodedFUSELAGE FS 364.00 HAS CORROSION FROM STGR 25L TO 25R.SDR DALA1109609873Pan · crackedMAIN CABIN WINDOW PAN CRACKED IN TOP FWD CORNER BETWEEN STA 794 AND 813 AT FASTENER LT SIDE. REMOVED 4 EA FASTENERS FROM WINDOW PAN. REMOVED DAMAGED AREA. NDT VERIFIED ALL DAMAGE WAS REMOVED. FABRICATED REPAIR ANGLE FILLER DRILLED, LOCATED AND DEBURRED FASTESDR DALA1109589873Pan · crackedMAIN CABIN WINDOW PAN CRACKED IN TOP FWD CORNER AT FASTENER BETWEEN STATION 693 AND 712 RT SIDE. CUT OUT CRACKED AREA. FABRICATED AND INSTALLED IAW SRM 56-20-02-801-663A-A. REQUIRED INSP COMPLETED.SDR EE4Y20110100Beam · corrodedREPORTED MID CARGO COMPARTMENT LOWER JAMB BEAM WITH CORROSION AT SEVERAL PLACES.SDR AALA20110208TUL07Pan · crackedCABIN LEFT AFT WINDOW PAN CRACKED STATION 1211 (TOP AFT). CUT OUT CRACKED AREA OF RINGPAN, DRILLED UP DOUBLER AND INSTALLED ALL PER AARD 53-10-00-25.SDR ASOA201100247Structure · corrodedFUSELAGE FS 333.00 HAS CORROSION FROM STR 25L TO STR 25R.SDR AALA20110208TUL06Pan · crackedWINDOW PAN CRACKED LEFT AT STATION 1249. TRIMMED OUT DAMAGE AND INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20110208TUL02Pan · crackedLEFT STATION 788 WINDOW RING PAN CRACKED UPPER FORWARD CORNER. INSTALLED REPAIR ANGLE PER AARD 53-10-00-25 .SDR AALA20110208TUL01Pan · crackedRIGHT SIDE WINDOW PAN IS CRACKED AT STATION 845 UPPER FORWARD SIDE. INSTALLED REPAIR DOUBLER AT RIGHT WINDOW RING PAN STATION 845 PER AARD 53-10-00-25.SDR CALA2011020800073Crease Beam · corrodedLEFT CABIN FLOOR STRUCTURE CREASE BEAM STA 1320-1340 HAS CORROSION (MARKED). REPAIR LT CREASE BEAM INBD CHORD SECTION STA 1370 PER EC/RA 5310-05352 SEE SUB-TASKS WORK ACCOMPLISHED. INITIATED DIP53-DIP CTL#09133 TO ACCOMPLISH PERMANENT REPAIR WITHIN 12 MONTHSSDR IPXA1664790Angle · crackedINSPECTION TYPE:C, MAIN EQUIPMENT CTR STA 246, LBL 50", VERTICAL CLIP FOUND CRACKED. MAIN EQUIPMENT CTR STA 246, LBL 50" VERTICAL CLIP REPLACED IAW SRM 51-10-02 AND INSTALLED IAW SRM 51-40-02, REV.49.SDR ASOA201100232Support Beam · crackedCARGO DOOR SUPPORT BEAM ANGLE CRACKED AT FS 621.00. R & R BRACKET, PN 601R35050-109 AT CARGO DOOR SUPPORT BEAM AND FS 621 BULKHEAD IAW SRM 51-40-11, 51-42-21. THIS REPAIR REQUIRES MAJOR/MINOR CLASSIFICATION IAW ASA SOP 5702. THIS REPAIR IS CLASSIFIED AS ASDR SWAA110714Crease Beam · crackedDURING SCHEDULED SPV CHECK, FOUND CREASE BEAM WEB CRACKED AT BS 297, STR 17R. REMOVED AND REPLACED WEB PER SRM AND BAC DWG.SDR AALA20110207TUL04Pan · crackedWINDOW RING PAN CRACKED UPPER AFT CORNER, STATION 1060 RIGHT. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR AALA20110207TUL03Pan · crackedWINDOW RING PAN CRACKED, UPPER AFT CORNER, STATION 1022 RIGHT. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR IXXA11SMN030SDoor Frame · crackedDURING ROUTINE C-CHECK INSP FOUND LOWER FWD CARGO COMPARTMENT FRAME CRACKED AT STA 200.000 BETWEEN LONGERON-32 RT AND LONGERON -33 RT. REMOVED FASTENERS AS NEEDED TO PERFORM REPAIR. REMOVED DAMAGED AREA. R & R EXTRUSION FRAME SEGMENT. FABRICATED SPLICE AND ASDR IXXA11SMN029SDoor Frame · crackedDURING ROUTINE C-CHECK INSP, FOUND FWD CARGO DOOR JAMB CRACKED AT STA FS 330.000 BETWEEN LONGERON 32 LT AND 33 LT. REMOVED FASTENERS AS NEEDED TO PERFORM REPAIR. REMOVED DAMAGED AREA. PERFORMED NDT INSP. NO DISCREPANCY FOUND. FABRICATED REPAIR TRIPLER, REPAIR
Back to JASC 5310