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 ASAA0671079Floorbeam · corrodedFLOORBEAM CORRODED ON TOP SURFACE AT BS 947 REPAIRED IAW EO 6261SDR SWAA063995Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM CORRODED AT BS 328, RBL 0 TO RBL 10. REPAIRED FLOORBEAM PER SRM.SDR USAA061232Floorbeam · corrodedBETWEEN C67 & C68 AT -Y1160 CORROSION. REPLACED FLOORBEAM PER SRM 51-72-11; CORR TASK JA-260-53500; LEVEL 1.SDR USAA061231Floorbeam · corrodedC68 AT -Y1160 CORROSION. REPLACED FLOORBEAM PER SRM 51-72-11; CORR TASK JA-260-53500; LEVEL 1, DEFECT SIZE: 1.5 X 2.5 INCHES AND 1 X 2 INCHES.SDR USAA061230Floorbeam · corrodedBETWEEN C66-C67, -Y1292 FLOORBEAM CORROSION. REMOVED AND REPLACED FLOORBEAM PER SRM 51-72-11; CORR TASK JA-260-53500; LEVEL 1, DEFECT SIZE: 1 SQ INCH.SDR USAA061229Floorbeam · corrodedC68, Y1160 FLOORBEAM CORROSION. REMOVED AND REPLACED FLOORBEAM PER SRM 51-72-11; CORR TASK JA-260-53500; LEVEL 1, DEFECT SIZE: 1 SQ INCH.SDR USAA061228Floorbeam · corrodedC66, Y1292 FLOORBEAM CORROSION. REMOVED & REPLACED FLOORBEAM PER SRM 51-72-11; CORR TASK JA-260-53500; LEVEL 1, DEFECT SIZE: 1 SQ INCH.SDR USAA061226Floorbeam · corrodedBEAM Y765 CORROSION. DEFECTIVE PART REPLACED WITH IDENT PART PER SRM 51-74-00, DEFECT SIZE: 2 X 3 INCHES.SDR USAA061225Floorbeam · corrodedFLOORBEAM Y17.32 AT C66, LEFT SIDE CORROSION. CUT OUT CORROSION & INSTALLED REPAIR ANGLES PER SRM 53-41-14; CORR TASK JA-260-53500, LEVEL, DEFECT SIZE: 0.75 X 0.75 INCH.SDR USAA061233Floorbeam · corrodedSTA C17 10 INCHES RT OF CENTER CORROSION. INSTALLED NEW FLOOR SUPPORT BEAM PER SRM 51-72-11; CORR TASK JA-220-53500, LEVEL 1, DEFECT SIZE: 2" X 2" X .075".SDR CALA0600413Floorbeam · corrodedCORRODED FLOORBEAM AT STA 986.5, LBL 27-43. REPAIRED IAW ECRA 5321-01404.SDR CALA0600411Floorbeam · corrodedCORRODED FLOORBEAM 312 RBL 35. REPAIRED IAW SRM 53-10-51, REPAIR 5, FIG 201.SDR DL76S060843Floorbeam · crackedUPPER CHORD OF THE STA 999 AT LBL 33 FLOORBEAM WAS FOUND CRACKED IN THE VERTICAL FLANGE FROM THE AFT SLOTTED CUTOUT TO THE END OF THE CHORD. THE CRACK WAS REMOVED BY EXTENDING THE SLOT CUTOUT TO THE END OF THE CHORD AND WAS REPAIRED WITH A REPAIR ANGLE APPROSDR 06FDEA03635Floorbeam · corrodedFOUND CORROSION ON FLOORBEAM UPPER TEE AND LOWER SURFACE STA 680 RBL 3-21. REPAIRED FLOOR BEAM UPPER CHORD AT STA 680 PER SRM 53-10-8.SDR CALA0600396Floorbeam · corrodedCORRODED FLOORBEAM AT STA 967, BL 5. REPAIRED IAW SRM 53-00-51.SDR SWIA200617539Floorbeam · crackedCRACKED FLOORBEAM FUSELAGE STA 621 RBL 44 WL 73, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED REPAIR PARTS PER REO 601R-53-61-117.SDR SWIA200617537Floorbeam · crackedFS 280 FLOORBEAM CRACKED LBL 9 AND 2 CLIPS CRACKED, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED REPAIR PARTS FILLER ANGLE, SPLICE ANGLE, AND (2 EA) CLIPS P/N 601R31113-57 IAW REO 601R-53-11-138.SDR UPS06448483Floorbeam · corrodedINSPECTION TYPE:C AFT CARGO COMPT RT STA1500 IN BETWEEN RBL45 AND RBL58 FLOORBEAM UPPER CHORD FOUND CORROSION. CORROSION BLEND OUT 0.033" BY 1" BY 8". AFT CARGO COMPT BS 1500 RBL 20 TO RT MOST O/B FLOORBEAM UPPER CHORD REPAIRED AS PER SRM 51-40-04 FIG 2.SDR SWAA063963Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM CRACKED AT BS 987, RBL 19. REPAIRED FLOORBEAM PER SRM.SDR SWAA063962Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM CRACKED AT BS 1016, LBL 9. REPAIRED FLOORBEAM PER SRM.SDR SWAA063961Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM CRACKED AT BS 328, LBL 28. REPAIRED FLOORBEAM PER SRM.SDR SWIA200617530Floorbeam · crackedFOUND FS 280 INBD AND OTBD FRAME CLIPS CRACKED AT LBL 9, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED INBD AND OTBD FRAME CLIPS AT FS 280 LBL9 P/N 601R31113-57 PO 70800 P/N 60R31113-58 PER REO 601R 53-11-138.SDR 06FDEA03620Floorbeam · corrodedMAIN CARGO COMPARTMENT FLOORBEAM UPPER TEE CORRODED TOP SIDE BS 620 LBL 10. REMOVED DAMAGED UPPER TEE IAW B 727 SRM 53-10-8 FIG. 3. FABRICATED AND INSTALLED REPAIR PARTS IAW B 727 SRM 53-10-8 FIG. 3.SDR 06FDEA03619Floorbeam · corrodedMAIN CARGO COMPARTMENT FLOORBEAM UPPER TEE CORRODED BODY STATION 680 BUTT LINE 0 RBL 55. REMOVED CORRODED FLOORBEAM TEE STA 680 IAW B727 SRM 53-10-8.SDR SWAA063914Floorbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM UPPER CHORD CORRODED AT BS 270, LBL 11 TO RBL 11. REPAIRED FLOORBEAM CHORD PER SRM.SDR SWAA063913Floorbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM UPPER CHORD CORRODED AT BS 259, LBL 8 TO RBL 8. REPAIRED FLOORBEAM CHORD PER ER.SDR CALA060388Floorbeam · corrodedCORRODED FLOORBEAM BS 325 LBL 30 TO 56. REPAIRED BEAM IAW SRM 53-00-51, FIG 201.SDR DU4R2006651Floorbeam · corrodedS/O 291025, NR 25013 CORROSION ON UPPER T-CAP OF FLOORBEAM IN PASSENGER CABIN AT BS 720 B/L 3R. CUT OUT CORRODED AREA. FABRICATED AND INSTALLED ANGLE REPAIR 11INCHES X 1 INCH X 2 INCH FROM BAC1490-2865 AND ANGLE DOUBLER 14 INCHES X 2 INCHES X 1INCH FROM BAC SDR CALA0600392Floorbeam · corrodedCORRODED FLOORBEAM AT STA 986.5 RBL 22.5 TO 29. REPAIRED IAW SRM 53-00-51.SDR CALA0600391Floorbeam · corrodedCORRODED FLOORBEAM AT STA 986.5 LBL 26.5 - LBL 34.5. REPAIRED IAW SRM 53-00-51.SDR CALA0600390Floorbeam · corrodedCORRODED FLOORBEAM AT STA 344 AROUND SEVERAL SCREW HOLES FROM LBL 21 - BL 0. REPAIRED IAW ECRA 5321-01330.SDR PIDR2006024Floorbeam · damagedVERTICAL WEB OF BS 520 FLOORBEAM DAMAGED AT RBL 36. REPAIRED DAMAGED AREA IAW EA 53-273.SDR SWAA063891Floorbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM CORRODED AT BS 987, LBL 12 TO RBL 40. REPAIRED FLOORBEAM PER ER.SDR SWIA200617525Floorbeam · crackedFS 280 FLOORBEAM CLIPS 2EA LBL CRACKED, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED REPLACEMENT CLIPS PER CRJ200 DWG 601R3113 AND SRM 51-40-06/51-24-16 PG 1-7.SDR SWIA200617524Floorbeam · crackedFS 280 FLOORBEAM CLIPS 2EA RBL 9 CRACKED, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED NEW PARTS IAW CRJ 200 SRM 51-42-06 PG 18 AT FS 280 FLOORBEAM RBL INBD AND OTBD.SDR SWIA200617523Floorbeam · crackedFS 280 FLOORBOARD SUPPORT IS CRACKED AT LBL 9.0, ON UPPER FLANGE, DISCOVERED DURING C-CHECK INSPECTION. REPAIR PARTS INSTALLED IAW REO 601R-53-11-138 REV-NC.SDR SIMA200631709Floorbeam · corrodedDISC - FOUND RIGHT UPPER FLOORBEAM AT FRAME 22 CORRODED INSTALLED NEW FLOORBEAM IAW EMB SRM 51-40-02. AIRCRAFT RETURNED TO SERVICE.SDR SWAA063882Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 744A, RBL 45. REPAIRED FLOORBEAM PER ER.SDR SWAA063881Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 744A, RBL 25. REPAIRED FLOORBEAM PER ER.SDR ASAA0671057Floorbeam · corrodedAFT CABIN FLOORBEAM IS CORRODED AT BS 994 WL 208 LBL 38-48 REPAIRED IAW SRM 51 40 02.SDR ASAA0671054Floorbeam · corrodedAFT CABIN FLOORBEAM CORRODED AT BS 1016 RBL 32 WL 208. REPAIRED IAW SRM 51 40 2.SDR TRAX200600827Floorbeam · corrodedFOUND CORROSION ON FWD AND AFT SUPPORT ANGLES AT FS 280 BETWEEN LBL9 AND RBL9 FLOOR WEB. REPAIRED IAW REO 601R-53-11-926 (SUPPLEMENTAL-SDR CLOSED)SDR SWAA063833Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM CRACKED AT BS 663, BL 0. REMOVED AND REPLACED FLOORBEAM SECTION PER SRM.SDR SWIA200617517Floorbeam · crackedFS 280 LOWER FLANGE OF FLOORBEAM CRACKED AT LBL9 AND RBL9, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED REPAIR PARTS P/N 601R-53-11-171-1 IAW REO 601R-53-11-171 BETWEEN LBL15 - RBL15, FS 280 LOWER FLANGE.SDR SWIA200617516Floorbeam · crackedCRACK AT FS 280 FLOORBEAM APPROXIMATELY LBL11.0 BELOW FLOORBOARD 231BLF, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED REPAIR PARTS.SDR SWIA200617515Floorbeam · crackedCRACK AT FS 280 FLOORBEAM APPROXIMATELY LBL 11.0 BELOW FLOORBOARD 231BLF, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED REPAIR PARTS IAW REO 601R-53-11-136.SDR AWXA200601817Floorbeam · crackedMCN - MAJOR REPAIR - C-19 CHECK - FOUND CLIP CRACKED, OUTBOARD SIDE OF FLOORBEAM, BS 683.25, LBL 0.07, WL 208.1. REPLACED CLIP, OUTBOARD SIDE OF FLOORBEAM, BS 683.25, LBL 0.07, WL 208.1 IAW AWA ER 03-5360-06296-SS2.SDR USAA061210Floorbeam · corrodedFOUND FLOORBEAM CORRODED, 10" LEFT OF CENTER, BETWEEN FS 12 AND 16. FLOORBEAM REMOVED AND INSTALLED PER SRM 51-72-11; CORROSION LEVEL 1; TASK JA-220-53500, DEFECT SIZE: 1" BY 18" BY .075".SDR USAA061211Floorbeam · corrodedFOUND FLOORBEAM CORRODED Y254 TOP FACE ABOVE C21. CUT OUT DAMAGE, INSTALLED REPAIR ANGLE AND FILLER PER SRM 53-00-14; CORROSION TASK JA-220-53500; LEVEL 1, DEFECT SIZE: 1/2" BY 1-3/4".SDR QXEA200603430Floorbeam · corrodedPDX C3 - AFT BAG COMPARTMENT FLOOR SUPPORT ANGLE FORWARD OF X783.10 CORROSION APPROXIMATELY YL13 TO YL23. REPAIRED IAW DHC-8-400 SRM 51-14-00-350-803, 51-21-10 AND SRM 51-20-00.
Back to JASC 5315