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 CALA0800011Floorbeam · corrodedSTA 986.5 FLOORBEAM CORRODED RBL 22 TO LBL 9. REMOVED AND REPLACED UPPER T-CHORD PER SRM 51-40-02.SDR SWIA200819513Floorbeam · crackedCOCKPIT FLOOR SUPPORT AT FS 280 IS CRACKED AT LBL9, FOUND AT C-CHECK. INSTALLED REPAIR PARTS PER CRJ700/900 SRM 51-23-00 PG 1-10 AND 51-42-06 PG 7-8.
SDR SWIA200819512Floorbeam · crackedFS 280 BEAM CRACKED AT RBL 9.0, FOUND AT C-CHECK. COMPLIED WITH REPAIRS PER CRJ7/9 SRM 51-42-21 PG 9-11.SDR USAA920080158Floorbeam · corrodedPIT - MAJOR REPAIR - BC4 CHECK - CORROSION ON CABIN FLOORBEAM, BS 3158 / FR 66 - BS 3366 / FR 70, +Y1162. REPLACED CABIN FLOORBEAM, BS 3158 / FR 66 - BS 3366 / FR 70, +Y1162 IAW A320 SRM 51-72-11.SDR USAA920080157Floorbeam · corrodedPIT - MAJOR REPAIR - BC4 CHECK - CORROSION ON CABIN FLOORBEAM, BS 3158 / FR 66 - BS 3366 / FR 70, +Y1162. REPLACED CABIN FLOORBEAM, BS 3158 / FR 66 - BS 3366 / FR 70, +Y1162 IAW A320 SRM 51-72-11.SDR USAA920080156Floorbeam · corrodedPIT - MAJOR REPAIR - BC4 CHECK - CORROSION ON CABIN FLOORBEAM, BS 3043 / FR 64 - BS 3510 / FR 69, -Y1162. REPLACED CABIN FLOORBEAM, BS 3043 / FR 64 - BS 3510 / FR 69, -Y1162 IAW A320 SRM 51-72-11.SDR USAA920080155Floorbeam · corrodedPIT - MAJOR REPAIR - BC4 CHECK - CORROSION ON CABIN FLOORBEAM, BS 3043 / FR 64 - BS 3510 / FR 69, -Y1162. REPLACED CABIN FLOORBEAM, BS 3043 / FR 64 - BS 3510 / FR 69, -Y1162 IAW A320 SRM 51-72-11.SDR USAA920080154Floorbeam · corrodedPIT - MAJOR REPAIR - BC4 CHECK - CORROSION ON CABIN FLOORBEAM, BS 3043 / FR 64 - BS 3510 / FR 69, -Y1162. REPLACED CABIN FLOORBEAM, BS 3043 / FR 64 - BS 3510 / FR 69, -Y1162 IAW A320 SRM 51-72-11.SDR DHL2007873513Floorbeam · damagedMAIN CARGO COMPT FLOORBEAM MISDRILLED HOLE AT BS 660 LBL 15"125 (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW SRM 51-2-1 FIG 1 SHEET 9-12, TR NR 51-130 DATED 01-26-04. REMOVED FASTENERS IAW SRM 51-1-20D. CUT OUT DAMAGED SECTION AND FABRICATED REPAIR ANGLE AND SDR SWAA080112Floorbeam · corrodedDURING SCHEDULED BRDG CHECK, FOUND TEE CHORD CORRODED AT BS 807, RBL 21. REMOVED AND REPLACED TEE CHORD PER SRM.SDR SWAA080113Floorbeam · corrodedDURING SCHEDULED BRDG CHECK, FOUND FLOORBEAM UPPER CHORD CORRODED AT BS 294, LBL 7. REPAIRED UPPER CHORD PER SRM.SDR SWIA200819525Floorbeam · crackedWEB STIFFENER AT FS 280 AND RBL 26 IS CRACKED, FOUND AT C-CHECK. COMPLIED WITH REPAIRS PER CRJ700 SRM 51-42-06-001-001-A01.
SDR SWIA200819524Floorbeam · crackedCOCKPIT FLOOR SUPPORT ANGLE IS CRACKED AT LBL 9, FOUND AT C-CHECK. REPAIRED COCKPIT FLOOR SUPPORT AT FS 280.00 PER CRJ700/900 SRM 51-42-06.
SDR SWIA200819523Floorbeam · crackedFS 280 FLOOR SUPPORT BEAM IS CORRODED AND CRACKED, FOUND AT C-CHECK. REPAIRED FS 280 FLOOR SUPPORT BEAM PER CRJ7/9 SRM 51-42-06 AND REO 620-33-11-265.
SDR QXEA200802079Floorbeam · corrodedPDX - C5 CHECK - CARGO PIT SUPPORT ANGLE FOR AFT END OF CARGO DOOR THRESHOLD IS CORRODED ON TOP AND BOTTOM SURFACES LOCATED ON STRUCTURE UNDER PANEL 145DZ (X600.00, Y29L, Z101.842). REMOVED ANGLE AND INSTALLED NEW ANGLE FROM STOCK IAW -8 200 SRM 51-40-00 AND SDR COMA0860012Attach Bracket · crackedDURING HMV3 INSPECTION FOUND LONGITUDINAL FLOORBEAM ATTACH BRACKETS CRACKED AT AFT SIDE. REMOVED AND REPLACED DAMAGED BRACKETS.SDR SWAA080041Floorbeam · corrodedDURING SCHEDULED BRDG CHECK, FOUND FLOORBEAM CORRODED AT BS 986, LBL 30 TO LBL 47. REPAIRED FLOORBEAM PER SWA EA.SDR 07FDEA05167Floorbeam · crackedCROSSBEAM CRACKED AT FR 30 AND BETWEEN TRACKS Y 450 AND Y 953. REPAIRED IAW SRM 53-10-15, FIG 212.SDR 07FDEA05165Floorbeam · corrodedFLOORBEAM AT Y 1959 AND BETWEEN FR 12A AND 13A WITH CORROSION. FLOORBEAM REPLACED PER SRM 51-72-10.SDR 07FDEA05163Floorbeam · crackedAFT CARGO COMP'T, CROSSBEAM CRACKED AT FRAME 64 BETWEEN TRACKS Y-953 AND Y- 1456. CROSSBEAM REPAIRED AT FRAME 64 BETWEEN TRACKS Y-953 AND Y-1456 IAW SRM 53-10-15, FIG 211, (SHEETS 1 AND 2).SDR 07FDEA05162Floorbeam · crackedAFT CARGO COMP'T, CROSSBEAM CRACKED AT FRAME 59 BETWEEN TRACKS Y-953 AND Y- 1456. CROSSBEAM REPAIRED AT FRAME 59 BETWEEN TRACKS Y-953 AND Y-1456 IAW SRM 53-10-15, FIG 211 (SHEET 1 AND 2).SDR EIA2008002Floorbeam · bentBODY STATION 1780, LBL 29, WL 118 FLOORBEAM UPPER CHORD HAS AFT FLANGE BENT. REMOVED DAMAGED FLANGE UPPER CHORD. FABRICATED AND INSTALLED REPAIR PER B747 SRM 51-70-12 PAGES 201-207 AND 51-40-02 PAGES 1-3.SDR USAA920080118Floorbeam · corrodedPIT - MAJOR REPAIR - C4 CHECK, LEVEL 2 CORROSION ON FLOORBEAM, BS 1661, BL 0. REPAIRED FLOORBEAM, BS 1661, BL 0 IAW B757 SRM 53-00-51 REPAIR 5.SDR ABXA080038Floorbeam · crackedFLOORBEAM ANGLE AT RIGHT BUTT LINE 25, STA 1092 WAS CRACKED AT UPPER END. REMOVED AND REPLACED ANGLE IAW B767 SRM 51-40-02 AND 53-60-07.SDR DHL2007873504Floorbeam · damagedMAIN CARGO COMPT FLOORBEAM MISDRILLED HOLES AT STA 600.000 RBL 32.250 AND RBL 38" (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW SRM 51-2-1 FIG 1 SHEET 9-12 TR NR 51-30 DATED JAN 26-04. REMOVED FASTENERS IAW SRM 51-1-20D, CUT OUT DAMAGED SECTION, FABRICATED REPASDR DHL2007873502Floorbeam · damagedMAIN CARGO COMPT FLOORBEAM MISDRILLED HOLE AT STA 620.000 RBL 38" (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW SRM 51-2-1 FIG 1 SHEET 9-12, TR NR 51-130 DATED JAN 26-04. REMOVED FASTENERS IAW SRM 51-1-20D. CUT OUT DAMAGED SECTION AND FABRICATED REPAIR ANGLE ASDR EIA2008006Floorbeam · gougedFLOORBEAM WEB HAS DEEP GOUGE AT BS 1780, LBL 16, WL 105. REMOVED DAMAGED SECTION OF WEB FABRICATED AND INSTALLED REPAIR PER B747 SRM 53-00-07 PAGES 201-202 AND 51-40-02 PAGE 1-3.SDR USAA920080109Floorbeam · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED FLOORBEAM, BS 665 - BS 669, LBL 24. REPAIRED FLOORBEAM, BS 665 - BS 669, LBL 24 IAW USAIRWAYS EA 100085.SDR 07FDEA05152Floorbeam · crackedAFT CARGO COMP'T, CROSSBEAM CRACKED AT FRAME 66 BETWEEN TRACKS Y -953 AND Y- 1456. CROSSBEAM REPAIRED AT FRAME 66 BETWEEN TRACKS Y -953 AND Y -1456 IAW SRM 53-10-15, FIGURE 211 (SHEET 1 AND 2).SDR EIA2008005Floorbeam · puncturedFLOORBEAM WEB PUNCTURED BODY STATION 1800, LBL 53, WL 108. REMOVED DAMAGED AREA OF WEB, FABRICATED AND INSTALLED REPAIR PER ENGINEERING DISPOSITION LETTER ITEM 1 AND 2 DATED 12-21-07 AND B747 SRM 53-00-07 PAGES 201-203.SDR USAA920080134Floorbeam · corrodedPIT - MAJOR REPAIR - C4 CHECK, LEVEL 2 CORROSION ON FLOORBEAM, BS 377, LBL 12. REPAIRED FLOORBEAM, BS 377, LBL 12 IAW USAIRWAYS TYPICAL REPAIR 53-15-01.SDR EIA2008003Floorbeam · bentBODY STATION 1780, RBL 18, WL 118 FLOORBEAM UPPER CHORD HAS AFT FLANGE BENT. CUT OUT DAMAGED CHORD, FABRICATED AND INSTALLED REPAIR PER B747 SRM 51-70-12 PAGE 202 FIGURE 201, 51-70-12 PAGES 201-206 AND 51-40-02 PAGE 1.SDR USAA920080120Floorbeam · crackedPIT - MAJOR REPAIR - C4 CHECK, CRACKED FLOORBEAM, BS 1320 - BS 1340, BL 0. REPAIRED FLOORBEAM, BS 1320 - BS 1340, BL 0 IAW B757 SRM 53-00-51.SDR SWAA076466Floorbeam · crackedDURING SCHEDULED BRIDGE CHECK, FOUND FUSELAGE FLOORBEAM CRACKED AT BS 947.5, LT LOWER SIDE AT CORNER FASTENER HOLE. REPAIRED FLOORBEAM PER SWA EA & SRM.SDR 07FDEA05136Floorbeam · misrepairedPREVIOUS CROSSBEAM REPAIR LOCATED IN AFT CARGO UNDER FLOOR AT FRAME 63 BETWEEN ROLLER TRACKS NR 3 LT Y1470 TO PRODUCTION SPLICE INBOARD OF NR 3 RT Y1470, HAS 3 EACH REPAIR SECTIONS PREVIOUSLY INSTALLED REPAIR LOCATED AT AFT CARGO UNDER FLOOR AT FRAME 63 BETWSDR 07FDEA05129Floorbeam · misrepairedPREVIOUS CROSSBEAM REPAIR LOCATED IN BULK CARGO UNDER FLOOR AT FRAME 64 RIGHT SIDE BETWEEN Y140 AND Y805, HAS 1 EACH REPAIR SECTION MEASURING 25.2" LONG AND 2 EACH REPAIR ANGLES MEASURING 9.2" LONG ON THE FWD AND AFT SIDES PREVIOUSLY INSTALLED REPAIR LOCATED ASDR 07FDEA05128Floorbeam · misrepairedPREVIOUS CROSSBEAM REPAIR LOCATED IN BULK CARGO UNDER FLOOR AT FRAME 65 BETWEEN RT Y210 TO LT Y1470, HAS 1 EACH REPAIR SECTION MEASURING 53.4" LONG AND 2 EACH REPAIR ANGLES MEASURING 8.8" LONG ON THE LT SIDE AND 9.5" LONG ON THE RT SIDE PREVIOUSLY INSTALLED RESDR 07FDEA05126Floorbeam · corrodedFWD CARGO COMPARTMENT CROSSMEMBER AT FRAME 34 HAS EXFOLIATION CORROSION AT CENTER AND RT ROLLER TRAY MATING SURFACE REMOVED CORROSION IAW A310 SRM 51-74-10. FOUND TO BE OUT OF LIMITS IAW A310 SRM 53- 10-15. FABRICATED CROSSMEMBER AND SPLICE ANGLES IAW A310 SDR 07FDEA05125Floorbeam · corrodedFWD CARGO COMPARTMENT AT FR 36 CROSSMEMBER HAS EXFOLIATION CORROSION AT CENTER AND RT ROLLER TRAY MATING SURFACE REMOVED CORROSION IAW A310 SRM 51-74-10 FOUND TO BE OUT OF LIMITS IAW A310 SRM 53-10-15. FABRICATED CROSSMEMBER AND SPLICE ANGLES IAW A310 SRM 53-SDR SWIA200719454Floorbeam · crackedSTA 280 AT RBL 9 LOWER FLOORBEAM IS CRACKED, FOUND AT C-CHECK. COMPLIED WITH FLOORBEAM REPAIR PER 601R -53-11-1305/601R 53-11-171.
SDR SWIA200719453Floorbeam · crackedFOUND AT C-CHECK, STA 280 AT LBL 9 UPPER FLOORBEAM IS CRACKED. COMPLIED WITH REPAIRS IAW CRJ200 REO 601R-53-11-138.SDR 2007UALA05237Floorbeam · corrodedFLOORBEAM IS CORRODED AT STA 1016 LBL 6 - LBL 9. SUSPECT MOISTURE CONTAMINATION. MAJOR REPAIR ACCOMPLISHED REMOVED DAMAGE AND INSTALLED UPPER TEE CAP FRAME REPAIR. AC OK FOR SERVICE.SDR CA071222005Floorbeam · corroded(CAN) AFT CABIN FLOORBEAM AT BS 947, LBL53 FOUND CORRODED DURING CPCP INSPECTION. LEVEL 2 CORROSION FOUND. REPAIRED IAW CUSTOMER EA. (TC NR 20071222005)SDR CA071222004Floorbeam · corroded(CAN) PASSENGER CABIN FLOORBEAM AT BS 344, RBL4 TO LBL56 FOUND CORRODED DURING CPCP INSPECTION. LEVEL 2 CORROSION. REPAIRED IAW CUSTOMER EA. (TC NR 20071222004)SDR CA071222002Floorbeam · corroded(CAN) AFT CARGO PIT FLOOR SUPPORT RAIL AT BS 767+14, LBL 3 FOUND CORRODED DURING CPCP INSPECTION. LEVEL 2 CORROSION. REPAIRED IAW CUSTOMER EA. (TC NR 20071222002)SDR CA071222001Floorbeam · corroded(CAN) AFT CARGO PIT FLOOR SUPPORT RAIL AT BS 767+5 RBL 3 FOUND CORRODED DURING CPCP INSPECTION. LEVEL 2 CORROSION. REPAIRED IAW CUSTOMER E.A. (TC NR 20071222001)SDR 1092008Floor Support · corrodedSEAT TRACK Y-254 BETWEEN FR 20 TO FR 16 HAS 4 EACH AREAS OF CORROSION (AREA 1 1.5 INCH X .5) (AREA 2 .6 INCH X .5) (AREA 3 .5 INCH X .4) ( AREA4 1.5 INCH X .7)SDR USAA920080050Floorbeam · corrodedPIT - MAJOR REPAIR - C4 CHECK, LEVEL 2 CORROSION FLOORBEAM, BS 1641, LBL 16. REPAIRED FLOORBEAM, BS 1641, LBL 16 IAW USAIRWAYS TYPICAL REPAIR 53-15-01.SDR 07FDEA05122Floorbeam · corrodedCORROSION AROUND NUT PLATE ON TOP OF FLOORBEAM AT FS 1130, LBL 51, WL 208. REMOVED CORROSION AROUND NUT PLATE ON TOP OF FLOORBEAM STA 1130, LBL 51, FOUND TO BE OUT OF LIMITS REF SRM 53-10-8. SAME LOCATION SEAT TRACK FOUND TO BE OUT OF LIMITS. FABRICATED ANDSDR 2007UALA05226Floorbeam · corrodedMAIN CABIN FLOORBEAM STA 324 UPPER SURFACE HAS CORROSION. ACCOMPLISHED MAJOR REPAIR.
Back to JASC 5315