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 IPXA1569575Frame · dentedC1 CHECK, BULK CARGO, INNER FLANGE OF FRAME DENTED BS 1540, BETWEEN STR 26L- 27L. REPAIRED IAW ER 11-04597.SDR IPXA1569530Frame · dentedINSPECTION TYPE:C1, BULK CARGO, INNER FLANGE OF FRAME DENTED BS 1520, STR 26L. REPAIRED IAW SRM 53-00-07-2R5 AND ATS ER 11-04539.SDR IPXA1569518Frame · dentedINSPECTION TYPE:C1, BULK CARGO, INNER FLANGE OF FRAME DENTED BS 1620 BETWEEN STR 25L- 26L. REPAIRED IAW SRM 53-00-07-2R 5 AND ER 11-04536.SDR IPXA1569489Frame · dentedINSPECTION TYPE:C1, BULK CARGO, INNER FLANGE OF FRAME DENTED BS 1520 BETWEEN STR 25R- 26R. REPAIRED IAW SRM 53-00-07-2R5 AND ATS ER 11-04540.SDR IPXA1569488Frame · dentedINSP TYPE:C1, BULK CARGO INNER FLANGE OF FRAME DENTED BS 1500 BETWEEN STR 20R-21R. REPAIRED IAW ER 11-04538.SDR IPXA20110905001Frame · dentedINSPECTION TYPE: C1, BULK CARGO, INNER FLANGE OF FRAME DENTED BS 1480 BETWEEN 26R SRM 53-00-07-2R-5 DETAIL ISDR DALA1151676309Frame · damagedDURING PERFORM REPAIR A TOOL PENETRATED THE 65B07415-5 WEB AT LBL 10, STA 120 LWR LOBE FRAME FWD CARGO COMPARTMENT S=0.6" X0.8". PER ER/A 495575-14 REV O AND NRC 120/30 COMPLETED THIS WORK.SDR SWAA116295Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 500, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME IAW SRM.SDR IPXA1569490Frame · damagedINSPECTION TYPE:C1, SCREW STRIKE ON INBD FACE OF FRAME INBD FLANGE BS 1640 BETWEEN STR 15L AND 16L. REPAIRED IAW ATS ER 11-04428.SDR IPXA1569468Frame · gougedINSPECTION TYPE: C1, 2 SCREW STRIKES ON INBD FACE OF FRAME INBD FLANGE BS 1300 BETWEEN STR 15L AND STR 16L. REPAIR IAW ATS ER 11-04410, DATED 23-SEP-2011 AND B757-5310-44298-A DATED 26-SEP-2011.SDR IPXA1569396Frame · damagedINSPECTION TYPE:C1, SCREW STRIKE ON INBD FACE OF FRAME, INBD FLANGE, BS 1580 AT STR 14R. REPAIRED SCREW STRIKE IAW ER 11-04501.SDR FDEA201109043666Frame · corrodedAFT PIT STUB FRAME BS 950E, 5IN IS CORRODED AT BOTTOM RBL4. REMOVED DAMAGED STUB FRAME AT BS 950E PLUS 5" RBL 4, FABRICATED & INSTALLED NEW STUB FRAME IAW DWG 65-56129, SRM 53-10-2 FIG 5, SRM 51-30-5, SRM 51-30-2.SDR IPXA1569501Frame · damagedINSPECTION TYPE: C1, SCREW STRIKE ON INBD FACE OF FRAME INBD FLANGE BS 365.25 BETWEEN STR 15L AND STR 16L. REPAIRED IAW ATS ER 11-04422.SDR IPXA1569393Frame · gougedINSPECTION TYPE:C1, SCREW STRIKE ON INBD FACE OF FRAME, INBD FLANGE, BS 1100 BETWEEN STR 15R AND STR 16R. REPAIRED IAW ER 11-04494 AND SRM 51-20-01-0G.SDR ABXA2011090389Failsafe · crackedLEFT FAILSAFE STRAP FS 955 LEFT WHEEL WELL IS CRACKED AT THE 1:00 CLOCK POSITION, CRACK EXTENDS TO .160 FROM RADIUS. DAMAGED REMOVED IAW B767 SB 767-53A0100.SDR FDEA201109033646Frame · corrodedPACK BAY NR 1, THE LONG FRAME JUST OUTBOARD OF PACK OUTLET DOOR, APPROX 16" FWD OF FRAME 495, THERE APPEARS TO BE CORROSION. REPAIRED DAMAGED AREA AREF. SRM 51-31-01 AND 53-00-05.SDR FDEA201109033654Stringer · corrodedCORROSION BS 1183 STRINGER 30 OB FLANGE. REMOVED DAMAGE STRINGER SECTION, FABRICATED NEW STRINGER REPAIR & SPLICES, LOCATED & DRILLED NEW FITTING & WEB, INSTALLED NEW STRINGER REPAIR PARTS, FITTING & WEB IAW SRM 53-10-3 FIG 1 & SRM 51-30-2.SDR ASAA11410400Frame · crackedBS 500G RT WIRE PENETRATION HOLE FOUND CRACKED AT INBD 9 O'CLOCK POSITION BETWEEN S 20R AND S 21 R GROUNDED YES. TRIMMED OUT DAMAGE FABRICATED REPAIR DOUBLERS AND INSTALLED IAW B737 400 SRM 53 00 07 REPAIR 13.SDR UHLA2011090200295Frame · corrodedLEVEL 2 CORROSION AFT SIDE FRAME 85 BETWEEN STR 26R-27R SHEAR CLIP. REMOVED AND REPLACED IAW EMB 170 SRM 51-41-01, 51-41-02, 53-23-04, 51-30-00, 51-23-04, 51-23-06, 51-23-05.SDR ABXA20110902103Failsafe · corrodedCTR FUSELAGE RT FAILSAFE STRAP 'T' FITTING HAS AREA OF DEEP CORROSION (3" AREA). REMOVED AND REPLACED TEE FITTING IAW REA B653-59436-MR, AWG.SDR ABXA20110902102Failsafe · crackedLOWER BOLT HOLE OF RT FAILSAFE STRAP IS CRACKED. CRACK IS AT THE 11:00 POSITION ON HOLE AS VIEWED FROM WHEEL WELL. CRACK IS .25 INCH LONG AND .5 INCH FROM FAILSAFE STRAP RADIUS. CUT OUT FAILSAFE IAW REA B653-59436-MR, AWG.SDR USAA2011090700012Frame · corrodedQ5 CHECK - LEVEL 2 INTERGRANULAR CORROSION ON FRAME AT BS 727G, BETWEEN S27L TO S27R, BL 0. REPAIRED FRAME AT BS 727G, BETWEEN S27L TO S27R, BL 0 IAW B737-400 SRM 53-00-07 REPAIR 4.SDR 3S8R201109020006Frame · crackedNLG WHEEL WELL FRAME CRACKED AT Z112.000 AND X110.000, RT OF CTR LINE (GEAR RELEASE CABLE HOLE). CUT OUT DAMAGE AND INSTALLED REPAIR PARTS IAW DHC8102 RD 8-53-7878 AND 11973.SDR QXEA2011090600804Frame · corrodedFRAME X8.000 LOWER FLANGE HAS CORROSION ABOVE STRINGER 25P JUST BELOW FWD LT PAX DOOR THRESHOLD. REMOVED CORROSION FROM FLANGE ANGLE IAW SRM 51-21-00-00-01. FOUND TO BE OUT OF TOLERANCE IAW SRM 53-20-23-00-01. FABRICATED NEW FLANGE FROM 7075 T6 .050 IAW TASSDR QXEA2011090600803Frame · corrodedFRAME X28.000 LOWER FLANGE HAS CORROSION ABOVE STRINGER 25P JUST BELOW FWD LT PAX DOOR THRESHOLD. REMOVED CORROSION FROM FLANGE ANGLE IAW SRM 51-21-00-00-01. FOUND TO BE OUT OF TOLERANCE IAW SRM 53-20-23-00-01. FABRICATED NEW FLANGE FROM 7075 T6 .050 IAW TASDR NSVA2011220Frame · corrodedTOP FLANGE OF FRAME AT STATION 294.0 CORRODED. COMPLETED REPAIR IAW TD340-53-11-09. COMPLETED JC 51-00-00S.SDR ZZDA2011678Frame · crackedMAIN CABIN FRAME CLIP, STA 212, LONG L15, CRACKED. ACCOMPLISHED FRAME CLIP DOUBLER REPAIR PER SRM 51-70-10. SEE NR 713964.SDR USAA2011090700013Frame · corrodedQ5 CHECK - LEVEL 2 INTERGRANULAR CORROSION ON FRAME AT BS 747, BETWEEN S26L TO S27L, LBL 8. REPAIRED FRAME AT BS 747, BETWEEN S26L TO S27L, LBL 8 IAW B737-400 SRM 53-00-07-2R-4 REPAIR 2.SDR JR2R2011090100359Frame · damagedSPLICE FRAME AT FS 897 BETWEEN STR 27 TO 20L.SDR UIEA2011091300510Frame · crackedLT BS 1265 FRAME WEB CRACKED AT FASTENER HOLE. CRACKED AREA TRIMMED OFF AND REPAIRED IAW HX RS R53-42--37204, REV A AND EO 4753B419, PART 1.SDR SWAA116237Frame · crackedDURING SCHEDULED SPV CHECK, FOUND RT FRAME INNER CHORD CRACKED AT BS 616, STR 17R. REPAIRED CHORD IAW EA.SDR SWAA116236Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME WEB CRACKED AT BS 986.5, STR 20R. REMOVED AND REPLACED WEB IAW SRM.SDR SWAA116231Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 440, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME IAW EA.SDR SWAA116230Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND R1 DOOR STUB FRAME CRACKED AT BOTTOM END AT CREASE BEAM. REPAIRED FRAME IAW SRM.SDR SWAA116229Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 827, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME IAW EA.SDR SWAA116228Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 787, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME IAW EA.SDR SWAA116227Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 500A, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME PER EA.SDR SWAA116226Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 440, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME PER EA.SDR SWAA116225Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 400, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME PER EA.SDR FDEA201108303579Frame Splice · damagedFWD PIT,BS 760 S-27L, FRAME SPLICE BOTTOM FASTENER MISDRILLED. ACCOMPLISHED REPAIR IAW EA F-5310-147727. MAJOR REPAIR.SDR UIEA2011091300509Frame · crackedFRAME BS 2231 BETWEEN S16-17L, FASTENER HOLE CRACK APPROX 0.040 AT FRAME STRAP. CRACKED SEGMENT CUT OFF AND REPAIRED IAW HX RS R53-60-37210, REV A. )SDR DALA1150960693Frame · dentedAFT CARGO FRAME DENTED STA 1420 ABOVE STR 26L 2 PLACES FABRICATED J SECTION REPAIR PER B757 SRM 53-00-07, REPAIR 5 PAGE 201-212 FIGURE 201 TABLE 1. INSTALLED J SECTION REPAIR AT AFT CARGO FRAME STA 1420 ABOVE STR 26L REF B757 SRM 53-00-07 PAGE 201 REPAIR 5.SDR DALA1150570693Frame · dentedAFT CARGO FRAME DENTED STA 1520 ABOVE STR 26L FABRICATED J SECTION PER SRM 53-00-07 REPAIR 5 FIGURE 201 TABLE 1 PAGE 201-212. INSTALLED REPAIR J SECTION ON STA 1520 S26L IAW B 757-SRM 53-00-07 REPAIR 5 STEP 10 AND 11 FIG 201 PG 201. AT SAA/SAT DURING HMV ON SDR SIMA201124402Frame · damagedDURING MAINTENANCE BASE VISIT FOUND FRAME19 HAS ELONGATED HOLE JUST BELOW STRINGER 14. THE AIRCRAFT WAS REMOVED FROM SERVICE. REPAIRED FRAME 19 IAW EO EM-53MR-1847. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR SIMA201124401Frame · damagedDURING MAINTENANCE BASE VISIT FOUND FRAME 17 HAS ELONGATED HOLE JUST BELOW STRINGER 14. THE AIRCRAFT WAS REMOVED FROM SERVICE. REPAIRED FRAME 17 IAW EO EM-53MR-1846. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR SWAA116213Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 727E, BETWEEN STR 27L TO STR 27R. REPAIRED FRAME IAW SRM.SDR SWAA116192Frame · crackedDURING SCHEDULED 28Y CHECK, FOUND FRAME CRACKED AT BS 807, BETWEEN STR 27R TO STR 27L. REPAIRED FRAME PER SRM.SDR UALA2011083004666Frame · corrodedCORROSION ON FRAME STA 1680, STR 28R AND 29R. MAJOR REPAIR ACCOMPLISHED. REPAIRED BS 1681.8 BETWEEN STR 28R - 29L PER THE INSTRUCTIONS IN PD 57-53-176 AND EVA 81247 WITHOUT DEVIATION.SDR UALA2011083004659Frame · corrodedCORROSION ON FRAME STA 1160, STR 17. REPAIRED PER THE INSTRUCTIONS ON PD 57-53-177 AND EVA 81239 WITHOUT DEVIATION.SDR SWAA116189Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 947.5, BETWEEN STR 25R TO STR 26R. REMOVED AND REPLACED FRAME SECTION PER SRM AND DWG.
Back to JASC 5311