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 0400705515Floorbeam · crackedDURING H-CHECK FOUND CRACK IN FLOORBEAM AT BS 700 LBL 24. REPAIRED PER EA 55-198768.SDR AUS20040347Floorbeam · corroded(AUS) CABIN FLOOR PANEL SUPPORT BEAMS (2OFF) CORRODED. SUSPECT CAUSED BY INCORRECT REMOVAL OF FLOOR PANEL AND GAP SEALANT USING A SHARP EDGED TOOL WHICH SCORED THE BEAMS. CORROSION INITIATED AT THE SCORE MARKS. PERSONNEL/MAINTENANCE ERROR.SDR C2XA04TY079Floorbeam · corrodedTYS-DURING A SCHEDULED INSPECTION CORROSION WAS FOUND ON THE RIGHT HAND OMEGA BEAM TOP CAP. MAINTENANCE REMOVED AND REPLACED THE TOP CAP IAW EMB SRM 51-30-01, 51-20-03, 51-60-02, CPM 51-21-04, 51-21-06, 51-21-06. THE AIRCRAFT WILL BE RELEASED UPON COMPLETIONSDR TIP2004F00000Floorbeam · corrodedCABIN FLOORBEAM STA 1480, RBL 42, CORRODED. CORROSION OUT OF LIMITS IAW B767 SRM REPAIR REQUIRED. FLOORBEAM IS NEAR GALLEY AREA WHERE SPILLS OCCUR. NEED TO MAKE SURE OF PROPER CIC APPLICATION. AIRCRAFT WAS IN STORAGE FOR APPROX 2 YEARS.SDR ASAA0410254Floorbeam · gougedPAE - DURING C-CHECK, FOUND UPPER CHORD DAMAGE ON FLOORBEAM WEB. REMOVED DAMAGE AND INSTALLED RPR PARTS IAW SRM 51-40-2. (M)SDR SWIA200413298Floorbeam · crackedFS 280 LT FLOORBEAM LBL 9.0 ATTACH ANGLE CRACKED. DISCOVERED DURING C-CHECK INSPECTION. ANGLE REPLACED IAW CRJ SRM 51-40-11, 51-42-06, 51-42-13, 51-23-00, 51-21-11SDR C2XA04TY077Floorbeam · corrodedTYS DURING A SCHEDULED INSPECTION CORROSION WAS FOUND ON THE MOUNTING SURFACE FOR PASSENGER SEAT TRACK NR LF1. MAINTENANCE REMOVED AND REPLACED THE LEFT HAND OMEGA BEAM TOP CAP IAW EMB SRM 51-40-02, CPM 51-14-00. THE AIRCRAFT WILL BE RELEASED UPON COMPLETIOSDR C2XA04TY076Floorbeam · corrodedTYS-DURING A SCHEDULED INSPECTION CORROSION WAS FOUND ON THE LEFT HAND OMEGA BEAM TOP CAP AT FRAME 16. MAINTENANCE REMOVED AND REPLACED THE OMEGA BEAM TOP CAP IAW EMB SRM 51-40-02. THE AIRCRAFT WILL BE RELEASED UPON COMPLETION OF INSPECTION.SDR CALA0400468Floorbeam · corrodedINSPECTION FOUND FORWARD GALLEY FLOORBEAM CORRODED AT STA 344. THE FLOORBEAM WAS REPAIRED IAW SRM 51-70-12.SDR CALA0400467Floorbeam · corrodedINSPECTION FOUND FORWARD GALLEY FLOORBEAM CORRODED AT STA 328. THE CORRODED SECTION OF FLOORBEAM WAS CUT OUT AND A REPAIR WAS INSTALLED IAW SRM 51-70-12.SDR GTIA040479Floorbeam · corrodedFLOORBEAM AT STA 1309 FROM RBL 22 TO LBL 22 CORROSION. REMOVED FLOORBEAM. FABED FLOORBEAM. INSTALLED FLOOR SUPPORT.SDR 0400726718Floorbeam · crackedDURING H-CHECK FOUND CRACK IN UPPER DECK FLOORBEAM CHORD AT BS 520. REPAIRED PER EA 67-165122.SDR 0400716718Floorbeam · crackedDURING H-CHECK FOUND CRACK IN UPPER DECK FLOORBEAM CHORD AT BS 420 BETWEEN LBL 8 AND RBL 58. REPAIRED PER EA 67-165119.SDR ASAA0410247Floorbeam · corrodedDURING C-CHECK, FOUND AFT CARGO BAY MAIN FLOORBEAM IS CORRODED. INSTALLED PERMANENT REPAIR IAW SRM 51-30-2. (M)SDR ASAA0410253Floorbeam · corrodedDURING C-CHECK, FOUND FLOORBEAM LOWER SURFACE OF BOTTOM FLANGE AT STATION 420 IS CORRODED. REMOVED DAMAGED RPR STRAPS AND INSTALLED REPLACEMENT RPR STRAP IAW EA 5310-02346. (M)SDR USAA040182Floorbeam · corrodedPIT - FOUND FLOORBEAM CORRODED, STATION 986.5. CORROSION LEVEL 1, TASK NR C53-107-01. REPLACED INTERCOSTAL STRUCTURE BETWEEN STATION 986.5 AND 100.6 PER SRM 52-10-02. (M)SDR SWIA200413291Floorbeam · crackedFS 625 RT OBLIQUE ANGLE P/N 601-35012-52 CRACKED IN RADIUS. (FOUND DURING C-CHECK INSPECTION). REMOVED AND REPLACED WITH NEW ANGLES IAW CRJ 200 SRM 51-21-11, 51-21-16, 51-23-00, AND 52-42-06. SEE RII53-401.SDR SWIA200413284Floorbeam · crackedFS 280 LT FLOORBEAM LBL 9.0 I/B AND O/B ATTACH ANGLE CRACKED. (FOUND DURING C-CHECK INSPECTION). REPLACED ANGLE IAW CRJ SRM 51-40-11, 51-42-06, 51-42-21, 51-21-11, 51-23-00, AND RII 53-401.SDR SWIA200413283Floorbeam · crackedFS 280 RT FLOORBEAM RBL 9.0 IB AND OB ATTACH ANGLES CRACKED. (FOUND DURING C-CHECK INSPECTION). REPLACED ANGLES IAW CRJ SRM 51-40-11, 51-42-06, 51-42-13, 51-23-00, 51-21-11, AND 51-42-21. REF. RII 53-401.SDR CALA0400460Floorbeam · corrodedINSPECTION FOUND FORWARD GALLEY FLOORBEAM CORRODED AT STA 344. REPAIRED IAW SRM 51-70-12.SDR CALA0400459Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 1640 BETWEEN LBL 9 AND RBL 14, WL 208. THE FLOORBEAM WAS REPAIRED IAW SRM 53-00-51, FIGURE 203.SDR C2XA04SH260Floorbeam · corrodedSHV-DURING C CHECK THE LEFT OMEGA BEAM WAS FOUND TO BE CORRODED AT FRAME 19. MAINTENANCE REMOVED THE DAMAGED AREA AND PERFORMED A DOUBLER REPAIR IAW EMB 135 SRM 53-21-10. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR 2004UALA00425Floorbeam · crackedBS 246 FLOORBEAM FWD SIDE PULLEY BRACKET SUPPORT ANGLE AT RBL 16 INCHES IS CRACKED. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED ANGLE REPAIR.SDR 2004UALA00423Floorbeam · crackedBS 246 FLOORBEAM FWD SIDE PULLEY BRACKET SUPPORT ANGLE AT RBL 12 INCHES, T-ANGLE CRACKED. MAJOR REPAIR ACCOMPLISHED. REPLACED PULLEY SUPPORT ANGLE.SDR ASAA0410244Floorbeam · corrodedPAE - DURING C-CHECK, FOUND CORROSION ON FLOORBEAM. REPAIRED FLOOR BEAM IAW SRM 53-10-1. (M)SDR ASAA0410235Floorbeam · corrodedOKC - DURING C-CHECK, FOUND LONGITUDINAL FLOORBEAM AT STATION 540-727B, RBL 45 INBOARD FLANGE SURFACES CORRODED. REMOVED DAMAGED AND INSTALLED RPR STRAPS IAW EA5310-02356. (M)SDR ASAA0410228Floorbeam · corrodedDURING C-CHECK, FOUND FLOORBEAM AT STATION 1016, RBL 5-40 IS CORRODED. REMOVED DAMAGE AND INSTALLED REPLACEMENT UPPER CHORD IAW EA5310-02354. (M)SDR ASAA0410224Floorbeam · corrodedDURING C-CHECK, FOUND FLOORBEAM RPR AT STATION 520 UPPER CHORD IS CORRODED. REMOVED DAMAGE AND INSTALLED REPLACEMENT PRP CHORD SECTION IAW EA5310-02358. (M)SDR ASAA0410225Floorbeam · corrodedDURING C-CHECK, FOUND AFT CARGO COMPARTMENT FLOORBEAM AT STATION 787 IS CORRODED AROUND FASTENER HOLES. REMOVED DAMAGE AND INSTALLED RPR STRAP, ANGLES AND STIFFENERS IAW EA5310-02360. (M)SDR ASAA0410226Floorbeam · corrodedDURING C-CHECK, FOUND FLOORBEAM FLANGE AT STATION 1006, RBL 45 IS CORRODED. REMOVED DAMAGE AND INSTALLED UPPER T-CHORD IAW EA5310-02347. (M)SDR ASAA0410227Floorbeam · corrodedDURING C-CHECK, FOUND FLOORBEAM AT STATION 986, LBL 15 IS CORRODED. REMOVED DAMAGE AND INSTALLED RPR ANGLE AND STRAP IAW SRM 53-10-9. (M)SDR ASAA0410230Floorbeam · corrodedOKC - DURING C-CHECK, FOUND FLOORBEAM AT STATION 500A, LOWER FLANGE, LOWER SURFACE IS CORRODED. REMOVED DAMAGED RPR STRAP AND INSTALLED RPR STRAP IAW EA5310-02349. (M)SDR ASAA0410231Floorbeam · corrodedOKC - DURING C-CHECK, FOUND FLOORBEAM AT STATION 807, RBL 44-RBL 60 IS CORRODED. REMOVED DAMAGE AND INSTALLED RPR STRAPS IAW EA5310-02353. (M)SDR ASAA0410232Floorbeam · corrodedDURING C-CHECK, FOUND AFT AIRSTAIR COLUMN OUTBOARD FLOOR MOUNT HOLES CORRODED. REMOVED DAMAGE, REAMED HOLES AND INSTALLED REPLACEMENT BUSHINGS IAW EA5260-01142. (M)SDR ASAA0410229Floorbeam · damagedDURING C-CHECK, FOUND HOLE IN LONGITUDINAL FLOORBEAM, OUTBOARD FLANGE AT STATION 609, RLB 46. REMOVED DAMAGE AND INSTALLED RPR AND STUD BEAM IAW EA5310-02348. (M)SDR ASAA0410233Floorbeam · corrodedDURING C-CHECK, FOUND STATION 807 BEAM CAP AT RBL 24.75 TO LBL 24.75. REMOVED DAMAGE AND INSTALLED RPR STRAPS IAW EA5310-02353. (M)SDR ASAA0410234Floorbeam · corrodedDURING C-CHECK, FOUND FLOORBEAM AT STATION 480 UPPER FLANGE SURFACES CORRODED. REMOVED DAMAGED AND INSTALLED RPR STRAPS IAW EA5310-02356. (M)SDR ASAA0410237Floorbeam · corrodedFOUND C-CHECK, FOUND FLOORBEAM AT STATION 727B, RBL 25-45 IS CORRODED AT NUTPLATES. REMOVED DAMAGE AND INSTALLED RPR ANGLES IAW EA5310-02357. (M)SDR ASAA0410238Floorbeam · corrodedFOUND C-CHECK, FOUND FLOORBEAM AT STATION 807, LBL 24-44 IS CORRODED AT AFT END UPPER T-CAP. REMOVED DAMAGE AND INSTALLED RPR STRAPS IAW EA5310-02353. (M)SDR 2004UALA00421Floorbeam · crackedBS 246 FLOORBEAM WEB CRACKED AT UPPER SECTION RBL 13 WL 200. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. INSTALLED (T) ANGLE DOUBLER.SDR MALA040396Floorbeam · crackedDURING 4K INSPECTION IN LCQ, FS 363.0 FLOORBEAM CRACKED. CUT OUT DAMAGED AREA OF FLOORBEAM, FABRICATED AND INSTALLED ANGLE AND FILLER REPAIR IAW EO NR S53108. REFER TO LG PG. NR 1270902 FOR ADDITIONAL INFORMATION. A/C RETURNED TO SERVICE 5/12/04.SDR C2XA04SH255Doubler · corrodedSHV-DURING C CHECK THE DOUBLER ON THE RIGHT OMEGA BEAM AT FRAME 18 WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED THE AFFECTED DOUBLER IAW EMB 135 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR TIP2004F00004Floorbeam · corrodedCABIN FLOORBEAM AT STA 303, RBL 54 THRU RBL 82. CORROSION OUT OF LIMITS. REPAIR REQUIRED. SRM 53-00-51. FLOORBEAM IS IN WET/GALLEY AREA, SPILLS IN AREA CORRODED BEAM. GALLEY NEED TO BE PROPERLY SEALED AND VAPOR BARRIER INSTALLED. TASK CARD NR S53-027-02.SDR TIP2004F00003Floorbeam · corrodedCABIN FLOORBEAM AT STA 287, RBL 20 THUR 82. CORROSION OUT OF LIMITS IAW B767 SRM REPAIR REQUIRED. FLOORBEAM UNDER WET AREA, SPILLS AND LEAKS CORRODED FLOORBEAM. GALLEY AREAS NEED MILAR VAPOR BARRIER INSTALLED AND SEALED AREA PROPERLY. AIRCRAFT WAS IN STORASDR TIP2004F00002Floorbeam · corrodedCABIN FLOORBEAM AT STA 325 RBL 24 THRU 54, CORROSION OUT OF LIMITS. B767 SRM, REPAIR REQUIRED. FLOORBEAM CORRODED BECAUSE OF GALLEY AREA LEAKS. GALLEY AREA NEEDS TO BE PROPERLY SEALED. AIRCRAFT WAS IN STORAGE FOR APPROX 2 YEARS. (TASK CARD NR S53-027-02)SDR TIP2004F00001Floorbeam · corrodedCABIN FLOORBEAM AT STA 347, LBL 20 THUR LBL28. CORROSION OUT OF LIMITS B767 SRM, REPAIR REQUIRED. FLOORBEAM HAS CORROSION FROM GALLEY AREA LEAKS, HAVE CORRODED THE BEAM.SDR USAA040161Floorbeam · corrodedPIT - FOUND BEAM CAP CORRODED 1 INCH AREA, BS 986 RBBL 10. CUT OUT CORRODED SECTION OF BEAM UPPER CAP AND SPLICED IN NEW PER TYPICAL REPAIR 53-60-01 REV A. (M)SDR SWAA041213Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND FLOORBEAM AT BS 219, LBL 16, CORRODED. REPAIRED FLOORBEAM PER SRM.SDR C2XA04SH251Floorbeam · corrodedSHV- DURING C-CHECK THE LT FLOORBEAM WAS FOUND TO BE CORRODED AT FRAME 20. MAINTENANCE REMOVED THE DAMAGED AREA AND PERFORMED A DOUBLER REPAIR IAW EMB 145 SRM 53-21-10. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR CALA0400495Floorbeam · crackedA CRACK WAS FOUND IN THE LONGITUDINAL FLOORBEAM UPPER CHORD AT ITS ATTACHMENT TO THE TRANSVERSE FLOORBEAM AT STA 727B, RBL 45. THE CRACK WAS LOCATED ON THE I/B SIDE OF THE LONGITUDINAL FLOORBEAM AT THE SECOND HI-LOK FASTENER HOLE FORWARD OF STA 727B. THE CRA
Back to JASC 5315