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 SIMA200131313Floorbeam · corrodedABI - DURING AN MBV INSPECTION, FOUND CORROSION ON THE LEFT OMEGA BEAM AT FRAME 24. REMOVED CORROSION. PERFORMED AN NDT INSPECTION OF THE AREA WITH NO REJECTABLE INDICATIONS. FABRICATED A Z REPAIR DOUBLER. REPAIR DONE IAW EMB GST 3598/01, PARA 8 AND STANDASDR SIMA200131312Floorbeam · corrodedABI - DURING MBV INSPECTION, CORROSION WAS FOUND ON THE CENTER OMEGA BEAM AT FRAME 24. REMOVED CORROSION BY BLENDING OUT. PERFORMED AN NDT INSPECTION OF THE AREA WITH NO REJECTABLE INDICATIONS. FABRICATED A Z REPAIR DOUBLER. REPAIR DONE IAW EMB GST-3598/01SDR 2001UALA02341Floorbeam · corrodedMAIN CABIN FLOORBEAM T-CAP STATION 951 CORRODED BEYOND LIMITS BETWEEN RBL 24 AND RBL 30. MAJOR REPAIR ACCOMPLISHED, FABRICATED NEW T-CAP AND STRAPS INSTALLED.SDR 2001UALA02253Floorbeam · corrodedCABIN FLOORBEAM CORRODED AT BODY STATION 365 RBL 9 TO RBL 15. MAJOR REPAIR ACCOMPLISHED. REPLACED UPPER CAP FROM BL 0 TO CREASE BEAM.SDR 2001UALA02245Floorbeam · corrodedFLOORBEAM UPPER CAP WAS CORRODED AT STATION 986.5 LBL 29 WITH EXCESSIVE MATERIAL LOSS AT WL 207. MAJOR REPAIR ACCOMPLISHED. ACCOMPLISHED ANGLE REPAIR.SDR 2001UALA02243Floorbeam · corrodedMAIN CABIN FLOOR BEAM T-CAP STATION 951 CORRODED BEYOND LIMITS BETWEEN RBL 24 AND RBL 30. MAJOR REPAIR ACCOMPLISHED. REMOVED FLOOR SUPPORT RBL 15 AND RBL 45 BETWEEN STATION 951 AND 967. FABRICATED NEW T-CAP AND STRAPS INSTALLED.SDR 0104289994Floorbeam · crackedDURING HCK IN ATL A CRACK WAS DISCOVERED IN THE WEB OF THE STA Y 237 FLOORBEAM AT X=7 LEFT. THE CRACK MEASURES 2.75 INCH IN LENGTH. MATERIAL 7075-T6511 ALUMINUM EXTRUSION. REPAIRED PER EA 99-185262.SDR SIMA200131303Floorbeam · corrodedTHIS IS A LEVEL 2 FINDING ON A CORROSION REPAIR ITEM. OMEGA BEAM AT FRAME 20 CORRODED. REPAIRED LEFT OMEGA BEAM AT FRAME 20 IAW EMB 135, SRM 53-210 AND 51-40-02. (M)SDR SIMA200131310Floorbeam · corrodedABI - DURING AN MBV INSPECTION, FOUND CORROSION ON THE RIGHT OMEGA FLOORBEAM AT FRAME 20. REMOVED CORROSION BY BLENDING. PERFORMED NDT INSPECTION ON THE AREA WITH NO REJECTABLE INDICATIONS. FABRICATED A U REPAIR DOUBLER. REPAIR DONE IAW EMB GST-3598/01 PARASDR SIMA200131311Floorbeam · corrodedABI - DURING A MBV, FOUND CORROSION ON THE GALLEY CENTER OMEGA BEAM. REMOVED CORROSION BY BLENDING OUT. PERFORMED AN NDT INSPECTION ON THE AREA WITH NO REJECTABLE INDICATIONS. FABRICATED A 'Z' REPAIR DOUBLER. REPAIR DONE IAW EMB GST-3598/01 PARA 7 AND STANSDR SWAA013057Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORRODED AT BS 294.5, LBL 12 TO RBL 12. REPAIRED FLOORBEAM PER SRM.SDR SWAA013041Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAMS CRACKED (3 EA) AT BS 787, 747 & 727D, RBL 14. REPAIRED FLOORBEAM PER SRM.SDR SIMA200131301Floorbeam · corrodedDURING AN MBV INSPECTION, FOUND CORROSION ON THE LEFT OMEGA BEAM AT FRAME 20. REMOVED CORROSION. FABRICATED DOUBLER AND INSTALLED IAW EMB 145 SRM 145/1142 CHAPTER 53 REV 15, 53-21-10, PAGE 201, FIG 201, SHEET 1 AND STANDARD SRM PRACTICES. (M)SDR 01FDEA00977Floorbeam · corrodedCORROSION BS 344, FLOORBEAM UPPER CHORD RBL 17 - LBL 55, WL 208. REMOVED AND REPLACED CHORD PER SRM 51-10-2, 51-10-6, 53-10-1, & 53-10-8.SDR 01FDEA00965Floorbeam · corrodedCORROSION (C53-224-01, 1) ON TOP OF FLOORBEAM AT FASTENER HOLES BS 312, LBL 3 TO LBL 50, WL 208. REMOVED AND REPLACED FLOORBEAM PER SRM 53-10-8, FIG 9.SDR SWAA013015Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM UPPER CHORD CORRODED AT BS 328, WL 208 & RBL 20 TO RBL 49. REPAIRED FLOORBEAM PER SRM.SDR 01FDEA00952Floorbeam · corrodedCORROSION (C53-224-01) ON TOP OF FLOORBEAM BS 344, RBL 3 - LBL 31, WL 208. REMOVED AND REPLACED FLOORBEAM PER SRM 51-10-6.SDR 2001UALA02195Floorbeam · damagedAFT CABIN STATION 947 LBL 12 TO LBL 13 WL 208 FLOORBEAM UPPER AFT FLANGE HAS 20 PERCENT MATERIAL REMOVED DURING REWORK. L-ANGLE DOUBLER MANUFACTURED AND INSTALLED. MAJOR REPAIR ACCOMPLISHED.SDR 2001UALA02183Floorbeam · corrodedMAIN CABIN FLOORBEAM STATION 798 LBL 19-15 UPPER CAP CORRODED. MAJOR REPAIR ACCOMPLISHED. INSTALLED FLOORBEAM SPLICE PER SRM 53-00-51 FIG 203.SDR CALA0100987Floorbeam · corrodedINSPECTION FOUND FLOORBEAM UPPER CHORD CORRODED AROUND SEVERAL FASTENERS AT STA 294.5, LBL 35-51. A NEW CHORD SECTION WAS INSTALLED IAW SRM 53-10-51, FIGURE 205, SHEETS 1-4.SDR CALA0100986Floorbeam · corrodedINSPECTION FOUND CABIN FLOORBEAM CORRODED AT STA 947, BL 0 TO LBL 6. A REPAIR WAS INSTALLED IAW SRM 53-60-51.SDR SWAA012954Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND AFT CARGO BIN FLOORBEAM CORRODED, BS 771 BETWEEN LBL 8-LBL 13. REPAIRED BEAM PER SWA RA.SDR C2XA01TY163Floor Support · corrodedTYS Several areas of corrosion were found on the aft side of service door aft of frame 22.Maintenance removed floor support and replaced it with a new part IAW emb135/145 SRM 51-40-02 and 51-10-02-Work was satisfactory and aircraft will be released upon compleSDR AWXA200100581Floorbeam · corrodedMCN - C13 CK - C - CORROSION FOUND ON FLOORBEAM UPPER FLANGE AT BS 1016, LBL 41 TO RBL 40, (PREVIOUSLY REPAIRED), FOUND TO BE OUT OF LIMITS AFTER CORROSION REMOVAL. MAINTENANCE REMOVED CORRODED UPPER FLANGE, FABRICATED REPAIR PARTS AND INSTALLED IAW AWA ER 15SDR AWXA200100569Floorbeam · corrodedMCN - C13 CK - C - CORROSION FOUND FLOORBEAM UPPER FLANGE AT BS 967.5, RBL 8 TO RBL 50, BEYOND SRM LIMITS AFTER CLEAN UP. MAINTENANCE CUT OUT DAMAGED SECTION OF FLOORBEAM UPPER FLANGE (PREVIOUSLY REPAIRED), FABRICATED REPAIR ANGLES AND STRAPS AND INSTALLED IASDR SWAA012938Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FLOOR BEAMS CORRODED ( 2 EA ) AT BS 910, RBL 14 & BS 945, LBL 17. REPAIRED FLOOR BEAMS PER SRM.SDR 01FDEA00932Floorbeam · corrodedCORROSION ON FLOORBEAM BS 1070, LBL 45, WL 208. REMOVED AND REPLACED FLOORBEAM PER SRM 53-10-8 FIG 3.SDR 01FDEA00927Floorbeam · corrodedCORROSION (C53-224-01, 2) ON LWR CHORD OF FLOORBEAM, BS 1110, RBL 41, WL 200. REMOVED AND REPLACED CORROSION PER EA 7-5310-59897.SDR 01FDEA00922Floorbeam · corrodedCORROSION C53-224-01,1 ON TOP CHORD OF BS 720A FLOORBEAM RBL 7 OUT OF LIMITS. REMOVED AND REPLACED FLOORBEAM PER EA 7-5310-60567.SDR 01FDEA00958Floorbeam · corrodedCORROSION ON FLOORBEAM BS 1970, LBL 45, WL 208.SDR 01FDEA00923Floorbeam · corrodedCORROSION ON UPPER CHORD OF FLOORBEAM BS 1050, RBL 35 AND RBL 55, WL 208. REMOVED AND REPLACED FLOORBEAM PER SRM 53-10-8 & 51-30-2.SDR SIMA200130304Floorbeam · corrodedDURING MBV INSPECTION, FOUND CORROSION ON THE GALLEY LEFT OMEGA BEAM AT FRAME 20. REMOVED CORROSION BY CUTOUT. FABRICATED FILLER AND DOUBLER. REPAIR DONE IAW EMB 145 (SRM 145/1142 CHAPTER 53 REV 15). 53-21-10, PAGE 204, FIG 201 AND STANDARD SRM PRACTICES. (SDR SIMA200130303Floorbeam · corrodedABI - DURING MBV INSPECTION OF AIRCRAFT, FOUND CORROSION ON THE FORWARD DIGITAL IN GALLEY AREA. REMOVED CORROSION BY BLENDING IT OUT. PERFORMED AN NDT INSPECTION OF THE AREA WITH NO REJECTABLE INDICATIONS. FABRICATED REPAIR DOUBLER IAW EMB135 GST-3493/01 ANSDR C2XA01IA392Floorbeam · corrodedIAH- DURING 1C INSPECTION IT WAS NOTED THAT THE LEFT FLOOR BEAM AT FRAME 20 WAS CORRODED. C CHECK MAINTENANCE REPAIRED THE FLOOR BEAM IAW EMB 145 SRM 53-21-10,AND, THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR 2001UALA02161Floorbeam · crackedSTATION 246 RBL 26.06 CHORD CRACKED 2 PLACES UNDER WEB. MAJOR REPAIR ACCOMPLISHED. REPAIR NR 2 SPLICED IN NEW SECTION OF CHORD, RBL 50 TO LBL 21. NOTED CRACKING OF THE 141W8519-1 MID CHORD IS DUE TO THERMAL CONTRACTION THAT RESULTS IN HIGHER THAN EXPECTED INSDR USAA011341Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 6 INCHES, STATION 1300 FLOORBEAM, LBL 12 AND 18. INSTALLED NEW T-CAP PER TR 53-15-01. (M)SDR 2001UALA02156Floorbeam · corrodedCABIN FLOORBEAM CORRODED BETWEEN RBL 6 AND RBL 56, STA 365. MAJOR REPAIR ACCOMPLISHED. SPLICED IN NEW T-CAP.SDR ZW0A0110001Floorbeam · corrodedDURING CHECK-C MAINT FOUND CORROSION AT STA 1250, LBL 24 INCHES TO LBL 44 INCHES, CABIN FLOOR FRAME. REMOVED AND TREATED CORROSION PER SPM 6-80-01 AND SRM 51-10-3. INSTALLED FLOOR SUPPORT PER SPM 6-70-01 AND SRM 51-30-5.SDR AWXA200100574Floorbeam · corrodedMCN - C13 CK - C - CORROSION FOUND ON FLOORBEAM UPPER FLANGE AT BS 967, RBL 46, BEYOND SRM LIMITS AFTER CLEAN UP, (HAD A PREVIOUS BLEND REPAIR IN THE SAME SPOT). MAINTENANCE TREATED AND FILLED BLENDED AREA, FABRICATED REPAIR STRAP AND SHIMS AND INSTALLED IAW SDR CALA0100966Floorbeam · corrodedFLOORBEAM STATION 986.5 HAS SEVERAL CORRODED HOLES AT UPPER FLANGE (TOP AND BOTTOM). REPAIRED FLOORBEAM PER EC/RA 5310-03851.SDR 2001UALA02222Floorbeam · corrodedMAJOR BS 852 RBL 50 WL 200 FLOORBEAM CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED FLOORBEAM AND SPLICES.SDR 2001UALA02221Floorbeam · crackedMAJOR FS 785.9 FLOORBEAM CRACKED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED FLOORBEAM SECTION AND SPLICES.SDR 2001UALA02220Floorbeam · corrodedMAJOR BS 852 RBL30 WL200 FLOORBEAM CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED FLOORBEAM SECTION AND SPLICESSDR 01FDEA00956Floorbeam · corrodedCORROSION ON LOWER CHORD OF FLOORBEAM AROUND NUT PLATE HOLES. REMOVED AND REPLACED FLOORBEAM PER EA 7-5310-59894.SDR RAIA00110014Floorbeam · corrodedMX-STL- DURING MAINTENANCE CHECK FOUND CORROSION ON FWD DIGITAL AT COCKPIT ENTRANCE AT FRAME 18 AND Y AXIS 0.0. MAINTENANCE REPAIRED DIGITAL AT FRAME 18 AND Y AXIS 0.0 IAW EMB ENGINEERING ORDER GST2322/01.SDR RAIA00110010Floorbeam · corrodedMX-STL- DURING MAINTENANCE CHECK FOUND CORROSION ON LT OMEGA BEAM AT FLOORBOARD SUPPORT CENTER AISLE AT FRAME 20 Y AXIS -.459. MAINTENANCE REPAIRED LT OMEGA BEAM AT FLOORBOARD SUPPORT CENTER AISLE AT FRAME 20 Y AXIS-.459 IAW EMB I45 SRM.SDR 2001UALA02151Floorbeam · corrodedCABIN FLOORBEAM UPPER CAP IS CORRODED BODY STATION 947, RBL 29 - 60, WL 208. MAJOR REPAIR ACCOMPLISHED. INSTALLED UPPER CAP SPLICE REPAIR.SDR AWXA200100573Floorbeam · corrodedMCN - C13 CK - C - CORROSION FOUND ON FLOORBEAM UPPER T-CHORD AT BS 986.5, LBL 43 TO RBL 43 BEYOND SRM LIMITS AFTER CLEAN UP. MAINTENANCE REMOVED FLOORBEAM UPPER T-CHORD, FABRICATED AND INSTALLED REPLACEMENT UPPER T-CHORD IAW B737 SRM 53-60-51, PG 207 - 208, SDR USAA011332Floorbeam · crackedCLT - FOUND FLOORBEAM STRAP CRACKED 2 INCHES, BS 365.25, LBL 27. INSTALLED DOUBLER REPAIR PER SRM 53-10-51. (M)SDR 2001UALA02150Floorbeam · damagedSTATION 897 RBL 12 TO RBL 15. CABIN FLOORBEAM UPPER CAP HAS AREAS BLENDED BEYOND 15 PERCENT LIMIT. MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGED SECTION. MANUFACTURED AND INSTALLED REPAIR DOUBLERS AND FILLERS.
Back to JASC 5315