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 USAA980346Floorbeam · corrodedCLT - DURING A Q-1 CHECK VISUAL INSPECTION, FOUND A .5 INCH BY .5 INCH AREA OF CORROSION ON FLOORBEAM AT BS 344 LBL 09 UPPER CHORD. REMOVED DAMAGED AREA AND INSTALLED REPAIR PARTS AND ANGLES PER REPAIR DOCUMENT 53-10-51. (M)SDR UPS98227538Floorbeam · corrosionINSPECTION TYPE-SI, CORROSION (C53-111-01.00-03) ON LOWER CHORD OF BS 1130 FLOORBEAM BETWEEN LBL 2 AND RBL 51 WL 201. REPAIRED CORROSION WITH NEW PART IAW ENGINEERING REPAIR NR 98-2760.SDR UPS98227535Floorbeam · corrodedINSPECTION TYPE-SI, CORROSION (C53-224-04.00-01) ON MAIN DECK FLOORBEAM UPPER CHORD TOP FLANGE BS 1130, RBL 22, WL 208 AT SMALL DRILLED HOLE (NR 40 BIT). REPAIRED PER ENGINEERING REPAIR NR 98-2760.SDR UPS98227534Floorbeam · corrodedINSPECTION TYPE-SI, CORROSION (C53-224-04.00-01) ON MAIN DECK FLOORBEAM UPPER CHORD AT BS 1130, RBL 18, WL 208 UNDER SHEAR WEB. REPAIRED IAW ENGINEERING REPAIR NR 98-2760.SDR SIMA982382Floorbeam · corrodedSAW - DURING CPCP-1 INSPECTION, FOUND FLOORBEAM 36 WITH SEVERAL ELONGATED HOLES ADJACENT TO SERVICE DOOR, AND FLOORBEAMS 38 AND 40 WERE CORRODED. REPAIRED ALL FLOORBEAMS. AIRCRAFT RETURNED TO SERVICE. (M)SDR CALA9801562Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 480, RBL 24-65. A CHORD, ANGLES, STRAPS, AND STIFFENERS WERE INSTALLED IAW SRM 53-10-8, FIGURE 1.SDR 98ZZZM712Floorbeam · corrodedSAW - DURING CPCP-1 INSPECTION, FOUND FLOORBEAM 36 WITH SEVERAL ELONGATED HOLES ADJACENT TO SERVICE DOOR, AND FLOORBEAMS 38 AND 40 WERE CORRODED. REPAIRED ALL FLOORBEAMS. AIRCRAFT RETURNED TO SERVICE. (M)SDR 98ZZZM711Floorbeam · corrodedSAW - DURING CPCP-1 INSPECTION, FOUND FLOORBEAM 36 WITH SEVERAL ELONGATED HOLES ADJACENT TO SERVICE DOOR, AND FLOORBEAMS 38 AND 40 WERE CORRODED. REPAIRED ALL FLOORBEAMS. AIRCRAFT RETURNED TO SERVICE. (M)SDR USAA980361Floorbeam · corrodedPIT - DURING C-CHECK, FOUND TOP SURFACE CORRODED, 1 INCH BY 1 INCH AREA, FWD CARGO ENTRANCE FLOORBEAM. TEMPORARY REPAIR PER EA SBF100-51-009 AND T.R. 53-30-02. ITEM WAS FOUND ON C-CHECK 6-12-98. TEMPORARY REPAIR PER E.O. 49926 BEAM REPLACED ON Q-CHECK PER SSDR SWAA981868Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM UPPER CHORD UPPER SURFACE CORRODED AT BS 1008 & 1014, WL 208, LBL 30.5 & LBL 6.0. REPAIRED PER BOEING SRM.SDR SWAA981867Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM UPPER CHORD UPPER SURFACE CORRODED AT BS 986.5, WL 208, LBL 4.75, LBL 13.5 & LBL 30.5. REPAIRED PER BOEING SRM.SDR SWAA981866Floorbeam · gougedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM UPPER CHORD UPPER SURFACE FWD EDGE GOUGED AT BS 986, WL 208, RBL 44. REPAIRED PER BOEING SRM.SDR CALA9801535Floorbeam · crackedINSPECTION FOUND A 2 INCH CRACK IN FLOORBEAM LOWER CHORD AT STA 675, BBL 0.07. THE LOWER CHORD WAS REMOVED AND A NEW LOWER CHORD ANGLE AND TWO REINFORCING SPLICE ANGLES WERE INSTALLED IAW ECRA 5710-01929.SDR CALA9801526Floorbeam · corrodedINSPECTION FOUND AFT PIT FLOORBEAM CRACKED AT BS 950E ABOVE STRINGER 29L. THE CRACKED SECTION OF FLOORBEAM WAS REMOVED. A REPAIR WAS INSTALLED IAW SRM 51-40-4, 51-30-2, 51-10-2, AND MM 51-20-0.SDR CALA9801522Floorbeam · crackedINSPECTION FOUND A 1 INCH CRACK IN FLOORBEAM WEB AT STA 663, BL 0. A REPAIR WAS INSTALLED IAW ECRA 5710-01931.SDR USAA980357Floorbeam · corrodedCLT - DURING Q-3 CHECK VISUAL INSPECTION, FOUND A 6 INCH AREA OF CORROSION AROUND CLIP NUT HOLE .5 INCH BY .5 INCH STATION 328 FLOORBEAM UPPER CHORD BL0. CORROSION TASK NR C53-107-02. INSTALLED DOUBLER PER SRM 53-10-51 FIG 206. (M)SDR USAA980356Floorbeam · corrodedCLT - DURING A Q-3 CHECK VISUAL INSPECTION, FOUND A 6 INCH AREA OF CORROSION ON STATION 967 LBBL 5-0 FLOORBEAM. CORROSION TASK NR C53-107-02. REPAIRED ONE FLANGE UPPER CHORD PER SRM 53-00-51 FIG 203. (M)SDR USAA980355Floorbeam · corrodedCLT - DURING Q-3 CHECK VISUAL INSPECTION, FOUND .5 INCH BY .5 INCH AREA OF CORROSION AROUND NUTPLATE HOLES STATION 312 LBL 12 TO RBL 12 FLOORBEAM UPPER CHORD. CORROSION TASK NR C53-107-02. SPLICED IN A NEW 'T' CAP SECTION PER SRM 53-10-51. (M)SDR SWAA981859Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED FLOORBEAM UPPER CHORD AT BS 986.5, RBL 5, 22, 23, 26, 43.5, LBL 4.5, 14, 43.5, WL 208 AND WL 207. REPAIRED PER BOEING SRM.SDR SWAA981845Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED FLOORBEAM AT BS 312, LBL 39, 33, 20, 14 RBL 8, WL 208 AND WL 207. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981828Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND CARGO FLOORBEAM CORRODED AROUND NUT PLATE AT BS 727-947, LBL 12.5, WL 159; BS 727-947, LBL 8, WL 159; BS 727-947, LBL 3, WL 159 AND BS 727-947, RBL 8, WL 159. REMOVED AND REPLACED PER BOEING SRM.SDR RAIA980819Floorbeam · corrodedSTL - DURING MAINTENANCE CHECK, FOUND CORROSION AT FLOORBEAM 36 TOP CAP. MAINTENANCE REPAIRED FLOORBEAM 36 IAW ATR72 SRM. (M)SDR SWAA981806Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND CARGO FLOORBEAM CORRODED AROUND NUT PLATE AT BS 727-947, RBL 3, WL 159. REMOVED AND REPLACED PER BOEING SRM.SDR DL767981726Floorbeam · corrodedCORROSION DAMAGE WAS FOUND ON THE UPPER CAP OF THE OVERWING LONGITUDINAL FLOORBEAM AT RBL 54, FROM BS 850 TO THE AFT END OF THE UPPER CAP AT APPROX BS 1000. THE UPPER CAP WAS REPLACED, BUT THE ORIGINAL EXTRUSION COULD NOT BE OBTAINED. REPAIRED PER ERA 332058SDR CALA9801487Floorbeam · corrodedINSPECTION FOUND FORWARD GALLEY FLOORBEAM CORRODED AT STA 344, LBL 30 TO 20. THE FLOORBEAM WAS REMOVED AND REPLACED IAW SRM 53-10-51.SDR SIMA982312Floorbeam · corrodedSAW - DURING MBV-1 INSPECTION, FOUND FLOORBEAM 36.38 AND 39 CORRODED. REMOVED AND REPLACED THE FLOORBEAMS. AIRCRAFT RETURNED TO SERVICE. (M)SDR DL767981707Floorbeam · corrodedCORROSION WAS FOUND ON THE UPPER SURFACE OF THE BS 287 FLOORBEAM UPPER CHORD. IN ADDITION, AN EXISTING REPAIR WAS ALSO LOCATED IN THE SAME AREA. REPAIRED PER ERA 332044-14.SDR CALA9801486Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 312, RBL 15 AND LBL 20. REPAIR DOUBLERS WERE INSTALLED IAW SRM 53-10-51.SDR SWAA981795Floorbeam · dentedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM TIE STRAP DENTED AT BS 430, RBL 10, WL 156. REMOVED AND REPLACED PER BOEING MM.SDR AALA981552Floorbeam · corrodedTUL - CORROSION AT FLOORBEAM AT STA 344 FROM LBL 24 TO RBL 24. INSTALLED FLOORBEAM REPAIR PER ESO 11697 AT STA 344. ESO DATED 7-28-98. TST: 53,245 HOURS. CYCLES: 32,117. (X)SDR 98FDEA00550Floorbeam · corrodedUPPER LOBE BS 380 HEAVY CORROSION ON FLOORBEAM AT LBL 34. REMOVED CORROSION PER SRM 51-10-6. CORROSION REMOVAL OUT OF LIMITS. INSTALLED REPAIR PER AARD 53-10-07-2 PG 1 AND 2 FIG 3.SDR 98FDEA00523Floorbeam · corrodedWHILE WORKING NR 0170 FOUND CORROSION ON FLOORBEAM BS 328, RBL 14, WL 208. *S/D* REPAIRED FLOORBEAM BS 328, RBL 14, WL 208 PER FED-EX SRM 53-10-8 FIG 9.SDR UPS98227474Floorbeam · corrodedINSPECTION TYPE-SI, CORROSION (C53-224-01.05-01) FLOORBEAM BS 720D LBL 5 TO 25 WL 208. REMOVED CORROSION FOUND OUT OF LIMITS. REPAIRED IAW SRM 53-10-02, 53-10-8, 51-40-02, 51-30-02.SDR SWAA981779Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORRODED FLOORBEAM AT BS 344, LBL 9. REPAIRED PER BOEING NR TIA53014.SDR 98FDEA00520Floorbeam · corrodedWHILE WORKING NR 0173 FOUND FLOORBEAM AT BS 344, RBL 14, WL 208.1 CORRODED. *S/D* REPAIRED FLOORBEAM AT BS 344, RBL 14, WL 208.1 PER FEDEX REPAIR DRAWING SR 27-53-007.SDR USAA980345Floorbeam · corrodedCLT - DURING C-4 CHECK VISUAL INSPECTION, FOUND A .5 INCH BY .5 INCH AREA OF CORROSION (120 INCHES) AT FLOORBEAM STATION 1640 RBL 60 TO LBL 60. INSTALLED NEW 'T' CAP PER TYPICAL REPAIR 53-15-01. (M)SDR SWAA981761Floorbeam · misdrilledDURING SCHEDULED D-CHECK, FOUND MISDRILLED HOLE AT BS 986.5 FLOORBEAM RBL 2 WL 208. REMOVED AND REPLACED PER BOEING SRM.SDR CALA9801453Floorbeam · crackedINSPECTION FOUND A 2 CRACK IN FLOORBEAM AT STA 1289 ADJACENT TO L-3 DOOR THRESHOLD. THE CRACKED AREA WAS TRIMMED OUT. A NEW FLOORBEAM SECTION WITH SPLICE CHANNEL WAS FABRICATED AND INSTALLED IAW SRM 51-21-01 AND 51-31-01.SDR UPS98227430Floorbeam · corrodedINSPECTION TYPE:SI CORROSION (C53-224-01.05-01), ON FLOORBEAM BS 344 LBL 60 RBL 5 WL 208. REMOVED CORROSION FOUND OUT OF LIMITS REPAIRED IAW SRM 53-10-01, 53-10-08, 51-30-02, 51-20-31.SDR UPS98227429Floorbeam · corrodedINSPECTION TYPE:SI CORROSION (C53-224-01.05-01) FLOOR BEAM BS 680 WL 208 LBL 2-15. REMOVED CORROSION FOUND OUT OF LIMITS. REPAIRED PER 51-10-6, 53-10-1, 51-30-02, 53-10-08, 51-10-02, 51-20-15 SRM.SDR SWAA981756Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM UPPER CHORD CRACKED AT FLOORBOARD FASTENER HOLE AT BS 947, LBL 53.5 WL 208. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981753Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORRODED FLOORBEAM AFT FLANGE AT BS 986.5, LBL 9. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981737Floorbeam · corrodedDURING SCHEDULED 1/2 D-CHECK, FOUND CORRODED FLOORBEAM CLIP NUT HOLE FWD FLANGE AT BS 986.5, RBL 28, RBL 36, RBL35, RBL 30, RBL 40 AND RBL 43. REPAIRED PER BOEING SRM.SDR SWAA981726Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND CRACKED UPPER CHORD OF FLOORBEAM AT BS 663 BL 0. REPAIRED PER BOEING SRM.SDR RRXA98404Floorbeam · corrodedDURING A MAINTENANCE VISIT, FOUND FLOORBEAM, UPPER FLANGE WITH CORROSION DAMAGED BEYOND LIMITS IAW DC-8 SRM AT STA 1300. REMOVED DAMAGED SECTION, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR STRAPS IAW FAA APPROVED TIMCO ENGINEERING SKETSDR AALA981520Floorbeam · damagedTUL - FOUND FLOORBEAM UPPER CAP STATION 360 RBL 10 TO RBL 14. REPAIRED PER AARD 53-10-07-07 FIG 2. (M)SDR 99FDEA00398Floorbeam · crackedDURING AC PF CONVERSION AT OAN, CRACK FOUND ON FLOORBEAM Y=1289X=107. REMOVED AND REPLACED CRACKED OUTBD AND INSTALLED STAINLESS STEEL REPAIR PARTS IAW EA NR 8-5323-44064.SDR UPS98227472Floorbeam · corrodedINSPECTION TYPE-SI, CORROSION (C53-224-01.05-01) ON FLOORBEAM BS 312 LBL 3 TO 25 WL 208. REMOVED OUT OF LIMITS CORRODED FLOORBEAM, FABRICATED NEW FLOORBEAM AND REPAIR PARTS IAW SRM 53-10-8, 51-30-2, INSTALLED PARTS IAW SRM 51-30-2.SDR SIMA982233Floorbeam · corrodedSAW - DURING CPCP-4 INSPECTION, FOUND FLOORBEAM 39 CORRODED AROUND THE NUT PLATE ATTACH POINT ON THE RIGHT SIDE. REPAIRED FLOORBEAM. AIRCRAFT RETURNED TO SERVICE. (M)SDR ABXA9800793Floorbeam · corrodedFLOORBEAM 1540 CORRODED FROM LBL 24 TO RBL 38 LOWER FLANGE. REPAIRED FLOORBEAM IAW ABX REA D853-22918 MR.
Back to JASC 5315