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 RAIA0012039Floorbeam · corrodedMX-STL-DURING MAINTENANCE CHECK FOUND CORROSION ON FLOORBEAM 36. MAINTENANCE REMOVED AND REPLACED FLOORBEAM IAW ATR42 SRM.SDR RAIA0012038Floorbeam · corrodedMX-STL-DURING MAINTENANCE CHECK FOUND CORROSION ON FLOORBEAM 40. MAINTENANCE REMOVED AND REPLACED FLOORBEAM IAW ATR42 SRM.SDR 00FDEA00853Floorbeam · damagedNR 907 MECHANICAL DAMAGE ON FLOORBEAM BS 312, LBL 3, WL 208. ** S/D ** R&R PER FEDEX EA 7-5310-53867.SDR RRXA003652Support · crackedDURING A MAINTENANCE VISIT FOUND A CRACK TO FLOOR SUPPORT ON L/H FLANGE AT STA Y-1745 AND BL-0, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. /////CORRECTIVE ACTION///// REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR IAW DC-8 SDR USAA002058Floorbeam · corrodedCLT - FLOORBEAM T-CAP CORRODED 1 INCH, BS 947.5, LBL 50 TO RBL 50. CORROSION LEVEL 2. REMOVED AND REPLACED FLOORBEAM T-CAP TR 53-10-05A. (M)SDR USAA002059Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 1 INCHES, BS 967, LBL 41 AND 47.5. INSTALLED UPPER FLANGE/CHORD REPAIR PER TR 53-10-05A AND SRM 53-00-51. (M)SDR USAAA002061Floorbeam · corrodedCLT - FOUND FLOORBEAM T-CAP CORRODED, STATION 986.5, RBL 50 TO LBL 50. CORROSION LEVEL 2. REMOVED AND REPLACED UPPER T-CAP PER TR 53-10-05A. (M)SDR 20010125SG013Floorbeam · corrodedSAW - DURING CPCP-2 INSPECTION, MAINTENANCE REPORTED FLOORBEAM 36 AND 39 CORRODED. MAINTENANCE REMOVED AND REPLACED FLOORBEAM 36 IAW SRM 51-25-01 AND REPAIRED FLOORBEAM 39 IAW SRM 53-00-00 FIGURE 438. AIRCRAFT WAS RETURNED TO SERVICE. REF SIMA3394. (M)SDR SIMA3394Floorbeam · corrodedSAW - DURING CPCP-2 INSPECTION, MAINTENANCE REPORTED FLOORBEAM 36 AND 39 CORRODED. MAINTENANCE REMOVED AND REPLACED FLOORBEAM 36 IAW SRM 51-25-01 AND REPAIRED FLOORBEAM 39 IAW SRM 53-00-00 FIGURE 438. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR UIEA00052Frame · crackedWHILE INSPECTION FRAME STATION 1265 BELOW FORWARD END OF MAIN ENTRY DOOR NR 3 CUT OUT AT WL 199, EDDY CURRENT CHECK INDICATED CRACK INDICATIONS L/S HOLE NR 10 AND R/S AT THE 10 O'CLOCK POS. HOLES REWORKED AND CRACKS STOP HOLED AS REQUIRED. REPAIR ANGLES, DOUSDR ARWA0001217Floorbeam · corrodedN/R 629 - DURING C CHECK INSPECTION, FOUND THE FOLLOWING: MAIN CARGO COMPARTMENT FLOORBEAM AT STA LBL 45 & FS 1680 CORRODED. CORRECTIVE ACTION: CORROSION REPAIR IAW BOEING MESSAGE INW-LIM-00-00147H, DATED 10/23/00.SDR QXEA0003287Floorbeam · corrodedPDX- CORROSION ON FLOORBEAM IN CABIN BETWEEN FRAME 3870 AND 4850, BL575-640L. REPAIRED IAW FOKKER SRM 51-31-01, 51-10-04 AND 51-10-05.SDR USAA002052Floorbeam · crackedCRACK LBL 25 FLOORBEAM AT LWR FAST.S707-712, W1202.5. CORRECTIVE ACTION: FABRICATED DOUBLER PER EA 68629SDR SWAA002540Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND FLOOR BEAM CORRODED, BS 328, RBL 5 TO LBL 40. REPAIRED FLOOR BEAM PER SRM.SDR AWXA0001015Floorbeam · corrodedCABIN FLOOR BEAM FS 312 RBL 12 LBL 12 TOP OF FLOORBEAM HAS CORROSION. REMOVED CORROSION IAW SRM 53-10-13 FIG 102 FOUND TO BE OUT OF LIMITS; REMOVED FLOORBEAM UPPER T CAP AND REMOVED A STIFFENER; FABED CHORD AND INSTALLED CHORD IAW SRM 53-10-51 FIG 205 AND REINSDR AWXA0001004Floorbeam · damagedCABIN FLOORBEAM WEB AT STA 328, LBL 46 WAS DAMAGED DURING MAINT. CUTOUT DMGD WEB, FABED FILLER AND DOUBLER IAW ER 03-5310-00327-JS2, SRM 51-20-1; INSTALLED REPAIR PARTS IAW ER 03-5310-00327JS2 AND SRM 51-40-02SDR CALA0001857Floorbeam · corrodedINSPECTION FOUND FLOORBEAM UPPER CHORD CORRODED AROUND FASTENERS AT STA 1016, RBL 5 TO RBL 6. A FLOORBEAM UPPER CHORD REPLACEMENT SECTION WAS INSTALLED IAW ECRA 5310-03851.SDR CALA0001853Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 1006, LBL 6 TO LBL 27. THE CORROSION WAS REMOVED AND A REPAIR STRAP WAS INSTALLED IAW SRM 53-00-51, FIGURE 203.SDR CNMA200100003Floorbeam · corrodedLEVEL 2 CORROSION FOUND ON FLOORBEAM STATION 1841 LEFT TO RIGHT DURING C-CHECK INSPECTION. REMOVED DAMAGED AREA ON LT SIDE FROM LBL 25-30 AND RT SIDE FROM LBL 25-35. FABRICATED L-ANGLE REPAIR AND FILLER IAW SRM 53-00-01.SDR 00FDEA00848Floorbeam · corrodedN 834 DURING ROUTINE INSP, BS 400 FLOORBEAM FOUND CORRODED AT RBL 12. R&R & FAB PER IAW BAC 727 SRM 53-10-8.SDR CALA0001848Floorbeam · corrodedINSPECTION FOUND CORROSION AROUND FASTENER HOLE ON FLOORBEAM UPPER CHORD AT STA 344, LBL 21 AND LBL 42. REPAIR STRAPS WERE INSTALLED AT EACH LOCATION IAW SRM 53-00-51.SDR CALA0001845Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AROUND FASTENER HOLE AT STA 986, RBL 29. REPAIRED IAW SRM 53-00-51, PAGE 214.SDR CALA0001844Floorbeam · corrodedINSPECTION FOUND CABIN FLOORBEAM CORRODED AROUND SCREW HOLES AT STA 986.5, LBL 21 AND LBL 26. DOUBLERS WERE INSTALLED IAW SRM 53-00-51, FIGURE 203 AND INSTALLED SHIM ON INTERCOSTAL IAW ECRA 5310-03585.SDR AWXA0001014Floorbeam · corrodedCABIN FLOOR BEAM STA 312 RBL 12 - LBL 12 TOP OF FLOOR BEAM WENT OUT OF LIMITS AFTER CORROSION REMOVAL. REMOVED UPPER TEE AT STA 312 LBL 18 TO RBL 22 AND A STIFFENER AT BETWEEN STA 312 AND 328 LBL 12 IAW SRM 51-40-02; FABED AND INSTALLED CHORD IAW 53-10-51 FIG SDR RRXA003651Angle · crackedDURING A MAINTENANCE VISIT FOUND A CRACK TO THE MAIN CABIN FLOOR BEAM ATTACH ANGLE FWD SIDE AT FS 55 X+44, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. /////CORRECTIVE ACTION///// REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. RECEIVED PART AND INSTALLED IASDR USAA002046Floorbeam · corrodedCLT - FOUND FLOORBEAM T-CAP CORODED .5 INCHES, BS 986, RBL 29.5, 31.5, 36, 40 AND 43. REMOVED AND REPLACED T-CAP PER TR 53-10-05A. (M)SDR USAA002044Floorbeam · corrodedCORROSION LEVEL 1 LOWER SURFACE UPPER FLOORBEAM BS 324, LBL 12CORRECTIVE ACTION: REPLACED FLOORBEAM SUPPORT PER SRM 51-10-2SDR 00FDEA00842Floorbeam · corrodedNR 862 (C53-224-01) CORROSION ON FLOORBEAM BS 620, LBL 25, TO LBL 44.5, WL 208. ** S/D ** R&R PER FEDEX SRM 53-10-8 FIG 8.SDR 00FDEA00836Floorbeam · corrodedNR 327 CORROSION C53-224-01 ON LOWER FLANGE OF FLOORBEAM BS 1130, RBL 50 - LBL 38, WL 200. ** S/D ** R&R PER IAW FEDEX EA 7-5310-53873.SDR SWAA002502Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND BS 1016 FLOOR BEAM CORRODED AT RBL 18 TO RBL 36. REPAIRED FLOOR BEAM PER ER 00-1312.SDR DHL200080209CFloorbeam · crackedAT C CHECK; MAIN CARGO COMPARTMENT FLOOR ATTACH ANGLE BROKEN 1/2 INCH, STA 1726.00 BLD. REMOVED AFFECTED AREA IAW SRM 53-2-0 FIG 1B, CLEANED,TREATED AND PRIMED AREA IAW SRM 51-1-8B, PG 1-2, FABRICATED AND INSTALLED FILLER AND "U" ANGLE IAW SRM 53-2-0, FIG 1B. SDR 00FDEA00803Floorbeam · corrodedDURING ROUTINE INSP, THE BS 344 FLOORBEAM FOUND CORRODED BETWEEN NR 3 & 5 SEAT TRACKS. REMOVED, REPLACED AND FAB PER IAW BAC 727 SRM 53-10-8.SDR USAA002008Floorbeam · corrodedCLT - FOUND T-CAP CORRODED 3 INCHES BY 108 INCHES, STATION 312. INSTALLED T-CAP PER SRM 53-00-51. (M)SDR USAA002009Floorbeam · corrodedCLT - FOUND T-CAP CORRODED 3 INCHES BY 108 INCHES, STATION 328. INSTALLED T-CAP PER SRM 53-10-05. (M)SDR 20010125SG011Floorbeam · corrodedSAW - DURING CPCP-2 INSPECTION MAINTENANCE, REPORTED FLOORBEAMS 38 AND 39 CORRODED. MAINTENANCE REPAIRED BOTH FLOORBEAMS IAW SRM 53-00-00 FIGURE 435. AIRCRAFT RETURNED TO SERVICE. REF SIMA3322. (M)SDR SIMA3322Floorbeam · corrodedSAW - DURING CPCP-2 INSPECTION MAINTENANCE, REPORTED FLOORBEAMS 38 AND 39 CORRODED. MAINTENANCE REPAIRED BOTH FLOORBEAMS IAW SRM 53-00-00 FIGURE 435. AIRCRAFT RETURNED TO SERVICE. (M)SDR AWXA0000971Floorbeam · misinstalledCABIN FLOORBEAM AT STA 420 LBL 57.0 HAS HI-LOK WITH NO E.D. REMOVED STA 420 FLOORBEAM, FABED NEW FLOORBEAM, AND INSTALLED NEW FLOORBEAM IAW SRM 51-40-00, 53-30-51, 51-40-05.SDR SWAA002433Floorbeam · corrodedDURING SCHEDULED D CHECK AT DALFORT, FOUND FLOOR BEAM CORRODED AT BS 986.5, RBL 4.75. REPAIRED FLOOR BEAM PER SRM.SDR USAA002122Floorbeam · corrodedPIT - FOUND BEAM CORRODED 2 INCHES BY .75 INCHES, RIGHT LAVATORY FLOORBEAM STATION 1322. INSTALLED ANGLE PER SRM 53-05 FIG 20A. (M)SDR GAIA00783Floorbeam · corrodedDURING C-CHECK, FOUND FLOORBEAM SUPPORT CORRODED UNDER FORWARD LAVATORY. REPLACED FLOORBEAM SUPPORT IAW B727 SRM 51-30-2. (M)SDR GAIA00782Floorbeam · corrodedDURING C-CHECK, FOUND FLOORBEAM SUPPORT CORRODED UNDER FORWARD LAVATORY. REPLACED FLOORBEAM SUPPORT IAW B727 SRM 51-30-2. (M)SDR GAIA00774Floorbeam · corrodedDURING C-CHECK, FOUND FLOORBEAM CORRODED IN MAIN CARGO COMPARTMENT. REPAIRED FLOORBEAM WITH DOUBLER REPAIR PER TIMCO REO NR S00415. (M)SDR AWXA0000941Floorbeam · corrodedFLOORBEAM UPPER T-CHORD CORRODED AT LBL 7 - 14 FS 1016. REMOVED, FABED REPLACEMENT, AND INSTALLED IAW SRM 53-00-51 FIG 202, 51-40-03 AND DWG 65-46812.SDR AWXA0000940Floorbeam · crackedFLOORBEAM CRACKED AT FS 380 LBL 61.5. REMOVED, FABED REPLACEMENT PART, AND INSTALLED IAW SRM 51-40-02 AND DWG.SDR AWXA0000933Floorbeam · corrodedFLOORBEAM STA 986.5 LBL 20 - RBL 28 TOP OF FLOORBEAM HAS CORROSION. REMOVED CORROSION LBL 15 MAT LOSS .021 ORIG THICKNESS .125 OUT OF LIMITS; FABED AND INSTALLED REPAIR STRAP PER SRM 53-00-51.SDR CALA0001835Floorbeam · corrodedINSPECTION FOUND FORWARD GALLEY/LAV AREA FLOORBEAM SECTIONS CORRODED AT Y = 375-475, X = 30R, 46R-48R, AND 50R-60R. THE FLOORBEAM SECTIONS WERE REMOVED AND NEW SECTIONS WERE INSTALLED IAW SRM 53-11-01.SDR MALA000733Floorbeam · corrodedFOUND DURING C-CHECK, CORROSION ON UPPER ANGLE OF UNDER FLOORBEAM AT STA 258. REFER TO CELSIUS W/O 19097, TASK CARD 1521. MAINTENANCE BLENDED OUT CORROSION DAMAGE IAW SRM 51-10-10, CORROSION FOUND TO BE OUT OF LIMITS.SEE IPM 123 FORM FOR REPAIRS.SDR SWAA002425Floorbeam · corroded1/2D CHECK, FOUND FLOORBEAMS CORRODED AT BS 986.5, LBL 5, RBL 43 & BS 312, LBL 10 TO RBL 8. REPAIRED FLOORBEAMS PER T1-453-03 & SRM.SDR 2000UALA00727Floorbeam · crackedSTA 246 FLOORBEAM: ONE STIFFENER CRACKED AT RBL 38.0. THREE STIFFENERS BUCKLED AT RBL 7.88, 26.06 & 39.0. SUPPLEMENTAL DATA UPDATE, REPLACED CRACKED STIFFENER PER SRM 53-10-51. REPLACED BUCKLED STIFFENER PER SRM 53-10-51.SDR SWAA002414Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORRODED AT BS 344, LBL 38 TO RBL 24. REPAIRED FLOORBEAM PER SRM.
Back to JASC 5315