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 IPXA11566580Shear Web · corrodedINSPECTION TYPE:C1, CABIN FLOOR SHEAR WEB AT BODY STA 1700+3 AND LBL 41, WEB IS CORRODED. REMOVED CORROSION, ORIGINAL THICKNESS .071, LOSS OF .010 WITH .061 MATERIAL LOSS IS OUT OF LIMITS IAW SRM 53-00-51-1A1. ACCOMPLISHED EA 1104 54/ EO B757-5310-42643-A FORSDR SWAA113351AStructure · crackedDURING SCHEDULED SPV CHECK, FOUND PASSENGER CABIN FLOOR AREA CRACKED, BS 616, WL 200, RBL 65 INNER CHORD. REPAIRED PER DOC.SDR ZZDA2011412Doubler · crackedPASSENGER ENTRANCE DOOR JAMB AFT FACE DOUBLER TAB, STA 215, LONG L15L, CRACKED. ACCOMPLISHED TAB DOUBLER REPAIR PER B717 SRM 51-70-10.SDR QMLDMG2191Structure · crushedINSIDE OF COWLING FOUND TO BE CRUSHED OVER A 1 TO 2 INCH SEAM DUE TO A KINK OR BENDING.SDR DALA1133416313Door Frame · crackedFORWARD CARGO DOOR CUTOUT FWD FRAME CHORD HAVE A CRACK STA 560 S-39R, L:2.5". ACCOMPLISHED REPAIR PER ER/A 491631-14 REV ORG SECTION I. WITHIN 12 MONTHS AFTER SECTION I. TBD PENDING BOEING DTA.SDR ASOA201100844Structure · corrodedFS 280.00 CORRODED BETWEEN LBL 36.00 AND RBL 36.00. REMOVED AND INSTALLED NEW FLOORBEAM IAW REO 670-53-11-047.SDR ASOA201100822Structure · corrodedAVIONICS COMPARTMENT AT FS 310.00 BETWEEN STR 26L AND STR 27 HAS A SMALL AREA OF CORROSION. BLENDED OUT CORROSION IAW SRM 51-21-06-001-001-A01 AND 51-42-06-001-001-A01.SDR SWAA113096Crease Beam · crackedDURING SCHEDULED 16Y CHECK, FOUND CREASE BEAM ANGLE CORRODED AT BS 344, STR 17L AT L1 DOOR LOWER LEVEL. REMOVED AND REPLACED ANGLE PER SRM.SDR DALA1128729871Door Frame · corrodedE & E COMPARTMENT AFT LOWER END OF AIRSTAIR DOOR CUTOUT HAS CORROSION. CORR ON CORNER ANGLE FOUND TO BE OUT OF LIMITS IAW SRM 53-01 FIG.1 75% MAT LOSS.CUT ACCESS HOLE STA 207 IN WEB TO GAIN ACCESS TO ANGLE FASTENERS 5"X 5" AREA IAW SRM 51-70-4 DEBURRED AND ISDR SWAA113075Crease Beam · corrodedDURING SCHEDULED 12Y CHECK, FOUND CREASE BEAM INSIDE OF L1 DOOR CORRODED. REMOVED AND REPLACED BEAM PER SRM AND BAC DWG.SDR SWAA113032Window Post · crackedDURING SCHEDULED HC2 CHECK, FOUND CAPTAINS WINDOW POST SKIN CRACKED AT UPPER LT CORNER. REPAIRED WINDOW POST PER SRM.SDR FDEA201104251616Service Panel · corrodedFWD LAV SERVICE PANEL DOOR IS CRACKED AND CORRODED. REPLACEMENT CARRIED OUT IAW AMM 52-42-11 PB401. DOOR OPERATION AND CLOSURE AS EXPECTED.SDR USAA2011050291713Door Frame · crackedCLT - Q2 CHECK - CRACK ON THE AFT FRAME OF THE FORWARD SERVICE DOOR CUTOUT BETWEEN WL 240 TO WL 250. REPAIRED THE AFT FRAME OF THE FORWARD SERVICE DOOR CUTOUT BETWEEN WL 240 TO WL 250 IAW EA 102887.SDR AALA20110423TUL04Pan · crackedRIGHT STATION 1041 FORWARD LOWER EAR CRACKED ON THE WINDOW PAN. INSTALLED REPAIR ANGLE AS PER AARD 53-10-00-25.SDR AALA20110422TUL02Pan · crackedRIGHT STATION 1079 UPPER AFT EAR CRACKED ON THE WINDOW PAN. INSTALLED REPAIR ANGLE DOUBLER PER AARD 53-10-00-25.SDR A6WA201140428Door Frame · damagedPAX DOOR SURROUND STRUCTURE DAMAGED AT FWD LOWER CORNER AFT HINGE ASSY. REPAIRED PAX DOOR CUT OUT SKIN LOWER FWD CORNER IAW SRM 53-21-31. REPAIR NR 1, FIG 202.SDR FDEA201104201536Window Frame · corrodedCORROSION WINDOW FRAME RT SIDE STA. 950 REMOVED CORROSION IAW SRM 51-10-6. MEASURED BLEND TO BE OUT OF LIMITS IAW SRM 56-20-1 FIG 1. FABRICATED DOUBLER REPAIR AND INSTALLED DOUBLE REPAIR IAW SRM 56-20-3 FIG 1.SDR ASOA201100799Post · crackedVERTICAL POST AT FS 409+128, WL 69.00, RBL 18.00 HAS 2 INDICATIONS: (1) ON THE OTBD POST, (1) ON THE INBD POST. BOTH IN THE AFT RADIUS. FAILED NDT INSPECTION. REMOVED VERT POST IAW SRM 51-42-06. LOCATED, DRILLED AND ASSEMBLED VERT POST IAW SRM 51-42-06 SDR AALA20110420TUL09Pan · crackedWINDOW PAN CRACKED, UPPER AFT CORNER, FORWARD SIDE OF STATION 1079 RIGHT SIDE. INSTALLED REPAIR ANGLE PER AARD 53-10-00-25.SDR AALA20110420TUL07Pan · crackedWINDOW PAN CRACKED UPPER AFT CORNER FORWARD SIDE OF STATION 1060 RIGHT SIDE. INSTALLED REPAIR ANGLE PER AARD 53-10-00-25.SDR AALA20110420TUL06Pan · crackedWINDOW PAN CRACKED LOWER FORWARD CORNER, AFT SIDE OF STATION 1193 RIGHT SIDE. INSTALLED REPAIR ANGLE PER AARD 53-10-00-25.SDR GLBA20110420GDoor Frame · crackedMAJOR REPAIR - DURING A SCHEDULED ROUNTINE INSPECTION MAINTENANCE FOUND THE UPPER GARGO DOOR FUSELAGE FRAME AT FS 460 AND STRINGER 3L CRACKED 1.3" IN LENGTH. MAINTENANCE REPAIRED THE AFFECTED AREA AND PERFORMED ALL REQUIRED RII INSPECTIONS I.A.W. EO 11-1900-53SDR SWAA112975Crease Beam · crackedDURING SCHEDULED 26Y CHECK, FOUND CREASE BEAM WEB CRACKED BETWEEN BS 635 TO BS 638.5, BETWEEN LBL 68.5 TO LBL 69.5. REPAIRED WEB PER SRM AND BAC DWG.SDR ZZDA2011398Door Frame · corrodedAFT CARGO LOWER FUSELAGE DOOR JAMB, CORROSION. ACCOMPLISHED DOOR JAMB SPLICE REPAIR PER B717 SRM 53-20-15.SDR SWAA112842Crease Beam · corrodedDURING SCHEDULED 18Y CHECK, FOUND FWD GALLEY DOORWAY CREASE BEAM CORRODED. REMOVED AND REPLACED BEAM PER BAC DWG.SDR SWAA112841Crease Beam · corrodedDURING SCHEDULED 18Y CHECK, FOUND AFT GALLEY DOORWAY CREASE BEAM CORRODED. REMOVED AND REPLACED BEAM PER BAC DWG.SDR SWAA112824Crease Beam · corrodedDURING SCHEDULED 18Y CHECK, FOUND RT CREASE BEAM CORRODED BETWEEN BS 380 TO BS 400. REPAIRED BEAM PER SRM.SDR FDEA201104181512Door Frame · corrodedLOWER CTR CARGO DOOR JAMB, STA 1601 - STA 1741, X = -147 LOWER SIDE FOUND WITH CORROSION. ACCOMPLISHED EA 1-5310-149741. REPAIR CLASSIFIED AS MAJOR GMM 6-2-100, REV 112.SDR FDEA201104181511Door Frame · corrodedLOWER CARGO DOOR JAMB STA 160 - STA 1741, X = -147 UPPER SIDE FOUND WITH CORROSION. ACCOMPLISHED EA 1-5310-149741, REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100, REV 112.SDR GUUA94053041711BDoor Frame · crackedDURING SCHEDULED ROUTINE STRUCTURAL INSPECTION DISCOVERED AIRSTAIR DOOR FRAME CRACKED AT UPPER AND LOWER COUNTER BALANCE MOUNTS APPROXIMATELY FS 150.6 AND WL 105. REMOVED DAMAGED SECTION OF ANGLE AND INSTALLED NEW SECTION.SDR 3S8R2011041600016Beam · damagedRT LONGITUDINAL BEAM LOWER SKIN AND BEAM DAMAGED. REPAIR TO BE CARRIED OUT IAW MX 20-03-05-420. DAMAGE IS BETWEEN FS 3855 AND 5295.SDR ASOA201100782Door Frame · crackedPAX DOOR FRAME CRACKED IN RADIUS APPROX 6" FROM AFT CAM ROLLER. REPAIRED IAW REO 601R-52-11-402.SDR HNAA2011050600111Panel · crackedCOCKPIT ENTRANCE FLOOR CLOSE OUT PANEL CRACKED. REMOVED AND FABRACATED COCKPIT ENTRANCE CLOSE OUT PANEL IAW DWG 85311097. INSTALLED PANEL IAW -8300 SRM 51-40-11. PART MAKE OF 2024T3 .040, BATCH 37.SDR ASOA201100772Post · crackedLBL 27 INBD POST CRACKED AT FS 409+128 AT S20L. REPAIRED IAW REO 601R-53-41-056 IAW REO 601R-53-41-056SDR 2011F00092Structure · crackedDURING PHASE 49 INSP EDDY CURRENT INP INDICATED A POSSIBLE CRACK. PAINT AND FILLER WERE REMOVED AND AREA INSPECTED BY VISUAL INSP USING MAGNIFICATION WHICH CONFIRMED 3 CRACKS IN BAND AT FS 287.78. IT APPEARS BAND WAS DAMAGED DURING LAST REPAINT OF ACFT, CAUSISDR 2011FA0000249Cross Tie · damagedFOUND 2 SHEARED RIVETS IN GUSSET ON FRAME AT FS 201.775 AND STRINGER/CROSS TIE 7R. DISCREPANCY FOUND DURING SCHEDULED INSP, THIS AREA WAS RECENTLY INCLUDED IN THE INSPECTION GUIDE. THE SIDEWALLS MUST BE REMOVED TO INSPECT CROSS TIES. THE LT SIDE HAD PREVIOUSLSDR IPXA1B66698Crease Beam · crackedINSPECTION TYPE:D, M/D STA 960, LT CREASE BEAM WEB CRACKED AT STR 7L AREA M/D STA 960, LT CREASE BEAM AT STR 7L. AREA ATTACH WEB REPLACED AND INSTALLED IAW HX RS R-53-20-37044, REV A & EO B747-5310-42616-A. THIS IS CATEGORY A REPAIR & CLASSIFIED AS MINOR REPSDR IPXA1B66695Crease Beam · crackedINSPECTION TYPE:D, M/D STA 980 RT CREASE BEAM WEB CRACK AT STR 5R AREA. M/D STA 980, RT CREASE BEAM WEB AT STR 5R AREA REPLACED AND INSTALLED IAW HX RS NO R-53-20-37045, REV A AND EO NR B747-5310-42617-A, THIS IS A CATEGORY A REPAIR & CLASSIFIED AS MINOR REPASDR FDEA201104141475Window Frame · crackedONE CRACK FOUND ON LEFT FUSELAGE INTERNAL STRUCTURE FROM FRAME 2 TO 4 WINDSHIELD FRAME LOWER SECTION AT FASTENER HOLE NR 10 AFT SIDE DURING EDDY CURRENT ROTATING PROBE TEST PER NTM53-11-01. LEFT FUSELAGE INTERNAL STRUCTURE FROM FRAME 2 TO 4 WINDSHIELD FRAMESDR FDEA201104141484Rib · crackedREAR FUSELAGE INTERNAL FOUND 1 RIB CRACKED AT FR86 STR32R. REMOVED THE CRACKED RIB. FABRICATED A NEW RIB FOR REPLACEMENT IAW SRM 51-72-10 AND IAW DWG A53986743205.SDR GUUA94753041311ADoor Frame · crackedDURING SCHEDULED ROUTINE MAINTENANCE DISCOVERED AFT CARGO DOOR FRAME CRACKED APPROXIMATELY 90% OF WIDTH AND 3.5 INCHES LENGTH AT APPROXIMATELY FS 509.50 STRINGER 10L. REMOVED DAMAGED SECTION OF FRAME AND INSTALLED NEW SECTION OF FRAME.SDR A6WA201140296Rail · crackedFWD CARGO DOOR SUPPORT RAIL AT FS 584 CRACKED. R & R SUPPORT RAIL BRACKET.SDR UALA2011041401803Crease Beam · corrodedCORROSION ON CREASE BEAM STA 1020 - 1035, RBL 64 MAIN CABIN A FLOOR LINE. MAJOR REPAIR ACCOMPLISHED, REMOVED CORROSION, FABRICATED AND INSTALLED STRAP ON PEMCO NR 2486N00278 PER EA PD57-53-106.SDR ASOA201100762Structure · corrodedFS 559.00+105 STR 23R HAS A SMALL AREA OF CORROSION AROUND RIVET" IN DIA. REMOVED LIGHT SURFACE CORROSION IAW SRM 51-21-06. WITHIN ALLOWABLE DAMAGE LIMITS IAW SRM 53-00-31.SDR SWAA112740Door Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FWD CARGO DOOR FRAME CUTOUT CRACKED AT AFT LOWER CORNER. REPAIRED FRAME PER EA.SDR SIMA201110401Striker · chafedDURING MAINTENANCE BASE VISIT FOUND THE PASSENGER DOOR FORWARD SEAL STRIKER CHAFED BELOW UPPER FRAME ROLLER. THE AIRCRAFT WAS REMOVED FROM SERVICE. REPAIRED IAW EO CR-53MR-238. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR SWAA112636Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO DOOR CUTOUT FWD FRAME CRACKED AT BS 440 AT UPPER STOP FITTING. REPAIRED FRAME PER SRM.SDR IPXA1B66717Rib · corrodedINSPECTION TYPE:D, FX STA 1045, BL 0 KEEL BEAM PANEL SUPPORT RIB FOUND CORRODED FX AT STA1045 BL0"-LBL 7" AREA PNL SUPT REPAIRED IAW SRM 53-00-71, FIG 201, REPAIR 3 REV 59 ORG MAT IS BAC1505-100081 7075T73-100 THK CORROSION BLEND OUT AREA 0.037" DEPTH 1" WIDSDR IPXA1B66716Rib · corrodedINSPECTION TYPE:D, FX STA 1120, BL0 KEEL BEAM PNL SUPT RIB FOUND CORRODED. CORROSION REMOVED & REPROTECTED IAW SRM 51-10-02 AND 51-20-01 REV 59. ORG THK 0.100". BEND DEPTH 0.006" X WIDTH 1", LENGTH 2" WITHIN SRM 53-00-71 ALLOWABLE DAMAGE 1 FIG 101 REV 59 SDR IPXA1B66715Rib · corrodedINSPECTION TYPE:D, FX STA 1120, BL 0 KEEL BEAM PANEL SUPPORT RIB FOUND CORRODED. CORROSION REMOVED & REPROTECTED IAW SRM 51-10-02 AND 51-20-01 REV 5 59. ORG THK 0.100". BLEND DEPTH 0.006" X WIDTH 1", LENGTH 2" WITHIN SRM 53-00-71 ALLOWABLE DAMAGE 1, FIG 10
Back to JASC 5310