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 SWAA060200Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 613, LBL 65. REPAIRED FRAME PER SWA TRM.SDR SWAA060199Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 613, RBL 65. REPAIRED FRAME PER SWA SRM.SDR USAA060058Frame · crackedFOUND FRAME CRACK STA 480 FRAME AT LT PSU RAIL SUPPORT. INSTALLED REPAIR DOUBLERS IAW TR 53-10-20C, DEFECT SIZE: .25".SDR USAA060054Frame · tornFWD CARGO DOOR CUT-OUT FWD FRAME, FABRICATED WEB REPAIR PER SRM 51-70-13 FIG 1, DEFECT SIZE: .125.SDR USAA060065Frame · crackedFOUND FRAME CRACKED STA 440 AT RT PSU SUPPORT RAIL. INSTALLED FILLER AND DOUBLERS IAW TR 53-10-20C, DEFECT SIZE: .250" CRACK.SDR USAA060033Frame · crackedFOUND FRAME CRACKED STA 787 FRAME BETWEEN S8L AND S9L. REPAIRED AND INSTALLED DOUBLER IAW TR 53-10-20C, DEFECT SIZE: .125".SDR USAA060034Frame · crackedFOUND FRAME CRACKED 827 S9R AT I/B PSU SUPPORT BRACKET RIVET. INSTALLED DOUBLER IAW 53-10-20-C, DEFECT SIZE: .500".SDR USAA060035Frame · crackedFOUND FRAME 787 CRACKED AT I/B PSU SUPPORT RIVET S9R. INSTALLED REPAIR ANGLES PER TR 52-10-20C, DEFECT SIZE: .500".SDR ASAA0640040Frame · corrodedPAE - FOUND CORROSION ON BS 794, FRAME BETWEEN STRINGER 23R-26R. REMOVED AND REPLACED FRAME AT BS 794, BETWEEN STRINGERS 16 TO 26 RT, IAW B737-400 SRM 51-40-02. (M)SDR IXXA06SMN050SFrame · corrodedDURING C-CK, ALT CARGO MPT FRAME CORRODED STA 13.000 L.35R L.35 L.. PERFORMED REPAIR. REMOVED FASTENERS. REMOVED CORROSION. FOUND OUT OF LIMITS. TRIMMED OUT CORRODED FRAME SEGMENT. FABRICATED NEW FRAME SEGMENT, FABRICATED ANGLE & SPLICE IAW SRM. CLEANED, TRSDR SWAA060189Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT FWD CARGO DOOR CUTOUT, BS 452, STR 24R. REPAIRED FRAME PER SWA EA.SDR QXEA200600182Frame · crackedPDX: FRAME X196.00 HAS A CRACKED FLANGE AT CUTOUT FOR STR 25. MAINTENANCE REPAIRED IAW RD 8/4-53-017 AND NDTM PART 6, 51-00-02.SDR SWAA060164Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482A, STR 20R. REPAIRED FRAME PER SWA EA.SDR SWAA060163Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482A, STR 20L. REPAIRED FRAME PER SWA EA.SDR ASAA0640029Frame · crackedOKC - FOUND CABIN FUSELAGE FRAME AT BS 294.5 CRACKED BETWEEN STRINGER 2 AND 3 LEFT. REMOVED AND REPLACED FRAME SECTION IAW B737-400 SRM 51-10-02 AND 51-40-02 FIGURE 8. (M)SDR QXEA200600351Frame · misinstalledYYC - C3 FUSELAGE INTERIOR RIGHT HAND FRAME AT FUSELAGE STATION 517, BELOW STRINGER 9 HAS RIVET POORLY INSTALLED-SKIN TO FRAME. REPLACED RIVET IAW CRJ700 SRM 51-42-06-001-001-A01.SDR QXEA200600338Frame · misinstalledYYC - C3 FUSELAGE INTERIOR FRAME AT FUSELAGE STATION 797, STRINGER 14R HAS POORLY INSTALLED RIVET FOR INTERCOSTAL. REPLACED RIVET IAW CRJ700/900 SRM 51-42-21-001-001-A01.SDR AWXA200600379Frame · corrodedMCN - DURING C24 CHECK DISCOVERED LEVEL 2 CORROSION ON FRAME AT BS 1006 AND BL 0. MAINTENANCE REMOVED DAMAGE FROM FRAME AT BS 1006 IAW BOEING 737-300 SRM 53-00-07-2R5. FABRICATED DOUBLER AND FILLER IAW BOEING 737-300 SRM 53-00-07-2R5. INSTALLED FABRICATED RSDR ABXA060064Frame · crackedLEFT FORWARD MAIN FRAME FS 699, FORWARD FLANGE CRACKED AT PT J AND AFT FLANGE CRACKED PTS H-I. REMOVED AND REPLACED MAIN FRAME AT FS 699 LEFT IAW JC EA 53400321-001-2.SDR C2XA006SH005Frame · corrodedSHV - DURING C-CHECK FRAME 22 WAS FOUND TO BE CORRODED BETWEEN STRINGER 15 RIGHT AND 16 RIGHT. MAINTENANCE REMOVED THEN DAMAGED AREA AND INSTALLED A SPLICE REPAIR IAW EC 5320-01282. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR 06FDEA0159Frame · dentedAFT CARGO BAY FRAME IS DENTED AT BS 1030, ABOVE STR 26R. REPAIRED FRAME BS 1030 ABOVE STR 26R IAW SRM 51-40-3.SDR MALA060028Frame · damagedDURING 4K2Y BRIDGE CHECK VISIT DAMAGE WAS FOUND ON THE RIGHT FRAME AT STA 686.883. THE DAMAGE WILL BE REPAIRED IAW MESABA EO S53335 ON MM409 262835.SDR SWAA060132Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SWA EA.SDR AT0700046Frame · crackedTWO CRACKS ON FUSELAGE CANTED FRAME STA 1178.225 BETWEEN LONGERON 16L AND 18L. INSTALLED ANGLE REPAIR AND FILLER AT FS CANTED FRAME STA 1178.225, BETWEEN LONGERON 16L AND 18L IAW B717 SRM 51-70-11 FIG 201. MATERIAL USED 7075-0-0.80, 15.5 X 2.5 AND 7075 T6 .0SDR ASAA0640019Frame · corrodedCORROSION ON FWD CARGO BAY AT BSTA 500C BETWEEN STR 28L AND 28R AND STR 28R SHEAR TIE HAS CORROSION AT LWR FASTENER TO SKIN. REPAIRED FRAME AT BSTA 500C BETWEEN STRINGERS 28L AND 28R IAW SRM. (K)SDR ASAA0640016Frame · corrodedFWD CARGO BAY STA 500D BETWEEN STRINGERS 28L AND 28R SHEAR TIE CORRODED. REPAIRED FWD CARGO BAY STA 500D FRAME BETWEEN STR 28L AND 28R SHEAR TIE. (K)SDR USAA060013Frame · crackedFOUND CRACK STA 440, S-8L. FABRICATED ANGLES FROM NR 1133534 AND 1133533, INST DOUBLERS IAW TR 53-10-20C, DEFECT SIZE: 0.25" CRACK.SDR USAA060007Frame · defectiveBS 639 FRAME AT OVERWING DOOR STOP LT SIDE, DEFECTIVE PART REPLACED WITH IDENTICAL PART:ORDERED "T" ANGLE 1717710 STOCK, FAB`D REPLACED IAW DWG65-46450, DEFECT SIZE: 1.5 INCH BY 1.5 INCH MISSING T-ANGLE (MISSING SINCE MANUFACTURE).SDR USAA060006Frame · crackedFOUND CRACK BS 727F BETWEEN S-8R AND S-9R AT AIRCONDITIONAL ATTACH BRACKET. CUTOUT DAMAGED AREA, FABRICATED AND INSTALLED REPAIR ANLGE IAW TR 53-10-20C, DEFECT SIZE: APPROX 1/2" CRACK.SDR USAA060014Frame · crackedFOUND FRAME CRACKED STA 907, BELOW S-8L. FAB`D FROM ANGLES NR 1133534 AND 1133533. INSTALLED DOUBLERS IAW TR 53-10-20C, DEFECT SIZE: FRAME CRACKED 0.25".SDR USAA0613Frame · crackedSTA 440, S-8L CRACKED. FABRICATED ANGLES FROM 1133534 & 1133533, INSTALLED DOUBLERS IAW TR 53-10-20C, DEFECT SIZE: 0.25 INCH CRACK.SDR USAA068Frame · defectiveBS 639 FRAME & OVERWING DOOR STOP RIGHT SIDE DEFECTIVE. PART REPLACED WITH IDENT PART: ORDERED T-ANGLE 1717710 STOCK FAB & INSTALLED PER DWG 65-46450, DEFECT SIZE: 1.5 INCH BY 1.5 INCH MISSING T-ANGLE (MISSING SINCE MANUFACTURE).SDR USAA067Frame · defectiveBS 639 FRAME AT OVERWING DOOR STOP LT SIDE DEFECTIVE. DEFECTIVE PART REPLACED WITH IDENTICAL PART: ORDERED T- ANGLE 1717710 STOCK,FAB REPLACED IAW DWG65-46450, DEFECT SIZE: 1.5 INCH BY 1.5 INCH MISSING T-ANGLE (MISSING SINCE MANUFACTURE).SDR USAA066Frame · crackedBS 727F BETWEEN S-8R & S-9R AT AIR CONDITION ATTACH BRACKET CRACKED. CUT OUT DAMAGED AREA, FABRICATED AND INSTALLED REPAIR ANGLE IAW TR 53-10-20C, DEFECT SIZE: APPROX .5 INCH CRACK.SDR USAA0614Frame · crackedSTA 907, BELOW S-8L CRACKED. FAB FROM ANGLES 1133534 & 1133533, INSTALLED DOUBLERS IAW TR 53-10-20C, DEFECT SIZE: FRAME CRACKED 0.25 INCH.SDR USAA058Frame · damagedBS 639 FRAME & OVERWING DOOR STOP RT SIDE. PART REPLACED WITH IDENT PART: ORDERED T-ANGLE 1717710 STOCK FAB & INSTALLED PER DWG 65-46450, DEFECT SIZE: 1.5 INCH BY 1.5 INCH MISSING T-ANGLE (MISSING SINCE MANUFACTURE).SDR USAA057Frame · damagedBS 639 FRAME AT OVERWING DOOR STOP LT SIDE. DEFECTIVE PART REPLACED WITH IDENTICAL PART: ORDERED T-ANGLE 1717710 STOCK, FAB REPLACED IAW DWG65-46450, DEFECT SIZE: 1.5 INCH BY 1.5 INCH MISSING T-ANGLE (MISSING SINCE MANUFACTURE).SDR USAA056Frame · crackedBS 727F BETWEEN S-8R & S-9R (AT AIR CONDITION ATTACH BRACKET) CRACKED. CUT OUT DAMAGED AREA, FABRICATED AND INSTALLED REPAIR ANGLE IAW TR 53-10-20C, DEFECT SIZE: APPROX .5 INCH CRACK.SDR USAA0514Frame · crackedSTA 907, BELOW S-8L CRACKED. FAB FROM ANGLES 1133534 & 1133533, INSTALLED DOUBLERS IAW TR 53-10-20C, DEFECT SIZE: FRAME CRACKED 0.25 INCH.SDR USAA0513Frame · crackedSTA 440, S-8L CRACKED. FABRICATED ANGLES FROM NR 1133534 AND 1133533, INSTALLED DOUBLERS IAW TR 53-10-20C, DEFECT SIZE: 0.25 INCH CRACK.SDR C2XA06TY006Casting · crackedMAIN DOOR FRAME STRUCTURE UPPER FWD STOP HOLE IS CRACKED (TOP INBOARD HOLE). REMOVED AND REPLACED CASTING FOR UPPER FWD PAX DOOR STOP IAW EMB 145 SRM 51-40-02.SDR MWEA060005Frame · crackedCRACK FOUND ON FRAME AT STATION 389 WHERE IT ATTACHES TO LONGERON 17 RIGHT. FABRICATED AND INSTALLED DOUBLER AND FILLER.SDR AWXA200600378Frame · crackedMCN - DURING C24 CHECK DISCOVERED MAIN CABIN FRAME AT BS 663 CRACKED .5 INCHES IN LENGTH AT STR 2R. MAINTENANCE ROUTED OUT DAMAGED AREA IAW BOEING 737-300 SRM 53-00-07-2R9 FIG 201. FABRICATED REPAIR ANGLE, FILLERS, AND STRINGER TIE IAW BOEING 737-300 SRM 53-SDR AWXA200600323Frame · crackedMCN - DURING C24 CHECK DISCOVERED MAIN CABIN FRAME AT BS 616 CRACKED, 2.2 INCHES, AT RT SIDE BOTTOM END, UNDER MAIN CABIN FLOOR AT BL 60R AND WL 200. MAINTENANCE REMOVED DAMAGED AREA FROM BS 616 FRAME IAW AMERICA WEST AIRLINES (AWA) ENGINEERING REPAIR (ER) NOSDR UPS06846114Frame · crackedINSPECTION TYPE:C1 TAIL SEC 60 COMPT AFT PRESSURE BULKHEAD STA 1766 3RD "J" FRAME FROM BOTTOM HAS A 3" CRACK AT C/L. STOP DRILLED CRACK, FABRICATED AND INSTALLED 2 ANGLES, 4 CLIPS, 4 SHIMS AND WASHERS IAW SRM51-1-21,53-2-5 FIG 26, AND 51-1-20D.SDR 06FDEA0116Frame · damagedFASTENER HOLES IN STUB FRAME HAVE SHORT SPACING AND EDGE MARGIN BS 609 LBL 22. *S/D* WORK ACCOMPLISHED.SDR 06FDEA0129Frame · tool damageBS 460 STR 3L FWD FRAME SEGMENT HAS DRILL START. REPAIRED PER FED EX EA 7-5330-98634.SDR 06FDEA0127Frame · misdrilledN01356, BS 620 LBL 23 FWD FRAME SEGMENT HINGE HOLE HAS LESS THAN 2D EDGE MARGIN. (HINGE HOLE SIZE .375 EDGE MARGIN .500).SDR 06FDEA0120Frame · misdrilledN01348, BS 620 LBL 26 BOTH FRAME HALVES HAVE DRILL STARTS COMMON TO OEM SKIN. COMPLIED WITH FED EX EA 7-5310-98573.SDR 06FDEA0117Frame · mismanufacturedN01345 FASTENER HOLES IN STUB FRAME HAVE SHORT SPACING AND EDGE MARGIN BS 611.5, LBL 22.
Back to JASC 5311