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 08FDEA03400Floorbeam · crackedMAIN DECK FLOORBEAM INTERCOSTAL MID CHORD EXISTING REPAIR DOUBLER IS CRACKED BS 302, WL 207 FABRICATED NEW REPAIR ANGLE REF SRM 51-40-3 PG 1. TREATED AND PRIMED REF SRM 51-10-2 PG 1-9. INSTALLED ANGLE REF SRM 51-30-2 PGS 1-7. THIS IS CLASSIFIED AS A MINOR RSDR USAA920081632Floorbeam · corrodedMCN C19 MAJOR REPAIR NR 6124249 - EXFOLIATION CORROSION ON TRANSVERSE BEAM AT BS986.5, WL208, RBL16. REPAIRED TRANSVERSE BEAM AT BS986.5, WL208, RBL16 IAW US AIRWAYS EA NR 130100.SDR UPS08853209Floorbeam · damagedINSPECTION TYPE:C2 DEEP SCRATCH ABOUT 16 INCHES LONG MAIN CABIN WING BOX FLOORBEAM UPPER SURFACE STA 880 LBL 25-45. FABBED AND INSTALLED REPAIR DOUBLER IAW SRM 51-1-8, 51-1-21, 51-1-20D.SDR F3LA200800553Floorbeam · corrodedDURING C-CHECK, INSP NOTED 3 OB NUT CLIP HOLES CORRODED ON FLOORBEAM Y1292 (L-2) AT FR 67. MAINT REMOVED AND REPLACED FLOORBEAM IAW SRM 51-42-11, PARAGRAPH 5. UPON COMPLETION OF THE REPAIR, IT WAS INSPECTED AND FOUND ACCEPTABLE. (S)SDR USAA920081513Floorbeam · corrodedPIT - S4-MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM AT FR66, Y512. REPLACED FLOORBEAM AT FR66, Y512 IAW A319 SRM 51-42-11. (S)SDR 2008UALA04248Floorbeam · corrodedFLOORBEAM CORRODED (MARKED ). REMOVED FLOORBEAM. TRANSFERRED BRACKETS ONTO NEW FLOORBEAM. INSTALLED FLOORBEAM.SDR 2008UALA04249Floorbeam · corrodedFLOORBEAM 190 CORRODED (MARKED). REMOVED BEAM. INSTALLED NEW FLOORBEAM.SDR 2008UALA04247Floorbeam · corrodedFLOORBEAM 150 CORRODED (MARKED). REMOVED FLOORBEAM. TRANSFERRED BRACKETS ONTO NEW FLOORBEAM. CONNECTED FLOORBEAMS 150 AND 95 TOGETHER AND HAVE THEM IN PLACE. INSTALLED FLOORBEAM.SDR 2008UALA04204Floorbeam · corrodedFLOORBEAM 185 CORRODED (MARKED). REMOVED CORROSION. ASSEMBLY OF FLOORBEAM COMPLETED. PAINTED & INSTALLED FLOORBEAM.SDR 2008UALA04203Floorbeam · corrodedFLOORBEAM 145 CORRODED (MARKED). ASSEMBLED FLOORBEAM. INSTALLED BOLTS AND PAINTED. INSTALLED FASTENERS TO COMPLETE FLOORBEAM AND PAINTED.
SDR 2008UALA04202Floorbeam · corrodedFLOORBEAM 140 CORRODED (MARKED). COMPLETED BEAM ASSY. PAINTED FLOORBEAM & INSTALLED BOLTS. INSTALLED FLOORBEAM.SDR 08FDEA03374Floorbeam · corrodedCORROSION FOUND ON FLOORBEAM AT STA 365, RBL 3 TO RBL 51. EVALUATE AND RECTIFY. REPAIR CARRIED OUT ON FLOORBEAM UPPER CHORD AT STATION 365 BETWEEN RBL 3 AND RBL 51 IN ACCORDANCE WITH B 757-200 SRM 53-00-51 FIGURE 201 REPAIR 1, REVISION 93. REPAIR IS CLASSIFSDR COMA086347Floorbeam · corrodedDURING HMV-3 INSPECTION, FOUND UPPER CAP OF FS 280 FLOOR WEB CORRODED FROM LBL 9-RBL 9. CUT OUT DAMAGED SECTION OF WEB AND CAP, INSTALLED WEB DOUBLER, FILLER, AND UPPER CAP ANGLE PER EA 10-5310-02294. (S)SDR SWIA200820456Floorbeam · crackedC-CHECK, FS 280 LBL9 INBOARD AND OUTBOARD TIE CLIPS CRACKED. REPAIRED PER REO.SDR SWIA200820455Floorbeam · crackedC-CHECK, FS 280 RBL9 INBOARD AND OUTBOARD CLIPS CRACKED. REPAIRED PER REO.SDR UPS08653109Floorbeam · crackedINSPECTION TYPE:C FX - CABIN FLOORBEAM ATTACHMENT STIFFENER AT STA 246 LBL 50 FOUND CRACK. CRACK LENGTH 0.75 INCH. FX CABIN FLOORBEAM STA 246 LBL 50 ATTACHMENT STIFFENER WAS REPLACED AS PER SRM 51-10-02 AND INSTALLED AS PER SRM 51-40-02.SDR 08FDEA03356Floorbeam · corrodedSURFACE CORROSION STA 720D RBL 12 TOP OF FLOORBEAM. REMOVED CORROSION IAW SRM 51-10-6, FOUND CORROSION OUT OF LIMITS IAW SRM 53-10-1 FIG 4, CUTOUT DAMAGED AREA IAW SRM 53-10-8 FIG 3, FABRICATED UPPER CHORD, 2 SUPPORT ANGLES AND 2 REINFORCEMENT STRAPS IAW SRM SDR USAA920081606Floorbeam · corrodedCLT Q6 MAJOR REPAIR NR 03C10853057/006 LEVEL 2 CORROSION ON FLOOR BEAM T CAP AT BS986, BLO. REPAIRED T CAP UPPER FLANGE IAW B737 TYPICAL REPAIR NR 53-60-01 REV A.SDR UPS08553100Floorbeam · corrodedCORROSION ON LONGITUDINAL FLOORBEAM TOP CHORD BETWEEN BS 1011-1015 LBL 44.5, WL 207. BLENDED DAMAGE AND REPAIRED PER EO 08-2597 AND UPS B757-5310-30207A.SDR CNMA20090053Floorbeam · corrodedCORROSION ON FLOOR SUPPORT AT STA 815 X19. FABRICATED AND INSTALLED NEW PN ADA7326-1 IAW DWG ADA7326 AND 7548 AND SRM 51-35-01, STEP 1, VOL II, REV 94.SDR CNMA20090052Floorbeam · corrodedLIGHT CORROSION ON FLOORBEAM AT STA 859 X-72. REMOVED CORROSION IAW SRM 51-21-01, ERV 94, VOL II OUT OF LIMITS. REPLACED PN ADD 7160-2 IAW SRM 51-35-01, VOL II, REV 94, STEP 1 (REF DWG ADD 7163).SDR CNMA20090051Floorbeam · corrodedCORROSION ON FLOOR SUPPORT TEE AT AFTER PRESSURE BULKHEAD, STA 2007. X-40 - X-60, AND X 20. PERFORMED REPAIR IAW SRM 53-40-00, FIG 16, REF 94, VOL I.SDR CNMA20090048Floorbeam · corrodedLIGHT CORROSION ON FLOOR SUPPORT AT STA 815 X-18. FABRICATED AND INSTALLED NEW PN ADA7326-1 IAW DWG 7696 AND ADA7548 AND SRM 51-35-01 STEP 1, VOL II REV 94.SDR CNMA20090035Floorbeam · crackedCTR CARGO COMPT, FLOOR STRUCTURE, AT STA 1523 (FWD BULKHEAD) NR 4 ANGULARS CRACKED. OPEN PANELS 183JE-183FE FWD BULKHEAD CTR CARGO COMPARTMENT IAW AMM 20-50-02 REV 81. PERFORM REPAIR IAW SRM 53-00-01, FIG 8, SHI REV 93 VOL I OK DONE. CLOSE PANELS 183JE, 189SDR CNMA20090031Floorbeam · crackedCTR CARGO COMP FLOOR UNLOAD BEAM CRACKED AT STA 1690 (UPPER FLANGE) PERFORMED REPAIR IAW SRM 53-70-00 FIG 3 REV 93 VOL J. PERFORMED PAINTING IAW SRM 51-21-02 VOL II REV 94.SDR SWIA200820407Floorbeam · crackedC-CHECK, FS 280 LOWER FLOOR SUPPORT CRACKED AT LBL9.. REPAIRED PER REO.SDR SWIA200820406Floorbeam · crackedC-CHECK, FS 280 RBL9 LOWER FLOOR SUPPORT CRACKED. REPAIRED PER REO.SDR SWIA200820405Floorbeam · crackedC-CHECK, FS 280 FORWARD FLOOR SUPPORT CRACKED AT RADIUS, REPLACED.SDR SWIA200820404Floorbeam · crackedC-CHECK, FS 280 RBL9 SUPPORT CRACKED. REPAIRED PER REO.SDR 2008UALA04175Floorbeam · corrodedFLOORBEAM 80 CORRODED (MARKED). *S/D* REMOVED FASTENERS FROM FWD SPLICE. ASSEMBLED BEAM 80. INSTALLED FASTENERS IN SPLICE AND LATERAL BEAM CONNECTIONS. BEAM COMPLETED & INSTALLED.SDR 2008UALA04176Floorbeam · corrodedFLOORBEAM 175 CORRODED. *S/D* REMOVED BEAM AND AFT 2 PROFILES. BEAM PARTIALLY INSTALLED AND IN PLACE. INSTALLED BEAM, AFT FASTENERS AND FWD TOP FASTENERS.SDR USAA920081545Floorbeam · corrodedCLT-Q6 -MAJOR REPAIR- LEVEL 2 INTERGRANULAR CORROSION ON FLOORBEAM AT BS 328, BL 0 TO RBL 44. REPAIRED FLOORBEAM AT BS 328, BL 0 TO RBL 44. REPAIRED IAW B737 SRM 53-10-51. (S)SDR SWIA200820390Floorbeam · crackedC-CHECK, FS 280 CROSSBEAM CRACKED AT LBL9 AND RBL9. REPAIRED PER REO.SDR TRAX200800975Floorbeam · corrodedFS 280 FWD ANGLE (FLIGHT STATION FWD FLOOR LAND) CORRODED. REMOVED FWD ANGLE AT FS 280. ALL WORK DONE IAW CRJ 700 SRM 51-42-06. DRILLED UP FWD ANGLE IAW SRM 51-42-06. (S)SDR TRAX200800974Floorbeam · corrodedTHE 280 BEAM CORRODED AND CRACKED OUTBOARD OF LBL 9. REFER TO STEPS 2-15 ON ATTACHED M234 FOR WORK ACCOMPLISHED. INSTALLED LT DRIP TRAY IAW CRJ 700 SRM 51-42-13. (S)SDR ZZDA2008149Floorbeam · corrodedFLOOR SUPPORT HAS CORROSION AT BS 200 BL-0 RBL 37. REMOVED AND REPLACED FLOOR SUPPORT AT BS 200 - BL-0 TO RBL 37 IAW B717 SRM 51-41-02.SDR ZZDA2008146Floorbeam · corrodedFLOOR SUPPORT HAS CORROSION AT BS 200 LBL 22 OUT OF LIMITS. REMOVED AND REPLACED SUPPORT AT BS 200 LBL 22 IAW SRM 51-41-01.SDR ZZDA2008145Floorbeam · corrodedFLOOR SUPPORT HAS CORROSION AT BS 200 & LBL 24 - 60 OUT OF LIMITS. REMOVED AND REPLACED FLOOR SUPPORT AT BS 200 & LBL 24 - 60 IAW B717 SRM 51-41-05.SDR ZZDA2008141Floorbeam · corrodedFLOOR SUPPORT HAS CORROSION AT STA 200 RBL 48-57 - OUT OF LIMITS. REPLACED FLOOR SUPPORT RBL 48 TO RBL 57 AT STA BS 200 PER B717 SRM 51-10-04.SDR 08FDEA03294Floorbeam · corrodedAT BS 1630, 63LBL, FLOOR SUPPORT ANGLE HAS CORROSION. CORROSION FOUND EXCEED SRM LIMITS. REPAIR CARRIED OUT IAW B757-200 SRM 51-70-12 REV 93. REPAIR IS CLASSIFIED AS MINOR PER GMM 6-2-100 CRITERIA.SDR SWAA084381Floorbeam · crackedDURING SCHEDULED SPV CHECK, FOUND FLOORBEAM WEB CRACKED AT BS 178, LBL 27, WL 208. REPAIRED WEB PER SRM.SDR 2010FA0000357Floorbeam · damaged(KADY) AN ELONGATED FASTENER HOLE WAS FOUND ON THE UPPER DECK FLOORBEAM UPPER CHORD AT STA 380, LBL 22/12.SDR SWIA200820377Floorbeam · crackedC-CHECK, COCKPIT FLOOR SUPPORT CRACKED AT FS 280. REPLACED PER SRM.SDR SWIA200820138Floorbeam · crackedFS 280 CROSSBEAM CRACKED AT LBL 9 AND RBL 9 (C-CHECK). REPAIRED PER REO.
SDR 08FDEA03261Floorbeam · corrodedFOUND CORROSION ON UPPER FLANGE AT C 27 RT OUT OF LIMIT. TOP CAP BEAM REPAIR PERFORMED IAW SRM 53-10-15 FIG 207.SDR SWAA084369Floorbeam · corrodedDURING SCHEDULED BRDG CHECK, FOUND FLOORBEAM CORRODED AT BS 312, LBL 3 TO LBL 7. REPAIRED FLOORBEAM PER SRM AND BOEING DRAWING.SDR CALA0800767Floorbeam · crackedLEFT FLOOR SUPPORT CRACKED STATION 540 AT BL-0. REMOVED AND INSTALLED NEW CHANNEL PER SRM 51-40-02, PARAGRAPH 7, ECRA 5321-01560.SDR CALA0800766Floorbeam · crackedRIGHT FLOOR SUPPORT CRACKED STATION 540 AT BL-0. REMOVED AND REPLACED FLOOR SUPPORT REF EC/RA 5321-01560.SDR SWAA084357Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED AT BS 772, LBL 8. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA084356Angle · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM ZEE ANGLE CORRODED AT BS 294 TO BS 338, RBL 56. REPAIRED ANGLE PER SRM.
Back to JASC 5315