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 QXEA200600640Frame · corrodedPDX - C4 CHECK, FRAME AT X167 HAS CORRODED CASTELATION BETWEEN STRINGER 31L - 32L. REPAIRED IAW SRM 51-20-11, SRM 51-20-16, SRM 51-20-36 AND SRM 51-40-11.SDR QXEA200600643Frame · corrodedPDX - C4 CHECK, FRAME AT X151 HAS CORRODED CASTELATION BETWEEN STRINGER 31L - 32L. REPAIRED IAW SRM 51-20-11, SRM 51-20-26, SRM 51-20-36 AND SRM 51-40-11.SDR UPS06846435Frame · gougedC-PIT STA 1140 FRAME UPPER FLANGE ABOVE LONGERON 34R HAS DEEP, LONG DRILL WALK. REMOVED AND REPLACED FRAME UPPER CAP IAW SRM 20-15-00-2,51-3-2 AND 51 -1-20D.SDR ASAA0640198Frame · chafedFOUND FRAME FLANGE CHAFED. REPAIRED PER SRM 51 70 11.SDR 2006UALA00330Frame · mismanufacturedSTA 178 BULKHEAD UPPER LT CHORD AT RBL 25.5 & WL 230 HAS 2 EA HOLES WITH NO EDGE DISTANCE. *S/D* REMOVED SECTION OF CHORD WITH SHORT EDGE DISTANCE. FABRICATED & INSTALLED SPLICE.SDR SWAA060619Beltframe · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE BELTFRAME CRACKED AT BS 500D, STR 19R. REPAIRED BELTFRAME PER SWA EA.SDR USAA060349Frame · dentedSTA 807, S25L DENTED. REMOVED DAMAGE, INSTALLED DOUBLER REPAIR IAW TR 53-60-07.SDR USAA060348Frame · crackedBS 440 FRAME BELOW STR 8 CRACKED. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR PARTS IAW TR 53-10-20, DEFECT SIZE: .50 INCH.SDR DHL2006760527Frame · crackedCONTINUATION OF NR 029364 AFT CARGO COMP FRAME STA 1166 IS CORRODED WITH EXFOLIATION AND CRACKING BETWEEN STR 28L & 28R ON AFT SIDE OF FRAME. FABBED SPLICE REPAIR ON STR 28R STA 1158 & BCA1498-131 7075 T6 PO 5070593 DIM 10" IAW B727 SRM 53-10-3, TREATED & PRISDR ABXA060106Frame · crackedRIGHT FORWARD MAIN FRAME FS 699, FORWARD FLANGE CRACKED AT POINTS G & J. REPAIRED AREA IAW EA 53400120-001-1.SDR ABXA060105Frame · crackedRIGHT AFT MAIN FRAME, FS 737, CRACKED FORWARD FLANGE, POINTS F TO H AND AFT FLANGE P & G. EXCEEDED LIMITS OF 5935650 REPAIR. REPAIRED AREA IAW JOB CARD EA 53400326-001-2.SDR ASAA0640193Frame · crackedCRACKED FRAME AT BIN RAIL ATTACHMENT. REPAIRED PER SRM 53 00 07SDR USAA060322Frame · crackedFOUND FRAME CRACKED STA 847 BETWEEN S8R AND 9R. REPAIRED PER 53-10-20C DEFECT SIZE: .25".SDR CALA0600065Frame · crackedINSPECTION FOUND A 1 INCH CRACK IN LT MAIN FRAME AT STA 616 JUST BELOW MAIN DECK FLOOR, LBL 0 TO LBL 60. REPAIRED FRAME IAW ECRA 5311-01158.SDR DU4R2006281Frame · bentFRAME AS STA 1400, S-25L IS BENT. CUT OUT BENT PORTION. FABRICATED AND INSTALLED FRAME SECTION REPAIR 22.5 X 3.75 INCHES FROM 7075-T6 .063, AND 2EA CLIPS P/N 140N2063-56 IAW B757 SRM 51-70-11 FIG 1, 51-20-2, 51-40-02.SDR DU4R2006280Frame · bentFRAME AS STA 1420, S-26L IS BENT. CUT OUT BENT PORTION. FABRICATED AND INSTALLED FRAME SECTION REPAIR 11.625 X 3.75 INCHES FROM 7075-T6 .063, FILLER AND CLIP P/N 140N2063-56 IAW B757 SRM 51-70-11 FIG 1, 51-20-2, 51-40-02.SDR ASAA0610177Frame · dentedFRAME AT BSTA 500B BETWEEN STR 20R TO 21R DENTED. FRAME REPAIRED BY MADE REPAIR PART PER SRM 51 40 03.SDR QXEA200600641Frame · corrodedPDX - C4 CHECK, FRAME AT X167 HAS CORRODED CASTELATION BETWEEN STRINGER 29L - 30L. REPAIRED IAW SRM 51-20-11, SRM 51-20-26, SRM 51-20-36 AND SRM 51-40-11.SDR QXEA200600644Frame · corrodedPDX - C4 CHECK, FRAME AT X151 HAS CORRODED CASTELATION BETWEEN STRINGER 29L - 30L. REPAIRED IAW SRM 51-20-11, SRM 51-20-26, SRM 51-20-36 AND SRM 51-40-11.SDR QXEA200600642Frame · corrodedPDX - C4 CHECK, FRAME AT X151 HAS CORRODED CASTELATION BETWEEN STRINGER 30L - 31L. REPAIRED IAW SRM 51-20-11, SRM 51-20-26, SRM 51-20-36 AND SRM 51-40-11.SDR 06FDEA0735Frame · dentedBS 1010, STR 25 - STR 26L FRAME AT BS 1010, STR 25L-26L IS DENTED. REPAIRED FRAME WITH DOUBLER PER SRM 51-40-3.SDR 2006UALA00295Frame · crackedMID CABIN STA 663 FRAME CRACKED AT STR 2R & 1R. *S/D* REMOVED CRACKS ACCOMPLISHED HFEC INSPECTION VERIFIED DAMAGE REMOVED, FABRICATED REPAIR ANGLE AND STRINGER STRAPS AND INSTALLED PER SRM 53-00-07.SDR ASAA0640168Frame · corrodedFRAME CORRODED OUT OF LIMITS.SDR USAA060306Frame · crackedBS 380 BETWEEN S-8R AND S-9R. REMOVED DAMAGE INSTALLED DOUBLER IAW TR 51-10-20C. DEFECT SIZE: .500"SDR USAA060308Frame · crackedSTA 480 S8R. REMOVED DAMAGE, INSTALLED REPAIR DOUBLER IAW TR 53-10-20C. DEFECT SIZE: .500SDR ABXA060104Frame · corrodedCORROSION ON FRAME IN AFT CARGO BAY AT STA 1020, LONGERON 35 LEFT. OUT OF LIMITS. FABRICATED T-BRACKET USING 7075-T6 0.120" X 0.090" THK. FABRICATED DOUBLER USING 7075-T6 0.100" THK. TREATED PRIMED REPAIR PARTS AND INSTALLED IAW DC8 SRM 51-2-0, PG 49, 53-4SDR DHL2006804545Frame · misdrilledMAIN CARGO COMPT FRAME MISDRILLED HOLE AT STA 120.000 L-14R (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW FAA FORM 8110-3 DATED 02-15-06 DWG AA66-53-R07 REV IR DATED 01-16-06. CUT OUT DAMAGED SECTION AND FABRICATED REPAIR ANGLE (EXTRUSION 7075T6 511 0.090") FILSDR USAA060290Frame · crackedBS 500A FRAME BETWEEN S-8R AND S-9R. CUTOUT DAMAGE , INSTALLED REPAIR ANGLE IAW TR 53-10-20C. DEFECT SIZE: .50"SDR USAA060275Frame · crackedBS 400 FRAME BETWEEN S-8R ND S-9R. CUTOUT DAMAGED AREA. INSTALLED REPAIR ANGLES IAW TR 53-10-20C. DEFECT SIZE: .50"SDR 0600626301Frame · crackedDURING "L" CHECK AND INSPECTION PER EM 5311-01165, FOUND CRACKS IN FRAME WEB HOLE A BS 1265 STR 26R. INTERIM REPAIR ACCOMPLISHED PER EA 63-206039 SECTION I. SECTION II REQUIRES REPETITIVE INSPECTION AT 2000 CYCLE INTERVALS UNTIL ACCOMPLISHMENT OF SECTION IIISDR GAIA06002Frame · crackedDURING INSPECTION A FRAME WAS FOUND BENT AND CRACKED AT WSTA 560 BY STR 9R. ACCOMPLISHED FUSELAGE FRAME REPAIR TO STA 560, STR 9R IAW SRM. AIRCRAFT RETURNED TO SERVICE. (K)SDR GAIA06003Frame · crackedDURING INSPECTION A FRAME WAS FOUND BENT AND CRACKED AT STA 380 BETWEEN STR6,STR7L. ACCOMPLISHED FUSELAGE FRAME REPAIR TO STA 380 BY STR 7L IAW SRM. AIRCRAFT RETURNED TO SERVICE. (K)SDR GAIA06004Frame · crackedDURING INSPECTION A FRAME WAS FOUND BENT AND CRACKED AT STA 360 BETWEEN STR 7 AND 8L. ACCOMPLISHED FUSELAGE FRAME REPAIR TO STA 360 IAW SRM. AIRCRAFT RETURNED TO SERVICE. (K)SDR UPS06446249Frame · crackedINSPECTION TYPE:C COCKPIT BS 360 STR 10AL FRAME INNER CHORD FOUND CRACKS FROM 1EA FASTENERS HOLE AS MARKED, CRACK LENGTH .125 INCH. COCKPIT BS 360 STR 10-15L FRAME INNER CHORD REPLACED & INSTALLED AS PER SRM 51-10-01 PG 9 & 51-30-02.SDR 06FDEA0692Frame · misdrilledSTA 660 STR 25 LT TWO DOUBLE DRILLED HOLES THROUGH FRAME AND DOUBLER. *S/D* REMOVED DAMAGED DOUBLER AND DAMAGE ON FRAME AT STA 660 STR 25 LT, FABRICATED NEW DOUBLER, INSTALLED IAW SRM 51-40-03, 51-20-02 AND FED-EX MM 51-20-151 MAJOR REPAIR.SDR ASAA0610161Frame · dentedFRAME DENTED. FABBED REPAIR PART PER SRM 51-40-03.SDR ABXA060093Frame · crackedRIGHT FORWARD MAIN FRAME WAS CRACKED BEYOND LIMITS OF REPAIR. REMOVED AND REPLACED MAIN FRAME ON JOB CARD EA 53400322-001-2.SDR 06FDEA0680Frame · crackedFWD AVIONIC COMPT FOUND 1 CRACK 1" LONG ON FRAME STA 455 LT SIDE (REMOVED PART FOR ACF). TRIMMED OUT CRACK AND PERFORMED REPAIR IAW SRM 53-30-00 FIG 4 VOL 1. FABRICATED PARTS IAW DETAIL PARTS TRAVELER F166546/N00546 AND IAW SRM 53-30-00 FIG 4 VOL 1.SDR CALA0600062Frame · corrodedINSPECTION FOUND SURFACE CORROSION ON FRAME AT STA 794, S27R. A REPAIR WAS INSTALLED IAW SRM 53-00-07, FIGURE 201.SDR AWXA200600526Frame · corrodedMCN - DURING C22 CHECK DISCOVERED LEVEL 2 EXFOLIATION CORROSION ON AFT SIDE OF FRAME TIE AT BS 967 BETWEEN STR 27L AND STR 27R. CORROSION WAS REMOVED AND RE-WORK WAS FOUND TO BE OUT OF LIMITS IAW BOEING 737-300 SRM 53-00-07-1A1 FIG 101. DAMAGED AREA WAS REMOSDR AWXA200600470Frame · crackedMCN - MAJOR REPAIR - DURING C22 CHECK DISCOVERED FRAME 639 WEB CRACKED, .75 INCHES, ABOVE CREASE BEAM AT STR 16R. NO REPAIR DATA COULD BE FOUND IN THE SRM. MAINTENANCE CUT OUT DAMAGED AREA OF WEB AT BS 639 IAW AMERICA WEST AIRLINES ENGINEERING REPAIR NR 03-5SDR SWAA060526Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT FWD CARGO DOOR CUTOUT, FWD FRAME NR 5 STOP FITTING, BS 440, RBL 25. REPAIRED FRAME PER BFG ER.SDR SWAA060520Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT FWD CARGO DOOR CUTOUT, AFT FRAME NR 5 STOP FITTING. REPAIRED FRAME PER BFG ER.SDR SWAA060506Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 492.5, BETWEEN STR 24R TO STR 25R. REPAIRED FRAME PER SWA EA.SDR ASOA06173Frame · crackedDURING C-CHECK, FS280, AT RBL9, FROM THE CLIP BOTTOM FASTENER HOLE, WAS FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE WILL REPAIR THE FS 280, AT RBL 9, FROM THE CLIP BOTTOM FASTENER HOLE, IAW EO. (K)SDR MALA060203Frame · crackedDURING 4K CHECK IN YQB, A CRACK WAS FOUND ON THE BOTTOM FRAME AT STATION 294 RBL 18.3. THE CRACK WILL BE REPAIRED IAW MESABA EO NR S53340 ON MM409#263251. REPAIRED IAW EO NR S53340 ON 2/14/06.SDR MALA060086Frame · crackedDURING 4K CHECK IN YQB, A CRACK WAS FOUND ON THE BOTTOM FRAME AT STATION 294 RBL 18.3. THE CRACK WILL BE REPAIRED IAW MESABA EO#S53340 ON MM409#263251.REPAIRED IAW EO#S53340 ON 2/14/06.SDR ASAA0640218Frame · dentedFOUND FRAME AT BSTA 767 STR 25R IS DENTED. DENTED FRAME REPAIRED PER SRM 53 00 07 FIG 201.SDR ASAA0640217Frame · dentedFOUND FRAME AT BS 727G STR 25R IS DENTED. REPAIRED PER SRM 51 70 11 FIG 1.SDR SWAA060513Frame · corrodedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CORRODED AT AFT CARGO DOOR CUTOUT, BS 847, RBL 34 TO RBL 40, WL 162. REPAIRED FRAME PER SRM.
Back to JASC 5311