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 WRLA20100609382Frame · corrodedCORROSION - FRAME AND FLOOR STRUT AFT WASTE TANK COMPARTMENT BILGE AREA AT STA 1981, X=-3, NRC U05041 ISSUED.SDR FDEA201006091919Frame · damagedTOOLING DAMAGE LOCATED AT FR14, STRINGER 12L COMPLIED WITH REPAIR ON FR14 AT STR 12L IAW EA 6-5310-135211, BY SMOOTH REWORK AREA , PERFORMING DVI IAW NTM 51-10-08 ENSURING NO DAMAGE EXIST , PERFORMED ROTOTEST INSP IAW NTM 51-10-01, IMPROVED SURFACE ROUGHNESS SDR CALA2010061000265Beltframe · corrodedAFT CARGO COMPARTMENT - BELT FRAME EXFOLIATED ABOVE STR 26 RT STA 1520. REPAIRED BELT FRAME REF SRM 53-00-07 REPAIR 5. ISSUED DIP FOR REP INSPECTION REF 53-00-07 REPAIR 5 FIG 201 TABLE 2 ZONE 1 REQUIREMENTS. REINSPECT BELT FRAME REPAIR STA 1520 ABOVE STRINGSDR AALA20100608TUL09Frame · crackedLEFT ANGLE ON AFT SIDE OF STATION 1418 IS CRACKED AT LONGERON 2 RIGHT. INSTALLED FRAME DOUBLER AT STATION 1418 2 RIGHT PER SRM 53-03-00 FIGURE 31A.SDR AALA20100608TUL08Frame · crackedTHE 1418 FRAME CRACKED AT LONGERON 2 RIGHT. INSTALLED FRAME DOUBLER PER SRM 53-03-00 FIGURE 31A.SDR WRLA20100607415Frame · corrodedCORROSION - STA 1986 L50L TO L50R LOWER FRAME CORROSION, NRC U05111 ISSUED.SDR USAA2010062991299Frame · crackedMCN - C22 - MAJOR REPAIR - CRACKS ON FUSELAGE FRAME AT BS 847 BETWEEN S15R TO S27R. REPLACED FUSELAGE FRAME AT BS 847 BETWEEN S15R TO S27R IAW B737 SRM 51-40-02.SDR SWAA103326Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 482, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR SWAA103325Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 520, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR SWAA103316Frame · corrodedDURING SCHEDULED MV2 CHECK, FOUND FRAME CORRODED AT BS 767, BETWEEN STR 26R TO 25R. REPAIRED FRAME PER EA.SDR SWAA103315Frame Splice · corrodedDURING SCHEDULED MV2 CHECK, FOUND FRAME SPLICE CORRODED AT BS 747, BETWEEN STR 26L TO 25L. REPAIRED SPLICE PER EA.SDR SWAA103314Frame Splice · corrodedDURING SCHEDULED MV2 CHECK, FOUND FRAME SPLICE CORRODED AT BS 747, BETWEEN STR 27L TO 26L. REPAIRED SPLICE PER EA.SDR SWAA103313Frame Splice · corrodedDURING SCHEDULED MV2 CHECK, FOUND FRAME SPLICE CORRODED AT BS 747, BETWEEN STR 27R TO 23R. REPAIRED SPLICE PER EA.SDR SWAA103311Frame Splice · corrodedDURING SCHEDULED MV2 CHECK, FOUND FRAME SPLICE CORRODED AT BS 747, BETWEEN STR 23L TO STR 26R. REPAIRED SPLICE PER EA.SDR COMA2010060850126Frame · crackedFS 280.00 FRAME HAS A CRACK BY THE LOWER RADIUS AT RBL 11. REPAIRED LOWER ANGLE ON FS 280.00 FRAME AT RBL 11, IAW REO 601R-53-11-171 SCHEME B.SDR CALA2010060800253Frame · misrepairedSUPPORT TASK: 4 EACH FRAME TIES (P/N N22007-001) LOCATED AT BS 727E L/R AND BS 727D LT, EXISTING FASTENERS LOCATIONS DO NOT MEET MINIMUM EDGE DISTANCE COMPLIED WITH ECRA 5310-05206 REV.SDR SWAA103258Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 420, BETWEEN STR 14L TO STR 15L. REPAIRED FRAME PER AAR EA.SDR SWAA103256Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME PER EA.SDR SWAA103254Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER EA.SDR SWAA103253Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER EA.SDR SWAA103252Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER EA.SDR SWAA103251Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 360, STR 8R. REPAIRED FRAME PER EA.SDR SWAA103243Frame · corrodedDURING SCHEDULED 12Y CHECK, FOUND LT SIDE LANDING GEAR FUSELAGE SUPPORT FRAME CORRODED AT BS 695. REPAIRED FRAME PER AAR EA.SDR SWAA103242Frame · corrodedDURING SCHEDULED 12Y CHECK, FOUND RT SIDE LANDING GEAR FUSELAGE SUPPORT FRAME CORRODED AT BS 695. REPAIRED FRAME PER AAR EA.SDR SWAA103241Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 482, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR DALA1136379013Frame · unknownFUSELAGE OVERWING FRAMES REPAIRED IAW EA 09-460094-12, ME03.SDR CA100621004Frame · crackedDURING ROUTINE CABLE REPLACMENT THE FRAME HOLDING THE THROTTLE WAS FOUND CRACKED. MFG HAS BEEN MADE AWARE AND THE PART WAS REPLACED.SDR USAA2010070891365Frame · crackedMCN - C22 - MAJOR REPAIR - CRACK IN FUSELAGE FRAME WEB AT BS 303.9, BETWEEN S15L TO S17L FWD LT DOOR. REPAIRED FUSELAGE FRAME WEB AT BS 303.9, BETWEEN S15L TO S17L IAW ENGINEERING JOB CARD M1L53001.SDR FDEA201006041829Frame · damagedTV MONITOR SUPPORT BRACKET MOUNT HOLE ON FRAME AT STA 395 STR 2L ELONGATED. REPAIR WAS ACCOMPLISHED DUE TO DISCREPANCY EFFECTING THE PTF CONVERSION ON ST AEROSPACE MOBILE NR 43269370001 AND EA 757-5332-16-F2660. CLASSIFIED MAJOR REPAIR.SDR FDEA201006041828Frame · damagedFRAME AT STA 418, BETWEEN STR. 1 AND 2L HAS HOLES THAT WERE DISCOVERED TO BE OUT OF LIMITS WHEN PARTS WERE REMOVED ASSOCIATED WITH THE TV MONITOR BRACKET MOD. REPAIR ACCOMPLISHED PER EA 757-5332-16-F2660, REV A. CLASSIFED MAJOR REPAIR.SDR EE4Y100192Frame · corroded((EE4Y)) LOWER FUSELAGE AFT CARGO COMPARTMENT AT BSTA 1006, STR 20L, FRAME WITH CORROSION. (W/O Y10122, SUB JOB 1, ITEM 136).SDR COMA2010060450125Sill · corrodedCORROSION FOUND ON PAX DOOR LOWER SILL PLATE. REMOVED AND REPLACED PAX DOOR SILL DUE TO EXCESSIVE CORROSION, REF SRM 51-42-06, SRM 51-41-10 AND SRM 51-42-21.SDR GLBA20100604FFrame · crackedMAJOR REPAIR - DURING A SCHEDULED ROUTINE INSPECTION A CRACK IN THE FRAME AT FS 456 AND STRINGER 10R, FOUND IN THE STRINGER CUTOUT, .45" IN LENGTH. MAINTENANCE REPAIRED THE AFFECTED AREA AND PERFORMED ALL REQUIRED RII INSPECTIONS IAW EO 10-1900-53-029. MATERSDR SWAA103239Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FWD CARGO BAY FRAME CRACKED AT BS 500C, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR CALA2010060300246Frame · damagedAFT CARGO STA 847 O/B OF STR 25 RIGHT HAS TWO EACH NR 40 DRILL MARKS ON TOP OF FRAME. REPAIRED FRAME DAMAGE AT AFT CARGO STA 847 O/B OF STR 25 RIGHT.SDR SWAA103277Frame · crackedDURING SCHEDULED MV2 CHECK, FOUND FRAME CRACKED AT BS 767, BETWEEN STR 23L TO STR 23R. REPAIRED FRAME PER EA.SDR COMA2010060250121Frame · crackedFOUND CRACK AT RIGHT SIDE FS 640 FRAME AT STRINGER 9 CUT OUT. REMOVED DAMAGE AND INSTALLED REPAIR DOUBLER IN ACCORDANCE WITH REO 601R-53-61-557 REV A.SDR GLBA20100601GFrame · crackedMAJOR REPAIR - DURING A SCHEDULED ROUNTINE INSP, A CRACK WAS FOUND IN THE FRAME RADIUS, RT SIDE AT FS 451.0 AT STRINGER 10R, 1.0" IN LENGTH. MAINTENANCE REPAIRED THE AFFECTED AREA AND PERFORMED ALL REQUIRED RII INSPECTIONS I.A.W. EO 10-1900-53-026. MATERIALSSDR SWAA103172Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 482A, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR SWAA103157Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO FRAME CRACKED AT BS 500B, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER ER.SDR GLBA20100601HFrame · crackedMAJOR REPAIR - DURING A SCHEDULED ROUNTINE INSP, A CRACK WAS FOUND AT THE CUTOUT AT FS 177.35 AND STRINGER 5R, .2" IN LENGTH. MX REPAIRED THE AFFECTED AREA AND PERFORMED ALL REQUIRED RII INSPECTIONS IAW EO 10-1900-53-025. MATERIALS UTILIZED ARE INCLUDED IN THSDR GLBA06012010001Frame · crackedMAJOR REPAIR - DURING A SCHEDULED ROUNTINE INSP, A CRACK WAS FOUND AT THE CUTOUT AT FS 177.35 AND STRINGER 5R, .2" IN LENGTH. SUPLEMENTAL INFORMATION WILL BE SUBMITTED UPON COMPLETION OF THE REPAIR AND RETENTION OF THE PAPERWORK.SDR IPXA10560700Frame · damagedINSPECTION TYPE:C3, MAIN CARGO BAY FRAME INNER FLANGE HAS SCREW START AT BS 1580, STR 14L. REPAIRED IAW ATS ER NR 10-2996.SDR SWAA103280Frame Splice · corrodedDURING SCHEDULED MV2 CHECK, FOUND AFT CARGO FRAME SPLICE CORRODED AT BS 767. REPAIRED FRAME PER EA.SDR SWAA103279Frame · corrodedDURING SCHEDULED MV2 CHECK, FOUND FRAME SPLICE CORRODED AT BS 787, BETWEEN STR 23L TO STR 23R. REPAIRED FRAME PER EA.SDR SIMA201015803Frame · damagedDURING MAINTENANCE BASE VISIT FOUND FRAME NR 47 HAS ELONGATED HOLES ON RIGHT SIDE UNDER UPPER SEAT TRACK SUPPORT. THE AIRCRAFT WAS REMOVED FROM SERVICE. REPAIRED FRAME 47 IAW SRM 51-40-02, 51-20-03, 53-00-04 AND ETA EM-5300-1271. THE AIRCRAFT WAS RETURNED TSDR UALA2010060101875Frame · crackedFRAME CRACKED AT TENSION TIE ATTACH POINT STA 1160 LT SIDE. MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGED FRAME. HFEC. FABRICATED AND INSTALLED REPAIR PARTS IAW SRM.SDR UALA2010060101874Frame · crackedCRACK-TENSION TIE ATTACH FRAME HOLE AT STA 1140 RT. MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGED FRAME. FABRICATED AND INSTALLED REPAIR PARTS IAW SRM.SDR SWAA103151Frame · corrodedDURING SCHEDULED MV2 CHECK, FOUND FRAME CORRODED AT BS 847, BETWEEN STR 17R TO STR 27R. REMOVED AND REPLACED FRAME PER ACO.SDR MASA2010071200752Frame · crackedIN-SERVICE DEVIATION FOR LT FS 640 FRAME CRACK ON FWD FACE ABOVE ENGINE SUPPORT BEAM (BETWEEN STRINGER 9 AND 12), JOB 5 OP (LINKED TO JOB 5 OP 151).
Back to JASC 5311