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 SWAA981328Floorbeam · crackedDURING SCHEDULED C2 CHECK, FOUND CRACKED LT FLOORBEAM ROW 10. REPAIRED PER BOEING SRM.SDR SWAA981314Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED CARGO FLOORBEAM AT BS 727 TO 947, LBL 8 WL 159, RBL 3, WL 159 AND RBL 8, WL 159. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981313Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED CARGO FLOORBEAM AT BS 727 TO 947, LBL 12.5, WL 159. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981306Floorbeam · corrodedDURING SCHEDULED 1/2 D-CHECK, FOUND CORRODED FLOORBEAM AT BS 986 LBL 10.5. REPAIRED PER BOEING SRM.SDR SWAA981298Floorbeam · corrodedDURING SCHEDULED 1/2 D-CHECK, FOUND CORRODED FLOORBEAM AT BS 344 PANEL HOLE, LBL 28. REPAIRED PER BOEING SRM.SDR SWAA981297Floorbeam · damagedDURING SCHEDULED TRAN CHECK, FOUND FLOORBEAM AT BS 1006, LBL 16 AND 29 WITH ELONGATED HOLES. REPAIRED PER BOEING SRM.SDR RAAA98B2032Floorbeam · misdrilledDURING SCHEDULED S5 INSPECTION PER CARD S6 54104, FOUND BS 1166 FLOORBEAM WITH 2 DRILL HOLES IN UPPER CHORD. REPAIRED PER BAC MSG RVV-SEA-98-0010RR AND SRM 53-10-8, FIG 3 M-54 NR 261.SDR C2XA98IA249Floorbeam · corrodedIAH - DURING C-CHECK INSPECTION, FOUND FLOOR STRUCTURE AT FIRST OFFICER'S SIDE SEAT ATTACHMENT AREA CORRODED. MAINTENANCE REMOVED AND REPLACED THE FLOOR STRUCTURE IAW ATR-42 SRM 51-25-02 AND SRM 53-17-70. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. TT:SDR C2XA98IA248Floorbeam · corrodedIAH - DURING C-CHECK INSPECTION, FOUND FLOOR STRUCTURE AT CAPTAIN'S SIDE SEAT ATTACHMENT AREA CORRODED. MAINTENANCE REMOVED AND REPLACED THE FLOOR STRUCTURE IAW ATR-42 SRM 51-25-02 AND SRM 53-17-70. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. TAT: 17,6SDR UPS98227290Floorbeam · corrodedINSPECTION TYPE-SI, CORROSION (C53-224-01.05-02) ON FLANGES OF LONGITUDINAL FLOORBEAM AND NUT PLATES BS 760 TO 848, WL 208 RBL 45. REPLACED LONGITUDINAL FLOORBEAM AND SEAT TRACK (NRC 832504) BS 760 TO 848 PER SRM 51-30-2.SDR SWAA981285Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED CARGO FLOORBEAM AT BS 727 TO 947, LBL 3 WL 159. REMOVED AND REPLACED PER BOEING SRM.SDR UPS98227135Floorbeam · corrodedINSPECTION TYPE:SI CORROSION (C53-224-01.05-02) ON FLANGES OF LONGITUDINAL FLOORBEAM AND NUT PLATES BS 760-848 LBL 25 WL 208. REPLACED LONG FLOORBEAM BS 760 TO 840 LBL 25 WL 208 AND EXPANSION LINK FROM 850 TO BS 870 PER 727 SRM 53-10-1 AND 51-30-2 EXPANSION LSDR ABXA9800609Floorbeam · corrodedDURING C-CHECK, FOUND UPPER CARGO COMPARTMENT FLOORBEAM AT STATION 937 LOWER TEE CAP CORRODED BEYOND LIMITS BETWEEN BL 0 AND LBL 40 TO 54. REPAIRED FLOORBEAM IAW ABX REA D953-24050 MR.SDR AALA981321Floorbeam · corrodedTUL - FOUND CORROSION ON TOP FLANGE OF FLOORBEAM STATION 360 LBL 10 INCHES AT NUTCLIP HOLE. REMOVED DAMAGED SECTION AND REPAIRED PER SRM 53-10-8. (M)SDR CALA9801314Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 303 TO 344, LBL 28. THE CORROSION WAS REMOVED IAW SRM 51-10-8. ANGLES WERE FABRICATED AND INSTALLED IAW SRM 51-40-8.SDR CALA9801313Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 380 BETWEEN RBL 32 AND RBL 42. THE CORRODED AREA OF FLOORBEAM WAS CUT OUT IAW SRM 53-10-8. A REPAIR WAS FABRICATED AND INSTALLED IAW SRM 53-10-8, 51-10-2, AND 51-40-4.SDR CALA9801306Floorbeam · corrodedINSPECTION FOUND FORWARD LAV FLOORBEAM AT STA 344, RBL 24 CORRODED. THE CORRODED AREA OF FLOORBEAM WAS REMOVED, A NEW FLOORBEAM SECTION WAS FABRICATED AND INSTALLED IAW SRM 51-10-1, 51-10-2, AND 51-30-2.SDR CALA9801304Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORROSION AT STA 328, LBL 30 AND 45, STA 344, STA 380, RBL 32 TO 42. THE CORRODED AREAS OF FLOORBEAM WERE CUT OUT. REPAIRS WERE FABRICATED AND INSTALLED IAW SRM 53-10-8, 51-10-2, AND 51-40-4.SDR EIAA980223Floorbeam · crackedSIN - DURING B-CHECK, BS 380 UPPER DECK FLOORBEAM WAS FOUND CRACKED AT THE UPPER CHORD, RT OUTBOARD END. ACCOMPLISHED TIME LIMITED REPAIR, PERMANENT REPAIR TO BE ACCOMPLISHED PRIOR TO 18 MONTHS OR 1500 CYCLES, WHICHEVER COMES FIRST PER TELEX SCO-QUG-98-0016RESDR EIAA980220Floorbeam · crackedHKG - DURING B-CHECK, BS 440 UPPER DECK FLOORBEAM WAS FOUND CRACKED AT THE UPPER CHORD, RT OUTBOARD END RUNNING INBOARD .040 INCH. ACCOMPLISHED TIME LIMITED REPAIR, PERMENANT REPAIR TO BE ACCOMPLISHED PRIOR TO 18 MONTHS OR 1500 CYCLES, WHICHEVER COMES FIRST PSDR EIAA980219Floorbeam · crackedHKG - DURING B-CHECK, BS 440 UPPER DECK FLOORBEAM WAS FOUND CRACKED AT THE UPPER CHORD, LEFT OUTBOARD END RUNNING INBOARD .040 INCH. ACCOMPLISHED TIME LIMITED REPAIR, PERMANENT REPAIR TO BE ACCOMPLISHED PRIOR TO 18 MONTHS OR 1500 CYCLES, WHICHEVER COMES FIRSTSDR DL72W981371Floor Beam · corrodedSEVERAL SMALL AREAS OF CORROSION AND BARE METAL AT FLOORBEAM STA 344 AND RBL12 TO LBL 60. REPAIRED PER SRM 53-10-8 FIG 11.SDR CALA9801194Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 380, RBL 18. THE CORRODED AREA WAS CUT OUT IAW SRM 53-10-8. A REPAIR WAS FABRICATED AND INSTALLED IAW SRM 53-10-8, 51-10-2, AND 51-40-4.SDR USAA980288Floorbeam · corrodedCLT - DURING C-2 CHECK VISUAL INSPECTION, FOUND A 1 INCH BY 1 INCH AREA OF CORROSION ON FLOORBEAM BS 365 LBL 30 RBL 62. FABRICATED NEW 'T' CAP, DOUBLERS AND ANGLES PER TR 53-15-01. (M)SDR USAA980286Floorbeam · corrodedCLT - DURIGN C-2 CHECK VISUAL INSPECTION, FOUND A 1 INCH BY 1 INCH AREA OF CORROSION ON FLOORBEAM AT BS 377 LBL 61 RBL 12. FABRICATED NEW 'T' CAP, DOUBLERS AND ANGLES PER TR 53-15-01. (M)SDR CKSA98383Floorbeam · crackedDURING ROUTINE CPCP INSPECTION, FOUND FS 440 RBL 50 UPPER DECK FLOORBEAM WEB CRACKED. REMOVED DAMAGED WEB IAW B747 SRM 51-30-02. FABRICATED REPAIR DOUBLERS IAW SRM 53-10-07 FIG 11. INSTALLED REPAIR IAW SRM 53-10-07 FIG 11. CORROSION TASK CARD NUMBER C53-21SDR CKSA98375Floorbeam · corrodedDURING ROUTINE CPCP INSPECTION, FOUND FS2240 RBL75 FLOORBEAM T CHORD HAS CORROSION. REMOVED CORROSION IAW B747 SRM 51-10-01. FOUND TO BE OUT OF LIMITS IAW B747 SRM 53-10-01. FABRICATED REPAIR DOUBLERS IAW B747 SRM 51-40-4 FIG 12 AND AIA EDR B4-05887. INSTASDR CKSA98373Floorbeam · corrodedDURING ROUTINE CPCP INSPECTION, FOUND LEVEL 2 CORROSION, FS440 RBL50 UPPER DECK FLOORBEAM HAS CORROSION ON FWD SIDE. REMOVED CORROSION IAW B747 SRM 51-10-01. FOUND TO BE OUT OF LIMITS IAW B747 SRM 53-10-01. MANF REPAIR PARTS IAW EDR B4-05871. INSTALLED REPSDR CKSA98372Floorbeam · corrodedDURING ROUTINE CPCP INSPECTION, FOUND LEVEL 2 CORROSION, STA1940-1960 LBL11.33 LONGITUDINAL FLOORBEAM UPPER CHORD CORRODED. REMOVED CORROSION IAW B747 SRM 51-10-01. FOUND OUT OF LIMITS IAW B747 SRM 53-10-01. FABRICATED REPAIR DOUBLERS IAW B747 SRM 53-10-05 SDR CKSA98368Floorbeam · corrodedDURING ROUTINE CPCP INSPECTION FOUND LEVEL 2 CORROSION, CORROSION AROUND CLIP NUT ON UPPER CHORD OF BS680 FLOORBEAM LBL3. CUTOUT DAMAGE AREA IAW SRM 51-40-04 FIG 1. MADE REPAIR ANGLES AND DRILLED IAW SRM 51-40-04 FIG 1. INSTALLED REPAIR IAW B747 SRM 51-40-4SDR CKSA98367Floorbeam · corrodedDURING ROUTINE CPCP INSPECTION FOUND LEVEL 2 CORROSION STA760 FWD LBL44 FLOORBEAM HAS CORROSION. CORROSION FOUND TO BE OUT OF LIMITS IAW B747 SRM 53-10-1. CUTOUT CORROSION AND FABRICATED REPAIR IAW B747 SRM 51-40-4 FIG 1. INSTALLED REPAIR IAW B747 SRM 51-40SDR CKSA98366Floorbeam · corrodedDURING ROUTINE CPCP INSPECTION, FOUND LEVEL 2 CORROSION STA760 FWD LBL72 FLOORBEAM HAS CORROSION. CORROSION FOUND TO BE OUT OF LIMITS IAW B747 SRM 53-10-1. CUTOUT CORRODED SECTION OF UPPER CHORD AND FABRICATED REPAIR IAW SRM 51-40-4 FIG 1. ALSO AIA EDR NR BSDR CKSA98362Floorbeam · corrodedDURING ROUTINE CPCP INSPECTION, FOUND LEVEL 2 CORROSION 2 AREA OF CORROSION ON BS480 FLOOR BEAM FWD, UPPER, SIDE AT RBL-76. REMOVED CORROSION IAW B747 SRM 51-10-01. FOUND TO BE OUT OF LIMITS IAW B747 SRM 53-10-01. FABRICATED REPAIR DOUBLERS IAW B747 SRM 51-SDR C2XA98IA218Floorbeam · corrodedIAH - DURING C-CHECK INSPECTION, FOUND AFT CARGO COMPARTMENT FLOOR AT CARGO DOOR THRESHOLD CORRODED. MAINTENANCE REMOVED AND REPLACED THE DAMAGED SECTION IAW EMB-120 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. (M)SDR EISA98154Floorbeam · corrodedDURING ACCOMPLISHMENT OF ROUTINE C-CHECK WORK CARD, FOUND CORROSION AROUND .25 INCH DIAMETER HOLE IN FLOOR STRUCTURE AT STR 29R FS 560, FWD CARGO PIT. REMOVED CORROSION, FABRICATED AND INSTALLED REPAIR PER SRM 53-10-2 AND SRM 53-10-1. TT: 72,562:53 HOURS. SDR EIAA980213Floorbeam · corrodedMZJ - DURING C-CHECK, MAIN DECK FLOORBEAM AT BS 229 HAS CORROSION AT RBL 23. REPAIRED FLOORBEAM PER SRM 53-40-00 FIG 6L. (M)SDR CALA9801180Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 328, LBL 2. REPAIRED IAW SRM 53-10-51, FIGURE 205.SDR CALA9801178Floorbeam · corrodedINSPECTION FOUND CORROSION AROUND FASTENER HOLES OF FLOORBEAM AT STA 967, RBL 40 TO 50. THE FLOORBEAM WAS REPAIRED IAW SRM 53-00-51, FIGURE 202.SDR CALA9801170Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CAP CORRODED AT STA 986 FROM RBL 0 TO RBL 46. THE FLOORBEAM WAS REPAIRED IAW ECRA 5310-03450.SDR ABXA9800572Floorbeam · corrodedDURING C-CHECK, FOUND THE LOWER TEE CAP OF THE FLOORBEAM THAT ATTACHES TO THE TOP OF THE AFT BULKHEAD OF THE LEFT WHEEL WELL EXFOLIATED. REPAIRED IAW ABX REA D953-23942-MR.SDR CALA9801167Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT FORWARD ENTRY, STA 312, RBL 21. THE FLOORBEAM WAS REPAIRED IAW SRM 53-10-51.SDR SWAA981211Floorbeam · out of limitsDURING SCHEDULED 1/2 D-CHECK, FOUND 4 FASTENER HOLES ALONG THE FLOORBEAM AT BS 1016 OUT OF LIMITS. REPAIRED PER BOEING TI-A53-014.SDR SWAA981210Floorbeam · crackedDURING SCHEDULED 1/2 D-CHECK, FOUND CRACKED BS 947.5 FLOORBEAM UPPER CHORD FROM SCREW HOLE AT LBL 54. REPAIRED PER SWA RA NR 1-353-1834.SDR SWAA981209Floorbeam · corrodedDURING SCHEDULED 1/2 D-CHECK, FOUND CORRODED FLOORBEAM AT BS 1016, FLOOR PANEL HOLE LBL 6, BS 1016 FLOOR PANEL HOLE LBL 10, BS 1016 FLOOR PANEL HOLE LBL 15 AND BS 1016 FLOOR PANEL HOLE LBL 16. REMOVED AND REPLACED PER BOEING SRM.SDR F3LA98105Floorbeam · corrodedPAE - DURING C-CHECK INSPECTION, REPORTED CORROSION ON FLOORBEAM. UNDER SIDE OF UPPER FRAME AT BS 986.5, LBL 45, WL 208. MAINTENANCE REMOVED CORROSION, FABRICATED REPLACEMENT PARTS AND REPAIRED PER SRM 53-00-51, PAGES 212 AND 213 AND SRM 53-60-51. (M)SDR F3LA98104Floorbeam · corrodedPAE - DURING C-CHECK INSPECTION, REPORTED CORROSION ON FLOORBEAM AT BS 328, RBL 15-42. MAINTENANCE REMOVED CORROSION AT RBL 15 (1.8 INCH BY 1.2 INCH BY .012 INCH), RBL 22 (1.3 INCH BY 1 INCH BY .013 INCH), RBL 29 (1.4 INCH BY 1 INCH BY .015 INCH) RBL 36 (1.5 SDR F3LA98101Floorbeam · corrodedPAE - DURING C-CHECK INSPECTION, REPORTED CORROSION ON UPPER SURFACE OF FLOORBEAM AT BS 1006, RBL 10, WL 208. MAINTENANCE REMOVED CORROSION (1.4 INCH BY 1.1 INCH BY .062 INCH). FABRICATED REPLACEMENT PARTS AND REPAIRED PER ERO 98-0567, SRM 51-40-2 AND SRM 53SDR F3LA98095Floorbeam · corrodedPAE - DURING C-CHECK INSPECTION, REPORTED CORROSION AROUND NUT HOLE PLATES AT BS 344 FLOORBEAM UPPER CHORD, LBL 10 TO RBL 2, WL 208. MAINTENANCE REMOVED CORROSION AROUND NUT PLATE HOLES AT BS 344 FLOORBEAM UPPER CHORD, RBL 2 (2 INCH BY 1 INCH BY .030 INCH), LSDR F3LA98094Floorbeam · corrodedPAE - DURING C-CHECK INSPECTION, REPORTED CORROSION ON FLOORBEAM AT BS 294.5 RBL 10 TO LBL 10, WL 208. MAINTENANCE REMOVED CORROSION, FABRICATED REPLACEMENT PARS AND REPAIRED PER SRM 51-40-2, 53-10-8 AND 53-10-51. (M)SDR F3LA98093Floorbeam · corrodedPAE - DURING C-CHECK INSPECTION, REPORTED 1.5 INCH BY 1 INCH BY .070 INCH AREA OF CORROSION ON FLOORBEAM AT BS 312, RBL 34. MAINTENANCE REMOVED CORRODED AREA, FABRICATED REPLACEMENT PARTS AND INSTALLED PER SRM 51-40-2, 53-10-51 AND 53-10-57. (M)
Back to JASC 5315