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 ASOA200801602Floorbeam · corrodedRT 280 BEAM HAS MINOR CORROSION ON UPPER SURFACE. REMOVED MINOR CORROSION ON UPPER SURFACE OF RT 280 FLOORBEAM PER SRM 51-12-00. PERFORMED UT THICKNESS MEASUREMENT OF BLEND AREA ON RT 280 FLOORBEAM IAW NDTM 51-20-004.SDR CALA2008120301122Floorbeam · corrodedCABIN - FLOOR SUPPORT FOUND CORRODED AT BS 303 BETWEEN LBL 20-35. CABIN FLOOR SUPPORT BEAM STA 303 LBL 20 TO LBL 60 REPAIRED PER SRM 53-00-51 REPAIR 1 FIG 201 AND HFEC NO CRACK FOUND.SDR CALA2008120301121Floorbeam · corrodedSTA 986.5 FLOORBEAM HAS CORROSION AT FASTENER HOLE, AFT FLANGE, LBL 17. CUT OUT DAMAGED AREA AND REPAIRED PER SRM 53-00-51 REPAIR 1 PAGE 204.SDR SWAA086711Floorbeam · corrodedDURING SCHEDULED 24Y CHECK, FOUND FLOORBEAM CORRODED AT BS 987, RBL 48. REPAIRED BEAM PER SRM.SDR SWAA086727Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 660, BL 0. REPAIRED BEAM PER SI.SDR AALA200820092Floorbeam · corrodedFLOORBEAM CORRODED, REPAIRED FLOORBEAM IAW SRM 53-0-51-2R3.SDR USAA2008120292173Floorbeam · crackedCLT - Q2 - MAJOR REPAIR - FLOORBEAM STABILIZER CRACKED AT BS 328, BL 0. REPLACED FLOORBEAM STABILIZER CRACKED AT BS 328, BL 0 IAW SRM 51-10-02.SDR USAA2008120292172Floorbeam · corrodedCLT - Q2 - MAJOR REPAIR - LEVEL 2 INTERGRANULAR CORROSION ON FLOORBEAM AT BS 312, LBL 14 TO RBL10. REPAIRED FLOORBEAM AT BS 312, LBL 14 TO RBL 10 IAW SRM 53-10-51.SDR DHLA2008743DH668Floorbeam · damagedUPPER FUSELAGE MAIN CARGO CABIN AT BS 720A RBL 62 FLOORBEAM WITH DOUBLE HOLE. REPAIRED FLOORBEAM SECTION AT BS 720A BTWN RBL 27 AND RBL 70 IAW COOPESA EO COO-2-53-477-08 DTD 12/18/08 DOCUMENTED ON FAA FORM 8110-3.SDR SWIA200820760Floorbeam · crackedDURING C-CHECK, RIGHT FS 484 FLOORBEAM CRACKED. REPLACED.SDR SWIA200820759Floorbeam · crackedDURING C-CHECK, LEFT FS 484 FLOORBEAM CRACKED. REPLACED.SDR AALA200820088Floorbeam · corrodedCORROSION ON FORWARD EDGE AND BETWEEN TEE CAP OF BEAM, REPAIRED FLOORBEAM TEE CAP IAW SRM 53-60-51-2R2 AND AARD 53-60-51-5SDR ASAA0873904Floorbeam · corrodedCORROSION ON BS 986.5 FLOORBEAM UPPER FLANGE. REPAIRED FLOORBEAM IAW SRM 53-70-51.SDR KCSA081603Floorbeam · crackedSTA 330 FLOORBEAM WEB CRACKED 3.5 INCHES AT LBL 63.SDR UHLA2008112800058Floorbeam · corrodedLEVEL 2 CORROSION RT FLOORBEAM BETWEEN FR86 AND 89. REMOVED AND FOUND OUT OF LIMITS IAW SRM 51-12-00. RT FLOORBEAM BETWEEN FR 86 AND 89 REPLACED IAW SRM 51-41-01 AND 51-43-01.SDR DHLA2009743DH642Floorbeam · damagedUPPER FUSELAGE MAIN CARGO CABIN AT BS 500 LBL 62 FLOORBEAM UPPER CHORD WITH DOUBLE HOLE. REPAIRED FLOORBEAM SECTION AT BS 500 BTWN LBL 56.5 AND LBL 70 IAW EO COO-2-53-467-08 DTD 12/17/08 DOCUMENTED ON FAA FORM 8110-3.SDR AALA200803068Strap · damagedSTABILIZATION STRAP FOR MAIN DECK FLOORBEAM WAS SEVERED. REMOVED PREVIOUS INTERIM REPAIR. AREA OF DISCREPANCY IS 3.25 INCH FORWARD AND 2.4 INCH AFT INBOARD OUTBOARD. INSTALLED REPAIR STRAP PER SRM 53-10-51 2R FIG 201 AND MRB 767 3351.SDR USAA2008120292163Floorbeam · corrodedCLT - Q2 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM UPPER T-CAP AT BS 344, LBL 19 TO RBL 8. REPAIRED FLOORBEAM UPPER TEE CAP AT BS 344, LBL 19 TO RBL 8 IAW SRM 53-30-51.SDR FDEA200811264978Beam · corrodedCABIN FLOORBEAM, UPPER CAP LOWER SURFACE, CORRODED AROUND NUTPLATE, STA 950 RBL 5 BLENDED AREA TO REMOVE CORROSION, ORIGINAL MAT .150, LOSS .035 REMAINING .115 AND FOUND TO BE OUT OF LIMITS REF SRM 53-10-1. OBTAINED EA 7-5310-123812. FOUND MORE CORROSION DURSDR SWAA086600Floorbeam · crackedDURING SCHEDULED SPV CHECK, FOUND FLOORBEAM CRACKED AT BS 947, LBL 54. REPAIRED BEAM PER ER.SDR USAA2008112592124Floorbeam · corrodedBFM - C4 - MAJOR REPAIR - LEVEL 2 CORROSION ON FLOORBEAM UPPER CHORD AT BS 1480, LBL 43 TO LBL 27. REPAIRED FLOORBEAM UPPER CHORD AT BS 1480, LBL 43 TO LBL 27 IAW B767 SRM 51-20-01 & 53-00-51.SDR USAA2008122292294Floorbeam · corrodedSAL - C19 - MAJOR REPAIR - NR 6130902 - CORROSION ON FLOORBEAM UPPER FLANGE AT BS 986.5, S17R, BETWEEN BL 0 TO RBL 19. REPAIRED FLOORBEAM AT BS 986.5, S17R, BETWEEN BL 0 TO RBL 19 IAW US AIRWAYS EA 132131 & B737 SRM 53-00-51-2R 2.SDR DU4R2008263Floorbeam · corrodedFOUND CORROSION IN AFT PIT ON TOP SURFACE OF FLOORBEAM AT BS 787 TO BS 847 RBL 16.SDR SWAA086569Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED AT BS 986, BETWEEN LBL 38 TO RBL 40. REPAIRED BEAM PER SWA EA.SDR SWAA086568Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED AT BS 772, LBL 3. REPAIRED BEAM PER SWA EA.SDR USAA2008120392179Floorbeam · corrodedSAL - C7 - MAJOR REPAIR - GALVANIC CORROSION ON FLOORBEAM AT FR 68, -Y1292. REPLACED FLOORBEAM AT FR 68, -Y1292 IAW SRM 51-72-11.SDR CALA2008112401095Support · corrodedCABIN - BS 325 LBL 27- LBL 60 FLOOR SUPPORT FOUND CORRODED. CABIN BS 325 LBL 16- LBL 62 FLOORBEAM SUPPORT REPAIRED PER SRM 53-00-51 REPAIR 1, FIG 201. HFEC NO CRACK FOUND.SDR UALA2008112406647Floorbeam · corrodedFLOORBEAM 200 HAS TWO SMALL SPOTS OF CORROSION (MARKED). MAJOR REPAIR ACCOMPLISHED. STARTED REPLACING BEAM.SDR UALA2008112406624Stiffener · crackedCABIN FLOORBEAM STIFFENER CRACKED AT BS 246, APPROX LBL 40, ABOVE CONTROL CABLE A1A. MAJOR REPAIR ACCOMPLISHED. INSTALLED NEW STIFFENER, P/N 141T5282-2.SDR USAA2008112492120Floorbeam · corrodedBFM - C4 - MAJOR REPAIR - LEVEL 2 CORROSION ON FLOORBEAM AT BS 325, RBL 14 THRU RBL 20. REPAIRED FLOORBEAM AT BS 325, RBL 14 THRU RBL 20 IAW B767 SRM 53-00-51 & 51-40-02.SDR SWIA200820723Floorbeam · crackedC-CHECK, FS 280 LBL9 LOWER FLOOR SUPPORT CRACKED. REPAIRED PER REO.SDR SWIA200820722Floorbeam · crackedC-CHECK, FS 280 RBL9 LOWER FLOOR SUPPORT CRACKED. REPAIRED PER REO.SDR SWIA200820721Floorbeam · crackedC-CHECK, LBL 9 FS 280 UPPER FLOOR SUPPORT CRACKED. REPAIRED PER REO.SDR AALA200810394Floorbeam · corrodedFLOORBEAM STATION 328 ALL MOUNT HOLES FROM BUTT LINE 10 RIGHT TO OUTBOARD FUSELAGE HAS CORROSION AFT LIP. INSTALLED FLOOR BEAM REPAIR STATION 328 PER ESO 61000 DATED 11/21/08.SDR AALA200810389Floorbeam · corruptedTOP OF FLOORBEAM CORRODED AT STATION 986 AND BUTT LINE 42 LEFT. INSTALLED REPAIR ANGLE PER AARD 53-00-00-7.SDR AALA200810388Floorbeam · corrodedTOP OF FLOORBEAM CORRODED AT STATION 986 BETWEEN BUTT LINE 29 LEFT AND BUTT LINE 31 LEFT. INSTALLED REPAIR ANGLE PER AARD 53-00-00-7.SDR UALA2008112406620Floorbeam · corrodedMAIN CABIN FLOORBEAM STA 1640, RBL 57 IS CORRODED. MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGED SECTION OF T-CAP, RBL 0 TO RBL 64. FAB NEW SECTION AND SPLICES.SDR 08FDEA04956Floorbeam · corrodedCORROSION ON FLOORBEAM BETWEEN BL0 AND RBL25 STA 1110. FOUND CORROSION OUT OF LIMITS, CUT OUT DAMAGED SECTION DIMS 2 3/4 INCH BY 2 1/2 INCH. FABRICATED REPAIR ANGLES USING BAC1490-2785 PO NR 9007702 DIMS 11 3/4 INCH BY 2 1/2 INCH AND BAC1490-2831 PO NR 9006SDR CALA2008112401091Floorbeam · corrodedMINOR CORROSION ON FLOORBEAM, STA 986 AT FASTENER HOLES, RBL 40-RBL 50. BURNISHED CORROSION FOUND TO BE OUT OF LIMITS AT RBL 40 AND INSTALLED REPAIR STRAP AT RBL 40 REF SRM 53-00-51 REPAIR 3.SDR CALA2008112401089Floorbeam · corrodedCABIN - BS 303 LBL 26-44 FLOOR SUPPORT FOUND CORRODED. CABIN - BS 303 LBL 7 TO LBL 62 FLOOR SUPPORT BEAM UPPER FLANGE REPAIRED PER SRM 33-00-51 REPAIR 1, FIG 201. HFEC NO CRACK FOUND.SDR SWAA086466Support · corrodedDURING SCHEDULED 24Y CHECK, FOUND AFT CARGO BAY FLOORBEAM SUPPORT CORRODED AT BS 727D + 6, LBL 8. REPAIRED BEAM PER SWA EA.SDR SWAA086465Support · corrodedDURING SCHEDULED 24Y CHECK, FOUND AFT CARGO BAY FLOORBEAM SUPPORT CORRODED AT BS 727D + 6, LBL 3. REPAIRED BEAM PER SWA EA.SDR DHLA2008743509Floorbeam · corrodedUPPER FUSELAGE CARGO CABIN BS 328 BTWN LBL 45 AND RBL 45 FLOORBEAM UPPER CHORD CORRODED. REPLACED FLOORBEAM SECTION AT BS 328 WL 208 BTWN RBL 63 AND LBL 63 DUE TO CORROSION IAW SRM 51-10-1 PARA 7A.SDR DU4R2008259Floorbeam · corrodedDURING SCHEDULED INSPECTION, FOUND CORRODED FLOOR BEAM AT BS 967 LBL 16 IN AFT CABIN.SDR DU4R2008258Floorbeam · corrodedDURING SCHEDULED INSPECTION, FOUND CORRODED FLOORBEAM AT BS 947 LBL 53 IN AFT CABIN.SDR DU4R2008254Floorbeam · corrodedDURING SCHEDULED INSPECTION, FOUND CORROSION ON FLOOR SUPPORT AT BS 328 RBL 9 - RBL 31.SDR DU4R2008251Floorbeam · corrodedDURING SCHEDULED INSPECTION, FOUND CORROSION ON FLOOR BEAM BS 312 LBL 13-30.SDR DU4R2008249Floorbeam · corrodedDURING SCHEDULED INSPECTION, FOUND CORROSION ON FLOOR BEAM BS 344 LBL 22.SDR DU4R2008248Floorbeam · corrodedDURING SCHEDULED INSPECTION, FOUND CORROSION ON BS 340 FLOOR SUPPORT LBL 11.SDR DU4R2008247Floorbeam · corrodedDURING SCHEDULED INSPECTION, FOUND CORROSION ON BS 325 FLOOR SUPPORT RBL 10.
Back to JASC 5315