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 ABXA010162Floorbeam · corrodedCORROSION WAS FOUND ON FLOORBEAM CAP AT STATION 303 RBL 63. MAINTENANCE INSPECTED AND REPAIRED THE AREA IAW BOEING DRAWING 141T5112 AND B767 SRM.SDR C2XA01IA099Floorbeam · crackedMYR - DURING CONTINENTAL EXPRESS C-CHECK INSPECTION, THE RIGHT HAND FLOORBEAM WAS FOUND TO BE CRACKED AT FRAME 38. MAINTENANCE PERFORMED A DOUBLER REPAIR IN ACCORDANCE WITH EMB120 SRM 51-70-05, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR AALA20010163Floorbeam · corrodedTUL - FOUND CORROSION ON TOP OF FORWARD UPPER CHORD OF FS 1130 FLOORBEAM LBL 26-60. BLENDED OUT CORROSION AND INSTALLED REPAIR STRAP PER AARD 53-10-07-1. (M)SDR SWAA010171Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND BS 747 FLOORBEAM CRACKED AT RBL 14. REPAIRED FLOORBEAM PER SRM.SDR 01FDEA00036Floorbeam · corrodedDURING ROUTINE INSP, BS 560 CABIN FLOORBEAM FOUND CORRODED BETWEEN NR 4 AND NR 5 SEAT TRACKS. REMOVED, REPLACED AND FAB PER IAW BAC 727 SRM 53-10-8.SDR TWAA0101206Floorbeam · corrodedDURING CHECK-C MAINT, FLOOR FRAME FITTING AT STA 1174, LT AFT SIDE OF AFT SERVICE DOOR WAS CORRODED. FABRICATED NEW FITTING PER DRAWING 3936091. INSTALLED PER DRAWING 5930490.SDR CALA0100048Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED IN PASSENGER CABIN AT STA 495, LT SIDE. A NEW FLOORBEAM WAS INSTALLED IAW SRM 51-31-01.SDR SWAA010165Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORRODED AT BS 860, LBL 3 & RBL 3. REPAIRED FLOORBEAM PER RA.SDR DL73K010087Floorbeam · crackedCRACKS WERE FOUND IN THE WEB OF THE LONGITUDINAL FLOORBEAM BETWEEN FS 700 AND 717. THE WEB AND CHORDS WERE INSPECTED AND REPAIRED PER S/B 737-57-1210 AT HMV.SDR MWEA010082Floorbeam · misdrilledTWO HOLES WITH IMPROPER SPACING ON UPPER TEE OF STATION 200. FABRICATED AND INSTALLED T-ANGLE AND OUTBOARD LEFT HAND SPLICES.SDR MWEA010080Floorbeam · gougedGOUGE IN FLOOR WEB AT STATION 159. FABRICATED AND INSTALLED REPAIR DOUBLER.SDR MWEA010049Floorbeam · corrodedLOWER HALF OF FLOORBEAM AT STATION 389 RIGHT HAND SIDE ABOVE FORWARD CARGO DOOR HAS EXFOLIATION AROUND LIGHTENING HOLE. FABRICATED AND INSTALLED REPAIR ANGLES.SDR ABXA010161Floorbeam · corrodedCORROSION WAS FOUND ON TOP LEG OF FLOOR BEAM FRAME 207, STATION 1518 LBL 25. MAINTENANCE INSPECTED AND REPAIRED THE AREA IAW ABX REA B653-39290-MR.SDR ASAA0140006Floorbeam · corrodedPAE - DURING SI CHECK, FOUND CORROSION ON FLOORBEAM AT BS 986.6 RBL 44 TO LBL 31, WL 208 AROUND FASTENER HOLES. REPAIRED FLOORBEAM IAW EA 5310-01891. (M)SDR SIMA0171Floorbeam · damagedSAW - DURING MBV-1 INSPECTION, MAINTENANCE REPORTED FLOORBEAM 34 HAD OVAL SHAPED HI-LOCK HOLES AT SEAT TRACK ATTACH POINT. MAINTENANCE REPAIRED THE FLOORBEAM IAW SRM 53-00-00 FIGURE 435. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR SWAA010167Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM CORRODED AT BS 814, RBL 3 & RBL 8. REPAIRED FLOORBEAM PER SRM & RA.SDR SWAA010166Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM CORRODED AT BS 773, LBL 13 TO RBL 8. REPAIRED FLOORBEAM PER RA.SDR SWAA010159Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM UPPER CHORD CORRODED AT BS 1016, LBL 10 TO LBL 20. REPAIRED FLOORBEAM UPPER CHORD PER SRM.SDR TWAA0101204Floorbeam · corrodedDURING CHECK-C MAINT FOUND IN MID CABIN ON LT SIDE, STA 940, LBL 58 INCHES, CORROSION AROUND LIGHTENING HOLE IN MEMBRANE. REMOVED CORROSION PER SRM 51-30-3, PAGE 21 PARAGRAPH 35. REPAIRED PER SRM 51-70-4, FIG 2 SHEET 2.SDR SIMA20010163Floorbeam · damagedSAW - DURING MBV-1 INSPECTION MAINTENANCE REPORTED FLOORBEAM 29 HAD AN OVERSIZED HI-LOCK HOLE AT THE LEFT AFT SEAT TRACK ATTACH POINT. MAINTENANCE REPAIRED THE FLOORBEAM IAW SRM 53-00-00 FIGURE 429. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR USAA010048Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 1 INCH BY 1 INCH, STATION 377.7, LBL 22 - LBL 48. INSTALLED FABRICATED T-CAP PER TR 53-15-01 AND SRM 53-00-01. (M)SDR USAA010050Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 2 INCH BY 4 INCH, TOP OF FLOORBEAM STATION 986.5, LBL 6-43. REPLACED FLOORBEAM PER TR 53-60-01. (M)SDR DHL2001740C08Floorbeam · corrodedAFT CARGO CROSS SECTION FLOOR ANGLE AT STA 950 HAS CORROSION AND TOO MANY DOUBLE HOLES. INSTALLED NEW ANGLE 50 X 4.75 INCHES PER B727 SRM53-10-2 AND 51-30-2.SDR TWAA0101123Floorbeam · corrodedDURING CHECK-C MAINT FOUND CORROSION ON CABIN FLOORBEAM AT STA 160, LBL 8 INCHES. MADE NEW FLOOR SUPPORT PART, INSTALLED PER SRM 51-30-02 AND SRM 51-30-05.SDR CALA0100033Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT LT MID PASSENGER CABIN, STA 857 - 899. A NEW FLOORBEAM WAS INSTALLED IAW SRM 51-31-01.SDR USAA010043Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 2 INCHES BY 5.5 INCHES, STATION 377.7, LBL 24.5. INSTALLED FABRICATED T-CAP PER TR 53-15-01 AND SRM 53-00-01. (M)SDR USAA010023Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 3 INCHES, AT 967, RBL 17 AND 31. CORROSION LEVEL 1. REPAIRED DOUBLER, TRIPLER AND FILLER PER SRM 53-30-51. (M)SDR USAA010024Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 2 INCHES BY .5 INCHES, BS 967, LBL 14-18. CORROSION LEVEL 1 C53-107-02. INSTALLED LEG REPAIR AND DOUBLER PER SRM 53-60-51 FIG 203. (M)SDR AALA20010112Floorbeam · corrodedTUL - FOUND STATION 1130 FLOORBEAM HAS CORROSION ON TOP FLANGE AT APPROX LBL 25-LBL 10. FABRICATED STRAP TREATED AND PRIMED AND INSTALLED PER SRM 53-10-07. (M)SDR SWAA010128Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM UPPER CHORD CORRODED AT BS 328, RBL 28 TO RBL 29. REPAIRED FLOORBEAM UPPER CHORD PER SRM.SDR CALA0100024Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CAP CORRODED AT STA 986, LBL 6 TO LBL 24. A REPAIR WAS INSTALLED IAW SRM 53-00-51, FIGURE 203.SDR COMA0160125Floorbeam · crackedFLOORBEAM (P/N 601R31113-67) AT FS 409 + 16 CRACKED .5 INCH (RBL 9 AND 409 + 16). REPAIRED FLOORBEAM AT RBL 9 AT FS 409 + 16 IAW WVAC EO 601R53-2110.SDR CALA0100022Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AROUND FASTENER HOLES FROM ENTRY DOOR TO SERVICE DOOR, STA 312, RBL 21 TO LBL 38. A REPAIR FLOORBEAM WAS INSTALLED IAW SRM 53-10-51, FIGURE 205.SDR UPS01435089Floorbeam · corrodedINSPECTION TYPE:C, CORROSION BEYOND LIMITS AT FLOORBEAM BS 1720 BETWEEN LBL 85 AND LBL 98. NEW SECTION SPLICED IN PER Q / NOTE 9/01.SDR COMA0110011Floorbeam · corrodedTHE AIRCRAFT SUSTAINED DAMAGE IN THE FORM OF CORROSION TO THE UPPER SURFACE OF THE CENTER OMEGA FLOORBEAM. THE OMEGA FLOORBEAM WAS REPAIRED IN ACCORDANCE WITH AERODESIGN REPORT NR 2181-11.SDR COMA0110010Floorbeam · corrodedTHE AIRCRAFT OMEGA BEAMS (P/N 120-46158-001) QTY 2, AND 120-46258-002 QTY 1, HAVE EXCESSIVE CORROSION. THE OMEGA BEAMS WERE REPLACED IN ACCORDANCE WITH AERODESIGN REPORT NR 2174-1.SDR ABXA010157Floorbeam · corrodedCORROSION WAS FOUND ON BEAM CAP AT STATION 287 BL 0- RBL 70. MAINTENANCE REPLACED THE CAP IAW B767 SRM.SDR ABXA010158Floorbeam · corrodedCORROSION WAS FOUND ON THE TOP OF FLOORBEAM CAP AT FRAME 087, STA 287, LBL 0 THROUGH LBL 20. MAINTENANCE INSPECTED AND REPLACED THE CAP IAW BOEING DRAWING 141T5111 AND B767 SRM.SDR SIMA0113Floorbeam · crackedSAW - DURING CPCP-8 INSPECTION, MAINTENANCE REPORTED THE LEFT SIDE OF FLOORBEAM 34 HAD A CRACK IN A HI-LOCK HOLE. MAINTENANCE REPAIRED FLOORBEAM 34 IAW SRM 53-00-00 FIGURE 435. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR TWAA0101109Floorbeam · corrodedDURING CHECK-C MAINT FOUND CORROSION ON FLOORBEAM AT STA 193 AND BETWEEN LBL 16 IN TO 43 IN. MADE NEW FLOOR SUPPORT EXTRUSION AND INSTALLED FLOOR SUPPORT PER SRM 51-30-0 RIVETS.SDR AWXA0001235Floorbeam · corrodedCORROSION ON TOP SURFACE OF FLOORBEAM STA 312 RBL 7 - 13. REMOVED CORROSION - AREA OUT OF LIMITS IAW UT INSP PER B737 NTM PT 1, 54-04-00; MAT THICKNESS .100, MATERIAL LOSS .022. REMOVED UPPER CHORD IAW SRM 53-10-51; FABED REPLACEMENT UPPER CHORD IAW 53-10-51SDR CALA0100013Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CAP CORRODED AT STA 344, LBL 25. A REPAIR DOUBLER WAS INSTALLED IAW SRM 53-00-51, FIGURE 203.SDR ABXA010155Floorbeam · corrodedCORROSION WAS FOUND ON T-CAP AT STA 434 RBL 44. MAINTENANCE REPLACED THE T-CAP IAW B767 SRM.SDR ABXA010156Floorbeam · corrodedCORROSION WAS FOUND ON T-CAP AT STA 632, RBL 20. MAINTENANCE REPLACED THE T-CAP IAW B767 SRM.SDR AALA20010084Floorbeam · gougedTUL - FOUND FLOOREAM GOUGED AT LBL 0 STATION 389. BLENDED GOUGE PER SRM AND INSTALLED DOUBLER PER ESO 80559 DATED 9/29/97. (M)SDR C2XA01IA057Floorbeam · corrodedYYZ - DURING C-CHECK INSPECTION, THE FLOORBEAM AT FRAME 36 WAS FOUND TO BE CORRODED. MAINTENANCE PERFORMED A DOUBLER REPAIR IN ACCORDANCE WITH ATR42-320 SRM 53-61-40, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA01IA056Floorbeam · corrodedYYZ - DURING C-CHECK INSPECTION, THE FLOORBEAM AT FRAME 38 WAS FOUND TO BE CORRODED. MAINTENANCE PERFORMED A DOUBLER REPAIR IN ACCORDANCE WITH ATR42-320 SRM 53-61-40, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA01IA055Floorbeam · corrodedYYZ - DURING C-CHECK INSPECTION, THE FLOORBEAM AT FRAME 40 WAS FOUND TO BE CORRODED. MAINTENANCE PERFORMED A DOUBLER REPAIR IN ACCORDANCE WITH ATR42-320 SRM 53-61-40, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA01IA048Floorbeam · corrodedYYZ - DURING CONTINENTAL EXPRESS C-CHECK INSPECTION, THE FLOORBEAM AT FRAME 39 WAS FOUND TO BE CORRODED. MAINTENANCE PERFORMED A DOUBLER REPAIR ON THE AFFECTED FLOORBEAM IN ACCORDANCE WITH ATR42-320 SRM 53-00-00, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SESDR SWAA010074Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM UPPER CHORD CORRODED AT BS 344, LBL 35. REMOVED AND REPLACED FLOORBEAM UPPER CHORD PER SRM.
Back to JASC 5315