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 USAA920071000Frame · crackedCLT - MAJOR REPAIR - C20 CHECK, CRACKED FRAME, BS 827, S8L - S9L. REPAIRED FRAME, BS 827, S8L - S9L IAW USAIRWAYS EA 98915 AND TYPICAL REPAIR 53-10-20E.SDR SWAA075069Frame · corrodedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 360, STR 28L. REPAIRED FRAME PER SRM.SDR UPS07551054Frame · dentedINSPECTION TYPE:C DENT IN AFT CARGO FUSELAGE FRAME STA 1340, BET WEEN S25R AND S26R (2EA). ACCOMPLISHED REPAIR PER FINAL EA 757-5330-A1756 AND UPS EO B757-5310-27941-A.SDR UPS07551053Frame · dentedINSPECTION TYPE:C DENT IN FWD CARGO COMPARTMENT FUSELAGE FRAME STA 660, S24R AND S25R. ACCOMPLISHED REPAIR ON FINAL EA 757-5330-27-A1755 AND UPS EO B757-5310-27937A.SDR UPS07551051Frame · dentedINSPECTION TYPE:C DENT IN FWD CARGO COMPARTMENT FUSELAGE FRAME STA 760, S22L TO S23L. REPAIRED FRAME DENT STA 760L IAW SRM 53-00-07 T/E 53-09. PER DETAIL II FIG 201 SHEET 5 OF 15. RE-INSPECTION PER SRM 53-00-07 T/E 53-09 DETAIL IV ZONE 1 FIG 201 SHEET 11 OFSDR ASAA0742101Frame · crackedMAIN CABIN STA 440 BETWEEN STR 8R AND 9R FRAME CRACKED AT HAT BIN ATTACH BRACKET POINT. CUT OUT DAMAGE AREA IAW SRM 53-00-7 NOT VERIFIED CRACKED CONTAINED IAW 737 NDT MANUAL PART 6 CH 51 00 00 FIG 23. REPAIRED IAW B737 400 SRM 53-00-7 DETAIL II.SDR USAA920071206Frame · crackedCLT - MAJOR REPAIR - C16 CHECK, CRACKED FRAME, BS 867, S8R - S9R. REPAIRED FRAME, BS 867, S8R - S9R IAW USAIRWAYS TYPICAL REPAIR 53-10-20E.SDR USAA920071205Frame · crackedCLT - MAJOR REPAIR - C16 CHECK, CRACKED FRAME, BS 867, S8L - S9L. REPAIRED FRAME, BS 867, S8L - S9L IAW USAIRWAYS TYPICAL REPAIR 53-10-20E.SDR DLM88071475Frame · crackedFOUND CRACKED ANGLES ON FRAME AT STA Y=1463 AFT SIDE. REPLACED ANGLES PER SRM 53-14-4.SDR DU4R2007177Frame · dentedFOUND DENTED FRAME AT BS 1500 S-26L (IN AFT PIT). REPAIRED BY REMOVING DOUBLER AND STRINGER TIES, FABRICATED AND INSTALLED DOUBLER REPAIR CHANNEL 21-1/2 BY 2-1/2 BY 1 FROM 7075-T6 .080 IAW B757 SRM 51-40-02, 51-40-05 AND 51-00-00D.
SDR DU4R2007176Frame · dentedFOUND DENTED FRAME AT BS 1520 S-26L (IN AFT PIT). REPAIRED BY REMOVING DOUBLER, FABRICATED AND INSTALLED DOUBLER REPAIR CHANNEL 21-1/2 BY 2-1/2 BY 1 FROM 7075-T6 .080 IAW B757 SRM 51-40-05, 51-20-01 AND 51-40-02.SDR USAA920070938Frame · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 6505051, CRACKED FRAME, BS 907, S9R. REPAIRED FRAME, BS 907, S9R IAW USAIRWAYS EA 120272.SDR USAA920070937Frame · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 6504947, CRACKED FRAME, BS 807, S9R. REPAIRED FRAME, BS 807, S9R IAW USAIRWAYS EA 120272.SDR USAA920070936Frame · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 6504946, CRACKED FRAME, BS 767, S9R. REPAIRED FRAME BS 767, S9R IAW USAIRWAYS EA 120272.SDR USAA920070935Frame · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 6504945, CRACKED FRAME, BS 480, S9R. REPAIRED FRAME, BS 480, S9R IAW USAIRWAYS EA 120272.SDR USAA920070934Frame · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 6504944, CRACKED FRAME, BS 440, S9R. REPAIRED FRAME, BS 440, S9R IAW USAIRWAYS EA 120272.SDR USAA920070933Frame · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 6505053, CRACKED FRAME, BS 847, S9L. REPAIRED FRAME, BS 847, S9L IAW USAIRWAYS EA 120272.SDR USAA920070932Frame · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 6505052, CRACKED FRAME, BS 827, S9L. REPAIRED FRAME, BS 827, S9L IAW USAIRWAYS EA 120272.SDR USAA920070931Frame · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 6505054 AND 6505050, CRACKED FRAME, BS 887, S9L AND S9R. REPAIRED FRAME, BS 887, S9L AND S9R IAW USAIRWAYS EA 120272.SDR MWEA070244Block · corrodedCORROSION ON FRAME TO STRINGER TIE RADIUS BLOCKS AT CANTED FRAME STATION 1446 AT STRINGER 12 LEFT & 14 LEFT. REMOVED DAMAGE, FABRICATED AND INSTALLED RADIUS BLOCK.SDR ASAA0742100Frame · crackedMAIN CABIN STA 380 RT AT STR 8 & 9 FRAME HAS CRACK AT OVERHEAD BIN BRACKET HOLE. REMOVED DAMAGE AREA NOT VERIFIED CRACK CONTAINED IAW 737 NOT MANUAL PART 6 CH 51-00-00 FIG 23. REPAIRED AREA IAW SRM 53-00-7 FIG 201 B737 400.SDR ASAA0742099Frame · crackedMAIN CABIN STA 400 BETWEEN STR 8R AND 9R FRAME CRACKED AT HAT BIN ATTACH BRACKET POINT. REMOVED DAMAGED AREA IAW B737 400 SRM 57 00 7 NDT VERIFIED NO CRACK. IAW B737 NOT MANUAL PART 6 CH 51-00-00 FIG 23. FABRICATED AND ATTACHED REPAIR PARTS IAW B737 400 SRM.SDR CALA0700581Frame · corrodedSTA 227 LBL 5 TO RBL 5 FRAME CORRODED. REPAIR ACCOMP PER ECRA 5311-01366.SDR 07FDEA04574Frame · crackedDURING MD10 ACF MODIFICATION, FOUND CRACK 4.5" LONG ON THE FRAME AT STA 1801 TO NEXT STR 13 RT SIDE AND 2 RIVET MISSING ON THE SPLICE FO. PERFORMED REPAIR FOR SRM 53-30-00 FIG 5 VOL I. INSTALLED RIVETS FOR SRM 51-35-01.SDR 07FDEA04573Frame · crackedDURING MD10 ACF MODIFICATION, FOUND CRACK 4,5" LONG ON THE FRAME AT STA 1781 TO STRINGER 13 LT PERFORMED REPAIR FOR SRM VOL I 53-30-00 FIG 5.SDR DHL2007748017Frame · dentedFRAME DENTED AT BS 990 JUST ABOVE STRINGER 27L. CUT DAMAGE AREA AT BS 990 ABOVE STRINGER 27L DIMENSION 1" BY .75" IAW B-727 SRM 51-40-3 FIGURE 1. FABRICATED FRAME REPAIR FROM 7075-O PO NR 9004690 DIMENSION 9" BY 4" IAW B-727 SRM 51-40-3 FIGURE 1. HEAT TREATSDR 12117Frame · corrodedFOUND FRAME 44 BETWEEN STRINGERS LEFT AND RIGHT 21 CORRODED. CORROSION REMOVED AND FOUND TO BE BEYOND MANUFACTURERS LIMITS. FRAME 44 REPAIRED IN ACCORDANCE WITH SRM 53-81-40 FIGURE 403.SDR ZZDA2007282Frame · crackedAFT ACCESSORY COMP CANTE FRAME CRACKED, FS 1178 BELOW LONG 17 LT. INSTALLED FORMED ANGLE REPAIR PER SRM 51-70-11.SDR ZZDA2007281Frame · crackedAFT ACCESSORY COMP CANTE FRAME CRACKED FS 1178 BELOW LONG 17 RT. INSTALLED FORMED ANGLE REPAIR PER SRM 51-70-11.SDR MALA070137Frame · crackedDURING WORK ON RT WRAP AROUND FOUND FRAME AT STA 294 CRACKED AT RBL 18.3. INSTALLED REPAIR DOUBLER ON FRAME AT STA 294 RBL18314W EO NR S53132.SDR 0700571Frame · crackedFWD CARGO LWR FRAME HAS CORROSION ON FED SIDE AT STA 500D LBL 16 TO LBL 21. REPLACED FWD CARGO LWR FRAME PER SRM 53-00-07.SDR 07FDEA04563Frame · chafedNR 1 AIR CONDITIONING COMPT BYPASS VALVE PUSH-PULL CABLE CHAFING AGAINST FRAME TOP CHORD STA 588. REPAIRED FRAME IAW EA 8-5310-10920B, FUSELAGE-AIR CONDITIONING BAY FRAME CHAFED. ON INNER FLANGE-REPAIR.SDR GLBA20061010Angle · crackedRT HEAVY ANGLE CRACKED AT FS 288. MAINTENANCE REPAIRED THE RIGHT HAND HEAVY ANGLE AT FS 288 IAW BEECH 1900D SRM 53-90. REPAIR DIMENSIONS 13.5.
PN 114-430002-7180. RII INSPECTION COMPLIED WITH PER TASKCARD 8.2.1.
SDR USAA920070971Frame · crackedCLT - MAJOR REPAIR - FPBH INSPECTION, FORWARD CARGO COMPARTMENT DOOR CUTOUT AFT FRAME CRACKED, BS 492, S24R. REPAIRED FORWARD CARGO COMPARTMENT DOOR CUTOUT AFT FRAME, BS 492, S24R IAW USAIRWAYS EA 98913.SDR 0700568Frame · crackedUPPER FRAME SECTION STA 440 STR 17R-14R HAS CRACK AT FASTENER HOLE. REPLACED UPPER FRAME AT STA 440 IAW SRM 51-40-02.SDR 2007UALA04102Frame · damagedCABIN CREASE BEAM CUT TO FACILITATE FRAME REPLACEMENT AT BS 452. MAJOR REPAIR: FABRICATED AND INSTALLED REPAIR SPLICE.SDR USAA920070922Frame · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 6504625, FORWARD CARGO COMPARTMENT DOOR CUTOUT FORWARD FRAME CRACKED, BS 442, S25R. REPLACED FORWARD CARGO COMPARTMENT DOOR CUTOUT FORWARD FRAME , BS 442, S25R IAW B737-300 SRM 51-40-02.SDR DLM90071323Frame · crackedAFT ACC BAY STA 1542 CANT FRAME IS CRACKED RT JUST O/B OF AIRSTAIR CUTOUT. REPAIRED FRAME IAW MD90 SRM 51-70-01 FIG 1.SDR ABXR070398Frame · crackedFRAME CRACKED AT STA 897, LONGERON 12 RIGHT. REPAIRED FRAME AT STA 897, LONGERON 12 RIGHT IAW DC9 SRM 53-03.SDR ASAA0782079Frame · crackedFRAME CRACKED. REPLACED FRAME PER SRM 53-03.SDR SWAA074988Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA074990Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA074991Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA074989Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA074987Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L AND STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA074986Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME PER SWA EA.SDR USAA920070904Strap · crackedCLT - MAJOR REPAIR - C-4 CHECK, CRACKED FRAME STRAP, BS 312, S13L. REPLACED FRAME STRAP, BS 312, S13L IAW BOEING DRAWING 65-17684.SDR ZZDA2007278Frame · crackedTWO EACH CRACKS, BOTH 1 INCH LONG IN RADIUS OF CANTE FRAME LEFT SIDE STA 1178 LONG 16 LEFT. INSTALLED FORMED ANGLE REPAIR PER SRM 51-70-11 F-201.SDR KCSA071443Frame · crackedSTA 1920 FRAME IS CRACKED 1 INCH BETWEEN STR 41L AND STR 42L.SDR MWEA070235Frame · chafedAFT FUSELAGE CANTED FRAME STATION 1497 IS CHAFED AT LOWER RIGHT SIDE. CUT OUT DAMAGE AND FABRICATED AND INSTALLED DOUBLER.
Back to JASC 5311