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 SWIA201023733Frame · corrodedFLT 7769-2--MAIN CABIN DOOR FRAMES AND STRINGERS CORRODED. REPAIRED PER SRM.SDR SWAA101062Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER EA.SDR SWAA101061Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER EA.SDR SWAA101046Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 482B, BETWEEN STR 20L TO STR 21L. REPAIRED SKIN PER ER.SDR USAA2010022690457Frame · corrodedCLT - C2 - MAJOR REPAIR - CORROSION ON FUSELAGE FRAME AT BS 729 BETWEEN S16L TO S18L. REPAIRED FUSELAGE FRAME AT BS 729 BETWEEN S16L TO S18L IAW EA 101761.SDR CALA2010022600050Beltframe · crackedB737-53-4-0012 BELT FRAME STA 787 BETWEEN STRINGER S8R - S9R HAS CRACK AT FASTENER AREA. REPAIRED FRAME PER EA 5310-04498 OP 02.SDR AALA20100224TUL32Fitting · crackedFRAME CLIP CRACKED STATION 500F LEFT BUTTLINE 24. REPLACED CLIP PER SRM 51-40-02.SDR AALA20100224TUL21Fitting · crackedFRAME CLIP CRACKED STATION 500G RIGHT BUTTLINE 24. REPLACED CLIP PER SRM 51-10-02.SDR AALA20100224TUL29Doubler · crackedCRACK IN DOUBLER ON CANT FRAME 1463 AT LONGERON 18 LEFT. REMOVED DOUBLER INSTALLED TRIPLER PER SRM 53-03-00.SDR DL757100816Frame · wornAFT CARGO FRAME REPAIR CAP WORN FROM CONTACT WITH TRANSITION PANEL AT STA 1520 ABOVE S26R. REPAIR HAS NO ID TAG. REPAIRED AT SAA DURING HMV ON N/R CARD 155292.SDR DL757100811Frame · dentedAFT CARGO FRAME UPPER SURFACE DENTED/GOUGED STA1520 ABOVE STR25L. C/W MAJOR REPAIR IAW SRM 53-00-07 REPAIR 5 AT SAA ON NRC 158371.SDR DL757100808Frame · dentedAFT CARGO FRAME UPPER SURFACE DENTED ABOVE S25L STA 1540. REPAIRED AT SAA DURING HMV ON N/R CARD 158370.SDR DL757100806Frame · dentedAFT CARGO FRAME UPPER SURFACE DENTED BETWEEN S25L AND S26L STA 1500. REPAIRED AT SAA DURING HMV ON N/R CARD 158372.SDR MALA100046Frame · chafedGENERIC CHAFE REPAIR TO FUSELAGE FRAME INNER FLANGE STA 363, SL1605, WO488930. REPAIRED IAW EO S53152.SDR MALA100045Frame · chafedGENERIC CHAFE REPAIR TO FUSELAGE FRAME INNER FLANGE STA 363, SL1505, WO488930. REPAIRED IAW EO S53731.SDR SWAA101016Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO COMPT FRAME CRACKED AT BS 500C, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR ASAA1047670Frame · crackedCABIN FRAME CRACKED AT FS 400R STRINGER 8R. REMOVED DAMAGED AREA, FABRICATED REPAIR ANGLES AND INSTALLED REPAIR PARTS.SDR ASAA1047667Frame · crackedCABIN FRAME CRACKED AT FS 440 RT AT STRINGER 8R TO 9R. CUT OUT DAMAGED SECTION IN FRAME, FABRICATED AND INSTALLED REPAIRS.SDR ASAA1047666Frame · crackedCABIN FRAME CRACKED AT FS 380 RT AT STRINGER 8R. CUT OUT DAMAGED SECTION IN FRAME, FABRICATED AND INSTALLED REPAIRS.SDR USAA2010030190469Frame · crackedCLT - Q5 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME AT BS 500D, WL 182.5 (RIGHT). REPAIRED RIGHT FUSELAGE FRAME AT BS 500D, WL 182.5 IAW B737 SRM 53-00-07 REPAIR 13.SDR CALA2010022600046Frame · crackedB737-53-3-0739 FWD CABIN FUSELAGE INT, STA 400 AT RIGHT PSU RAIL ATTACH AREA, FRAME CRACKED AT ATTACH FASTENER BETWEEN STRINGER 8 RIGHT AND STRINGER 9 RIGHT. FRAME REPAIR AT STA 400 RT BETWEEN STR 8 AND 9 RT COMPLIED WITH REF ECRA 5310-05100.SDR CALA2010022600045Frame · crackedSTA 400 AT LEFT PSU RAIL ATTACH AREA, FRAME IS CRACKED AT ATTACH FASTENER BETWEEN STRINGER 8 LEFT AND 9 LEFT. FRAME REPAIR AT STA 400 LT BETWEEN STR 8 AND 9 LT COMPLIED WITH REF ECRA 5310-05100.SDR CALA2010022600044Frame · crackedSTA 440 AT LT PSU RAIL ATTACH AREA, FRAME IS CRACKED AT ATTACH FASTENER BETWEEN STRINGER 8 LEFT AND 9 LEFT. FRAME REPAIR AT STA 440 LT BETWEEN STR 8 AND 9 LT COMPLIED WITH REF ECRA 5310-05100.SDR USAA2010022590445Frame · crackedCLT - Q5 - MAJOR REPAIR - CRACK IN FUSELAGE FRAME AT BS 500D, WL 182.5. REPAIRED FUSELAGE FRAME AT BS 500D, WL 182.5 IAW B737 SRM 53-00-07 REPAIR 13.SDR SWAA101000Frame · crackedDURING SCHEDULED 26Y CHECK, FOUND FRAME CRACKED AT BS 500B, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER ER.SDR SWAA100999Frame · crackedDURING SCHEDULED 26Y CHECK, FOUND FRAME CRACKED AT BS 500A, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER ER.SDR USAA2010022490440Frame · crackedCLT - Q5 - MAJOR REPAIR - CRACK IN FUSELAGE FRAME AT BS 500E BETWEEN S20L & S21L. REPAIRED FUSELAGE FRAME AT BS 500E BETWEEN S20L & S21L IAW B737 SRM 53-00-07-2R-13.SDR USAA2010022490439Frame · crackedCLT - Q5 - MAJOR REPAIR - CRACK IN FUSELAGE FRAME AT BS 500D BETWEEN S20L & S21L. REPAIRED FUSELAGE FRAME AT BS 500D BETWEEN S20L & S21L IAW B737 SRM 53-00-07-2R-13.SDR USAA2010022490438Frame · crackedCLT - Q5 - MAJOR REPAIR - CRACK IN FUSELAGE FRAME AT BS 500C BETWEEN S20L & S21L. REPAIRED FUSELAGE FRAME AT BS 500C BETWEEN S20L & S21L IAW B737 SRM 53-00-07 REPAIR 13.SDR AALA20100222AFW01Frame · damagedSTATIONS 500 TO 522 FRAMES BETWEEN STRINGER 30 LEFT AND 31 LEFT DAMAGED. ACCOMPLISHED REPAIR PER EA B767-53-009146.SDR AALA20100305TUL04Failsafe · corrodedFAIL-SAFE CHORD STATION 312 BETWEEN STRINGER 25 LEFT AND 21 LEFT IS CORRODED. INSTALLED NEW FAIL-SAFE CORD AND FASTENERS PER SRM 51-10-2.SDR AALA20100224TUL14Frame · crackedFRAME CRACKED AT INBOARD AIR CONDITIONING RAIL BRACKET STATION 440 RIGHT. REPAIRED PER ECO J1159AC.SDR UIEA201000051Failsafe · crackedFUSELAGE - BS 860, S6-7R FRAME FAIL-SAFE CHORD CRACK REPAIR SRM 53-30-1 FIGURE 1, DETAILS I AND II. REPEAT REQ: PERMANENT.SDR ASAA1047566Failsafe · gougedAFT PIT FRAME FAIL SAFE ANGLE IS GOUGED SEVERAL PLACES ON O/B SIDE OF INTERCOSTAL FWD ATTACH ANGLE. REMOVED AND REPLACED ANGLE.SDR SWAA100986Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER EA.SDR SWAA100957Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 440, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER ER.SDR SWAA100954Frame · crackedDURING SCHEDULED 26Y CHECK, FOUND FRAME CRACKED AT BS 500B, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER ER.SDR SWAA100927Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AFT EDGE FRAME AFT LOWER CORNER R1 DOOR CUTOUT AT LEVEL STR 17R. REPAIRED FRAME PER AEM EO.SDR FDEA201002190474Frame · misrepairedEXISTING REPAIR ON FRAME AT LT AIRCON BAY STA 485, LONGERON 36 LT TO LONGERON 38 LT. EXISTING REPAIR AT LT STA 485 FRAME, BETWEEN LONGERON 36 LT AND LONGERON 38 LT, EVALUATED AND FOUND PREVIOUSLY ACCOMPLISHED NOT IAW SRM REPAIR SCHEME. NEW REPAIR CARRIED OUTSDR FDEA201002190498Frame · corrodedAFT CARGO STATION 990 STUB FRAME CORRODED AT STR 29R. CUT OUT DAMAGED AREA IAW SRM 53-10-4 FIG 15 AND 51-10-1. FABRICATED DOUBLER, ANGLE AND SHIM IAW SRM 53-10-4 FIG 15. INSTALLED REAIR PARTS IAW SRM 51-30-2.SDR USAA2010021990408Frame · corrodedCLT - Q1 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON FUSELAGE FRAME AT BS 360 BETWEEN BL 0 TO LBL 6. REPAIRED FUSELAGE FRAME AT BS 360 BETWEEN BL 0 TO LBL 6 IAW B737 SRM 51-70-11 & 53-00-07.SDR ASOA201000321Frame · crackedRT FS 714 AT STRINGER 11 IS CRACKED IN RADIUS. THIS DISCREPANCY WILL BE REPAIRED WITH THE INCORPORATION OF S/B 601R-53-055 STRUCTURAL REPAIR AT FS 718. REF CO 762110 JOB 8762115 OP 5238 FOR DETAILS.SDR USAA2010022490437Frame · crackedCLT - Q5 - MAJOR REPAIR - CRACK IN FUSELAGE FRAME AT BS 492.4 ABOVE S24R. REPLACED FUSELAGE FRAME AT BS 492.4 ABOVE S24R IAW BOEING DRAWING 65-20723.SDR SIMA201005003Frame · gougedDURING THE MAINTENANCE BASE INSPECTION FOUND FRAME 65 HAS TOOLING MARKS. THE AIRCRAFT WAS REMOVED FROM SERVICE. REPAIRED FRAME 65 IAW ENGINEERING ORDER EM-53MR-1473. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR AALA20100224TUL18Frame · crackedFRAME CRACKED STATION 480 RIGHT INBOARD AIR CONDITIONING RAIL BRACKET. REPAIRED PER ECO-1159A/C.SDR AALA20100224TUL28Frame · crackedFRAME 440 CRACKED AT INBOARD RIVET OF AIR CONDITIONING RAIL BRACKET RIGHT SIDE. REPAIRED PER ECO J1159AC.SDR AALA20100224TUL27Frame · crackedFRAME 787 CRACKED AT INBOARD RIVET OF AIR CONDITIONING RAIL BRACKET RIGHT SIDE. REPAIRED PER ECO J1159AC.SDR AALA20100224TUL26Frame · crackedFRAME 500C CRACKED AT INBOARD RIVET OF AIR CONDITIONING RAIL BRACKET RIGHT SIDE. REPAIRED PER ECO J1159AC.SDR AALA20100224TUL25Frame · crackedFRAME CRACKED 787 RIGHT INBOARD AIR CONDITIONING RAIL BRACKET. REPAIRED PER ECO 1159AC.SDR AALA20100224TUL24Frame · crackedFRAME 480 CRACKED AT INBOARD RIVET OF AIR CONDITIONING RAIL BRACKET RIGHT SIDE. REPAIRED PER ECO J1159AC.
Back to JASC 5311