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 SWAA030241Floorbeam · crackedDURING SCHEDULED D CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 727A +17, WL 208 AND RBL 44. REPAIRED FLOORBEAM PER BFG ER.SDR 03FDEA00089Floorbeam · corrodedCORROSION ON FLOORBEAM UPPER FLANGE BS 720D LBL 25-45, WL 208. REMOVED CORROSION FROM FLOORBEAM UPPER FLANGE BS 720D LBL 25-45 WL 208. AREA REMOVED .4 INCH X 1 INCH .045 INCH, ORIGINAL THICKNESS .125 INCH FOUND OUT OF LIMITS PER SRM 53-10-1. CUT OUT, OUT OFSDR SWAA030226Floorbeam · crackedDURING SCHEDULED D CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 727A + 17, WL 208 AND RBL 27.5. REPAIRED FLOORBEAM PER BFG ER.SDR 03FDEA00088Floorbeam · corrodedCORROSION BS 1130 WL 201 LBL 37 - RBL 51, CORROSION AROUND NUT PLATE HOLES ON LWR FLOORBEAM CHORD AFT CARGO BAY.SDR AWXA200300176Floor Support · corrodedLCQ - MAJOR REPAIR - DURING C-09 CHECK INTERGRANULAR CORROSION WAS FOUND ON FLOOR SUPPORT FRAME BS 1510, RBL 2. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS; REMOVED CORRODED SECTION OF FLOOR SUPPORT FRAME BS 1510, RBL 2; FABRICATESDR AWXA200300174Floor Support · corrodedLCQ - MAJOR REPAIR - DURING C-09 CHECK INTERGRANULAR CORROSION WAS FOUND ON FLOOR SUPPORT FRAME BS 1510, LBL 2. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS; REMOVED CORRODED SECTION OF FLOOR SUPPORT FRAME BS 1510, LBL 2; FABRICATESDR AWXA200300172Floorbeam · corrodedLCQ - MAJOR REPAIR - DURING C-09 CHECK INTERGRANULAR CORROSION WAS FOUND ON FLOOR SUPPORT FRAME BS 1510, LBL 07 IN THE AFT CARGO COMPARTMENT . MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS; REMOVED CORRODED SECTION OF FLOOR SUPPORT SDR AWXA200300171Frame · corrodedLCQ - MAJOR REPAIR - DURING C-09 CHECK INTERGRANULAR CORROSION WAS FOUND ON FLOOR SUPPORT FRAME BS 1510, LBL 11. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS; REMOVED CORRODED SECTION OF FLOOR SUPPORT FRAME BS 1510, LBL 11; FABRICASDR F3LA200300055Floorbeam · corrodedDURING C-4 CHECK, INSPECTION REPORTED FLOORBEAM AT STA 312 CORRODED FROM BL 0 TO RBL 12. FOUND CORROSION OUT OF LIMITS PER SRM 53-10-51, PARA 114, DETAIL XI. FABRICATED REPAIR PART PER SRM 53-10-51 AND INSTALLED PER SRM 53-10-51 AND SRM 51-40-02.SDR 2003UALA00118Floorbeam · crackedL-ANGLE AND CHANNEL CRACKED BETWEEN STA 325 AND 347 AT RBL 42.69. L-ANGLE ATTACHES TO THE FORWARD END OF C-CHANNEL FLOORBOARD SUPPORT AT RBL 42.69 TO THE STA 325, FLOORBEAM. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED NEW L-ANGLE AND NEW CHANNEL.SDR SWAA030213Beam · crackedDURING SCHEDULED D CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED BETWEEN BS 716 - BS 706, BBL 0, WL 208. REPAIRED BEAM PER SRM AND BFG ER.SDR AWXA200300170Floorbeam · corrodedDURING C-09 CHECK INTERGRANULAR CORROSION WAS FOUND ON CABIN FLOORBEAM IN AND AROUND FASTENER HOLES BS 1640. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS TO BE OUT OF LIMITS; REMOVED CORRODED SECTION OF FLOORBEAM BS 1640; FABRICATED A NEW REPLACEMENT SDR AWXA200300128Floorbeam · corrodedMAJOR REPAIR, DURING C-09 CHECK INTERGRANULAR CORROSION WAS FOUND ON A MAIN CABIN FLOORBEAM AT BS 1640, BS 0 TO LBL 5. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS OUT OF LIMITS; REMOVED EXISTING REPAIR FROM FORWARD SIDE OF FLOORBEAM AND TRIMMED OUT SDR AWXA200300127Floorbeam · crackedYVR - MAJOR REPAIR - DURING C-14 CHECK 2 EACH CRACKS A 4" AND 2" WERE FOUND ON CHORD AND WEB OF CABIN CENTER SECTION FLOOR BEAM AT BS 663, BL "0". MAINTENANCE CUTOUT DAMAGE ON FLOORBEAM BS 663 BL "0"; FABRICATED 2 EACH FILLERS, STRAPS, SPLICE ANGLES, AND SPLISDR AWXA200300137Floorbeam · corrodedMAJOR REPAIR - DURING C-09 CHECK EXFOLIATION CORROSION WAS FOUND ON FLOORBEAM FORWARD UPPER T CAP BS 1681.8, AT NUT CLIP ATTACH POINTS FROM CUSP TO CUSP. MAINTENANCE REMOVED CORROSION AND FOUND MATERIAL LOSS OUT OF LIMITS; REMOVED FLOORBEAM FROM BS 1660 TO BS SDR AWXA200300126Floorbeam · crackedYVR - MAJOR REPAIR - DURING C-14 CHECK A .1562 INCH CRACK WAS FOUND EXTENDING BEYOND STOP DRILL HOLE ON FORWARD FACE OF FLOORBEAM AT BS 520. MAINTENANCE CUTOUT MATERIAL FROM FORWARD END OF INTERCOSTAL AND CHANNEL RADIUS FILLER BS 520; FABRICATED A NEW INTERCOSSDR AWXA200300115Floorbeam · crackedYVR - MAJOR REPAIR - DURING C-14 CHECK 2 EACH 1/2" CRACKS WERE FOUND ON MAIN CABIN FLOOR BEAM BS 540, TRANSVERSE BEAM WEB IS CRACKED AT BOTH ENDS BL "0" AND LBL 24.75. MAINTENANCE REMOVED TRANSVERSE BEAM BS 540; FABRICATED A NEW REPLACEMENT TRANSVERSE BEAM PERSDR 0300495511Floorbeam · corrodedDURING "H" CHECK FOUND CORROSION ON FLOORBEAM AT BS 345 LBL 7. REPAIRED PER EA 55-121560.SDR 0300205511Floorbeam · crackedDURING "H" CHECK FOUND CRACK IN FLOORBEAM AT BS 700 LBL 25. REPAIRED PER EA 55-193436.SDR 2003F00465Floorbeam · corrodedAT C-CHECK, FOUND CORROSION, FORWARD CARGO PIT, MAIN FLOORBEAM, LOWER FLANGE AT STATION 575, RBL 0, BENEATH NUTPLATE. CUTOUT DAMAGED AREA. FABRICATED ANGLE REPAIR AND FILLER. TREATED AND PRIMED. INSTALLED FABRICATED ANGLE ON FORWARD CARGO PIT, MAIN FLOORBESDR 2003F00461Floorbeam · corrodedAT C-CHECK, FOUND CORROSION ON FLOORBEAM, STATION 328 RBL 10, UNDERNEATH NUTPLATE. REMOVED CORROSION. MATERIAL LOSS OTU OF LIMITS. FABRICATED ONE EACH END CAP AND 4 ANGLES. TREATED, PRIMED AND INSTALLED REPAIRED PARTS. (M)SDR 2003F00268Floorbeam · corrodedAT C-CHECK, FOUND CORROSION ON TOP OF FLOORBEAM AT STATION 1130, RBL 45. REMOVED UPPER T-CAP FROM LBL 60 TO RBL 60. FABRICATE, TREAT, PRIME AND INSTALLED NEW T-CAP. (M)SDR 2003F00267Floorbeam · corrodedAT C-CHECK, FOUND CORROSION ON FLOORBEAM AT STATION 1130, LBL 0. REMOVED CORROSION FROM FLOORBEAM AT FUSELAGE STATION 1130 BL 0. REMOVED UPPER T-CAP LBL 60 TO RBL 60, STATION 1130. FABRICATED NEW T-CAP. TREATED, PRIMED AND INSTALLED NEW UPPER T-CAP LBL 60 SDR 2003F00280Floorbeam · corrodedAT C-CHECK, FOUND CORROSION ON TOP OF BEAM IN CABIN FLOOR AREA AT STATION 950, RBL 30 TO RBL 42. REMOVED CORROSION. MATERIAL LOSS OUT OF LIMITS. REMOVED AND REPLACED DAMAGED AREA. TREATED AND PRIMED AREA. (M)SDR 03FDEA00072Floorbeam · damagedMECHANICAL DAMAGE ON FLOORBEAM BS 990 RBL 37.5 WL 207.SDR 03FDEA00065Floorbeam · corrodedCORROSION ON FLOORBEAM LOWER CHORD UPPER SURFACE STA 1130, RBL 4, WL 201. REMOVED CORROSION ON FLOORBEAM LOWER CHORD UPPER SURFACE BS 1130, RBL 1-RBL 8, WL 201, IAW SRM. 100 PERCENT MATERIAL LOSS, FOUND TO BE OUT OF LIMITS IAW SRM. REPAIRED LOWER FLANGE OFSDR F3LA200300019Floorbeam · corrodedDURING C-4 CHECK, INSPECTION REPORTED FLOORBEAM AT STA 312 CORRODED FROM LBL 1 TO LBL 31. REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS PER SRM 53-10-51, PARA 114, DETAIL XI. FABRICATED AND INSTALLED REPAIR PER SRM 53-10-51 AND 51-40-02.SDR F3LA200300018Floorbeam · corrodedDURING C-4 CHECK, INSPECTION REPORTED CORROSION ON FLOORBEAM AT STA 1016, RBL 29. FABRICATED AND INSTALLED REPLACEMENT PARTS PER SRM 53-30-51, PAGES 203-208.SDR AUS20030049Floorbeam · corroded(AUS) FLOORBEAM CORRODED AT BS 870 LBL 65 AND RBL 65.SDR AUS20030048Floorbeam · corroded(AUS) FLOORBEAM CORRODED AT BS 620 LBL 62 AND RBL 62.SDR AUS20030047Floorbeam · corroded(AUS) FLOORBEAM CORRODED AT BS 72 LBL 65 AND RBL 65.SDR AUS20030045Floorbeam · corroded(AUS) FLOORBEAM CORRODED AT BS 1030 FL AND RBL 70.SDR AUS20030044Floorbeam · corroded(AUS) FLOORBEAM CORRODED AT BS 950 AND RBL 70.SDR AUS20030043Floorbeam · corroded(AUS) FUSELAGE FLOORBEAM CORRODED AT BS 1110 LBL 68 AND RBL 68 WL 208.SDR AUS20030041Floorbeam · corroded(AUS) FUSELAGE FLOORBEAM LOCATED AT BS 1130 LBL 71 AND RBL 71 CORRODED.SDR SWAA030138Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND CORROSION ON FLOORBEAMS UPPER SURFACE AT BS 312, LBL 10, AND UPPER AND LOWER SURFACE AT BS 328, RBL 9 - RBL 58. REPAIRED CORRODED SECTION OF FLOORBEAMS PER SRM.SDR 03FDEA00050Floorbeam · corrodedCORROSION ON FLOORBEAM LWR CHORD UPPER SURFACE STA 1130 RBL 4 WL 201.SDR F3LA200300015Floorbeam · corrodedDURING C-4 CHECK, INSPECTION REPORTED FLOORBEAM FASTENER CORRODED AND FROZEN IN PLACE AT STA 294.5, LBL 5. DETERMINED CORROSION TO BE OUT OF LIMITS PER SRM 53-10-15. REPAIRED FLOORBEAM UPPER CHORD FROM LBL 22 - RBL 59 PER SRM 53-10-51, FIG 205, SRM 51-40-2 ASDR F3LA200300014Floorbeam · corrodedDURING C-4 CHECK, INSPECTION REPORTED FLOORBEAM AT STA 294.5 CORRODED IN SEVERAL AREAS FROM BL 0 TO RT MOPSILL. DETERMINED CORROSION ON FLOORBEAM AT STA 294.5 FROM CENTER TO LBL 12 TO BE OUT OF LIMITS PER SRM 53-10-15. REPAIRED FLOORBEAM UPPER CHORD FROM LBLSDR C2XA02SH179Floorbeam · corrodedSHV-DURING C CHECK THE LEFT HAND OMEGA BEAM AT FRAME 20 INBOARD SIDE WAS FOUND TO HAVE CORROSION. MAINTENANCE REMOVED DAMAGED AREA AND PERFORMED A SPLICE REPAIR IAW EMB 145 SRM 53-21-10. THE AIRCRAFT WAS APPROVED TO RETURN TO SERVICE.SDR SIMA200402003Floorbeam · corrodedTHE LT FLOORBEAM AT FRAME 20 WAS FOUND TO BE CORRODED BEYOND SRM LIMITS. CUT OUT DAMAGE SECTION OF LT FLOORBEAM, CLEANED AND TREATED THE REPAIR AREA. FABRICATED EXTERNAL ANGLE, FILLER, PLATE AND SHIMS. REPAIR DONE IAW EMB SRM, SRM EMB 145/1142 REV 24, CHAPTESDR OZI2003F00003Floorbeam · corrodedFORWARD SIDE OF LAVATORY FLOORBEAM (FRAME 35), CORRODED.SDR F3LA200300009Floorbeam · corrodedDURING C-4 CHECK, INSPECTION REPORTED CABIN FLOORBEAM AT STA 987.5, RBL 24.25 TO LBL 45.50, SHOWED SIGNS OF CONTAMINATION AND BLUE WATER CONTAMINATION. BLENDED CORROSION ON FLOORBEAM UPPER CAP AND FOUND TO BE OUT OF LIMITS PER SRM 53-60-51, FIG 101. FABRICATSDR F3LA200300008Floorbeam · corrodedDURING C-4 CHECK, INSPECTION REPORTED TOP SURFACE OF I-BEAM AT STA 986.5 CORRODED. BLENDED CORROSION AND FOUND TO BE OUT OF LIMITS PER SRM 53-60-51, FIG 101. REMOVED DAMAGED UPPER CAP OF FLOORBEAM PER SRM 53-00-51, FIG 202. FABRICATED AND INSTALLED REPAIR PSDR F3LA200300007Floorbeam · corrodedDURING C-4 CHECK, INSPECTION REPORTED TOP SURFACE OF I-BEAM AT STA 967 CORRODED. BLENDED CORROSION AND FOUND TO BE OUT OF LIMITS PER SRM 53-60-51, FIG 101. REMOVED DAMAGE PER SRM 53-00-51, FIG 203. FABRICATED AND INSTALLED REPAIR STRAPS FOR FLOORBEAM AT STASDR SIMA200302201Floorbeam · corrodedABI - DURING AN MBV INSPECTION, FOUND CORROSION ON THE CENTER FLOORBEAM AT FRAME 20. REMOVED CORRODED AREA BY CUTOUT. FABRICATED AN EXTERNAL U-SHAPED DOUBLER. REPAIR DONE IAW EMB-145 SRM (145/1142, REV 20) 53-21-10 PARA 5 FIG 204 SHEET 2, AND STANDARD SRM PSDR 2003UALA00064Floorbeam · crackedFLOORBEAM CRACKED AT FLOOR SUPPORT ATTACH CLIP, STA 700 LBL 46. MAJOR REPAIR ACCOMPLISHED. INSTALLED T-CAP REPAIR.SDR GTIA030007Floorbeam · brokenFTW - FOUND PASSENGER CABIN CENTER FLOORBEAM BETWEEN STATION 537 AND 615 BROKEN PLACES. REMOVED PASSENGER CABIN CENTER FLOORBOARD. FABRICATED FLOORBOARD. INSTALLED PASSENGER CABIN CENTER FLOORBOARD. (M)SDR 03FDEA00035Floorbeam · damagedMECHANICAL DAMAGE ON FLOORBEAM BS 990, RBL 37.5, WL 207. REPAIRED FLOORBEAM BS 990 RBL 37.5 WL 207 IAW SRM 53-10-8.SDR 03FDEA00027Floorbeam · corrodedCORROSION ON LOWER FLOORBEAM CHORD, AROUND NUTPLATES, STA 1130 0 BL, RBL 48, WL 200. REPAIRED FLOORBEAM BS 113 WL 200 IAW EA 7-5310-68165.
Back to JASC 5315