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 CALA0500423Floorbeam · corrodedINSPECTION FOUND FLOORBEAM FORWARD FLANGE CORRODED AT STA 947, LBL 10.5. A REPAIR STRAP WAS INSTALLED IAW SRM 53-00-51.SDR 05FDEA04021Floorbeam · corrodedFOUND MAIN CABIN FLOORBEAM T-CAP CORROSION BS 560 LBL 3 TO LBL 24. COMPLIED WITH FLOORBEAM UPPER CHORD REPAIR AT STA 560 LBL 3 TO LBL 24, IAW B727 SRM 53-10-8 FIG 3, SIGNED BY TIMCO MECH NR 5154 AND QC 321.SDR 05FDEA04020Floorbeam · corrodedFOUND CABIN FLOORBEAM UPPER TEE CAP CORRODED AT STA BS400 BETWEEN BL 0 AND LBL 12. DAMAGE FOUND TO BE BEYOND LIMITS IAW B727 SRM 53-10-1 FIGURE 5. REMOVED DAMAGED UPPER CHORD IAW B727 SRM 53-10-8 FIGURE 3. FABRICATED REPAIR PARTS IAW B727 SRM 53-10-8 FIGURESDR 05FDEA04019Floorbeam · corrodedCABIN FLOORBEAM UPPER TEE CAP CORRODED AT STA BS 380 BETWEEN LBL24 AND LBL36. REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS IAW P-FSRM (ER 01-049) 53-10-1 FIGURE 4A. REMOVED DAMAGED AREA AND OBTAINED MATERIAL ID FOR UPPER CHORD AND REPAIR PARTS IAW B727 SRSDR 05FDEA04014Floorbeam · corrodedMAIN DECK FLOORBEAM CORRODED AT STA BS 720D FROM LBL27 TO LBL44. DAMAGE FOUND TO BE OUT OF LIMITS IAW B727 SRM 53-10-1 FIGURE 5. REMOVED STANCHION AND INTERCOSTAL BETWEEN STA BS 720D AND STA BS 720E TO FOM IAW B727 SRM 51-30-2. FABRICATED UPPER CHORD REPAIRSDR 05FDEA04011Floorbeam · corrodedFORWARD CARGO COMPARTMENT STA BS 560, BOTTOM OF FLOORBEAM HAS CORROSION BETWEEN RBL10 AND LBL40. REMOVED DAMAGE, FABRICATED 2 EACH REPAIR ANGLES, AND 1 EACH FILLER, AND 1 EACH LOWER STRAP IAW B727 SRM 53-10-8 FIGURE 2 ALODINED AND PRIMED REPAIR PARTS IAW B7SDR 05FDEA04007Floorbeam · corrodedCABIN FLOORBEAM, UPPER T-CAP CORRODED AT STA BS 440 BL 0 - RBL 24. DAMAGE FOUND TO BE OUT OF LIMITS IAW SRM 53-10-1 FIGURE 5. REMOVED DAMAGED T-CAP FROM RBL-8 TO LBL 8 STA BS 440 IAW SRM 53-10-8 FIGURE 3. REMOVED CORROSION FROM RBL 8 TO RBL 24 IAW SRM 51-10SDR DL73S050752Floorbeam · crackedCRACKS WERE FOUND IN THE RBL 24.8 FLOORBEAM. REINFORCED CHORD AND WEB WITH ANGLES, CHANNELS, AND DOUBLERS REF AD 2001-17-18, 93-17-08, 90-06-02 AND 03-056673-03AD.SDR DL73S050751Floorbeam · crackedCRACKS WERE FOUND IN THE OVERWING FLOORBEAMS AT LBL 24.8. EXISTING FLOORBEAM REPAIR/MODIFICATION WAS REMOVED AND STRUCTURAL REINFORCING WAS ADDED TO THE FLOORBEAM REF AD 2001-17-18, 93-17-08, 90-06-02, 3-056673-03AD.SDR SWAA053788Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CABIN FLOORBEAM CORRODED AT BS 947.5, LBL 16 TO RBL 6. REPAIRED FLOORBEAM PER SRM.SDR CALA0500419Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 986.5, RBL 7 TO LBL 49. REPAIRED IAW ECRA 5310-04494.SDR CALA0500418Floorbeam · corrodedINSPECTION FOUND UPPER AND LOWER SURFACE OF FLOORBEAM CORRODED AT STA 1640, RBL 8. THE FLOORBEAM WAS REPAIRED IAW SRM 53-00-51.SDR SWAA053747Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND FUSELAGE FLOORBEAM CORRODED AT BS 259, BETWEEN LBL 11 TO RBL 11, WL 208. REPAIRED FLOORBEAM PER BFG ER.SDR SWAA053746Channel · corrodedDURING SCHEDULED D CHECK, FOUND COCKPIT FLOOR Z-CHORD CORRODED AT BS 270, BETWEEN LBL 54 TO RBL 54, WL 208. REMOVED AND REPLACED Z-CHORD PER SRM.SDR SWAA053743Floorbeam · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FLOORBEAM CRACKED AT BS 947.5, LBL 55, WL 208. REPAIRED FLOORBEAM PER BFG ER.SDR SWAA053764Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FLOORBEAM CORRODED AT BS 1016, RBL 12 TO RBL 36. REPAIRED FLOORBEAM PER SRM.SDR AWXA200501573Floorbeam · crackedMAJOR REPAIR - DURING C-00 CHECK DISCOVERED FLOORBEAM CRACKED, 1.5 INCHES LONG, AT BS 700, WL 206 AND BL 24R. MAINTENANCE CUT OUT DAMAGE ON FLOORBEAM IAW ENGINEERING REPAIR NR 19-5335-05346-RC3. FABRICATED REPAIR ANGLES AND REPAIR SECTION IAW AWA ER NR 19-53SDR CALA0500416Floorbeam · corrodedINSPECTION FOUND FLOORBEAM UPPER CHORD CORRODED AT STA 986.5, RBL 28 TO RBL 45.5 (RIGHT I/B OF R-2 DOOR Z-ANGLE). A REPAIR WAS INSTALLED IAW SRM 53-00-51, FIGURE 201.SDR ASAA0540689Floorbeam · corrodedYXX - FOUND FLOORBEAM AT BS 947.5 CORRODED FROM LBL 14 TO RBL 14. REPAIRED FLOORBEAM IAW ASA EA 5310-0257. (M)SDR ASAA0540688Floorbeam · corrodedYXX - FOUND FLOORBEAM AT BS 986.5 CORRODED AT CLIP NUT HOLES ALONG TOP SURFACE. REPAIRED FLOORBEAM IAW ASA EA 5310-02525 AND ERO 4999. (M0SDR ASAA0540687Floorbeam · corrodedYXX - FOUND CORROSION ON FLOORBEAM AT BS 986.5 AT CLIP NUTS. REPAIRED FLOORBEAM IAW ASA EA 5310-02525. (M)SDR ASOA051069Floorbeam · crackedDURING A C-CHECK IN TUS, THE FS 280 FLOORBEAM WAS FOUND TO BE CRACKED AND CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE FS 280 FLOORBEAM IAW ASA EC EO700-53-0061. (M)SDR SWAA053735Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND CABIN FLOORBEAM UPPER CHORD CRACKED AT BS 294.5, LBL 22 TO LBL 27. REPAIRED FLOORBEAM PER SRM.SDR USAA051416Floorbeam · corrodedBEAM Y254 FWD CABIN, DEFECTIVE PART REPLACED WITH IDENT PART IAW SRM 51-72-11; CORROSION LEVEL 2; TASK JA-220-53500. DEFECT SIZE: .5 INCH X .5 INCH.SDR 2005UALA01316Floorbeam · crackedCABIN FLOORBEAM CRACKED UPPER FLANGE FWD SIDE, LBL 26.SDR CALA0500421Floorbeam · corrodedINSPECTION FOUND FLOORBEAM UPPER CHORD CORRODED AT STA 303, LBL 23 TO LBL 26. REPAIRED IAW SRM 53-00-51, FIGURE 201, REPAIR 1.SDR GTIA050273Seat Track · corrodedSTA 1136, SEAT TRACK HAS CORROSION. FABRICATED, TREATED AND INSTALLED SECTION OF SEAT TRACK AT STA 1136. (K)SDR SWAA053689Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CABIN FLOORBEAM CORRODED AT BS 967, RBL 18 TO RBL 42. REPAIRED FLOORBEAM PER SRM.SDR ASAA0540667Floorbeam · corrodedPAE - FOUND FLOORBEAM CORRODED. REMOVED DAMAGED SECTION OF FLOORBEAM UPPER CHORD, FABRICATED REPAIR PARTS AND INSTALLED PER EA 5310-02515. (M)SDR SWAA053668Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND CABIN FLOORBEAM CORRODED AT BS 986.5, RBL 45. REPAIRED FLOORBEAM PER BFG ER AND SRM.SDR 05FDEA03898Floorbeam · damagedFOUND DOUBLE HOLE IN FLOORBEAM BS 740 LBL 47 WL 208. REPAIRED PER FED EX EA 7-5810-91429.SDR 05FDEA03895Floorbeam · corrodedMAIN CABIN FLOORBEAM TEE CAP CORRODED STA 620 RBL 10 AND RBL15. REMOVED DAMAGED AREA AND INSTALLED FILLER AND 2 (EA.) REPAIR ANGLES IAW B727 SRM 53-10-8 FIG 8. ALODINED AND PRIMED SAME IAW B727 SRM 51-10-2.SDR AWXA200501516Floorbeam · corrodedMCN - DURING C19 CHECK DISCOVERED CORROSION ON THE TOP AND BOTTOM SURFACE ON TRANSVERSE BEAM FROM BL 19L TO BL 19R, WL 208 AND BS 986. CORROSION WAS FOUND TO BE OUT O LIMITS IAW BOEING 737-300 SRM 53-60-51-1A1 FIG 101. MAINTENANCE REPAIRED BEAM FROM BL 19L TSDR AWXA200501504Floorbeam · corrodedMCN - DURING C19 CHECK DISCOVERED CORROSION ON TOP OF TCAP ON BEAM BS 1016, BL 6R AND WL 208. FOUND CORROSION TO BE OUT OF LIMITS IAW BOEING 737-300 SRM 53-560-51-1A-1, CUT OUT DAMAGED AREA IAW BOEING 737-300 SRM 51-10-12-06. FABRICATED ANGLES, FILLER, AND ESDR AWXA200501503Floorbeam · corrodedMCN - DURING C19 DISCOVERED CORROSION ON FLOOR SUPPORT AT BS 961, BL 10R TO BL 17R AND WL 208. CORROSION WAS FOUND TO BE OUT OF LIMITS IAW BOEING 737-300 SRM 53-60-51-1A1 FIG 101. MAINTENANCE REMOVED AND INSTALLED NEW FLOOR SUPPORT AT BS 961, BL 10R TO 17R ASDR AWXA200501502Floorbeam · corrodedMCN - DURING C19 DISCOVERED CORROSION ON FLOOR SUPPORT AT BS 957, BL 24R AND WL 208. CORROSION WAS FOUND TO BE OUT OF LIMITS IAW BOEING 737-300 SRM 53-60-51-1A1 FIG 101. MAINTENANCE REMOVED AND INSTALLED NEW FLOOR SUPPORT AT BS 957, BL 24R AND WL 208 IAW BOESDR AWXA200501497Floorbeam · corrodedMCN - DURING C19 CHECK DISCOVERED CORROSION ON THE FLOOR SUPPORT ASSEMBLY AT BS 961, BL 36R TO BL 35R AND WL 208. CORROSION WAS FOUND TO BE OUT OF LIMITS IAW BOEING 737-300 SRM 53-60-51A1 FIG 101. MAINTENANCE REMOVED AND INSTALLED NEW FLOOR SUPPORT ASSEMBLY SDR SWAA053659Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CABIN FLOORBEAM CORRODED AT BS 344, BETWEEN BL 0 TO LBL 7.REPAIRED FLOORBEAM PER SWA EA.SDR SWAA053658Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CABIN FLOORBEAM CORRODED AT BS 328, BL 0. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA053657Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CABIN FLOORBEAM CORRODED AT BS 312, RBL 35. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA053628Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND FUSELAGE FLOORBEAM CORRODED AT BS 986.5, BETWEEN RBL 20 TO RBL 41. REPAIRED FLOORBEAM PER SRM.SDR UPS05545777Floorbeam · corrodedINSPECTION TYPE:C CORROSION ON MAIN CARGO FLOORBEAM BS 1200, BL-0 TO RBL 60. REPAIRED FLOORBEAM IAW GOODRICH ER 05-4846.SDR UPS05545775Floorbeam · corrodedINSPECTION TYPE:C CORRISOIN ON MAIN CARGO BAY FLOORBEAM BS 1200, BL-0 TO LBL 60. REPAIRED FLOORBEAM IAW GOODRICH ER 05-4846.SDR USAA051403Floorbeam · corrodedMAIN CABIN FLOORBEAM TEE STA 986.5 RBL 20-30 CORRODED. REMOVED & REPLACED TEE PER TYP REP 53-60-01. DEFECT SIZE: 10 INCHES.SDR USAA051401Floorbeam · corrodedFLOOR SUPPORT BEAM AT FR 75, Y-441; CORROSION LEVEL 1; TASK C534159-01. DEFECTIVE PART REPLACED WITH IDENTICAL PART PER SRM 51-72-11. DEFECT SIZE: 1 X 1 INCH AREA.SDR ASAA0540658Floorbeam · corrodedPAE - FOUND CORROSION AROUND FASTENER HOLES IN FLOORBEAM UPPER CHORD AT BS 986, RLB 24 TO LBL 44, WL 208. REPAIRED PER B737-400 SRM 53-60-51 AND EA 5310-0251. (M)SDR DL73S050712Floorbeam · crackedTHE OVERWING FLOORBEAM AT LBL 24.8 WAS FOUND CRACKED. INSPECTED PER ER/A 451613-14AD. REF AD 2001-17-18, SI 03-056673-12AD, ER/A 369397-14.SDR USAA051374Floorbeam · corrodedFOUND CORROSION FS 17 AT Y1292; CORROSION LEVEL 1; TASK JA-220-53500. INSTALLED FILLER PER SRM 51-00-14 FIG 204, DEFECT SIZE: 3/4" BY 3/4".SDR USAA051373Floorbeam · corrodedFOUND CORROSION FLOORBEAM Y-1292 13" AFT OF FS 23; CORROSION LEVEL 1; TASK JA-220-53500. REMOVED AND REPLACED BEAM PER SRM 51-72-11, DEFECT SIZE: 1" BY 1".SDR USAA051372Floorbeam · corrodedFOUND CORROSION FLOORBEAM SEGMENT -Y1162, -Y1292 FS 66-68; CORROSION LEVEL 1; TASK JA-260-5350. REPLACED 3 SEGMENTS OF BEAM WITH IDENTICAL PARTS PER DWG D53472780 AND TYP REP 51-40-01, DEFECT SIZE: 1" BY 1", 1/2" BY 1/2", 1/2" BY 3/4".
Back to JASC 5315