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 GLBA20090220IFrame · crackedDURING ROUTINE SCHEDULED MX CRACK WAS FOUND ON FRAME AT STRINGER 9R FS 163.975 STRINGER RELIEF CUTOUT. MAINTENANCE DETERMINED THIS DID NOT MEET THE CRITERIA OF A MAJOR REPAIR, HOWEVER, MAINTENANCE REPAIRED THE AFFECTED AREA PER BEECH 1900 SRM 51-70-21.SDR FDEA200902200613Frame · crackedFRAME CRACKED BS 970 ABOVE STR 26L AFT PIT. REMOVED INTERCOSTAL AND PREVIOUS REPAIR FOR ACCESS IAW SRM 51-30-2, CUTOUT DAMAGED AREA ON FRAME IAW SRM 51-10-1. FABRICATED FILLERS & DOUBLER IAW SRM 53-102 FIG 5 AND 51-40-3 FIG 1. HEAT TREATED FILLERS & DOUBLER SDR FDEA200902200612Frame · crackedFRAME CRACKED BS 990 ABOVE STR 26L AFT PIT. CUTOUT DAMAGED AREA IAW SRM 51-10-1, FABRICATED FILLER & DOUBLER IAW SRM 53-10-2 FIG 5 & 51-40-3 FIG 1. HEAT TREATED FILLER & DOUBLER TO 7075 T-6 IAW FAS ENG REPORT 2-37153-001 REV A. LOCATED DRILLED, DEBURRED FILLSDR IPXA09555044Frame · dentedINSPECTION TYPE:C FRAME STATION 1300 HAS A DENT BETWEEN S22R TO S23R. DNT L=.991W=.490DPTH=.039. TRIM OUT DENT DAMAGE IAW EA757-5362-27-A1836 STP1 PRELIM2 TRM SZ:W=1.5"X L=1.09". REMOVED FASTENERS CMMN TO REPAIR FOR HFEC INSP IAW SRM 51-40-02, EA757-5362-27SDR SWAA091196Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 380, STR 16L. REPAIRED FRAME PER SRM.SDR SWAA091184Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA091183Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA091182Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 520, STR 8R. REPAIRED FRAME PER SWA EA.SDR AALA20090226TUL21Frame · corrodedFRAME LOWER FLANGE HAS CORROSION AT STATION 1309 ABOVE LONGERON 30, INSTALLED NEW LOWER CHANNEL L28L TO L28R PER SRM 53-03 FIGURE 2A.SDR ASAA0944786Frame · corrodedFWD PIT FRAME STA 500E BETWEEN STR 28L 28R CORRODED. REMOVED CORROSION, FABRICATED, TREATED AND INSTALLED REPAIR SHEAR TIE IAW B737 400 SRM 53 00 07.SDR ASAA0944596Frame · corrodedFWD PIT FRAME CORRODED STA 500B BETWEEN STR 26R 27L. REMOVED CORROSION, FABBED, DRILLED AND INSTALLED SHEAR TIE REPAIR AW B737 400 SRM 53 00 07 51 20 01.SDR DL76L090252Frame · crackedDURING HMV AT HKG, THE RT STA 903.5 FRAME INNER CHORD WAS FOUND CRACKED. A REPAIR BASED ON BOEING INSTRUCTIONS WAS INSTALLED. A DAMAGE TOLERANCE ASSESSMENT IS DUE WITHIN 12 MONTHS OF THE REPAIR.SDR SWAA091178Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER SRM.SDR UALA2009021900556Frame · dentedAFT PIT FRAME DENTED STA 1420, BETWEEN STR 25L AND 24L. MAJOR REPAIR ACCOMPLISHED. REMOVED DAMAGED SECTION OF FRAME AND FABRICATED & INSTALLED A REPAIR J-ANGLE.SDR ASOA200900216Doubler · failedJOB 8733915 OPERATION 180 / FRAME DOUBLER P/N 601R5361193-13 AT LT FRAME FS 718.00 FAILED LPI ON S/B 601R-53-055 PART D PROCEDURE K STEP F.SDR USAA2009040190776Frame · crackedMCN - C24 - MAJOR REPAIR - CRACK IN FUSELAGE FRAME AT BS 887, S9R. REPAIRED FUSELAGE FRAME AT BS 887, S9R IAW US AIRWAYS EA 130204.SDR USAA2009040190775Frame · crackedMCN - C24 - MAJOR REPAIR - CRACK IN FUSELAGE FRAME AT BS 827, S9R & S9L. REPAIRED FUSELAGE FRAME AT BS 827, S9R & S9L IAW US AIRWAYS EA 130204.SDR USAA2009040190774Frame · crackedMCN - C24 - MAJOR REPAIR - CRACK IN FUSELAGE FRAME AT BS 807, S9R. REPAIRED FUSELAGE FRAME AT BS 807, S9R IAW US AIRWAYS EA 130204.SDR USAA2009040190773Frame · crackedMCN - C24 - MAJOR REPAIR - CRACK IN FUSELAGE FRAME AT BS 747, S9R & S9L. REPAIRED FUSELAGE FRAME AT BS 747, S9R & S9L IAW US AIRWAYS EA 130204.SDR USAA2009040190772Frame · crackedMCN - C24 - MAJOR REPAIR - CRACK IN FUSELAGE FRAME AT BS 727E, S9R. REPAIRED FUSELAGE FRAME AT BS 727E S9R IAW US AIRWAYS EA 130204.SDR USAA2009040190771Frame · crackedMCN - C24 - MAJOR REPAIR - CRACK IN FUSELAGE FRAME AT BS 500A, S9R. REPAIRED FUSELAGE FRAME AT BS 500A, S9R IAW US AIRWAY EA 130204.SDR USAA2009040190770Frame · crackedMCN - C24 - MAJOR REPAIR - CRACK IN FUSELAGE FRAME AT BS 480 BETWEEN S8L TO S9L & ALSO AT S9R. REPAIRED FUSELAGE FRAME AT BS 480 BETWEEN S8L TO S9L & ALSO AT S9R IAW US AIRWAYS EA 130204.SDR USAA2009030690515Frame · corrodedSAL - C17 - MAJOR REPAIR - CORROSION ON FRAME AT BS 821, S27L. REPAIRED FRAME AT BS 821, S27L IAW B737 SRM 53-00-07.SDR C2XA09TY031Frame · damagedFRAME 31 HAS MAINTENANCE INDUCED DAMAGE STR 15R AND 16R. CUT OUT DAMAGE AREA ON FRAME 31 & FABRICATED AND INSTALLED DOUBLER IAW EMB SRM 53-00-04. AIRCRAFT STILL IN C-CHECK.SDR DLM88090246Frame · crackedFOUND CRACK AT FRAME 927 AT X=+65. REPLACED FRAME ON NR 01124.SDR AALA2009021600181Frame · crackedCRACK IN LEFT FRAME STATION 380 480 500D BETWEEN STRINGER 8 AND 9 AT INBOARD SUPPORT BRACKET. REPAIRED PER ECO J1159AA.SDR AALA2009021600178Frame · crackedCRACK ON RIGHT FRAME STATION 500A 500C 500D BETWEEN STRINGER 8 AND 9 AT INBOARD SUPPORT BRACKET FASTENER. REPAIRED PER ECO J1159AA.SDR USAA2009031890625Frame · crackedMCN - C24 - MAJOR REPAIR - 2 CRACKS IN FRAME AT E & E COMPARTMENT LOWER LOBE BS 344 BETWEEN S22L TO S24L. REPAIRED FRAME AT E & E COMPARTMENT LOWER LOBE BS 344 BETWEEN S22L TO S24L IAW B737 SRM 51-70-11.SDR USAA2009031690603Frame · crackedSAL - C17 - MAJOR REPAIR - CRACK ON FRAME AT BS 480 BETWEEN S8L TO S9L. REPAIRED FRAME AT BS 480 BETWEEN S8L TO S9L IAW TASK CARD M1C53002.SDR USAA2009031390593Frame · crackedSAL - C17 - MAJOR REPAIR - CRACK ON FRAME AT BS 480 BETWEEN S8R TO S9R. REPAIRED FRAME AT BS 480 BETWEEN S8R TO S9R IAW TASK CARD M1C53002.SDR USAA2009031390592Frame · crackedSAL - C17 - MAJOR REPAIR - CRACK ON FRAME AT BS 380 BETWEEN S8R TO S9R. REPAIRED FRAME AT BS 380 BETWEEN S8R TO S9R IAW TASK CARD M1C53002.SDR USAA2009031390591Frame · crackedSAL - C17 - MAJOR REPAIR - CRACK ON FRAME AT BS 787 BETWEEN S8R TO S9R. REPAIRED FRAME AT BS 787 BETWEEN S8R TO S9R IAW TASK CARD M1C53002.SDR USAA2009031390590Frame · crackedSAL - C17 - MAJOR REPAIR - CRACK ON FRAME AT BS 440 BETWEEN S8R TO S9R. REPAIRED FRAME AT BS 440 BETWEEN S8R TO S9R IAW TASK CARD M1C53002.SDR USAA2009031390589Frame · crackedMAJOR REPAIR - CRACK ON FRAME AT BS 400 BETWEEN S8L TO S9L & BETWEEN S8R TO S9R. REPAIRED FRAME AT BS 400 BETWEEN S8L TO S9L & BETWEEN S8R TO S9R IAW TASK CARD M1C53002.
SDR AALA2009021700144Frame · crackedCRACK ON RIGHT FRAME AT STATION 380 BETWEEN STRINGER 8 AND 9 RIGHT AT INBOARD SUPPORT BRACKET FASTENER. INSTALLED DOUBLER PER ECO J1159AA.SDR AALA2009021700143Frame · crackedCRACK ON RIGHT FRAME FORWARD AT STATION 400 RIGHT BETWEEN STRINGER 8 AND 9 RIGHT AT INBOARD SUPPORT BRACKET FASTENER. REPAIRED PER ESO J1169AASDR AALA2009021700141Frame · crackedCRACK FOUND ON RIGHT FRAME AT STATION 480 BETWEEN STRINGER 8 RIGHT AND 9 RIGHT AT INBOARD SUPPORT BRACKET FASTENER. INSTALLED DOUBLER PER ECO J1159AA.SDR FDEA200902160547Frame · dentedMAIN DECK CARGO COMPARTMENT, FUSELAGE RIGHT MAIN FRAME STA 1741 LONGERON 12 FOUND WITH DENT. REPAIRED AS PER SRM 53-30-00 FIGURE 1 VOLUME I. REPETITIVE INSPECTION TO BE CARRIED OUT AS PER SRM 53-30-00 FIGURE 1 VOLUME I. REPAIR CLASSIFIED AS MAJOR AS PER GMM SDR FDEA200902160546Frame · dentedMAIN DECK CARGO COMPARTMENT, FUSELAGE RIGHT MAIN FRAME STA 1681 LONGERON 12 FOUND WITH DENT. REPAIRED AS PER SRM 53-30-00 FIGURE 1 VOLUME I. REPETITIVE INSPECTION TO BE CARRIED OUT AS PER SRM 53-30-00 FIGURE 1 VOLUME I. REPAIR CLASSIFIED AS MAJOR AS PER GMM SDR ASAA0944933Frame · crackedFUSELAGE FRAME STA 907L IS CRACKED BETWEEN STRINGER 8L 9L. CUT OUT CRACKED SECTION OF FRAME, FABRICATED AND INSTALLED REPAIR ANGLES IAW ASA EA 400 53EA 00948.SDR ASAA0944932Frame · crackedFUSELAGE FRAME STA 787L IS CRACKED BETWEEN STRINGER 8L 9L. CUT OUT CRACKED SECTION OF FRAME, FABRICATED AND INSTALLED REPAIR ANGLES IAW ASA EA 400 53EA 00948.SDR ASAA0944931Frame · crackedFUSELAGE FRAME STA 907 IS CRACKED BETWEEN STRINGER 8R 9R. CUT OUT CRACKED SECTION OF FRAME, FABRICATED AND INSTALLED REPAIR ANGLES IAW ASA EA 400 53EA 00948.SDR ASAA0944930Frame · crackedFUSELAGE FRAME STA 727D IS CRACKED BETWEEN STRINGER 8R 9R. CUT OUT CRACKED SECTION OF FRAME, FABRICATED AND INSTALLED REPAIR ANGLES IAW ASA EA 400 53EA 00948.SDR ASAA0944929Frame · crackedFUSELAGE FRAME STA 480 IS CRACKED BETWEEN STRINGER 8R 9R. CUT OUT CRACKED SECTION OF FRAME, FABRICATED AND INSTALLED REPAIR ANGLES IAW ASA EA 400 53EA 00948.SDR ASAA0944928Frame · crackedFUSELAGE FRAME STA 480 IS CRACKED BETWEEN STRINGER 8R 9R. CUT OUT CRACKED SECTION OF FRAME, FABRICATED AND INSTALLED REPAIR ANGLES IAW ASA EA 400 53EA 00948.SDR ASAA0944927Frame · crackedFUSELAGE FRAME STA 500C IS CRACKED BETWEEN STRINGER 8R 9R. CUT OUT CRACKED SECTION OF FRAME, FABRICATED AND INSTALLED REPAIR ANGLES IAW ASA EA 400 53EA 00948.SDR ASAA0944926Frame · crackedFUSELAGE FRAME STA 500A IS CRACKED BETWEEN STRINGER 8R 9R. CUT OUT CRACKED SECTION OF FRAME, FABRICATED AND INSTALLED REPAIR ANGLES IAW ASA EA 400 53EA 00948.SDR ASAA0944925Frame · crackedFUSELAGE FRAME STA 827 IS CRACKED BETWEEN STRINGER 8R 9R. CUT OUT CRACKED SECTION OF FRAME, FABRICATED AND INSTALLED REPAIR ANGLES IAW ASA EA 400 53EA 00948.SDR ASAA0944924Frame · crackedFUSELAGE FRAME STA 400 IS CRACKED BETWEEN STRINGER 8R 9R. CUT OUT CRACKED SECTION OF FRAME, FABRICATED AND INSTALLED REPAIR ANGLES IAW ASA EA 400 53EA 00948.SDR ASAA0944923Frame · crackedFUSELAGE FRAME STA 480 IS CRACKED BETWEEN STRINGER 8L 9L. CUT OUT CRACKED SECTION OF FRAME, FABRICATED AND INSTALLED REPAIR ANGLES IAW ASA EA 400 53EA 00948.
Back to JASC 5311