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 SWAA103769Floorbeam · crackedDURING SCHEDULED MV2 CHECK, FOUND LT FLOORBEAM T-CHORD CRACKED AT BS 312. REMOVED AND REPLACED T-CHORD PER SRM.SDR SWAA103731Floorbeam · crackedDURING SCHEDULED 16Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 727B, LBL 45.50. REPAIRED BEAM PER EO.SDR SWAA103703Floorbeam · corrodedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM CORRODED AT BS 986.5, RBL 43.5. REPAIRED BEAM PER SRM.SDR SWAA103696Floorbeam · corrodedDURING SCHEDULED16Y CHECK, FOUND FLOORBEAM CORRODED AT BS 986.5, LBL 43.5. REPAIRED BEAM PER SRM.SDR DALA1014526311Floorbeam · corrodedDURING M-CHECK FOUND CORROSION ON FLOORBEAM AT BS 1700 LBL50-LBL77. REPAIRED IAW SRM 53-60-51 FIGURE 201.SDR DALA1014486311Floorbeam · corrodedDURING M-CHECK FOUND CORROSION ON FLOORBEAM AT BS 1700 RBL 40-77. REPAIRED IAW SRM 53-60-51 FIG 201.SDR DALA1014406311Floorbeam · corrodedDURING M-CHECK FOUND CORROSION ON FLOORBEAM AT BS1700 LBL50-LBL77. REPAIRED IAW SRM 53-60-51, FIG 201.SDR USAA2010062491264Floorbeam · corrodedBFM - Q5 - MAJOR REPAIR - LEVEL 2 CORROSION ON CABIN FLOORBEAM AT BS 312, BETWEEN BL 0 & RBL 8, WL 208.1. REPLACED CABIN FLOORBEAM AT BS 312, BETWEEN BL 0 & RBL 8, WL 208.1 IAW B737 SRM 53-10-13 & 53-00-51 REPAIR 1.SDR DALA1014436311Floorbeam · corrodedDURING M-CHECK FOUND CORROSION ON PANEL SUPPORT AT BS 880 LBL48 TO RBL20. REPAIRED IAW DWG SA35890-50.SDR AALA20100622TUL04Floorbeam · crackedFLOORBEAM CRACKED STATION 660. INSTALLED TEE-CAP REPAIR PER SRM 53-00-51-2R-3.SDR A6WA201040601Floorbeam · corrodedFS 280 FLOOR STRUCTURE BENEATH FLIGHT COMPARTMENT CTR FLOOR PANEL HAS CORROSION. REPAIRED DAMAGE TO FS 280 BULKHEAD WEB IAW REO 601R-53-11-926.SDR A6WA201040600Floorbeam · crackedFS 280 FWD FLOOR SUPPORT ANGLE BENEATH CTR FLIGHT COMPARTMENT FLOORBOARD CRACKED. R & R FS 280 FWD ANGLE IAW SRM 51-42-06 & 51-42-21.SDR A6WA201040468Floorbeam · corrodedFLOORBEAM AT FS 349 IS CORRODED, REO 601R-53-21-1143 CARRIED OUT.SDR FDEA201006222110Floorbeam · corrodedFLOORBEAM UPPER TEE, STA. 365 B.L. 0 TO RBL 59 CORRODED. REMOVED CORROSION ORIGINAL MATERIAL .125, MATERIAL REMOVED .016, FOUND TO BE OUT OF LIMITS IAW SRM 53-00-51 FIG 101, DETAIL III. INSTALLED REPAIR AT STA 365, LBL 17- RBL 70, IAW SRM 53-00-51 FIG 201, RESDR SWAA103629Floorbeam · corrodedDURING SCHEDULED 12Y CHECK, FOUND FLOORBEAM CORRODED AT BS 328, RBL 21. REPAIRED BEAM PER SRM.SDR AALA20100621TUL02Strap · damagedLOWER FLOORBEAM STRAP, AFT SIDE OF 660 LEFT BUTTLINE 45, HAS DAMAGED HOLES. INSTALLED REPAIR DOUBLER PER SRM 53-10-51-2R 1.SDR UALA2010062202194Floorbeam · corrodedMAIN CABIN FLOORBEAM UPPER TEE CORRODED AT BS 1541, LBL 30. MAJOR REPAIR ACCOMPLISHED: FLOORBEAM TEE HAS 100 PERCENT MATERIAL LOSS, OUT OF LIMITS. REMOVED DAMAGED AREA AND FABRICATED REPAIR ANGLES, STRAPS AND FILLERS AND INSTALLED.SDR GTIA1000028Floorbeam · corrodedFWD RT PARTITION ATTACH POINTS AT FLOOR HAVE CORROSION.SDR DALA1013713268Floorbeam · corrodedDURING M-CHECK FOUND CORROSION ON RT FLOOR SUPPORT BEAM Y1292 BETWEEN FR66 & FR68. REPAIRED IAW SRM 51-42-11.SDR DALA1013703268Floorbeam · corrodedDURING M-CHECK FOUND CORROSION ON RT FLOOR SUPPORT BEAM Y1292 AT FR66. REPAIRED IAW SRM 51-42-11.SDR SWAA103540Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM CORRODED AT BS 986, FROM RBL 22 TO RBL 45. REPAIRED BEAM PER SRM.SDR FDEA201006192224Floorbeam · damagedFLOORBEAM TEE HAS DOUBLE DRILLED HOLE BS 353 LBL 52 MAIN CARGO CAMPARTMENT. REMOVED DAMAGED PART IAW SRM 51-40-02. RECEIVED NEW REPAIR ANGLES TRAV NR T10/836720, AND REPAIR STRAPS TRAV NR T10/836719. INSTALLED NEW REPAIR SPLICE PARTS FLOORBEAM UPPER TEE AT SDR DALA1013673267Floorbeam · corrodedDURING M-CHECK FOUND CORROSION ON BEAM AT Y765 BETWEEN FR66 & FR68. REPAIRED IAW SRM 53-41-15, SRM 51-22-00, SRM 53-41-15.SDR DALA1013653267Floorbeam · corrodedDURING M-CHECK FOUND CORROSION ON BEAM AT Y1292 BETWEEN FR68 & FR69. REPAIRED IAW SRM 51-42-11.SDR DALA1013643267Floorbeam · corrodedDURING M-CHECK FOUND CORROSION ON BEAM AT Y1292 BETWEEN FR67 & FR68. REPAIRED IAW SRM 51-42-11.SDR FDEA201006192077Floorbeam · corrodedAFT CARGO COMPT FRAME 58 LT SIDE FLOOR SUPPORT BEAM, LBL 44 UNDER SIDE HAD EXFOLIATION CORROSION APROX 4SQ IN IN TOTAL. REMOVED CORROSION IAW SRM 51-74-10 CHECK AREA FOUND TO BE OUT OF LIMIT IAW SRM 53-10-15. REPAIRED FLOOR SUPPORT BEAM IAW SRM 53-10-15.SDR FDEA201006182106Floorbeam · corrodedMAIN CARGO DECK STA 950 RBL 24 FLOORBEAM TEE CORRODED. CORROSION OUT OF LIMITS. REMOVED TEE FROM LBL 63 TO RBL 63. FABRICATED NEW TEE USING BAC1505-100405 7075T6 DIMS 127 3/8" IAW DWG 65-16338 AND INSTALLED IAW SRM 51-30-2.SDR USAA2010062491265Floorbeam · corrodedBFM - Q5 - MAJOR REPAIR - LEVEL 2 CORROSION ON CABIN FLOORBEAM UPPER T-CHORD AT BS 328 BETWEEN BL 0 TO RBL 24, WL 208. REPLACED FLOORBEAM AT BS 328 BETWEEN BL 0 TO RBL 24, WL 208 IAW B737 SRM 53-10-51& 51-00-51 REPAIR 1.SDR DALA1013613267Floorbeam · corrodedDURING M-CHECK FOUND CORROSION ON FLOORBEAM AT Y1292 FR68-FR69. REPAIRED IAW SRM 53-41-15, SRM 51-42-11.SDR DALA1013603267Floorbeam · corrodedDURING M-CHECK FOUND CORROSION ON FLOORBEAM AT Y1292 FR66. REPAIRED IAW SRM 53-41-15, SRM 51-42-11.SDR C77A272550Floorbeam · corrodedDURING BASIC CHECK INSP VISIT CORROSION WAS ON LT FWD FUSELAGE FLOORBEAM PN 170-03264-001. PERMENENT REPAIR WAS ACCOMPLISHED REF EMB ETD2010-170/05014 AND COMPASS EO E175-53MR-036.SDR FDEA201006182052Floorbeam · corrodedFWD CARGO COMPARTMENT FLOORBEAM HAS 3X1 INCH CORROSION UNDER NR 1L CARGO LOADING ROLLER TRACK AT FR 33. REMOVED CORROSION AND CHECKED MATERIAL LOSS FOUND 100 PERCENT LOSS. REPAIRED FLOORBEAM IAW SRM 53-10-15, PAGE 237.SDR FDEA201006172042Floorbeam · corrodedFLOORBEAM BL0 AND STA 324 GOUGED. DAMAGED FLOORBEAM FOUND OUT OF LIMITS WITH ORGINAL MATERIAL .110 LOSS.024 MATERIAL REMAINING .086, L-.050 W-2" AS PER SRM 53-00-51 PG.103 DETAIL 3 & FLOOR SUPPORT ORGINIAL MATERIAL .050 MATERIAL LOSS .009 REMAINING MATERISDR USAA2010070791360Floorbeam · corrodedPIT - S4 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM AT FR21, -Y254. REPLACED FLOORBEAM AT FR21, -Y254 IAW A319 SRM 51-72-11.SDR DALA1013693268Floorbeam · corrodedDURING M-CHECK FOUND CORROSION ON RT AFT CABIN FLOOR SUPPORT BEAM AT Y464.4 FORWARD OF FR 66. REPAIRED IAW SRM 51-42-11.SDR AALA20100617AFW01Floorbeam · corrodedDURING HEAVY CHECK, LOCAL CORROSION WAS FOUND ON THE STA 347 FLOORBEAM UPPER CAP BETWEEN RBL 54.5 AND RBL 68.25. THE CORROSION WAS CENTRALIZED AROUND NUT PLATE SCREW HOLES ON THE FLANGE OF THE INNER CHORD. ALL CORROSION WAS REMOVED BY BLENDING. THE BLENDS WERESDR DALA1013183267Floorbeam · corrodedDURING M-CHECK, FOUND CORROSION ON BEAM AT Y254 FR66. REPAIRED IAW SRM 51-42-11.SDR IPXA10560556Floorbeam · corrodedINSPECTION TYPE:C3, MLB FLOORBEAM HAS EXFOLIATION CORROSION ON UPPER FLANGE, BS 879, LBL 20, WL 208. REPAIRED FLOORBEAM IAW ER 10-2912.SDR IPXA10560554Floorbeam · corrodedINSPECTION TYPE:C3 MLB FLOORBEAM HAS EXFOLIATION CORROSION ON UPPER FLANGE, BS 879, LBL 20, WL 208. REPAIRED FLOORBEAM IAW ER 10-2912.SDR USAA2010070791359Floorbeam · corrodedPIT - S4 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM AT FR66, -Y254. REPLACED FLOORBEAM AT FR66, -Y254 IAW A319 SRM 51-42-11 & 51-72-11.SDR USAA2010062991301Floorbeam · corrodedPIT - S4 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM AT FR66, -Y254. REPLACED FLOORBEAM AT FR66, -Y254 IAW A319 SRM 51-42-11 & 51-72-11.SDR SWAA103516Floorbeam · crackedDURING SCHEDULED 12Y CHECK, FOUND FLOORBEAM CRACKED AT BS 294.5, RBL 55. REPAIRED BEAM PER SRM.SDR DALA1012993268Floorbeam · corrodedDURING M-CHECK FOUND CORROSION ON FLOOR SUPPORT BEAM AT Y254 FORWARD OF FR68. REPAIRED IAW SRM 51-44-11, SRM 51-42-11.SDR DALA1012983268Floorbeam · corrodedDURING M-CHECK FOUND CORROSION ON FLOOR SUPPORT BEAM AT Y254 FWD OF FR70. REPAIRED IAW SRM 51-44-11, SRM 51-42-11.SDR DALA1012973268Floorbeam · corrodedDURING M-CHECK FOUND CORROSION ON FLOOR SUPPORT BEAM AT +Y765 FR66. REPAIRED IAW SRM 51-44-11, SRM 51-42-11.SDR FDEA201006141996Floorbeam · crackedFORWARD CARGO COMPARTMENT FLOOR BEAM IS CRACKED; RIGHT HAND SIDE OF THE MIDDLE ROLLER TRAYS AT FS 808 TO FS 808. REPAIRED FWD CARGO PIT FLOOR BEAM AT STA 808; RBL 32 IAW MD/DC10 SRM 53-00-01, FIG 7, PG 23, VOL I.SDR SWAA103489Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED AT BS 328, RBL 12. REPAIRED BEAM PER SRM.SDR SWAA103472Floorbeam · crackedDURING SCHEDULED 14Y CHECK, FOUND FLOORBEAM WEB CRACKED AT BS 705, LBL 46.5. REPAIRED WEB PER AAR EA.SDR DALA1012863267Floorbeam · corrodedDURING M-CHECK FOUND CORROSION ON BEAM INBD SPLICE AT Y1292 FR68. REPAIRED IAW SRM 51-42-11.SDR FDEA201006141985Floorbeam · corrodedLWR AFT CARGO FLOORBEAM, FR 63 FWD FLANGE HAS 6 SQUARE INCHES OF CORROSION AT 30"-34" LT OF CTR ON LOWER SURFACE OF FLANGE (IN AND AROUND FASTENER HOLES) REMOVED CORROSION IAW SRM 51-74-10, CHECKED LIMITS FOUND OUT OF LIMITS IAW SRM 53-10-15, PB 101 AND 53-10-
Back to JASC 5315