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 SWIA200820232Floorbeam · crackedFS 280 RBL9 INBOARD AND OUTBOARD CLIPS CRACKED. C-CHECK, REPLACED CLIPS.SDR SWIA200820229Floorbeam · crackedFS 280 FLOORBEAM LOWER FLANGE IS CRACKED AT RBL12. C-CHECK, REPAIRED PER REO.SDR KCSA081286Floorbeam · dentedAFT PIT FLOORBEAM UPPER CHORD DENTED AT B.S.1800, RBL-12 TO RBL-18 (B)SDR KCSA081284Floorbeam · crackedAFT PIT FLOORBEAM WEB CRACKED AT BS 1560 ABOVE STR-46L. (B)SDR SWIA200820182Floorbeam · crackedC-CHECK, UPPER FLANGE FS280 FLOORBEAM AT RBL12 CRACKED. REPAIRED PER REO.
SDR QXEA200800689Floorbeam · corrodedRFD C4 CHECK LT SECTION OF THE 280 CROSSBEAM IS CORRODED. BLENDED CORROSION FROM LT FS 280 CROSSBEAM. .020 MATERIAL REMOVED, BLEND IS OUT OF LIMITS IAW REO 670-53-11-046. REMOVED LT SECTION OF 280 CROSSBEAM IAW CRJ 700 SRM 51-42-06. CUT NEW CROSSBEAM IAW RSDR SWAA083222Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM UPPER CHORD CORRODED AT BS 1006, LBL 10. REMOVED AND REPLACED CHORD PER SRM.SDR SWAA083221Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM UPPER CHORD CORRODED AT BS 947.5, RBL 48. REMOVED AND REPLACED CHORD PER SRM.SDR DL757080864Floorbeam · corrodedMAIN CABIN STA 1640 LBL FLOOR STRUCTURE "T" CHORD REPAIR EXFOLIATED AT FASTENER HOLE. REPLACED DAMAGED FLOOR STRUCTURE IAW SRM 53-00-51.SDR SWIA200820222Floorbeam · crackedFS 280 FLOORBEAM CRACKED AT LBL9 AND RBL9. C-CHECK, REPAIRED PER REO.SDR KCSA081278Floorbeam · dentedAFT PIT FLOORBEAM UPPER "I" CHORD DENTED AT BS1660 ABOVE STR-49L (B)SDR KCSA081276Floorbeam · crackedAFT PIT FLOORBEAM WEB CRACKED NEAR TOP AT BS 1800, RBL-59. (B)SDR 2008UALA03310Floorbeam · damagedUPPER DECK FLOORBEAM UPPER CHORD AT BS 860 & 880, LBL 7 1.5, TOTAL OF 3 FASTENER HOLES MISDRILLED. PLUGGED FASTENER HOLES REF SRM 51-40-02. AC OK FOR SERVICE.SDR 08FDEA02227Floorbeam · crackedMAIN DECK FLOOR; FRAME 64; RIGHT 46 INCH FROM CENTERLINE; THE FLOORBEAM IS CRACKED.SDR SWIA200820210Floorbeam · crackedFS 280 FLOORBEAM CRACKED. C-CHECK, REPAIRED PER REO.SDR F3LA200800324Floorbeam · corrodedREFERENCE NON ROUTINE C044879. DURING C4 S1 C-CHECK INSPECTION NOTED AFT CARGO COMPARTMENT STANCHION RECEPTABLE AND AREA CORRODED AT FLOOR FRAME 56 AND STRINGER 37 RT. MAINTENANCE REPAIRED IN ACCORDANCE WITH EA A9-53R-30365 AND SRM 51-42-11, SRM 51-75-12, SRSDR F3LA200800323Floorbeam · corrodedREFERENCE NON ROUTIN C044731. DURING C4 S1 C-CHECK INSPECTION NOTED CORROSION ON OUTBOARD NUT CLIP HOLE 2 INCHES FORWARD OF FRAME 66 ON FLOORBEAM Y1732 LT. MAINTENANCE REPAIRED FLOORBEAM Y1732 LT IN ACCORDANCE WITH THE REQUIREMENTS OF EA A9-53R-30354, SRM 51SDR F3LA200800318Floorbeam · corrodedREFERENCE NON ROUTINE C044885. DURING C4 S1 C-CHECK INSPECTION NOTED AFT CARGO COMPARTMENT FLOOR FRAME 59 U-CHANNEL IS CORRODED FROM STRINGER 41 RT TO STRINGER 38 LT. MAINTENANCE REMOVED AND REPLACED U-CHANNEL IN ACCORDANCE WITH THE REQUIREMENTS OF SRM 51-44SDR SWAA083183Floorbeam · corrodedDURING SCHEDULE 22Y CHECK, FOUND FLOORBEAM CORRODED AT BS 986, RBL 44. REPAIRED FLOOR BEAM PER ER.SDR SWAA083184Floorbeam · corrodedDURING SCHEDULED BRDG CHECK, FOUND FLOORBEAM CORRODED AT BS 294.5, LBL 10. REPAIRED FLOORBEAM PER SRM.SDR SIMA200816504Floorbeam · corrodedDURING A MBV INSP, THE GALLEY FLOOR CENTER BEAM AT FR 20 WAS FOUND CORRODED WITH LEVEL TWO CORROSION. PERFORMED CUT OUT OF THE CENTER BEAM TO REMOVE THE DAMAGE. FAB A DOUBLER, DRILLED, APPLIED PREVENTIVE AND INSTALLED. WORK DONE IAW EMB 145 SRM (SRM EMB-145SDR F3LA200800300Floorbeam · corrodedDURING C-CHECK INSP, NOTED CORROSION ON FLOOR TRACK AT Y189 FRAME 20. MAINT REMOVED DAMAGED FLOORBEAM Y189 AND INSTALLED NEW FLOORBEAM FROM FRAME 20 TO FRAME 24 IAW SRM 51-42-11 PARAGRAPH 7. UPON COMPLETION OF THE REPAIR IT WAS INSPECTED AND FOUND ACCEPTABLESDR 2008UALA03271Floorbeam · damagedFLOORBEAM 175 NEEDS REPLACEMENT FROM FR68 TO FR70.SDR 08FDEA02206Floorbeam · crackedTHE BULK CARGO COMPARTMENT CEILING AREA MAIN DECK FLOOR SUPPORT ANGLE IS CRACKED AT THE FWD FACE OF FRAME 69 AND LBL 60.SDR COMA0860271Floorbeam · crackedFS 280 FLOORBEAM (GALLEY SIDE) CRACKED. REPAIRED FS 280 FLOORBEAM IAW REO 601R-53-11-136. (S)SDR F3LA200800312Floorbeam · corrodedDURING C-CHECK INSP, NOTED CABIN FLOORBEAM Y1292 AT FRAME 66 HAS CORROSION AROUND FASTENER. MAINT REMOVED CORROSION ON LONGERON BEAM Y1291 AT FRAME 66 AND FOUND TO BE OUT OF LIMITS. MAINT REMOVED AND REPLACED FLOORBEAM Y1292 AT FRAME 66 IAW SRM 53-00-14. UPONSDR F3LA200800294Floorbeam · corrodedDURING C-CHECK INSP NOTED THE CENTER LONGITUDINAL FLOORBEAM FROM FRAME 58 TO FRAME 59 HAS CORROSION AROUND THE FWD NUTPLATE HOLE. MAINT REPAIRED THE FLOORBEAM IAW EA A9-53R-30355 AND SRM 51-75-00, SRM 53-00-14 AND SRM 51-42-11. UPON COMPLETION OF THE REPAIR ITSDR A6WA200840499Floorbeam · crackedCROSSBEAM AT PILOTS BULKHEAD CRACKED. CROSS BEAM REPAIRED IAW REO 601R-53-11-171 REV D SCHEME B. (A)SDR 2008UALA03274Floorbeam · corrodedFLOORBEAM 150 REMOVED FROM FR65 TO FR70, FOR CORROSION.SDR 2008UALA03273Floorbeam · corrodedFLOORBEAMS 145 AND 140 REMOVED FROM FR 64 TO 69 FOR CORROSION.SDR F3LA200800309Floorbeam · corrodedREFERENCE NON ROUTINE 34329. DURING C3 S1 C-CHECK INSPECTION NOTED THE CABIN FLOOR LONGERON BEAM Y765 HAD CORROSION AROUND FASTNER HOLE AT FRAME 68 AND BARE METAL FROM FRAME 66 TO FRAME 68. MAINTENANCE REMOVED AND REPLACED RT HAND CABIN FLOOR LONGERON BEAM YSDR A6WA200840498Floorbeam · crackedCROSSBEAM AT PILOTS BULKHEAD CRACKED. REPAIRED IAW REO 601R-53-11-171 REV D SCHEME B. (A)SDR 08FDEA02171Floorbeam · corrodedFOUND CORROSION ON CROSS BEAM PROFILE C 67RHS. REPAIR PERFORMED BY REPLACEMENT OF PART IAW SRM 51-72-10.SDR SIMA200816501Floorbeam · corrodedDURING A HMBV INSPECTION, THE L ANGLE ON FRAME 225 AT THE GALLEY FLOOR AREA WAS FOUND TO HAVE LEVEL TWO CORROSION. FABRICATED A FILLER, SHIM AND REPAIR ANGLE. TREATED ALL PARTS AND INSTALLED IN AIRCRAFT. REPAIR DONW IAW SAAB 340 SRM (SRM 72LKS 3079 REV 50) SDR USAA920081263Floorbeam · corrodedCLT - C-22 - MAJOR REPAIR - FLOORBEAM CORRODED AT BS 787, RBL 24. REPAIRED FLOORBEAM AT BS 787, RBL 24 IAW B737 SRM 53-60-53 & SRM 51-10-02. (S)SDR AALA200801832Floorbeam · corrodedAFW - FLOORBEAM UPPER CAP AT STATION 325 HAD CORROSION. REMOVED FROM THE HORIZONTAL FLANGES FROM RT BUTTLINE 11 TO RT BUTTLINE 50. REPAIRED PER MRB 767-3220. (S)SDR F3LA200800293Floorbeam · corrodedDURING C-CHECK INSP NOTED CORROSION ON BEAM Y1292 LT UPPER OB SIDE NUTCLIP HOLE AT FRAME 68. MAINT REMOVED CORRODED FLOORBEAM Y1292 AND INSTALLED NEW FLOORBEAM FROM FRAME 68 TO FRAME 69 IAW SRM 51-42-00 AND DRAWINGS D53472780, D53472816 AND E53473250. UPON COMSDR USAA920081213Strap · crackedBFM - C-2 - MAJOR REPAIR - NR 6051543 - FLOORBEAM STRAP CRACKED AT BS 1300 RBL 25. REPAIRED FLOORBEAM STRAP AT BS 1300 RBL25 IAW SRM 51-70-11. (K)SDR SWIA200819931Floorbeam · crackedFS 280 FLOOR SUPPORT IS CRACKED ALONG THE OB SIDE OF RBL 9. (FOUND AT C-CHECK) COMPLIED WITH REPAIRS AT FS 280 AND RBL 9 IAW MFG REO 601R-53-11-171, REV. "D".
SDR TRAX200800732Floorbeam · corrodedLT SIDE OF BS 280 FLOORBEAM CORRODED BEYOND LIMITS. PICKED FASTENER HOLES EXISTING IN LT 280 BEAM CC670-341-75-7 IAW CRJ SRM 51-40-06. (B)SDR TRAX200800731Floorbeam · corrodedRT BS 280 FLOORBEAM CORRODED OUT OF LIMITS. PICKED UP EXISTING FASTENER HOLES RT 280 BEAM CC 670-341-75-7 IAW SRM 51-40-06. (B)SDR 08FDEA02117Floorbeam · corrodedFOUND CORROSION SPOTS ON CROSS BEAM C 72, C 46-46`. REPAIR PERFORMED BY REPLACEMENT OF PART IAW SRM 51-72-10.SDR 08FDEA02115Floorbeam · corrodedFOUND CORROSION ON UPPER FLANGE C 27 RT BETWEEN OUTER STRUT AND CORNER FITTING. SPLICE REPAIR PERFORMED IAW SRM 53-10-15 FIG 207.SDR CALA0800537Floorbeam · corrodedSTATION 986.5 FLOORBEAM HAS CORROSION ON UPPER CHORD RBL 23 FWD FLANGE AT PREVIOUS REPAIR. REMOVED AND REPLACED REPAIR FILLER PER SRM 53-00-51 REPAIR 1.SDR CALA0800536Floorbeam · corrodedSTATION 986.5 FLOORBEAM UPPER CHORD AFT FLANGE HAS CORROSION LBL 26. REPAIRED PER EC/RA 5321-01330 REVISION A.SDR CALA0800535Floorbeam · corrodedSTATION 986.5 FLOORBEAM UPPER CHORD FORWARD FLANGE LBL 26 CORROSION ON PREVIOUS REPAIR. REMOVED AND REPLACED REPAIR FILLER PER SRM 53-00-51 REPAIR 1.SDR CALA0800534Floorbeam · corrodedSTATION 986.5 FLOORBEAM UPPER CHORD HAS CORROSION AT LBL 38. REPAIRED PER EC/RA 5321-01330.SDR CALA0800533Floorbeam · corrodedSTATION 986.5 FLOORBEAM UPPER CHORD HAS CORROSION AT LBL 44. REPAIRED PER EC/RA 5321-01330 REVISION A.SDR F3LA200800288Floorbeam · corrodedDURING C-CHECK INSP, NOTED FLOORBEAM 1292 RT AT FRAME 68 CORROSION IN OB NUTCLIP HOLE. MAINT INSTALLED NEW FLOORBEAM Y1292 FROM FRAME 68 TO FRAME 69 IAW THE REQUIREMENTS OF SRM 51-42-11. UPON COMPLETION OF THE REPAIR IT WAS INSPECTED AND FOUND ACCEPTABLE. (A)SDR F3LA200800283Floorbeam · corrodedDURING C-CHECK INSP, NOTED FLOORBEAM Y765 RT HAS PITTING CORROSION AT FRAME 68 ON TOP SURFACE. MAINT REMOVED BEAM AND INSTALLED NEW BEAM IAW DRAWING D53472815 AND SRM 51-42-11. UPON COMPLETION OF THE REPAIR IT WAS INSPECTED AND FOUND ACCEPTABLE. (A)
Back to JASC 5315