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 SWAA010315Floorbeam · crackedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM CRACKED AT BS 787, RBL 13. REPAIRED FLOORBEAM PER SRM.SDR DHL2001367506Floorbeam · damagedC CHECK, HINGED FLOORBEAMS AT FR 54 HAVE EXCESSIVE PLAY N/R 78796. REPAIRED HINGED FLOORBEAM IAW SRM 53-15-00-1 & FSI SB94FS494-53-12. REFITTED FLOORBEAM.SDR TWAA0102305Bracket · crackedDURING CHECK-C MAINT IN THE FWD CARGO COMPT BILGE, STA 237, BETWEEN LONGERON 29R AND 28R, ANGLE BRACKET WAS CRACKED IN RADIUS IN INTERCOSTAL AFT END UNDER TIE DOWN TRACK. INSTALLED NEW BRACKET PER DRAWING 9915554.SDR CALA0100082Floorbeam · corrodedINSPECTION FOUND CABIN FLOORBEAM CORRODED AROUND NUT PLATE HOLES AT STA 986.5, LBL 18 - 31. A DOUBLER WAS INSTALLED IAW SRM 53-60-51, FIGURE 203.SDR ASAA0110025Floorbeam · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND FLOORBEAM ANGLE AT BS 986, LBL 39, CORRODED. REPAIRED PER SRM. (M)SDR 0101201146Floorbeam · damagedDURING M-CHECK, MAIN CABIN FLOORBEAM AT BS 1293 WAS FOUND SEVERED AT LBL 106 AND CRACKED AT RBL 106 JUST INSIDE OF NR 3 LT AND NR 3 RT DOORS. REPAIRED PER EA 11-180795.SDR USAA010070Floorbeam · corrodedCLT - FOUND FLOORBEAM T-CAP CORRODED .5 INCH, STATION 947, LBL 4 TOP OF FLOORBEAM. INSTALLED NEW T-CAP SECTION PER SRM 53-00-51. (M)SDR USAA010074Floorbeam · corrodedCLT - FOUND FLOORBEAM TOP CAP CORRODED .75 INCH BY .75 INCH, BS 967, RBL 29.5 AND RBL 30. INSTALLED REPAIR PARTS PER SRM 53-00-51 FIG 201 AND 202. (M)SDR USAA010091Floorbeam · crackedCLT - FOUND FLOORBEAM CRACKED 1 INCH, STATION 663, LBL 0.0. INSTALLED DOUBLER AND ANGLES PER SRM 53-10-9. (M)SDR GAIA01035Floorbeam · crackedTHIS ITEM WAS FOUND DURING ROUTINE MAINTENANCE AT THE TIMCO OSC MAINTENANCE FACILITY. FLOORBEAM UPPER SURFACE OF UPPER CHORD AT BS 420, RBL 45 IS CORRODED. REPAIRED FLOORBEAM AT BS 420 RBL 45 IAW B727 SRM 53-10-8 AND 51-30-2. FABRICATED REPAIR ANGLES IAW B7SDR GAIA01032Floorbeam · misdrilledTHIS ITEM WAS FOUND DURING ROUTINE MAINTENANCE AT THE TIMCO OSC MAINTENANCE FACILITY. FLOORBEAM UPPER CAP AT BS 360, RBL 63 HAS DOUBLER DRILLED HOLES. REMOVED DAMAGES SECTION OF FLOORBEAM. FABRICATED REPAIR ANGLE IAW B727 SRM 53-10-8. INSTALLED REPAIR IAW SDR GAIA01028Floorbeam · misdrilledTHIS ITEM WAS FOUND DURING ROUTINE MAINTENANCE AT THE TIMCO OSC MAINTENANCE FACILITY. FLOORBEAM UPPER CAP AT BS 344 HAS SEVERAL HOLES WITH NO EDGE DISTANCE. REMOVED AND REPLACED FLOORBEAM UPPER CAP AT BS 344 FROM RBL 67 TO LBL 67 IAW B727 SRM 53-10-2 AND 51-SDR GAIA01023Floorbeam · corrodedTHIS ITME WAS FOUND DURING ROUTINE MAINTENANCE AT THE TIMCO OSC MAINTENANCE FACILITY. CABIN FLOORBEAM FOUND CORRODED ON UPPER SURFACE OF UPPER CHORD AT BS 400, RBL 45. REMOVED CORROSION FROM UPPER BEAM IAW B727 SRM 51-10-6, FOUND TO BE OUT OF LIMITS. FABRICSDR GAIA01020Floorbeam · corrodedTHIS ITEM WAS FOUND DURING ROUTINE MAINTENANCE AT THE TIMCO OSC MAINTENANCE FACILITY, BS 1090 CABIN FLOORBEAM IS CORRODED AT THE LOWER CHORD AS SEEN FROM THE AFT CARGO COMPARTMENT, RBL 10 TO RBL 23. REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS. FABRICATEDSDR TWAA0101923Floorbeam · corrodedDURING CHECK-C MAINT, IN THE AFT CABIN, FLOORBEAM CORROSION WAS REMOVED BEYOND LIMITS AT STA 1338, LBL 19 AND LBL 26. INSTALLED REPAIR PER SRM 53-05, FIG 20A, PAGE 31.SDR TWAA0101912Floorbeam · corrodedDURING CHECK-C MAINT, FOUND INTERCOSTAL CORRODED, ATOP FLOORBEAM AT STA 1250, LBL 23 TO 46. REPLACED CORRODED FLOORBEAM SUPPORT AND INSTALLED FASTENERS PER SRM 51-30-05.SDR CALA0100079Floorbeam · corrodedINSPECTION FOUND AFT LT LAV FLOORBEAM CORRODED AT STA 1322, LBL 41. THE CORROSION WAS TRIMMED OUT AND A DOUBLER, REPAIR STRIP, AND SHIM WERE INSTALLED IAW SRM 53-05, FIGURE 20A, 51-30-2, AND 51-30-5.SDR AT0100073Floorbeam · corrodedFOUND FLOORBEAM AT BS 1016 UPPER FORWARD FLANGE CORRODED. REMOVED, FABRICATED AND INSTALLED REPAIR BEAM IAW REO-L00367 REV D.SDR QXEA0100208Floorbeam · corrodedYYC- CORROSION ON SURFACE OF FLOORBEAM STRUCTURE INBOARD OF SERVICE EMERGENCY DOOR SURROUND. REPAIRED IAW FOKKER SRM 51-10-4 PAGE 9AND 53-01-01 PAGE 6.SDR QXEA0100207Bracket · crackedYYC- FLOORBEAM BRACKET IS CRACKED AT FRAME 4175, INBOARD OF MAIN CABIN DOOR. REPAIRED IAW FOKKER SRM 51-31-01.SDR QXEA0100132Floorbeam · corrodedYYC- CORROSION ON SURFACE OF FLOORBEAM STRUCTURE, INBOARD OF SERVICE EMERGENCY DOOR SURROUND. REPAIRED IAW FOKKER SRM 51-10-4 PAGE 9.SDR RRXA010655Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE TO THE FLOORBEAM CENTER WING STA 879, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED PART AND INSTALLED IAW E.O.01-024 WITH APPROVED 8110-3 DATED 01/29/0SDR SWAA010260Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM UPPER CHORD CORRODED AT BS 1016, LBL 15. REPAIRED FLOORBEAM UPPER CHORD PER SRM.SDR AALA20014021Floorbeam · corrodedAFW - FOUND CORROSION ON 1640 LBL 25 FLOORBEAM 2 INCHES WL RT. CORROSION ON 1640 AT WL FLOORBEAM 8 INCHES RIGHT. INSTALLED REPAIR STRAP FROM 301.5 H STAINLESS STEEL .50 THICKNESS. PER ATTACH ALODINE ALL BARE METAL SURFACE. FINISH BLEND AND REPAIRS PARTS WISDR RRXA10836Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE TO MAIN CABIN FLOOR BEAM AT STA. 1723 AND LBL 8 TO 24 ON T CORD, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED REPAIR AND INSTALLED IAW DC-8 SRM 51-1-21SDR TWAA0101903Floorbeam · crackedDURING CHECK-C MAINT, FOUND CRACKED FLOOR SUPPORT AT STA 948, LBL 6. FABRICATED NEW SUPPORT PER DRAWING 5930560-61. INSTALLED PER SPM 6-70-01 AND SRM 51-01. TYPE FASTENERS PER SRM 51-30-2. PRIMED PER SRM 51-10-3.SDR AALA20010145Floorbeam · crackedTUL - FOUND FLOORBEAM IN CENTER CARGO AT STATION 1701 CRACKED ABOVE LONGERON 45R. REPLACED 40 INCHES OF FLOORBEAM AT STATION 1701 ON RIGHT SIDE PER SRM 53-60-01 VOL I. (M)SDR USAA010169Floorbeam · corrodedPIT - FOUND BEAM CORRODED 1 INCH BY 4 INCHES BY .014 INCH, FLOOR DECK SUPPORT 1250 LBBL AFT STATION 767. CORROSION LEVEL 1, TASK C53-202-01. INSTALLED DOUBLER PER TYP REPAIR 53-10-06B. (M)SDR USAA010168Floorbeam · corrodedPIT - FOUND SUPPORT BEAM CORRODED 1 INCH BY 4 INCHES BY .011 INCH, FLOOR DECK SUPPORT 300 LBBL AFT STATION 767. CORROSION LEVEL 1, TASK NR C53-202-01. INSTALLED DOUBLER PER TYP REP 53-10-06B. (M)SDR USAA010167Floorbeam · corrodedPIT - FOUND BEAM CORRODED 1 INCH BY 4 INCHES BY .016 INCH, FLOOR DECK SUPPORT 810 RBBL AFT OF STATION 767. CORROSION LEVEL 1, TASK NR C53-202-01. INSTALLED DOUBLER PER TYP REPAIR 53-10-068. (M)SDR USAA010166Floorbeam · corrodedPIT - FOUND BEAM CORRODED 1 INCH BY 5 INCHES BY .011 INCH, FLOOR DECK SUPPORT 810 LBBL AFT OF STATION 767. CORROSION LEVEL 1, TASK NR C53-202-01. INSTALLED DOUBLER PER TYP REPAIR 53-10-068. (M)SDR USAA010165Floorbeam · corrodedPIT - FOUND BEAM CORRODED 1 INCH BY 4 INCHES BY .017 INCH, DECK STRUCTURE 810 LBBL AFT STATION 727D. CORROSION LEVEL 1, TASK NR C53-202-01. INSTALLED DOUBLER PER TYP REPAIR 53-10-20. (M)SDR USAA010068Floorbeam · corrodedCLT - FOUND T-CAP CORRODED 20 INCHES, LBL 55 TO RBL 55 STATION 1640 ENTIRE LENGTH OF T-CAP. FABRICATED FILLER AND REPAIR DOUBLER PER EA 68897. (M)SDR USAA010067Floorbeam · corrodedCLT - FOUND BEAM CHORD CORRODED 3 INCHES, FLOORBEAM 328 UPPER CHORD LBL 33 - RBL 65. INSTALLED REPAIR DOUBLER AND T-CAP PER SRM 53-10-54 FIG 205. (M)SDR SWAA010209Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAMS CORRODED AT BS 294, LBL 13 TO RBL 51, BS 312, LBL 8 TO RBL 8 & BS 328, LBL 30. REPAIRED FLOORBEAMS PER SRM.SDR SWAA010208Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAMS CORRODED AT BS 967, RBL 51, RBL 41, RBL 27, RBL 4 & BS 329, RBL 65. REPAIRED FLOORBEAMS PER SRM.SDR CALA0100066Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 947 BETWEEN LBL 27 AND RBL 5. THE FLOORBEAM WAS REPAIRED BY INSTALLING SPLICES IAW ECRA 5310-04095.SDR CALA0100061Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 481. THE FLOORBEAM WAS REMOVED AND A NEW FLOORBEAM WAS INSTALLED IAW SRM 53-11-01.SDR MWEA010112Fastener · missingCABIN FLOORBEAM UPPER ANGLE, STATION 160, AFT SIDE, HAS SIX UNFILLED FASTENER HOLES. FABRICATED AND INSTALLED SPLICE ANGLES.SDR MWEA010110Floorbeam · chafedCENTER FLOOR SUPPORT IS CHAFING INTO FLOORBEAM AT STATION 484. FABRICATED AND INSTALLED FILLERS AND REPAIR ANGLES.SDR USAA010057Floorbeam · corrodedCLT - FOUND BEAM CHORD CORRODED 56 INCHES, FLOORBEAM 312, LBL 17.5 INCH TO RBL 11 INCH. NEW T-CAP SECTION INSTALLED PER SRM 53-10-51 AND 51-20-01. (M)SDR USAA010058Floorbeam · corrodedCLT - FOUND CORROSION ON FLOORBEAM 1 INCH BY 1 INCH, STATION 344, LBL 12 - RBL 12 UPPER CHORD SURFACE. INSTALLED REPAIR PART AND ANGLES PER SRM 53-10-51 FIG 205. (M)SDR USAA010056Floorbeam · crackedCLT - FOUND FLOORBEAM CRACKED .5 INCH, STATIN 520, RBL 45 IN RADIUS UPPER CHORD/WEB. INSTALLED REPAIR PER SRM 53-00-51 FIG 201. (M)SDR USAA010059Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 24 INCHES, STATION 312, LBL 12 TO RBL 12. CORROSION LEVEL 2 C53-107-01. SPLICED IN NEW T-CAP SECTION PER TR 53-10-13. (M)SDR UPS01834839Floorbeam · crackedINSPECTION TYPE:C1&3, STA 680 LBL 48 VERTICAL FLOORBEAM SUPPORT ANGLE IS CRACKED. REMOVED, FABRICATED AND REPLACED ANGLE IAW DWG 5773275, AND SRM 51-1-20D.SDR COMA0160140Floorbeam · crackedFLOORBEAM (P/N 600-34017-17) AT FS 280.00 HAS A 2 INCH LONG CRACK. TRIMMED OUT CRACKED AREA, LPI, FABBED REPAIR ANGLE AND INSTALLED IAW WVAC EO 601R-53-2100.SDR UPS01435084Floorbeam · corrodedINSPECTION TYPE:C, CORROSION ON UPPER SURFACE OF HORIZ FLANGE MAIN CABIN FLOORBEAM AT BS 260 BETWEEN RBL 35 AND RBL 48. REPAIRS ACCOMPLISHED PER FLS QUERY NOTE 17 / 01 REFERENCE ALSO QUERY NOTE 19 / 01.SDR NACA2001009Floorbeam · corrodedFLOORBEAM AT BS 1090, LBL 62.5 CORRODED. REMOVED CORRODED AREA, FABBED AND INSTALLED REPAIR PARTS PER SRM 53-10-8 FIG 8.SDR SWAA010177Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM CORRODED AT BS 727A, RBL 3. REPAIRED FLOORBEAM PER SRM.SDR CALA0100049Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 986.5, LBL 15. A REPAIR STRAP WAS INSTALLED IAW ECRA 5310-04093.
Back to JASC 5315