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 LR7A01008Fitting · corrodedDURING SCHEDULED C3 INSPECTION PER JOB CARD HC05297 FOUND FS 729 - 737 INTERCOSTAL FITTING CORRODED AT WL 143, LBL 60. REPLACED FITTING IAW SMP 581-53-40 PG 10.SDR MWEA010576Floorbeam · corrodedCORROSION GOUGES AND ELONGATED HOLES ON RT LAV FLOORBEAMS AT STATION 996. FABRICATED AND INSTALLED FLOORBEAM ANGLE.SDR CALA0100368Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AROUND NUT PLATE HOLES AT STA 986, RBL 4. THE CORROSION WAS CLEANED AND A STRAP REPAIR WAS INSTALLED IAW SRM 53-00-51, FIGURE 203.SDR RRXA10983Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE TO MAIN CABIN FLOOR BEAM AT STA 1640 AND LBL48, 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 53-2-0 FIG.1B AND DHSK 602SDR RRXA10982Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE TO SEAT TRACK AT STA 1580-1600 AND LBL45, 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-8 AND DHSK 602-497.SDR CALA0100367Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED ON UPPER SURFACE AROUND SCREW HOLES AT STA 967, RBL 27, LBL 6, AND LBL 27. REPAIR STRAPS AND SHIMS WERE INSTALLED IAW SRM 53-00-51, FIGURE 203, 51-20-01, AND 51-30-01.SDR AALA20010889Floorbeam · damagedTUL - FOUND RIGHT AFT LAVATORY STATION 1338 FLOORBEAM DAMAGED, CORROSION AROUND FASTENER HOLE. REPAIRED FLOORBEAM PER SRM 53-05 PART 1. (M)SDR CALA0100364Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT AND UNDER NUT PLATES AT STA 1309, BL 0 TO LBL 54.SDR 0102412288Floorbeam · corrodedIN H CHECK, FOUND CORROSION ON FLOORBEAM. REPAIRED PER EA22-182212.SDR AWXA0001609Floorbeam · corrodedFLOORBEAM AT BS 350 HAS CORROSION AND BARE METAL AROUND FLOORBOARD FASTENERS HOLES ON THE UPPER AND LOWER SURFACE OF THE TOP FLANGE FROM LBL 60 RBL 60. REMOVED EXISTENT SPLICE CHORD IAW SRM 51-40-02; FABBED EXISTENT SPLICE CHORD IAW SRM 53-00-51; INSTALLED SPSDR 20010606SG007Floorbeam · corrodedSAW - DURING CPCP-2 INSPECTION MAINTENANCE REPORTED FLOORBEAMS 36, 38, 39 AND 40 CORRODED. MAINTENANCE REMOVED AND REPLACED FLOORBEAMS 36, 38, AND 39 IAW SRM 51-25-02. MAINTENANCE REPAIRED FLOORBEAM 40 IAW SRM 53-00-00 FIGURE 436. AIRCRAFT WAS RETURNED TO SSDR 20010606SG006Floorbeam · corrodedSAW - DURING CPCP-2 INSPECTION MAINTENANCE REPORTED FLOORBEAMS 36, 38, 39 AND 40 CORRODED. MAINTENANCE REMOVED AND REPLACED FLOORBEAMS 36, 38, AND 39 IAW SRM 51-25-02. MAINTENANCE REPAIRED FLOORBEAM 40 IAW SRM 53-00-00 FIGURE 436. AIRCRAFT WAS RETURNED TO SSDR 20010606SG005Floorbeam · corrodedSAW - DURING CPCP-2 INSPECTION MAINTENANCE REPORTED FLOORBEAMS 36, 38, 39 AND 40 CORRODED. MAINTENANCE REMOVED AND REPLACED FLOORBEAMS 36, 38, AND 39 IAW SRM 51-25-02. MAINTENANCE REPAIRED FLOORBEAM 40 IAW SRM 53-00-00 FIGURE 436. AIRCRAFT WAS RETURNED TO SSDR SIMA20011175Floorbeam · corrodedSAW - DURING CPCP-2 INSPECTION MAINTENANCE REPORTED FLOORBEAMS 36, 38, 39 AND 40 CORRODED. MAINTENANCE REMOVED AND REPLACED FLOORBEAMS 36, 38, AND 39 IAW SRM 51-25-02. MAINTENANCE REPAIRED FLOORBEAM 40 IAW SRM 53-00-00 FIGURE 436. AIRCRAFT WAS RETURNED TO SSDR 2001UALA00511Floorbeam · crackedDISCREPANCIES: STA. 246 BUCKLED STIFFENER AT LBL - 7, RBL - 26.06, 50.0STA. 246 CRACKED STIFFENER AT LBL - 38.5STA. 246 CRACKED MID-CHORD AT LBL - 7 REPAIRED MID-CHORD PER SRM 53-10-51, REPAIR 2.REPLACED CRACKED AND BUCKLED STIFFENERS PER SRM 53-10-51, REPAIRSDR CALA0100335Floorbeam · corrodedINSPECTION FOUND UPPER SURFACE OF FLOORBEAM CORRODED AT STA 986.5. THE CORRODED SECTION OF FLOORBEAM T-CAP WAS REMOVED AND A NEW SECTION WAS INSTALLED USING REPAIR STRAP AND ANGLES IAW SRM 51-40-00 AND ECRA 5310-03851.SDR CALA0100324Doubler · gougedINSPECTION FOUND FWD ENTRYWAY FLOORBEAM AFT FLANGE OUTER DOUBLE STACK REPAIR DOUBLER GOUGED IN RADIUS AND ON HORIZONTAL FLANGE AT STA 312, RBL 24. THE DOUBLER WAS REMOVED AND A REPAIR ANGLE WAS INSTALLED IAW SRM 53-10-51.SDR ASAA0140051Floorbeam · corrodedPAE - DURING SI CHECK, FOUND FLOORBEAM CORRODED SEVERAL PLACED NEAR NUT PLATE HOLES AT BS 986.5, RBL 5-43, AND WL208, LEVEL 1. REPAIRED IAW SRM AND ASA EA5310-01928. (M)SDR ASAA0140050Floorbeam · corrodedPAE - DURING SI CHECK, FOUND FLOORBEAM CORRODED AT BS 1016, LBL 29 AND WL 208. REPAIRED IAW SRM AND ASA EA 5310-01925. (M)SDR 2001UALA00512Floorbeam · crackedSTA 246 MID-CHORD HORIZ LEG CRACKED AT RBL 38.5. *S/D* REPAIRED PER SRM 53-10-51, REPAIR 2.SDR 2001UALA00471Floorbeam · damagedMAIN CABIN FLOORBEAM T-CAP HAS DOUBLE DRILLED HOLES BS 790 TO 880 LBL 33. MAJOR REPAIR ACCOMPLISHEDFABRICATED AND INSTALLED REPAIR IN ACCORDANCE WITH SRM 53-00-51 AND 51-40-02.SDR 2001UALA00460Floorbeam · damagedEXCESS MATERIAL LOSS AT STA 947 FLOORBEAM RBL 16, 20, 25, 36, AND 37. FABRICATED AND INSTALLED REPAIR STRAP. MAJOR REPAIR ACCOMPLISHED.SDR SWAA011086Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND FLOOR BEAM CORRODED AT BS 986.5, RBL 35 TO RBL 45. R&R FLOORBEAM PER T1-453-037.SDR 2001UALA00459Floorbeam · damagedSTA 294 FLOORBEAM UPPER CAP HAS EXCESS MATERIAL REMOVED AT RBL 38. ACCOMPLISHED FLOORBEAM REPAIR. MAJOR REPAIR ACCOMPLISHED.SDR AWXA0001607Floorbeam · crackedREMOVE BLOCK ON BOTTOM SIDE OF UPPER FWD LIP OF FLOORBEAM AT LBL 45.5 FOR FURTHER CRACK INSPECTION BS 520. INSPECTED AND REPAIRED CRACK IAW EO 53-14-12 REV C.SDR AWXA0001604Floorbeam · crackedFLOORBEAM REPAIR RBL 25 BS 675 CRACKED. REMOVED AND REPLACED FLOORBEAM REPAIR IAW B737-200 SRM 51-20-1 PG 13 FIG 2, 51-40-02 AND 51-70-11 FIG 1 PG 1-6.SDR SWAA011096Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOOR BEAM UPPER CHORD CORRODED AT BS 328, RBL 14 & RBL 28. REPAIRED FLOORBEAM PER SRM.SDR SWAA011088Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORRODED AT BS 986, RBL 46 TO LBL 15. REPAIRED FLOORBEAM PER SWA T1.SDR UPS01435732Floorbeam · corrodedINSPECTION TYPE:C3 U/D - BS 660 LBL 38 FLOORBEAM FOUND CORROSION. U/D BS 660 LBL 38 FLOORBEAM REPAIR AS PER SRM 53-10-01 FIG.1.SDR UPS01435731Floorbeam · corrodedINSPECTION TYPE:C3 COCKPIT LATERAL FLOORBEAM UPPER CHORD CORRODED AROUND FASTENER HOLES. U/D BS 420 LBL 11 TO LBL 30 FLOORBEAM REPAIR AS PER SRM 53-10-07 FIG.8SDR UPS01435720Floorbeam · crackedINSPECTION TYPE: C3 UPPER DECK FLOORBEAM UPPER CHORD AT BS 340 RBL 44-55 FOUND THREE EACH FLOOR PANEL ATTACHMENT HOLES CRACKED AS MARKED. REPAIRED FLOORBEAM UPPER HCORD (AFT SIDE) CRACKED HOLES AS PER SB 747-53A2431 FIG.9.SDR UPS01435719Floorbeam · crackedINSPECTION TYPE: C3 UPPER DECK FLOORBEAM UPPER CHORD AT BS 360 RBL 18-58 FOUND EIGHT FLOOR PANEL ATTACHMENT HOLES CRACKED AS MARKED. REPAIRED FLOORBEAM CRACKED HOLES PER SB 747-53A2431 FIG 9.SDR UPS01435718Floorbeam · crackedINSPECTION TYPE:C3 UPPER DECK FLOORBEAM UPPER CHORD AT BS 380 LBL 32-36 FOUND TWO EACH , FLOOR PANEL ATTACHMENT HOLES CRACKED AS MARKED. REPAIRED FLOOR BEAM CRACKED HOLES PER SB 747-53A2431 FIG 7.SDR UPS01435717Floorbeam · crackedINSPECTION TYPE:C3 UPPER DECK FLOORBEAM UPPER CHORD AT BS 380 RBL 32-36 FOUND PANEL ATTACHMENT HOLES CRACKED AS MARKED. REPAIRED FLOOR BEAM CRACKED HOLES AS PER SB 747-53A2431 FIG 9 .SDR UPS01435716Floorbeam · crackedINSPECTION TYPE:C3 UPPER DECK FLOORBEAM UPPER CHORD AT BS 340 LBL 32 FOUND ONE EACH FLOOR PANEL ATTACHMENT HOLE CRACKED AS MARKED. REPAIRED CRACKED HOLES AS PER SB 747-53A2431 FIG 9.SDR UPS01435715Floorbeam · crackedINSPECTION TYPE: C3 UPPER DECK FLOOR BEAM UPPER CHORD AT BS 360 LBL 24-54 FOUND FOUR FLOORBEAM PANEL ATTACHMENT HOLES CRACKED AS MARKED. REPAIRED CRACKED HOLES PER SB 747-53A2431 FIG 9. THE REPETITIVE INSPECTION TO BE FOLLWED BY UPS & TO BE BODIED IN 3000 FLTSDR SWAA011068Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOOR BEAM CORRODED AT BS 294, BL 0 TO LBL 19. REPAIRED FLOOR BEAM PER SWA T1.SDR 01FDEA00260Floorbeam · corrodedDURING ROUTINE INSP, BS 660 FLOORBEAM FOUND CORRODED AT NR 5 SEAT TRACK. CUT OUT DAMAGED AREA. FAB AND INSTALL REPAIR PER IAW BAC 727 SRM 53-10-8.SDR 01FDEA00259Floorbeam · corrodedDURING ROUTINE INSP, BS 640 FLOORBEAM FOUND CORRODED AT 5 SEAT TRACK. CUT OUT DAMAGED AREA. FAB AND INSTALL REPAIR PER IAW BAC 727 SRM 53-10-8.SDR 0101805502Floorbeam · corrodedDURING H-CHECK FOUND CORROSION ON FLOORBEAM UPPER CAP AT BS 377 RBL 10. REPAIRED PER EA 55-183448.SDR SWAA011054Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOOR BEAM CORRODED AT BS 312, LBL 10 TO RBL 10. REPAIRED FLOOR BEAM PER SWA T1.SDR CALA0100291Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED ON UPPER SURFACE AROUND SCREW HOLES AT STA 967, RBL 27, LBL 6, AND LBL 27. REPAIR STRAPS AND SHIMS WERE INSTALLED IAW SRM 53-00-51, FIGURE 203, 51-20-01, AND 51-30-01.SDR CALA0100290Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AROUND FASTENER HOLES AT STA 947, LBL 20.5. A REPAIR WAS INSTALLED IAW ECRA 5320-01668.SDR USAA010383Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 63 INCHES SEVERAL AREAS, STATION 986.5, LBL 18-45. INSTALLED T-CAP PER TR 53-10-05 REV A. (M)SDR USAA010380Floorbeam · corrodedCLT - FOUND TOP OF FLOORBEAM CORRODED IN SEVERAL AREAS, STATION 328 RBL 12 - RBL 54. REPLACED T-CAP PER SRM 53-10-51. CORROSION LEVEL 2. REPLACED T-CAP PER SRM 53-10-51. (M)SDR USAA010379Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 32 INCHES IN SEVERAL AREAS, STATION 344, LBL 16 THROUGH RBL 16. INSTALLED NEW T-CAP FROM LBL 23 - RBL 21 PE SRM 53-10-51. (M)SDR USAA010364Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 58 INCHES, STATION 1016, LBL 29 TO RBL 29. LEVEL 2 CORROSION. REPAIR STRAP INSTALLED PER SRM 53-00-51 AND 51-10-2. (M)SDR USAA010369Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED LBL 8-14, STATION 312, LBL 8 TO RBL 14. REPAIRED PER SRM 53-10-51, FIG 205. (M)SDR UPS01835680Floorbeam · corrodedINSPECTION TYPE:C2,3 STA. 140 FLOORBEAM IS CORRODED BEYOND LIMITS BETWEEN RBL. 50 AND RBL. 60. REPAIRED FLOORBEAM I.A.W. 8110-3 APPROVED DH SK 779-363SDR ZW0A0100111Floorbeam · corrodedDURING OP 15 MAINT CHECK AT STA 965, RBL 5 INCHES AND RBL 14 INCHES, BOTTOM OF CABIN FLOORBEAM HAD A BULGE. REMOVED CORRODED SECTIONS OF FLOORBEAM. INSTALLED REPAIR DOUBLERS AND ANGLES PER SRM 53-05, FIG 79, AND ARA 17099.
Back to JASC 5315