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 RRXA991063Floorbeam · crackedDURING A MAINTENANCE VISIT FOUND CRACKS, FUSELAGE, FLOORBEAM AT STA 160 AND STA 180, BL 40 LEFT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED STRAPS, ANGLES, AND DOUBLERS IAW FAA APPROVED TSDR RRXA991062Floorbeam · crackedDURING A MAINTENANCE VISIT FOUND CRACKS, FUSELAGE, FLOORBEAM, AT STA 160 AND STA 180, CRACKED AT APPROX BL 40 LEFT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED STRAPS, ANGLES, AND DOUBLERSSDR AWXA9900050Floorbeam · corrodedDURING ROUTINE MAINTENANCE CHECK, FOUND CORROSION ON UPPER FLOORBEAM T CAP AT STATION 986.5 LBL 18 TO RBL 18. REPAIRED PER ER 3-53-16-35A.SDR AWXA9900049Floorbeam · corrodedDURING ROUTINE MAINTENANCE CHECK, FOUND CORROSION ON UPPER FLOORBEAM T CAP STATION 947.5 LBL 9 TO RBL 9. REPAIRED PER SRM 51-10-02, 51-20-01.SDR AWXA9900048Floorbeam · corrodedFOUND DURING ROUTINE MAINTENANCE CHECK, FLOORBEAM STA 967 LBL 28 TO LBL 50 CORRODED IN SEVERAL AREAS. FABRICATED REPAIR SECTION OF UPPER T CHORD PER SRM 53-00-51 PAGES 207 TO 211.SDR UPS99228611Floorbeam · corrodedINSPECTION TYPE-SI, CORROSION ON LOWER SURFACE OF FLOORBEAM AT BS 600, RBL 12 TO RBL 21 WL 200. REMOVED CORROSION AND REPAIRED FLOORBEAM PER ER 99-5042P3.SDR SWAA990200Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORROSION AT BS 727, 772, 941 AND 965. REPAIRED PER BOEING SRM.SDR RRXA991070Floorbeam · damagedDURING A MAINTENANCE VISIT FOUND A TRIM OUT, FUSELAGE, LONGITUDINAL FLOORBEAM AT BL 11.5 RIGHT FROM STA 21 TO STA 25 IN THE UPPER HORIZONTAL FLANGE AND A BLEND OUT IN THE VERTICAL FLANGE. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAWSDR AALA994018Floorbeam · corrodedAFW - FLOORBEAM AT STATION 764 HAD CORROSION BLENDED BEYOND SRM LIMITS. ALODINE ALL BARE ALUMINUM SURFACES FINISH BLENDED AREAS WITH 2 COATS OF PRIMER. FILL BLEND WITH BMS5-95. (M)SDR AALA990130Floorbeam · corrodedTUL - FOUND CORROSION ON FLOORBEAM AT STATION 819 ABOVE STRINGER 43L. SPLICED IN NEW SECTION OF FLOORBEAM PER AARD 51-01-00 AND SRM 53-10-01. (M)SDR GTIA990892Floorbeam · corrodedMHV - AFT CARGO FS 955 RBL 24 EVIDENCE OF MODERATE TO HEAVY LOAL CORROSION ON FLOORBEAM UPPER CAP. REMOVED AND REPLACED UPPER CAP FABRICATED NEW CAP FROM 7075T6511 EXTRUSION S912758T PO NR 81788. INSTALLED FASTENER PER DC9 SRM 51-30-1 FOR TORQUE OF BOLTS DC9SDR AALA994020Floorbeam · corrodedAFW - FLOORBEAM AT STATION 347 HAD CORROSION BLENDED BEYOND SRM LIMITS. ALODINE AND FINISH THE BLENDED AREAS WITH 2 COATS PRIMER. FILL BLENDS WITH BMS5-95 AND INSTALLED SKIN AS REQUIRED. (M)SDR SWAA990189Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND CARGO FLOORBEAM CORRODED AT BS 732D. REPAIRED PER SWA RA 1-353-1995.SDR AALA994022Floorbeam · corrodedAFW - FLOORBEAMS AT LBL AND RBL 11 HAD CORROSION BLENDED BEYOND SRM LIMITS. BLEND OUT CORROSION AND ROTO PEEN THE REWORKED AREA PER SRM. ALODINE ALL BARE ALUMINUM SURFACES. FINISH BLEND AREAS WITH 2 COATS PRIMER. FILL BLENDS WITH BMS 5-95. (M)SDR AALA994019Floorbeam · corrodedAFW - FLOORBEAMS AT LBL AND RBL 33 HAD CORROSION BLENDED BEYOND SRM LIMITS. BLEND OUT CORROSION AND ROTO PEEN THE REWORKED AREA PER SRM. ALODINE ALL BARE ALUMINUM SURFACES. FINISH BLENDED AREAS WITH 2 COATS PRIMER. FILL BLENDS WITH BMS5-95. (M)SDR AALA994017Floorbeam · corrodedAFW - FLOORBEAM AT STATION 325 HAD CORROSION BLENDED BEYOND SRM LIMITS. ACCOMPLISHED IAW SKETCHES. ALODINE AND PRIME STRAP TO INSTALL. (M)SDR AALA993041Floorbeam · corrodedAFW - FLOORBEAM AT LBL 54.81 STATION 906 HAD CORROSION BLENDED BEYOND SRM LIMITS. BLEND OUT CORROSION AND ROTO PEEN THE REWORKED AREA PER SRM. ALODINE ALL BARE ALUMINUM SURFACES. FINISH BLENDED AREAS WITH 2 COATS PRIMER. FILL BLENDS WITH BMS5-95. (M)SDR C2XA99IA081Floorbeam · corrodedIAH - DURING C-CHECK INSPECTION, THE FLOORBEAM AT FRAME 38 WAS FOUND CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED FLOORBEAM IAW ATR 42-320 SRM 51-21-28, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. ACFT TT: 20,370.2 HOURS. CYCLES: 21,34SDR SWAA990172Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CRACKED AT BS 488. SPLICED IN NEW SECTION PER SWA BOEING SRM.SDR SWAA990171Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORROSION AT BS 986.5, LBL 4. REPAIRED DAMAGED SECTION PER SWA RA 1-353-1993.SDR SWAA990170Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORROSION AT BS 787 TO 847, LBL 3. REPLACED SECTION PER BOEING SRM.SDR RRXA991150Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, CABIN FLOORBEAM LOWER ATTACHING CHORD AT STA 1727, BETWEEN BL 24 RIGHT AND BL 0. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED ATTACHINGSDR USAA990024Floorbeam · crackedCLT - DURING Q-6 CHECK VISUAL INSPECTION, FOUND A .20 INCH CRACK STATION 520 LBL 25 FLOORBEAM. INSTALLED DOUBLER AND REPAIR ANGLES PER EA 63326, SB 737-53-1120. (M)SDR USAA980685Floorbeam · crackedCLT - DURING Q-6 CHECK VISUAL INSPECTION, FOUND A 1 INCH LONG CRACK IN FLOORBEAM STATION 520 RBL 45. INSTALLED DOUBLERS AND FILLERS PER SB 737-53-1120 AND EA 63326. (M)SDR USAA980684Floorbeam · crackedCLT - DURING Q-6 CHECK VISUAL INSPECTION, FOUND A 1 INCH LONG CRACK IN FLOORBEAM STATION 520 RBL 25. INSTALLED DOUBLERS AND FILLERS PER SB 737-53-1120 FIG 28 EA 63326. (M)SDR USAA980683Floorbeam · crackedCLT - DURING Q-6 CHECK VISUAL INSPECTION, FOUND A 1 INCH LONG CRACK IN FLOORBEAM STATION 520 LBL 45. INSTALLED DOUBLERS AND FILLERS PER S/ 737-53-1120 EA 63326. (M)SDR SWAA990165Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND UPPER FLOORBEAM CHORD CRACKED AT BS 947. REPLACED PER BOEING SRM.SDR SWAA990163Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM UPPER T CHORD CORRODED AT BS 294.5. REPLACED PER BOEING SRM.SDR RRXA991055Floorbeam · misdrilledDURING A MAINTENANCE VISIT, FOUND DOUBLE DRILLED, FUSELAGE, FLOORBEAM SUPPORT AT STA 380. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR ANGLE AND DOUBLERS IAW FAA APPROVED TIMCO DER ESDR AT9900163Floorbeam · corrodedSCHEDULED INSPECTION AT AERO CORP, FL. FOUND CABIN FLOORBEAM CORRODED AT FASTENERS HOLES OF UPPER FLANGE AT BS 967 RBL 48. REMOVED CORROSION, FABRICATED REPAIR, ALODINED, PRIMED, AND INSTALLED IAW B737 SRM 53-10-9 FIG 2, 51-20-2, AND 51-21-31.SDR SWAA990155Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CARGO FLOORBEAM CORRODED AT BS 727E+3. REPAIRED PER BOEING SRM.SDR SIMA990221Floorbeam · damagedSAW - DURING CPCP-2 INSPECTION, FOUND THE LEFT AFT OUTBOARD SEAT TRACK FLOORBEAM 35 DAMAGED. SPLICED FLOORBEAM IAW SRM 53-00-00 FIGURE 438. AIRCRAFT RETURNED TO SERVICE. (M)SDR RRXA991051Floorbeam · damagedDURING A MAINTENANCE VISIT, FOUND DRILL DAMAGE, FUSELAGE, FLOORBEAM AT FS 960 IN THE CAP AND VERTICAL FLANGE. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR ANGLE AND DOUBLERS IAW FAA SDR AALA994023Floorbeam · corrodedAFW - FLOORBEAM AT STATION 347 HAD CORROSION BLENDED. FABRICATE REPAIR STRAP. ALODINE ALL BARE ALUMINUM SURFACES. FINISH BLEND AND REPAIR PARTS WITH 2 COATS PRIMER. INSTALL STRAP WET WITH SEALANT. (M)SDR AALA990222Floorbeam · corrodedTUL - FOUND CORROSION ON FLOORBEAM STATION 1130 RBL 27 INCH. INSTALLED REPAIR PER ESO 11697, DATED 1-5-99. (M)SDR TWAA9901705Floorbeam · corrodedDURING OP 16 MAINT CHECK, FOUND FLOORBEAM CAP CORRODED AT STA 1156 BETWEEN TRACK LBL 22 AND LBL 42. FABRICATED NEW PART FROM 7075 T6. INSTALLED PER TWA STD PROCESSES MANUAL 6-70-01.SDR RRXA991049Floorbeam · damagedDURING A MAINTENANCE VISIT, FOUND DRILL DAMAGE, DOUBLE DRILLED HOLES AND HOLES, FUSELAGE, MAIN CABIN FLOOR BEAMS AT VARIOUS LOCATIONS BETWEEN STA 70 AND STA 200. DAMAGE WAS CAUSED FROM A PREVIOUS MOD.. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TSDR USAA990038Floorbeam · crackedCLT - DURING C-4 CHECK VISUAL INSPECTION, FOUND A .50 INCH CRACK ON STIFFENER ANGLE STA 246 FLOORBEAM FORWARD FACE AT LBBL 17.0. REPAIRED FLOORBEAM ANGLE PER SRM 51-10-00. (X)SDR USAA990030Floorbeam · corrodedCLT - DURING C-4 CHECK VISUAL INSPECTION, FOUND CORROSION ON FLOORBEAM 1 INCH BY 79 INCHES AT STA 325 RBL 23 TO RBL 56. INSTALLED DOUBLER PER SRM 53-00-51 FIG 201. (X)SDR SWAA990129Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM SCREW HOLE CORROSION, VARIOUS PLACES AT BS 986.5, AFT GALLEY AREA.SDR RRXA991043Floorbeam · damagedDURING A MAINTENANCE VISIT, FOUND DRILL DAMAGE, FUSELAGE, FLOORBEAM, AT FS 857, AT BL 0 AND RL 20 RIGHT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR ANGLE AND DOUBLER IAW FAA APPROVSDR TSAA9953047Floorbeam · crackedFLOORBEAM IN FORWARD CARGO PIT CRACKED A BS 500 STR 26L. REPLACED SPLICED CRACKED SECTION OF CARGO FLOORBEAM PER SRM 53-10-2. TAT: 47,785.0 HOURS. TAC: 63,219. (X)SDR TSAA9953039Floorbeam · corrodedUPON FLOORBOARDS REMOVAL, SCATTERED CORROSION SPOTTED ALONG UPPER SECTION, MAIN DECK BS 312 FLOORBEAM AS EVIDENT. CUT OUT CORRODED FLOORBEAM AND REPAIRED PER SRM 53-10-9. TAT: 47,785.0 HOURS. TAC: 63,219. (X)SDR TSAA9953038Floorbeam · corrodedUPON FLOORBOARDS REMOVAL, SCATTERED CORROSION SPOTTED ALONG UPPER SECTION, MAIN DECK BS 294.5 FLOORBEAM AS EVIDENT. REPAIRED PER SRM 53-10-9. TAT: 47,785.0 HOURS. TAC: 63,219. (X)SDR DL72S990149Floorbeam · corrodedFOUND DURING MV-1 CORROSION VISIT NRC 46, CORROSION AT FLOORBEAM STA 344 RBL 5 TO LBL 60 UPPER AND LOWER SIDES. REPAIRED PER SRM 53-10-8 FIG 11.SDR 99FDEA00019Floorbeam · corrodedNR 575 WHILE WORKING ON NR 395, DISCOVERED CORROSION ON FLOORBEAM LWR CHORD BS 1050, RBL 2, WL 200. REPAIRED FLOORBEAM PER FEDEX EA 7-5310-43772 REV A.SDR USAA990042Floorbeam · corrodedCLT - DURING Q-4 CHECK VISUAL INSPECTION, FOUND CORROSION AROUND FASTENER HOLES STATION 947 BETWEEN LBL 20 TO RBL 20 FLOORBEAM. CORROSION TASK NR C 53-107-02. INSTALLED BEAM SECTION PER TR 53-60-02. (M)SDR USAA990041Floorbeam · corrodedCLT - DURING Q-4 CHECK VISUAL INSPECTION, FOUND CORROSION ON FLOORBEAM BS 344.17 RBL 8 - RBL 22 CORROSION TASK NR C 53-107-02. INSTALLED 'T' CAP DOUBLER REPAIR PER SRM 53-10-51 FIG 205. (M)SDR USAA990040Floorbeam · corrosionCLT - DURING Q-4 CHECK VISUAL INSPECTION, FUOND CORROSIN ON FLOORBEAM STATION 986 BL 0 TO RBL 35 1 INCH BY 3 INCH, CORROSION TASK NR C 53-107-02. INSTALLED 'T' CAP AND SHEAR TIES PER TR 53-60-01 AND SRM 53-00-01 FIG 202. (M)SDR USAA990010Floorbeam · corrodedCLT - DURING Q-4 CHECK VISUAL INSPECTION, FOUND CORROSION ON FLOORBEAM STATION 967 RBL 20. CORROSION TASK NR C53-107-02. INSTALLED REPAIR ANGLE PER SRM 53-60-51. (M)
Back to JASC 5315