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 UALA2011011700274Frame · damagedSTA 1060 RT FRAME T-CHORD DAMAGED. MAJOR REPAIR ACCOMPLISHED: INSTALLED ANGLE REPAIR TO RT WHEEL WELL FAIRING SUPPORT STRUCTURE AT STA 1060 PER SRM.SDR QXEA2011012000054Frame · corrodedC5 CHECK - FUSELAGE FRAME X1.00 LOWER FLANGE HAS CORROSION BETWEEN STR 31P AND 32P. REMOVED CORROSION FROM FRAME FLANGE IAW RD 8/4-53-2344. MATERIAL LOSS FOUND TO BE WITHIN LIMITS OF RD 8/4-53-2344. COMPLETED REPAIR IAW RD 8/4-53-2344.SDR QXEA2011011900040Frame · corrodedC5 CHECK - FUSELAGE FRAME X196.000 LOWER FLANGE HAS CORROSION BETWEEN STRINGERS 32S & 31S. REMOVED LIGHT SURFACE CORROSION IAW RD 8/4-53-2344. FLANGE IS WITHIN LIMITS IAW RD 8/4-53-2344. APPLIED ALODINE AND PRIMER TO FRAME FLANGE AS REQUIRED IAW RD 8/4-53-2SDR CALA2011011700025Frame · crackedSUPPORT TASK. STA 303.9 FRAME WEB AT STRINGER S16L HAS CRACKED AT LOWER O/B AREA OF OVAL HOLE. REPAIRED FRAME WEB AT STA 303.9 PER EA 5310-04659 OP 02.SDR SWAA110266Frame · crackedDURING SCHEDULED SPV CHECK, FOUND RT FRAME CRACKED AT BS 492, AT NR 5 STOP FITTING. REMOVED AND REPLACED FRAME PER ACO.SDR MASA2011012101758Doubler · corrodedFS 379 RT FRAME DOUBLER CRACKED. MX R2 FS 379 FRAME DOUBLER IAW CRJ-700 SRM 51-42-06 AND 51-42-21.SDR SIMA201102101Frame · crackedDURING MAINTENANCE BASE VISIT INSPECTION FOUND FRAME 23 CRACKED .75 INCH BETWEEN STRINGERS 15 RIGHT AND 16 RIGHT. THE AIRCRAFT WAS REMOVED FROM SERVICE. REPAIRED FRAME 23 IAW ENGINEERING ORDER EM-53MR-1750. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR DALA1104149855Frame · damagedFWD CARGO STA 427 L26R-L25R FRAME HAS DRILL HOLE NEXT TO CORE NUT HOLE. REAMED HOLE TO .625 IAW DWG 5912461. RECEIVED 3 EA FREEZE PLUGS ON TRAV 2312NO2114. INSTALLED 3 EA FREEZE PLUGS IAW ER/A NR 487380-14. FAB 2 EA REPAIR STRAPS. INSTALLED LOWER AND UPSDR DALA1104039857Frame · damagedMAIN CABIN STA 389, RT SIDE AT L16R FRAME HAS 1 EA HOLE. REMOVED DAMAGED PORTION OF FRAME IAW SRM 53-05, FIG 4. FABRICATED FILLER, REPAIR PLATE, REPAIR ANGLE TREATED AND PRIMED PARTS IAW SRM 51-10-3. INSTALLED FRAME REPAIR IAW SRM 51-30-2, 53-03, FIG 4. APSDR ASAA1148808Frame · crackedINTERIOR FRAME CRACKED STA 500A BETWEEN STINGER 8R AND 9R AT THE AIR DISTRIBUTION SUPPORT BRACKET. REPAIRED CRACKED FRAME IAW AD20062609-400-53-112 AND ER 11-01153.SDR C2XA11SH024Frame · crackedSHV - DURING C-CHECK FRAME 10 AT STRINGER 10L AND 9L CRACKED. MAINTENANCE REMOVED AND REPLACED FRAME 10 AT STRINGER 10L AND 9L IAW EMB-145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR AALA20120112TUL04Frame · crackedSTATION 400 STRINGER 10 LEFT CRACKED. ACCOMPLISHED NESTED ANGLE REPAIR PER ECO J1159AD.SDR AALA20120112TUL06Frame · crackedSTATION 480R FRAME CRACKED AT AIR CONDITIONING RAIL BRACKET INBOARD HOLE. ACCOMPLSHED NESTED REPAIR PER ECO J1159AD.SDR AALA20120112TUL02Frame · crackedSTATION 500C FRAME CRACKED AT AIR CONDITIONING RAIL BRACKET INBOARD HOLE. ACCOMPLISHED NESTED ANGLE REPAIR PER ECO J1159AD.SDR USAA2011012690351Frame · crackedMIA - C22 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME AT BS 360, S15R. REPAIRED FUSELAGE FRAME AT BS 360, S15R IAW EA 139900.SDR CALA2011011700024Frame · corrodedB737-53-3-0306, ABB STA 907 BETWEEN S-27-LT & S-26-LT CORROSION ON FRAME. INSTALLED REPAIR DOUBLER ON STA 907 BETWEEN S-27 LT & S-26 LT REF SRM 53-00-07.SDR AALA20110114TUL04Frame · crackedAFT SIDE OF FRAME STATION 1418 CRACKED AT LONGERON 2 RIGHT. INSTALLED DOUBLER PER EA MD80-53-014820.SDR EE4Y1101031Frame · crackedDURING THE INSPECTION COOPESA FOUND THE AFT ACCESSORY COMPARTMENT CANTED STA 1463, -X8.5 OUTBOARD CHORD CRACKED. PERMANENT REPAIR WILL BE PERFORMED AS PER DER APPROVAL.SDR FDEA201101130130Frame · gougedAFT CARGO COMPT FRAME GOUGED AT STA 1480, BETWEEN STR 24R AND 25R, UPPER CHORD SPLICE. REMOVED PRODUCTION SPLICE FROM FRAME BS 1480, S24R/25R, SRM 51-40-02. GOUGES FOUND OUT OF LIMITS IAW SRM 53-00-07, FIG 101, DETAIL 2, PG. 103. NEW SPLICE FABRICATED ON TRSDR ASOA201100081Frame · corrodedCORROSION FOUND ON FS 349.00 FRAME, STR 26L IN MAIN AVIONICS COMPARTMENT. INSTALLED FRAME SECTOR IAW SRM 51-42-06 AND 51-42-21.SDR ASOA201100080Frame · corrodedCORROSION FOUND ON FS 333.00, STR 26L-26, IN MAIN AVIONICS COMPARTMENT. CORROSION OUT OF LIMITS IAW SRM 53-00-00. REMOVED FRAME IAW SRM 51-42-06 AND 51-42-21. LOCATED, DRILLED AND INSTALLED NEW FRAME IAW SRM CH 51-40-11, CH 51-42-06 AND CH 51-42-21.SDR ASOA201100079Frame · corrodedCORROSION FOUND ON FS 319, FRAME, STR 26L IN MAIN AVIONICS COMPARTMENT. LOCATED AND DRILLED NEW FRAME. INSTALLED FRAME IAW SRM CH 51-40-11, CH 51-42-06 AND 51-42-21.SDR DALA1102870197Frame · crackedRT FS 903, FRAME INNER CHORD CRACKED BETWEEN STR 20 & 21R AND REPAIRED IAW ERA 487046.SDR DALA1102860197Frame · crackedLT FS 903, FRAME INNER CHORD CRACKED BETWEEN STR 20 & 21 LT AND REPAIRED IAW ERA 480431-14.SDR COMA2011011350007Frame · crackedCRACK FOUND ON LEFT FS 640.00 FUSELAGE FRAME AT STRINGER 9L. COMPLIED WITH REO 601R-53-61-557. REMOVED DAMAGED SECTION OF 640 FRAME AND INSTALLED A DOUBLER AND FILLER.SDR ASAA1148956Frame · crackedFRAME CRACKED AT BS 867 BETWEEN STR 8R AND 9R. REPAIRED CRACKED FRAME IAW EA AD20062609 400 53 109 REV NEW DATED 28JAN11.SDR ASAA1148949Frame · crackedFRAME CRACKED AT BS 747 BETWEEN STR 8L AND 9L. REPAIRED CRACKED FRAME IAW EA AD20062609 400 53 109 REV NEW DATED 28JAN11.SDR ASAA1148948Frame · crackedFRAME CRACKED AT BS 747 BETWEEN STR 8R AND 9R. REPAIRED CRACKED FRAME IAW EA AD20062609 400 53 109 REV NEW DATED 28JAN11.SDR ASAA1148947Frame · crackedFRAME CRACKED AT BS 787 BETWEEN STR 8L AND 9L. REPAIRED CRACKED FRAME IAW EA AD20062609 400 53 109 REV NEW DATED 28JAN11.SDR ASAA1148946Frame · crackedFRAME CRACKED AT BS 787 BETWEEN STR 8R AND 9R. REPAIRED CRACKED FRAME IAW EA AD20062609 400 53 109 REV NEW DATED 28JAN11.SDR ASAA1148943Frame · crackedFRAME CRACKED AT BS 907 BETWEEN STR 8R AND 9R. REPAIRED CRACKED FRAME IAW EA AD20062609 400 53 109 REV NEW DATED 28JAN11.SDR ASAA1148942Frame · crackedFRAME CRACKED AT BS 907 BETWEEN STR 8R AND 9R. REPAIRED CRACKED FRAME IAW EA AD20062609 400 53 109 REV NEW DATED 28JAN11.SDR ASAA1148940Frame · crackedFRAME CRACKED AT BS 727F BETWEEN STR 8L AND 9L. REPAIRED CRACKED FRAME IAW EA AD20062609 400 53 109 REV NEW DATED 28JAN11.SDR ASAA1148939Frame · crackedFRAME CRACKED AT BS 727D BETWEEN STR 8R AND 9R. REPAIRED CRACKED FRAME IAW EA AD20062609 400 53 109 REV NEW DATED 28JAN11.SDR IPXA1564259Frame · dentedINSPECTION TYPE:C2, WHILE VISUALLY INSPECTING THE REPAIR AREA UNDER THE REPAIR ON CARD 917047 FOUND BS 1480 FRAME INNER FLANGE DENTED 5 INCHES BELOW STR 25L. REPAIRED IAW SRM 53-00-07-2R 5.SDR ASAA1178775Frame · wornFRAME WORN OUT OF LIMITS BS 654 - BS-674. REMOVED AND REPLACED FRAME IAW BOEING DRAWING 149A7214.SDR ZZDA2011038Fastener · shearedAFT ACCESSORY BULKHEAD FRAME CLIP HI-LOKS, SHEARED. ACCOMPLISHED FRAME CLIP HI-LOKS REPLACEMENT PER EA 17-53-03015A.SDR DALA1102609855Frame · corrodedAFT CARGO COMPARTMENT BS 1151, BETWEEN L29L & L29R FRAME HAS CORROSION ON LOWER FWD SIDE. REMOVED COROSION IAW SRM 51-10-3, LOSS OUT OF LIMITS IAW SRM 53-01. CUT OUT DAMAGED SECTION OF FRAME FROM L25R-L29L. RECEIVED LOCATED & INSTALLED REPAIR IAW SRM 53-03 FSDR SWAA110206Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 867, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME PER EA.SDR SWAA110195Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 500B, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR COEA2011011212805Frame · corrodedHEAVY CHECK COE / MAJOR REPAIR/ LEVEL 2 CORROSION: FOUND EVIDENCE OF LEVEL 2 CORROSION AT FRAME 41 BETWEEN STRINGER 16R AND 17R. BLENDED CORROSION ON FR 41 BETWEEN STR 16-17R, OUT OF LIMITS. AWATING SRI FROM ATR.SDR AALA20110112TUL02Frame · corrodedAFT CARGO HAS CORROSION ON FRAME AT STATION 1271 NEAR LONGERON 30. INSTALLED J ANGLE DOUBLER PER AARD 53-10-00-14 FIGURE 1 SHEET 1.SDR FDEA201101120108Frame · crackedMAIN DECK CARGO COMPARTMENT, WITH REF TO EO NR6-5310-7-5006A1, PART 2, PAGE 21 OF 48 STEP 79, FRAME 44 RT HOLE B ABOVE STRINGER 26 FOUND WITH CRACK INDICATION. REPAIR CARRIED OUT PER EO NR 6-5310-7-5006 A1 PART 2. THIS REPAIR IS CLASSIFIED AS MAJOR PER GMM 6SDR FDEA201101120107Frame · crackedMAIN DECK CARGO COMPARTMENT, WITH REF TO EO 6-5310-7-5006A1 PART 1, PAGE 21 OF 48 STEP 79, FRAME 44 HOLE B ABOVE STRINGER 26, CRACK INDICATION FOUND. REPAIR CARRIED OUT PER EO NR 6-5310-7-5006 A1 PART 1. THIS REPAIR IS CLASSIFIED MAJOR PER GMM 6-2-100 REVISISDR USAA2011022190844Frame · crackedCLT - MAJOR REPAIR - Q1 CHECK - CRACKED FRAME AT BS 727B, S8R - S9R. REPAIRED FRAME AT BS 727B, S8R-S9R IAW EA 102559.SDR USAA2011022190843Frame · crackedCLT - MAJOR REPAIR - Q1 CHECK - CRACKED FRAME AT BS 787, S8L - S9L. REPAIRED FRAME AT BS 787, S8L-S9L IAW EA 102559.SDR USAA2011020990665Frame · crackedCLT - MAJOR REPAIR - Q1 CHECK - CRACK ON FRAME AT BS 727F, BETWEEN S8R TO S9R. REPAIRED FRAME AT BS 727F, BETWEEN S8R TO S9R IAW ENGINEERING AUTHORIZATION 102559.SDR ASAA1148955Frame · crackedFRAME CRACKED AT BS 480 BETWEEN STR 8L AND 9L. REPAIRED CRACKED FRAME IAW EA AD20062609 400 53 109 REV NEW DATED 28JAN11.SDR ASAA1148954Frame · crackedFRAME CRACKED AT BS 440 BETWEEN STR 8R AND 9R. REPAIRED CRACKED FRAME IAW EA AD20062609 400 53 109 REV NEW DATED 28JAN11.SDR ASAA1148953Frame · crackedFRAME CRACKED AT BS 440 BETWEEN STR 8L AND 9L. REPAIRED CRACKED FRAME IAW EA AD20062609 400 53 109 REV NEW DATED 28JAN11.
Back to JASC 5311