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 ZZDA2010613Frame · damagedAFT LEFT STA 1178 CANTED FRAME INSPECTION IDENTIFIED CONFIGURATION 1 CONDITION 1. ACCOMPLISHED REPAIR TO AFT FUSELAGE FRAME CAP, CANTED STA 1178.225, LEFT SIDE IAW AIRTRAN TASK CARD 17-5310-2973.SDR ASOA201001901Frame · corrodedFUSELAGE BELLY FRAME AT FS 333.00 IS CORRODED IN SEVERAL AREAS. REMOVED BELLY FRAME FROM STR 23L - 23R IAW SRM 51-42-06 & 51-42-21. LOCATED, DRILLED, SEALED & INSTALLED NEW FRAME IAW SRM 51-42-06, 51-42-21. FRAME STA 333 LOWER REQ'S PAINT. TOUCHED UP REWOSDR ASOA201001900Frame · corrodedFUSELAGE BELLY FRAME AT FS 319.7 HAS SEVERAL AREAS OF CORROSION. REMOVED CORROSION IAW SRM 51-21-06. REMOVED APPROX .003 MATERIAL. REMOVAL WITHIN LIMITS. MINOR REPAIR IAW SOP 5702.SDR ASOA201001897Frame · corrodedFS 364.00 FRAME HAS MODERATE CORROSION ON FLANGE BETWEEN STR 26L AND 26R. MEASURES APPROX .006" DEEP. INSTALLED AVIONICS DOOR LATCH PIN PROX SWITCH MOUNTING BRACKET AND FWD CNTR LATCH FITTING IAW AMM 52-70-08-400-801 & SRM 51-41-04- & 51-42-06. REMOVED MODESDR ASOA201001896Frame · corrodedFS 349.00 FRAME HAS MODERATE CORROSION ON FLANGE BETWEEN STR 26L AND 26R. MEASURES APPROX .007" DEEP. REMOVED MODERATE CORROSION IAW SRM 51-21-06. REMOVED APPROX .005. REMOVAL WITHIN LIMITS. TREATED, PRIMED & PAINTED REPAIR AREA IAW SRM 51-21-06. MINOR REPASDR QXEA2010121000857Frame · corrodedC5 CHECK - CORROSION FOUND ON FR 94.8 LOWER FLANGE BETWEEN STRINGERS 31R TO 30R. REMOVED LIGHT CORROSION IAW SRM 51-21-00. NO MATERIAL LOSS NOTED. ALODINED AND PRIMED IAW SRM 51-21-10 AND 51-25-10. MIN MATERIAL REMAINING .040" REF NTM 51-00-02-250-801. CONSDR ASAA1078633Frame · crackedCRACKED MAIN CABIN FRAME BS 400 JUST BELOW STR 8L. REPAIRED MAIN CABIN FRAME IAW ATS ER 10 05657.SDR ASAA1078632Frame · crackedCRACKED MAIN CABIN FRAME BS 400 JUST BELOW STR 8R. REPAIRED MAIN CABIN FRAME IAW ATS ER 10 05657.SDR QXEA2010121000864Frame · corrodedC5 CHECK - FR 196.000 FWD SIDE IS CORRODED AT STR 32L AND 32R. REMOVED CORROSION IAW SRM 51-21-00. MIN REMAINING THICKNESS .039" REF NTM 51-00-02-250-801. FOUND DAMAGE ON LWR RADIUS FWD SIDE OF FRAME, DAMAGE WAS CUT OFF AND REPAIRED ON NR 100056, WO 100785.SDR QXEA2010121000861Frame · corrodedC5 CHECK - FR 32.400 LOWER FLANGE BETWEEN STR 32R AND 31R IS CORRODED. REMOVED CORROSION FROM FLANGE IAW SRM 51-21-00. MIN REMAINING THICKNESS .034" REF NTM 51-00-02-250-801. MATERIAL LOSS FOUND TO BE OUT OF LIMITS IAW SRM 53-20-15. FRAME SECTION TO BE REPLASDR QXEA2010121000860Frame · corrodedC5 CHECK - FR 32.400 LOWER FLANGE BETWEEN STR 31L AND 32L IS CORRODED. REMOVED CORROSION FROM FRAME FLANGE IAW SRM 51-21-00. CONFIRMED CRACK FREE CONDITION REF 51-00-01-250-801. MIN THICKNESS REMAINING .036" REF NTM 51-00-02-250-801. MATERIAL LOSS FOUND TOSDR QXEA2010121000859Frame · corrodedC5 CHECK - FR 1.000 LWR FLANGES ARE CORRODED FROM STR 32L TO 31R. REMOVED CORROSION IAW SRM 51-21-00. MIN REMAINING THICKNESS .045" NTM 51-00-02-250-801. MATERIAL LOSS AT FLANGE AT STA 1.00, STR 33-32R FOUND TO BE OUT OF LIMITS AND FLANGES AT STA 1.00 STR SDR QXEA2010121000856Frame · corrodedC5 CHECK - FR 19.400 LOWER FLANGES FROM STR 32L TO 31R ARE CORRODED. REMOVED CORROSION IAW SRM 51-21-00. FOUND TO BE OUT OF LIMITS IAW RD 8/4-53-2344. REMOVED FLANGE AND FABRICATED REPAIR FLANGE IAW RD 8/4-53-017. CONFIRMED AFFECTED AREA CRACK FREE REF NTM 5SDR FDEA201012074608Frame · damagedMAIN CARGO DECK FRAME AT STA 418 BETWEEN STRINGER S-1R HAS EXISTING TV MONITOR MOUNT HOLES THAT DOES NOT HAVE PROPER EDS. REPLACED FRAME AT STA 418 FROM RBL 2.5 TO TO LBL 2.5 IAW EA 757-5312-16-F3027. MAJOR REPAIR.SDR SWAA107687Frame · crackedDURING SCHEDULED 26Y CHECK, FOUND FRAME CRACKED AT BS 500D, STR 21R. REPAIRED FRAME PER SRM AND BAC DWG.SDR ASAA1078595Frame · crackedCRACK ON FRAME AT STR 8 ATTACH BRACKET BS 727D. REPAIRED CRACK ON FRAME IAW ATS ER 10 05657.SDR ASAA1078594Frame · crackedCRACK IN FUSELAGE COMMON TO BIN RAIL ATTACH BRACKET AT BS 727D. REPAIRED FRAME IAW ATS ER 10 05657.SDR FDEA201012074607Frame · damagedMAIN CARGO DECK FRAME AT STA 1100, STRINGER S-2L HAS EXISTING TV MONITOR MOUNT HOLES THAT DOES NOT HAVE EDS. REMOVED AND INSTALLED STRINGER CLIP AT S-2L IAW SRM 51-40-02. CUT OUT FRAME FROM STR 1 TO STR 5L, IAW SRM 53-00-07, FOR SPECIAL FREIGHTER AND REPAIRESDR FDEA201012074606Frame · damagedMAIN CARGO DECK FRAME AT STA 1100, STRINGER S-2R HAS EXISTING TV MONITOR MOUNT HOLES THAT DOES NOT HAVE PROPER EDS. R & R STRINGER CLIP S2R IAW SRM 51-40-02. CUT OUT FRAME FROM STR 2R TO STR 5R, IAW SRM 53-00-07 FOR SPECIAL FREIGHTER AND REPAIRED IAW SRM 53-SDR QMLDMG1474Frame · crackedDURING INSP FOUND THE TAIL CONE "A" FRAME CRACKED AT THE ECS BLEED LINE ATTACHMENT. AWAITING A REPAIR SCHEME FROM MFG.SDR SWAA107667Frame · corrodedDURING SCHEDULED SPV CHECK, FOUND FRAME CORRODED AT BS 500, RBL 24.5. REPAIRED FRAME PER EA.SDR SWAA107625Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 500C, BETWEEN LBL 1 TO RBL 1. REPAIRED FRAME PER SRM AND BAC DWG.SDR SWAA107623Failsafe · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME FAIL SAFE ANGLE CORRODED AT BS 947, BETWEEN RBL 14 TO RBL 16. REMOVED AND REPLACED ANGLE PER SRM AND BAC DWG.SDR SWAA107594Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FRAME CRACKED AT BS 500B, STR 1R. REPAIRED FRAME PER SRM.SDR CA101207003Frame · broken(CAN) DURING A ROUTINE POST-FLIGHT INSPECTION BY MAINTENANCE PERSONNEL, THE LOWER FRAME ASSY WAS FOUND CRACKED AT THE UPPER L/H AFT ATTACHMENT POINT. THE BROKEN AREA DID NOT HAVE ANY EVIDENCE OF PRE-EXISTING CRACKS, AND APPEARED TO BE A CLEAN BREAK. THERE WAS SDR DALA1117789221Frame · corrodedHMV2 AFT BILGE AREA STA 1231 HAS CORROSION ON FRAME. REPAIR PER SRM 53-10-02 FIG 3.SDR SWAA107535Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 787, BETWEEN STR 27R TO STR 26R. REPAIRED FRAME PER SRM.SDR SWAA107528Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 500B, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR SWAA107525Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 500B, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER EA.SDR CALA2011032900214Frame · crackedBS 303.9 FRAME CRACKED AT STR 16L FORWARD SIDE AROUND OVAL HOLE. INSTALLED REPAIR PER ECRA 5311-01515. GENERATED DIP TO REINSPECT BEFORE THE ACCUMULATION OF 66000 TOTAL A/C FLY CYCLES PER PART 2 OF ECRA 5311-01515 REF DIP 08205 FRAME CRACKED STA 303.9 PER ESDR QXEA2010120700850Frame · corrodedC5 CHECK - FR 714.602 LOWER FLANGE BETWEEN STR 33 AND 32L IS CORRODED. TRIMMED FRAME LOWER FLANGE IAW RD 8/4-53-017. CLEANED MINOR SURFACE CORROSION ON LOWER SKIN PANEL IAW SRM 51-21-00. CONFIRMED CRACK FREE CONDITION REF NTM 51-00-01-250-801. MIN REMAINING TSDR QXEA2010120700849Frame · corrodedC5 CHECK - FR 156.000 LOWER FLANGE IS CORRODED BETWEEN STR 31R AND 32R. REMOVED CORROSION IAW SRM 51-21-00-00-02. FR 156 IS WITHIN LIMITS IAW RD 8/4-53-2344. MIN REMAINING THICKNESS .036" REF NTM 51-00-02-250-801. TREATED AND PAINTED REF SRM 51-21-10-02-01SDR DALA1034949864Frame · crackedDURING M-CHECK FOUND LT MAIN WHEEL WELL, KEEL AREA BS 712 PREVIOUS FRAME REPAIR IS CRACKED. REMOVED OLD REPAIR DOUBLER AND FABRICATED NEW DOUBLER. INSTALLED REPAIR DOUBLER IAW SRM 51-30-5.SDR USAA2010122893260Frame · crackedCLT - MAJOR REPAIR - Q1 CHECK - CRACKED FRAME AT BS 400, S8R - S9R. REPAIRED FRAME AT BS 400, S8R - S9R IAW TR 737-5310-10-0287.SDR ASAA1048663Frame · corrodedSTA 847 FRAME UPPER FLANGE CORRODED. REMOVED CORRODED SECTION AND INSTALLED NEW FRAME SECTION IAW B737 400 SRM 51 40 02.SDR ASAA1078583Frame · crackedCRACK IN FUSELAGE FRAME COMMON TO BIN RAIL ATTACH BRACKET AT BS 727D BETWEEN STR 8L AND 9L. REPAIRED FRAME PER EA 700-53EA-04482.SDR UALA2010120304445Frame · corrodedAFT FUSELAGE BILGE FRAME 67 AT CTR LINE AREA CORRODED. MAJOR REPAIR ACCOMPLISHED: REMOVED ANGLE, FABRICATED NEW PART, REF DWG D53480212236. INSTALLED IAW SRM.SDR SWAA107424Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 303.9, STR 16L. REPAIRED FRAME PER ACO.SDR SWAA107417Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 847, STR 1. REPAIRED FRAME PER SRM.SDR SWAA107411Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 807, STR 26R. REPAIRED FRAME PER SRM.SDR SWAA107402Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 500C, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME PER EA.SDR SWAA107401Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 500C, BETWEEN STR 27L TO STR 28L. REPAIRED FRAME PER EA.SDR SWAA107400Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 500C, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME PER EA.SDR SWAA107395Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 887, BETWEEN STR 27L TO STR 27R. REPAIRED FRAME PER SRM.SDR SWAA107394Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 907, BETWEEN STR 27L TO STR 27R. REPAIRED FRAME PER SRM.SDR SWAA107393Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 867, BETWEEN STR 27L TO STR 27R. REPAIRED FRAME PER SRM.SDR SWAA107390Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 500C, BETWEEN STR 27R TO STR 28R. REPAIRED FRAME PER EA.SDR SWAA107387Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 500C, BETWEEN STR 28L TO STR 28R. REPAIRED FRAME PER EA.SDR SWAA107386Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 500, BETWEEN STR 28L TO STR 28R. REPAIRED FRAME PER EA.SDR SWAA107385Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 500B, BETWEEN STR 28L TO STR 28R. REPAIRED FRAME PER EA.
Back to JASC 5311