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 AALA20121201011Frame · gougedDEEP GOUGE IN FRAME, FORWARD SIDE OF E AND E ACCESS DOOR CUTOUT. INSTALLED DOUBLER REPAIR PER EA B757-53-027257.SDR QXEA2012120101476Frame · corrodedFRAME 136 FLANGE IS CORRODED STRINGER 30S-32S. REMOVED RIVETS AND CORROSION IAW RD 8/4-53-2344. MIN NOTED THICKNESS .043 REF NTM 51-00-04-910-801 PT 1, VERIFIED AFFECTED AREA TO BE CRACK FREE REF NTM 51-00-06-910-801 PT 1. FLANGES FOUND TO BE IN LIMITS IAW RDSDR QXEA2012120101475Frame · corrodedFRAME 49.5, FLANGES ARE CORRODED STRINGER 32S-28S. REMOVED RIVETS AS NECESSARY AND CORROSION IAW SRM 51-42-05-02-01 AND 51-21-00-00-02 AND RD 8/4-53-2344. MIN NOTED THICKNESS .047 REF NTM 51-00-04-910-801 PT 1, VERIFIED AFFECTED AREA TO BE CRACK FREE REF NTM 5SDR QXEA2012120101472Frame · corrodedFRAME 547, FLANGE IS CORRODED, STRINGER 32P-31P. REMOVED RIVETS AS NECESSARY AND CORROSION IAW RD 8/4-53-2344. MIN NOTED THICKNESS .054 REF NTM 51-00-04-910-801 PT 1, VERIFIED AFFECTED AREA TO BE CRACK FREE REF NTM 51-00-06-910-801 PT 1. MATERIAL LOSS FOUND TSDR QXEA2012120101471Frame · corrodedFRAME 489.5, FLANGES ARE CORRODED STRINGER 33-30P. REMOVED RIVETS TO ACCESS CORROSION IAW SRM 51-42-05-02-01. BLENDED CORROSION PER RD 8/4-53-2344. MIN NOTED THICKNESS .055 REF NTM 51-00-04-910-801 PT 1, CONFIRMED AFFECTED AREA CRACK FREE REF NTM 51-00-06-910-SDR QXEA2012120101470Frame · corrodedFRAME 469.5, FLANGE IS CORRODED STRINGER 32P-31P. REMOVED RIVETS AND CORROSION IAW SRM 51-42-05-02-01 AND RD 8/4-53-2344. MIN NOTED THICKNESS .055 REF NTM 51-00-04-910-801 PT 1, CONFIRMED AFFECTED AREA CRACK FREE REF NTM 51-00-06-910-801 PT 1. FLANGES FOUND TSDR QXEA2012120101469Frame · corrodedFRAME 136, FLANGES ARE CORRODED STRINGER 30P-32P. REMOVED RIVETS AND CORROSION IAW SRM 51-42-05-02-01 AND RD 8/4-53-2344. MIN NOTED THICKNESS .043 REF NTM 51-00-04-910-801 PT 1, CONFIRMED AFFECTED AREA CRACK FREE REF NTM 51-00-06-910-801 PT 1. FLANGES FOUND ISDR QXEA2012120101468Frame · corrodedFRAME 94.8, FLANGES ARE CORRODED, STRINGER 30P-32P. REMOVED RIVETS TO ACCESS CORROSION IAW SRM 51-42-05-02-01 AND RD 8/4-53-2344. MIN NOTED THICKNESS .042 REF NTM 51-00-04-910-801 PT 1, CONFIRMED AFFECTED AREA CRACK FREE REF NTM 51-00-06-910-801 PT 1. DAMAGE SDR QXEA2012120101467Frame · corrodedFRAME BS 71.2, FLANGES ARE CORRODED STRINGER 30S-32S. REMOVED RIVETS AND CORROSION IAW RD 8/4-53-2344. MIN NOTED THICKNESS .039 REF NTM 51-00-04-910-801 PT 1, CONFIRMED AFFECTED AREA CRACK FREE REF NTM 51-00-06-910-801 PT 1. MATERIAL LOSS FOUND IN LIMITS IASDR DALA1255996702Frame · dentedDENT ON AFT CARGO FRAME AT BS 1460 ABOVE STR 26L. REPAIRED IAW SRM 53-00-07, FIG 201, REPAIR 5.SDR DALA1255986702Frame · dentedAFT CARGO FRAME DENTED AT BS 1400 ABOVE STR 26L. REPAIRED IAW SRM 53-00-07, FIG 201, REPAIR 5.SDR ASAA2012120193398Frame Splice · corrodedFUSELAGE FRAME SPLICE AT BS 787, STR 26R FOUND TO BE CORRODED. R & R FRAME SPLICE.SDR CALA2012120400834Frame · crackedA CRACK INDICATION NOTED AT FRAME BS 787 BETWEEN STRINGER 8-9L DURING MFEC INSPECTION. REMOVED DAMAGE IAW EA. FABRICATED AND INSTALLED REPAIR ANGLES IAW EA 5310-04716, REV D.SDR CALA2012120400833Frame · crackedA CRACK INDICATION NOTED AT FRAME BS 380 BETWEEN STRINGER 8-9L DURING MFEC. REMOVED DAMAGE IAW EA FABRICATED AND INSTALLED REPAIR ANGLES IAW EA 5310-04716, REV D.SDR CALA2012120400832Frame · crackedFRAME AT BS 500A SHOWS CRACK INDICATION DURING MFEC INSPECTION, FRAME REPAIRED IAW EA 5310-04716, REV D, OP1 FIG 3.SDR CALA2012120400831Frame · crackedFRAME BS 727D SHOWS CRACK INDICATION BETWEEN STR 8 AND 9L. DURING MFEC INSPECTION. FRAME REPAIRED IAW EA 5310-04716 REV D OP 1 FIG 3.SDR CALA2012120400830Frame · crackedONE STRAP HOLE IN FRAME BS 727D AND 727E BETWEEN STRINGERS 2 AND 3R LINE UP WITH TWO EXISTING HOLES IN FRAMES MAKING THREE IN A LINE ON FRAMES. REF DWG 739N220 FLAG NOTE NR 33 VIEW AF COMPLIED WITH EA 1828, REV IR AND REPAIRED FRAME 727D AND 727E BETWEEN STR SDR SWAA2012122110817Frame · crackedFRAME CRACKED BS 296 WL 208.5 RT SIDE. REPAIRED FRAME BS 296 WL 208 RT SIDE STUB FRAME IAW ER 12-03669 AND EA 1-753-21271.SDR SWAA2012121010407Frame · crackedFUSELAGE FRAME CRACKED AT AIR CONDITIONING ATTACH BRACKET BS 827 STR 8LT. REPAIRED CRACKED FRAME BS 827 STR 8LT IAW EA 1-A53-12114.SDR QXEA2012113001521Frame · corrodedCORROSION ON FRAME -94.2 FWD SIDE ON VERTICAL WEB AT STRINGER 29P. REMOVED CORROSION IAW SRM 51-21-00-00-02. MIN REMAINING THICKNESS .042", CONFIRMED AFFECTED AREA CRACK FREE, REF NTM 51-00-04-910-801 PT 1 AND 51-00-06-910-801 PT 1. DAMAGE IS WITHIN LIMITS IASDR QXEA2012113001487Frame · corrodedFRAME 509.5, FLANGES ARE CORRODED STRINGER 33P-31P. REMOVED FASTENERS FOM IAW IAW RD 8/4-53-2344. BLENDED OUT CORROSION IAW RD 8/4-53-2344. MIN REMAINING THICKNESS .054" NTM 51-00-04-910-801 PT 1. VERIFIED AFFECTED AREA CRACK FREE REF NTM 51-00-06-910-801 PT 1SDR QXEA2012113001486Frame · corrodedFRAME 71.2, FLANGES ARE CORRODED, STRINGER 29P-32P. REMOVED FASTENERS FOM IAW IAW RD 8/4-53-2344. BLENDED OUT CORROSION IAW RD 8/4-53-2344. MIN REMAINING THICKNESS .039" NTM 51-00-04-910-801 PT 1. VERIFIED AFFECTED AREA CRACK FREE REF NTM 51-00-06-910-801 PT SDR QXEA2012113001485Frame · corrodedFRAME 49.5, FLANGE IS CORRODED STRINGER 31P-30P. REMOVED CORROSION IAW RD 8/4-53-2344. MIN REMAINING THICKNESS .050" NTM 51-00-04-910-801 PT 1. CONFIRMED AFFECTED AREA CRACK FREE REF NTM 51-00-06-910-801 PT 1. MATERIAL LOSS FOUND TO BE IN LIMITS IAW RD 8/4-5SDR QXEA2012113001532Frame · corrodedFRAME BS 176, FLANGES ARE CORRODED, STRINGER 29-32P. REMOVED FASTENERS, REPAIR ANGLE AND CORROSION IAW RD 8/4-53-2344. MIN REMAINING THICKNESS .029", CONFIRMED AFFECTED AREAS CRACK FREE REF NTM 51-00-04-910-801 PT 1 AND 51-00-06-910-801 PT 1. FABRICATED AND SDR AALA20121203014Frame · crackedAIR CONDITIONER RAIL FRAME CRACKED LEFT SIDE AT STATION 500D. INSTALLED REPAIR DOUBLER PER ECO J1159AE.SDR AALA20121203013Frame · crackedAIR CONDITIONER RAIL FRAME CRACKED LEFT SIDE AT STATION 480. INSTALLED REPAIR DOUBLER PER ECO J1159AE.SDR AALA20121130011Frame · crackedAIR CONDITIONER RAIL FRAME CRACKED LEFT SIDE AT STATION 440. INSTALLED REPAIR DOUBLER PER ECO J1159AE.SDR AALA20121130010Frame · crackedAIR CONDITIONER RAIL FRAME CRACKED LEFT SIDE AT STATIONS 727B. INSTALLED REPAIR DOUBLER PER ECO J1159AE.SDR SWAA2012121810764Frame · corrodedCARGO COMPARTMENT FRAME AT BS 947 CORRODED LOWER SIDE BETWEEN STR 25R AND 26R. REMOVED AND REPLACED IAW SRM AND DWG.SDR SWAA2012121310599Frame · crackedFUSELAGE FRAME CRACKED AT AIR CONDITIONING ATTACH BRACKET BS 727D STR 8-9R. FRAME WAS REPLACED ON CARD T166212.SDR SWAA2012121310598Frame · crackedFUSELAGE FRAME CRACKED AT AIR CONDITIONING ATTACH BRACKET BS 360 STR 8-9R. REPAIRED CRACK AT A/C BRACKET BS 360 STR 8-9 RT IAW ER 12-03651 EA 1-753-21219.SDR QXEA2012112901526Frame · corrodedFRAME 1, FLANGE IS CORRODED STRINGER 31P-32P. REMOVED RIVETS TO ACCESS CORROSION IAW SRM 51-42-05-02-01. BLENDED CORROSION IAW RD 8/4-53-2344. INSPECTED BLEND WITH HFEC, NO CRACK NOTED REF NDTM PT 6 TASK 51-00-01-250-801. MIN REMAINING THICKNESS .046" REF NDSDR SWAA2012121010404Frame · crackedFUSELAGE FRAME CRACKED AT AIR CONDITIONING ATTACH BRACKET BS 787 STR 8-9R. REPAIRED FUSELAGE FRAME AT AIR CONDITIONING ATTACH BRACKET AT BS 787 STR 8-9R PER EA 1-A53-12114.SDR SWAA2012121010403Frame · crackedFUSELAGE FRAME CRACKED AT AIR CONDITIONING ATTACH BRACKET BS 500C STR 8-9R. REPAIRED FRAME BS 500C STR 8-9RT PER EA 1-A53-12114.SDR SWAA2012121010402Frame · crackedFUSELAGE FRAME CRACKED AT AIR CONDITIONING BRACKET ATTACHMENT BS 500C STR 8-9L. REPAIRED FRAME BS 500C STR 8-9L PER EA 1-A53-12114.SDR QXEA2012112901525Frame · corrodedFRAME FLANGES ARE CORRODED STRINGER 33-31S. REMOVED RIVETS AND BLENDED CORROSION IAW SRM 51-42-05-02-01 AND RD 8/4-53-2344. MIN REMAINING THICKNESS .045", VERIFIED AREA CRACK FREE REF NDTM 51-00-01-250-801 PT 6 AND 51-00-04-910-801 PT 1. FOUND TO BE OUT OF LIMSDR QXEA2012112901524Frame · corrodedFRAME 136, FLANGES ARE CORRODED, STRINGER 33-31S. REMOVED RIVETS AND CORROSION IAW SRM 51-42-05-02-01 AND 51-21-00-00-02. MIN REMAINING THICKNESS .037", CONFIRMED AFFECTED AREA CRACK FREE, REF NTM 51-00-04-910-801 PT 1 AND 51-00-06-910-801 PT 1. FOUND DAMAGE TSDR QXEA2012112901523Frame · corrodedFRAME 388, FLANGE IS CORRODED, STRINGER 31P-32P. REMOVED NECESSARY RIVETS AND CORROSION IAW RD8/4-53-2344 AND 51-21-00-00-02. MIN REMAINING THICKNESS .062", CONFIRMED AFFECTED AREA CRACK FREE, REF NTM 51-00-04-910-801 PT 1 AND 51-00-06-910-801 PT 1. MATERIAL SDR SWAA2012120710363Frame · crackedFUSELAGE FRAME CRACKED AT AIR CONDITIONING ATTACH BRACKET BS 400 STR 8. REPAIRED FRAME AT BS 400 STR 8-9RT PER EA 1-A53-12114.SDR SWAA2012120710362Frame · crackedFUSELAGE FRAME CRACKED AT AIR CONDITIONING BRACKET ATTACHMENT BS 480 STR 8-9L. REPAIRED FRAME BS 480 STR 8-9LT PER EA 1-A53-12114.SDR SWAA2012120710348Frame · crackedFUSELAGE FRAME CRACKED AT AIR CONDITIONING ATTACH BRACKET BS 867 STR 8-9R. REPAIRED CRACKED FRAME BS 867 STR 8R-9R PER EA 1-A53-12114.SDR SWAA2012120710347Frame · crackedFUSELAGE FRAME CRACKED AT AIR CONDITIONING ATTACH BRACKET BS 500A STR 8-9R. REPAIRED BS 500A FRAME AT STR 8-9RT PER EA 1-A53-12114.SDR SWAA2012120510239Frame · crackedFUSELAGE FRAME CRACKED AT AIR CONDITIONING ATTACH BRACKET BS 480 STR 8-9R. REPAIRED FRAME AT BS 480 BETWEEN STR 8R & 9R IAW EA 1-A53-12114.SDR SWAA2012120510238Frame · crackedFUSELAGE FRAME CRACKED AT AIR CONDITIONING BRACKET ATTACHMENT BS 727B STR 8-9L. REPAIRED FUSELAGE FRAME AT AIR CONDITIONING BRACKET ATTACHMENT BS 727B STR 8-9L PER EA 1-A53-12114.SDR SWAA2012120510237Frame · crackedFUSELAGE FRAME CRACKED AT AIR CONDITIONING BRACKET ATTACHMENT BS 500A STR 8-9L. REPAIRED FRAME AT BS 500A BETWEEN STRINGER 8L TO 9L IAW EA 1-A53-12114 REV 2.SDR SWAA2012120510236Frame · crackedFUSELAGE FRAME CRACKED AT AIR CONDITIONING BRACKET ATTACHMENT BS 440 STR 8-9L. REPAIRED FRAME AT BS 440 BETWEEN STRINGER 8L & 9L IAW EA 1A-53-12114.SDR DALA12014469238Frame · corrodedCORROSION AT AFT CARGO BS 1379 FRAME. AFT SIDE AT L30. REMOVED CORROSION. AREA FOUND OUT OF LIMITS WITH 100 PERCENT MATERIAL LOSS. CUT OUT DAMAGED AREA. FABRICATED TWO REPAIR SPLICES AND NEW FORMER. REPAIR INSTALLED IAW SRM 53-00-01, FIG 1 AND 51-10-03 PSDR AALA20121129018Frame · crackedCUT BELL FRAME ANGLE BETWEEN LONGERONS 4 AND 5 RIGHT AT STATION 1338, FOR OTHER MAINTENANCE. INSTALLED BELL FRAME REPAIR ANGLE AND BELL FRAME REPAIR STRAP PER SRM 53-03-00 FIGURE 14 AND EA MD80-53-027258.SDR QXEA2012112901464Frame · corrodedFRAME BS 449.5, FLANGE IS CORRODED STRINGER 32S-31S. REMOVED RIVETS FOM IAW SRM 51-42-05-02-01. REMOVED CORROSION IAW RD 8/4-53-2344. MIN NOTED THICKNESS .067" REF NTM 51-00-04-910-801 PT 1, VERIFIED AFFECTED AREA TO BE CRACK FREE USING HFEC REF NTM 51-00-06-9SDR UALA2012112806807Frame · crackedSTA 1220 LT TENSION TIE FRAME WITH ONE HOLE CRACK REPAIRED. REPLACED THE STA 1220 LT TENSION TIE FRAME PER SRM.
Back to JASC 5311