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 2009FA0000767Floorbeam · corrodedCORROSION FOUND ON FLOORBEAM, 11 INCHES FROM LT-BUTT-LINE, BETWEEN FRAMES 85 AND 87. (K)SDR ASAA0946433Floorbeam · corrodedCABIN FLOORBEAM AT STA 312 AND RBL 8 CORRODED. REPAIRED FLOORBEAM IAW SRM.SDR SWAA095442Floorbeam · crackedDURING SCHEDULED SPV CHECK, FOUND FLOORBEAM CRACKED AT BS 311.5 AT UPPER FWD DOOR STOP FITTING. REPAIRED BEAM PER AAR EA.SDR CALA2009082500489Floorbeam · corrodedLATERAL INTERCOSTAL (FLOORBEAM) AT STATION 270 IS CORRODED AT BL-0. INSTALLED REPAIR PARTS PER ECRA 5321-01682.SDR FDEA200908243077Floorbeam · corrodedBS 705 RBL 3-16 FLOORBEAM CORRODED AND DAMAGED. CORRODED AND DAMAGED FLOORBEAM BS 705 REMOVED AND REPLACED IAW SRM 51-40-02 REV. 97. REPAIR IS CLASSIFIED AS MINOR PER GMM 6-2-100 CRITERIA.SDR A6WA200940536Floorbeam · corrodedCROSSBEAM WEB FS 280.00, BTW RBL 9 TO LBL 9WL 72.00 IS CORRODED. CROSSBEAM WEB FS 280.00 BTW RBL 9 TO LBL 9.00, WL 72.00. REPAIRED IAW REO 601R-53-11-926, REV B. (K)SDR ASAA0976437Floorbeam · corrodedFLOORBEAM UPPER CHORD CORRODED. REPAIRED PER SRM.SDR USAA2009082492231Floorbeam · corrodedCLT - Q3 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM AT BS 967, LBL 18. REPAIRED FLOORBEAM AT BS 967, LBL 18 IAW B737-400 SRM 53-00-51-2R-2.SDR USAA2009100192681Floorbeam · crackedMCN - C4 - MAJOR REPAIR - MAIN DECK FLOORBEAM CRACKED AT BS 700, WL 208, RBL 24.75. REPAIRED MAIN DECK FLOORBEAM AT BS 700 ,WL 208, RBL 24.75 IAW US AIRWAYS EA 130329.SDR ASAA0976452Floorbeam · corrodedUPPER LOBE FLOORBEAM PREVIOUS REPAIR FILLER PLATE UPPER SURFACE BS 986 WL 208 RBL 30 HAS CORROSION. REMOVED CORRODED FLOOR BEAM REPAIR FILLER FABRICATED FILLER ALODINED PRIMED AND INSTALLED PER SRM.SDR USAA2009082792263Floorbeam · corrodedCLT - Q4 - MAJOR REPAIR - LEVEL 1 EXFOLIATION CORROSION ON FLOORBEAM T-CAP AT BS 328 BETWEEN LBL 34 TO RBL 64 (AREA PREVIOUSLY BLENDED). REPLACED FLOORBEAM T-CAP AT BS 328 BETWEEN LBL 34 TO RBL 64 IAW B737 SRM 53-10-51 REPAIR 5.SDR FDEA200908213067Floorbeam · corrodedFWD CARGO FLOOR SUPPORT SPLICES (8 EACH) FOUND CORRODED AT STA 705 LBL 3, 8, 12, 16 AND RBL 3, 8, 12, 16. FLOOR SUPPORT SPLICES FOUND CORRODED BEYOND SRM ALLOWABLE DAMAGE LIMITS. SPLICES REMOVED AND REPLACED IAW SRM 51-40-02 REV 97. REPAIR IS CLASSIFIED SDR UALA2009082402597Floorbeam · corrodedMAIN CABIN FLOORBEAM STA 325, LBL 30 IS CORRODED. MAJOR REPAIR ACCOMPLISHED. CUT OUT UPPER T-CAP FROM RBL 30 TO RBL 70, STA 325. INSTALLED REPAIR T-CAP.SDR UALA2009082402596Floorbeam · corrodedMAIN CABIN FLOORBEAM CORRODED AT STA 287, BL 0 TO LBL 10. MAJOR REPAIR ACCOMPLISHED. INSTALLED NEW UPPER T-CAP FROM ZERO BL TO RBL 70, STA 287.SDR ABXR200908210007Floorbeam · crackedDURING THE ACCOMPLISHMENT OF A ROUTINE VISUAL AND EDDY CURRENT INSP OF THE CARGO DOOR STRUCTURE, THE FLOORBEAM SPLICE PLATE WAS FOUND CRACKED. THE SPLICE PLATE WAS REMOVED AND REPLACED. ITEM WAS RETURNED TO SERVICE.SDR ABXR200908210006Floorbeam · crackedDURING THE ACCOMPLISHMENT OF A ROUTINE VISUAL AND EDDY CURRENT INSP OF THE CARGO DOOR STRUCTURE, THE FLOORBEAM SPLICE PLATE WAS FOUND CRACKED. THE SPLICE PLATE WAS REMOVED AND REPLACED. ITEM WAS RETURNED TO SERVICE.SDR ABXR200908210005Floorbeam · crackedDURING THE ACCOMPLISHMENT OF A ROUTINE VISUAL AND EDDY CURRENT INSP OF THE CARGO DOOR STRUCTURE, THE FLOORBEAM SPLICE PLATE WAS FOUND CRACKED. THE SPLICE PLATE WAS REMOVED AND REPLACED. ITEM WAS RETURNED TO SERVICE.SDR ABXR200908210004Floorbeam · crackedDURING THE ACCOMPLISHMENT OF A ROUTINE VISUAL AND EDDY CURRENT INSP OF THE CARGO DOOR STRUCTURE, THE FLOORBEAM SPLICE PLATE WAS FOUND CRACKED. THE SPLICE PLATE WAS REMOVED AND REPLACED. ITEM WAS RETURNED TO SERVICE.SDR ABXR200908210003Floorbeam · crackedDURING THE ACCOMPLISHMENT OF A ROUTINE VISUAL AND EDDY CURRENT INSP OF THE AEI CARGO DOOR STRUCTURE, THE FLOORBEAM SPLICE PLATE WAS FOUND CRACKED. THE SPLICE PLATE WAS REMOVED AND REPLACED. ITEM WAS RETURNED TO SERVICE.SDR ABXR200908210002Floorbeam · crackedDURING THE ACCOMPLISHMENT OF A ROUTINE VISUAL AND EDDY CURRENT OF THE CARGO DOOR FLOOR STRUCTURE, THE FLOORBEAM SPLICE PLATE WAS FOUND CRACKED. THE SPLICE PLATE WAS REMOVED AND REPLACED. ITEM WAS RETURNED TO SERVICE.SDR USAA2009093092667Floorbeam · crackedMCN - C4 - MAJOR REPAIR - CRACK ON FLOORBEAM AT BS 1320, RBL 45.50. REPAIRED FLOORBEAM AT BS 1320, RBL 45.50 IAW EA 130332.SDR CALA2009082400478Floorbeam · corrodedCORROSION IN AFT WET AREA FLOOR AT STA 986.5 LBL 42. REPAIRED FLOORBEAM AT STA 986 LBL 42 REF ECRA 5321-01429 REPAIR A.SDR SWAA095408Floorbeam · corrodedDURING SCHEDULED 10Y CHECK, FOUND FLOORBEAM CORRODED AT BS 767, RBL 6. REPAIRED FLOORBEAM PER SWA EA.SDR UALA2009082102563Stiffener · crackedFLOORBEAM AT BS 246, VERTICAL STIFFENER CRACKED AT LBL 24. MAJOR REPAIR ACCOMPLISHED. INSTALLED NEW STIFFENER.SDR USAA2009092492619Floorbeam · corrodedSAL - C23 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM AT BS 986.5 BETWEEN LBL 44 TO RBL 33. REPAIRED FLOORBEAM AT BS 986.5 BETWEEN LBL 44 TO RBL 33 IAW EA 132609.SDR USAA2009082492229Floorbeam · corrodedCLT - Q3 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM AT BS 967, BETWEEN RBL 5 TO RBL 42. REPAIRED FLOORBEAM AT BS 967, BETWEEN RBL 5 TO RBL 42 IAW EA 101371.SDR AALA20090825TUL23Floorbeam · damagedFLOORBEAM AT STATION 1098 UNDER SEAT TRACK NUMBER 4 IS DAMAGED. INSTALLED DOUBLER ON FLOORBEAM AT STATION 1098 UNDER EA MD80-53-007159.SDR SWAA095404Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED AT BS 706, RBL 24.5. REPAIRED WEB PER SWA EA.SDR IPXA09657149Stiffener · crackedINSPECTION TYPE:C MEC COMPT STA 246 LBL 40 FLOORBEAM ATT STIFFENER FOUND CRACKED (CRACK LENGTH 1.25 INCH). MEC COMPT STA 246 LBL 40 FLOORBEAM ATTACH STIFFENER REPAIRED REF SRM 53-10-51-2R4 REV 44. THIS IS CLASSIFIED AS MAJOR REPAIR WITH MATERIAL 7075T6-0.063SDR IPXA09657111Attach Angle · crackedINSPECTION TYPE:ETOP MEC COMPT STA 246 LBL 25 FLOORBEAM ATT ANGLE FOUND CRACK. MEC COMPT STA 246 LBL 25 FLOORBEAM ATT ANGLE REPLACED AS PER SRM 51-10-02 AN INSTALLED AS PER SRM 51-40-02 REV 44.SDR ASOA200900899Floorbeam · corrodedLBL 27.0 FLOORBEAM CAP CORRODED ON FLANGES AROUND NUT PLATE HOLES, FS 574.0 - FS 621. REMOVED AND REPLACED LBL 27.0 FLOORBEAM CAP AT FS 574-0 - FS 621 IAW SRM 51-42-06, 51-42-21, 51-42-22, AND 51-42-34. DISPOSITION FOR ALTERNATE FASTENERS FOR AFT FUSELAGE FLSDR UALA2009081902541Floorbeam · corrodedMAIN CABIN FLOORBEAM STA 347 APPROX RBL 30 IS CORRODED. MAJOR REPAIR ACCOMPLISHED: CUTOUT DAMAGED TEE CAP RBL ZERO TO 70. FABRICATED SPLICE ANGLES AND NEW 'T' CAP AND INSTALLED.SDR A6WA200940532Floorbeam · crackedUNDER FLOOR FS 484, RBL 27 CLIP CRACKED. UNDER FLOOR FS 484, RBL 27 CLIP, REPLACED IAW SRM 51-21-42. (K)SDR SWAA095285Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM CHORD CRACKED BETWEEN BS 659.0 TO BS 673.75, LBL 24.5. REPAIRED CHORD PER EO.SDR FDEA200908173036Floorbeam · corrodedMAIN DECK FLOORBEAM AT STA 740, RBL 45 TO 58, UPPER CAP CORRODED. REMOVED SECTION, FABED STRAPS MAT-7075-T6-.063C, AND FABED ANGLES MAE TRAV NR T9/800804, T9/800803, IAW SRM 51-40-02. INSTALLED FLOORBEAM STRAPS AND ANGLES, ALL REPAIR PARTS, AT STA 740, FLOORSDR FDEA200908173035Floorbeam · damagedWHILE DELETING PARTS FOR AFT PALLET MOD, LT PRODUCTION FOUND SEVERAL FASTENER HOLES WITH LESS THAN 40 PITCH. DUE TO THE DISCREPANCY EFFECTING THE PTF MOD, A REPAIR WAS ACCOMPLISHED AT STA 1640, WHERE THE FLOORBEAM AND FRAME MEET. WORKED ON MAE MOD W/C 11835SDR FDEA200908173034Floorbeam · damagedWHILE DELETING PARTS FOR AFT PALLET MOD RHS PRODUCTION FOUND SEVERAL FASTENER HOLES WITH LESS THAN 40 PITCH. DUE TO DISCREPANCY EFFECTING THE PTF MOD, A REPAIR WAS ACCOMPLISHED AT STA 1640, WHERE THE FRAME AND FLOOR BEAM MEET. WORKED ON MAE MOD W/C 1183504SDR USAA2009090992457Floorbeam · corrodedSAL - BC7 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON BEAM BETWEEN FR68 TO FR69, -Y1292. REPLACED FLOORBEAM BETWEEN FR68 TO FR69, -Y1292 IAW A320 SRM 51-72-11.SDR USAA2009090992456Floorbeam · corrodedSAL - BC7 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON BEAM BETWEEN FR66+6 TO FR67+16, -Y1292. REPLACED FLOORBEAM BETWEEN FR66+6 TO FR67+16, -Y1292 IAW A320 SRM 51-72-11.SDR USAA2009090992455Floorbeam · corrodedSAL - BC7 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON BEAM BETWEEN FR66 TO FR70, -Y765. REPLACED FLOORBEAM BETWEEN FR66 TO FR70, -Y765 IAW A320 SRM 51-72-11.SDR USAA2009090992454Floorbeam · corrodedSAL - BC7 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON BEAM BETWEEN FR64 TO FR66, -Y512. REPLACED FLOORBEAM BETWEEN FR64 TO FR66, -Y512 IAW A320 SRM 51-72-11.SDR USAA2009090992453Floorbeam · corrodedSAL - BC7 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON BEAM BETWEEN FR68 TO FR70, Y254. REPLACED FLOORBEAM BETWEEN FR68 TO FR70, Y254 IAW A320 SRM 51-72-11.SDR USAA2009090992452Floorbeam · corrodedSAL - BC7 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON BEAM BETWEEN FR66+5 TO FR70, Y765. REPLACED FLOORBEAM BETWEEN FR66+5 TO FR70, Y765 IAW A320 SRM 51-72-11.SDR USAA2009090992451Floorbeam · corrodedSAL - BC7 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON SEAT BEAM BETWEEN FR65 TO FR66, Y765. REPLACED FLOORBEAM BETWEEN FR65 TO FR66, Y765 IAW A320 SRM 51-72-11.SDR USAA2009090992450Floorbeam · corrodedSAL - BC7 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM BETWEEN FR68 TO FR69, Y1292. REPLACED FLOORBEAM BETWEEN FR68 TO FR69, Y1292 IAW A320 SRM 51-72-11.SDR USAA2009090992449Floorbeam · corrodedSAL - BC7 - MAJOR REPAIR - LEVEL 2 - GALVANIC CORROSION ON FLOORBEAM BETWEEN FR66+5 TO FR67+16, Y1292. REPLACED FLOORBEAM BETWEEN FR66+5 TO FR67+16, Y1292 IAW A320 SRM 51-72-11.SDR USAA2009090192311Floorbeam · corrodedSAL - BC7 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM BETWEEN FR 69 TO FR 70, Y520. REPLACED FLOORBEAM BETWEEN FR 69 TO FR 70, Y520 IAW B737 SRM 51-72-11.SDR IPXA09557223Floorbeam · corrodedINSPECTION TYPE:C2 CORROSION ON UPPER SURFACE OF FLOORBEAM AT STA 1200 AT LBL 60 TO RBL 44. REPAIRED PER UPS EO B757-5310-34779-A AND ATS ER NR 09-4259.SDR IPXA09557222Floorbeam · corrodedINSPECTION TYPE:C2 FOUND CORROSION ON UPPER SURFACE OF FLOORBEAM AT STA 1100 AT LBL 60 TO RBL 60. REPAIRED BS 1100 FLOORBEAM PER UPS EO B757-5310-34763-A AND ATS ER NR 09-4275.SDR USAA2009081992181Floorbeam · corrodedCLT - Q3 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM T-CAP AT BS 987, BETWEEN LBL 7 TO LBL 20. REPAIRED FLOORBEAM T-CAP AT BS 987, BETWEEN LBL 7 TO LBL 20 IAW B737-400 SRM 53-00-51, REPAIR 3.
Back to JASC 5315