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 AALA20090911AFW03Floorbeam · corrodedCORROSION WAS FOUND ON FLOORBEAM 303 INNER CHORD BETWEEN RBL 35 AND RBL 46. THE CORROSION WAS REMOVED BY BLENDING AND A HFEC SURFACE AND OPEN-HOLE INSPECTION WAS ACCOMPLISHED TO ENSURE ALL CORROSION WAS REMOVED AND NO CRACKS EXIT. A REPAIR STRAP OF 0.063 INCSDR AALA20090911AFW02Floorbeam · corrodedCORROSION WAS FOUND ON FLOORBEAM 347 INNER CHORD BETWEEN RBL 22.5 AND RBL 30. THE CORROSION WAS REMOVED BY BLENDING RBL 22.5, 26 AND 30. A HFEC INSPECTION WAS ACCOMPLISHED TO ENSURE ALL CORROSION WAS REMOVED AND NO CRACKS EXIST. A REPAIR STRAP OF 0.050 INCHSDR AALA20090911AFW01Floorbeam · corrodedCORROSION WAS FOUND ON INNER CHORD OF STATION 325 FLOORBEAM. THE CORROSION WAS BLENDED AT LBL 22,18,14 AND RBL 4, 13, 24, 44 AND 55 LBL 18 AND RBL 13 REQUIRED TRIM OUT AND A SINGLE FLANGE REPAIR PER 767-200 SRM 53-00-51-2R. THE REMAINING BLENDED AREAS WERE RSDR SWAA095777Floorbeam · corrodedDURING SCHEDULED 6Y CHECK, FOUND FLOORBEAM CORRODED AT BS 773, LBL 12. REPAIRED BEAM PER SWA EA.SDR SWAA095776Floorbeam · corrodedDURING SCHEDULED 6Y CHECK, FOUND FLOORBEAM CORRODED AT BS 773, LBL 18. REPAIRED BEAM PER SWA EA.SDR SWAA095740Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED AT BS 986.5, RBL 5. REPAIRED BEAM PER SWA EA.SDR CALA2009090800534Floorbeam · corrodedFLOORBEAM STA 344 BL 0 CORROSION IS OUT OF LIMITS. CUT OUT DAMAGE AND REPAIRED FLOORBEAM 344 AT BL 0 WITH FLOORBEAM SPLICE REPAIR REF EC/RA 5321-01687.SDR IPXA09557398Floorbeam · corrodedINSPECTION TYPE:C2 MAIN CARGO DECK FLOORBEAM UPPER CHORD AT BS 1100 LBL 60 - RBL 60 HAS CORROSION. REPAIRED MAIN CARGO DECK FLOORBEAM UPPER CHORD AT BS 1100 LBL 60 TO RBL 60 IAW ER 09-4426 BOEING'S DRAWING D634N301.SDR IPXA09557373Floorbeam · corrodedINSPECTION TYPE:C2 MAIN CARGO DECK FLOORBEAM UPPER CHORD AT BS 1100 LBL 60 RBL 60 HAS CORROSION. REPAIRED MAIN CARGO DECK FLOORBEAM UPPER CHORD AT BS 1100 LBL 60 TO RBL 60 IAW ER 09-4426 BOEING DRAWING D634N301.SDR IPXA09557328Floorbeam · corrodedINSPECTION TYPE:C2 MAIN CARGO DECK FLOORBEAM UPPER CHORD AT BS 1200 LBL - RBL60 HAS CORROSION. REPAIRED MAIN CARGO DECK FLOORBEAM IAW SRM 53-00-51-1A SRM 51-10-02-0G AND ER 09-4417.SDR ASAA0946518Floorbeam · corrodedCABIN FLOORBEAM STA 986.5 HAS AREAS OF CORROSION RBL 60 TO LBL 60. REPAIRED FLOORBEAM IAW EA.SDR IPXA09657337Angle · crackedINSPECTION TYPE:C MEC COMPT FLOORBEAM STA 246 ANGLE FOUND CRACKED AT LBL 25. CRACK LENGTH 0.75 INCH. MEC COMPT FLOORBEAM STA 246 ANGLE REPLACED AS PER SRM 51-10-02 AND INSTALLED AS PER SRM 51-40-02 REV 45 JUST AT LBL 25.SDR IPXA09657336Fitting · crackedINSPECTION TYPE:C MEC COMPT STA 246 FLOORBEAM CLIP FOUND CRACK AT RBL 10. CRACK LENGTH 1.5 INCH. MEC COMPT STA 246 FLOORBEAM CLIP REPLACED AS PER SRM 51-10-02 AND INSTALLED AS PER SRM 51-40-02 REV 45 JUST AT RBL 10.SDR IPXA09657335Fitting · crackedINSPECTION TYPE:C MEC COMPT STA 246 FLOORBEAM CLIP FOUND CRACK JUST AT LBL 50. CRACK LENGTH 1 INCH. MEC COMPT STA 246 FLOORBEAM CLIP REPLACED AS PER SRM 51-10-02 AND INSTALLED AS PER SRM 51-40-02 REV 45 JUST AT LBL 50.SDR IPXA09657298Stiffener · crackedINSPECTION TYPE:C MEC COMPT STA 246 FLOORBEAM STIFFENER FOUND CRACK AT LBL 40 ( CRACK LENGTH 1.125" ). MEC COMPT STA 246 FLOORBEAM STIFFENER REPAIRED AS PER SRM 53-10-51- 2R4 FIG 201 AT LBL 40. THIS IS CLASSIFIED A MAJOR REPAIR WITH MATERIAL 7075T6-0063. RESDR USAA2009090292327Floorbeam · corrodedCLT - Q4 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON T-CAP BETWEEN BS 927 TO BS 947.5, BL 0. REPAIRED T-CAP BETWEEN BS 927 TO BS 947.5, BL 0 IAW B737 SRM 53-60-51R3 & EA 101389.SDR SWAA095651Floorbeam · crackedDURING SCHEDULED 18Y CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED AT BS 706, RBL 24.5. REPAIRED WEB PER AAR EA.SDR FDEA200909013202Floorbeam · crackedAFT CARGO COMPT FLOOR PANEL SUPPORT FOUND WITH .2500 INCH CRACK THROUGH NUTPLATE HOLE AT STA 1493 LBL 10.45. CRACKED SUPPORT ANGLE REMOVED AND REPLACED IAW SRM 51-40-02 REV 97. REPAIR IS CLASSIFIED AS MINOR IAW GMM 6-2-100.SDR USAA2009090292324Strap · crackedCLT - Q4 - MAJOR REPAIR - CRACK ON FLOORBEAM STRAP AT BS 328, RBL 32. REPLACED FLOORBEAM STRAP AT BS 328, RBL 32 IAW B737 SRM 51-10-2.SDR SWAA095633Floorbeam · corrodedDURING SCHEDULED 10Y CHECK, FOUND FLOORBEAM CORRODED AT BS 772, LBL 8. REPAIRED BEAM PER SWA EA.SDR SWAA095632Floorbeam · corrodedDURING SCHEDULED 10Y CHECK, FOUND FLOORBEAM CORRODED AT BS 772, LBL 12. REPAIRED BEAM PER SWA EA.SDR SWAA095631Floorbeam · corrodedDURING SCHEDULED 10Y CHECK, FOUND FLOORBEAM CORRODED AT BS 772, LBL 17. REPAIRED BEAM PER SWA EA.SDR FDEA200908313169Floorbeam · corrodedFWD CARGO FLOORBEAM SPLICE ANGLE BELOW FOUND CORROSION AT STA 633 BL 3, 8, 12, 16 AND RBL 3,8, 12, 16. CORRODED SUPPORT SPLICE ANGLES REMOVED AND REPLACED IAW SRM 51-40-02 REV 97. REPAIR IS CLASSIFIED AS MINOR IAW GMM 6-2-100 CRITERIA.SDR FDEA200908313160Floorbeam · corrodedBS 740 RBL 8 FLOOR SUPPORT ANGLE CORRODED. CORRODED SUPPORT ANGLE REMOVED AND REPLACED IAW SRM 51-40-02 REV 97. REPAIR IS CLASSIFIED AS MINOR GMM 6-2-100 CRITERIA.SDR ASOA200900993Floorbeam · crackedFLOORBEAM FS 280.00 JUST OTBD OF LBL 9.00 BELOW MLG AFT EXTENSION CABLE PULLEY BRACKET, WEB IS CRACKED APPROX 2 INCHES LONG.SDR F3LA2009090100148Floorbeam · corrodedDURING C6 C-CHECK, INSP NOTED A CORRODED NUT PLATE HOLE ON THE FLOORBEAM AT STA Y1292 JUST AFT OF FRAME 68. MX REMOVED AND REPLACED FLOORBEAM IAW SRM 51-42-11, 51-44-11 AND 53-00-14.SDR F3LA2009090100147Floorbeam · corrodedDURING C6 C-CHECK, INSP NOTED THE FLOORBEAM AT STA Y1162 HAS CORROSION 2 INCHES FWD OF FRAME 68. MX REMOVED AND REPLACED THE FLOORBEAM IAW SRM 51-42-11, 51-44-00 AND 51-42-11.SDR ASOA200900961Floorbeam · corrodedFLOOR SUPPORT ANGLES ARE CRACKED INBD AND OTBD SIDE OF LBL9 AT FS 280.0.SDR USAA2009091692546Floorbeam · corrodedMCN - C4 - MAJOR REPAIR - CORROSION ON CABIN LONGITUDINAL FLOORBEAM UPPER CAP AT BS 330 BETWEEN RBL 24 TO RBL 25. REPLACED CABIN LONGITUDINAL FLOORBEAM AT BS 330 BETWEEN RBL 24 TO RBL 25 IAW B757 SRM 51-40-02 & 53-00-51.SDR ASOA200900944Floorbeam · corrodedDURING 6 YEAR INSPECTION IAW TC 53-900-500, FOUND CORROSION OF FLOORBEAM AT FS 280.00. BLENDED AREA, FOUND TO BE OUT OF LIMITS. REMOVED AND REPLACED FS280 CROSSBEAM AS PER SRM 51-42-21, 51-42-06 SB 670BA-53-026.SDR ASAA0976471Floorbeam · corrodedUPPER WBE FLOORBEAM PREVIOUS REPAIR UPPER SURFACE CORROSION OUT OF LIMITS. REMOVED PREVIOUS REPAIR AND REPAIRED FLOORBEAM UPPER TEE FITTING.SDR SWIA200922764Floorbeam · corrodedFLOORBEAM AT FRAME 16L CORRODED. (C CHECK) REPLACED FLOORBEAM SUPPORT BRACKET PER SRM.SDR ASOA200901025Floorbeam · corrodedCARGO COMPARTMENT LBL 27.00 BETWEEN FS 574.00 FLOORBEAM UPPER CAP OTBD SIDE AROUND FASTENER HOLES HAS CORROSION APPROX 0.016" DEEP BEFORE CORROSION REMOVAL.SDR USAA2009090292326Floorbeam · corrodedCLT - Q4 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON T-CAP CHORD AT BS 344 BETWEEN LBL 34 TO RBL 34. REPAIRED T-CAP CHORD AT BS 344 BETWEEN LBL 34 TO RBL 34 IAW B737 SRM 53-10-51 REPAIR 5.SDR ASOA200900938Floorbeam · corrodedCOCKPIT FLOORBEAM FS 280 LBL 11.00" TO RBL 11.00", SEVERELY CORRODED.SDR SWAA095557Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM UPPER CHORD CORRODED AT BS 947.5, BETWEEN RBL 16 TO LBL 16. REPAIRED CHORD PER ER.SDR FDEA200908273112Floorbeam · failedTHE INCOMING FLOORBEAM REPAIR AT STA 1661 WILL INTERFERE WITH THE INSTALLATION OF SEAT TRACKS AND CREASE BEAMS. REMOVED FLOORBEAM AT STA 1661 IAW SRM 51-40-02, FABRICATED NEW BEAM FROM BAC 1518-338 BATCH NR 0001674883 IAW DWG 146N5090, ANODIZED IAW BAC 5019 RESDR FDEA200908273111Floorbeam · failedTHE INCOMING FLOORBEAM REPAIRS AT STA 1640 WILL INTERFERE WITH THE INSTALLATION OF SEAT TRACKS AND CREASE BEAM MODS. REMOVED FLOORBEAM AT STA 1640 IAW SRM 51-40-02, FABRICATED NEW FLOORBEAM FROM BAC1518-338 BATCH NR 0001674883 IAW DWG 146N5089, ANODIZED IAW BSDR UHLA2009082600081Floorbeam · corrodedFLOORBEAM UNDER FWD GALLEY HAS LIGHT SURFACE CORROSION AROUND TWO RIVET FASTENERS. PERFORMED REPAIR AS CALLED OUT IN EMB 170 IC2009-170/06914.SDR UHLA2009082600080Floorbeam · corrodedFLOORBEAM AT RIGHT FWD SERVICE DOOR HAS LIGHT SURFACE CORROSION UNDER FLOOR PANEL. PERFORMED REPAIR AS CALLED OUT IN IC2009-170-06914.SDR ASOA200901044Floorbeam · corrodedRT FS 280 FLOORBEAM HAS CORROSION AROUND NUTPLATE LOCATION AT APPROX RBL 22. REMOVED AFT COCKPIT FLOORBEAM IAW SRM 51-42-21. GVI PERFORMED NO DEFECTS NOTED. LOCATED AND DRILLED NEW RT FLOORBEAM IAW REO 670-53-11-047 REV E DATED 2009-03-13. P.RICE 09-19-09. SDR FDEA200908263104Floorbeam · corrodedMAIN CABIN FLOORBEAM STA 740, LBL 45 TO LBL 62, HAS AREAS OF CORROSION REMOVED FLOORBEAM SEC, FABRICATED A NEW WITH MATERIAL PN 7075-T6- .071C, FABED ANGLES ON MAE TRAVELER NR T9/800801,TR NR T9/800802, INSTALLED ALL REPAIR PARTS STA 740, LBL 45 TO LBL 62. SDR USAA2009082792267Floorbeam · corrodedCLT - Q4 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM T-CAP AFT FLANGE AT BS 986, RBL 18. REPAIRED FLOORBEAM T-CAP AFT FLANGE AT BS 986, RBL 18 IAW B737 SRM 53-60-51.SDR USAA2009082792266Support · crackedCLT - Q4 - MAJOR REPAIR - CRACK IN FLOORBEAM SUPPORT AT BS 328, RBL 30. REPLACED FLOORBEAM SUPPORT AT BS 328, RBL 30 IAW B737 SRM 51-10-02.SDR PIDA09037Floorbeam · corrodedDURING C-CHECK, FOUND CORROSION ON UPPER CAP OF FLOORBEAM 277 AT LBL 47. REPAIRED PER SRM 53-10-51 REPAIR 6.SDR CALA2009082600497Floorbeam · corrodedCORROSION IN AFT WET AREA FLOOR STA 986.5 RBL 42. CUT OUT DAMAGED SECTION OF FLOORBEAM, FABBED REPAIR PIECES, TREATED, PRIMED AND INSTALLED IN REF TO ECRA 5321-01429 AND ECRA 5321-01684.SDR A6WA200940548Floorbeam · corrodedFWD ANGLE FLOORBEAM AT FS 280.00 CORRODED. FWD ANGLE FLOORBEAM AT FS 280.00 CORROSION REMOVED IAW SRM 51-21-06.SDR ASAA0946432Floorbeam · corrodedFLOORBEAM AT STA 986 AND LBL 20 CORRODED. REPAIRED FLOORBEAM IAW SRM.SDR PIDA09036Floorbeam · corrodedDURING C-CHECK, FOUND CORROSION ON FLOORBEAM AT BS 294.5 AT RBL 48. REPLACED FLOORBEAM T-CAP FROM RBL 59 TO LBL 59 PER SRM 53-10-51 REPAIR 5 AND SRM 51-40-02.SDR 2009FA0000768Floorbeam · corrodedCORROSION FOUND ON FLOORBEAM, 11 INCHES FROM LEFT-BUTT-LINE, BETWEEN FRAMES 85 AND 87. (K)
Back to JASC 5315