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 AALA20100714TUL01Frame · crackedNOSE SECTION FORWARD BULKHEAD FRAME 37 CRACK AT LOWER RIGHT RADOME ALIGNMENT PIN RADIATING FROM INBOARD RIVET. CUT OUT CRACK AND INSTALLED DOUBLER PER AARD 53-10-00-19.SDR IPXA10562293Frame · damagedINSPECTION TYPE:C3, ACCOMPLISH EO B757-5310-25199B. REPLACED INNER CHORD OF FUSELAGE FRAME REPAIR AT BS 940, S-14L TO S-16L. REPAIRED IAW EO B757-5310-25199B.SDR IPXA10562038Frame · damagedINSPECTION TYPE:C3, ACCOMPLISH EO B757-5310-25200B FRAME REPAIR AT BS 1020, S-14L TO S-16L. ACCOMPLISHED EO B757-5310-25200B FRAME REPAIR AT BS1020 A14L TO S-16L.SDR QXEA2010071500414Frame · corrodedC CHECK - FOUND CORROSION ON FRAME AT FS 295 BETWEEN STRINGERS 19L ATO 20L. REMOVED CORROSION IAW SRM 51-21-06-001-001-A01. CORROSION REMOVED MEASURES .8L X .6W X .003 D, ORIGINAL MATERIAL IS .050" REMAINING MATERIAL IS .047". FOUND TO BE OUT OF LIMITS IAW SSDR SWAA104112Frame · crackedDURING SCHEDULED 26Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 14R. REPAIRED FRAME PER ER.SDR FDEA201007132499Frame · dentedFUSELAGE INTERNAL STRUCTURE AT FR 54.2 HAS (2 EA) AREAS DENTED. AREA NR1=.0781 IN.D X .7500 IN W . AREA NR2 =.0469 IN D X .5 IN W BETWEEN STRINGER 12-15 LT SIDE. REPAIRED FRAME IAW SRM 53-10-12, PARA 5, REPAIR 202, AND EA 6-5310-135243.SDR AALA20100712TUL01Frame · crackedAFT ACCS 1510 CANT FRAME CRACKED ABOVE LEFT UPPER TAIL CONE LATCH. INSTALLED REPAIR DOUBLER PER EA MD80-53-011638.SDR FDEA201007122494Frame · chafedMAIN DECK CARGO LT UPPER AND LOWER SUPPORT YOKE AREA FRAME FOUND CHAFED. FRAME REPAIRED AS PER DWG SG10530002 REV 0 NEW. REFER TO SNRM N00199 FOR WORK DETAILS. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100 REV 110.SDR FDEA201007122493Frame · damagedDWG NR 657N3160-SH.2, REV D, FOR AFT PALLET FRAME MOD SHOWS 4EA. EXISTING FASTENER HOLES TO BE PICKED UP IN THE 657N3161-11 FITTING AT BS 1640, LT. ACFT HAS 5 EA EXISTING HOLES AT BS 1640, S17L/18L, FRAME REPAIR WAS ACCOMPLISHED ON MAE MOD W/C 118350399EZ2R02,SDR GLBA20100712FFrame · crackedDURING A SCHEDULED ROUNTINE INSP A CRACK WAS FOUND IN THE FRAME AT FS 288 STRINGER CUTOUT 4R, .25" IN LENGTH. MAINTENANCE REPAIRED THE AFFECTED AREA AND PERFORMED ALL REQUIRED RII INSPECTIONS I.A.W. EO 10-1900-53-043. MATERIALS UTILIZED ARE INCLUDED IN THE ENGSDR GLBA20100712GFrame · crackedMAJOR REPAIR - DURING A SCHEDULED ROUNTINE INSPECTION A CRACK WAS FOUND IN THE FRAME AT THE AIRSTAIR DOOR FRAME ANGLE FS 150.60, AT THE NUTPLATE AREA OF THE DOOR LOWER STRUT MOUNT, AFT UPPER MOUNT HOLES BETWEEN STRINGER 8L & 9L. MAINTENANCE REPAIRED THE AFFECTSDR QXEA2010071500408Frame · corrodedC CHECK - FOUND CORROSION ON FRAME AT FS310 FROM STRINGER 26R TO 26L. REMOVED CORROSION ON FRAME IAW SRM 51-21-06-001-001-A01. ORIGINAL THICKNESS IS .050". MAX MATERIAL REMOVED .004", REMAINING MATERIAL IS .046", WITHIN LIMITS IAW SRM 53-21-06-101-002-A01. SDR USAA2010071391413Frame · crackedCLT - Q1 - MAJOR REPAIR - CRACK ON UPPER FRAME TO SIDE FRAME SPLICE AT BS 380, S13R. REPAIRED FUSELAGE FRAME AT BS 380, S13R IAW TYPICAL REPAIR 53-10-21R.SDR QXEA2010071300407Frame · corrodedRFD - C CHECK - FOUND CORROSION ON FRAME AT FS 310 FROM STRINGERS 25L - 24L. REMOVED CORROSION ON FRAME IAW SRM 51-21-06-001-001-A01. CORROSION BLENDED ON ATTACH FLANGE OF FRAME 310.0 IS 4.6"L X 0.6"W X .004"D, ORIGINAL MATERIAL THICKNESS IS .050" REMAINING SDR SWAA104092Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER EA.SDR SWAA104091Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER EA.SDR SWAA104090Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER EA.SDR FDEA201007112475Frame · dentedFUSELAGE INTERNAL STRUCTURE FR 54.3 L HAS A DENT APPROX 3/32 INCH DEEP AND 1.5 IN DIAM. BETWEEN STR 14-13 LT MEASURED DENT ON FR 54.3 AT STR. 13L-14L FOUND TO BE OUT OF LIMIT IAW SRM 53-16-13 . REPAIRED FR 54.3L IAW EA 6-5310-135243 INSTRUCTIONS AND SRM 53-10-SDR SWAA104079Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER EA.SDR SWAA104078Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER EA.SDR USAA2010080391580Frame · crackedCLT - Q1 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME AT BS 500E BETWEEN S20R TO S21R. REPAIRED FUSELAGE FRAME AT BS 500E BETWEEN S20R TO S21R IAW B737 SRM 53-00-07 REPAIR 13.SDR USAA2010071491421Frame · crackedBFM - Q5 - MAJOR REPAIR - CRACK IN FUSELAGE FRAME AT BS 500B BETWEEN S20R TO S21R, WL182.5. REPAIRED FUSELAGE FRAME AT BS 500B BETWEEN S20R TO S21R, WL 182.5 IAW B737 SRM 53-00-07.SDR USAA2010071491417Frame · crackedBFM - Q5 - MAJOR REPAIR - CRACK IN FUSELAGE FRAME AT BS 500C BETWEEN S20R TO S21R, WL182.5. REPAIRED FUSELAGE FRAME AT BS 500C BETWEEN S20R TO S21R, WL 182.5 IAW B737 SRM 53-00-07.SDR QXEA2010071300397Frame · corrodedC-CHECK - FOUND CORROSION ON FRAME AT FS 295 FROM STRINGER 27 TO 25L. REMOVED CORROSION IAW SRM 51-21-06-001-001-A01. BLENDED 2 AREAS. ONE AT THE ATTACH FLANGE BETWEEN 25L-26L MEASURED 2.0"L X 0.6"W X .002" DEEP, SECOND BLEND ON ATTACH FLANGE BETWEEN STRINGESDR QXEA2010071300400Frame · corrodedC CHECK - FOUND CORROSION ON FRAME FS485 BETWEEN STRINGERS 26R TO 25L. REMOVED CORROSION IAW SRM 51-21-06-001-001-A01. BLENDS ARE WITHIN LIMITS OF SRM 53-31-06-101-003-A01. TREATED AND PRIMED IAW SRM 51-21-11-001-001-A01 AND 51-25-06-001-001-A01. PAINTED SDR QXEA2010071300401Frame · corrodedC CHECK - FOUND CORROSION ON FRAME FS501 BETWEEN STRINGERS 25L TO 25R. REMOVED CORROSION IAW SRM 51-21-06-001-001-A01. BLENDED AREA ORIGINAL THICKNESS IS .050", REMAINING MATERIAL IS .047". BLENDS ARE WITHIN LIMITS OF SRM 53-31-06-101-003-A01. TREATED AND SDR QXEA2010071300402Frame · corrodedC CHECK - FOUND CORROSION ON FRAME FS 501 BETWEEN STRINGERS 23L TO 22L. REMOVED CORROSION IAW SRM 51-21-06-001-001-A01. BLENDED AREA ORIGINAL THICKNESS IS .050", REMAINING MATERIAL IS .047". BLEND IS WITHIN LIMITS OF SRM 53-31-06-101-003-A01. TREATED AND PSDR QXEA2010071300403Frame · corrodedC CHECK - FOUND CORROSION ON FRAME FS 549 BETWEEN STRINGERS 27 TO 26L. REMOVED CORROSION IAW SRM 51-21-06-001-001-A01. BLENDED AREA ORIGINAL THICKNESS IS .050", REMAINING MATERIAL IS .048". BLEND IS WITHIN LIMITS OF SRM 53-31-06-101-003-A01. TREATED AND PRSDR QXEA2010071300404Frame · corrodedC CHECK - FOUND CORROSION ON FRAME FS565 BETWEEN STRINGERS 27 TO 26L ON BOTH FWD AND AFT SIDES OF FRAME. REMOVED CORROSION IAW SRM 51-21-06-001-001-A01. BLENDED AREA ON ATTACH ANGLE HAS ORIGINAL THICKNESS IS .050", REMAINING MATERIAL IS .048". BLEND ON WEBSDR QXEA2010071300405Frame · corrodedC CHECK - FOUND CORROSION ON FRAME FS 517 BETWEEN STRINGERS 25L TO 26R. BLENDED AND REMOVED CORROSION IAW SRM 51-21-06-001-001-A01. BLENDED AREA ORIGINAL THICKNESS IS .050" DEEPEST BLEND .003" REMAINING MATERIAL IS .047" AND WITHIN LIMITS OF SRM 53-31-06-101SDR ASAA1048069Frame · gougedAFT PIT FRAME GOUGED BETWEEN STR 24R 25R. CUT OUT DAMAGED AREA, FABRICATED AND INSTALLED DOUBLER.SDR SWIA201024888Frame · corrodedCORROSION FOUND AT RIGHT INTERIOR FUSELAGE FRAME 40. (C-CHECK) REMOVED AND REPLACED RIGHT FLOORBEAM AT FRAME 40 PER SRM.SDR AALA20100708TUL01Frame · damagedTOOLING MARK AT FRAME 727 LEFT SIDE BETWEEN STRINGERS 20 AND 21. REPAIRED PER SRM 51-70-11-2R.SDR USAA2010082391747Frame · crackedSAL - Q4 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME AT BS 500C BETWEEN S8R TO S9R. REPAIRED FUSELAGE FRAME AT BS 500C BETWEEN S8R TO S9R IAW TYPICAL REPAIR 53-10-20E.SDR IPXA10B61891Frame · crackedINSPECTION TYPE:C EMP- TAIL COMPT STA 2598 LT BHD INNER CHORD CRACK AT LWR TORSION BOX AREA AS MARKED. (CHORD CRACK LENGTH 0.915"), ( WEB CRACK LENGTH 0.030" ) CHORD & WEB REPAIRED IAW HX RS R53-80-36775, REV A AND EO 747- 5310-38966-A, ORG MAT'L:BAC1505-1008SDR SWAA104031Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME WEB CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER EA.SDR SWAA104030Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME WEB CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER EA.SDR SWAA104028Frame · crackedDURING SCHEDULED 26Y CHECK, FOUND FWD CARGO COMPT FRAME CRACKED AT BS 500C, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER ER.SDR SWAA103995Frame · crackedDURING SCHEDULED 26Y CHECK, FOUND FWD CARGO COMPT FRAME CRACKED AT BS 500B, BETWEEN 20L TO STR 21L. REPAIRED FRAME PER ER.SDR AALA20100707TUL10Frame · crackedTHE 1497 CANT FRAME CRACKED BELOW RIGHT LOUVER BOX. INSTALLED DOUBLER PER EA MD80-53-011694.SDR NOCA05110Fitting · crackedRIGHT FAIL-SAFE FITTING STA 955 CRACKED. REMOVED DAMAGED 955 FAIL-SAFE FITTING AND REPAIRED AS PER EO 767-53-004 REV D AND IAW AD 2004-19-06-R1.SDR FDEA201007062373Frame · crackedFWD PIT - FRAME UPPER FLANGE HAS DENT AT BS 520 BETWEEN STRINGERS 24L AND 23L. CUT- OUT DAMAGED AREA DIM 1" X .5" IAW SRM 51-10-1, FABRICATED DOUBLER FROM 7075 0 .063" DIM 7" X 4.5" IAW SRM 51-40-3 FIG 1 & INSTALLED REPAIR DOUBLER IAW SRM 51-40-3 FIG 1 REV 103SDR SWAA103979Frame · crackedDURING SCHEDULED 26Y CHECK, FOUND FWD CARGO FRAME CRACKED AT BS 500C, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR SWAA103978Frame · crackedDURING SCHEDULED 26Y CHECK, FOUND FWD CARGO FRAME CRACKED AT BS 500D, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR SWAA103956Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 827, STR 24L. REPAIRED FRAME PER EO.SDR SWAA103944Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 767, BETWEEN STR 25L TO STR 26L. REPAIRED FRAME PER SRM.SDR SWAA103943Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 767, BETWEEN STR 27R TO STR 27L. REPAIRED FRAME PER SRM.SDR NOCA04910Strap · crackedLEFT SIDE 955 FAIL-SAFE FITTING CRACKED. REMOVED DAMAGE 955 FAIL-SAFE STRAP AND REPAIRED AS PER EO 767-53-004 REV D AND IN ACCORDANCE WITH AD 2004-19-06-R1.SDR IPXA10561122Frame · dentedINSPECTION TYPE:C4, AFT CARGO LT FRAME DENTED ON INBD FLANGE, BS 1320, STR 26L, MARKED. REPAIRED DAMAGE IAW SRM 53-00-07-2R 5.SDR FDEA201007032341Frame · bentMAIN CARGO COMPARTMENT FRAME BENT AT FRAME 735, LONGERON 12R. REPAIRED FRAME IAW SRM 53-30-00 FIG. 5. CAT. B INSP DUE AT 12,000 AND REPETITIVE INSP DUE AT 8,000. CLASSIFIED AS A MAJOR REPAIR.
Back to JASC 5311