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 DALA1030769865Frame · chafedDURING M-CHECK FOUND CHAFING ON AFT ACCESSORY COMPARTMENT FRAME AT BS 1247 L13R. REPAIRED PER SRM 51-70-5 FIGURE 1 SHEET 1.SDR CALA2010110800528Beltframe · crackedSUPPORT TASK - BELTFRAME STA 440 HAS CRACKED AT FASTENER HOLE BETWEEN STRINGERS S8L AND S9L AT THE A/C OUTLET SUPPORT BRACKET ATTACHMENT AREA (ALL WORK ACCOMPLISHED ON FORMS 44.008 AND 43.0150). REMOVED DAMAGED FRAME SECTION INSTALLED REPAIR DOUBLERS REF EA 5SDR CALA2010110800527Beltframe · crackedSUPPORT TASK - BELTFRAME STA 400 CRACKED AT FASTENER HOLE BETWEEN STR 8L & 9L AT A/C OUTLET EXTRUSION SUPPORT BRACKET ATTACHMENT AREA. INSTALLED REPAIR ANGLE A & B REF EA 5310-04498 OP.02.SDR CALA2010110800526Beltframe · crackedSUPPORT TASK. BELTFRAME STA 400 CRACK INDICATION BETWEEN STR 8R AND 9R AT A/C OULET EXTRUSION SUPPORT BRACKET ATTACHMENT (RIVET BUCKED TAIL) AREA PER MID-FREQ EDDY CURRENT INSPECTION (MFEC). INSTALLED REPAIR ANGLE A & B REF EA 5310-04498 OP2.SDR CALA2010110800525Beltframe · crackedSUPPORT TASK BELTFRAME STA 380 HAS CRACKED AT FASTENER HOLE BETWEEN STRINGERS S8R AND S9R AT THE A/C OUTLET SUPPORT BRACKET DAMAGED AREA REMOVED FROM FRAME AT STA 380 B/W STR S8R AND S9R. AREA REPAIRED PER EA 5310-04498 OP2.SDR CALA2010110800524Beltframe · crackedSUPPORT TASK BELTFRAME STA 867 HAS CRACKED AT FASTENER HOLE BETWEEN STRINGERS S8R AND S9R AT A/C OUTLET EXTRUSION BRACKET DAMAGED AREA REMOVED FROM FRAME AT STA 867 B/W STR S8R AND S9R. AREA REPAIRED PER EA 5310-04498 OP2.SDR CALA2010110800523Beltframe · crackedSUPPORT TASK BELTFRAME STA440 HAS CRACKED AT FASTENER HOLE BETWEEN STRINGERS S8R AND S9R AT THE A/C OUTLET EXTRUSION SUPPORT BRACKET DAMAGED AREA REMOVED FROM FRAME AT STA 440 B/W STR S8R AND S9R. AREA REPAIRED PER EA 5310-04498 OP2.SDR SWAA106807Frame · crackedDURING SCHEDULED OTS CHECK, FOUND STUB FRAME CRACKED AT R1 DOOR. REPAIRED FRAME PER SRM.SDR C2XA10SH384Frame · crackedSHV - DURING C-CHECK RT COCKPIT FRAME 10 CRACK BELOW DV WINDOW CUTOUT. MAINTENANCE REMOVED AND REPLACED RT COCKPIT FRAME 10 BELOW DV WINDOW IAW EMB-145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR DALA1030649865Frame · crackedDURING M-CHECK FOUND CRACK IN FRAME AT BS 737 L18L. REPAIRED PER SRM 51-10-4, SRM 51-30-5, SRM 51-30-2 AND ERA 486619-14 P-205.SDR DALA1030619865Frame · gougedDURING M-CHECK FOUND AFT ACCESSORY COMPARTMENT FRAME GOUGED AT BS 1209 STRINGER 5 BY FLOW VALVE. REPAIRED PER SRM 53-01 FIGURE 4 & SPM 06-10-001.SDR FDEA201011054261Frame · gougedFRAME 1280 IS GOUGED JUST BELOW STR S-11L.SDR AALA20101105TUL17Frame · crackedFRAME CRACKED AT STATION 1418 LONGERON 2 LEFT. INSTALLED DOUBLER PER SRM 53-03-00.SDR AALA20101105TUL16Frame · crackedFRAME CRACKED STATION 1418 LONGERON 2 RIGHT. INSTALLED DOUBLER PER SRM 53-03-00.SDR DALA1030589882Frame · crackedDURING L-CHECK FOUND CRACK IN AFT ACCESSORY COMPARTMENT CANTED FRAME AT BS 1245 L3R. REPAIRED PER SRM 51-30-5.SDR EE4Y1105451Frame · corrodedDURING STRUCTURAL INSPECTION COOPESA REPORTED AT LOWER FUSELAGE AFT CARGO COMPARMENT FRAME WITH CORROSION AT STA Y 1309 BETWEEN LONGERON 21 AND 2 RIGHT SIDE.SDR DALA1052630909Frame · crackedAFT ACCESSORY COMPT CANTED FRAME CRACKED AT LONGERON 17L, STA 1463. REPAIRED IAW SRM 51-30-05 AND 51-10-4.SDR DALA1052540909Frame · crackedMAIN PASSENGER CABIN FRAME 1174 HAS .5 IN CRACK AT APPROX L6L. REPAIRED IAW SRM 53-02, FIG 4.SDR ZZDA2010558Frame · corrodedAFT CARGO COMPARTMENT FRAME, STA 1022, LONG L26L TO L26R, CORROSION. ACCOMPLISHED FRAME SPLICE REPAIR PER B717 SRM 53-00-06.SDR QXEA2010110500705Frame · corrodedC3 CHECK - FRAME 310 HAS CORROSION BETWEEN STR 25R AND 26L. REMOVED 19 RIVETS TO ACCESS CORROSION IAW SRM 51-42-06-001-001-A01. BLENDED OUT CORROSION, REMOVED .003" OF MATERIAL, REMAINING MATERIAL IS .047" WITHIN LIMITS IAW SRM 53-21-06-001-002-A01. TREATEDSDR DALA1030469865Frame · crackedDURING M-CHECK FOUND MAIN CABIN FRAME CRACKED AT FLOOR LEVEL AT BS 712 RIGHT. REPAIRED PER SRM 51-30-2, SRM 51-30-5, SRM 51-10-4.SDR DALA1030410176Frame · crackedCABIN RT STA 903 BETWEEN S20R AND S21R FRAME INNER CHORD CRACK REPAIR ACCOMPLISHED AS PER ERA 485487-14AD REV ORIG. (DL76L103019)SDR DALA1030400176Frame · crackedCABIN LT STA 903 BETWEEN S20L AND S21L FRAME INNER CHORD CRACK. REPAIR ACCOMPLISHED AS PER ERA 485486-14AD REV ORIG. (DL76L103018)SDR QXEA2010110300701Frame · corrodedC3 CHECK - FRAME 310 HAS CORROSION BETWEEN STRINGERS 26L AND 27. REMOVED 14 RIVET FOR ACCESS TO CORROSION IAW SRM 51-42-06-001-001-A01. DETERMINED CORROSION TO EXTEND FROM 26L TO 26R. REMOVED .003" OF CORROSION FROM ORIGINAL MATERIAL OF .050". MATERIAL REMSDR SWAA106774Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 500B, BETWEEN STR 19R TO STR 22R. REPAIRED FRAME PER SRM.SDR SWAA106773Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 500B, BETWEEN STR 19L TO STR 22L. REPAIRED FRAME PER SRM.SDR SWAA106772Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 500D, BETWEEN STR 19L TO STR 22L. REPAIRED FRAME PER SRM.SDR SWAA106771Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 500C, BETWEEN STR 19L TO STR 22L. REPAIRED FRAME PER SRM.SDR SWAA106770Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 500C, BETWEEN STR 19R TO STR 22R. REPAIRED FRAME PER SRM.SDR C2XA10SH377Frame · crackedSHV - DURING C-CHECK LT FRAME 10 CRACKED BELOW DV WINDOW CUTOUT. MAINTENANCE REMOVED AND REPLACED LT FRAME 10 BELOW DV WINDOW IAW EMB-145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA10SH376Frame · crackedSHV - DURING C-CHECK RT FRAME 10 CRACKED BELOW DV WINDOW CUTOUT. MAINTENANCE REMOVED AND REPLACED RT FRAME 10 BELOW DV WINDOW CUTOUT IAW EMB-145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR V0XR201011020001Frame · corroded(V0XR) RT SIDE FRAME AT STA 510 IS CORRODED. R & R SPLICE IAW RD8-53-11498.SDR FDEA201011014205Frame · dentedFWD CARGO COMPT LT FRAME AT STA 680 S24L FOUND DENTED. FWD CARGO COMPT DENTED FRAME AT STA 680, S24L REPAIRED IAW SRM 53-00-07, FIG 201. REPAIR 5, REV 101 CATEGORY B, REPAIR REQUIRES REPEAT INSP AT 12000 F/C INTERVAL AFTER FIRST INSP AT 37500 F/C. REPAIR IS SDR DALA1030169853Frame · gougedDURING M-CHECK FOUND GOUGE IN MAIN CABIN FRAME AT BS 256 BETWEEN L11L AND L12L. REPAIRED PER SRM 53-01 FIGURE 1, SRM 51-10-9 & DC9-A-53-10-05-801-663A-A.SDR CALA2010110100516Frame · crackedCABIN INTERIOR RT SIDE STA 480 FRAME CRACKED AT PB737-53-3-0739-CABIN INTERIOR RT SIDE STA 480 FRAME CRACKED AT PUS RAIL ATTACH POINT BETWEEN STRINGER 8 AND 9. INSTALLED REPAIR DOUBLER IN INTERIOR CABIN RT SIDE AT STA 480 FRAME BETWEEN STRINGER 8 AND 9 REF ECSDR CALA2010110100515Frame · crackedCABIN INTERIOR LT SIDE STA 400 FRAME CRACKED AT PSU RAIL ATTACH POINT BETWEEN STRINGER 8 AND 9. INSTALLED REPAIR DOUBLERS IN INTERIOR CABIN LT SIDE AT STA 400 FRAME BETWEEN STRINGER 8 AND 9 REFECRA 5310-05296.SDR DALA1031249853Angle · crackedDURING M-CHECK FOUND CRACK IN MAIN CABIN FRAME SHEAR ANGLE AT BS 313 L15L. REPAIRED PER SRM 51-10-4, SRM 51-10-3 & SRM 51-30-2.SDR CALA2010110100506Frame · crackedCABIN INTERIOR RT SIDE STA 380 FRAME CRACKED AT PSU RAIL ATTACH POINT BETWEEN STRINGER 8 AND 9 (MARKED). INSTALLED REPAIR DOUBLERS IN MAIN CABIN AT STA 380 BETWEEN STR 8 & 9 RT SIDE REF.EC/RA 5310-05295. INITIATED DIP TO READ AS FOLLOWS: ACCOMPLISH INSPECTISDR CALA2010110100505Frame · crackedCABIN INTERIOR LT SIDE STA 440 FRAME CRACKED AT PSU RAIL ATTACH POINT BETWEEN STRINGER 8 AND 9. INSTALLED REPAIR DOUBLERS IN INTERIOR CABIN RT SIDE AT STA 440 FRAME BETWEEN STRIGER 8 AND 9 REF ECRA 5310-05296.SDR CALA2010110100504Frame · crackedCABIN INTERIOR RT SIDE STA 440 FRAME CRACKED AT PSU RAIL ATTACH POINT BETWEEN STRINGER 8 AND 9. INSTALLED REPAIR DOUBLER IN INTERIOR CABIN RT SIDE AT STA 440 BETWEEN STRINGER 8 AND 9 REF ECRA 5310-05296.SDR CALA2010110100503Frame · crackedCABIN INTERIOR RT SIDE STA 400 FRAME CRACKED AT PSU RAIL ATTACH POINT BETWEEN STRINGER 8 AND 9. INSTALLED REPAIR DOUBLERS IN INTERIOR CABIN RT SIDE AT STA 400 FRAME BETWEEN STRINGER 8 AND REF ECRA 5310-05296.SDR QXEA2010110100674Frame · corrodedC2 CHECK - FUSELAGE FRAME X94.800 LOWER LEG HAS CORROSION BETWEEN STRINGERS 30S AND 31S. REMOVED RIVETS FOM IAW SRM 51-42-05. REMOVED CORROSION FROM FRAME FLANGE STA 94.800 STGR 30R-31R IAW SRM 51-21-00. MEASURED AFFECTED AREA MIN MATERIAL REMAINING .036 RESDR QXEA2010110100673Frame · damagedC2 CHECK - FUSELAGE FRAME X94.800 LWR LEG HAS CORROSION BETWEEN STR 31S AND 32S. REMOVED RIVETS FOM IAW SRM 51-42-05. REMOVED CORROSION FROM FRAME FLANGE STA 94.800 STGR 31R-32R IAW SRM 51-21-00. MEASURED AFFECTED AREA MIN MATERIAL REMAINING .034 REF NTM 51SDR KCSA101173Frame · crackedBS 2669 RBL 32 WL 305 INNER CHORD OF FRAME CRACKED .5 INCH.SDR KCSA101164Frame · crackedBS 2360 LBL 30 WL 304 FRAME HAS 3 INCH CRACK IN WEB.SDR V0XR201010290002Frame · corroded(V0XR) CORROSION ON FRAME FLANGE AND WEB AT STN 467.0 FROM STR 32L - 30R. REMOVED AND REPAIRED FRAME FLANGE. W/C 1100SDR V0XR201010290001Frame · corroded(V0XR) CORROSION ON FRAME STR 32L-30R AND STR 31R-30R AT STN 531.SDR C2XA10SH365Frame · corrodedSHV - DURING C-CHECK CORROSION (LEVEL 2 LOCAL) ON FRAME 65 STRINGER 16L-17L. MAINTENANCE PERFORMED REPAIR ON FRAME 65 STRINGER 16L-17L IAW EMB-145 EC5310-01529. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR SWAA106737Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER AAR EA.SDR WX0A070642Frame · corrodedFRAME 1401 LOWER CHORD CORRODED IN RADIUS 2 PLACES APPROX BL 0. REPLACED FS 1401 FRAME LOWER CHORD IAW MD-80/DC-9 SRM 51-10-4 PG 1, 51-30-2 PG 3 AND 51-30-5 PG 3.
Back to JASC 5311