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 UALA2011111806325Frame · corrodedFRAME STA 1400 HAS CORROSION FROM RBL 7 TO RBL 12. MAJOR REPAIR ACCOMPLISHED IAW ECRA 5311-01536, EVA 81492, AND S-CO NR 9953206.SDR AALA20111117TUL11Frame · crackedCRACK INDICATED IN FRAME AT AC RAIL ATTACH BRACKET AT STATION 500A. FRAME REPAIRED PER ECO J1159AD.SDR AALA20111117TUL09Frame · crackedCRACK INDICATED AT FRAME AT AC RAIL ATTACH BRACKET AT STATION 480L. FRAME REPAIRED PER ECO J1159AD.SDR AALA20111117TUL08Frame · crackedCRACK INDICATED IN FRAME AT AC RAIL ATTACH BRACKET AT STATION 440L. FRAME REPAIR COMPLETED PER ECO J1159AD.SDR AALA20111117TUL06Frame · crackedCRACK INDICATED IN FRAME AT AC RAIL ATTACH BRACKET AT STATION 400L. FRAME REPAIRED PER ECO J1159AD.SDR AALA20111117TUL04Frame · crackedCRACK INDICATED IN FRAME AT AC RAIL ATTACH BRACKET AT STATION 380. FRAME REPAIRED PER ECO J1159AD.SDR COEA2011111619801Frame · corrodedHEAVY CK COE / MAJOR REPAIR / LEVEL 2 CORROSION: FRAME 36 AT STR 15R HAS CORROSION (LENGTH 4.234", WIDTH .343", DEPTH .062"). SUBMITTED TO ATR / REPAIR PER STRUCTURAL REPAIR INSTRUCTIONS AND SRAS FROM ATR.SDR DALA1167033716Frame · dentedPSV 14 FWD CARGO STA 500C FRAME STGR 26L HAS DENT. REPAIR PER ERA 498053-14 REV ORIG.SDR DALA1166693231Frame · damagedFRAME 1 CHORD ANGLE DAMAGED BY BIRD STRIKE. CUT OUT DAMAGED SECTION OF FRAME 1 CHORD MPN D5311085201. CUT NEW SECTION OF CHORD, FABRICATED .080" AND .100" 2024-0 REPAIR ANGLES. INSTALLED NEW CHORD SECTION AND REPAIR.SDR SWAA117975Frame · corrodedDURING SCHEDULED 20Y CHECK FOUND, FRAME CORRODED AT BS 767, BETWEEN STR 26L TO STR 25L. REPAIRED FRAME IAW SRM AND DWG.SDR SWAA117959Frame · crackedDURING SCHEDULED 26Y CHECK FOUND, FRAME CRACKED AT BS 400, STR 26L. REPAIRED FRAME PER ER AND EA.SDR SWAA117952Frame · crackedDURING SCHEDULED SPV CHECK FOUND, FRAME CRACKED AT BS 639, RBL 65.5. REPAIRED FRAME IAW EA.SDR SWAA117947Frame · corrodedDURING SCHEDULE 16Y CHECK FOUND, FRAME CORRODED AT BS 787, BETWEEN STR 27L TO STR 26L. REPAIRED FRAME IAW SRM.SDR SWAA117946Frame · corrodedDURING SCHEDULED 16Y CHECK FOUND, FRAME CORRODED AT BS 500B, BETWEEN STR 28L TO STR 28R. REPAIRED FRAME IAW SRM.SDR SWAA117943Frame · crackedDURING SCHEDULED 16Y CHECK FOUND, FRAME CRACKED AT BS 296, STR 7R. REPAIRED FRAME IAW EA.SDR SWAA117935Frame · crackedDURING SCHEDULED 20Y CHECK FOUND, RT FRAME INNER CHORD CRACKED AT BS 616, WL 203. REPAIRED CHORD IAW EA.SDR COEA2011111618801Failsafe · corrodedHEAVY CK COE / MAJOR REPAIR / LEVEL 2 CORROSION: FRAME 39 FAIL SAFE IS CORRODED AND HAS MISSING SURFACE PROTECTION STR 20R-20L (LENGTH 40", WIDTH 1", DEPTH .016"). SUBMITTED TO ATR / REPAIR PER STRUCTURAL REPAIR INSTRUCTIONS & SRAS.SDR AALA20111116TUL04Frame · corrodedAFT CARGO HAS CORROSION ON FRAME STATION 1271 ABOVE LONGERONS 29 LEFT AND 29 RIGHT. REPAIRED CORRODED FRAME PER AARD 53-10-00-14 FIGURE 1, SHEET 2.SDR AALA20111116TUL02Frame · crackedCANT FRAME 1510 IS CRACKED AT ALIGNMENT PIN ABOVE LOWER RIGHT TAIL CONE LATCH. INSTALLED REPAIR ANGLE ON 1510 CANT FRAME PER EA MD80-53-020295.SDR MASA2011121364201Frame · damagedONE DAMAGE HOLE IN UPPER FRAME SECTION AT FS 409.00 AND ANGLE VHF ANTENNA, RT LOWER HOLE. DISCREPANT HOLE OPENED TO.216 C/W RO CRJ9-53-0811, TASK MRO 18321.SDR UALA2011111506251Frame · corrodedCORROSION ON FRAME CAP AT STA 325 - RBL 57. MAJOR REPAIR ACCOMPLISHED. REPAIRED FRAME CAP AT STA 325 RBL 57 IAW B767-300 SRM.SDR FOTR2118615061Frame · damagedAFT CARGO PIT DOUBLE DRILLED HOLE FRAME, STA 1271, LBL 2. REPAIRED ON FASI WO 21186, NR 15061.SDR USAA2011112100016Frame · crackedCDFI CHECK - CRACK IN FRAME WEB AT BS 291, S16L. REPLACED FRAME WEB AT BS291, S16L IAW EO 53-11-01025.SDR EIAA20111115254Frame · misrepairedAFT CARGO PIT FWD, CARGO DOOR JAMB BS 1810 STR. 39R FRAME REPAIRED INCORRECTLY. MAJOR REPAIR ACCOMPLISHED. REMOVED, REPAIR, FABRICATED NEW REPAIR AND INSTALLED PER SRM 53-10-04 FIG 70.SDR SIMA201132101Frame · damagedDURING MAINTENANCE BASE INSPECTION FOUND FRAME 70 TO HAVE A TOOLING MARK AT 4 O'CLOCK POSITION. THE AIRCRAFT WAS REMOVED FROM SERVICE. REPAIRED FRAME 70 IN ACCORDANCE WITH EO EM-53MR-1891. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR CALA2011111600745Frame · crackedSUPPORT TASK: REF EA 5310-04716 FRAME AT STA 400L INBOARD RIVET CANNOT PERFORM MFEC DUE TO PROXIMITY OF RIVET TO FRAME RADIUS REPAIRED FRAME AT STA 400L EA 5310-04716 REV C.SDR CALA2011111600744Frame · crackedSUPPORT TASK REF EA 5310-04716. BRACKET AT FRAME STA 500A LT, I/B RIVET HOLE CRACKED. INSTALLED REPAIR PER EA 5310-04716 AT FRAME 500A LT.SDR CALA2011111600743Frame · crackedSUPPORT TASK REF EA 5310-04716 BRACKET AT FRAME STA 500A RT, I/B RIVET HOLE CRACKED. INSTALLED REPAIR DOUBLER ON FRAME STA 500A RT SIDE BTW STRS 8 + 9 IAW EA 5310-04716 REV C.SDR SWAA117918Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 360, STR 8R. REPAIRED FRAME IAW SRM AND EA.SDR SWAA117900Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 767, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME IAW SRM AND DWG.SDR SWAA117873Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO BAY FRAME CRACKED AT BS 500D, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME IAW SI AND SRM.SDR SWAA117872Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO BAY FRAME CRACKED AT BS 500C, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME IAW SI AND SRM.SDR SWAA117871Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO BAY FRAME CRACKED AT BS 500D, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME IAW SI AND SRM.SDR SWAA117870Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO BAY FRAME CRACKED AT BS 500B, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME IAW SI AND SRM.SDR KCSA111276Frame · corrodedUPPER DECK STA 580 LBL 9 FRAME WEB HAS CORROSION UNDER ATTACH ANGLE.SDR KCSA111275Frame · corrodedUPPER DECK BS 580 FWD SIDE OF FRAME FROM STR 3L TO 3R FOUND CORROSION.SDR CALA2011111500741Frame · crackedSUPPORT TASK REF EA 5310-04716. BRACKET AT FRAME STA 480L INBOARD RIVET HOLE CRACKED. REPAIRED DAMAGED FRAME IAW EA 5310-04716 REV C.SDR CALA2011111500740Frame · crackedSUPPORT TASK REF EA 5310-04716 BRACKET AT FRAME STA 480R INBOARD RIVET HOLE CRACKED. INSTALLED REPAIR AT STA 480R REF EA 5310-04716.SDR CALA2011111500739Frame · crackedSUPPORT TASK REF EA 5310-04716 BRACKET AT FRAME STA 440L I/B RIVET HOLE CRACKED. ACCOMPLISHED REPAIR TO FRAME AT STA 440L, AS PER EA 5310-04716 REV C OP 2.SDR GLBA20111114LFrame · crackedDURING A SCHEDULED ROUTINE INSP, FOUND A CRACK IN THE FUSELAGE FRAME AT FS 288 AND STRINGER 4R, .3" IN LENGTH. MAINTENANCE REPAIRED THE AFFECTED AREA AND PERFORMED ALL REQUIRED RII INSPECTIONS IAW EO 11-1900-53-064. MATERIALS UTILIZED ARE INCLUDED IN THE ENGISDR GLBA20111114KFrame · crackedDURING A SCHEDULED ROUTINE INSP, FOUND A CRACK IN THE FUSELAGE FRAME ANGLE AT FS 150 AND STRINGER 9AL AT THE AS DOOR STRUT LWR MOUNT UPPER AFT INNER NUTPLATE AREA, 1" IN LENGTH. MAINTENANCE REPAIRED THE AFFECTED AREA AND PERFORMED ALL REQUIRED RII INSPECTIONSSDR FDEA201111144917Frame · dentedFWD LWR CARGO COMP. FRAME UPPER SURFACE HAS DENT AT STA 820, BETWEEN STRINGERS S23L AND S24L. REPAIRED IAW EA F-5310-153483, PART 1. REPAIR IS CLASSIFIED AS MAJOR.SDR FDEA201111144914Frame · dentedAFT LWR CARGO COMP FRAME STA 1500 UPPER SURFACE HAS DENT ABOVE STRINGER S25R. REPAIRED IAW EA F-5310-153465. REPAIR CLASSIFIED AS MAJOR.SDR FDEA201111144913Frame · dentedAFL LWR CARGO COMP FRAME UPPER SURFACE HAS DENT AT STA 1520, BETWEEN S25L & S26L. REPAIRED IAW EA F-5310-153466. REPAIR CLASSIFIED AS MAJOR.SDR DALA1163140928Frame · crackedDURING HMV A CRACK WAS FOUND ON FRAME AT STAY=1451 AND LONGERON 1. CRACK ON FRAME WAS BLENDED OUT AND INSTALL FILLER, DOUBLER IAW MD88 SRM 53-03D FIG 4.SDR DALA1163053715Frame · crackedSTA 400 LT FRAME CRACKED AT STRINGER 8. REPAIRED PER ERA 494564-14.SDR DALA1162983715Frame · crackedSTA 480 FRAME CRACKED AT STRINGER 8 LT. REPAIRED PER ERA 494564-14.SDR DALA1162963715Frame · crackedSTA 380 RT FRAME CRACKED AT INBD STRINGER 8. REPAIRED PER ERA 494564-14.SDR DALA1162943715Frame · crackedPASSENGER CABIN FUSELAGE FRAME AT STA 440 LT HAS CRACK AT INBD RIVET HOLE AT AT PSU ATTACH CLIP STRINGER. REPAIRED PER ERA 494564-14.SDR JR2R2011111100583Frame · corrodedFRAME 310 HAS CORROSION BETWEEN STGR 25R AND 24R IN THE FWD E&E BAY. REPAIRED FRAME FS 310 BETWEEN STGR 24R AND 25R IAW MESA RO CRJ9-53-0867 AS ON AAR WO 1007307-1000-0041 AND MESA 711014235.
Back to JASC 5311