JASC 5311
Service difficulty reports · 61,554
Reports filed under 5311 · Fuselage Main, Frame, 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 = '5311' 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 = '5311' 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 DALA13048060928Frame · damagedFORMER AT FS 712 BETWEEN LONGERONS 21R-25R DAMAGED. REMOVED DAMAGES FRAME SECTION. INSTALLED NEW FRAME SECTIONS IAW SRM 53-04, FIG 12C. C/W PRI 518883-14, REV O.SDR SWAA2013121123233Frame · corrodedFRAME CORRODED AT STATION 908, BETWEEN STRINGER 29R & STRINGER 29L. REPAIRED FRAME IAW SRM.SDR SWAA2013102921648Former · crackedFORMER CRACKED AT BS 1037, BETWEEN LONGERON 17R TO LONGERON 16R. REPAIRED FORMER IAW SRM.SDR SWAA2013102921647Former · crackedFORMER CRACKED AT BS 1022, BETWEEN LONGERON 13R TO LONGERON 14R. REPAIRED FORMER IAW EA.SDR AALA20130928006Frame · damagedRT FRAME FASTENER HOLE THAT ATTACHES TO THE TRANSITIONAL PANEL AT BS 727J IS ELONGATED. OVERSIZED HOLE IAW EA B737-53-031774.SDR CALA2013093000710Frame · dentedAFT PIT BS 1440 FRAME FLANGE DENTED BETWEEN STRINGER 26L & 27L. REPAIRED FRAME AT BS 1440 IN AFT CARGO PIT BETWEEN STRINGER 26L & 27L ON FLANGE IAW B757-200 SRM 53-00-07 REPAIR 5 FIG 201 PG 201-2 15.SDR CALA2013093000704Frame · crackedAD 2009-01-02 MAIN CABIN AREA INSPECTION STATION 480 RT SIDE BETWEEN STRINGER 8 & STRINGER 9 CRACKED INDICATION NOTED ON MFEC REF EA 5310-04716 REV E OP 2. FUSELAGE FRAME 480 RT HAS BEEN REPAIRED IAW EA 5310-04716 REV E OP 2.SDR CALA2013093000703Frame · crackedAD 2009-01-02 MAIN CABIN AREA FRAME INSPECTION STATION 440 RT SIDE BETWEEN STRINGER 8 & STRINGER 9. CRACK INDICATION NOTED ON MFEC. IAW EA 5310-04716 REV E, OP 2. REPAIRED FRAME AT STATION 440 RT BETWEEN STRINGER 8R & 9R IAW EA 5310-04716, REVISION E, OP 2.SDR DALA13047879207Frame · corrodedAFT CARGO BAY, BS 1344, BETWEEN L29L AND L27R, FORWARD FACE AND LOWER FLANGE OF FRAME IS CORRODED. FRAME FOUND TO BE OUT OF LIMITS. INSTALLED NEW FRAME ASSY IAW SRM 53-10-02.SDR DALA13047849207Frame · corrodedAFT CARGO BAY, LOWER AFT FLANGE OF FRAME, BS 1307 CORRODED BETWEEN L29L AND L29R. REMOVED CORROSION. FOUND TO BE OUT OF LIMITS. REPAIRED IAW SRM 53-10-02.SDR FDEA201309272420Frame · corrodedAFT CARGO BAY, S26R BS 1460 FRAME INBD FLANGE CORRODED. REMOVED CORROSION FROM FRAME FLANGE IAW SRM 51-10-02. FOUND TO BE IN LIMITS IAW SRM 53-00-07, FIG 101, DETAIL II. AFTER CORROSON REMOVAL FOUND GOUGED. REMOVED GOUGE IAW SRM 51-10-02. FOUND TO BE OSDR ASAA2013092796123Frame · wornFOUND FRAME ASSY WORN BEYOND LIMITS. ACFT GROUNDED. R & R FRAME ASSY IAW SRM 51-40-02.SDR FDEA201309272443Frame · gougedBS 377.7, S6R, FRAME GOUGEED AND DENTED. REPAIRED IAW EA 757-5312-16-F4309.SDR CALA2013093000708Frame · dentedSUPPORT TASK BS 1400 FRAME IN AFT CARGO PIT DENTED ON INNER CHORD FLANGE BETWEEN STRINGER 26L & 27L. REPAIRED FRAME AT BS 1400 IN AFT CARGO PIT BETWEEN STRINGER 26L & STRINGER 27L ON FLANGE IAW B757-200 SRM 53-00-07.SDR CALA2013092700702Frame · crackedIAW EA 5310-04716 REV E OP 2 STEP 4 & AD 2009-01-02. FRAME AT BS 440L SHOWS CRACK INDICATION BETWEEN STRINGER 8L & 9L AT BAIR CONDITION OUTLET EXTRUSSION BRACKET INBD FASTENER LOCATION. REPAIRED IAW EA 5310 04716-REV E OP2.SDR SWAA2013120322963Former · crackedFORMER CRACKED AT BS 1144, LONGERON 2L. R & R FORMER IAW DRAWING.SDR SWAA2013112122676Former · crackedFORMER CRACKED AT BS 1022, BETWEEN LONGERON 13L TO LONGERON 14L. REPAIRED FORMER IAW EA.SDR SWAA2013112122675Former · crackedRT UNDER WING BARREL KEEL BEAM FORMER CRACKED AT BS 715 AT OTBD END. R & R FORMER IAW SRM & DRAWING.SDR SWAA2013112122674Former · crackedLT UNDER WING BARREL KEEL BEAM FORMER CRACKED AT BS 715 OTBD END. R & R FORMER IAW SRM.SDR SWAA2013110521990Former · crackedFORMER CRACKED AT BS 674, UNDER WING BARREL KEEL BEAM LT SIDE. R & R FORMER IAW SRM & DRAWING.SDR SWAA2013110521986Former · crackedFORMER CRACKED AT BS 1022, BETWEEN LONGERON 13R TO LONGERON 14R. R & R FORMER IAW SRM & DRAWING.SDR SWAA2013110521993Former · crackedFORMER CRACKED AT BS 696, UNDER WING BARREL KEEL BEAM RT SIDE. R & R FORMER IAW DRAWING.SDR SWAA2013110521992Former · crackedFORMER CRACKED AT BS 674, UNDER WING BARREL KEEL BEAM RT SIDE. R & R FORMER IAW SRM & DRAWING.SDR SWAA2013110521991Former · crackedFORMER CRACKED AT BS 696, UNDER WING BARREL KEEL BEAM LT SIDE. R & R FORMER IAW DRAWING.SDR SWAA2013102821442Frame · crackedFRAME CRACKED AT STATION 889, LONGERON 30. R & R FRAME IAW SRM.SDR SWAA2013102221366Frame · corrodedFRAME CORRODED AT STATION 889, STRINGER 30R. REPAIRED FRAME IAW SRM.SDR SWAA2013102221357Former · crackedFORMER CRACKED AT BS 1144, LONGERON 2R. R & R FORMER IAW SRM.SDR SWAA2013100720810Frame · crackedFRAME CRACKED AT BS 706, BETWEEN STRINGER 8L & STRINGER 9L. R & R FRAME IAW EA.SDR DALA13048260855Frame · damagedFOUND FRAME DAMAGE BS 1190 BETWEEN L16-17R. COMPLIED WITH ERA/PRI 519084-14, REV 0.SDR DALA13047559207Frame · corrodedAFT CARGO BAY BS 1260, STUB FRAME, OTBD OF LONGERON 28R, HAS CORROSION ON FWD AND AFT SIDES. REMOVED CORROSION. FOUND TO BE OUT OF LIMITS. LOCATED, DRILLED, AND INSTALLED NEW STUB FRAME IAW SRM 51-10-05 AND 53-00-01.SDR DALA13047529207Frame Splice · corrodedAFT CARGO BAY, AFT REPAIR SPLICE AT FRAME, BS 1328 CORRODED, BETWEEN 29L AND 29R. FABRICATED AND INSTALLED NEW SPLICE IAW SRM 53-10-02.SDR FDEA201309252313Frame · dentedAFT CARGO BAY, BS 1440, S25-26L, FRAME INBD FLANGE HAS TWO DENTS. FOUND OUT OF LIMITS IAW SRM 53-00-07 FIG 101. REMOVED AND REPLACED FRAME IAW SRM 51-40-02 AND DWG 146N1028. CAT."A" MAJOR REPAIR.SDR SWAA2013102221384Former · crackedRT UNDER WING BARREL KEEL BEAM AREA, BS 674 CANTED KEEL AREA OTBD END OF FORMER CRACKED. REPAIRED FORMER IAW SRM & DRAWING.SDR SWAA2013102221383Former · crackedLT UNDER WING BARREL KEEL BEAM AREA, BS 674 CANTED KEEL AREA OTBD END OF FORMER CRACKED. R & R FORMER IAW SRM & DRAWING.SDR SWAA2013102221381Frame · corrodedFRAME CORRODED AT STATION 870, BETWEEN LONGERON 28L TO LONGERON 28R. REPAIRED FRAME IAW SRM.SDR SWAA2013102221371Frame · corrodedFRAME CORRODED AT STATION 870. REPAIRED FRAME IAW SRM.SDR SWAA2013101721244Former · crackedUNDER WING BARREL KEEL BEAM AREA, BS 715 LT SIDE CANTED KEEL AREA OTBD END OF FORMER CRACKED. R & R FORMER IAW SRM & DRAWING.SDR SWAA2013101521211Former · crackedUNDER WING BARREL KEEL BEAM AREA, BS 696 LT SIDE CANTED KEEL AREA OTBD END OF FORMER CRACKED. R & R FORMER IAW SRM & DRAWING.SDR SWAA2013101421174Former · crackedUNDER WING BARREL KEEL BEAM AREA, BS 715 RT SIDE CANTED KEEL AREA OTBD END OF FORMER CRACKED. R & R FORMER IAW SRM.SDR SWAA2013101421173Former · crackedUNDER WING BARREL KEEL BEAM AREA, BS 696 RT SIDE CANTED KEEL AREA OTBD END OF FORMER CRACKED. R & R FORMER IAW SRM.SDR SWAA2013100720809Frame · crackedFRAME CRACKED AT BS 706, BETWEEN STRINGER 8R & STRINGER 9R. R & R FRAME IAW EA.SDR DALA13047519207Frame · corrodedAFT CARGO BAY AFT SIDE OF FRAME, BS 1364 CORRODED, S26L- 29R. R & R SECTION OF FRAME IAW SRM 53-10-02.SDR ASOA2013102809256Frame · corrodedCORROSION FOUND ON FRAME BS 549 AT STRINGER 27 IN FWD CARGO BAY, REPAIRED IAW SRM 51-21-06-001-001-A01.SDR SWAA2013100720947Former · crackedFORMER CRACKED AT BD 674 LT SIDE. R & R FORMER IAW SRM.SDR CALA2013092491403Frame · corrodedCORROSION ON LOWER FRAME BS 1701 AT RBL3 TO RBL6. CUT OUT DAMAGED AREA ON FRAME FAIL SAFE CHORD. FABRICATED & INSTALLED REPAIR PARTS IAW ECRA5310-05860.SDR DALA13046916811Frame · gougedMAIN CABIN BS 1280, FRAME IS GOUGED AT S11R. BLENDED DAMAGED AREA IAW SRM 53-00-07. FOUND OUT OF LIMITS IAW SRM 53-00-07, DETAIL II AND BAC1517, CUTOUT DAMAGE AND REPAIRED IAW SRM 53-00-07, REPAIR 1, PAGE 201-215.SDR FDEA201309232285Frame · gougedBS 1280, STR 10 - 14L, FRAME FOUND GOUGED. REPAIRED IAW SRM 53-00-07, FIG.201, REPAIR 3, REV.110. REPAIR IS CAT B, MAJOR.SDR FDEA201309232284Frame · gougedBS 1280, S10 - 12R, FRAME GOUGED. REPAIRED IAW SRM 53-00-07 FIG.201, REPAIR 3, REV.110. REPAIR IS CAT.B MAJOR.SDR SWAA2013101721230Fitting · crackedAFT SIDE OF FRAME CLIP CRACKED AT BS 1151, LONGERON 2R. R & R CLIP IAW SRM & DRAWING.SDR SWAA2013101721229Fitting · crackedAFT SIDE OF FRAME CLIP CRACKED AT BS 1151, LONGERON 2L. R &R CLIP IAW SRM & DRAWING.
Back to JASC 5311