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 IPXA09655159Attach Fitting · crackedINSPECTION TYPE:C MEC - BS 246 CABIN FLOORBEAM AFT FACE ATT CLIP CRACKED AT LBL 50 (CRACK 1 INCH LENGTH). MEC - BS 246 CABIN FLOORBEAM AFT FACE ATT CLIP REPLACED AS PER SRM 51-10-02 AND INSTALLED AS PER SRM 51-40-02 REV 43 JUST AT LBL 50.SDR IPXA09655120Floorbeam · crackedINSPECTION TYPE:C MEC STA 246 CABIN FLOORBEAM FWD FACE ALTERNATE L/G ELECT ACT SUPPORT ANGLE CRACKED AT LBL 25 (CRACK 0.625 INCH LENGTH). MEC STA 246 CABIN FLOORBEAM FWD FACE ALTERNATE L/G ELECT ACT SUPPORT ANGLE REPLACED AS PER SRM 51-10-02 AND INSTALLED AS SDR FDEA200903170942Floorbeam · corrodedBS 377.5 FLOORBEAM HAS CORROSION UNDER UPPER TEE AT LBL 45.5. INSTALLED UPPER TEE AND REPAIR IAW SRM 51-00-51 FIG 201 REPAIR NR 3. THIS IS A CATEGORY "A" MAJOR REPAIR.SDR FDEA200903170941Floorbeam · corrodedBS 365.5 FLOORBEAM UPPER TEE HAS CORROSION LBL 24.5. INSTALLED UPPER TEE AND REPAIR IAW SRM 53-00-51 FIG 201 REPAIR NR 3.THIS IS A CATEGORY "A" MAJOR REPAIR.SDR ASAA0944830Stiffener · gougedBS 520 FLOORBEAM FWD VERTICAL STIFFENER IS GOUGED LBL 45 WL 207 201. REMOVED AND REPLACED TEE STIFFENER BS 520 LBL 45 WL 207 201.SDR SWAA091760Floorbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM CORRODED AT BS 947, RBL 3. REPAIRED BEAM PER SRM.SDR FDEA200903170940Floorbeam · dentedUPPER TEE OF CABIN FLOORBEAM CORRODED ON TOP AND ON LWR SURFACE UNDER ONE NUTPLATE (LBL 13) FS 365 LBL 25-RBL 5. INSTALLED UPPER TEE REPAIR IAW SRM 53-00-51 FIG 201. REPAIR NR 3. THIS IS A MAJOR REPAIR CATEGORY "A".SDR FDEA200903161405Floorbeam · corrodedAREA 100 - PREVIOUS REPAIR AT FLOORBEAM FOUND LOCATED AT FR 63 BTW Y420 AND Y-420. REPAIR REQUIRES EVALUATION FOR MAJOR/MINOR DETERMINATION AND IF IT WAS ACCOMPLISHED USING FAA APPROVED DATA. THE REPAIR WAS REMOVED BECAUSE THE FLOORBEAM WAS REPLACED DUE TO SSDR ASAA0954764Floorbeam · corrodedAFT CARGO FLOORBEAM AT BS 727I+4 RBL 8. REPAIRED AFT CARGO FLOOR BEAM AT BS 727I+4 RBL 8SDR ASAA0954767Floorbeam · corrodedAFT CARGO FLOORBEAM CORRODED AT BS 767+4 LBL 12. REPAIRED AFT CARGO FLOOR BEAM AT BS 767+4 LBL 12SDR ASAA0954766Floorbeam · corrodedAFT CARGO FLOORBEAM AT BS 727I+4 LBL 7. REPAIRED AFT CARGO FLOOR BEAM AT BS 727+4 LBL 7.SDR ASAA0954765Floorbeam · corrodedAFT CARGO FLOORBEAM AT BS 727I+4 LBL 3. REPAIRED AFT CARGO FLOOR BEAM AT BS 727I+4 LBL 3.SDR ASAA0954763Floorbeam · corrodedAFT CARGO FLOORBEAM AT BS 727I+4 RBL 2. REPAIRED AFT CARGO FLOORBEAM AT BS 727I+4 RBL 2.SDR ASAA0954760Floorbeam · corrodedAFT CARGO FLOORBEAM CORRODED BS 767+4 RBL 3. REMOVED AND REPLACED WITH NEW EXTRUSION ON AFT CARGO FLOORBEAM.SDR ASAA0954759Floorbeam · corrodedAFT CARGO FLOORBEAM CORRODED BS 767+4 RBL 2. REMOVED AND REPLACED WITH NEW EXTRUSION ON AFT CARGO FLOORBEAM.SDR ASAA0954758Floorbeam · corrodedAFT CARGO FLOORBEAM CORRODED BS 767+4 RBL 7. REMOVED AND REPLACED WITH NEW EXTRUSION ON AFT CARGO FLOORBEAM.SDR SWAA091738Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FWD CABIN FLOORBEAM CORRODED AT BS 295, RBL 10. REPAIRED BEAM PER AAR EA.SDR CALA2009031700147Floorbeam · corrodedCABIN BODY STATION 303, LBL 30 FLOOR SUPPORT FOUND CORRODED. CABIN BODY STATION 303 FLOORBEAM LBL 9 - LBL 37 REPAIRED PER SRM 53-00-51, FIG 201, REPAIR 1 AND HFEC NO CRACK FOUND.SDR FDEA200903160928Floorbeam · corrodedFOUND CORROSION ON CROSSBEAM C 57.1 RT, REPAIR PERFORMED BY REPLACEMENT OF PART IAW SRM 51-72-10.SDR FDEA200903160927Floorbeam · corrodedFOUND DEEP SCRATCHES ON CROSS BEAM C 57.2 AND 57.1, SPLICE REPAIRS PERFORMED IAW SRM 53-10-15 FIG 207.SDR FDEA200903160926Floorbeam · corrodedFOUND CORROSION ON CROSS BEAM C 63. SPLICE REPAIR PERFORMED IAW SRM 53-10-15 FIG 207.SDR IPXA09555028Floorbeam · corrodedINSPECTION TYPE:C3 FLOORBEAM AT STA 1681.8 EVIDENCE OF CORROSION FROM RBL 30 TO 53 BULGING BETWEEN ANGLE AND SKIN. REPAIRED DAMAGED AREAS IAW ER 09-1586.SDR F3LA2009031800057Fastener · shearedREFERENCE NON-ROUTINE C059730. DURING C4/S1 C-CHECK, INSPECTION NOTED THE FORWARD GALLEY FLOORBEAM FITTING Y765 AT FRAME 12 HAS SHEARED HI-LOK AND LOOSE HI-LOK. MAINTENANCE REPLACED THE FITTING IAW SRM 51-42-11 PARAGRAPH 7.SDR ASAA0954749Floorbeam · corrodedAFT CARGO BAY FLOORBEAM CORRODED. REMOVED AND REPLACED FLOORBEAM.SDR IPXA09555022Floorbeam · corrodedINSPECTION TYPE:C3 FLOORBEAM AT STA 1681.8 EVIDENCE OF CORROSION FROM RBL 20 TO 53 BULGING BETWEEN ANGLE AND SKIN. REPAIRED DAMAGED AREA IAW ER 09-1586.SDR SWIA200921953Floorbeam · crackedFS 280 BEAM CRACKED AND CORRODED. (C CHECK) REPAIRED PER REO.SDR USAA2009033090719Floorbeam · corrodedSAL - C7 - MAJOR REPAIR - GALVANIC CORROSION ON FLOORBEAM BETWEEN FR64 TO FR66 + 5 INCHES, -Y765. REPLACED FLOORBEAM BETWEEN FR64 TO FR66 + 5 INCHES, -Y765 IAW A320 SRM 51-72-11.SDR USAA2009033090718Floorbeam · corrodedSAL - C7 - MAJOR REPAIR - GALVANIC CORROSION ON FLOORBEAM BETWEEN FR66 + 5 INCHES TO FR70, -Y765. REPLACED FLOORBEAM BETWEEN FR66 + 5 INCHES TO FR70, -Y765 IAW A320 SRM 51-72-11.SDR MTNA0903003Floorbeam · crackedLONGITUDINAL FLOORBEAM CRACKED BETWEEN FRAME 28 AND 28C LEFT SIDE. REPAIRED CRACK BY ACCOMPLISHING REPAIR IAW M7 AEROSPACE LONGITUDINAL SPLICE REPAIR DRAWING NUMBER 42-7000 DATED 02/02/2007 AND LAR 0903001 DATED 03/12/2009.SDR DL757090410Floorbeam · corrodedFUSELAGE PASSENGER FLOORBEAM, UPPER FLANGE STA 324 WL208 BL61 CORROSION DAMAGE BLENDED OUT.SDR SWAA091698Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED BETWEEN BS 663 TO BS 669, BBL 0. REPAIRED BEAM PER SRM.SDR SWAA091696Floorbeam · crackedDURING SCHEDULED 18Y CHECK, FOUND FLOORBEAM CRACKED AT BS 727A, RBL 23, WL 208. REPAIRED BEAM PER AAR EA.SDR SWAA091671Floorbeam · crackedDURING SCHEDULED 18Y CHECK, FOUND FLOORBEAM CRACKED AT BS 663, RBL 24, WL 207. REPAIRED BEAM PER SWA EA.SDR SWAA091670Floorbeam · crackedDURING SCHEDULED 18Y CHECK, FOUND FLOORBEAM CRACKED AT BS 665, LBL 25, WL 207. REPAIRED BEAM PER SWA EA.SDR SWAA091669Floorbeam · crackedDURING SCHEDULED 18Y CHECK, FOUND FLOORBEAM CRACKED AT BS 661, BBL 0, BETWEEN WL 208 TO WL 207. REPAIRED BEAM PER SWA EA.SDR SWAA091668Floorbeam · crackedDURING SCHEDULED 18Y CHECK, FOUND FLOORBEAM CRACKED AT BS 661, BETWEEN RBL 1 TO LBL 1, WL 208. REPAIRED BEAM PER SWA EA.SDR FDEA200903120909Floorbeam · corrodedMAIN CARGO DECK FLOORBEAM AT STA 720A HAS CORROSION AND SCRIBE MARKS ON UPPER " T " SECTION BETWEEN LBL25 AND RBL25. REMOVED DAMAGED AND CORRODED SECTION IAW SRM 53-10-8 FIG 3, FABRICATED REPAIR PARTS ON TRAVELERS T9/783984,T9/783989,T9/784001,T9/783983,ANDSDR A6WA200940151Floorbeam · crackedCRACK FOUND ON CLIPS FS 280, LBL 9 (2 CRACKS, LENGTH IS .500) CLIP CHANGED ON FS 280.00, LBL 9 IAW SRM 51-42-06 AND 51-42-21. (K)SDR A6WA200940134Floorbeam · crackedCRACK FOUND ON CLIP FS 280, RBL 9 (CRACK LENGTH IS .500) CLIP FS 280.00 RBL 9 FABRICATED IAW SRM 52-24-16 AND INSTALLED IAW SRM 51-42-06 AND 51-42-21. (K)SDR SWAA091608Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND RT FLOORBEAM CORRODED AT BS 328, RBL 20. REPAIRED BEAM PER SWA EA.SDR F3LA2009031100045Floorbeam · corrodedDURING C4/S1 C-CHECK, INSPECTION NOTED FLOORBEAM AT Y1162 AT FRAME 68 HAS CORROSION AT NUT CLIP HOLE. MAINTENANCE REMOVED AND REPLACED FLOORBEAM IAW SRM 51-42-11 PG 7, SRM 51-42-11 AND ENGINEERING AUTHORIZATION A9-53T-30392 STEPS 1 AND 2.SDR F3LA2009031100044Floorbeam · corrodedDURING C4/S1 C-CHECK, INSPECTION NOTED THE FORWARD GALLEY FLOORBEAM Y-1292 AT FRAME 20 WAS CORRODED ON THE UPPER SURFACE. MAINTENANCE REMOVED AND REPLACED THE FLOORBEAM IAW SRM 51-40-00 PARAGRAPH 2B, SRM 51-40-00 PARAGRAPH 3B AND SRM 51-72-11.SDR F3LA2009031100043Floorbeam · corrodedDURING C4/S1 C-CHECK, INSPECTION NOTED THE FLOORBEAM Y1292 AT FRAME 66 HAS CORROSION AT NUT CLIP HOLE. MAINTENANCE REMOVED AND REPLACED THE FLOORBEAM IAW SRM 51-42-11, 51-44-11, 51-40-00, 51-72-11 AND ENGINEERING AUTHORIZATION A9-53T-30392 STEPS 1 AND 2.SDR SWAA091602Floorbeam · crackedDURING SCHEDULED 18Y CHECK, FOUND LT FLOORBEAM VERTICAL WEB CRACKED AT BS 710.5, BBL 0, WL 203. REPAIRED WEB PER SI.SDR SWAA091600Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FWD CABIN CREASE BEAM CORRODED BETWEEN BS 295 TO BS 328, RBL 56. REPAIRED BEAM PER SRM.SDR SWAA091599Floorbeam · corrodedDURING SCHEDULED SPV CHECK, FOUND FLOORBEAM CORRODED AT BS 312, BL 0. REPAIRED BEAM PER SRM.SDR SWAA091569Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 727B, LBL 45. REPAIRED BEAM PER AAR EA.SDR CALA2009031100132Floorbeam · corrodedCORROSION AT FLOORBEAM STATION 1640 BL-0. TREATED, PRIMED AND INSTALLED REPAIR PARTS REF SRM 53-00-51, REPAIR 3 AND EC/RA 5321-01082.SDR FDEA200903100879Floorbeam · corrodedMAIN CARGO DECK FLOORBEAM UPPER TEE BS 1130 HAS CORROSION BETWEEN LBL 0 AND LBL 13. REMOVED CORROSION ON FLOORBEAM UPPER TEE BS 1130 BETWEEN LBL 0 AND LBL 13 FOUND TO BE OUT OF LIMITS IAW SRM 53-10-8 FABBED 3 (EA) FILLERS AND NEW ANGLE P/N BAC 1505/100393 IASDR MZZA2009031000030Floorbeam · corrodedCORROSION FOUND AROUND SCREW HOLE ON CABIN FLOORBEAM BS 986.5 RBL 43. REPAIR CARRIED OUT IAW EC/RA 5320-01924.
Back to JASC 5315