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 FDEA201009193542Frame · corrodedAVIONICS COMPT- FRAME 14A, STRINGER 42L-44L FRAME BOTTOM FLANGE FOUND CORROSION. BLEND OUT CORROSION IAW SRM 51-74-10. REMAINING THINKNESS IS 0.048" IAW NTM 51-10-04 NO CRACK FOUND IAW NTM 51-10-18 AND NTM 51-10-08 WITHIN ALLOWABLE DAMAGE LIMIT IAW EA 6-53SDR FDEA201009193541Frame · corrodedAVIONICS COMPT- FRAME 14A, STRINGER R41L-37L FRAME BOTTOM FLANGE FOUND CORROSION. REMOVED CORROSION IAW 51-74-10 REMAINING THINKNESS IS 0.046" IAW NTM 51-10-04 NO CRACK FOUND IAW NTM 51-10-18 AND NTM 51-10-08 WITHIN ALLOWABLE DAMAGE LIMIT IAW EA NR 6-5310-1SDR FDEA201009193540Frame · corrodedAVIONICS COMPT- FRAME 14, STRINGER 44L-42L FRAME BOTTOM FLANGE FOUND CORROSION BLENT OUT CORROSION IAW SRM 51-74-10. REMAINING THINKNESS IS 0.113" IAW NTM 51-10-04 NO CRACK FOUND IAW NTM 51-10-18 WITHIN ALLOWABLE DAMAGE IAW EA 6-5310-141616 RESTORED FINISH SDR USAA2010093092158Frame · crackedCLT - Q6 - MAJOR REPAIR - CRACK ON STUB FRAME AT BS 295 BETWEEN S9R TO S10R. REPLACED STUB FRAME AT BS 295 BETWEEN S9R TO S10R IAW B737 SRM 51-10-02 & BOEING DRAWING 65-45607.SDR DALA1023449208Frame · crackedFATIGUE CRACK IN FRAME FS 962 RT. R & R FRAME EO 02-460094-12AD REVA ME03 OPN0301.SDR AALA20100918TUL01Frame · crackedSTATION 1418 FRAME CRACKED AT LONGERON 2 LEFT. REPAIRED PER EA MD80-53-013026.SDR USAA2010093092159Frame · crackedCLT - Q6 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME AT BS 500B BETWEEN S20L TO S21L. REPAIRED FUSELAGE FRAME AT BS 500B BETWEEN S20L TO S21L IAW B737 SRM 53-00-07 REPAIR 13.SDR DALA1023179869Frame Splice · crackedDURING L-CHECK, FOUND CRACK IN AFT ACCESSORY COMPARTMENT RT CANTED FRAME SPLICE AT BS 1243, STRINGER 10. REPAIRED IAW SRM 53-13-4 FIG 3, SRM 51-30-5, SRM 51-30-4 PAGE 9, SRM 51-10-2 & SRM 51-10-3 PAGE 125.SDR IXXA10SMN085SFrame · crackedDURING ROUTINE C-CHECK INSP FOUND MAIN CARGO COMPARTMENT FRAME FLANGE CRACKED AT STA 1580.000 LONGERON20-21 RT. REMOVED FASTENERS AS NEEDED TO PERFORM REPAIR. REMOVED DAMAGED FRAME. FABRICATED FRAME SEGMENT. PERFORMED HEAT TREATMENT. CLEANED,TREATED, AND PSDR GLBA20100916GFrame · crackedMAJOR REPAIR - DURING A SCHEDULED ROUNTINE INSP, MX FOUND A CRACK IN THE FRAME AT STRINGER CUTOUT 10R AND FS 456, .4" IN LENGTH. MX REPAIRED THE AFFECTED AREA AND PERFORMED ALL REQUIRED RII INSPECTIONS IAW EO 10-1900-53-054. MATERIALS UTILIZED ARE INCLUDED INSDR GLBA20100916FFrame · crackedMAJOR REPAIR - DURING A SCHEDULED ROUNTINE INSP, MX FOUND A CRACK IN THE FRAME ANGLE AT STRINGER 13L AND FS 177.35, UNDER THE AIRSTAIR ENTRANCE FLOOR, 2" IN LENGTH. MX REPAIRED THE AFFECTED AREA AND PERFORMED ALL REQUIRED RII INSPECTIONS IAW EO10-1900-53-055SDR AALA20100916TUL03Frame · crackedSTATION 1510 CANT FRAME CRACKED LOWER RIGHT TAIL CONE ALIGNMENT PIN. INSTALLED REPAIR DOUBLER PER SRM 53-01-00 FIGURE 2 SHEET 3.SDR AALA20100916TUL02Frame · crackedSTATION 1510 CANT FRAME CRACKED LOWER LEFT TAIL CONE ALIGNMENT PIN. INSTALLED REPAIR DOUBLER PER SRM 53-01-00 FIGURE 2 SHEET 3.SDR AALA20100916TUL01Frame · crackedSTATION 1510 CANT FRAME CRACKED AT TAIL CONE ALIGNMENT PIN ABOVE MAIT LIGHT SWITCH. INSTALLED DOUBLER REPAIR PER SRM 53-01-00.SDR ASOA201001398Frame · crackedLEFT AFT BELLY FAIRING 195DL AFT FRAME IS CRACKED AND HAS CHAFING DAMAGE. R & R C-CHANNEL FOR LT AFT BELLY FAIRING 195DL IAW SRM 51-41-02-001-001-A01 (PN CC670-39171-1) COMPLY WITH MODSUM IS670538200021. COMPLIED WITH EC/TC MOD SUM IS670538200021 AND MET ALLSDR SIMA201026303Frame · gougedDURING MAINTENANCE BASE VISIT FOUND FRAME 65 HAS DAMAGE FROM SCREW AT APPROXIMATELY STRINGER 11 RIGHT. THE AIRCRAFT WAS REMOVED FROM SERVICE. REPAIRED BY DRILLING OUT DAMAGE AND INSTALLING RIVET IAW EO EM-53MR-1645. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR SWAA105573Frame · crackedDURING SCHEDULED 2HC1 CHECK, FOUND FRAME CRACKED AT BS 947, STR 21R. REPAIRED FRAME PER EA.SDR SWAA105567Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 500D, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR SWAA105566Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 500C, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR SWAA105565Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 500B, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR SWAA105564Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 500D, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR SWAA105563Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 328, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER EA.SDR DALA1022919869Frame · crackedDURING M-CHECK, FOUND CRACK IN AFT ACCESSORY COMPARTMENT RT SIDE FRAME FASTENER HOLE AT BS 1275, STRINGER 9. REPAIRED IAW SRM 51-30-05.SDR DALA1022909869Frame Splice · crackedDURING M-CHECK, FOUND CRACK IN AFT ACCESSORY COMPARTMENT LT SIDE FRAME SPLICE AT BS 1243 STRINGER 9. REPAIRED IAW SRM 51-10-2, SRM 51-10-4, SRM 51-30-5.SDR GLBA20100915FFrame · crackedMAJOR REPAIR - DURING A SCHEDULED ROUTINE INSP, MX FOUND CRACK IN FRAME AT FS 327.63, 1" BELOW FLOORBOARD ON RT SIDE, 2.5" IN LENGTH. MX REPAIRED THE AFFECTED AREA AND PERFORMED ALL REQUIRED RII INSP IAW EO10-1900-53-060. MATERIALS UTILIZED ARE INCLUDED IN SDR FDEA201009153423Frame · failedPREVIOUS FRAME REPAIR LOCATED IN BULK CARGO COMPARTMENT UNDEFLOOR ON FRAME 67 BETWEEN STRINGERS 43 TO 46 RT HAS A REPAIR AGLE ON AFT SIDE OUTER FLANGE MEASURING 9-8 IN LONG. PREVIOUSLY INSTALLED REPAIR LOCATED IN BULK CARGO ON FRAME 67 BETWEEN STRINGERS 43 TO SDR C2XA10SH298Frame · brokenSHV - DURING C-CHECK LT FRAME 10 BROKEN UNDER DV WINDOW FRAME. MAINTENANCE REMOVED AND REPLACED LT FRAME 10 UNDER DV WINDOW FRAME IAW EMB-145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR FDEA201009143419Frame · damagedDAMAGE ON FRAME FREE FLANGE AT STA 730 BELOW STR 9R. REPAIRED AS PER E.A. F-5310-137672 730. REPAIR IS CLASSIFIED AS MAJOR PER GMM 6-2-100.SDR FDEA201009143414Frame Splice · damagedUPON FRAME REMOVAL, FOUND DOUBLE DRILLED HOLES IN FRAME SPLICE, STA 950B, STR 24L. REMOVED PRODUCTION SPLICE/DOUBLER IAW SRM 51-30-2 FORMED NEW DOUBLER IAW SRM 51-20-1 FIG 7 INSTALLED NEW DOUBLER IAW SRM 51-30-2 REV 103.SDR ZZDA2010423Frame · damagedAFT LEFT STA 1178 CANTED FRAME INSPECTION IDENTIFIED CONFIGURATION 1 CONDITION 3. ACCOMPLISHED REPAIR TO AFT FUSELAGE FRAME CAP, CANTED STA 1178.225, LEFT SIDE IAW AIRTRAN TASK CARD 17-5310-2975.SDR ZZDA2010422Frame · damagedAFT RIGHT STA 1178 CANTED FRAME INSPECTION IDENTIFIED CONFIGURATION 2 CONDITION 5. ACCOMPLISHED REPAIR TO AFT FUSELAGE FRAME CAP, CANTED STA 1178.225, RIGHT SIDE IAW AIRTRAN TASK CARD 17-5310-2990.SDR COEA2010091421803Frame · corrodedHEAVY CHECK / LEVEL 2 CORROSION / FR36 RT BETWEEN STR 14R-15R IS CORRODED ON AFT SIDE AND ON LWR FLANGE AT SKIN. WILL REMOVE AND REPLACE.SDR SWAA105526Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 787, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME PER SWA EA.SDR DALA1051439012Frame · unknownFUSLEAGE MAIN FRAME LT LOWER NOSE LONGERON 22-26 AND ATTACH FRAME REPAIRED IAW EA 09-069225-12, ME01.SDR LR7A2010103100151Frame · corrodedDURING SCHEDULED C-10 CHECK PER JOB CARD HC5324 FOUND RT MLG FRAME EXFOLIATION CORROSION AT FS 517, WL 140 TO WL 175 ON INTER AND OUTER CAP AND REINFORCEMENT PLATE. REPAIRED IAW LAC MEA382-53-10-041 R1 AND DWG R10-021-03. REINFORCING PLATE REPLACED IAW SMP58SDR LR7A2010103100094Ring Assembly · corrodedDURING SCHEDULED C-10 CHECK PER JOB CARD HC5313 FOUND CABIN INTERIOR RING SEGMENT WITH PITTING CORROSION AT FS 732, WL 146, BL 61R. REPAIRED IAW LOCKHEED SMP583 FIG 51-140-21.SDR LR7A2010103100089Ring Assembly · crackedDURING SCHEDULED C-10 CHECK PER JOB CARD HC5315 FOUND RT AFT FUSELAGE FS 737 (817E) INTERIOR RING SEGMENT CRACKED AT WL 152, BL 66R. REPAIRED IAW LOCKHEED SMP583 FIG 53-40-46.SDR SWAA105478Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 235.8, BETWEEN LBL 20 TO LBL 50. REPAIRED FRAME PER EO.SDR SWAA105464Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 787, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME PER SRM.SDR SWAA105461Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 807, STR 27L. REPAIRED FRAME PER SRM.SDR SWAA105459Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 747, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME PER SRM.SDR LR7A2010091400032Frame · crackedDURING SCHEDULED C-10 CHECK PER JOB CARD HC5321 FOUND RT UPPER MAIN WHEEL WELL ARMPIT PANEL FRAME CRACKED AT FS 478, WL 256, RBL 79. REPAIRED IAW LOCKHEED SMP583 FIG 51-140-23.SDR DALA1022529868Frame · damagedDURING M-CHECK, FOUND 2 EA MISDRILLED HOLES IN AFT ACCY CANTED FRAME AT BS 1275 L3R. REPAIRED IAW SRM 53-02 FIG 18 & SRM 51-30-5.SDR FDEA201009123354Frame · corrodedNOSE EQUIPMENT BAY BULKHEAD LOWER CHORD AT STA 199.09 BL.0 FOUND WITH CORROSION. CORRODED LOWER CHORD AT NOSE EQUIPMENT BAY BULKHEAD AT STA 199.09. R & R IAW SRM 51-40-02 REV 100. REPAIR IS CLASSIFIED AS MINOR IAW GMM 6-2-100.SDR KCSA101124Frame · crackedBS 520 FUSELAGE FRAME CRACKED BETWEEN STR 8R AND STR 9R.SDR KCSA101123Frame · crackedBS 520 FUSELAGE FRAME CRACKED BETWEEN STR 9R AND 10R.SDR KCSA101122Frame · crackedBS 520 FUSELAGE FRAME CRACKED BETWEEN STR 10R AND STR 10A R.SDR DALA1022286302Frame · damagedDURING LINE CHECK, FOUND FREEZE PLUG REQUIRED DOUBLER AT BS 240 BETWEEN S13 & S14. REPAIRED IAW ERA 485386-14.SDR DALA1026916901Frame · corrodedAFT CARGO FRAME CORRODED STA 1600 STR 29R-30. COMPLED WITH ERA 486174-14 REV ORIGINAL DURING HMV AT ST AEROSPACE SAT ON NON ROUTINE CARD 171047 (DL75E102749).SDR DALA1026786901Frame · corrodedAFT CARGO FRAME CORRODED STA 1480 STR 26L-26R. REMOVED AND REPLACED FRAME, STIFFENERS, FAIL SAFE CHORD AT STA AEROSPACE SAT ON NON ROUTINE CARD 171030 (DL75E102736).
Back to JASC 5311