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 USAA070646Floorbeam · corrodedAROUND FASTENER HOLES & TOPSIDE OF FLOORBEAM, FR 66-69 HAS CORROSION. INSTALLED NEW FLOORBEAM PER SRM 51-72-11; CORR TASK JA-260-53500, DEFECT SIZE: 1.5 X 1.5 INCH.SDR USAA070647Floorbeam · corrodedAROUND FASTENER HOLES & TOPSIDE OF FLOORBEAM, FR 66-69 HAS CORROSION. INSTALLED NEW FLOORBEAM PER SR 51-72-11; CORR TASK JA-260-53500, DEFECT SIZE: 1.5 X 1.5 INCH.SDR USAA070648Floorbeam · corrodedAROUND FASTENER HOLES & TOPSIDE OF FLOORBEAM, FR 66-69 HAS CORROSION. INSTALLED NEW FLOORBEAM PER SRM 51-72-11; CORR TASK JA-260-53500, DEFECT SIZE: 1.5 X 1.5 INCH.SDR SWAA073992Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM UPPER CHORD CORRODED AT BS 986, RBL 5. REPAIRED FLOORBEAM CHORD PER ER.SDR SWAA073993Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM UPPER CHORD CORRODED AT BS 294.5, RBL 11 TO RBL 12. REPAIRED FLOORBEAM CHORD PER ER.SDR SWAA073958Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM CHORD CRACKED AT BS 664, BL 0. REMOVED AND REPLACED FLOORBEAM CHORD PER SRM.SDR SWAA073974Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED AT BS 987, BETWEEN RBL 29 AND LBL 41. REPAIRED FLOORBEAM PER SRM.SDR SROM200700013Floorbeam · corrodedNR291 - CORROSION ON FLOORBEAM UPPER FLANGE STA 344 LBL 48-60. REPAIRED IN ACCORDANCE WITH BOEING SRM 53-10-9, FIGURE 1.SDR DU4R2007164Floorbeam · corrodedFOUND CORROSION AROUND FASTENER HOLE AT FLOORBEAM BS 1661 LBL 10. REPAIRED BY CUTTING OUT CORRODED AREA. FABRICATED AND INSTALLED REPAIR CHORD 16 LONG FROM BAC1505-100617, 2 EA. REPAIR ANGLES 24 LONG FROM BAC1490-2734 AND BAC1490-2865 AND TWO 24 REPAIR STRAPSDR USAA070623Floorbeam · corrodedNUT PLATE HOLE, RBL 12, STA 987 CORRODED. REMOVED & REPAIRED T-CAP AREA PER SRM 53-00-01; CORR TASK C53-107-01, DEFECT SIZE: 2 X INCHES.SDR SWIA200718748Floorbeam · crackedFOUND AT C-CHECK, FLOOR SUPPORT ON FORWARD SIDE OF FS 280 BEAM IS CRACKED. REPLACED FLOOR SUPPORT AT FS 280 PER CRJ700/900 SRM 51-42-06 PAGE 7.
SDR SROM200700007Floorbeam · crackedNR228-CRACK IN FLOORBEAM AND WEB STA 660 BL0. CRACKED FLOORBEAM AND WEB AT STA 660 BL0 REPAIRED IAW MFG SB 737-57-1210, REV 1, DATED AUG 27/07.SDR CALA0700452Floorbeam · crackedINSPECTION FOUND CRACKS TO THE LONGITUDINAL FLOORBEAM FLANGES AT STA 727B, LBL 45.5, RBL 45.5 AND RBL 24.8. REPAIRS WERE PERFORMED IAW ECRA 5321-01492.SDR 2007UALA03066Floorbeam · corrodedFLOORBEAM CORRODED: CABIN BS 294.5, LBL 6-7 WATERLINE 208, UPPER FLANGE CAP. REMOVED CORROSION. FABRICATED AND INSTALLED REPAIR ANGLE AND SHIM.SDR SIMA200722716Floorbeam · corrodedFOUND STATION 280 FLOORBEAM CORRODED ALONG TOP FLANGE. SPLICED IN FRAME 280, SUPPORT AND EXTENTION MOUNTS IAW AMERICAN EAGLE ENGINEERING ORDER CR-53MR-119. RETURNED AIRCRAFT TO SERVICE.SDR A6WA200740439Floorbeam · crackedFOUND RIGHT 621 FLOOR SUPPORT ANGLE IS CRACKED. (M)SDR A6WA200740438Floorbeam · crackedFOUND LEFT 621 FLOOR SUPPORT ANGLE IS CRACKED. (M)SDR TRAX200701119Floorbeam · crackedRIGHT FS 280 CROSSBEAM CRACKED ON UPPER FLANGE O/B OF RBL 9.0. REMOVED RIGHT FS 280 DAMAGED BEAM. LOCATED NEW RIGHT, FS 280 FLOORBEAM, P/N CC670-34175-7, IAW CRJ 700 SRM 51-40-11. OK TO INSTALL. INSTALLED RIGHT FS 280 BEAM, IAW CRJ SRM 51-42-06 AND 51-42-2SDR TRAX200701118Floorbeam · crackedLEFT FS 280 CROSSBEAM CRACKED ON UPPER FLANGE O/B OF LBL 9.0. REMOVED LEFT FS 280 DAMAGED BEAM. LOCATED NEW LEFT FS 280 FLOORBEAM, P/N CC670-304175-7, IAW CRJ SRM 51-42-21. OK TO INSTALL. INSTALLED LEFT FS 280 BEAM, IAW CRJ SRM 51-42-06 AND 51-42-21. OK TSDR DL76S071030Floorbeam · crackedFLOORBEAM BS 347 HAD CRACKS IN UPPER CHORD BETWEEN LBL 10 AND RBL 20. DUE TO A WEB REPAIR NEAR RBL 29.5. A SPLICE REPAIR WAS DONE BETWEEN LBL 27 AND RBL 30.5.SDR DU4R2007163Floorbeam · corrodedFOUND CORROSION ON CABIN FLOORBEAM AT BS 1640, LBL 24 TO RBL 4. CUT OUT 30 INCH CORRODED SECTION OF T-CAP. FABRICATED AND INSTALLED T-CAP REPAIR 36-3/4" FROM BAC1505-100617, 2 EA. SPLICE PLATES 9" BY 1-1/2" BY 1" AND 2 EA. 6-1/2" BY 1-1/2"FROM 7075-T6 .050",SDR A6WA200740441Floorbeam · crackedFOUND RIGHT FS 621 FLOOR SUPPORT ANGLE CRACKED. (M) MAINTENANCE REPAIRED IAW REO 601R-53-61-117. (M)SDR A6WA200740440Floorbeam · crackedFOUND LEFT FS 621 FLOOR SUPPORT ANGLE CRACKED. (M) MAINTENANCE REPAIRED IAW REO 601R-53-61-117. (M)SDR SWIA200718724Floorbeam · corrodedFOUND AT C-CHECK, CORROSION AT PAX DOOR AREA ON FLOORBEAM. REMOVED AND REPLACED OMEGA BEAM AND BUTTSTRAP IAW SRM 51-10-02.
SDR 2007UALA02955Floorbeam · corrodedCABIN FLOORBEAM Y-254 (RBL 10) UPPER FLANGE HAS EXFOLIATION CORROSION FROM FRAME C19 TO FRAME C20 AND UNDER THE GALLEY FLOORBOARD. REPLACED FLOORBEAM.SDR 2007UALA02954Floorbeam · corrodedCABIN FLOORBEAM Y-765 (RBL 30) UPPER FLANGE HAS EXFOLIATION CORROSION - 1 TO 2 INCHES FWD OF FRAME C20. REPLACED FLOORBEAM.SDR SWAA073897Floorbeam · crackedDURING SCHEDULED BRDG CHECK, FOUND FLOORBEAM CRACKED BETWEEN BS 664 AND BS 660, RBL 1. REPAIRED FLOORBEAM PER SWA EA.SDR 07FDEA02716Floorbeam · corrodedCABIN STA 950 FLOORBEAM BET RBL 45 AND 62 HAS CORROSION ON UPPER AND LWR, AND AROUND FASTENER HOLES REMOVED CORROSION. HFEC NO DEFECT NOTED, ROTO PEENED REF SOPM 20-10-3. TREATED AND PRIMED REF SRM 51-10-2, LEVEL 1 CORROSION.SDR SWIA200718682Floorbeam · crackedFS 280 FLOORBEAM IS CRACKED AT RBL AND LBL9.0, FOUND AT C-CHECK. REPLACED FS 280 BEAM AND INTERCOSTAL PER CRJ7/9 SRM 51-42-06, REO 670-53-11-247 AND SRM 51-42-21.SDR LR7A07067Floorbeam · brokenDURING SCHEDULED B-1 CHECK PER HB5301, FOUND FLOORBEAM LOWER CAP BROKEN, FS 797E, LBL20-RBL20, WL132. LOWER CAP REPLACED IAW SMP583 CHAPTER 51-60 AND 51-70.SDR 2007UALA02933Floorbeam · corrodedCABIN FLOORBEAM Y-1292 (RBL 51) UPPER FLANGE HAS EXFOLIATION CORROSION FROM FRAME C17 TO FRAME C20. MAJOR REPAIR ACCOMPLISHED: REMOVED & REPLACED CABIN FLOORBEAM.SDR DLM88071000Floorbeam · crackedCRACKED FRAME AT FLOORBEAM JOINT STA Y=864 X=56. REPAIRED PER DWG SR 09530282 ON N/R T0062703 AT HMV-3.SDR DLM88070999Floorbeam · crackedFOUND CRACKED FLOOR SUPPORT AT STATION Y=905, X =42. REPAIRED PER DWG 9923417 ON N/R T0062835 AT HMV-3.SDR SWAA073791Floorbeam · crackedDURING SCHEDULED BRDG CHECK, FOUND FLOORBEAM CRACKED AT BS 660, RBL 24. REPAIRED FLOORBEAM PER SWA EA.SDR 07FDEA02688Floorbeam · corrodedT-CAP CORRODED FR35 AT RBL 56 TO 62 FWD PIT REMOVED AND REPLACED T-CAP PER A310-200 SRM 51-40-21 PARAGRAGH 7 AND 53-10-15, PAGE 241 AND 242.SDR 07FDEA02687Floorbeam · corrodedT-CAP CORRODED FR35 AT RBL 56 TO 62 FWD PIT REMOVED AND REPLACED T-CAP PER A310-200 SRM 51-40-21 PARAGRAGH 7 AND 53-10-15, PAGE 241 AND 242.SDR CPCP20070088Floorbeam · corrodedFR 39 FLOORBEAM CORRODED. FR 39 FLOORBEAM REPAIRED TRANSFER ON W/C 181274.SDR 07FDEA02669Floorbeam · crackedFWD CARGO COMPT BILGE AREA ON BEAM FOUND CRACK. REPAIRED BEAM IAW SRM 53-60-01 VOL 1 FIG 3 SHEET 1-2.SDR 2007UALA02874Floorbeam · mismanufacturedCABIN FLOORBEAM AT BS 368 AND RBL 58 HAS 2 EACH MISDRILLED HOLES, ONE THROUGH UPPER CHORD AND WEB AND THE OTHER IN THE UPPER CHORD RADIUS. CUTOUT DAMAGE IN WEB AND OVERSIZED THE 2 MISDRILLED HOLES. FABRICATED 1 REPAIR ANGLE FOR THE FWD AND AFT SIDE OF THE FLSDR 07FDEA02653Floorbeam · crackedFLOORBEAM FRAME 31 BETWEEN SEAT TRACKS NR L4 AND NR 5L HAS A .5 INCH CRACK AT STIFFENER. CUT OUT CRACKED SECTION OF FLOORBEAM IAW A300-600 FREIGHTER SRM 53-10-15. FABRICATED AND INSTALLED REPAIR ANGLE AND FILLER IAW A 300-600 FREIGHTER SRM 53-10-15. ALODINESDR SWIA200718840Floorbeam · crackedCARGO FLOOR SUPPORT STRUCTURE IS CRACKED AT FS 559 + 90 AND RBL27 ON INBD SIDE, DISCOVERED AT C-CHECK. COMPLIED WITH REPAIR PER CRJ200 SRM 53-00-43.
SDR SWIA200718837Floorbeam · crackedCRACK FOUND ON SUPPORT ANGLE UNDER FLOOR PANEL 262DRF AT FS480, DISCOVERED AT C-CHECK. INSTALLED NEW SUPPORT AT FS484 AND RBL36 PER CRJ200 SRM 51-23-00, 51-42-06 AND 51-42-21.
SDR KCSA071262Floorbeam · dentedMAIN DECK FLOORBEAM WEB IS DENTED AT STA 460, RBL 103, WL 189 TO 199.SDR SWIA200718698Floorbeam · crackedFS 621 RBL42 FLOOR SUPPORT ANGLE IS CRACKED, DISCOVERED AT C-CHECK. INSTALLED NEW REPAIR ANGLE AND SPLICE AT FS 621 RBL42 FLOOR SUPPORT ANGLE PER REO NO 601R-53-61-117 REV A.SDR SWIA200718686Floorbeam · crackedFS 280 FLOOR SUPPORT BEAM IS CRACKED AT LBL9, FOUND AT C-CHECK. INSTALLED FS 280 FLOOR SUPPORT BEAM AND INTERCOSTALS PER CRJ7/9 SRM 51-42-21, 51-42-06, SRM 51-23-00 AND REO:670-53-11-242 REV B.SDR SWIA200718684Floorbeam · crackedFOUND COCKPIT FLOORBEAM ANGLE IS CRACKED AT RBL9, FOUND AT C-CHECK. INSTALLED COCKPIT FLOOR SUPPORT ANGLE PER CRJ700/900 SRM 51-42-06.SDR UIEA200700299Floorbeam · crackedCRACK INDICATION IN LEFT SIDE OF UPPER DECK FLOORBEAM FUSELAGE 6, 7 AND 8TH HOLES FROM OUTBOARD TOP ROW OF FASTENERS STRAP AREA OF UPPER CHORD REF S/B 747-53A24201 FIG 2 STEP 2. REMOVED CRACKED CHORD SECTION REMOVED CRACKED WEB SECTION FABRICATED AND INSTALLESDR UIEA200700298Floorbeam · crackedCRACK INDICATION IN LEFT SIDE OF UPPER DECK FLOORBEAM FUSELAGE STA 360 5TH AND 8TH HOLES FROM THE OUTBOARD STRAP AREA OF UPPER CORD REF S/B 747-53A24201 FIG 2 STEP 2. INSTALLED FRAME WEB REPAIR REPLACEMENT PARTS IAW SRM 53-10-04 FIG 103 DETAIL 2.SDR UIEA200700297Floorbeam · crackedCRACK INDICATION IN RIGHT SIDE OF UPPER DECK FLOORBEAM FUSELAGE STA 440 3RD AND 4TH HOLES FROM THE OUTBOARD TOP ROW OF FASTENERS STRAP AREA OF UPPER CORD REF S/B 747-53A2449 FIG 2 STEP 2. DISASSEMBLED AREA AT STA 440 DISCOVERED CRACKS IN FRAME WEB AND CRACKEDSDR 07FDEA02636Floorbeam · misrepairedON AGING A/C INSP, FOUND EXISTING REPAIR LOCATED AT BS 620 FLOORBEAM UPPER CHORD FROM LBL 3" TO 19". EVALUATED AND DETERMINED REPAIR NOT TO CONFORM TO FED EX DWG SR27-53-034. REMOVED EXISTING REPAIR, FABRICATED NEW REPAIR ANGLE FROM 17-7 PH .063", HEAT TREAT
Back to JASC 5315