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 SWAA043114Web · crackedDURING SCHEDULED D-CHECK, FOUND 2 EACH CRACKS ON FLOOR WEB BETWEEN BS 188 AND BS 196, AT STRINGER 17L AND STRINGER 17R. REMOVED AND REPLACED FLOOR WEB SECTIONS PER SRM.SDR USAA040889Floorbeam · mismanufacturedPIT-Q5- FLOORBEAM, INCORRECT MATERIAL FROM MFG. FLOORBEAM UPPER CHORD REMOVED AND REPLACED IAW EA 68822A, FLOOR STA 328.SDR SWAA043098Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM UPPER CHORD AT BS 663, BL 0, CRACKED. REPAIRED FLOORBEAM CHORD PER EA.SDR SWAA043090Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM WEB AT BS 947.5, LBL 37 CRACKED. REMOVED AND REPLACED FLOORBEAM WEB SECTION PER ER.SDR CALA0400687Floorbeam · corrodedINSPECTION FOUND UPPER FLANGE OF FLOORBEAM CORRODED AT STA 328, LBL 6 TO RBL 6. THE CORRODED SECTION OF FLOORBEAM WAS REMOVED AND REPLACED IAW SRM 53-10-51.SDR AWXA200401295Floorbeam · corrodedSAL - MAJOR REPAIR - DURING C-04 CHECK INTERGRANULAR CORROSION WAS FOUND ON FLOORBEAM -Y48 RT AT FR 67+11 INCHES. MAINTENANCE REMOVED CORRODED FLOORBEAM -Y48 RT AT FR 67+11 INCHES; FABRICATED A NEW REPLACEMENT FLOORBEAM; INSTALLED REPAIR PART IAW A320 SRM 51-SDR AWXA200401294Floorbeam · corrodedSAL - MAJOR REPAIR - DURING C-04 CHECK EXFOLIATION CORROSION WAS FOUND ON FLOORBEAM -Y48 RT AT FR 68. MAINTENANCE REMOVED CORRODED FLOORBEAM -Y48 RT AT FR 68; FABRICATED A NEW REPLACEMENT FLOORBEAM; INSTALLED REPAIR PART IAW A320 SRM 51-72-11.SDR AWXA200401293Floorbeam · corrodedSAL - MAJOR REPAIR - DURING C-04 CHECK CORROSION WAS FOUND ON FLOORBEAM Y20 LT AT FR 66+6 INCHES. MAINTENANCE REMOVED CORRODED FLOORBEAM Y20 LT AT FR 66+6 INCHES; FABRICATED A NEW REPLACEMENT FLOORBEAM; INSTALLED REPAIR PART IAW A320 SRM 53-00-14 FIG 207.SDR SWIA200414041Floorbeam · crackedCARGO COMPARTMENT FLOOR SUPPORT ANGLE IS CRACKED; FS 621.00 RBL 40. ITEM FOUND AT C-CHECK INSPECTION. REPAIRED IAW CRJ REO 601R-53-61-117 REV B.SDR SWIA200414040Floorbeam · crackedCARGO COMPARTMENT FLOOR SUPPORT ANGLE IS CRACKED; FS 621.00 LBL 40. ITEM FOUND AT C-CHECK INSPECTION. REPAIRED FLOOR SUPPORT ANGLE AT F.S 621.00, LBL -40, IAW CRJ REO 601R-53-61-117, REV "B".SDR CALA0400686Floorbeam · corrodedINSPECTION FOUND UPPER FLANGE OF FLOORBEAM CORRODED AT STA 344, RBL 45 TO LBL 12. THE CORRODED AREA OF FLOORBEAM UPPER CHORD WAS REMOVED AND A NEW UPPER CHORD AND SPLICES WERE INSTALLED IAW SRM 53-10-51.SDR CALA0400684Floorbeam · corrodedINSPECTION FOUND THE UPPER FLANGE OF FLOORBEAM CORRODED AT NUT PLATE HOLE, STA 312, RBL 8. A FLOORBEAM REPAIR WAS INSTALLED IAW SRM 53-10-51.SDR ASA0440188Floorbeam · corrodedPAE - CORROSION ON FLOORBEAM. REPLACED EXISTING REPAIR STRAP.SDR 2004UALA00976Floorbeam · corrodedMAIN CABIN, STA 324, RBL 24-RBL 63, UPPER SURFACE OF FLOORBEAM CORRODED. INSTALLED REPAIR STRAP.SDR SWAA043065Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM WEB FROM RIGHT BS 188 TO BS 196, CRACKED. REPAIRED FLOORBEAM WEB SECTION PER SRM.SDR SWAA043060Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM AT BS 907 + 8, RBL 3, CORRODED. REPAIRED FLOORBEAM PER EA.SDR USAA040762Floorbeam · corrodedCLT, C-4, FLOORBEAM, 2 INCHES BY 1 INCH, LEVEL 1 CORROSION, STA 324, RBL58, TO RBL60. ACCOMPLISHED TEE CAP REPAIR IAW EA 95913.SDR USAA040761Floorbeam · corrodedCLT, C-4, FLOORBEAM, .5 INCH AREAS SEVERAL SPOTS, LEVEL 1 CORROSION, STA 377.7 FROM LBL62 TO RBL12. ACCOMPLISHED (T) CAP REPAIR IAW TR 53-15-01 AND EA 95899.SDR EIA2004137Floorbeam · corrodedBS 540, UPPER DECK FLOORBEAM, UPPER FORWARD SIDE OF CHORD LBL3 THRU LBL6 HAS EXFOLIATING CORROSION. REMOVED, FABRICATED, AND INSTALLED REPLACEMENT CHORD PER B747 SRM 53-30-03, FIGURE 1, ALONG WITH MM 51-30-05 AND 51-20-02.SDR QXEA200400731Floorbeam · corrodedPDX - CORROSION ON FLOORBEAM AT STATION FS 280.0 ON TOP FLANGE FROM LEFT HAND BL 30.0 TO RIGHT HAND BL 40.0. REPAIRED IAW HORIZON AIR EA R-53-212.SDR UPS04443426Floorbeam · crackedINSPECTION TYPE: SPV, SEAT TRACK SUPPORTS HAVE ELONGATED MOUNTS HOLES AT STA 1920, 1940, LBL 98.58. REMOVED 2EA DAMAGED SUPPORT ANGLES. FABBED ANGLE 69B04527 PER DWG STA 1920 ATTACH ANGLE CRACKED. FABBED AND INSTALLED REPAIR PER SRM 51-40-03. NDT VERIFIED SDR QXEA200400730Floorbeam · crackedPDX - FLOORBEAM 280 CRACKED. REPAIRED IAW CRJ 51-42-06 AND REO 670-53-11-045.SDR UPS04443425Floorbeam · damagedINSPECTION TYPE: SPV, FLOORBEAM 65B38095 STA 1900, LBL 98.58, SEAT TRACK ATTACH HOLES FOUND OVERSIZED FWD HOLE 0.350, AFT HOLE 0.390. REMOVED AFT ATTACH ANGLE, REAMED BEAM HOLES FWD 0.389, AFT 0.432 PER EO. FAB & INSTALLED 2EA FREEZE PLUGS PER SKETCH & SRM SDR UPS04443424Floorbeam · damagedINSPECTION TYPE: SPV, FLOORBEAM 65B38096 STA 1920 LBL 98.58, SEAT TRACK ATTACH HOLES FOUND OVERSIZED, FWD & AFT HOLES 0.380. REAMED BEAM HOLES TO; FWD 0.389, AFT 0.432 PER EO. FAB & INSTALLED FREEZE PLUGS PER SKETCH & SRM 51-10-08. FAB FWD FITTING 69B04238 SDR UPS04443423Floorbeam · damagedINSPECTION TYPE: SPV, FLOORBEAM 65B38093, STA 1860 LBL 98.58, SEAT TRACK ATTACH HOLES FOUND OVERSIZED. FWD HOLE 0.350, AFT HOLE 0.410. REMOVED AFT TRACK ATTACH ANGLE. REAMED BEAM HOLES TO 0.389 & 0.432 PER EO. FAB & INSTALLED FREEZE PLUGS PER SKETCH AND SRSDR UPS04443422Floorbeam · damagedINSPECTION TYPE: SPV, FLOORBEAM 65B38094 STA 1880, LBL 98.58 SEAT TRACK ATTACH HOLES FOUND OVERSIZED, FWD HOLE 0.340, AFT HOLE 0.380. REMOVED AFT ATTACH ANGLE, REAMED HOLES IN BEAM TO 0.389 PER EO. FAB & INSTALLED FREEZE PLUGS PER SKETCH. REAMED OVERSIZED TSDR UPS04443421Floorbeam · damagedINSPECTION TYPE: SPV, FLOORBEAM 65B38092, STA 1840 LBL 98.58, SEAT TRACK ATTACH HOLES FOUND OVERSIZED, FWD HOLE 0.330 IN, AFT HOLE 0.390 IN. REAMED HOLES TO 0.389 AND 0.432. FABRICATED AND INSTALLED FREEZE PLUGS PER EO. REPLACED 65B38120-1 FITTING DUE TO OSDR SWAA043023Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND 2 EACH CRACKS ON FLOORBEAMS AT BS 986.5, LBL 52 TO RBL 52, BS 947, RBL 53. REPAIRED FLOORBEAM SECTIONS PER SRM.SDR USAA040765Floorbeam · corrodedFLOORBEAM, .5 INCH AREA, CORROSION LEVEL 2, STA 345, RBL 62. ACCOMPLISHED (T) CAP REPAIR IAW EA95913.SDR AWXA200401216Floorbeam · corrodedDURING C-04 CHECK, EXFOLIATION CORROSION WAS FOUND ON BEAM Y1292 LT BETWEEN FS 68 AND FS 69. MAINTENANCE REMOVED CORRODED SECTION BEAM Y1292 LT FROM FS 68 TO FS 69; FABRICATED A NEW REPLACEMENT SECTION OF BEAM; INSTALLED REPAIR PART IAW A320 SRM 51-72-11.SDR AWXA200401204Floorbeam · corrodedDURING C-04 CHECK, EXFOLIATION CORROSION WAS FOUND ON BEAM Y1292 RT BETWEEN FS 16 AND FS 20. MAINTENANCE REMOVED CORRODED SECTION OF BEAM Y1292 RT FROM FS 16 TO FS 20; FABRICATED A NEW REPLACEMENT BEAM; INSTALLED REPAIR PART IAW A320 SRM 53-11-14, FIG 102.SDR AWXA200401201Floorbeam · corrodedDURING C-04 CHECK EXFOLIATION CORROSION WAS FOUND ON BEAM Y1292 LT AT FR 66. MAINTENANCE REMOVED CORRODED SECTION OF BEAM Y1292 LT FROM FR 64 TO FR 66; FABRICATED A NEW REPLACEMENT BEAM; INSTALLED REPAIR PART IAW SRM 51-72-11.SDR AWXA200401193Floorbeam · corrodedDURING C-04 CHECK GALVANIC CORROSION WAS FOUND ON BEAM Y1292 RT BETWEEN FR 68 AND FR 69. MAINTENANCE REMOVED CORRODED BEAM Y1292 RT FROM FR 68 TO FR 69; FABRICATED A NEW REPLACEMENT BEAM; INSTALLED REPAIR PART IAW SRM 51-42-11, FIG. 9-12.SDR USAA040877Floorbeam · crackedPIT - Q4, BEAM, ABOUT .5 INCH, CRACKED, FLOOR SUPPORT BEAM, STA 540 AND LT OB SEAT TRACK. DEFECTIVE PART REPLACED WITH IDENT PART IAW DWG 65-46819-4.SDR SWIA200414109Floorbeam · crackedSTA 621 LOWER RIGHT HAND CORNER AT WL 79.5 HAS CRACK AT RADIUS. ITEM FOUND AT C-CHECK INSPECTION. REPAIR ANGLES AND RADIUS STRAP, INSTALLED AS PER REO 601R-53-61-117 AND EO 601R-53-5514.SDR SWIA200414108Floorbeam · crackedSTA 621 LOWER LEFT HAND CORNER AT WL 79.5 HAS A CRACK AT THE RADIUS. ITEM FOUND AT C-CHECK INSPECTION. REPAIRED FLOORBEAM ANGLE FS 621 LT IAW REO 601R-53-61-117.SDR SWIA200414107Floorbeam · crackedLEFT FS 280 ANGLE CRACKED. ITEM FOUND AT C-CHECK INSPECTION. INSTALLED REPAIR PER CRJ 200 SRM 51-42-06, 51-42-06.SDR AWXA200401312Floorbeam · corrodedLCQ - MAJOR REPAIR - DURING C-09 CHECK EXFOLIATION CORROSION WAS FOUND ON CABIN FLOORBEAM AT BS 1680 FROM LBL 54 TO RBL 54. MAINTENANCE REMOVED CORRODED FLOORBEAM UPPER CHORD AT BS 1681 FROM LBL 54 TO RBL 54; FABRICATED A NEW REPLACEMENT UPPER CHORD; INSTALLESDR EIA2004132Strap · corrodedUPPER DECK FLOORBEAM STRAP HAS EXFOLIATION CORROSION, STA 420R, 3 INCHES IB FUSELAGE SKIN. REPLACED STRAP IAW SRM 51-30-02, PGS 8-9, 51-30-05, FIG 4, AND 51-30-02, PGS 8-9SDR 2004UALA00945Floorbeam · corrodedCABIN FLOORBEAM CAP AT BS 1640 RBL 51 TO RBL 60 IS CORRODED BEYOND ALLOWABLE LIMITS. MAJOR REPAIR ACCOMPLISHED. TYPICAL FLOOR STRUCTURE CORROSION. INSTALLED STRAP REPAIR.SDR 2004UALA00943Floorbeam · crackedFLIGHT DECK FLOORBEAM AT STA 246 FORWARD FACE STIFFENER CRACKED LOWER CORNER AT LBL 25. BOEING SERVICE BULLETIN RECOMMENDED ROUTINE INSPECTION IN PLACE TO MONITOR THIS CRACKING OF STA 246 FLOORBEAM. CRACKING OCCURS DUE TO HIGHER THAN INITIALLY ANTICIPATED LOSDR ASOA04802Clip · crackedDURING A C-CHECK, THE LT OB CLIP ON THE FLOORBEAM AT FS 484, LBL 36 WAS FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE REPAIRED THE LT OB CLIP ON THE FLOORBEAM AT FS 484, LBL 36 IAW EO 600-53-0098.SDR USAA040751Floorbeam · corrodedFLOORBEAM, SEVERAL .5 INCH AREAS, CORROSION LEVEL 2, STA 365 BL0 TO RBL12. INSTALLED TEE CAP REPAIR IAW SRM 53-00-51.SDR SIMA200429807Floorbeam · corrodedDURING AN IMBV INSPECTION THE FORWARD DIGITAL ON LT FLOORBEAM WAS FOUND CORRODED. PERFORMED A CUTOUT OF THE DAMAGED AREA. FABRICATED A SPLICE AND DOUBLER. REPAIR DONE IAW SRM.SDR USAA040739Floorbeam · corrodedFLOORBEAM, 2 INCHES, 57.5 INCHES, CORRODED, STA 1640, BL0, RBL 57.5. SPLICED NEW SECTION OF T-CAP IAW TR 53-15-01.SDR USAA040738Floorbeam · corrodedFLOORBEAM, 2 INCH X 57.5 INCH, CORROSION, STA 1640, BL0 TO LBL 57.5. SPLICED NEW T-CAP SECTION IAW TR 53-15-01.SDR QXEA200400721Floorbeam · corrodedCOCKPIT FLOORBEAM WITH CAMLOCK RECEPTACLES ON IT AT JUST FORWARD OF FS 280 HAS CORROSION ON TOP OF C CHANNEL. REPAIRED IAW REO 670-53-1-095 AND SRM 51-42-06-001-001.SDR QXEA200400718Floorbeam · crackedPDX - BEAM FS 280 HAS A POSSIBLE CRACK LEFT SIDE BELOW T-BRACKET ATTACH POINT FOR SEAT RAIL BEAM. REPAIRED IAW REO 670-53-11-045.SDR QXEA200400717Floorbeam · crackedPDX - FLOORBEAM FS 280 IS CRACKED TOP FLANGE 12 INCHES FROM CENTER RIGHT SIDE. REPAIRED IAW REO 670-53-11-045 AND HORIZON AIR EA R-55-211.SDR USAA040884Floorbeam · corrodedFLOORBEAM, 2 INCH AREA, CORROSION; LEVEL 1; TASK NR C53-107-02, LBL 30.5 BETWEEN STA 947.5 AND 967. REMOVED AND REPLACED DEFECTIVE PART WITH IDENT PART IAW SRM 51-10-02.
Back to JASC 5315