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 DALA13002336307Frame · crackedDURING OPEN HOLE HFEC INSPECTION ON RT SIDE BS 1120 TENSION TIE, FOUND ONE CRACK AT FRAME, LOWER ROW 2ND FASTENER HOLE FROM OTBD. FRAME R & R IAW SRM 51-40-02 BETWEEN S-4 AND S11R AND FAILSAFE REPAIR CARRIED OUT SRM 51-70-11, FIG 1.SDR DALA1306956705Frame · bentAFT CARGO BS 1600, S26L FRAME IS BENT. REPAIRED IAW SRM 53-00-07, FIG 201, REPAIR 5.SDR SWAA2013021112495Frame · corrodedFRAME CORRODED AT BS 500 AND LEVEL STR 26R CARGO DOOR CUT OUT. REPAIRED FRAME IAW EA.SDR SWAA2013020412259Frame · crackedFRAME CRACKED AT BS 500C, BETWEEN STR 20L AND 21L. REPAIRED FRAME IAW SRM.SDR SWAA2013020112193Frame · crackedFRAME CRACKED AT BS 500D, BETWEEN STR 20R AND STR 21R. REPAIRED FRAME IAW SRM.SDR ASOA2013013102941Frame · corrodedCORROSION ON FWD FACE OF FRAME AT FS 349, STR 27. REMOVED CORROSION ON FWD FACE OF FRAME 349 AT STR 27 IAW SRM 51-21-06-001-001. ORIGINAL MATERIAL THICKNESS .050" IAW SRM 53-21-06-991-806. RECEIVED AND COMPLIED WITH REO 690-53-21-423.SDR QXEA2013011500040Frame · corrodedFRAME 32.4, FLANGE IS CORRODED STR 32P-31P. REMOVED 4 RIVETS AND CORROSION IAW RD 8/4-53-2344. MIN THICKNESS NOTED .037", CONFIRMED CRACK FREE REF NTM 51-00-04-910-801, PT 1 AND 51-00-06-910-801 PT 1. MATERIAL LOSS FOUND TO BE IN LIMITS IAW RD 8/4-53-2344. SDR GLBA2013011500158Frame · crackedDURING A SCHEDULED ROUTINE INSPECTION, FOUND FRAME CRACKED AT THE AFT LOWER CARGO DOOR FRAME AT FS 509.5, 2 INCHES IN LENGTH. REPAIRED IAW EO 13-1900-53-002.SDR GLBA2013011500157Frame · crackedDURING A SCHEDULED ROUTINE INSPECTION, FOUND FRAME CRACKED AT FS 107, LT SIDE FRAME BEHIND FINGER DOUBLER IN THE BEND RADIUS, 1" IN LENGTH. REPAIRED IAW EO 13-1900-53-004.SDR ASOA20130115231Frame · corrodedGALLEY AFT STEP-UP CORRODED BEYOND LIMITS. R & R LOWER PORTION OF GALLEY AFT STEP-UP.SDR IPXA13576980Frame · corrodedINSPECTION TYPE:S4C8, APU INLET DOOR HSG CUT-OUT FWD FRAME CORRODED. REMOVED AIR INTAKE HSG IAW 49-15-08-004-001, EMP: 05948. UPON REMOVAL OF AIR INTAKE HSG FOUND MORE CORROSION ON THE MATING SURFACES OF THE UPPER LOWER AND AFT SUPPORT FLANGES. REMOVED 9EASDR SWAA2013020412311Frame · corrodedFRAME CORRODED AT BS 747 AND BETWEEN STR 25L TO 26L CARGO COMPARTMENT. REPAIRED FRAME IAW SRM AND DWG.SDR SWAA2013020112226Frame · crackedCRACK ON FRAME LOCATED BS 947.5 AND S-18L IN AFT CARGO COMPARTMENT. REPLACED SECTION OF FRAME LOCATED BS 947.5 BETWEEN STR 17L TO STR 24L IAW B737-300 SRM 51-10-02 PAR 8 51-40-02 AND DWG 365-46947SDR ASOA2013013102932Frame · corrodedCORROSION ON AFT FLANGE OF FRAME AT FS 295, STR 26L TO 26R. REMOVED CORROSION IAW SRM 51-42-06-001-001 & 51-21-06-001-001. COMPLIED WITH REO 690-53-21-423.SDR ASOA2013013102931Frame · corrodedAFT FLANGE OF FRAME CORRODED AT FS 349, STR 26L TO 26R. REMOVED CORROSION IAW SRM 51-42-06-001-001 & 51-21-06-001-001. COMPLIED WITH REO 690-53-21-423.SDR ASOA2013013002928Frame · corrodedAFT FLANGE OF FRAME CORRODED AT FS 333, STR 27 TO 26R. RECEIVED AND COMPIED WITH REO 690-53-21-423.SDR SWAA2013012811971Frame · corrodedCORRODED ON FRAME BS 500C BETWEEN STR 28L TO 28R CARGO COMPARTMENT. REPAIRED FRAME IAW SRM.SDR SWAA2013012811970Frame · corrodedCORRODED ON FRAME BS 500C BETWEEN STR 28L TO 28R CARGO COMPARTMENT. REPAIRED FRAME IAW SRM.SDR AALA20130114013Frame · crackedFRAME CRACKED AT STATION 500F, STRINGER 7 RIGHT. ACCOMPLISHED NESTED ANGLE REPAIR PER ECO J1159AE/0004.SDR AALA20130114011Frame · crackedFRAME CRACKED AT STATION 480R, STRINGER 7 RIGHT. ACCOMPLISHED NESTED ANGLE REPAIR PER ECO J1159AE/0004.SDR AALA20130114010Frame · crackedFRAME CRACKED AT STATION 400R, STRINGER 7 RIGHT. ACCOMPLISHED NESTED ANGLE REPAIR PER ECO J1159AE/0004.SDR AALA20130114009Frame · crackedFRAME CRACKED AT STATION 867L, STRINGER 7 LEFT. ACCOMPLISHED NESTED ANGLE REPAIR PER ECO J1159AE/0004.SDR AALA20130114008Frame · crackedFRAME CRACKED AT STATION 480L, STRINGER 7 LEFT. ACCOMPLISHED NESTED ANGLE REPAIR PER ECO J1159AE/0004.SDR AALA20130114007Frame · crackedFRAME CRACKED AT FASTENER HOLE, STATION 400L AT STRINGER 7 LEFT. ACCOMPLISHED NESTED ANGLE REPAIR PER ECO J1159AE/0004.SDR AALA20130114006Frame · crackedFUSELAGE FRAME CRACKED AT FASTENER HOLE, STATION 380L AT STRINGER 7 LEFT. INSTALLED NETSED ANGLE REPAIR PER ECO J1159AE/0004.SDR SIMA20130113009Frame · corrodedDURING 3C CHECK FOUND FRAME AT FS 333.00 CORRODED BETWEEN STRINGERS 26 LEFT AND 26 RIGHT. THE AIRCRAFT WAS REMOVED FROM SERVICE. COMPLIED WITH EO-CR-53MR-313 FOR REPAIR. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR SWAA2013012111676Frame · crackedAD DRIVEN ACO# 8323-53: STA 867 FRAME IS CRACKED AT AIR CONDITIONING BRACKET I/B FASTENER AT STR 8R. ACCOMPLISHED IAW EA 1-A53-12114 REV 2 STA 867 FRAME IS CRACKED AT AIR CONDITIONING BRACKET I/B FASTENER AT STR 8RT.SDR SWAA2013012111614Frame · corrodedFRAME CORRODED AT BS 500C, BETWEEN STR 28R AND STR 27R. REPAIRED FRAME IAW SRM.SDR UALA2013011400233Frame · damagedAFT CARGO BAY FRAME BS 1240 ABOVE S27R, SIDE PLATE ATTACH FASTENER HOLE ELONGATED. CUTOUT DAMAGE AND INSTALLED L ANGLE REPAIR DOUBLER PER ECRA 5360-01239. MAJOR REPAIR.SDR CALA2013011400039Frame · crackedRT FUSELAGE FRAME BS 380 BETWEENS STRINGERS 8 & 9R HAS CRACKED AT RIVETS ATTACHING BRACKET. INSTALLED REPAIR ANGLES DOUBLERS AND VERIFY ALL STEPS AND ATTACH HEAT TREAT FORM 43-0150 ARE COMPLIED REF ECRA 5311-01582.SDR ASOA20130113224Frame · corrodedFRAME 65, CORRODED BEYOND LIMITS FORWARD OF CARGO DOOR SILL. BLENDED OUT CORROSION AND INSTALLED A DOUBLER.SDR SWAA2013021512730Frame · crackedCRACK IN BS 663 FRAME AT I/B SIDE OF STRINGER 3L MOUSE HOLE. CRACK IN BS 663 FRAME AT I/B SIDE OF STRINGER 3L MOUSE HOLE WAS REPAIRED IAW ATS ER 13-01224 DATED 08FEB13 AND EA 1-353-21682.SDR SWAA2013021512729Frame · crackedCRACK IN BS 663 FRAME AT I/B SIDE OF STRINGER 2L MOUSE HOLE. CRACK IN BS 663 FRAME AT I/B SIDE OF STR 2L MOUSE HOLE WAS REPAIRED IAW ATS ER 13-01224 DATED OF 08FEB2013 AND EA 1-353-21682.SDR SWAA2013013012140Frame · crackedFRAME AT BS 907 AC BRACKET STR 8L CRACKED. REPAIRED FRAME IAW EA.SDR SWAA2013013012139Frame · crackedAD DRIVEN ACO# 8323-53: STA 360 FRAME CRACKED AT AIR CONDITIONING BRACKET INBD FASTENER AT STR 8R. REPAIRED STA 360 FRAME CRACK AT STR 8R AC BRACKET IAW EA 130067 IR AND 1-753-21516 REV- FACT AS A RESULT OF POST REPAIR INSPECTION.SDR SWAA2013012811984Frame · crackedAD DRIVEN SI 8212-53 FRAME BS 500A AT AC BRACKET AT STRINGER 8L IS CRACKED. REPAIRED FRAME AT BS 500A AT AC BRACKET AT STRINGER 8L IAW EA 1-A53-12114 REV 2.SDR SWAA2013012111675Frame · crackedAD DRIVEN ACO# 8323-53: STA 747 FRAME IS CRACKED AT AIR CONDITIONING BRACKET I/B FASTENER AT STR 8R. ACCOMPLISHED IAW EA 1-A53-12114 REV 2 STA 747 FRAME IS CRACKED AT AIR CONDITIONING BRACKET I/B FASTENER AT STR 8RT.SDR SWAA2013012111674Frame · crackedAD DRIVEN ACO# 8323-53: STA 727D FRAME IS CRACKED AT AIR CONDITIONING BRACKET I/B FASTENER AT STR 8R. REPAIRED CRACK AT STA 727D AT STR 8R IAW EA 1-A53-12114 REV 2.SDR SWAA2013012111673Frame · crackedAD DRIVEN ACO# 8323-53: STA 727B FRAME IS CRACKED AT AIR CONDITIONING BRACKET I/B FASTENER AT STR 8R. REMOVED DAMAGE AT STA 727B ON AC BRACKET OF STR 8R AND REPAIRED FRAME IAW EA 1-A53-12114 REV 2.SDR SWAA2013012111672Frame · crackedAD DRIVEN ACO# 8323-53: STA 727A FRAME IS CRACKED AT AIR CONDITIONING BRACKET I/B FASTENER AT STR 8R. REMOVED DAMAGE AT FRAME 727A AT STR 8R AND REPAIRED DAMAGED FRAME IAW EA 1-A53-12114 REV 2.SDR SWAA2013012111671Frame · crackedAD DRIVEN SI 8212-53 FRAME AT BS 867 AT AC BRACKET AT STRINGER 8L IS CRACKED. REMOVED DAMAGE AT FRAME 867 STR 8L AND REPAIRED DAMAGED FRAME IAW EA 1-A53-12114 REV 2.SDR SWAA2013012111670Frame · crackedAD DRIVEN ACO# 8323-53: STA 597 FRAME IS CRACKED AT AIR CONDITIONING BRACKET I/B FASTENER AT STR 8R. ACCOMPLISHED REPAIR IAW EA 1-A53-12114 REV 2 AT STA 597 STR 8R.SDR SWAA2013012111669Frame · crackedAD DRIVEN ACO# 8323-53: STA 520 FRAME IS CRACKED AT AIR CONDITIONING BRACKET I/B FASTENER AT STR 8R. ACCOMPLISHED ON EA 1-A53-12114 REV 2 AT STA 520 STR 8R.SDR SWAA2013012111668Frame · crackedAD DRIVEN ACO# 8323-53: STA 500A FRAME IS CRACKED AT AIR CONDITIONING BRACKET I/B FASTENER AT STR 8R. REPAIRED STA 500A STRINGER 8R FRAME CRACK IAW EA 1-A53-12114 REV 2.SDR SWAA2013012111667Frame · crackedAD DRIVEN SI 8212-53 FRAME AT 747 AT AC BRACKET AT STRINGER 8L IS CRACKED. REPAIRED CRACK AT STA 747, STR 8L IAW EA 1-A53-12114 REV 2.SDR SWAA2013012111666Frame · crackedAD DRIVEN ACO# 8323-53: STA 480 FRAME IS CRACKED AT AIR CONDITIONING BRACKET I/B HOLE AT STR 8R. REPAIRED CRACK AT STA 480 STR 8R IAW EA 1-A53-12114 REV 2.SDR SWAA2013012111665Frame · crackedAD DRIVEN SI 8212-53 FRAME AT BS 520 AT AC BRACKET AT STRINGER 8L IS CRACKED. REMOVED DAMAGE AT FRAME BS 520 STR 8L. REPAIRED FRAME CRACK AT STA 520 STRINGER 8L IAW EA 1-A53-12114 REV 2.SDR SWAA2013012111664Frame · crackedAD DRIVEN SI 8212-53 FRAME AT BS 480 AT AC BRACKET AT STRINGER 8L IS CRACKED. REMOVED DAMAGE AND PERFORMED FRAME REPAIR AT STA 480L STR 8L REF EA 1-A53-12114 REV 2.SDR SWAA2013012111663Frame · crackedAD DRIVEN SI 8212-53 FRAME AT BS 440 AT AC BRACKET AT STRINGER 8L IS CRACKED. REPAIRED CRACK AT STA 440L STR 8L IAW EA 1-A53-12114 REV 2.SDR SWAA2013012111662Frame · crackedAD DRIVEN ACO# 8323-53: STA 400 FRAME CRACKED AT I/B FASTENER AT AIR CONDITIONING BRACKET AT STR 8R. REMOVED DAMAGE AND PERFORMED FRAME REPAIR AT STA 400R STR 8R REF EA 1-A53-12114 REV 2.
Back to JASC 5311