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 FDEA201109274152Frame · dentedFRAME BS 1701 L12R, FOUND DENTED. REPAIR CARRIED OUT AS PER SRM 53-00-07 FIG. 201 REPAIR 2 REV 47. REPAIR CLASSIFIED MAJOR AS PER GMM 6-2-100 REV 112.SDR FDEA201109274151Frame · dentedFRAME BS 1681, L12R, FOUND DENTED. REPAIRED IAW SRM 53-00-07 FIG.201 REPAIR 2 REV 47. REPAIR CLASSIFIED AS MAJOR GMM 6-2-100 REV 112.SDR DALA1158391702Frame · crackedMID LT STA 903 STR 20-21 FRAME INNER CHORD FOUND CRACKED AND REPAIRED IAW ER/A496337-14AD REV 0.SDR DALA1158381702Frame · crackedM/D RIGHT STA 903 STR 20-21 FRAME INNER CHORD FOUND CRACKED AND SUBJECT INNER CHORD. REPAIRED IAW ER/A 496336-14AD REV 1.SDR AALA20111005AFW02Frame · dentedFOUND TYPICAL DENT DAMAGE TO THE STATION 500 FUSELAGE FRAME INNER CHORD ABOVE STRINGER 31 LEFT DUE TO IMPACT DAMAGE FROM CARGO PALLETS. FABRICATED AND INSTALLED REPAIR ANGLE PER EA B767-53-019173.SDR DALA1156750966Frame · crackedDURING PSV, PAX MOD VISIT IN MSP FOUND AFT FUSELAGE TAIL CONE ATTACH FRAME STA 1510 CRACKED AT 2ND ALIGNMENT PIN BELOW UPPER RT LATCH ASSY. INSTALLED NEW FRAME SECTION PER MD88 SRM 53-03 FIG 802D.SDR DALA1156110138Frame · corrodedFWD C/C FS 654+121 LBL 38 FRAME UPPER CHORD IS CORRODED BEYOND LIMITS. CHORD REPLACED PER B767-300 SRM 51-10-02 AND INSTALLED PER B767-300 SRM 51-40-02.SDR USAA2011092800002Frame · crackedFRAME HOLE INSP - CRACK IN FUSELAGE FRAME BETWEEN 500B, BETWEEN S20R TO S21R. REPAIRED FUSELAGE FRAME BETWEEN 500B, BETWEEN S20R TO S21R IAW EA 200950.SDR QXEA2011092900912Frame · corrodedFRAME 54.0, FLANGES FROM STR 31P TO 29P ARE CORRODED. REMOVED CORROSION IAW RD 8/4-53-2344. CONFIRMED CRACK FREE AREA REF NTM 51-00-02-250-801. FRAME FLANGE FOUND TO BE WITHIN LIMITS IAW RD 8/4-53-2344. ALODINED, PRIMED, PAINTED AND APPLIED CPC IAW SRM 51-SDR QXEA2011092800906Frame · corrodedFRAME 69.4, FLANGES FROM STR 29P TO 32S ARE CORRODED. REMOVED CORROSION IAW RD 8/4-53-2344. BLENDED AREAS FOUND TO BE WITHIN LIMITS IAW RD 8/4-53-2344. CONFIRMED AREA TO BE CRACK FREE REF NTM 51-00-01-250-801. ALODINED, PRIMED, PAINTED AND APPLIED CPC IAW SDR QXEA2011092800905Frame · corrodedFRAME 54.0, FLANGE FROM STR 33 TO 32S IS CORRODED. REMOVED CORROSION IAW RD 8/4-53-2344. CONFIRMED AREA TO BE CRACK FREE REF NTM 51-00-02-250-801. MATERIAL LOSS FOUND TO BE WITHIN LIMITS IAW RD 8/4-53-2344. ALODINED, PRIMED, PAINTED AND APPLIED CPC IAW SRSDR DALA1155540138Frame · corrodedFWD C/C FS 654+121 LBL 38 FRAME UPPER CHORD IS CORRODED BEYOND LIMITS.SDR KCSA111216Frame · crackedBS 280 RT NOSE WHEEL WELL BULKHEAD FRAME HAS THREE CRACKS AT STANDOFF HOLE APPROX WL 145, 175 AND 188.SDR FDEA201109254120Shear Tie · corrodedCARGO BAY HAS CORROSION ON SHEAR TIE AT BS 700 BETWEEN S27-28L REMOVED, FABRICATED, AND INSTALLED NEW SHEAR TIE IAW SRM 53-10-4, FIG 11.SDR FDEA201109244105Frame · corrodedFRAME CORRODED ON FWD SIDE BS 950A BETWEEN S29L-28L. REMOVED DAMAGED AREA IAW B727 SRM 51-40-3 FIG 1. FABRICATED REPAIR DOUBLER IAW SRM 51-40-3 FIG 1 AND 53-10-2 FIG 1. INSTALLED REPAIR DOUBLER IAW SRM 51-40-3 FIG 1.SDR QXEA2011092600894Frame · corrodedFRAME 32.4 UPPER TIE TO INTERCOASTAL 28P IS CORRODED. REMOVED CORROSION IAW SRM 51-21-00-00-02. MINIMUM REMAINING THICKNESS .037". CONFIRMED AREA CRACK FREE REF NTM 51-00-02-250-801 AND 51-00-01-250-801. FABRICATED PART USING 7075-T6 .040" IAW DWG 85329356SDR IPXA1569672Frame · dentedINSPECTION TYPE:C-CK, AFT PIT STA 1540 FRAME DENTED BETWEEN S-26R AND S-27R. REPAIRED AFT PIT FRAME STA 1540 BETWEEN S-26R AND S-27R IAW SRM 53-00-07-02R, REPAIR 5.SDR AALA20110923TUL09Frame · crackedCRACK IN FRAME 887 RIGHT AT AIR CONDITIONING RAIL BRACKET. REPLACED ANGLE PER ECO J1159AD.SDR AALA20110923TUL08Frame · crackedCRACK ON FRAME 500 D RIGHT AT AIR CONDITIONING RAIL BRACKET. REPLACED ANGLE PER ECO J1159AD.SDR AALA20110923TUL07Frame · crackedCRACK IN FRAME 480 RIGHT AT AIR CONDITIONING RAIL BRACKET. REPLACED ANGLE PER ECO J1159AD.SDR AALA20110923TUL06Frame · crackedCRACK IN FRAME 400 RIGHT AT AIR CONDITIONING RAIL BRACKET. REPLACED ANGLE PER ECO J1159AD.SDR AALA20110923TUL05Frame · crackedCRACK IN FRAME 787 LEFT AT AIR CONDITIONING RAIL BRACKET. REPLACED ANGLE PER ECO J1159AD.SDR AALA20110923TUL04Frame · crackedCRACK IN FRAME 737B AT AIR CONDITIONING RAIL BRACKET. REPLACED ANGLE PER ECO J1159AD.SDR AALA20110923TUL03Frame · crackedCRACK ON FRAME LEFT HAD AIR CONDITIONING RAIL BRACKET. REPLACED ANGLE PER ECO J1159AD.SDR DALA1156670966Frame · crackedDURING PSV, PAX MOD VISIT IN MSP FOUND AFT FUSELAGE TAIL CONE ATTACH FRAME STA 1510 CRACKED AT 1ST ALIGNMENT PIN ABOVE LOWER LEFT LATCH ASSY. INSTALLED DOUBLER REPAIR PER MD88 SRM53-03D FIG 802.SDR UALA2011092605162Frame · dentedAFT PIT BELT FRAME DENTED JUST OTBD OF LEFT TRANSITION PANEL, AT BS 1420. REMOVED & INSTALLED NEW BELT FRAME FROM STR 24L TO 27L.SDR QXEA2011092900909Frame · corrodedFRAME 156, FLANGES STR 27P TO 32P ARE CORRODED. REMOVED CORROSION IAW SRM 51-21-00-00-02 AND RD 8/4-53-2344. FOUND CORROSION BEYOND LIMITS ON FRAME FLANGE BETWEEN STR 28P AND 29P. MINIMUM REMAINING THICKNESS .037" CONFIRMED CRACK FREE REF NTM 51-00-02-250-8SDR FDEA201109234098Frame · misrepairedFUSELAGE FRAME STA 1320 BETWEEN S-25R AND S-26R MISREPAIRED. R & R FRAME BETWEEN S-24R - S-24L IAW SRM 51-40-02. MAJOR REPAIR.SDR QXEA2011092600888Frame · corrodedFRAME 236, FLANGES STR 30P TO 32P ARE CORRODED. REMOVED SURFACE CORROSION AND BLENDED IAW RD 8/4-53-2344. CONFIRMED AREA CRACK FREE REF NTM 51-00-02-250-801 AND 51-00-01-250-801. MATERIAL LOSS WITHIN LIMITS OF RD 8/4-53-2344. COMPLETED REPAIR IAW RD 8/4-53SDR QXEA2011092600887Frame · corrodedFRAME 94.8 FLANGES STR 30P TO 32P ARE CORRODED. REMOVED CORROSION AND BLENDED IAW RD 8/4-53-2344. CONFIRMED AREA CRACK FREE REF NTM 51-00-02-250-801 AND 51-00-01-250-801. MATERIAL LOSS WITHIN LIMITS OF RD 8/4-53-2344. COMPLETED REPAIR IAW RD 8/4-53-2344.SDR QXEA2011092600886Frame · corrodedFRAME 116, FLANGES STR 30P TO 32P ARE CORRODED. REMOVED CORROSION AND BLENDED IAW SRM 51-21-00-00-02. MATERIAL LOSS WITHIN LIMITS OF RD 8/4-53-2344. COMPLETED REPAIR RD 8/4-53-2344.SDR IPXA11569799Frame · dentedINSPECTION TYPE:C-CK, FWD CARGO COMPARTMENT FRAME AT STA 760 STR 24R IS DENTED. INSTALLED REPAIR MADE FROM .071 70750-T6 IAW SRM 53-00-07-2R, REPAIR 5, DETAIL 111.SDR IPXA11569732Frame · dentedINSPECTION TYPE:C-CK, AFT PIT, STA 1480 FRAME DENTED, STATION 1480, LBL 30, AT STRINGER 26L. REMOVED DAMAGE AND REPAIRED STA 1480 FRAME AT STR 26L BY INSTALLING REPAIR DOUBLER MADE FROM 7075-T6 .063 SAME THICKNESS AS FRAME ORIGINAL MATERIAL IAW SRM 53-00-07-2SDR IPXA1569670Frame · dentedINSPECTION TYPE:C-CK, FWD CARGO COMPARTMENT STA 680 FRAME DENTED BETWEEN S-24L AND S-25L. REPAIRED FWD CARGO COMPARTMENT STA 680 FRAME BETWEEN S-24L AND S-25L IAW SRM 53-00-07-2R REPAIR 5 AND EA 111281 IR REV A AND EO B757-5310-44545-B.SDR IPXA11569612Frame · dentedINSPECTION TYPE:C-CK, AFT PIT STA 1520 FRAME DENTED BETWEEN S-25L AND S-26L. REPAIRED AFT PIT FRAME STA 1520 BETWEEN S-25L AND S-26L IAW SRM 53-00-07-2R, REPAIR 5 DETAIL 3.SDR IPXA1569596Frame · dentedINSPECTION TYPE:C-CK, FWD CARGO COMPARTMENT STA 720 FRAME DENTED BETWEEN S-23L AND S-24L. REPAIRED FWD CARGO COMPARTMENT FRAME STA 720 BETWEEN S-23L AND S-24L IAW SRM 53-00-07-2R, REPAIR 5, DETAIL 1.SDR IPXA1569534Frame · dentedINSPECTION TYPE:C-CK, FWD CARGO COMPARTMENT FRAME STA 720 ABOVE S-23R IS DENTED. REPAIRED FWD CARGO COMPARTMENT FRAME STA 720 ABOVE S-23R IAW SRM 53-0 0-07-2R REPAIR 5, DETAIL 1.SDR QXEA2011092900916Frame · corrodedFRAME 38.4, UPPER TIE TO INTERCOSTAL 28P IS CORRODED. REMOVED CORROSION IAW SRM 51-21-00-00-02. MATERIAL LOSS FOUND OUT OF LIMITS. FABRICATED NEW PART IAW TASK CARD 6-53-1014. COMPLIED WITH TASK CARD 6-53-1014. PRIMED AND PAINTED IAW SRM 51-25-10-02-01 ANSDR IPXA11569464Frame · dentedINSPECTION TYPE: C, FWD CARGO COMPARTMENT BS 740 FRAME DENTED BETWEEN S23L AND S24L. REPAIRED FWD CARGO COMPARTMENT FRAME IAW SRM 53-00-07-2R REPAIR 5, DETAIL 1.SDR QXEA2011092600890Frame · corrodedFRAME 216, FLANGES STR 29P TO 32P ARE CORRODED. BLENDED TO REMOVE CORROSION IAW RD 8/4-53-2344. CONFIRMED AREA CRACK FREE REF NTM 51-00-02-250-801 AND 51-00-01-250-801. MATERIAL LOSS WITHIN LIMITS OF RD 8/4-53-2344. COMPLETED REPAIR IAW RD 8/4-53-2344.SDR QXEA2011092600871Frame · corrodedSTATION AT FR 18.25 IS CORRODED BY STR 31P. REMOVED CORROSION IAW SRM 51-21-00-00-02. FOUND BLEND TO BE WITHIN LIMITS IAW RD 8/4-53-3950. APPLIED ALODINE, PRIMER, PAINT AND CPC IAW RD 8/4-53-3950. COMPLIED WITH TASK CARD RD 8/4-53-3950.SDR SWAA116753Frame · damagedDURING SCHEDULED RON CHECK, FOUND FRAME HEAT DAMAGED AT BS 277, BETWEEN STR 18R TO STR 19R. REMOVED AND REPLACED FRAME IAW EA.SDR SWAA116752Frame · damagedDURING SCHEDULED RON CHECK, FOUND FRAME I/B SPLICE CHORD HEAT DAMAGED AT BS 277, STR 18R. REMOVED AND REPLACED SPLICE CHORD IAW EA.SDR SWAA116751Frame · damagedDURING SCHEDULED RON CHECK, FOUND FRAME HEAT DAMAGED AT BS 277, BETWEEN STR 17R TO STR 19R. REMOVED AND REPLACED FRAME IAW EA.SDR FDEA201109224023Frame · damagedAFTER REMOVAL OF CABIN FLOORBEAM REPAIR AT STA 720, RBL 45 TO RBL 64, OBSERVED FRAME INNER CHORD AREA WITH DAMAGE ADJACENT S17R. DAMAGED FRAME REMOVED AND REPLACED IAW SRM 51-40-02 REV. 104. REPAIR IS CLASSIFIED AS MAJOR.SDR FDEA201109224022Frame · chafedFRAME AT BS 1280 HAS CHAFE MARKS AT S10R AND 2" BELOW S11R. REPAIRED IAW SRM 53-00-07 REPAIR 3, FIG. 201, REV 104. REPAIR IS CLASSIFIED AS MAJOR.SDR WRLA20110922512Frame · damagedDURING TENSION TIE INSPECTION FOUND DAMAGE CUT OUT AT BS 1160 RT. PERFORMED FRAME SEGMENT REPAIR PER 747-400 SRM REPAIR 3 AND IAI WORK DOCUMENT CS-25702-002 REV A.SDR WRLA20110922511Frame · damagedDURING TENSION TIE INSPECTION, FOUND DAMAGE CUT OUT AT BS 1160 LT. PERFORMED FRAME SEGMENT REPAIR PER SRM REPAIR 3 AND IAI WORK DOCUMENT CS-25702-002 REV "A".SDR DALA1158611702Strap · crackedFX RT BS 955 REAR SPAR B/H FITTING AREA 1 EACH FASTENER HOLE FOUND CRACKED AT FAIL-SAFE LAYER. SUBJECT FAIL-SAFE STRAP REPAIRED IAW ER/A 496332-14AD REV O.SDR DALA1158591702Strap · crackedFX LT BS955 REAR SPAR B/H FITTING AREA 1 EACH FASTENER HOLE FOUND CRACKED AT FAIL-SAFE STRAP LAYER AND SUBJECT FAIL-SAFE STRAP REPAIRED IAW ER/A 496331-14AD REV 0.
Back to JASC 5311