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 SWAA201210803Frame · damagedA/C HAS DAMAGE FUSELAGE FRAME AND SHEAR TIE AT BS 965 TO BS 967 BETWEEN STR 23R AND 24R. REMOVED AND REPLACED PER EA REO. (SUBMITTED AS A SUPPLEMENTAL, COULDN`T FIND ORIGINAL RECORD.)SDR SWAA2012121310609Frame · crackedFUSELAGE FRAME CRACKED AT AIR CONDITIONING ATTACH BRACKET BS 907 STR 8-9L. REPAIRED BS 907 FRAME STR 8-9 LEFT IAW ER 12-03581 AND EA 1-753-212 06.SDR SWAA2012121110498Frame · crackedFUSELAGE FRAME CRACKED AT AIR CONDITIONING ATTACH BRACKET BS 500C STR 8-9L. REPAIRED FRAME BS 500C STR 8-9L PER EA 1-A53-12114 REV 2.SDR SWAA2012121010448Frame · corrodedCORROSION ON FWD AND AFT FACE OF FRAME IN THE AFT CARGO COMPARTMENT AT BS 787 BETWEEN STR 27L AND STR 27R. REPAIRED FRME IN THE AFT CARGO COMPARTMENT AT BS 787 BETWEEN STR 27L AND STR 27R IAW B737-300 SRM 53-00-07-2R-3 REPAIR 3 DUE TO REMOVEDSDR SWAA2012120410198Frame · crackedFUSELAGE FRAME CRACKED AT AIR CONDITIONING ATTACH BRACKET BS 400 STR 8-9L. REPAIRED FUSELAGE FRAME AT AIR CONDITIONING ATTACH BRACKET BS 400 STR 8-9 LEFT PER EA 1-A53-12114 REV 2.SDR SWAA2012120410197Frame · crackedFRAME CRACKED AT A/C ATTACH BRACKET BS 360 STR 8R. REPAIRED BS 360 FRAME AT STR 8R IAW EA 1-753-21158 AND ER 12-03582.SDR SWAA2012113010083Frame · crackedFUSELAGE FRAME CRACKED AT AIR CONDITIONING ATTACH BRACKET BS 867 STR 8-9L. PERFORMED REPAIR FRAME CRACKED AT AIR CONDITIONING ATTACH BRACKET BS 867 STR 8-9L IAW EA 1-A53-12114 REV 2.SDR SWAA2012113010053Frame · corrodedCORROSION ON FRAME AT BS 344 LEVEL OF STR 27R E/E COMPARTMENT. REPAIRED FRAME IAW SRM.SDR QXEA2012111401396Frame · corrodedFRAME BS 449.5, CORRODED STRINGER 33-32S. REMOVED FASTENERS COMMON TO SKIN AND BLENDED CORROSION REF RD 8/4-53-2344. INSPECTED WITH HFEC, NO CRACKS NOTED REF NDTM 51-00-01-250-801 MIN REMAINING THICKNESS .061 REF NDTM 51-00-01-250-801. MATERIAL LOSS FOUND INSDR SWAA2012112809985Frame · crackedFUSELAGE FRAME CRACKED AT AIR CONDITIONING ATTACH BRACKET BS 827 STR 8-9L. PERFORMED REPAIR AT FUSELAGE FRAME AIR CONDITIONING ATTACH BRACKET BS 827 STR 8L-9L IAW EA 1-A53-12114, REV 2.SDR SWAA2012112609842Frame · crackedFUSELAGE FRAME CRACKED AT AIR CONDITIONING ATTACH. PERFORMED REPAIR FRAME CRACKED AT AIR CONDITIONING ATTACH BRACKET BS827 STR 8-9R IAW EA 1-A53-12114.SDR SWAA2012112609841Frame · crackedFUSELAGE FRAME CRACKED AT AIR CONDITIONING ATTACH BRACKET BS 480 STR 8-9L. REPAIRED FRAME AT AIR CONDITIONING ATTACH BRACKET BS 480 STR 8-9L PER EA 1-A53-12114 REV 2.SDR SWAA2012112609840Frame · crackedFRAME CRACKED AT A/C ATTACH BRACKET BS 440 STR 8R. PERFORMED REPAIR AT FRAME ATTACH BRACKET BS 440 STR 8R IAW EA 1-A53-12114 REV 2.SDR SWAA2012112109713Frame · crackedSTA 400 BETWEEN STR 8R & 9R, FRAME HAS A CRACK INDICATION. FABRICATED REPAIR ANGLES AND INSTALLED PER SRM.SDR UALA2012111606615Frame · corrodedAFT CARGO BAY BS 1480 FRAME S25-27R FOUND CORRODED. BLENDED CORROSION, MATERIAL LOSS FOUND EXCEEDING SRM LIMITS. ACCOMPLISHED HFEC OF BLENDED AREA & OPEN HOLES, NO DEFECTS NOTED. FABRICATED & INSTALLED REPAIR ANGLE IAW ECRA5360-01233. MAJOR REPAIR.SDR UALA2012111606604Frame · corrodedAFT BILGE BODY FRAME MID CHORD IS CORRODED AT BS 1520 STR 29L-29R, WL 144. MAJOR REPAIR ACCOMPLISHED: MAINT TEXT: REMOVED CORRODED MATERIAL LOSS EXCEED SRM 53-00-07 LIMITS. ACPD HFEC BLENDED AREA & OPEN HOLE PER NDT 51-00-19 & 51-00-1 6, NO DEFECT NOTED. FSDR UALA2012111606601Frame · corrodedAFT CARGO COMP AT BS 1420 RBL 21- LBL 5 FRAME IS CORRODED ON INNER CHORD AND WEB IN SEVERAL PLACES REF CORR TASK CARD C53-156-02 AND C53-155-02. MAJOR REPAIR ACCOMPLISHED: DUE TO CORROSION OUT OF LIMITS, REMOVED AND REPLACED FRAME AT STA 1420 STR 24L TO 24R SDR UALA2012111606591Failsafe · corrodedFORWARD CARGO BAY, BS 660, WL 150, MAIN FRAME, AFT SIDE AT LBL 1, LBL 2 AND LBL 8 HAS AREAS OF CORROSION. AREA BLENDED AND FOUND TO BE OUT OF LIMITS BY NDT. REPLACED THE FAILSAFE AT BS 660 LBL 22 TO RBL 22 PER SRM 51-40-02. MAJOR REPAIR.SDR U2RA201211140005Frame · corrodedAFT CARGO BS 1640, STRINGER 29L TO 29R FRAME WEB HAS HEAVY CORROSION. REPLACED FROM STRINGER 24L TO S24R IAW DWG 146N1032. REF NRC HFL6086. GENERATED FROM TASK CARD 53-222-00-01.SDR FDEA201211144005Frame · dentedAFT CARGO BAY LT SIDE FRAME BS 1480 HAS DENT ON TOP OF FRAME, BETWEEN STR 25 AND 26L. REPAIRED IAW EA : F-5310-162902. REPAIR CLASSIFIED MAJOR IAW GMM 6-2-100.SDR FDEA201211144004Frame · dentedFWD CARGO BAY LT SIDE FRAME AT BS 680 HAS DENT ON TOP OF FRAME AT STR 23L. COMPLIED IAW EA: RF-5310-162903. REPAIR CLASSIFIED MAJOR IAW GMM 6-2-100.SDR SWAA2012121210555Frame · corrodedCORROSION ON FACE OF FRAME AT BS 500B AND BETWEEN STR 26L TO 27L CARGO COMPARTMENT. REPAIRED FRAME IAW SRM.SDR SWAA2012120510247Frame · corrodedPASSENGER CABIN STA 716 BETWEEN STR 16L AND 17L, MLG SUPPORT FRAME SIDE CORRODED. REMOVED AND REPLACED FRAME IAW EA.SDR SWAA2012113010069Frame · crackedSTA 360, STR 8R FRAME CRACKED AT I/B FASTENER. REMOVED AND REPLACED FRAME IAW EA.SDR SWAA2012112901005Frame · crackedCRACK ON FRAME LOCATED AT BSTA 947.5 LEVEL STR 19L AFT CARGO COMPARTMENT. REPLACED REPAIR FRAME AND FASTENERS LOCATED AT BS 947.5 BETWEEN STR 17L AND 23L IAW B737-300 SRM 51-10-02 ITEM 8, SRM 51-40-02 AND DWG 65-46947.SDR SWAA2012112609890Frame · crackedFRAME CRACKED AT STRINGER CUTOUT, BS 380 STR 26L. REPAIRED IAW SRM 53-00-07-2R.SDR SWAA2012112609865Frame · crackedSTA 867, STR 8L FRAME CRACKED AT I/B FASTENER. REMOVED AND REPLACED FRAME IAW EA.SDR SWAA2012112609864Frame · crackedSTA 747 STR 8L FRAME CRACKED AT I/B FASTENER. REMOVED AND REPLACED FRAME IAW EA.SDR SWAA2012112609863Frame · crackedSTA 480 STR 8L FRAME CRACKED AT I/B FASTENER. REMOVED AND REPLACED FRAME IAW EA SRM.SDR SWAA2012112609829Frame · crackedSTA 827 STR 8R FRAME CRACKED AT I/B FASTENER. REMOVED AND REPLACED FRAME IAW EA.SDR SWAA2012112609828Frame · crackedSTA 400 STR 8L FRAME CRACKED AT I/B FASTENER. REMOVED AND REPLACED FRAME IAW EA.SDR SWAA2012112009657Frame · crackedSTA 480, STR 8R FRAME CRACKED AT I/B FASTENER. REMOVED AND REPLACED FRAME IAW EA.SDR AALA20121113015Frame · crackedFRAME 500A RIGHT CRACKED AT AIR CONDITIONING BRACKET. ACCOMPLISHED NESTED ANGLE REPAIR PER ECO 1159AE CARD 0006.SDR AALA20121113014Frame · crackedCRACK IN FRAME WEB STATION 440 LEFT AIR CONDITIONING BRACKET BIN ATTACH. ACCOMPLISHED NESTED ANGLE REPAIR PER J1159AE CARD 0006.SDR AALA20121113013Frame · crackedFRAME 480 RIGHT CRACKED AT AIR CONDITIONING BRACKET. ACCOMPLISHED NESTED ANGLE REPAIR PER ECO 1159AE CARD 0006.SDR V0XR201211140135Frame · corrodedFRAME AT BS 327.763 BOTTOM SIDE OF PASSENGER DOOR IS CORRODED. R & R FRAME IAW SRM 51-42-06 AND 51-40-11.SDR CALA2012111300797Frame · crackedFRAME AT BS 500C BETWEEN STRINGERS 8 AND 9R, CRACKED AT AIR CONDITIONING OUTLET ATTACH BRACKET. REF STEP 7 OF EA 5310-04716 REV D, FRAME 500C R BETWEEN STRINGERS 8 AND 9 HAS BEEN REPAIRED IAW 5310-04716, REV D.SDR SWAA2012123110992Frame · corrodedCORROSION ON FRAME LOCATED BS 500A BETWEEN S-25L TO S-26L FWD CARGO COMPARTMENT. PERFORMED REPAIR ON FRAME LOCATED BS 500A BETWEEN S-25L TO S-26L FWD CARGO COMPARTMENT IAW B737-300 SRM 53-00-07-2R-5.SDR SWAA2012121210556Frame · corrodedCORROSION ON FRAME LOCATED BS 500B BETWEEN S-25L TO S-26L CARGO COMPARTMENT. REPAIRED FRAME IAW SRM.SDR SWAA2012113010051Frame · corrodedCORROSION LOWER FLANGE OF FRAME AT BS 867 BETWEEN STR 27L TO STR 27R. REPAIRED FRAME IAW SRM DWG.SDR FDEA201211123982Frame · crackedFRAME BS 760 S9L RIVET HAS SET MARK AND AT STRINGER 10L-11L THERE IS A TRAPPED HOLE. FRAME REPAIRED IAW SRM 53-00-07, FIG 201, REPAIR 3. MAJOR REPAIR.SDR AALA20121112001Frame · wornSTATION 1380 LEFT SIDE FRAME WEB HAS WORN AREA FROM COCKPIT TEMP CONTROL VALVE. REMOVED DAMAGED MATERIAL AND INSTALLED FRAME WEB REPAIR AS PER AARD 53-10-00-28.SDR SWAA2012113010049Frame · corrodedCORROSION ON LOWER FLANGE OF FRAME AT BS STA 807 BETWEEN STR 27L TO STR 27R. REPAIRED FRAME IAW SRM DWG.SDR DALA1254583711Frame · damagedDAMAGE FOUND AT FRAME BS 857 BETWEEN S24 AND 26L. REPAIRED DAMAGE IAW ERA 508826-14.SDR CALA2012111300795Frame · crackedFRAME AT BS 500A BETWEEN STRINGERS 8 AND 9R CRACKED AT AIR CONDITIONING OUTLET ATTACH BRACKET. REF STEP 7 OF EA 5310-04716 REV D. FRAME 500A R BETWEEN STRINGERS 8 AND 9 HAS BEEN REPAIRED IAW EA 5310-04716 REV D OP1.SDR CALA2012111300794Frame · crackedFRAME BS 727B CRACKED BETWEEN S8-9R AT ATTACH BRACKET. REPAIRED IAW EA 5310-04716, REV D, OP 1.SDR CALA2012111300793Frame · crackedFRAME BS 867 CRACKED BETWEEN S8-9R AT ATTACH BRACKET. REPAIRED IAW EA 5310-04716, REV D, OP 1.SDR ASOA2012121002622Frame · corrodedFRAME BS 349.00 CORRODED AT STRINGER 17 RT. FRAME REPAIRED IAW REO 601R-53-21-2374 REV(P3).SDR SWAA2012111909585Fitting · corrodedCARGO COMPARTMENT STA 927 BETWEEN STR 27L AND 27R CORRODED ON FRAME FOOT. REMOVED AND REPLACED IAW FRAME SRM AND BAC DWG.SDR SWAA2012111609565Frame · crackedAFT CARGO, FWD DOOR FRAME, INNER CLOSURE WEB CRACKED AT FWD LWR CORNER. REMOVED AND REPLACED FRAME PER SRM.
Back to JASC 5311