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 GLBA20110516LFrame · crackedMAJOR REPAIR - DURING A SCHEDULED ROUTINE INSPECTION MAINTENANCE FOUND CRACKS AT F.S. 456 BETWEEN STRINGERS 3L AND 4L AT THE UPPER IB NUTPLATE AREA, 1.9" IN LENGTH, 7 CRACKS. MAINTENANCE REPAIRED THE AFFECTED AREA AND PERFORMED ALL REQUIRED RII INSPECTIONS IAWSDR GLBA20110516KFrame · crackedMAJOR REPAIR. DURING A SCHEDULED ROUTINE INSPECTION MAINTENANCE FOUND A CRACK IN THE FRAME AT FS 456 AND S10R, .5" IN LENGTH. MAINTENANCE REPAIRED THE AFFECTED AREA AND PERFORMED ALL REQUIRED RII INSPECTIONS IAW EO 11-1900-53-034. MATERIALS UTILIZED ARE INCLSDR SWAA113763Frame · crackedDURING SCHEDULED 12Y CHECK FOUND, FRAME CRACKED AT BS 787, BETWEEN STR 7L TO STR 8L. REPAIRED FRAME PER EA.SDR SWAA113639Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND RT FRAME CRACKED AT BS 500A, BETWEEN STR 7R TO STR 8R. REPAIRED FRAME PER SRM.SDR DALA1134889866Frame · gougedAFT WET AREA-STA 1136 LEFT LONG 4 PYLON BULKHEAD FRAME GOUGED. BLEND GOUGE 1" BY 4" ORIG .050 REMOVED .012 REMAINING .038. FOUND OUT OF LIMITS PER SRM 53-01.FAB AND INSTALLED 2 ANGLES FROM .040 7075-0 IAW SRM 53-02 FIG 2 SHEET 4. HEAT TREATED ON TRAVELER 25SDR DALA1134879866Frame · crackedMAIN CABIN STA 734 RIGHT LONG 18 MAIN FRAME CRACKED. REMOVED AND INST NEW FRAME PART NR 9923406-502 IAW 51-30-5, DWG 3924863.P-226. REQUIRED INSPECTION COMPLETED.SDR CALA2011051600367Frame · crackedSUPPORT TASK - FRAME AT STA 303 IS CRACKED AT STRINGER 16L CUTOUT. REPAIRED FRAME AT STA 303 PER EA 5310-04659.SDR SIMA201113704Frame · crackedDURING MANTENANCE BASE VISIT FOUND FRAME 23 TO BE CRACKED BETWEEN STRINGERS 15 RIGHT AND 16 RIGHT. THE AIRCRAFT WAS REMOVED FROM SERVICE. REPAIRED FRAME 23 IAW EO EM-53MR-1815. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR UALA2011051602407Frame · corrodedCORROSION ON FRAME AT STA 1420, BETWEEN S-30 AND STR 28L. MAJOR REPAIR ACCOMPLISHED: REMOVED CORROSION FROM THE FRAME. ACP NDT OF FASTENER HOLES & BLENDED AREA REF NDT MANUAL. FABRICATED & INSTALLED REPAIR DOUBLER, ATTACH ANGLE, REPAIR STRINGER CLIP AND SHESDR SIMA201113701Frame · damagedDURING MANTENANCE BASE VISIT FOUND FRAME 69 HAS MIS-DRILLED HOLE. THE AIRCRAFT WAS REMOVED FROM SERVICE. REPAIRED FRAME 69 IAW EO EM-53MR-1255. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR DALA1134209866Frame · crackedMAIN CABIN STA 753 RIGHT LONG 18 MAIN FRAME CRACKED. REMOVED MAIN FRAME AT STA 753 RIGHT LONG 18. RECEIVED NEW FRAME P/N 97-5300-3-0024. INSTALLED NEW FRAME IAW SRM 51-30-5 P226.SDR AALA20110515TUL03Frame · crackedSTATION 1485 CANT FRAME CRACKED AT BOTTOM OF STAIR RETRACT ACTUATOR. REMOVED DAMAGE AND INSTALLED DOUBLER PER AARD 53-10-00-33.SDR USAA2011060800025Angle · crackedCLT - Q4 - CRACK IN FUSELAGE FRAME REINFORCEMENT ANGLE AT BS 500E BETWEEN S20R TO S21R. REPAIRED FUSELAGE FRAME REINFORCEMENT ANGLE AT BS 500E BETWEEN S20R TO S21R IAW B737 SRM 53-00-07 REPAIR 13.SDR AALA20110525TUL06Frame · corrodedFRAME AT STATION 686 RIGHT SIDE 3 INCHES ABOVE FLOORLINE CORRODED. INSTALLED FRAME REPAIR DOUBLER PER SRM 51-70-11-0G.SDR DALA1134219866Frame · damagedAFT CARGO COMPT FRAME REPAIR ANGLE HAS SEVERAL IMPROPERLY INSTALLED FASTENER'S SOME PULLED THROUGH AND TOOLING GOUGE'S IN UPPER FWD FLANGE AT STA 908 BETWEEN LONG S29L-29R. REMOVED DAMAGED FRAME REPAIR IAW SRM 51-30-5. FABRICATED AND INSTALLED NEW FRAME SECTSDR FOTR2106708996Frame · crackedLEFT FUSELAGE FRAME AT BS 601 IS CRACKED AT LWR FASTENER HOLE ON INBD FLANGE BELOW STRINGER 17L CREASE WEB. REPAIRED ON FASI WO 21067, NR 08996.SDR SWAA113696Frame · crackedDURING SCHEDULED 24Y CHECK FOUND, FRAME CRCKED AT BS 616, BETWEEN STR 17R TO STR 18R. REPAIRED FRAME PER EA.SDR UALA2011051302376Frame · corrodedCORROSION ON FRAME AT STA 1460 BETWEEN STR 16R AND 17R. MAJOR REPAIR ACCOMPLISHED: REPAIRED PER INSTRUCTIONS ON EA57-53-122 AND UA EVA 80836 WITHOUT DEVIATION. CF9044 CREATED FOR 24 MONTH DTA REQUIREMENT.SDR SWAA113386Frame · corrodedDURING SCHEDULED OTS CHECK FOUND, CORROSION ON FWD FACE OF FRAME LOCATED BS 727D BETWEEN STR 26L TO STR 27L AFT CARGO COMPARTMENT. REPAIRED FRAME IAW SRM.SDR SWAA113385Frame · corrodedDURING SCHEDULED OTS CHECK FOUND, CORROSION ON FRAME LOC BS 767 BETWEEN STR 26R TO STR 27R LOWER FLANGE AFT CARGO COMPARTMENT. REPAIRED FRAME SECTION IAW SRM.SDR SWAA113383Frame · corrodedDURING SCHEDULED OTS CHECK FOUND, CORRODED ON FRAME LOC STA 727E AND BETWEEN STR 25R TO STR 26LA FT CARGO COMPARTMENT. REPAIRED FRAME IAW SRM.SDR SWAA113382Frame · corrodedDURING SCHEDULED OTS CHECK FOUND, CORROSION ON FRAME LOCATED AT BS 727B STR 26R TO STR 27R AFT CARGO COMPARTMENT. REPAIRED FRAME PER SRM.SDR SWAA113380Frame · corrodedDURING SCHEDULED OTS CHECK FOUND, CORRODED ON EXISTING REPAIR OF FRAME LOCATED BS 727D BETWEEN STR 26R TO STR 27R AFT CARGO COMPARTMENT. REPAIRED FRAME PER SRM.SDR SWAA113379Frame · corrodedDURING SCHEDULED OTS CHECK FOUND, CORROSION ON EXISTING REPAIR LOC STA 747 AND BETWEEN STR 26R TO STR 27R AFT CARGO COMPARTMENT. REPAIRED FRAME PER SRM.SDR SWAA113372Frame · corrodedDURING SCHEDULED 16Y CHECK FOUND, CORROSION ON FWD AND AFT FACE OF FRAME LOCATED BS 727D BETWEEN STR 27L TO STR 27R AFT CARGO COMPARTMENT. REPAIRED SECTION OF FRAME IAW SRM.SDR IPXA1566611Frame · dentedINSPECTION TYPE:C1, AFT CARGO COMPARTMENT STA 1300 JUST BELOW STR 25R, FRAME IS DENTED ON INBD FLANGE. REMOVED DAMAGE AND REPAIRED FRAME AT STR 25R IAW EA 110442 IR.SDR CALA2011050900351Frame · crackedFRAME AT STA 480 RT HAS CRACK INDICATION DURING MF EC ON I/B RIVET REF NDT MANUAL, PART 6, 53-30-00, FIG 7, PARA 6.C.1 FOR ADDITIONAL REQUIREMENTS FOR MAINT. REPAIRED CRACK AT STA 480 R PER EA 5310-04716 REV C.SDR SWAA113348AFailsafe · corrodedDURING SCHEDULED OTS CHECK FOUND, FAIL SAFE CHORD AT STA 747 STR 26 - 27 LT IS CORRODED ON THE VERTICAL AND HORIZONTAL FLANGES. REPAIRED CHORD PER SRM.SDR FDEA201105121823Frame · crackedHIGH FREQUENCY EDDY CURRENT OPEN HOLE INSPECTION CARRIED OUT AND FOUND HOLE NR 1 WITH CRACK INDICATION AT LEFT FRAME STATION 44. LEFT FRAME STATION 44 CARRIED OUT REPAIR AS PER E.A. 6-5310-143580 AND E.A. 6-5310-143578, REPAIR CLASSIFIED MAJOR AS PER GMM 6-2-SDR FOTR2104615158Frame · dentedFWD PIT FRAME BS 700 UPPER FLANGE IS DENTED BETWEEN STR 24R-23R. REPAIRED ON FASI WO 21046, NR 15158.SDR UALA2011051302373Failsafe · damagedMAJOR REPAIR TO THE FAIL SAFE CHORD AT BS 1460 BETWEEN STR 16R AND STR 17R WAS ACCOMPLISHED DURING HMV AND RECEIVED FIRST STAGE APPROVAL FOR THE REPAIR WITHOUT DEVIATION. THE FAIL SAFE CHORD REPAIR MUST RECEIVE A NEW FAA FORM 8100-9 SHOWING COMPLIANCE TO 14 CFSDR SIMA201113601Frame · chafedDURING MAINTENANCE BASE VISIT FOUND THE FUSELAGE FRAME 55 CHAFED AT STRINGER 8 LEFT. THE AIRCRAFT WAS REMOVED FROM SERVICE. CUT OUT DAMAGED AERA, FABRICATED, PREPPED AND INSTALLED REPAIR ANGLES IAW EO EM-53MR-1811. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR ASOA201100953Frame · corrodedRIGHT OTBD END OF FRAME FS 349.0 IS CORRODED. BLENDED FRAME, ORIGINAL MAT'L .063. REMOVED .003. REMAINING MAT'L .060, WITHIN SERVICABLE LIMITS IAW SRM 51-12-00. MAJOR REPAIR.SDR ASOA201100952Frame · crackedFS 280.0 FRAME CRACKED, OTBD OF RBL 9.0. R & R DAMAGED SECTION OF FRAME IAW REO 601R-53-11-136 REV A. MAJOR REPAIR.SDR SWAA113338AFrame · corrodedDURING SCHEDULED 20Y CHECK FOUND, FRAME CORRODED AT BS 747, BETWEEN STR 27R TO STR 27L. REPAIRED FRAME PER SRM.SDR SWAA113332AFrame · crackedDURING SCHEDULED 24Y CHECK FOUND, FRAME BS 727B CRACKED AT LWER EDGEAT STRINGER 14R. REPAIRED FRAME PER EA.SDR AALA20110512TUL02Frame · crackedFRAME CRACKED 1418 LONGERON 2 RIGHT FORWARD AND AFT SIDES. INSTALLED FORWARD AND AFT SIDE FRAME DOUBLER 1418 2 RIGHT PER SRM 53-03-00 FIGURE 31.SDR A6WA201140408Frame · chafedNR 2 HYD PUMP STEEL BRAIDED 1 CHAFING, FS 718 FRAME. REPAIRED FS 718 FRAME BETWEEN STRINGERS 10R & 11R IAW REO 601R-53-61-4060.SDR SWAA113687Frame · corrodedDURING SCHEDULED 26Y CHECK FOUND, FRAME CORRODED AT BS 380, BETWEEN STR 25R TO STR 26R. REPAIRED FRAME.SDR SWAA113684Frame · corrodedDURING SCHEDULED 26Y CHECK FOUND, FRAME CORRODED AT BS 345, BETWEEN RBL 16 TO RBL 22. REPAIRED FRAME PER SRM.SDR DALA1133479866Frame · corrodedAFT CARGO COMPT AFT FACE OF FRAME 1108 SPLICE UNDERNEATH OF UPPER FLANGE HAS CORROSION BETWEEN LONG 27L AND L28L. REMOVED SPLICE IAW 51-30-5. TOOLING MARK ON SPLICEOUT OF LIMITS IAW SRM 53-01 FIG 1. RECEIVED MAT .063 7075-0. RECEIVED FROM HEAT TREATSDR CALA2011051200362Frame · crackedSUPPORT TASK - FWD FRAME IS CRACKED JUST O/B OF ELECTRIC MOTOR DRIVEN PUMP, 22 INCHES FROM FWD BULKHEAD, RT SIDE OF RT MLG WHEEL WELL MKD. CUT OUT DAMAGED AREA AND INSTALLED REPAIR ANGLES REF ECRA 5340- 01447.SDR AALA20110511TUL06Frame · corrodedCORROSION ON FRAME 1360 3 INCHES OUTBOARD OF STRINGER 27 RIGHT. DOUBLER REPAIR COMPLETED PER SRM 53-00-07-2R 5.SDR EVCA00021Frame · corrodedFOUND PITTING AND CORROSION, SOME THAT GOES THROUGH OUTER LAYER OF HONEY COMB TUB, IN THE AREA JUST BELOW AND AFT OF THE LEFT HAND REAR DOOR JAM AT THE BOTTOM AFT CORNER.SDR ASAA1149845Frame · corrodedFRAME AT BS 1006 CORRODED ON LOWER FLANGE BETWEEN STR 22R AND 24R. REPAIRED FRAME IAW ASA EA 400 53EA 05595.SDR ASAA1149846Frame · corrodedFRAME AT BS 1006 CORRODED ON UPPER FLANGE AND UNDER FRAME SPLICE BETWEEN REPAIRED FRAME IAW ASA EA 400 53EA 05595.SDR WRLA20110510482Frame · crackedCRACK RT BS 1160 FRAME 1 EA HOLE ( AFTER 0.313 OVERSIZE REAMING) CRACK STILL PROGRESSING. TRIMMED OUT CRACK AT FRAME BS1160 IAW SRM 53-40-07. HFEC AREA NO CRACKS FOUND IAW SRM 51-00-00 FIG 3 PG 6. FABRICATED PARTS IAW SRM 53-40-07 FIG 201. INSTALLED PER SRSDR IPXA11566588Frame · damagedINSPECTION TYPE:C3, FRAME SPLICE AT STA 1380 AND STRINGER 24L HAS ELONGATED HOLES. R & R FRAME SPLICE AT STA 1380 S-24L IAW SRM 51-40-02 A ND SRM 51-40-05.SDR DALA1133199866Frame · crackedMAIN CABIN STA 579 RIGHT LONG 17 FRAME CRACKED. CUT OUT DAMAGE IAW DC-9 SRM 53-03 FIG 32. 1 1/4 INCH BY 3 3/4 INCH NDT VERIFY NO DAMAGE REMAINS. FABRICATED -29 FILLER .063 7075T6 IAW 53-03 FIG 32. FABRICATED -33 ANGLE .071 7075-0 PO 1120609. HEAT TREATED OSDR DALA1133189866Frame · crackedMAIN CABIN STA 503 FRAME AT L17L CRACKED AT FASTENER CUT OUT DAMAGED SECTION 1 1/4 BY 3 3/4 IAW DC9 SRM 53-03 FIG 32. NDT VERIFIED DAMAGE REMOVED. FABRICATED 1-32 ANGLE FROM 7075-0.071. HEAT TREATED ON PEMCO TRAVELER NR 2547 NO 1585 TO 7075-T6. FABRICATED
Back to JASC 5311