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 DL75E090151Floorbeam · corrodedCORRSION ON MAIN CABIN FLOORBEAM AT STA 377.7 LBL-1 TO LBL-12 UPPER SURFACE AND UNDER FASTENER HOLES.SDR DL75E090148Floorbeam · corrodedCORROSION ON MAIN CABIN BEAM UPPER SURFACE AT SAT 324 RBL 61.SDR QXEA2009021000098Floorbeam · corrodedPDX - C5 - 280 BEAM HAS CORROSION ON FORWARD FACE OF BEAM ON LT AND RT SIDE OF CENTER SPLICE. BLENDED FORWARD FACE OF BEAM FROM LBL 9.00 TO RBL 9.00 IAW REO 670-53-11-046. INSPECTED BLENDED AREA FOR CRACKS IAW CRJ 700 NDTM 51-20-004. HI .040 INCH, LOW .038 ISDR QXEA2009020600090Floorbeam · corrodedPDX - C5- 280.00 BEAM HAS CORROSION AROUND RIVETS ON TOP FLANGE RT SIDE EXTENDING OUT 24 INCHES FROM CENTERLINE. REMOVED CORROSION ON 280.00 BEAM IAW CRJ-700 REO 670-53-11-046. PERFORMED THICKNESS CHECK IAW CRJ NDTM 51-20-004 - MAX READ .040 INCH, MINIMUM RSDR SWAA090891Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED AT BS 986, RBL 41. REPAIRED BEAM PER SRM.SDR SWAA090887Floorbeam · crackedDURING SCHEDULED 14Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 667, LBL 24. REPAIRED BEAM PER SWA EA.SDR SWAA090886Floorbeam · crackedDURING SCHEDULED 14Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 670, RBL 24. REPAIRED BEAM PER SWA EA.SDR CALA2009020500087Floorbeam · corrodedFLOOR SUPPORT FOUND CORRODED AT BODY STATION 325 BETWEEN LBL 26-59 AFTER FLOOR PANEL REMOVED. CABIN BODY STATION 325 BETWEEN LBL 26 - LBL 60 FLOOR SUPPORT BEAM REPAIRED AS PER SRM 53-00-51 REPAIR 1 FIG 201 AND HFEC NO CRACK FOUND.SDR DL75E090147Floorbeam · corrodedDURING CURRENT HMV CHECK, EXTENSIVE CORROSION WAS FOUND ON THE FS 365 FLOORBEAM UPPER CHORD, FROM BL0 TO RHS END. THE UPPER CAP WAS CUT OUT AND A NEW SECTION SPLICE IN PER BOEING APPROVED REPAIR INSTRUCTIONS, AS IS DOCUMENTED IN ER/A 472304-14.SDR SWAA090875Floorbeam · crackedDURING SCHEDULED 14Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 667, LBL 24. REPAIRED BEAM PER ER.SDR A6WA200940096Floorbeam · crackedCRACK FOUND ON BRACKET FS 280, LBL 9 INBD AND OTBD NEW BRACKET INSTALL AT FS 280, RBL 9 INBD AND OTBD IAW SRM 51-42-21. (K)SDR USAA2009020690295Floorbeam · corrodedPIT - S4 - MAJOR REPAIR - LEVEL 2 INTERGRANULAR CORROSION ON FLOORBEAM BETWEEN FR20 TO FR24, Y765. REPLACED FLOORBEAM BETWEEN FR20 TO FR24, Y765 IAW A319 SRM 51-72-11.SDR SWAA090815Floorbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM UPPER FLANGE CORRODED AT BS 360, BETWEEN LBL 21 TO RBL 21. REPAIRED BEAM PER ER.SDR SWAA090810Floorbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM CORRODED AT BS 986 BETWEEN RBL 18 TO RBL 42, WL 208. REPAIRED BEAM PER ER.SDR SWAA090809Floorbeam · crackedDURING SCHEDULED 12Y CHECK, FOUND FLOORBEAM CRACKED AT BS 709, RBL 24. REPAIRED BEAM PER SWA EA.SDR SWAA090807Floorbeam · crackedDURING SCHEDULED 12Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 658, RBL 24. REPAIRED BEAM PER SWA EA.SDR SWAA090796Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 727B, RBL 45. REPAIRED BEAM PER SWA EA.SDR CALA2009020400081Floorbeam · corrodedCABIN FLOOR SUPPORT FOUND CORRODED AT BS 303 BETWEEN LBL 15 - 56. CABIN FLOOR SUPPORT BEAM AT BS 303 BETWEEN LBL 15 TO LBL 58 REPAIRED PER SRM 53-00-51 REPAIR 1 FIG 201 AND HFEC NO CRACK FOUND.SDR FDEA200902030438Floorbeam · corrodedSTA 2681 FLOORBEAM TOP AND BOTTOM SURFACE ALONG ANCHOR NUTS AREA HAVE CORROSION. REPAIRED FLOORBEAM AT STA 1681 RBL-31 BOTTOM SURFACE IAW SRM 53-00-51 REPAIR NR 2. THIS IS MAJOR 'A' REPAIR NO FOLLOW-UP INSPECTION REQUIRED.SDR CNMA20090122Floorbeam · crackedBS1239, LBL 48-74 THERE IS A CRACK ON THE FLOORBEAM. DAMAGED FLOORBEAM REMOVED, NEW FABRICATED. IAW SRM VOL 3, 57-14-01 FIG 5 AND OMNI GMM 4.45. INSTALLED FASTENERS IAW SRM VOL.2. 51-31-01.SDR CNMA20090121Floorbeam · crackedBS 1239 LBL 29-46 THERE IS A CRACK ON THE FLOORBEAM. DAMAGED FLOORBEAM REMOVED, NEW FABRICATED IAW SRM VOL 3. 53-14-01 FIG 5 AND GMM 4.45 AND INSTALLED FASTENERS IAW SRM VOL 2. 51-21-01.SDR CNMA20090113Floorbeam · tornBS1871, RBL45, FLOORBEAM IS TORN. TORN FLOORBEAM REMOVED FABRICATEDNEW FLOORBEAM IAW SRM VOL 3, 53-14-01 FIG 5 AND GMM 4.45 AND INSTALLED FASTENERS IAW SRM VOL 3, 51-31-01.SDR CNMA20090112Floorbeam · corrodedBS1941, RBL40 CORROSION ON FLOORBEAM. DAMAGED FLOORBEAM REMOVED. FABRICATED NEW FLOORBEAM IAW SRM VOL 3, 53-16-01 FIG 8 GMM 4.45 AND INSTALLED FASTENERS IAW SRM VOL 2, 51-31-01.SDR CNMA20090111Floorbeam · corrodedBS 1964, RBL 43-46 CORROSION ON FLOORBEAM. DAMAGED FLOORBEAM REMOVED, AND NEW FABRICATED IAW SRM VOL 3, 53-16-01 FIG 8 AND GMM 4-45. INSTALLED FASTENERS IAW SRM VOL 2, 51-31-01.SDR CNMA20090106Floorbeam · tornSTA 1821, BL-0 UPPER FLANGE OF FLOORBEAM IS TORN (UNDER CENTER RAIL). DAMAGED AREA TRIMMED OUT. REINFORCED AREA WITH ANGLES AND E FILLERS IAW SRM 53-00-01 FIG 2. INSTALLED FASTENERS IAW SRM VOL 2 51-31-01.SDR CNMA20090104Floorbeam · corrodedSTA 878, B/T LBL28 AND LBL60 DEEP CORROSION ON FLOORBEAM. DAMAGED FLOORBEAM REMOVED, NEW FABRICATED IAW SRM VOL 3, 53-13-01 FIG 24 AND GMM 4.45. INSTALLED FASTENERS IAW SRM VOL 2, 51-31-01.SDR SWIA200921801Floorbeam · crackedC-CHECK, CARGO DOOR ENTRANCE FLOORBEAM CRACKED. REPAIRED WEB PER SRM.SDR ASOA00900158Floorbeam · corrodedFS 280 FLOORBEAM IS CORRODED (RT OF BL 0). REMOVED AND REPLACED FS 280 BEAM (RT OF BL 0). REMOVED RIGHT SIDE BEAM IAW SRM 700 51-42-06 AND 51-42-21. PILOT DRILLED RT FS 280 FLOORBEAM PER CRJ 700 SRM 51-41-00. BEGIN FINAL SIZING HOLES IN AFT FACE RT 280 BEASDR DL757090619Floorbeam · corrodedFS 365 FLOORBEAM CORRODED, REPAIRED PER SRM 53-00-01.SDR F3LA2009020900022Floorbeam · corrodedDURING C3 C-CHECK, INSPECTION NOTED THE LEFT AFT GALLEY FLOORBEAM Y1292 HAS CORROSION AROUND FASTENER HOLES BETWEEN FRAME 67 AND FRAME 68. MAINTENANCE REMOVED AND REPLACED FLOORBEAM IAW SRM 51-42-11, PARAGRAPHS 5 AND 7.SDR ASOA200900158Floorbeam · corrodedFS 280 FLOORBEAM IS CORRODED (RT OF BL0).SDR ASOA200900157Floorbeam · corrodedFS 280 FLOORBEAM IS CORRODED (LT OF BL0). LT FS 280 FLOORBEAM (LT OF BL 0). REMOVED AND REPLACED PER SRM 51-42-06 & 51-42-21. REMOVED LEFT BEAM IAW SRM 700 51-42-06 AND 51-42-21. PILOT DRILLED L/S FS 280 FLOORBEAM PER SRM 51-41-00. FINAL SIZED HOLES IN L/SDR SWAA090781Floorbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM CORRODED AT BS 986, BETWEEN RBL 18 TO RBL 42, WL 208. REPAIRED BEAM PER ER.SDR SWAA090780Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM TEE CAP CORRODED AT BS 986, BETWEEN RBL 48 TO LBL 48, WL 208. REPAIRED BEAM PER SWA EA.SDR SWAA090776Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL BEAM CRACKED AT BS 727B, RBL 45. REPAIRED BEAM PER ER.SDR SWAA090747Floorbeam · crackedDURING SCHEDULED 14Y CHECK, FOUND FLOORBEAM CRACKED AT BS 312, RBL 25. REPAIRED BEAM PER SRM.SDR USAA2009020690297Floorbeam · corrodedPIT - S4 - MAJOR REPAIR - LEVEL 2 FILIFORM CORROSION ON FLOORBEAM BETWEEN FR64 TO FR66, Y704. REPLACED FLOORBEAM BETWEEN FR64 TO FR66, Y704 IAW A319 SRM 53-41-04.SDR SWIA200921848Floorbeam · corrodedC-CHECK, FS 280 BEAM CORRODED. REPAIRED PER REO.SDR SWIA200921847Floorbeam · crackedC-CHECK, FS 280 BEAM CRACKED AND CORRODED. REPAIRED PER REO.SDR SWIA200921317Floorbeam · crackedC-CHECK, FS 280 FLOOR SUPPORT BEAM CRACKED. REPAIRED PER REO.SDR SWIA200921316Floorbeam · crackedC-CHECK, FS 280 FORWARD FLOOR SUPPORT AT LBL9 AND RBL9 CRACKED. REPAIRED PER SRM.SDR QXEA2009020200063Floorbeam · corrodedPDX - C2 - CORNER ANGLE OTBD OF BEAM FS 280 RT SIDE HAS LIGHT SURFACE CORROSION. REMOVED FASTENERS FROM REPAIR AREA IAW REO 670-53-21-139. CUT OUT DAMAGED SECTION OF FLOOR SILL IAW REO 670-53-21-139. HFEC IAW NDTM PART 1, 51-20-006 AT CUT OUT, NO CRACKS NOTSDR QXEA2009020200062Floorbeam · crackedPDX - C2 - CRACK ON BEAM FS 280 AT APPROX RBL 9.00. REMOVED RT SECTION OF 280 BEAM. CUT REPLACEMENT RT SECTION OF 280 BEAM IAW REO 670-53-11-047. PERFORMED HFEC INSP OF BEAM CUTOUT IAW NDTM 51-20-006, NO CRACKS NOTED. LOCATED, DRILLED AND COUNTERSUNK REPLASDR QXEA2009020200061Floorbeam · crackedPDX - C2 - CRACK ON BEAM FS280 AT APPROX LBL 9.00. REMOVED THE LT SIDE OF THE 280 BEAM AT THE CENTER SPLICE IAW REO670-53-11-052, CUT REPLACEMENT LT SECTION OF FS280 BEAM IAW REO 670-53-11-047. PERFORMED HFEC INSP OF BEAM CUT OUT IAW 51-20-006, NO CRACKS NOTSDR FDEA200901300404Floorbeam · corrodedFOUND CORROSION SPOTS ON CROSSBEAM C 62 OUT OF SRM LIMIT. SPLICE REPAIR PERFORMED IAW SRM 53-10-15 FIG 207.SDR FDEA200901300402Floorbeam · corrodedFOUND CROSSBEAM C 64 CORRODED. REPAIR PERFORMED BY REPLACEMENT OF PART IAW SRM 51-72-10.SDR SWIA200921616Floorbeam · corrodedC-CHECK, FS 280 COCKPIT FLOOR SUPPORT CORRODED. REPLACED FLOOR SUPPORT.SDR AALA2009020900034Floorbeam · corrodedCORROSION ON TOP OF FLOORBEAM 23 TO 29 INCHES AT STATION 294.5. REPAIRED IN ACCORDANCE WITH ESO 61000 DATED 26 JAN 2009.SDR USAA2009020490279Floorbeam · corrodedPIT - S4 - MAJOR REPAIR - LEVEL 2 INTERGRANULAR CORROSION ON FLOORBEAM BETWEEN FR64 TO FR69, -Y1292. REPLACED FLOORBEAM BETWEEN FR64 TO FR69, -Y1292 IAW A319 SRM 51-72-11.SDR USAA2009020490278Floorbeam · corrodedPIT - S4 - MAJOR REPAIR - LEVEL 2 INTERGRANULAR CORROSION ON FLOORBEAM BETWEEN FR67 TO FR68, -Y1292. REPLACED FLOORBEAM BETWEEN FR67 TO FR68, -Y1292 IAW A319 SRM 51-72-11.
Back to JASC 5315