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 USAA2009071791861Floorbeam · corrodedSAL - Q3 - MAJOR REPAIR - NR 6206268 & 6206269 - LEVEL 2 GALVANIC CORROSION ON TRANSVERSE FLOORBEAM UPPER CHORD AT BS967, LBL16 AND RBL31. REPAIRED TRANSVERSE FLOORBEAM UPPER CHORD AT BS967 BETWEEN LBL35 TO RBL50 IAW US AIRWAYS EA 132494.SDR DL757091170Floorbeam · corrodedCABIN FLOORBEAM FS 365.25 BL0 TO RBL45 UPPER CAP SURFACE CORRODED / ACCOMPLISHED ER/A 475623-14 REV ORIG DATED 07/07/09 AT SAA SAT ON N/R CARD 127408SDR USAA2009070891743Floorbeam · corrodedSAL - Q3 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM AT BS 344 BETWEEN RBL 9 TO LBL 15. REPAIRED FLOORBEAM AT BS 344 BETWEEN RBL 9 TO LBL 15 IAW B737 SRM 53-10-05.SDR USAA2009070291667Floorbeam · corrodedSAL - Q3 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM AT BS 986.5 BETWEEN RBL 46.5 TO LBL 46.5. REPAIRED FLOORBEAM AT BS 86.5 BETWEEN RBL 46.5 TO LBL 46.5 IAW US AIRWAYS EA 132491.SDR CALA2009060800304Floorbeam · corrodedFLOORBEAM CORRODED STA 986.5, AT L2 GIRT LATCH FAST. HOLE MARKED, REMOVED AND REPLACED PREVIOUS UPPER TEE REPAIR ON FLOORBEAM AT STA 986.5.SDR SWAA093661Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM UPPER CHORD CRACKED AT BS 663, RBL 24. REPAIRED CHORD PER EA.SDR SWAA093662Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM UPPER CHORD CRACKED AT BS 664, RBL 25. REPAIRED CHORD PER EA.SDR SWAA093657Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM UPPER CHORD CRACKED AT T-CAP BS 665, LBL 24. REPAIRED BEAM PER EA.SDR SWAA093656Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM UPPER CHORD CRACKED AT T-CAP BS 665, RBL 24. REPAIRED BEAM PER EA.SDR SWAA093658Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED BETWEEN BS 706 TO BS 737, BBL 0. REPAIRED BEAM PER EA.SDR SWAA093652Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 727B, RBL 25. REPAIRED BEAM PER EA.SDR FDEA200906051939Floorbeam · corrodedMINOR CORROSION AT STA 879, WL 208.1, RBL 12.00 TO LBL 12.00 ON TOP SURFACE FLOORBEAM. REPAIR AT LBL 12 CARRIED OUT IAW SRM 53-00-51 REV 96 FIG 201 REPAIR 3. AT RBL 12, CORROSION REMOVED IAW SRM 51-10-02 REV 96, FOUND WITHIN LIMITS. REPAIR IS CLASSIFIED AS SDR USAA2009060591416Floorbeam · corrodedPIT - C7 - MAJOR REPAIR - CORROSION ON UPPER SURFACE OF FLOORBEAM AT FR66 BETWEEN Y765 TO Y1292. REPLACED FLOORBEAM AT FR66 BETWEEN Y765 TO Y1292 IAW A320 SRM 51-72-11.SDR SWAA093625Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 727B, RBL 24.8. REPAIRED BEAM PER SRM.SDR FDEA200906041931Floorbeam · damagedELONGATED HOLE FOUND ON FLOOR SUPPORT ANGLE AT BS 1279, LBL 65. EVALUATE AND REPAIR. FLOOR SUPPORT ANGLE REPAIR CARRIED OUT AT BS 1279, LBL 65 IN ACCORDANCE WITH B757-200 SRM 51-70-12 FIG 1 REV 96. PART MARKED ON REPAIR ANGLE AS FX 146N5590-58 IN ACCORDANCESDR FDEA200906041930Floorbeam · corrodedCORROSION FOUND AT FLOORBEAM TOP AND BOTTOM FLANGE, STA 1320, LBL 24.75, WL 207.10 AFTER SEAT TRACK HAS BEEN REMOVED. EVALUATE AND RECTIFY. EXISTING REPAIR OF FLOORBEAM UPPER TEE AT LBL 34 TO RBL 34, BS 1320 REMOVED AND REPAIRED IAW SRM 53-00-51 FIG. 201 REVSDR SWAA093615Floorbeam · crackedDURING SCHEDULED SPV CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 660, BL 0. REPAIRED BEAM PER SRM.SDR GTIA0900019Floorbeam · corrodedSURFACE CORROSION AFT GALLEY AREA FR68 AND Y765. REMOVED AND REPLACED FLOORBEAM FR66.5 TO FR 70 AT STA Y765 IAW SRM 51-72-11.SDR SWAA093574Floorbeam · crackedDURING SCHEDULED 14Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 727B, RBL 24.8. REPAIRED BEAM PER EA.SDR FDEA200906021890Floorbeam · damagedFOUND NON RECORDED TOP CAP BEAM REPAIR AT C 27, LT. SPLICE REPAIR RENEWED IAW SRM 53-10-15 FIG.207.SDR FDEA200906021887Floorbeam · corrodedFOUND CROSS BEAM C 62 IN BAD CONDITION (CORROSION SPOTS, OLD REWORKS) REPAIR PERFORMED BY REPLACEMENT OF PART IAW SRM 51-72-10.SDR FDEA200906021886Floorbeam · corrodedFOUND CORROSION SPOTS ON CROSS BEAM C 63 LT SPLICE REPAIR PERFORMED IAW SRM 53-10-15 FIG 207.SDR FDEA200906021885Floorbeam · damagedFOUND WRONG MATERIAL NEEDED FOR CROSS BEAM AT C 66 REPAIR PERFORMED BY REPLACEMENT OF PART IAW SRM 51-72-10.SDR FDEA200906021869Floorbeam · corrodedFOUND CORROSION ON SHORT CROSS BEAM C 63 RT IN AFT CARGO COMPARTMENT. REPAIR PERFORMED BY REPLACEMENT OF PART IAW SRM 51-72-10.SDR IPXA09556342Floorbeam · corrodedINSPECTION TYPE:C2 MAIN CARGO DECK BS 1029 RBL 45 LONGITUDINAL FLOORBEAM HAS CORROSION O/B FLANGE. REPAIRED PER ER 09-3034 DATED 06/12/09.SDR IPXA09556341Floorbeam · corrodedINSPECTION TYPE:C2 FLOORBEAM BS 1016 BL 0 CORRODED ON UPPER FLANGE. REPAIRED PER ATS ER 09-3033.SDR DL75E090973Floorbeam · corrodedSTA 365 FLOORBEAM BL 0 -RBL 60 CORRODED CP53-221-01-02.5, C/W AT SAA =- SAT ON N/R 126021 JOB 82957530001.SDR IPXA09656266Stiffener · crackedINSPECTION TYPE:6C MAIN E/E CENTER STA 246 LBL 40 M/D FLOORBEAM ATT STIFFENER FOUND CRACKED. MAIN E/E CENTER STA 246 LBL 40 FLOORBEAM ATT STIFFENER REPAIRED AS PER SRM 53-10-51-2R 4 FIG 201 REV 44, THIS IS CLASSIFIED AS A MAJOR REPAIR WITH MATERIAL 7075-0-006SDR IPXA09556249Floorbeam · corrodedINSPECTION TYPE:C2 BS 1040-1080 BL 0 LONGITUDINAL FLOORBEAM HAS SEVERAL SPOTS OF CORROSION. REMOVED AND REPLACED BS 1040-1080 BL 0 FLOORBEAM IAW SRM 51-40-05-0G, SRM 51-40-08-0G AND SRM 51-40-02-0G.SDR ASOA200900627Floorbeam · corrodedFLOORBEAM AT LBL 27 OUTBOARD FLANGE IS CORRODED AROUND NUT PLATES FOR FLOORBOARD SCREWS FS 559+80 TO FS 621.0. REMOVED FLOORBEAM CAP IAW SRM 51-42-06 AND 51-42-21. LOCATED AND DRILLED NEW CAP IAW SRM 51-42-06. REMOVED BEAM FITTING STA 605-621 IAW SRM 51-42SDR ASOA200900612Attach Fitting · crackedFS 280 ATTACH CLIPS FOR FLOORBEAMS ARE CRACKED AT O/B SIDE OF LBL 9 AND O/B SIDE OF RBL 9. REMOVED & REPLACED PER REO 601R-53-11-171 STEP 9 ON MWC 8765821.SDR FDEA200906011866Floorbeam · corrodedMAIN CABIN FLOORBEAM BS 312, LBL 6 IS EXFOLIATED ON AFT LIP OF UPPER CHORD. CUT OUT DAMAGED AREA 2 BY 1 INCH IAW DWG NR SR27-53-017 REV A. FABRICATED 2 REPAIR ANGLES AND REPAIR FILLER IAW DWG NR SR27-53-017 REV A. HEAT TREATED REPAIR ANGLES FROM TO T6 IAW FSDR CALA2009060200295Floorbeam · corrodedSUPPORT TASK MAIN CABIN FLOORBEAM AT STA 1640 RBL 56 FOUND TO BE OUT OF LIMITS AFTER CORROSION REMOVAL. INSTALLED REPAIR ANGLES, STRAPS AND T-CHORD ON FLOORBEAM STA 1640 RBL 38-66 PER SRM 53-00-01.SDR IPXA09656308Attach Angle · crackedINSPECTION TYPE:6C AFT OF BULK CARGO COMPT STA 1582 LBL 81 MAIN DECK FLOOR SUPPORT BEAM ATTACH ANGLE FOUND CRACK. AFT OF BULK CARGO COMPT STA 1582 LBL 81 MAIN DECK FLOOR SUPPORT BEAM ATTACH ANGLE REPLACED AS PER SRM 51-10-02 AND INSTALLED AS PER SRM 51-40-02 SDR IPXA09656307Attach Angle · crackedINSPECTION TYPE:6C AFT OF BULK CARGO COMPT STA 1582 RBL 81 MAIN DECK FLOOR SUPPORT BEAM ATTACH ANGLE FOUND CRACK. AFT OF BULK CARGO COMPT STA 1582 RBL 81 MAIN DECK FLOOR SUPPORT BEAM ATTACH ANGLE REPLACED AS PER SRM 51-10-02 AND INSTALLED AS PER SRM 51-40-02 SDR IPXA09656283Attach Fitting · crackedINSPECTION TYPE:6C MAIN E/E CENTER STA 246 RBL 10 M/D FLOORBEAM ATT CLIP FOUND CRACKED. MAIN E/E CENTER STA 246 RBL 10 M/D FLOORBEAM ATT CLIP REPLACED AS PER SRM 51-10-02 AND INSTALLED AS PER SRM 51-40-02 REV 44.SDR IPXA09656265Attach Angle · crackedINSPECTION TYPE:6C MAIN E/E CENTER STA 246 LBL 25 MAIN DECK FLOORBEAM ATT ANGLE FOUND CRACKED. MAIN E/E CENTER STA 246 LBL 25 MAIN DECK FLOORBEAM ATT ANGLE REPLACED AS PER SRM 51-10-02 AND INSTALLED AS PER SRM 51-40-02 REV 44.SDR IPXA09656263Attach Fitting · crackedINSPECTION TYPE:6C MAIN E/E CENTER STA 246 LBL 50 MAIN DECK FLOORBEAM ATT CLIP FOUND CRACKED. MAIN E/E CENTER STA 246 LBL 50 MAIN DECK FLOORBEAM ATT CLIP REPLACED AS PER SRM 51-10-02 AND SRM 51-40-02 REV 44.SDR SWAA093479Floorbeam · crackedDURING SCHEDULED 12Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 727B, RBL 45.5. REPAIRED BEAM PER SWA EA.SDR SWAA093478Floorbeam · crackedDURING SCHEDULED 12Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 727B, LBL 45.5. REPAIRED BEAM PER SWA EA.SDR IPXA09556289Floorbeam · corrodedINSPECTION TYPE:C2 CORROSION ON THE BS 1200 FLOORBEAM FWD FLANGE RBL 30 TO RBL 60. REMOVED DAMAGED / CORRODED FLOORBEAM AREA. FABRICATED AND INSTALLED NEW FLOORBEAM SECTION IAW ER 09-2975.SDR FDEA200905291849Floorbeam · corrodedMAIN DECK FLOORBEAM AT BS 1660, RBL 9, HAS TOOLING MARKS. REMOVED TOOLING MARKS IAW SRM 53-00-51 AND FOUND OUT OF LIMITS PER SRM 53-00-51. REMOVED FLOORBEAM IAW SRM 51-40-02. RECEIVED NEW FLOORBEAM, LOCATED AND DRILLED IAW SRM 51-40-05. INSTALLED NEW FLOORBESDR USAA2009060291380Floorbeam · corrodedBFM - C21 - MAJOR REPAIR - INTERGRANULAR CORROSION ON FLOORBEAM UPPER T-CHORD AT BS 244, WL 208.1, LBL 24 TO RBL 33. REPAIRED FLOORBEAM UPPER T-CHORD AT BS 244, WL 208.1, LBL 24 TO RBL 33 IAW B737 SRM 53-10-51.SDR FDEA200905291848Floorbeam · corrodedMAIN DECK BS 1640 FLOORBEAM AT LBL 12, HAS AREA OF CORROSION. REMOVED CORROSION IAW SRM 53-00-51 AND FOUND OUT OF LIMITS IAW SRM 53-00-51. REMOVED FLOORBEAM AT BS 1640, LBL 65-RBL 65, IAW SRM 51-40-02. RECEIVED NEW FLOORBEAM, LOCATED AND DRILLED IAW SRM 51-SDR CALA2009060100290Floorbeam · corrodedB737-53-3-0710 FLOOR SUPPORT ANGLE BEAM AT STA 286 LBL 10 TO RBL 10 FLANGE CORRODED. REMOVED DAMAGED AREA PER ECRA 5321-01643. FABRICATED REPAIR ANGLES, STRAP & TAPERED FILLERS PER ECRA 5321-01643. PERFORMED HFEC OF AREA PER ECRA 5321-01643. TREAT AND PRIMSDR A6WA200940297Floorbeam · crackedQTY (2) FLOOR SUPPORT ANGLES AT FS 280.00, LBL 9.0, WL 72.00 ARE CRACKED. QTY (2) FLOOR SUPPORT ANGLES AT FS 280.00, LBL 9.0, WL 72.00 REPLACED IAW SRM 51-42-21. (K)SDR A6WA200940298Floorbeam · crackedQTY (2) FLOORBEAM ANGLES AT FS 280.00, RBL 9.00, WL 72 ARE CRACKED. QTY (2) FLOORBEAM ANGLES AT FS 280.00, RBL 9.000, WL 72.00 REPLACED IAW SRM 51-21-42. (K)SDR A6WA200940299Floorbeam · crackedUPPER AFT FLOORBEAM ANGLE AT FS 280.00, WL 72.00 IS CRACKED AT RBL 9.00 AND LBL 9.00. UPPER AFT FLOORBEAM ANGLE AT FS 280.00, LW 72.00, AT RBL 9.0 AND LBL 9.0 REPAIRED IAW REO 601R-53-11-136, REV. A. (K)SDR SWAA093456Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND CENTER BOX WING FLOORBEAM UPPER CHORD CRACKED AT STA 667, LBL 25.5. REPAIRED CHORD PER EA.SDR SWAA093455Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 727B, AT LBL 45.5. REPAIRED BEAM PER AAR EA.
Back to JASC 5315