JASC 5315
Service difficulty reports · 44,223
Reports filed under 5315 · Fuselage Main, Floor Beam, 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 = '5315' 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 = '5315' 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 USAA2010093092165Floorbeam · corrodedCLT - Q6 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM T-CAP AT BS 986, LBL 7. REPLACED FLOORBEAM T-CAP AT BS 986, LBL 7 IAW B737 SRM 53-60-51.SDR USAA2010093092164Floorbeam · corrodedCLT - Q6 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM CAP AT BS 967 BETWEEN LBL 4.5 TO RBL 10.5. REPAIRED FLOORBEAM CAP AT BS 967 BETWEEN LBL 4.5 TO RBL 10.5 IAW B737 SRM 53-00-51 REPAIR 2.SDR IPXA10562805Floorbeam · corrodedINSPECTION TYPE:C3, WHILE WORKING NRC NR 912364 FOUND AN OUT OF ROUND FASTENER HOLE ON FLOORBEAM AT BS 440, RBL 45, WL 208. REPAIRED IAW ER NR10-4315, DATED 15, SEP 2010.SDR USAA2010092192054Floorbeam · corrodedCLT - Q6 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM T-CAP AT BS 986, LBL 45. REPLACED FLOORBEAM T-CAP AT BS 986, LBL 45 IAW B737 SRM 53-60-51.SDR USAA2010090791949Floorbeam · corrodedSAL - Q4 - MAJOR REPAIR - CORROSION ON FLOORBEAM AT BS 1016, LBL 35 ON UPPER FLANGE. REPAIRED FLOORBEAM AT BS 1016, LBL 35 ON UPPER FLANGE IAW EA 133038.SDR ASOA201001276Floorbeam · crackedBOTH RT 280 CLIP AT RBL 9 CRACKED ON UPPER CORNER. REMOVED BOTH 280 CLIPS RBL 9 IAW SRM 51-42-06, 51-42-21. LOCATED AND DRILLED NEW 280 CLIPS IAW SRM 51-42-06, 51-42-21. INSTALLED BOTH 280 CLIPS RBL 9 IAW SRM 51-42-06, 51-42-21.SDR ASOA201001274Floorbeam · crackedFS 280.090 FLOORBEAM WEB IS CRACKED LOWER RADIUS, AT LBL 11 AND BOTH FWD & AFT J CHANNELS ARE CORRODED ACROSS COCKPIT ENTRANCE. REPAIRED AND COMPLIED WITH REO 601R-53-11-926 IAW REO 601R-53-11-926, REV B. CLOSEOUT AND OPS CHECK REQ'ED. COMPLIED WITH CLOSEOUTSDR 2010FA0000948Fitting · corrodedCORROSION ON AFT CARGO COMPARTMENT FLOOR SUPPORT FITTING FR 47 LBL 28. FITTING IS LISTED AS PRIMARY STRUCTURE. NO CORROSION REMOVAL LIMITS AVAILABLE IN SRM. REPLACED FITTING WITH NEW PART.SDR USAA2010092092045Floorbeam · crackedCLT - Q2 - MAJOR REPAIR - CRACK ON FLOORBEAM WEB AT BS 710, BBL 07. REPAIRED FLOORBEAM WEB AT BS 710, BBL 07 IAW BOEING DRAWING & ROUTINE TASK CARD M2C57002.SDR USAA2010092092042Floorbeam · crackedCLT - Q2 - MAJOR REPAIR - CRACK ON LOWER CHORD OF LONGITUDINAL FLOORBEAM AT BS 685, LBL 24.8. REPAIRED LONGITUDINAL FLOORBEAM AT BS 685, LBL 24.8 IAW EA 102146.SDR USAA2010091692001Floorbeam · crackedCLT - Q6 - MAJOR REPAIR - CRACK ON FLOORBEAM T-CAP AT BS 328, RBL 11. REPLACED FLOORBEAM T-CAP AT BS 328, RBL 11 IAW B737 SRM 51-10-02 & BOEING DRAWING 65-45812.SDR DALA1021203102Support · corrodedDURING M-CHECK, FOUND CORROSION ON FLOORBEAM SUPPORT AT +Y765 FR66. REPAIRED IAW SRM 51-42-11.SDR R61A20100429Floorbeam · corrodedWHILE A/C WAS IN FOR HEAVY CHECK FOUND LEVEL 2 CORROSION ON RT LONGITUDINAL FLOORBEAM BETWEEN FR 85 AND FR 90. MX REPLACED THE RT UPPER SHEET FLOORBEAM AND PANEL SUPPORT P/N 170-86101-001, P/N 170-86150-001, P/N 170-65669-004 IAW EMB 170 SRM. A/C REMAINS IN SDR IPXA10562812Floorbeam · corrodedINSPECTION TYPE:C3, SECTION 46, MAIN DECK FLOOR STRUCTURE, FLOORBEAM HAS CORROSION AT BS 1540, RBL 30, RBL 49, RBL 52, RBL 54, AT UPR AFT STRUCTURE NUT CLIP FASTENER HOLES. REPAIRED IAW ER NR10-4400 DATED 17 SEP 2010.SDR IPXA10562811Floorbeam · corrodedINSPECTION TYPE:C3, SECTION 46, MAIN DECK FLOOR STRUCTURE, FLOORBEAM BS 1540, LBL 29.5, LBL 33, LBL 37, LBL 41 HAS CORROSION AT NUTCLIP HOLES OF UPPERBEAM. REPAIRED IAW ER NR10-4400 DATED 17 SEP 2010.SDR IPXA10562756Floorbeam · corrodedINSP TYPE:C3 LATERAL FLOORBEAM UPPER CHORD UPPER SURFACE IS CORRODED IN SEVERAL AREAS AT BS 879 BETWEEN RBL 29-41, WL 208. REPAIRED IAW ER 10-4318.SDR COEA2010090209803Floorbeam · corrodedHEAVY CK / LEVEL 2 CORROSION: FLOORBEAM 13 UPPER FLANGE LOWER SURFACE BETWEEN STRINGERS 15R & 17R HAS AREAS OF CORROSION. REQUIRES SRM SPLICE REPAIR.SDR IPXA10562371Floorbeam · corrodedINSPECTION TYPE:C3, MCB FLOOR SUPPORT UPPER PLATE IS CORRODED AT BS 900 BETWEEN RBL 25-45, WL 208. FABRICATED MCB FLOOR SUPPORT UPPER PLATE IAW DWG 144N5081 AND SRM 51-40-05-0G.SDR QXEA2010090700518Floorbeam · crackedC-CHECK - LT SIDE FS 280 BEAM CRACKED. REMOVED DRIP PANS AND INTERCOSTALS FOR AS REQUIRED IAW SRM 51-42-13-001-001-A01 AND 51-42-21-001-001-A01. DRILLED OFF CRACKED 280 BEAM IAW SRM 51-42-06-001-001-A01. ALL WORK IAW REO 670-53-11-047. PERFORMED CUT LINE ONSDR QXEA2010090700517Floorbeam · corrodedC-CHECK - COCKPIT FLOOR SUPPORT ANGLE ON FWD SIDE OF FS 280 BEAM SHOWS SIGNS OF CORROSION. REMOVED CORRODED FLOOR SUPPORT ANGLE FOR ACCESS IAW SRM 51-42-06-001-001-A01. BLENDED CORROSION IAW SRM 51-21-06-001-001-A01. ORIGINAL THICKNESS IS .063". BLENDED .015SDR R61A20100428Floorbeam · corrodedWHILE A/C WAS IN FOR HEAVY CHECK FOUND LEVEL 2 CORROSION ON LT LONGITUDINAL FLOORBEAM BETWEEN FR85 AND FR 90. MX REPLACED LT LONGITUDINAL FLOORBEAM P/N 170-65669-03 IAW EMB 170 SRM. A/C REMAINS IN CMH FOR HEAVY CHECK COMPLETION.SDR FDEA201009023249Floorbeam · crackedIN FWD CARGO MAIN DECK FLOORBEAM (FR 37) AT 27 INCHES RT OF CTR LINE. FWD FACE IS A CRACK IN THE UPPER SIDE OF THE BEAM APPROX .7500 INCH LONG REMOVED DAMAGE SECTION , INSTALLED NEW BEAM SECTION IAW SRM 53-10-15, FIG 201.SDR IPXA10562802Floorbeam · corrodedINSPECTION TYPE:C3, SECTION 46, MAIN DECK FLOOR STRUCTURE, HAS CORROSION ON FLOORBEAM, BS 1200, RBL 5, RBL 10, RBL 15, WL 208, AT NUT CLIP FASTNER HOLE, AT AFT UPR SIDE OF BEAM. REPAIRED IAW ER NR10-4390 DATED 22SEP2010.SDR IPXA10562796Floorbeam · corrodedINSP TYPE:C3 SECTION 46 MAIN DECK FLOOR STRUCTURE, HAS CORROSION ON FLOORBEAM BS 1320, RBL 29.5, RBL 33, RBL 37.5, RBL 41, WL 208, AT NUT CLIP FASTENER HOLE, AT FWD & AFT UPPER SIDE OF BEAM. REPAIR IAW ATS ER 10-4317.SDR IPXA10562440Floorbeam · corrodedINSPECTION TYPE:C3, COCKPIT FLOOR BEAM CHORD HAS AREAS OF CORROSION ON TOP AND BOTTOM SIDES BS 298 BL 0-LBL 11. R & R FLOORBEAM CHORD IAW SRM 53-00-51-1A-1; SRM 51-40-02-0G, SRM 51-40-05-0G; SRM 51-40-06-0G; SRM 51-40-08-0G; DRW NR141N5140.SDR ASOA201001218Floorbeam · corrodedFS 559+112 FLOORBEAM ANGLE BETWEEN RBL 27 - RBL 36 CORRODED. REMOVED CORROSION IAW SRM 51-21-06. FLOOR SUPPORT ANGLE CORROSION IS IN LIMITS. REMOVED 1 PERCENT OF THE MATL THICKNESS IAW SRM 53-00-00. PERFORMED LPI ON FS 559+112 FLOOR SUPPORT ANGLE BETWEEN SDR ASOA201001217Floorbeam · corrodedFS 559+112, RBL 9 - RBL 27, FLOORBEAM ANGLE CORRODED. REMOVED CORROSION IAW SRM 51-21-06. FLOOR SUPPORT ANGLE CORROSION IS IN LIMITS. REMOVED 1 PERCENT OF THE MATERIAL THICKNESS IAW SRM 53-00-00. PERFORMED LPI ON FS 559-112 RBL 9 - RBL 27 FLOOR SUPPORT SDR ASOA201001216Floorbeam · corrodedJUST FWD OF FS 559+112, RBL 9, OTBD FLOORBEAM ANGLE CORRODED. CORROSION AT FLOOR SUPPORT ANGLE IS OUT OF LIMIT OF THE ALLOWABLE DAMAGE IAW SRM 53-00-00. REMOVED FLOOR SEAT RAILS AND FILLER STRIPS RBL 9 BETWEEN FS 559.00 AND FS 574.00 TO ACCESS FLOORBEAM TOP SDR ASOA201001214Floorbeam · corrodedFS 589, LBL 9 - LBL 27, FLOORBEAM ANGLE CORRODED. REMOVED FLOOR SUPPORT ANGLE IAW SRM 51-40-11. REQUIRE INSTALLATION. FLOOR SUPPORT ANGLE CORROSION IS OUT OF LIMIT OF THE ALLOWABLE DAMAGE IAW SRM 53-00-00. LOCATED AND DRILLED UP NEW FLOOR CAP STRIP PN 601RSDR FDEA201009013222Floorbeam · corrodedBELOW LAVATORY LT NR 1 FLOORBEAM UPPER SURFACE CORROSION AT FR13B POSITION. DAMAGED FLOORBEAM WAS REPLACED. IAW SRM 51-72-10&57-40-21. REPAIR CLASSIFIED AS MINOR PER GMM 6-2-100.SDR DALA1020785522Floorbeam · corrodedCORROSION ON CABIN FLOORBEAM STA 377,BL'0' TO LBL18 AND AT RBL13. RII: Y BLENDED AREA ORG .125 L=3" X W=1.2" X D=.035 REMAINING .090 OUT OF LIMITS IAW SRM 53-00-51, FIG 101 SHEET 1,2,3 DETAIL II,III. REMOVED SPLICES AT STA 377 RBL32 & LBL34 IAW SRM 51-40-02. RSDR DALA1020850868Floorbeam · corrodedMAIN CABIN BETWEEN FS 200 LBL 1-20 FLOOR SUPPORT HAS CORROSION CPCP TASK NR46-53303 RII: N REMOVED CORROSION 1" X 1" ORIG. MAT .060 REMOVED .033 REMAINING .027 FOUND TO BE OUT OF LIMITS REMOVED FABRICATED AND INSTALLED NEW FLOOR SUPPORT IAW SRM 51-10-03 F3-01 SDR IPXA10B62360Floorbeam · crackedFLOOR SUPPORT BEAM DAMAGES AT FWD LWR CARGO STA 570. REPLACED BEAM IAW EO B747-5320-39489-A.SDR SWAA105132Floorbeam · crackedDURING SCHEDULED 26Y CHECK, FOUND FLOORBEAM UPPER CHORD CRACKED BETWEEN BS 709 TO BS 711, LBL 24.5. REPAIRED CHORD PER ER AND EA.SDR SWAA105131Floorbeam · crackedDURING SCHEDULED 26Y CHECK, FOUND FLOORBEAM UPPER CHORD CRACKED AT BS 667, LBL 24.5. REPAIRED CHORD PER ER AND EA.SDR FDEA201008313203Floorbeam · mislocatedEXISTING FASTENER HOLE AT STA 440, BL-0, AFTSIDE OF FLOORBEAM WILL BE IN THE RADIUS ON LT SIDE OF L-0 SEAT TRACK CROWN IF DRILLED. AT STA 440, BL-0 EXISTING HOLE PLUGED AND RELOCATED DUE TO DISCREPANCY EFFECTING THE PTF CONVERSION ON MAE MOD W/C NR 118350425BZSDR USAA2010091692013Floorbeam · corrodedCLT - Q2 - MAJOR REPAIR - LEVEL 1 EXFOLIATION CORROSION ON FLOORBEAM T-CAP AT BS 328, BETWEEN RBL 27 TO RBL 29. REPLACED FLOORBEAM T-CAP AT BS 328, BETWEEN RBL 27 TO RBL 29 IAW B737 SRM 53-10-51 REPAIR 5.SDR FDEA201008293186Floorbeam · misrepairedCTR CARGO - EXISTING REPAIR AT STA 1701 FLOORBEAM WEB AFT SURFACE ABOVE LONGERON 44 RT TO LONGERON, 48 RT. EXISTING REPAIR AT CTR CARGO, STA 1701 FLOORBEAM WEB AFT SURFACE ABOVE LONGERON 44 RT TO LONGERON 48 RT EVALUATED AND FOUND PREVIOUSLY ACCOMPLISHED NOT SDR USAA2010091692010Floorbeam · corrodedCLT - Q2 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM T-CAP AT BS 986, RBL 24. REPLACED FLOORBEAM T-CAP AT BS 986, RBL 24 IAW TYPICAL REPAIR 53-10-05B.SDR USAA2010090391902Floorbeam · corrodedCLT - MAJOR REPAIR - Q2 CHECK - LEVEL 2 CORROSION ON FLOORBEAM T-CAP AT ST 986, RBL 24. REPLACED FLOORBEAM T-CAP AT ST 986, RBL 24 IAW TYPICAL REPAIR 53-10-058.SDR USAA2010083191875Floorbeam · corrodedCLT - Q2 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM AT BS 967, RBL 5. REPLACED FLOORBEAM T-CAP AT BS 967, RBL 5 IAW TYPICAL REPAIR 52-10-05-B.SDR R61A20100418Floorbeam · corrodedWHILE A/C WAS IN FOR HEAVY CHECK FOUND LEVEL 2 CORROSION ON LT CENTER FLOORBEAM TOP FLANGE CORRODED AT FR 87. MX REPLACED LT CENTER FLOORBEAM IAW EMB 170 SRM. A/C REMAINS IN HEAVY CHECK FOR COMPLETION.SDR SWAA105066Floorbeam · corrodedDURING SCHEDULED 12Y CHECK, FOUND FLOORBEAM UPPER T-CAP CORRODED AT BS 328, BETWEEN RBL 13 TO RBL 55. REPAIRED T-CAP PER SRM.SDR SWAA105065Floorbeam · corrodedDURING SCHEDULED 12Y CHECK, FOUND FLOORBEAM UPPER T-CAP CORRODED AT BS 328, LBL 9. REPAIRED T-CAP PER SRM.SDR VGQY2010082900126Floorbeam · crackedHFEC OPEN HOLE INSP CARRIED OUT AND FOUND ONE HOLE ELONGATED AT BS 380 UPPER DECK FLOORBEAM UPPER CHORD FWD FLANGE RBL 15. INSURANCE CUT ON FASTENER HOLE CARRIED-OUT PER SB 747-53A2439 REV 2. FINAL HOLE SIZE 0.341". HFEC INSPECTION CARRIED-OUT PER B747 NDTMSDR VGQY2010082900125Floorbeam · crackedHFEC OPEN HOLE INSP CARRIED OUT AND FOUND ONE HOLE WITH CRACK INDICATION AT BS 340 UPPER DECK FLOORBEAM AFT FLANGE LBL 15 AT 6 O'CLOCK BY PLAIN VIEW. INSURANCE CUT ON FASTENER HOLE CARRIED-OUT PER SB 747-53A2439 REV 2. FINAL HOLE SIZE 0.341". HFEC INPECTION SDR VGQY2010082900124Floorbeam · crackedHFEC OPEN HOLE INSP CARRIED OUT AND FOUND ONE HOLE WITH CRACK INDICATION AT BS 340 UPPER DECK FLOORBEAM UPPER CHORD FWD FLANGE LBL 35 AT 12 O'CLOCK BY PLAIN VIEW. TRIMMED-OUT AND FABRICATED REPAIR FILLER AND STRAP INSTALLED PER SB B747-53A2429 REV 2.SDR DALA1020745522Floorbeam · corrodedCORROSION ON CABIN FLOORBEAM UPPER CHORD AT STA 365 FROM RBL 63-BL'0'. BLENDED AREA DIM. L=5' W=2" D=.060" FOUND TO BE OUT OF LIMITS IAW SRM 53-00-51, REMOVED OLD REPAIR IAW SRM 51-40-02. FAB, LOCATED, & DRILLED T-CHORD BEAM IAW SRM 51-40-05 & 53-00-51, INSTASDR USAA2010083091865Support · crackedCLT - Q2 - MAJOR REPAIR - CRACK ON FLOORBEAM SUPPORT AT BS 616, LBL 65. REPAIRED FLOORBEAM SUPPORT AT BS 616, LBL 65 IAW TYPICAL REPAIR 53-62-01.SDR U2RA227DHN024Floorbeam · corrodedAFT CABIN FLOOR SUPPORT CORRODED BEYOND LIMITS, MORE THAN 50 PERCENT MAT LOSS, STA 1680 FROM LBL 8 TO RBL 10.
Back to JASC 5315