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 MZZA2009071700094Floorbeam · corrodedFWD PASSENGER COMPARTMENT FLOOR STRUCTURE WET AREA FLOORBEAM AT BS 312. FOUND WITH CORROSION AROUND SCREW HOLE AT LBL 13.5 REPAIR CARRIED OUT IAW EC/RA 5321-01665.REFER TO ATTACHED FORM 44.0008 FOR SEQUENCE OF OPERATION. REFER TO L/P 0975568 FOR N DT INSPECTISDR MZZA2009071700093Floorbeam · corrodedFWD PASSENGER COMPARTMENT FLOOR STRUCTURE WET AREA FLOORBEAM AT BS 328 FOUND CORRODED AROUND SCREW HOLE AT RBL 47.5. REPAIR CARRIED IAW EC/RA 5321-01662. REFER TO ATTACHED FORM 44.0 008 FOR SEQUENCE OF OPERATION. REFER TO L/P #0975567 FOR NDT INSPECTION.SDR MZZA2009071700098Floorbeam · corrodedAFT PASSENGER COMPTMENT FLOOR STRUCTURE WET. AREA FLOORBEAM AT BS 986.5 FOUND CORROSION AROUND SCREW HOLE AT RBL 34. REPAIR CARRIED OUT THE UPPER CHORD OF THE FLOORBEAM AT STA 986 .5 BETWEEN LBL 50 AND RBL 50 IAW SRM 53-70-51, REPAIR ALTERNATIVE I, FIG 204 / SDR A6WA200940427Floorbeam · corrodedPRESSUE FLOOR SUPPORT STRUCTURE, SUPPORT FITTING CRACKED AT FS 461, RBL 9. PRESSURE FLOOR SUPPORT STRUCTURE, SUPPORT FITTING REPLACED IAW SRM 51-42-06 AND 51-42-21. (K)SDR USAA2009072791918Floorbeam · crackedCLT - Q-4 - MAJOR REPAIR - CRACK ON LONGITUDINAL FLOORBEAM AT BS 707, RBL 24.8. REPAIRED LONGITUDINAL FLOORBEAM AT BS 707, RBL 24.8 IAW US AIRWAYS EA 101266.SDR AALA20090721TUL30Floorbeam · corrodedCORROSION ON FLOORBEAM. REPLACED BEAM UPPER CHORD PER EA 737-53-006740.SDR USAA2009072891943Floorbeam · crackedCLT - Q2 - MAJOR REPAIR - CRACKS IN FLOORBEAM WEB BETWEEN BS 707 TO BS 711, LBL 07. REPAIRED FLOORBEAM WEB BETWEEN BS 707 TO BS 711, LBL 07 IAW US AIRWAYS EA 101295.SDR AALA20090721TUL26Strap · corrodedCORROSION ON FLOORBEAM STRAP. REMOVED AND INSTALLED A SERVICEABLE STRAP PER SRM 51-10-02-0G.SDR AALA20090721TUL25Strap · corrodedCORROSION ON FLOORBEAM STRAP. REMOVED AND INSTALLED A SERVICEABLE STRAP PER SRM 51-10-02-0G.SDR AALA20090721TUL24Strap · corrodedCORROSION ON FLOORBEAM STRAP. REMOVED AND INSTALLED A SERVICEABLE STRAP PER SRM 51-10-02-0G.SDR AALA20090721TUL23Strap · corrodedCORROSION ON FLOORBEAM STRAP. REMOVED AND INSTALLED A SERVICEABLE STRAP PER SRM 51-10-02-0G.SDR EIAA200900093Floorbeam · gougedLONGITUDINAL FLOOR BEAM RBL 98 BS 1350 HAS GOUGE AT UPPER CHORD. BLEND OUT OF LIMITS, REMOVED DAMAGE, FABBED AND INSTALLED REPAIR PER SRM 53-10-01, 53-30-02 AND 53-10-05SDR EIAA20090090Floorbeam · damagedBS 1660 RBL 89 FLOOR BOARD HOLE ON FLOORBEAM FALLS NEXT TO A RIVET AND EDGE OF CARGO RAIL SUPPORT. REMOVED DAMAGE, FABBED AND INSTALLED REPAIR PER SRM 51-40-04 FIG. 3.SDR EIAA20090089Floorbeam · damagedMAIN DECK FLOORBEAM BS 1700 BL 0 DRILL STRUT NEXT TO FASTENER HOLE. REMOVED DAMAGE, FABRICATED REPAIR STRAP AND FILLER AND STIFFENER PER SRM 53-10-07 FIG 2 AND 51-30-02 PG 8-9SDR FDEA200907142614Floorbeam · misrepairedFOUND ON CROSSBEAM C 61 Y-200 AN OLD REPAIR, NOT PERFORMED IAW SRM. REPAIR PERFORMED BY REPLACEMENT OF CROSSBEAM IAW SRM 51-72-10.SDR COEA2009071303901Floorbeam · crackedFOUND IN COE HEAVY CHECK: MAJOR REPAIR: LT LONGITUDINAL FLOORBEAM JUST FWD OF FRAME 33 IS CRACKED. OPENSDR COEA2009071302901Floorbeam · crackedORIGINAL/OPEN: FOUND IN COE HEAVY CHECK: MAJOR REPAIR: RT LONGITUDINAL FLOORBEAM JUST AFT OF FRAME 34 IS CRACKED.SDR COEA2009071301901Floorbeam · crackedORIGINAL/OPEN: FOUND IN COE HEAVY CHECK: MAJOR REPAIR: LT LONGITUDINAL FLOORBEAM JUST AFT OF FRAME 39 IS CRACKED.SDR ASAA0946211Floorbeam · corrodedFLOORBEAM AT STA. 312 RBL 8 CORRODED AT FASTENER. REPAIRED FLOORBEAM UPPER CHORD IAW SRM.SDR F3LA2009071700105Floorbeam · corrodedDURING C3 C-CHECK, INSP NOTED CORROSION IN AND AROUND NUT CLIP HOLES ON FLOORBEAM Y1292 RT, BETWEEN FR 66 AND FR 68. CORROSION WAS FOUND BEYOND SRM LIMITS. MX REMOVED AND REPLACED THE FLOORBEAM IAW SRM 51-44-11, 51-72-11 AND EO A0-53T-11472.SDR F3LA2009071700104Floorbeam · corrodedDURING C3 C-CHECK, INSP NOTED CORROSION IN AND AROUND NUT CLIP HOLES ON FLOORBEAM Y1292 LT, BETWEEN FRAME 66 AND FRAME 68. CORROSION WAS FOUND BEYOND SRM LIMITS. MX REMOVED AND REPLACED THE FLOORBEAM IAW A319 SRM 51-42-11 AND DWG D53475815.SDR AALA20090713TUL10Floorbeam · corrodedCABIN FLOOR AREA, FLOORBEAM CORRODED AT CLIP NUT HOLES STATION 986.5 LEFT BODYLINE 28.25 AND 30. INSTALLED DOUBLER REPAIR PER SRM 53-00-00-51-2R.SDR AALA20090713TUL09Floorbeam · corrodedCABIN FLOOR, UPPER CAP FLOOR BEAM CORRODED AT CLIP NUT HOLE STATION 986.5 LEFT BODYLINE 43. INSTALLED DOUBLER PER AARD 53-00-00-7.SDR A6WA200940389Floorbeam · crackedCROSSBEAM LWR FLANGE CRACKED AT FS 280, RBL12.00. CROSSBEAM LWR FLANGE AT FS 280, RBL 12.00. REPAIRED IAW REO 601R-53-11-171, REV D. (K)SDR USAA2009071091784Support · crackedCLT - Q4 - MAJOR REPAIR - CRACK IN FLOORBEAM SUPPORT BETWEEN BS 927 TO BS 947, BL 0. REPLACED FLOORBEAM SUPPORT BETWEEN BS 927 TO BS 947, BL 0 IAW B737 SRM 53-60-51.SDR UALA2009071001996Floorbeam · corrodedMAIN CABIN FLOORBEAM UPPER SURFACE CORRODED BS 1518 AND LBL 26-LBL30. MAJOR REPAIR ACCOMPLISHED. REMOVED DAMAGED SECTION OF FLOORBEAM BETWEEN LBL 35 TO RBL 35. FABRICATED AND INSTALLED NEW REPAIR ANGLE, SPLICE ANGLES AND SHIMS AND BACO DWG 146T5710 FOR 8 EASDR UALA2009071001994Floorbeam · corrodedCABIN FLOORBEAM STA 287 IS CORRODED RBL 88. MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGED SECTION OF FLOORBEAM BETWEEN RBL 59- RBL 88. FABRICATED AND INSTALLED SPLICE ANGLE AND STRAP.SDR UALA2009071001987Floorbeam · corrodedMAIN CABIN FLOORBEAM T-CAP CORRODED ON UPPER SURFACE OF CHORD BS 348, RBL 38 - RBL 55. MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGED SECTION OF FLOORBEAM BETWEEN RBL 45 - RBL 88. FABRICATED & INSTALLED REPAIR SPLICE ANGLES AND REPAIR STRAP.SDR ASAA0996155Floorbeam · corrodedAFT CARGO BS 890 LBL 7 TO RBL 19 T-CAP SPLICE CORROSION AROUND NUT PLATES. REPLACED T-CAP.SDR SWAA094346Floorbeam · corrodedDURING SCHEDULED 24Y CHECK, FOUND CENTER WING BOX LONGITUDINAL FLOORBEAM CORRODED AT BS 670, BBL 0.07. REPAIRED BEAM PER EA.SDR SWAA094344Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 662, BBL 0.07. REPAIRED BEAM PER EA.SDR TRBACPCP20090016Floorbeam · corrodedFRAME 39 FLOORBEAM HAS CORROSION. REMOVED AND REPLACED FLOORBEAM AT FR39 IAW EO E2-5300-030.SDR TRBACPCP20090015Floorbeam · corrodedFRAME 36 FLOORBEAM HAS CORROSION. REMOVED AND REPLACED FLOORBEAM AT FR36 IAW EO NR E2-53EP-204.SDR USAA2009071691845Floorbeam · corrodedCLT - Q-4 - MAJOR REPAIR - NR 03C10753060/007 - LEVEL 2 EXFOLIATION CORROSION ON FLOOR BEAM UPPER T-CAP AT BS328 BETWEEN LBL34 TO RBL65. REPAIRED FLOORBEAM UPPER T-CAP AT BS328 BETWEEN LBL34 TO RBL65 IAW B737 SRM 53-10-51.SDR USAA2009071091786Floorbeam · corrodedCLT - Q4 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION IN FLOORBEAM AT BS 986, LBL 4. REPAIRED FLOORBEAM AT BS 986, LBL 4 IAW US AIRWAYS TYPICAL REPAIR 53-60-01 REV A.SDR SWAA094325Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 670, BBL 0.07. REPAIRED BEAM PER EA.SDR SWAA094324Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 669, BBL 0.07. REPAIRED BEAM PER EA.SDR SWAA094323Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 668, BBL 0.07. REPAIRED BEAM PER EA.SDR SWAA094320Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 661, BL 0. REPAIRED BEAM PER EA.SDR SWAA094303Floorbeam · corrodedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM CORRODED AT BS 675, BBL 0.07. REPAIRED BEAM PER SWA EA.SDR IPXA09556730Floorbeam · crackedINSPECTION TYPE: C2 FOUND CRACKS AND PULLED THROUGH RIVETS ON TOP OF FLOOR SUPPORT (HAT CHANNEL) BETWEEN RBL 24.75 AND BL 0 AT STA 1020. REMOVED AND REPLACED FLOOR SUPPORT DOUBLER.SDR IPXA09556729Floorbeam · corrodedINSPECTION TYPE: C2 CORROSION ON TOP OF LONGITUDINAL FLOORBEAM, RBL 23.75 AT BS 1054. BLENDED CORROSION OUT OF LIMITS, REMOVED AND REPLACED WITH NEW SEAT TRACK IAW SRM 51-40-08, 51-40-05 AND 5300-52-1A1.SDR IPXA09656624Attach Angle · crackedINSPECTION TYPE:7C AFT OF BULK CARGO COMPT STA 1582 LBL 81 MAIN DECK FLOORBEAM O/B ATT ANGLE FOUND CRACKED. MAIN DECK DOOR BEAM O/B ATTACH ANGLE AT BS 1582 LBL 81 AREA REPLACED AND INSTALLED AS PER SRM 51-10-02 AND 51-40-02 REV 44.SDR IPXA09656607Attach Angle · crackedINSPECTION TYPE:7C AFT OF BULK CARGO COMPT STA 1582 LBL 80 MAIN DECK FLOORBEAM ATTACH ANGLE FOUND CRACK. MAIN DECK FLOORBEAM ATTACH ANGLE AT BS 1582 LBL 80 AREA REPLACED AND INSTALLED AS PER SRM 51-10-02 AND 51-40-02 REV 44.SDR SWAA094267Splice · corrodedDURING SCHEDULED 6Y CHECK, FOUND AFT CARGO PIT FLOOR BUTT SPLICE CORRODED AT BS 772, LBL 16. REPAIRED SPLICE PER SWA EA.SDR IPXA09656599Attach Fitting · crackedINSPECTION TYPE:C MAIN EQUIPMENT CENTER STA 246 LBL 50 CLIP FOUND CRACK (CRACK 1 INCH LENGTH). MAIN EQUIPMENT CENTER STA 246 LBL 50 FLOORBEAM ATTACH CLIP REPLACED AND INSTALLED AS PER SRM 51-10-02 AND 51-40-02 REV 44.SDR USAA2009071391812Floorbeam · corrodedSAL - C7 - MAJOR REPAIR - NR 6205979 - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM BETWEEN FR66+ 5 INCHES TO FR67 + 17 INCHES, -Y1162. REPLACED FLOORBEAM BETWEEN FR66+ 5 INCHES TO FR67 + 17 INCHES, -Y1162 IAW A320 SRM 51-72-11. THIS DISCREPANCY IS DETERMINED TO BSDR A6WA200940390Floorbeam · crackedFS 280 UPPER AFT ANGLE CRACKED AT LBL 12.00, FS 280 UPPER AFT ANGLE AT LBL 12.00 REPAIR CARRIED OUT IAW REO 601R-53-11-138. (K)SDR USAA2009071091778Floorbeam · corrodedCLT - Q4 - MAJOR REPAIR - INTERGRANULAR CORROSION ON FLOORBEAM T-CAP AT BS 986, RBL 16. REPLACED FLOORBEAM T-CAP AT BS 986, RBL 16 IAW US AIRWAYS TYPICAL REPAIR 53-60-01.SDR FDEA200907022460Floorbeam · unknownFLOORBEAM AT BS 1640 REPLACEMENT DUE TO EXISTING FLOORBEAM REPAIRS. REMOVED FLOORBEAM AT BS 1640, PER SRM 51-40-02. FABBED NEW FLOORBEAM FROM BAC 1518-338, BATCH 0001501784, PER BOEING DWG 146N5109. LOCATED AND DRILLED NEW FLOORBEAM PER SRM 51-40-02. ANNODIZED
Back to JASC 5315