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 0202045508Floorbeam · crackedDURING "H" CHECK FOUND CRACK IN FLOORBEAM AT BS 700 LBL 45. REPAIRED PER EA 55-189888.SDR SWAA021243Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND FLOORBEAM CORRODED AT BS 987, WL 208 AND LBL 21.5 TO 25.5. REPAIRED FLOORBEAM PER BFG ER.SDR ZW0A0206003Floorbeam · damagedDURING CHECK-C MAINT THE FLOOR BEAM CAP WAS GROUND BEYOND LIMITS AT STA 1322, LBL 34. REPAIRED FLOOR BEAM CAP PER SRM 53-05, FIG 20A.SDR AWXA200200547Floorbeam · crackedYVR - MAJOR REPAIR - DURING C-15 INSPECTION A CRACK WAS FOUND ON A FLOORBEAM WEB AT BS 639 BETWEEN RIVETS AT STA RBL 64. MAINTENANCE REPAIRED CABIN FLOOR BEAM BS 639 WEB RBL 64 IAW AWA ER 15-5310-02168-JS1.SDR SIMA200215704Floorbeam · corrodedABI - DURING INSPECTION, FOUND CORROSION ON GALLEY RIGHT FLOORBEAM AT FRAME 20. REMOVED CORROSION BY BLENDING. FABRICATED AND INSTALLED DOUBLER IAW EMB GST-1707/02, ITEM NR 2, AND STANDARD SRM PRACTICES. (M)SDR SWIA200210970Angle · crackedFUSELAGE STA 280 FLOOR BEAM ATTACH ANGLE CRACKED AT RBL 9 OUTBOARD. REPLACED CRACKED ANGLE IAW CRJ SRM 51-42-13 & 51-42-21. P/N: 601R31113-58.SDR SWIA200210967Angle · crackedFUSELAGE STA 621 RIGHT FLOOR SUPPORT ANGLE CRACKED AT RBL 42. REPAIRED ANGLE IAW REO 601R-53-61-117, REV. A.SDR 2002UALA00948Cap · corrodedCABIN FLOOR BEAM STATION 324 UPPER CAP CORRODED RBL40 TORBL60. MAJOR REPAIR ACCOMPLISHED.SPLICED IN NEW CAP.SDR 2002UALA00947Floorbeam · gougedFORWARD CABIN FLOOR STATION 365 BL 0 THROUGH RBL 65 UPPER T-CAP IS GOUGED AND CORRODED. MAJOR REPAIR ACCOMPLISHED. SPLICED IN REPAIR CAP.SDR ASAA0210138Floorbeam · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND FLOORBEAM AT BS 1016, LBL 6, LBL 10 CORRODED. REPAIRED FLOORBEAM PER SRM. (M)SDR 02FDEA00381Floorbeam · corrodedCORROSION ON FLOORBEAM BS 900, LBL 43. REMOVED AND REPLACED FLOORBEAM PER EA 7- 5310-64924.SDR COOSDR020150Floorbeam · corrodedMAIN CARGO CABIN - BS 620 FLOORBEAM UPPER CHORD, CORRODED.SDR COOSDR020149Floorbeam · corrodedMAIN CARGO CABIN - BS 1070 FLOORBEAM UPPER CHORD, CORRODED.SDR COOSDR020148Floorbeam · corrodedMAIN CARGO CABIN - BS 1090 FLOORBEAM UPPER CHORD CORRODED.SDR COOSDR02146Floorbeam · corrodedMAIN CARGO CABIN BS 680 FLOOR BEAM UPPER CHORD CORRODED.SDR COOSDR02106Floorbeam · corrodedBS 950C FLOOR BEAM UPPER CHORD CORRODED FROM RBL 48 TO RBL 60 AND FROM LBL 46 TO LBL 60.SDR SIMA200215703Floorbeam · corrodedABI - DURING INSPECTION FOUND CORROSION ON GALLEY CENTER FLOORBEAM. REPLACED GALLEY CENTER BEAM IAW EMB 145 SRM 145/1142, CHAPTER 51, REV 18, ETN EM-53-028, AND STANDARD SRM PRACTICES. (M)SDR SIMA200215702Floorbeam · corrodedABI - DURING INSPECTION FOUND CORROSION ON PREVIOUS REPAIR, FORWARD DIGITAL. REMOVED PREVIOUS REPAIR. FABRICATED AND INSTALLED NEW DOUBLER IAW EMB SST-249/00, AND STANDARD SRM PRACTICES. (M)SDR 2002F00737Floorbeam · corrodedAT C-CHECK, FOUND CORROSION AT CABIN FLOORBEAM, AT STATION 1110.0, BL 0 TO LBL 60. (M)SDR SIMA200216304Floorbeam · corrodedABI - THIS IS A LEVEL 2 FINDING, CORROSION ON LEFT OMEGA BEAM UNDER EDGE OF COMPOSITE FLOOR CROSSBEAM BETWEEN FRAMES 24-25. FABRICATED AND INSTALLED A DOUBLER, IAW EMB145 SRM 53-21-10. (M)SDR UPS02M38946Floorbeam · corrodedINSPECTION TYPE:C, FLOORBEAM AT STA 1841 LBL 27 FOUND CORRODED. FLOORBEAM WEB AT STA 1841 LT REMOVED AND REPLACED AS PER DWG:AGA7170 AND INSTALLED AS PER SRM 51-35-01 VOL II REV 31.SDR SIMA200215706Floorbeam · corrodedABI - DURING INSPECTION FOUND CORROSION ON GALLEY RIGHT FLOORBEAM FRAME 23. REMOVED CORROSION BY BLENDING. FABRICATED AND INSTALLED DOUBLER IAW EMBGST1707/02, ITEM NR 2, AND STANDARD SRM PRACTICES. (M)SDR ASAA0210136Floorbeam · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND FLOORBEAM AT BS 328, RIGHT BUTTOCK LINE 15, RIGHT BUTTOCK LINE 29 CORRODED. REPAIRED FLOORBEAM PER SRM. (M)SDR AALA20020781Floorbeam · corroded(FLOORBEAM) CORROSION ON TOP OF FLOORBEAM AT BL1127R FROM STA 4610 TO 4850. REPLACE TOP OF FLOOR SUPPORT WITH ANGLE PROCURED FROM AA STOCK.SDR 02FDEA00368Floorbeam · crackedCORROSION BS 870, WL 208, LBL 65 TO RBL 65. REMOVED AND REPLACED FLOORBEAM PER EA 7- 5310-54227.SDR 02FDEA00369Floorbeam · corrodedCORROSION ON TOP OF FRETTED FLOORBEAM BS 740, WL 208, LBL 60 - RBL 65. REMOVED AND REPLACED FLOORBEAM PER SRM 51-20-4, 51-30-2.SDR RYN2002F00034Floorbeam · crackedAT (C) CHECK, FOUND CABIN FLOOR BEAM WITH .5000 INCH CRACK PROTRUDING FROM LIGHTENING HOLE, AT STATION 820, LBL 48.SDR 2002F00855Floorbeam · corrodedAT C-CHECK, FOUND FLOORBEAM EXFOLIATED IN SEVERAL AREAS, FROM LBL 60 TO RBL 60 UPPER CHORD, AT STATION 1130. (M)SDR ASAA0210134Floorbeam · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND FLOORBEAM AT BS 294, LEFT BUTTOCK LINE 20, RIGHT BUTTOCK LINE 60 CORRODED. REPAIRED FLOORBEAM PER SRM. (M)SDR AALA20020791Floorbeam · corrodedTUL - FOUND FS 1640 FLOORBEAM T-CAP CORRODED FROM BL 10L TO BL 61R. REPLACED 1640 T-CAP FROM BL 10L TO BL 61R PER SRM 53-00-51-2. (M)SDR AALA20020780Floorbeam · corrodedCORROSION ON TOP OF FLOORBEAM STA 3845 TO 4610 BL1127LH. REPLACE CORROSION WITH NEW ANGLE PROCURED FROM AA STOCK.SDR SIMA200216302Floorbeam · corrodedABI - THIS IS A LEVEL 2 FINDING, GALLEY RIGHT HAT BEAM HAS CORROSION. INSTALLED SERVICEABLE RIGHT HAT BEAM IAW EMB145 SRM 51-40-02 AND GST-1826/02. (M)SDR SIMA200214703Floorbeam · corrodedTHIS IS A LEVEL 2 FINDING, LEFT OMEGA BEAM PREVIOUS REPAIR AT FRAME 20 HAS CORROSION. INSTALLED SERVICEABLE REPAIR DOUBLER, FILLER, PLATE AND SHIMS IAW EMB145 SRM 53-21-10. (M)SDR UPS02238549Floorbeam · corrodedINSPECTION TYPE:C, CORROSION ON CHORD AT FLOOR LEVEL AT BS 1177 RT O/B. CHORD REPLACED IAW SRM 51-30-02 AND DRAWING 65-19606.SDR 200200266Floorbeam · crackedWHILE ACCOMPLISHING POSITION SENSOR INSTALLATION ON THE CONTROL COLUMN, DAMAGE WAS FOUND ON THE BS 120 FLOORBEAM WEB. TWO HORIZONTAL CRACKS IN THE WEB. REPAIR WAS MADE BY TRIMMING THE WEB TO REMOVE THE CRACKS, PERFORMING A HFEC TO ENSURE DAMAGE REMOVAL AND FSDR UPS02838618Floorbeam · chafedINSPECTION TYPE:C1 FLOORBEAM AT STA 717 CHAFED BETWEEN RBL 0-24. REPAIRED FLOORBEAM IAW DC8 SRM 53-2-0 TR 53-124.SDR UPS02838592Floorbeam · chafedINSPECTION TYPE:C1 FLOORBEAM AT STA 742 CHAFED BETWEEN RBL 0-24. REPAIRED FLOORBEAM IAW DC8 SRM 53-2-0 TR 53-124.SDR UPS02838591Floorbeam · chafedINSPECTION TYPE:C1 FLOORBEAM AT STA 759 CHAFED BETWEEN RBL 0-24. REPAIRED FLOORBEAM IAW DC8 SRM 532-0 TR 53-124.SDR ASAA0210132Floorbeam · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND FLOORBEAM AT BS 312, WATERLINE 208 CORRODED. REPAIRED FLOORBEAM PER SRM. (M)SDR UPS02838621Floorbeam · corrodedINSPECTION TYPE:C1 MAIN CABIN FLOORBEAM CORRODED AROUND NUTPLATE STA 980 LBL 10. REPLACED SECTION OF FLOORBEAM CAP IAW DC8 SRM 53-2-0 TR 53-124SDR SIMA200216517Floorbeam · corrodedABI - THIS IS A LEVEL 2 FINDING, GALLEY RIGHT FLOORBEAM AT FRAME 20 CORRODED. REPAIRED GALLEY FLOORBEAM IAW EMB145 SRM 51-40-02. (M)SDR C1HA200292029Floorbeam · corrodedFLOORBEAM STA 1030 LBL 45 - RBL 8 HAS CORROSION AND LBL 12 HAS A HOLE WITH NO EDGE DISTANCE.SDR MALA020330Floorbeam · corrodedDURING C-CHECK IN CVG, CORROSION WAS FOUND ON THE FRAME 18 FLOORBEAM OUTBOARD OF SEAT RAIL NR 3. MAINTENANCE REPAIRED DAMAGE IN ACCORDANCE WITH RIL HC537H9257, BAE FAX BARA/AVR/5931/02-DC AND EO A53085.SDR ASOA02287Floorbeam · corrodedDURING C-CHECK INSPECTION IN BNA, THE UPPER FLANGE OF THE FLOORBEAMS AT FRAMES 36, 39 AND 40 HAD SURFACE CORROSION BEYOND LIMITS AROUND THE NUTCLIP HOLES FROM STRINGER 14 LEFT TO STRINGER 14 RIGHT. MAINTENANCE REPAIRED THE CORRODED FLOORBEAM UPPER FLANGES IAWSDR ABXA020028Fitting · crackedFS 965 RIGHT BUTT LINE 48, FITTING WAS CRACKED AT FORWARD SIDE OF FLOOR BEAM. FABRICATED AND INSTALLED FITTING IAW DC-9 SRM.SDR AWXA200200521Floorbeam · corrodedLCQ - MAJOR REPAIR - DURING C-08 CHECK CORROSION WAS FOUND ON FLOORBEAM UPPER CHORD SURFACE AT BS 377, LBL 15, WL 208. MAINTENANCE REMOVED 64 INCHES CORRODED SECTION OF UPPER CHORD; FABRICATED A NEW CHORD, 2 REPAIR ANGLES, AND 2 STRAPS; INSTALLED REPAIR PARTSSDR SIMA200216518Floorbeam · corrodedABI - THIS IS A LEVEL 2 FINDING, RIGHT HAT BEAM AT FRAME 23 CORRODED. FABRICATED AND INSTALLED DOUBLER IAW EMB 145 GST-1707/02. (M)SDR ZW0A0205303Floorbeam · corrodedDURING CHECK-C MAINT FOUND CORROSION IN LATERAL FLOOR BEAM AT STA 180, FROM RBL 8 TO RBL 43. FABRICATED AND INSTALLED FLOOR SUPPORT PER SRM 51-01, PAGE 1 ITEM C.SDR 200200265Floorbeam · puncturedDURING B-CHECK A PUNCTURE WAS FOUND IN THE BS 380 FLOORBEAM WEB P/N 65B10929-506 AT APPROXIMATELY LBL 57. THE DAMAGE WAS TRIMMED OUT, HFEC INSPECTION PERFORMED AND DOUBLERS AND FILLERS FABRICATED AND INSTALLED PER ECRA 478-53-137-02.SDR 200200264Floorbeam · crackedDURING B-CHECK, A CRACKED FLOOR PANEL ATTACH HOLE COMMON TO THE BS 380 UPPER DECK FLOORBEAM UPPER CHORD WAS DISCOVERED P/N 65B10929-18 AT RBL 65.0. THE CRACKED UPPER CHORD IS BEING REPAIRED BY INSTALLING 2 STRAPS PER ECRA.
Back to JASC 5315