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 USAA060819Frame · dentedBS 827 BELOW S-24L DENTED. INSTALLED REPAIR ANGLES IAW TR 53-60-07, DEFECT SIZE: .040 INCH.SDR USAA060826Frame · crackedSTA 616 FRAME ABOVE S-17R CRACKED. REMOVED DAMAGE AND INSTALLED REPAIR ANGLE AND FILLER IAW TR 53-62-01, DEFECT SIZE: 1 INCH.SDR SIMA200616719Frame · bentDURING MBV, FOUND FRAME 72 BENT JUST ABOVE FLOOR LEVEL ON LEFT SIDE OF BAGGAGE COMPARTMENT. REPAIRED FRAME 72 IAW SRM 53-00-04 FIGURE 201 BY CUTTING OUT DAMAGE AND SPLICING IN A NEW PIECE OF FRAME. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR SWAA062045Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727E, STR 26L. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR 2006UALA01150Frame · bentAFT PIT, BS 827 BETWEEN STRINGERS 24L AND 25L FRAME BENT ON INNER FRAME RADIUS.SDR USAA060811Frame · crackedTHE 827 FRAME S9L AT PSU SUPPORT BRACKET I/B RIVET CRACKED. REMOVED DAMAGE, INSTALLED DOUBLERS IAW TR 53-10-20D, DEFECT SIZE: .125 INCH.SDR USAA060810Frame · crackedRIVET STA 907 BETWEEN STA 8 AND 9 OVERHEAD LOWER ATTACH POINT CRACKED. CUT OUT CRACK DAMAGE, FABRICATED DOUBLER ANGLES IAW SRM 53-20-10D, DEFECT SIZE: .25 INCH.SDR SWAA062026Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 500C, STR 26L. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR 2006UALA01139Frame · crackedFOUND PASSENGER CABIN OVERWING FRAME CHORD WEB AT BS 616R WL 202 CRACKED.SDR 2006UALA01135Frame · crackedFOUND FWD CABIN FRAMES AT STA 400 AND 440 BETWEEN STR 8R AND 9R FRAME CRACKED.SDR AWXA200600918Frame · crackedMCN - MAJOR REPAIR - DURING C19 CHECK DISCOVERED FRAME CRACKED, .25 AND .80 INCHES, AT STA 440 AND STR 24 RIGHT BELOW DOOR STOP FITTING. MAINTENANCE REPAIRED CRACKED FRAME AT STA 440 AND STR 24R BELOW DOOR STOP FITTING BY CUTTING OUT DAMAGED AREA AND INSTALLISDR SWAA061986Angle · crackedDURING SCHEDULED 20Y CHECK, FOUND STUB FRAME ANGLE CRACKED IN RADIUS AT BS 348, STR 16L. REMOVED AND REPLACED ANGLE PER SRM.SDR AWXA200601065Sill · corrodedDURING C17 CHECK DISCOVERED LEVEL 2 EXFOLIATION CORROSION ON THE L2 DOOR SILL CHORD IN SEVERAL PLACES AT BS 947.5 TO BS 986.5 AT STR 17L. CORROSION WAS FOUND TO BE OUT OF LIMITS IAW BOEING 737-300 SRM 53-60-15-1A1 FIG 101. MAINTENANCE REMOVED AND INSTALLED NSDR 2006UALA01121Frame · crackedBS FRAME 616R CRACKED AT LOWER FASTENER TO EDGE OF FRAME AT WL 200.SDR 2006UALA01117Frame · crackedFUSELAGE FRAME CRACKED AT STA 787 & 907 STR 8R OUT OF FASTENER HOLE.SDR 06FDEA2256Frame · misdrilledDOUBLE HOLE AT BS 600 STR 21L. COMPLIED WITH FED EX EA 7-5310-102255.SDR 06FDEA2255Frame · misdrilledDOUBLE HOLE AT BS 520 STR 21L. COMPLIED WITH FED EX EA 7-5310-102255.SDR 06FDEA2254Frame · misdrilledDOUBLE HOLE AT BS 500 STR 21L. COMPLIED WITH FED EX EA 7-5310-102255.SDR A6WA200640239Frame · damagedOVERSIZED HOLE ON THE LEFT SIDE FUSELAGE AT STRINGER 10L FRAME STATION 640. MAINTENANCE REPAIRED OVERSIZE HOLE BY TRIMMING OUT SKIN AND FABRICATING AND INSTALLING FILLER IAW BOMBARDIER SERVICES EO 601R-53-9303. (M)SDR QXEA200601640Frame · corrodedPDX: MCK FRAME FOR ENTRY WAY PANEL 131CZ, THE FRAME HAS CORROSION ON TOP AND BOTTOM UNDER NUTPLATES. MAINTENANCE REPAIRED IAW Q400 NDTM PART 6, 51-00-01-250-801, NDTM PART 1, 51-00-04, HORIZON EA 6-53-745 AND Q400 SRM 51-42-05.SDR 2006UALA01111Frame · crackedFRAME HAS A CRACK OUT OF FASTENER HOLES OF AC RAIL SUPPORT STA 747 S8R.SDR SWAA061957Beltframe · corrodedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE BELT FRAME CORRODED AT BS 747, STR 26R. REPAIRED FRAME PER SRM.SDR USAA060785Frame · crackedAT 787 FRAME S9L AT PSU CRACK. INSTALLED DOUBLER REPAIR IAW SRM 53-10-20, DEFECT SIZE: .375 INCH.SDR USAA060780Frame · crackedBS 794.3 BETWEEN S-12R AND S-22R CRACKED. REMOVED DAMAGE FRAME AND DOUBLER. INSTALLED NEW FRAME AND DOUBLER IAW EA 97751A, DEFECT SIZE: .125 INCH.SDR UPS06547270Frame · dentedDENT IN AFT CARGO FUSELAGE FRAME. CONTINUED ON ECA 11525 AND 115856 FRAME REPAIR WAS ACCOMPLISHED PER EA 757-5362-27-A1478 AND UPS EO B757-5310-24596A.SDR 2006UALA01112Skin · gougedAFT BELLY SKIN GOUGED.SDR SWAA061939Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FWD SERVICE DOOR STUB FRAME CORRODED AT ZEE ANGLE LOWER END, BS 294.5, RBL 55. REPAIRED STUB FRAME PER SRM.SDR SWAA061934Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FWD ENTRY DOOR FRAME CUTOUT CRACKED AT FWD LOWER STOP FITTING BS 303, STR 16L. REPAIRED FRAME SECTION PER SRM.SDR AT0700083Frame · dentedAFT FUSELAGE LT CANTED FRAME IS CRACK IN TWO PLACES AT STA 1178.225 BETWEEN L-16L TO 18L. INSTALLED DOUBLER REPAIR AT LEFT CANTED FRAME AT STA 1178.225 BETWEEN L-16L TO 18L IAW B717 SRM 51-70-01 FIG 201. MATERIAL USED 7075-080; HEAT TREATED TO T6 IAW AVBORNESDR QXEA200601448Frame · corrodedPDX - C4 FORWARD FLAGE OF FRAME X434.5 IS CORRODED BETWEEN STRINGERS 31R AND 30R. REPAIRED IAW DHC-8-200 SRM 51-10-16, 51-20-11, 51-40-11.SDR AWXA200601069Frame · crackedDURING C17 CHECK DISCOVERED BS 188 FRAME CRACKED, 3.10 INCHES, AT BL 30R AND WL 207. MAINTENANCE CUT OUT AND REMOVED DAMAGED AREA FROM BS 188 FRAME, BL 30R AND WL 206 IAW B737-300 SRM 53-00-07R11 FIG 201. REPAIRED BS 188 FRAME AT BL 30R IAW AMERICA WEST AIRLSDR AWXA200601067Frame · crackedDURING C17 CHECK DISCOVERED BS 188 FRAME CRACKED, 3.10 INCHES, AT BL 30L AND WL 207. MAINTENANCE CUT OUT AND REMOVED DAMAGED AREA FROM BS 188 FRAME, BL 30L AND WL 206 IAW B737-300 SRM 53-00-07R11 FIG 201. REPAIRED BS 188 FRAME IAW AMERICA WEST AIRLINES ENGINSDR AWXA200601064Frame · crackedDURING C17 CHECK DISCOVERED FORWARD PIT, AFT CUTOUT FRAME WEB CRACKED, .8 INCHES, AT BS 492.4 AND STR 24R. NO SRM DATA WAS AVAILABLE FOR THIS AREA. MAINTENANCE CUT OUT DAMAGED AREA IAW AMERICA WEST AIRLINES ENGINEERING REPAIR NO 03-5332-06179-ES2. FABRICATESDR AWXA200601063Frame · crackedDURING C17 CHECK DISCOVERED FORWARD PIT, FORWARD CUTOUT FRAME WEB CRACKED, .75 INCHES, AT BS 440 AND STR 24R. NO SRM DATA WAS AVAILABLE FOR THIS AREA. MAINTENANCE CUT OUT DAMAGED AREA IAW AMERICA WEST AIRLINES ENGINEERING REPAIR NO 03-5330-06179-ES2. FABRICSDR SWAA061905Frame · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE FRAME CRACKED AT AFT CARGO DOOR CUTOUT FWD FRAME, UPPER STOP FITTING. REPAIRED FRAME SECTION PER SWA EA.SDR TRAX200600323Frame · crackedFS 280 FRAME CRACKED AT LBL 11.0 AROUND ALT EXTENSION CABLE PULLEY BRACKET (MARKED).SDR ALGR109781Frame · corrodedFOUND FRAME ASSY CORRODED. REPLACED W/NEW PART.SDR UPS06247060Frame · crackedINSPECTION TYPE:C DURING REMOVAL OF FASTENERS TO FACILITATE THE FLOOR SUPPORT REPAIR FOR NRC 100734 CRACK FOUND ON FRAME FOR INNER RADIUS BS1050 RBL 12. CRACKED FRAME AT ABOVE LOCATION REPAIRED IAW SRM 53-10-02 AND SRM 51-4 0-3SDR SWAA061897Frame · corrodedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 767, STR 27R. REPAIRED FRAME SECTION PER SRM.SDR SWAA061894Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482, STR 19L. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA061893Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 492, STR 19L. REPAIRED FRAME SECTION PER SWA EA.SDR QXEA200602361Frame · corrodedYYC - FUSELAGE INTERIOR STA X1.00 LT UNDERFLOOR, LWR MACHINED FRAME FWD FACE BETWEEN STR 28P-29P HAS CORROSION AROUND RIVET SHOP HEAD. MAINTENANCE REPAIRED IAW Q400 SRM 51-21-00-350-801, SRM 51-25-10-370-801 AND SRM 51-25-15-370-801.SDR SWAA061869Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE UPPER FRAME ANGLE CRACKED AT BS 294, STR 10L. REMOVED AND REPLACED FRAME ANGLE PER SRM.SDR SWAA061868Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE LOWER FRAME ANGLE CRACKED AT BS 294, STR 10L. REMOVED AND REPLACED FRAME ANGLE PER SRM.SDR SWAA061865Frame · crackedDURING SCHEDULED C2 CHECK, FOUND FWD SERVICE DOOR CUTOUT CENTER STUB FRAME CRACKED BENEATH UPPER HINGE. REPAIRED STUB FRAME PER SWA EA.SDR CA060619012Frame · cracked(CAN) FRAME, F.S. 227 LOWER FLANGE CRACKED AT RADIUS. CRACK WAS APPROX 4.5 INCHES LEFT AND RIGHT OF A/C CENTRELINE. (TC# 20060619012)SDR 2006UALA01101Frame · puncturedAFT CARGO COMPARTMENT FRAME WEB PUNCTURED, BS 1780 LBL 20. REMOVED DAMAGE & INSTALLED REINFORCING DOUBLER , SUSPECT CARGO LOADING DAMAGE.SDR 2006UALA01100Frame · puncturedAFT CARGO COMPARTMENT FRAME WEB PUNCTURED, BS 1760 RBL 20. CUT OUT DAMAGE & INSTALLED REINFORCING DOUBLER. SUSPECT CARGO LOADING DAMAGESDR 2006UALA01050Frame · puncturedAFT CARGO COMPARTMENT FRAME WEB PUNCTURED, BS 1820 RBL 5.SDR 2006UALA01049Frame · puncturedAFT CARGO COMPARTMENT FRAME WEB PUNCTURED, BS 1760 LBL 20.
Back to JASC 5311