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 FDEA201101260379Frame · misrepairedREPAIR ON CABIN LT AT STATION 535, L24. FOUND NOT IN ACCORDANCE WITH APPROVED DATA. CARRIED OUT REPAIR AS PER DRAWING SG10530002 REVISION 0. EO 1-5100-7-5001 A5 PART1. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100 REVISION 111.SDR USAA2011020990647Frame · crackedCLT - MAJOR REPAIR - Q2 CHECK - CRACKED FRAME INNER CHORD AT BS 616, S17R. REPAIRED FRAME INNER CHORD AT BS 616, S17R IAW TYPICAL REPAIR TR737-5362-10-0023.SDR UALA2011012700451Frame · corrodedCORROSION ON S43L AFT FRAME 31 IN FWD PIT. EVALUATED CORROSION AND FOUND IT OUT OF LIMITS OF SRM. REMOVED DAMAGED SECTION & FAB AND INSTALLED NEW SECTION & REPAIR SPLICES FROM FR 30 TO FR 31. THIS REPAIR VALID UNTIL 31DEC 2013 ONLY.SDR SIMA201103401Frame · crackedDURING MAINTENANCE BASE VISIT INSPECTION FOUND RIGHT FRAME 23 CRACKED AT THE FLOOR LEVEL. THE AIRCRAFT WAS REMOVED FROM SERVICE. REPAIRED CRACKED FRAME IAW EO EM-53MR-1759. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR CALA2011012800045Frame · corrodedCORROSION ON FRAME STA 807 FWD SIDE BETWEEN STR 27 LT AND 27 RT. CUT OUT DAMAGED SECTION OF SHEAR TIE, FABRICATED REPAIR PARTS AND INSTALLED REF SRM 53-00-07.SDR USAA2011032991279Frame · corrodedCLT - Q2 - LEVEL 2 EXFOLIATION CORROSION ON FUSELAGE FRAME AT BS787 BETWEEN S27L TO S27R. REPAIRED FUSELAGE FRAME AT BS 787 BETWEEN S27L TO S27R IAW EA 102701.SDR USAA2011032391191Frame · corrodedCLT - Q2 - LEVEL 2 CORROSION ON FUSELAGE FRAME AT BS 827 BETWEEN BL 0 TO RBL 14. REPAIRED FUSELAGE FRAME AT BS 827 BETWEEN BL 0 TO RBL 14 IAW EA 102702.SDR USAA2011030390952Frame · corrodedCLT - Q2 - MAJOR REPAIR - LEVEL 2 CORROSION ON FRAME AT BS 767 BETWEEN S27L TO S27R. REPAIRED FRAME AT BS 767 BETWEEN S27L TO S27R IAW B737 SRM 53-00-07.SDR USAA2011022890887Frame · crackedCLT - MAJOR REPAIR - Q2 CHECK - CRACKED FRAME AT BS 500E, S20L - S21L. REPAIRED FRAME AT BS 500E, S20L - 21L IAW B737 SRM 53-00-07 REPAIR 13.SDR USAA2011022890886Frame · crackedCLT - MAJOR REPAIR - Q2 CHECK - CRACKED FRAME AT BS 500C, S20R. REPAIRED FRAME AT BS 500C, S20R IAW B737 SRM 53-00-07 REPAIR 13.SDR IPXA1564710Frame · dentedINSPECTION TYPE:C, AFT PIT FRAME STA 1280 LBL 27" DENTED. REPAIRED IAW EA110055 AND EO B757-5310-41382.SDR IPXA11564616Frame · dentedINSPECTION TYPE:C4, DENT ON FRAME IN THE BULK CARGO BAY, BS 1580, STR26L REPAIRED IAW SRM 53-00-07-2R5 AND ER 11-01205.SDR ASAA1148945Frame · crackedFRAME CRACKED AT BS 827 BETWEEN STR 8R AND 9R. REPAIRED CRACKED FRAME IAW EA AD20062609 400 53 109 REV NEW DATED 28JAN11.SDR ASAA1148944Frame · crackedFRAME CRACKED AT BS 867 BETWEEN STR 8L AND 9L. REPAIRED CRACKED FRAME IAW EA AD20062609 400 53 109 REV NEW DATED 28JAN11.SDR IPXA11564560Frame · dentedINSPECTION TYPE:C4, FWD CARGO BAY, FRAME IS DENTED ON INBD FLANGE, STA 780, STR 23L. REPAIR IAW SRM 53-00-07-2R 5.SDR FDEA201101250358Frame · dentedAFT PIT, FRAME AT BS 970 IS DENTED BETWEEN STR 25L-STR 27L. CUT OUT DAMAGED AREA IAW SRM REV 103, 51-10-1. FABRICATED DOUBLER IAW SRM 51-40-3 FIG 1 AND 53-10-2 FIG 5. INSTALLED REPAIR DOUBLER IAW SRM 51-30-2 AND 51-40-3 FIG 1.SDR DALA1106139857Frame · crackedAFT ACCY FRAME 1209 CRACKED AT LIGHTNING HOLE, APPROX 4 INCHES AT L12R. STOP DRILLED VERIFIED CRACK NO LONGER EXIST IAW NDT SPM 06-10-01. FABRICATED REPAIR DOUBLER, HEAT TREATED TO T6, DRILLED AND DEBURRED DOUBLER, ALODINE, PRIMED AND INSTALLED IAW SRM 53-01SDR SWAA110437Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 500B, BETWEEN STR 19R TO STR 22R. REPAIRED FRAME PER SRM.SDR SWAA110436Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 520, BETWEEN STR 19L TO STR 22L. REPAIRED FRAME PER SRM.SDR USAA2011032291164Frame · crackedCLT - Q2 - CRACK ON FUSELAGE FRAME AT BS 847 JUST BELOW S19R. REPLACED FUSELAGE FRAME AT BS 847 JUST BELOW S19R IAW B737 SRM 51-40-02 & BOEING DRAWING 65-47960.SDR USAA2011032291163Frame · crackedCLT - Q2 - CRACK ON FUSELAGE FRAME AT BS 847 JUST BELOW S22R. REPLACED FUSELAGE FRAME AT BS 847 JUST BELOW S22R IAW B737 SRM 51-40-02 & BOEING DRAWING 65-47960.SDR IPXA11564650Frame · dentedINSPECTION TYPE:C4 BS 1500 FRAME INNER FLANGE IS DENTED AT STR26R. REPAIR IAW SRM 53-00-07-2R-5, DETAIL III.SDR IPXA11564558Frame · dentedINSPECTION TYPE:C4, FWD CARGO BAY, FRAME IS DENTED ON INBD FLANGE, STA 780, STR 23L. REPAIR IAW SRM 53-00-07-2R 5.SDR UIEA2011012400022Frame · damagedHEAT DAMAGE ON THE FRAME INNER CHORD AT STA 2638, WL 285 LT SIDE. REPAIRED IAW EI NR T2011 A53B-139 REV EO 00, 01,02 AND 03.SDR SWIA201125522Frame · crackedFS 280 FRAME CRACKED ON RIGHT SIDE. (C-CHECK) REPAIR PER REO.SDR ASOA201100164Frame · crackedFS 280 BOTTOM FLANGE AT LBL 9 OF LOWER ANGLE IS CRACKED. REPAIRED IAW REO 601R-53-11-171.SDR MASA2011012601798Fitting · crackedFRAME TIE (CLIP) AT FS 625.3 REAR PRESSURE BULKHEAD RT SIDE CRACKED. MX R2 FRAME TIE (CLIP) AT FS 625.3 REAR PRESSURE BULKHEAD IAW CRJ-200 SRM 51-42-13.SDR SWAA110434Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 500B, BETWEEN STR 19L TO STR 22L. REPAIRED FRAME PER SRM.SDR AALA20110124AFW02Frame · corrodedRIGHT SIDE FUSELAGE FRAME AT STATION 977 BETWEEN WATERLINES 183 TO 187 OUTER CHORDS CORRODED. ACCOMPLISHED NESTED STEEL ANGLE REPAIR PER EA B767-53-014905.SDR USAA2011020290484Frame · crackedPIT - CDFI - MAJOR REPAIR - CRACK IN FUSELAGE FRAME AT BS 500B BETWEEN S20R TO S21R. REPAIRED FUSELAGE FRAME AT BS 500B BETWEEN S20R TO S21R IAW EA 117098.SDR USAA2011020190468Frame · crackedPIT - CDFI - MAJOR REPAIR - CRACK IN FUSELAGE FRAME AT BS 520 BETWEEN S20R TO S21R. REPLACED DOUBLER ON FUSELAGE FRAME AT BS 520 BETWEEN S20R TO S21R IAW B737 SRM 53-00-07 REPAIR 17.SDR USAA2011020190467Frame · crackedPIT - CDFI - MAJOR REPAIR - CRACK IN FUSELAGE FRAME AT BS 500F BETWEEN S20R TO S21R. REPLACED DOUBLER ON FUSELAGE FRAME AT BS 500F BETWEEN S20R TO S21R IAW B737 SRM 53-00-07 REPAIR 17.SDR USAA2011012890403Frame · crackedCLT - Q3 - MAJOR REPAIR - CRACK IN FUSELAGE FRAME AT BS 500F AT S21L. REPAIRED FUSELAGE FRAME AT BS 500F AT S21L IAW B373 SRM 53-00-07 REPAIR 13.SDR SWAA110385Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND FRAME CORRODED AT BS 482A, BETWEEN STR 28L TO STR 28R. REPAIRED FRAME PER SRM.SDR SWAA110362Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND FRAME CORRODED AT BS 927, BETWEEN STR 25R TO STR 26R. REPAIRED FRAME PER SRM.SDR ASAA1148903Frame · corrodedFRAME CORROSION AT BS 500B BL 0 LBL 4. REPAIRED FRAME IAW B737 400 SRM 53 00 07 FIG 201.SDR DALA1104959855Frame · crackedAFT ACCESSORY COMPARTMENT RT CANTED FRAME 1314, CRACKED BELOW AIRSTAIR ACTUATOR. CUTOUT DAMAGED AREA 2" X 2" AREA NDT VERIFIED DAMAGE. REMOVED IAW NDT SPM 06-10-01 FABBED & INSTALLED FILLER & DOUBLER IAW SRP DC9-A-53-10-17-801-663A-A. REQUIRED INSPECTION COSDR DALA1104925813Frame · corrodedAFT CARGO COMPARTMENT BS 1560 FRAME FWD FACE CORRODED BET S-28R & S-29R. ACCOMPLISHED FINAL ER/A 488606-14 REV O, STEPS 1 TO 15. PERMANENT REPAIR SEC I REPAIR APPROVAL IS LIMITED TO 24 MONTHS (730) DAYS SERVICE ONLY FROM 20JAN'11 PER LOG PAGE NR 0307787. IDESDR DALA11000055813Frame · corrodedMX DISCOVERED CORROSION ON FRAME BS 1560 BETWEEN STR 28 AND 29. TRIM CORRODED AREA AND PERFORMED HFEC INSPECTION - NO CRACKS WERE FOUND. FABRICATED REPAIR AND TREAT AREA. REF ERA 488606-14.SDR ASAA1148878Frame · damagedBS 312 FRAME SPLICE MISSING MATERIAL AT ONE OF FOUR END FASTENERS. REPAIRED FRAMES IAW ASA EA 400 53EA 04649 REV NEW DATED 26 JAN 2011.SDR DALA1105059855Frame · misrepairedAFT ACCY COMPARTMENT CANTED FRAME, STA 1245, L3R, FRAME TO LONGERON ATTACH FASTENERS HAVE MISDRILLED HOLES. REMOVED DAMAGE APPROX 15.5". HFEC INSP IAW NDT SPM 06-10-01. VERIFIED DAMAGE REMOVED. LOCATED, FABRICATED AND DRILLED NEW SECTION OF LONGERON AND 2ESDR DALA1104979864Frame · crackedMAIN PASSENGER CABIN STA 1136 OTBD BETWEEN LONGERON FRAME CLIP IS CRACKED. R & R FRAME CLIPS IAW SRM51-30-5. REMOVED AND INSTALLED FASTENERS FOR ACCESS IAW SRM 51-30-5. CLEANED UP MINOR SCRATCHES ON SURROUNDING AREA IAW SRM 53-01 & SRM 51-10-3 AND FABRICATEDSDR DALA1104949857Frame · crackedMAIN PASSENGER CABIN STA 1167, RT SIDE APB NR5 VERTICAL FRAMETOP ANGLE CRACKED. REMOVED TOP CLIP ANGLE FROM STA 1167 RT APB NR 5 IAW SRM 51-30-5 & 51-30-2. ORG MAT 050 IAW DWG 9915558. FABRICATED CLIP ANGLE IAW SRM 51-10-2 AND DWG NR 9915558. LOCATED & DRILLSDR QXEA2011012400065Frame · corrodedC5 CHECK - FUSELAGE FRAME X32.400 LOWER FLANGE HAS CORROSION BETWEEN STR 31P AND 32P. REMOVED CORROSION FROM FRAME FLANGE IAW RD 8/4-53-2344. MATERIAL LOSS FOUND TO BE OUT OF LIMITS IAW RD 8/4-53-2344. REPAIRED REF RD 8/4-53-017.SDR QXEA2011012400064Frame · corrodedC5 CHECK - FUSELAGE FRAME X1.00 LOWER FLANGE HAS CORROSION BETWEEN STR 33 AND 32S. REMOVED CORROSION FROM FRAME FLANGE IAW RD 8/4-53-2344. MATERIAL LOSS FOUND TO BE OUT OF LIMITS IAW RD 8/4-53-2344. CONFIRMED CRACK FREE AREA REF NTM 51-00-01-250-801. REPASDR AALA20110121TUL04Frame · corrodedCARGO AFT CORROSION ON FRAME 1322 FORWARD SIDE LONGERONS 28 LEFT TO 28 RIGHT. INSTALLED NEW FRAME SECTION STATION 1322 PER AARD 51-10-00-5 AND SRM 51-30-05. INSTALLED FRAME SPLICES AT LONGERONS 25 RIGHT AND 25 LEFT PER SRM 53-03-00 FIGURE 2A SHEET 1.SDR FDEA201101200316Frame · gougedGOUGES AFT SIDE OF FRAME WEB STA 1030, BETWEEN S1-2L. CUT OUT DAMAGED AREA, FABRICATED WEB REPAIR AND INSTALLED WEB REPAIR IAW SRM 53-10-4 FIG 1, 51-30-2, 51-10-2 AND 51-30-5 REV 103SDR FDEA201101200357Frame · damagedAFT PIT- DAMAGE ON UPPER FLANGE OF FRAME AT BS 1148 RBL30. BLENDED DAMAGE ON BS 1148 RBL 30 IAW SRM 51-10-1 FOUND TO OUT OF LIMITS IAW SRM 53-10-1. REMOVED DAMAGED AREA IAW SRM 51-40-3 FIG 1. FABRICATED REPAIR DOUBLER 10" X 5" FROM .071" 7075 O IAW SDR DALA1104469857Frame · crackedMAIN PASSENGER CABIN APB OTBD SIDE NR5 VERTICAL FRAME BOTTOM OLD REPAIR CRACKED. REMOVED EXISTING REPAIR FABRICATED, TRIMMED, LOCATED, DRILLED, DEBURRED, TREATED & PRIMED. NEW REPAIR ANGLES INSTALLED NEW REPAIR ANGLES INBD SIDE NR 5. VENTRAL FRAME APB IAW SSDR AALA20110120AFW01Frame · bentFUSELAGE CIRCUMFERENTIAL FRAME STATION 500 STRINGER 30 TO 31 LEFT INNER CHORD BENT. REPAIRED DISCREPANCY PER EA B767-53-014483.
Back to JASC 5311