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 SWAA043258Shear Tie · corrodedDURING SCHEDULED D-CHECK, FOUND SHEAR TIE AT BS 500D, LBL 16 TO LBL 21, CORRODED. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA043257Shear Tie · corrodedDURING SCHEDULED D-CHECK, FOUND SHEAR TIE AT BS 1006, LBL 4 TO RBL 4, CORRODED. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR 04FDEA03050Door Frame · gougedFUSELAGE CORROSION/GOUGES ON MAIN CARGO DOOR FRAME. COMPLIED WITH EA 8-5310-82067. FUSELAGE CORROSION GOUGES ON MAIN CARGO DOOR FRAME.SDR 04FDEA03038Door Frame · damagedBS 1108 AFT CARGO DOOR FRAME AT STR 26 HAS A OPEN HOLE IN UPPER FLANGE. REPAIRED AFT CARGO DOOR FRAME PER FED EX EA 7-5310-825111.SDR EIA2004145Structure · corrodedBS 1480 MCD, CORROSION ON WHEEL WELL CHORDS AND STRIP, LBL 98-0 - LBL 57.5, AND LBL 35.0 - RBL 21.0. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR PER ECRA 470-53-215-2PL.SDR EIA2004143Structure · corrodedBS 1480, LBL 74.92, TOP OF MLG BOX HAS CORROSION. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR PER ECRA 470-53-215-2P-1.SDR SWAA043237Door Frame · crackedDURING SCHEDULED C3 CHECK, FOUND FWD SERVICE DOOR FRAME CUTOUT BELOW UPPER HINGE STUB FRAME CRACKED. REPAIRED FRAME PER EA.SDR ASAA0410485Door Frame · dentedPAE - AFT CARGO DOOR CUTOUT UPPER CHORD DENTED. REPLACED CHORD.SDR SWAA043216Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM WEB FROM BS 460 TO BS 480, RBL 65, CORRODED. REMOVED AND REPLACED WEB SECTION PER SRM.SDR WLDA2004100Shear Tie · corrodedITEM: DURING "C2" CHECK INSPECTION, FOUND SHEAR CLIP CORROSION AT STA 1953, STA 1959 AND STA 1975 BETWEEN L48L AND L52R. REMOVED THE CORROSION SHEAR CLIP AND INSTALLED NEW PARTS PER MD11 SRM VOL II 51-35-01. APLIED PROTECTION COATING.SDR USAA040947Strap · corrodedPIT - Q5 - STRAP, .2500 INCH BY .2500 INCH IN 66 AREAS, CORROSION; LEVEL 1; TASK NR-C53-107-02, AFT CARGO DOOR FRAME SECTION S25R, STA 807-848. REPLACED PART IAW SRM 53-00-07.SDR AWXA200401351Shear Tie · corrodedMCN - MAJOR REPAIR - DURING C-15 CHECK EXFOLIATION CORROSION WAS FOUND ON SHEAR TIE AND BEAR STRAP IN AFT BILGE AREA BS 967, BL "0". MAINTENANCE REMOVED SHEAR TIE AND AFTER CLEANING OFF CORROSION FOUND NO MATERIAL LOSS. TRIMMED OUT CORRODED AREA OF BEAR STRASDR WLDA200499Shear Tie · corrodedDURING C2-CHECK INSPECTION, FOUND SHEAR TIE CORROSION AT STA 1741 BETWEEN L51L TO L51R. CUT OUT THE CORROSION AREA AND MADE REPAIR PARTS PER SRM 53-30-00 VOL 1 FIG 5. PERFORMED NDT INSP NO DEFECT FOUND. INSTALLED REPAIR PARTS PER MD11 SRM 51-33-01 VOL II REV3SDR 72300031Door Frame · corroded3 INCH BY 5 INCH AREA OF CORROSION ON FUSELAGE DOOR FRAME.SDR ASOA04920Doubler · corrodedDURING C-CHECK INSPECTION, THE UPPER DOUBLER OF THE HANDRAIL FITTING ON THE LT THRESHOLD BETWEEN FS 38 AND 39 WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE CORRODED DOUBLER IAW WITH SRM 51-21-42 AND 51-25-04.SDR 0401965502Door Frame · crackedDURING L-CHECK FOUND CRACKED HOLE NR 7 AT UPPER CORNER OF NR 1 LT PASSENGER DOOR JAMB. REPAIRED PER EA 55-200848.SDR SWAA043184Shear Tie · corrodedDURING SCHEDULED D-CHECK, FOUND AFT CARGO COMPARTMENT SHEAR TIE AT BS 727D, RBL 18, CORRODED. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA043180Shear Tie · corrodedDURING SCHEDULED 1/4D CHECK, FOUND SHEAR TIE AT BS 927 BETWEEN STRINGER 26R AND STRINGER 27R, CORRODED. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA043179Door Frame · corrodedDURING SCHEDULED 1/4D CHECK, FOUND AFT CARGO DOOR FRAME CUTOUT AFT WEB CORRODED. REMOVED AND REPLACED WEB SECTION PER SRM.SDR SWIA200414215Buttstrap · corrodedRIGHT BUTT STRAP AT Y479.00R FROM FRAME 21 TO FRAME 26 IS CORRODED. ITEM FOUND AT C-CHECK INSPECTION. BLENDED AND ASSESSED CORROSION IAW EMB 120 SRM 53-20-10, FOUND TO BE WITHIN LIMITS. DEPTH .004. REPROTECTED IAW SRM 51-21-02 AND AMM 20-30-05.SDR SWIA200414209Buttstrap · corrodedBUTT STRAP AT Y479.00L FROM FRAME 30-34 IS CORRODED, ITEM FOUND AT C-CHECK INSPECTION. BUTTSTRAP REPLACED IAW EMB SRM 120 51-40-02, 51-25-00.SDR SWIA200414208Buttstrap · corrodedBUTT STRAP FROM FRAME 30-34 CENTER IS CORRODED. ITEM FOUND AT C-CHECK INSPECTION. BUTT STRAP REPLACED IAW EMB 120 SRM 51-25-00, 51-40-00SDR AMTA200401345Shear Web · corrodedCORROSION ON DECK PLATE, BS 1681, LBL 30 AT FASTENER HOLE. SHEAR WEB BS 1681 TO 1720 WILL BE REPLACED ON EO 757-53SW-25 91, REVC.SDR USAA040857Frame · crackedPIT - Q4, FRAME, .1250 INCH CRACK, EMANATING FROM FASTENER, FRAME STA 847, STR 9L. INSTALLED DOUBLERS IAW TYPE REP 53-10-20A.SDR ASA0440224Shear Tie · corrodedCORRODED SHEAR TIE. REPAIRED WITH DOUBLER.SDR ASA0440196Door Frame · dentedAFT CARGO DOOR CUT OUT, AFT FRAME WEB BENT. ACCOMPLISHED REPAIR IAW EA ON AFT FRAME.SDR CA041110007Door Frame · cracked(CAN) ON INSPECTION FOUND CRACKED AT UPPER FWD RADIUS ABOUT 1.0 INCH IN LENGTH. PART WAS REPLACED AS REQUIRED.SDR UPS04443468Shear Angle · crackedINSPECTION TYPE: C, M/D - BS 440, APPROX STR 16L, FRAME ATT SHEAR ANGLE FOUND CRACK. CRACKED SHEAR ANGLE REPLACED PER SRM 51-10-01.SDR MWEA040197Door Frame · crackedPASSENGER DOOR JAMB WEB TANG IS CRACKED AT STATION 207 LONGERON 15 LEFT. FABRICATED AND INSTALLED DOUBLER.SDR QXEA200400754Door Frame · corrodedPDX - AFT FUSELAGE RIGHT HAND AFT SERVICE DOOR SURROUND STRUCTURE FSX669.300 TO X697.000 WLZ100.032 EDGE CHANNEL HAS SURFACE CORROSION IN SEVERAL LOCATIONS. REPAIRED IAW HORIZON AIR EA 6-53-441, RD 8/4-53-1031 AND SRM 51-21-10-380-801.SDR SWAA043142Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND RT FUSELAGE CREASE BEAM WEB CORRODED BETWEEN BS 380 AND BS 420. REPAIRED CREASE BEAM PER SRM.SDR SWAA043158Crease Beam · crackedDURING SCHEDULED PM CHECK, FOUND FUSELAGE RT CREASE BEAM WEB CRACKED AT BS 639. REPAIRED WEB PER SRM & SWA EA.SDR SWAA043129Shear Tie · corrodedDURING SCHEDULED D-CHECK, FOUND SHEAR TIE AT BS 787, RBL 13, CORRODED. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA043127Crease Beam · crackedDURING SCHEDULED D-CHECK, FOUND 2 EACH CREASE BEAM WEBS CRACKED AT BS 821, LBL 70, BS 773, RBL 7.5. REMOVED AND REPLACED WEB SECTIONS PER SRM.SDR USAA040968Crease Beam · corrodedPIT - Q5 - CREASE BEAM WEB, .75 INCH (6 AREAS), CORROSION; NO LEVEL OR TASK, BETWEEN STA 420 AND STA 440, RT SIDES. CREASE BEAM WEB MFG IAW DWG 65-96956 AND BACD2003.SDR UPS04443499Panel · crackedINSPECTION TYPE:C, LT WLG W/W FWD CANTED BULKHEAD LOWER AREA CRACKED AT STA 1241, LBL 94 AS MARKED (CLOSEOUT PANEL). CANTED BULKHEAD LT CLOSEOUT PANEL REPLACED AS PER UPS EO B747-5310-2758-E APPENDIX E.SDR SWAA043118Door Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FWD ENTRY DOOR AFT FRAME NEAR 4TH STOP FITTING FROM BOTTOM, CRACKED. REPAIRED FRAME SECTION PER SRM.SDR AWXA200401169Shear Tie · crackedDURING C-18 CHECK A .5 INCH CRACK WAS FOUND IN FRAME FOOT CLIP AT BS 986, STR 25 RT. MAINTENANCE REMOVED AND REPLACED FRAME FOOT CLIP AT BS 986, STR 25 RT IAW SRM 51-40-02, FIG. 3, 4, 6, 7, AND 8.SDR A6WA200460050Frame · crackedSUB FRAME CRACK ON ATTACH FLANGE FRAME 33BY BETWEEN STR 11 AND 12 LT. MAINTENANCE REQUESTED REPAIR FROM BAE SYSTEMS REF AVMAX FAX 6008-2049004.SDR 2004UALA00977Crease Beam · corrodedCABIN FLOOR LT CREASE BEAM INNER CHORD ANGLE CORRODED STA 676 TO STA 680, LBL 64. FABRICATED & INSTALLED NEW CHORD ANGLE.SDR SWAA043100Door Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FWD ENTRY DOOR CUTOUT FWD LOWER FRAME WEB CRACKED. REMOVED AND REPLACED FRAME WEB SECTION PER SRM.SDR SWAA043099Gusset · crackedDURING SCHEDULED 1/2D CHECK, FOUND FWD ENTRY DOOR LOWER FWD FRAME AT LOWER STOP FITTING GUSSET CRACKED. REMOVED AND REPLACED GUSSET PER SRM.SDR SWAA043093Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM WEB FROM BS 727D TO BS 747, RBL 70, CORRODED. REMOVED AND REPLACED CREASE BEAM WEB SECTION PER SRM.SDR SWAA043091Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM WEB AT BS 857, LBL 70, CORRODED. REMOVED AND REPLACED CREASE BEAM WEB SECTION PER SRM.SDR SWAA043089Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM WEB AT BS 480, LBL 69, CORRODED. REMOVED AND REPLACED CREASE BEAM WEB SECTION PER SRM.SDR ASOA04829Support Beam · crackedDURING A C-CHECK, THE CENTER ENGINE SUPPORT BEAM UPPER AND LOWER WEB AT BL0 WAS FOUND TO BE CRACKED AT THE FIRE LOOP CLIP BEYOND LIMITS. MAINTENANCE IS REPAIRING THE CENTER ENGINE SUPPORT BEAM UPPER AND LOWER WEB AT BL0 IAW EO 60053-0072.SDR ASAA0410448Beam · corrodedPAE - CORROSION ON LONGITUDINAL BEAM. REMOVED AND REPLACED LONGITUDINAL BEAM.SDR AWXA200401281Beam · corrodedSAL - MAJOR REPAIR - DURING C-04 CHECK CORROSION WAS FOUND AT FASTENER HOLES ON LOWER SILL BEAM OF BULK CARGO DOOR BETWEEN FR 60 AND FR 62, STR 38 RT. MAINTENANCE CUT OUT DAMAGE IN SILL BEAM FROM FR 60 TO FR 62, STR 38 RT; FABRICATED A FILLER AND DOUBLER; INSSDR 872SJ007Structure · corrodedLT WW UPPER LT SIDE FWD AND AFT OF NR 6 FLOOR SUPPORT HAS CORROSION. GBAMC NR04178 -OPEN-SDR ASA0440187Shear Tie · corrodedPAE - CORROSION ON SHEAR TIE. REPAIRED SHEAR TIE.
Back to JASC 5310