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 SWAA2012071605881Frame · crackedFRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2012071605880Frame · crackedFRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2012071605879Frame · crackedFRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME IAW EA.SDR QXEA2012062900570Frame · corrodedFRAME X301.000 LOWER FLANGES HAVE CORROSION BETWEEN STRINGERS 28P AND 30P. REMOVED RIVETS AND CORROSION IAW RD 8/4-53-2344. MIN REMAINING THICKNESS .040 REF NTM 51-00-04-910-801 PT 1. MATERIAL LOSS FOUND WITHIN LIMITS IAW RD 8/4-53-2344. INSTALLED RIVETS ISDR DALA1240149264Frame · corrodedAFT ACCY LOWER FRAME SECTION BS 1437 LBL 16 TO RBL 16 HAS CORROSION ON AFT SIDE OF TEE CAP ALSO FUSELAGE SKIN JUST AFT HAS BARE SPOTS. REMOVED CORROSION, FOUND OUT OF LIMITS. REMOVED FRAME SECTION LOCATED AND DRILLED NEW FRAME, TREATED AND PRIMED SKIN AND FRASDR DALA1239490633Frame · dentedSMALL DENT ON INNER FREE FLANGE OF FUSELAGE FRAME STA 1220 ABOVE STR 26R. REPAIRED IAW SRM 53-00-07 REPAIR 5, FIG. 201, DETAIL 2 ENCOMPASSED BY ERA 503771-14 REV ORIGINAL.SDR CHQA20120628208Frame · damagedDURING INSPECTION, A HOLE WAS FOUND IN FRAME 65 ON THE RIGHT SIDE NEAR STRINGER 12R. MAINTENANCE INSTALLED A NEW REPAIR DOUBLER IN ACCORDANCE WITH ETD2012-145-009260.SDR SWAA2012070905585Frame · crackedFRAME CRACKED AT BS 907, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME PER EA.SDR SWAA2012070905584Frame · crackedFRAME CRACKED AT BS 867, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME PER EA.SDR SWAA2012070905583Frame · crackedFRAME CRACKED AT BS 480, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME PER EA.SDR QXEA2012062800591Frame · corrodedFUSELAGE FRAME X1.00 LOWER FLANGE HAS CORROSION BETWEEN STRINGERS 30P AND 32P. REMOVED CORROSION IAW RD 8/4-53-2344. MIN REMAINING THICKNESS .045", CONFIRMED CRACK FREE CONDITION REF NTM 51-00-04-910-801 AND 51-00-06-910-801 PT 1. FOUND FRAME FLANGES OUT OFSDR QXEA2012062800590Frame · corrodedFUSELAGE FRAME X49.500 LOWER FLANGE HAS CORROSION BETWEEN STRINGERS 29S AND 31S. REMOVED RIVETS AND CLEANED CORROSION IAW SRM 51-42-05-02-01, 51-21-00-00-01. MIN REMAINING THICKNESS .043" CONFIRMED CRACK FREE CONDITION REF NTM 51-00-04-910-801 AND 51-00-06-9SDR QXEA2012062800588Frame · corrodedFUSELAGE FRAME X-18.250 AFT SURFACE AND LOWER FLANGES HAVE CORROSION BETWEEN STRINGERS 29S AND 33. REMOVED CORROSION IAW RD 8/4-53-2344. FRAME HAS EXFOLIATION CORROSION. CUT OUT REPLACEMENT FRAME FROM NEW PART IAW RD 8/4-53-4575. CONFIRMED FRAME CUT LINESSDR QXEA2012062800559Frame · corrodedFRAME X196.000, LOWER FLANGES HAVE CORROSION BETWEEN STRINGERS 31P AND 32P. REMOVED AND BLENDED CORROSION. REMOVED RIVETS IAW SRM 51-42-05-02-01 AND 51-21-00-00-02. MIN REMAINING THICKNESS NOTED .039", CONFIRMED CRACK FREE IN AFFECTED AREA REF NTM 51-00-04-SDR QXEA2012062800558Frame · corrodedFRAME AT X176.000, LOWER FLANGE HAS CORROSION BETWEEN STRINGERS 31P AND 32P. REMOVED RIVETS AND REMOVED CORROSION IAW SRM 51-42-05-02-01 AND 51-21-00-00-02. MIN REMAINING THICKNESS .039, CONFIRMED AFFECTED AREA CRACK FREE REF NTM 51-00-04-910-801 AND 51-00-0SDR QXEA2012062800557Frame · corrodedFRAME X116.000 LOWER FLANGES HAVE CORROSION BETWEEN STRINGERS 31S AND 32S. REMOVED FASTENERS FOM AND REMOVED CORROSION IAW SRM 51-21-00-00-02 AND 51-42-05-02-01. MIN REMAINING THICKNESS .038 CONFIRMED AFFECTED AREA CRACK FREE REF NTM 51-00-04-910-801 AND 51-SDR QXEA2012062800556Frame · corrodedFRAME X156.000 LOWER FLANGES HAVE CORROSION BETWEEN STRINGERS 31P AND 32P. REMOVED RIVETS AND CORROSION IAW RD 8/4-53-2344. MIN REMAINING THICKNESS .039 CONFIRMED AFFECTED AREAS CRACK FREE REF NTM 51-00-04-910-801 AND 51-00-06-910-801 PT 1. MATERIAL LOSS FOSDR QXEA2012062800555Frame · corrodedFRAME X116.000 LOWER FLANGES HAVE CORROSION BETWEEN STRINGERS 31P AND 32P. REMOVED RIVETS FOM AND REMOVED CORROSION IAW SRM 51-21-00-00-02 AND SRM 51-42-05-02-01. CONFIRMED AFFECTED AREA CRACK FREE REF NTM 51-00-06-910-801 PT 1. MATERIAL LOSS FOUND TO BE INSDR QXEA2012062800579Frame · corrodedFUSELAGE FRAME X71.2 LOWER FLANGE HAS CORROSION BETWEEN STRINGER 28S AND 29S. REMOVED CORROSION IAW SRM 51-21-00-00-02. FLANGE FOUND OUT OF LIMITS IAW RD 8/4-53-2344. CUT FRAME FLANGE IAW RD 8/4-53-017. CONFIRMED FRAME CRACK FREE AFTER FLANGE REMOVED USINGSDR QXEA2012062800578Frame · corrodedFOUND FRAME X49.500 LOWER FLANGES CORRODED BETWEEN STRINGERS 31P AND 31S. REMOVED RIVETS FOM IAW SRM 51-42-05-02-01. REMOVED CORROSION AND BLENDED IAW RD 8/4-53-2344. CONFIRMED CRACK FREE REF NTM 51-00-04-910-801 AND 51-00-06-910-801 PT 1. MATERIAL LOSS FOSDR QXEA2012062800576Frame · corrodedFUSELAGE FRAME X71.200 LOWER FLANGE CORROSION BETWEEN STRINGERS 30S AND 31S. REMOVED RIVETS IAW SRM 51-42-05-02-01. REMOVED CORROSION IAW SRM 51-21-00-00-02. DAMAGE FOUND TO BE OUT OF LIMITS IAW RD 8/4-53-2344. CUT FRAME SECTION AS REQUIRED IAW RD 8/4-53-0SDR QXEA2012062800575Frame · corrodedFUSELAGE FRAME X1.00 LOWER FLANGE HAS CORROSION BETWEEN STRINGERS 29S AND 33. REMOVED RIVETS AND REMOVED CORROSION IAW RD 8/4-53-2344. CONFIRMED CRACK FREE CONDITION REF NTM 51-00-04-910-801 AND 51-00-06-910-801 PT 1. FOUND TO BE WITH IN LIMITS IAW RD 8/4-5SDR QXEA2012062800574Frame · corrodedFUSELAGE FRAME X32.400 LOWER FLANGE HAS CORROSION BETWEEN STRINGERS 28S AND 30S. REMOVED RIVETS AND CLEANED CORROSION IAW RD 8/4-53-2344. CONFIRMED AREAS TO BE CRACK FREE REF NTM 51-00-01-250-801. MIN REMAINING THICKNESS .038 CONFIRMED CRACK FREE CONDITION SDR QXEA2012062800573Frame · corrodedFUSELAGE FRAME X116.000 LOWER FLANGE HAS CORROSION BETWEEN STRINGERS 30S AND 32S. REMOVED CORROSION IAW RD 8/4-53-2344. CONFIRMED AREAS TO BE CRACK FREE REF NTM 51-00-01-250-801, PT 6. PERFORMED UT THICKNESS OF BLENDS IAW NTM 51-00-04-910-801, PT 1. MINIMUSDR IPXA12574515Frame · damagedINSPECTION TYPE: C, LOWER LOBE INTERIOR RT BS 377.7 FRAME DAMAGED STRINGER 23R. REMOVED DAMAGE, FABRICATED AND INSTALLED DOUBLER IAW EA 120836 IR AND EO B757-5310-47945-A.SDR QXEA2012062700577Frame · corrodedFUSELAGE FRAME X19.400 LOWER FLANGE HAS CORROSION BETWEEN STRINGERS 28S AND 33. REMOVED RIVETS IAW RD 8/4-53-2344 AND BLENDED CORROSION IAW SRM 51-21-00-00-02. REMOVED FLOORBOARD SUPPORT RAIL FRAME IAW SRM 51-42-05-02-01. MATCH DRILLED NEW FRAME IAW SRM 51-SDR AALA20120628009Frame · corrodedSTATION 1219 J-CAP IS HEAVILY CORRODED JUST LEFT OF CENTER ON UPPER HORIZONTAL FLANGE. REPLACED J-CAP PER SRM 51-10-02.SDR AALA20120628008Frame · corrodedSTATION 1197 + 66 CARGO FLOOR INNER J-FRAME CORRODED. REPLACED J-CAP PER SRM 51-10-02.SDR AALA20120627016Frame · crackedTHE 1485 CANT FRAME CRACKED BELOW AFT AIRSTAIR RETRACT ACTUATOR. ACCOMPLISHED SPLICE REPAIR PER AARD 53-10-00-33.SDR FDEA201206272367Frame · damagedFRAME 24 AT STRINGER 13R WAS FOUND WITH VISIBLE DISTORTION TO UNDERLYING FRAME SPLICES. FOUND FRAME SECTION DAMAGE BEYOND ECONOMICAL REPAIR AND R & R FRAME SECTIONS BETWEEN STRINGERS 8R TO 22R IAW SRM 51-72-10, PAGES 1 TO 3, SRM 51-40-21, PG 10 TO 22, DRILLESDR FDEA201206262349Frame · wornAFT CARGO BAY, ELONGATED FASTENER HOLE IN UPPER FLANGE OF FRAME AT BS 1030, LBL 25. CUT OUT DAMAGED AREA OF FRAME 1/2" X7/8" IAW SRM REV 103 51-40-3 FIG 1. FABRICATED REPAIR DOUBLER FROM 7075-0,.063"X 14"X 4 1/2" IAW SRM 51-40-3 AND SRM 51-30-5 INSTALLEDSDR SIMA20120625011Frame · corrodedFRAME 20 IS CORRODED BEYOND LIMITS. REPAIRED.SDR SWAA2012071705895Frame · crackedFRAME CRACKED AT BS 360, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME IAW EA.SDR SWAA2012071605883Frame · crackedFRAME CRACKED AT BS 907, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME IAW EA.SDR SWAA2012071205721Frame · crackedFRAME CRACKED AT BS 360, STR 8L. REPAIRED FRAME PER ER AND EA.SDR SWAA2012070605580Frame · crackedFUSELAGE FRAME CRACKED AT BS 520, STR 8L. REPAIRED FRAME PER EA.SDR SWAA2012070605579Frame · crackedFUSELAGE FRAME CRACKED AT BS 500C, STR 8L. REPAIRED FRAME PER EA.SDR SWAA2012070605578Frame · crackedFUSELAGE FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER EA.SDR SWAA2012070605577Frame · crackedFUSELAGE FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER EA.SDR SWAA2012070605576Frame · crackedFUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER EA.SDR SWAA2012070605575Frame · crackedFUSELAGE FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER EA.SDR SWAA2012062805401Frame · crackedFRAME CRACKED AT BS 747, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME PER EA.SDR SWAA2012062805400Frame · crackedFRAME CRACKED AT BS 480, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME PER EA.SDR SWAA2012062805399Frame · crackedFRAME CRACKED AT BS 787, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME PER EA.SDR SWAA2012062805398Frame · crackedFRAME CRACKED AT BS 400, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME PER EA.SDR SWAA2012062805397Frame · crackedFRAME CRACKED AT BS 787, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME PER EA.SDR SWAA2012062805396Frame · crackedFRAME CRACKED AT BS 827, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME PER EA.SDR QXEA2012062500543Frame · corrodedFUSELAGE FRAME X281.000 LOWER FLANGE HAS CORROSION BETWEEN STR 27P AND 28P. REMOVED RIVETS IAW SRM 51-42-05-02-01. REMOVED CORROSION IAW RD 8/4-53-2344. MATERIAL LOSS FOUND WITHIN LIMITS IAW RD 8/4-53-2344. ALODINED AND PRIMED IAW RD 8/4-53-2344. INSTALLESDR DALA1238860934Frame · crackedDURING HMV, A CRACK WAS FOUND ON FUSELAGE FRAME OVERWING OF THE STA Y=864 AND X=55 AT THE CABIN FLOOR STRUCTURE. FRAME WAS REPLACED IAW DWG SR09530282 REV C.SDR AALA20120625012Frame · crackedFRAME CRACKED AT SUPPORT BRACKET FOR AIR CONDITIONING RAIL AT STATION 500C LEFT. INSTALLED DOUBLER PER EA B737-53-024502.
Back to JASC 5311