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 USAA051184Frame · corrodedFOUND FRAME BOX CORRODED AT STA 847 AND STR 25. REMOVED, FABRICATED AND INSTALLED NEW BOX PANEL IAW SRM 53-60-15, DEFECT SIZE: 3" BY 5".SDR SWAA053062Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 303, STR 16L. REPAIRED FRAME PER BFG ER.SDR SWAA053061Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 616, LBL 65, WL 203. REPAIRED FRAME PER BFG ER.SDR SWAA053057Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 328, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR SWAA053054Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 663, STR 2L. REPAIRED FRAME PER SRM.SDR ASAA0510337Frame · corrodedYXX - FOUND FORWARD CARGO PIT, MAIN FRAME FOUND CORRODED AT BS 440 AND STRINGER 26 RT. FORWARD CARGO PIT MAIN FRAME AT BS 440 AND 28 RT REPAIRED IAW B737-200 SRM 51-10-01 PARAGRAPH 8. (M)SDR UPS05845783Spar · corrodedINSPECTION TYPE:C2 PRESSURE PANEL AT STA 857 RBL 26 TO 46 REAR SPAR TO FUSELAGE ANGLE EXFOLIATED. REMOVED ANGLE CHORD AT STA 857 RBL 26 TO 46 IAW SRM 51-1-20D. LOCATED AND DRILLED RT UPPER AFT SPAR CHORD AND INSTALLED SPAR CHORD IAW SRM 51-1-20D AND SRM 53-2SDR 05FDEA03205Failsafe · corrodedSTA 1148 LBL 12 CORROSION ON BULK CARGO FRAME FAILSAFE CHORD. REPLACED STIFFENER AT BS 1148 LBL 12 PER 51-40-4.SDR SWAA053042Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND FUSELAGE SHEAR TIE CORRODED AT BS 500C, BETWEEN LBL 9 TO RBL 2. REPAIRED SHEAR TIE PER SRM.SDR SWAA053038Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER SRM.SDR USAA051163Flange · crackedFOUND FUSELAGE STATION 559, STRINGER 13L CRACKED. REMOVED DAMAGED AREA, FABRICATED AND INSTALLED REPAIR ANGLE IAW EA 96912, DEFECT SIZE: .7".SDR SWAA053028Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SWA EA.SDR SWAA053026Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8R. REPAIRED FRAME PER SRM.SDR SWAA053024Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT FWD CARGO DOOR CUTOUT, FWD BOTTOM DOOR STOP FITTING. REPAIRED FRAME PER BFG ER.SDR SWAA053021Frame · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE FRAME CRACKED AT R1 DOOR UPPER HINGE CUTOUT. REPAIRED FRAME PER SWA EA.SDR USAA051161Frame · crackedFOUND FRAME CRACKED AT STATION 887 BETWEEN STRINGERS 8R AND 9R. REMOVED DAMAGED AREA, FABRICATED AND INSTALLED DOUBLER IAW SRM 53-10-20B, DEFECT SIZE: .6".SDR USAA051159Flange · crackedFOUND FUSELAGE CRACKED STATION 559 STRINGER 13L. REMOVED DAMAGED AREA, FABRICATED AND INSTALLED REPAIR ANGLE IAW EA 96912, DEFECT SIZE: .7".SDR SWAA053004Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT FWD CARGO DOOR CUTOUT, AFT BOTTOM DOOR STOP FITTING. REPAIRED FRAME PER BFG ER.SDR SWAA053003Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SRM.SDR SWAA052999Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT FWD CARGO DOOR CUTOUT, AFT BOTTOM DOOR STOP FITTING. REPAIRED FRAME PER BFG ER.SDR AT0700039Frame · crackedAFT ACCESSORY COMPARTMENT CANTED FRAME AT BS 1178 CRACKED IN TWO PLACES LONGERON 16 TO 18 LEFT. INSTALLED FORMED CHANNEL REPAIR AT AFT ACCESSORY COMPARTMENT CANTED FRAME AT BS 1178 BETWEEN LONGERON 16L AND LONGERON 18L IAW B717 SRM 51-70-11 FIG 201. SIZE OF SDR ASAA0510329Doubler · dentedYXX - FOUND FRAME DOUBLER DAMAGED AT BS 360 BETWEEN STRINGER 26 RT PLUS 4 INCHES TO STRINGER 28 RT. REPLACED DOUBLER IAW B737-200 SRM 51-40-3. (M)SDR ASAA0510327Frame · crackedYXX - FOUND FORWARD CARGO PIT FRAME CRACKED AT BS 460 BETWEEN STRINGER 22 AND 23 LEFT. REPLACED FRAME WITH REPAIR PARTS PER B737-200 SRM 53-10-4. (M)SDR ASAA0510326Failsafe · corrodedCORRODED FAIL SAFE ANGLE AT BSTA 967, BETWEEN STRINGER 27 LT AND 27 RT IS CORRODED. BSTA 967 BETWEEN STRINGER 27 RT AND 27 LT FAIL SAFE ANGLE REPAIRED IAW SRM. (K)SDR 724000012Frame · dentedDENT ON FUSELAGE FRAME FLANGE.SDR 724000011Frame · crackedCRACK IN FUSELAGE FRAME SUPPORT.SDR SIMA200527706Frame · crackedFOUND FRAME 68 WAS FOUND CRACKED AT THE BAGGAGE DOOR STAY ROD HOLDER CUP BRACKET. PERFORMED CUT OUT OF FRAME 68 TO REMOVE THE DAMAGE. FABRICATED AN ANGLE SPLICE AFT AND ONE FOR FORWARD. FABRICATED A CUP SUPPORT. REPAIR DONE IAW EMB REPAIR STATEMENT IC2005-SDR ABXA050248Frame · crackedFRAME 1152 CRACKED LONGERON 2 RIGHT. REPLACED CRACKED FRAME SECTION FS 1152 IAW DC-9 SRM 53-03.SDR SWAA052985Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L TO STR 9L. REPAIRED FRAME PER SRM.SDR AWXA200501230Frame · crackedDURING C18 CHECK DISCOVERED CRACK, 2.0 INCHES IN LENGTH, ON FRAME IN RADIUS AT BS 188, WL 209 AND BL 33R. MAINTENANCE TRIMMED OUT CRACK AT BS 188, WL 209 AND BL 33R IAW AMERICA WEST AIRLINES ENGINEERING REQUEST NR 03-5300-05286-RC1. FABRICATED FILLERS AND ANSDR PIDA20050150Frame · crackedCRACK AT I/B CHORD LOWER FASTENER HOLE IN BS 616 FRAME LEFT. REPAIRED FRAME PER SB 737-53-1182.SDR SWAA052976Beltframe · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE BELTFRAME CORRODED AT BS 500A, RBL 1. REPAIRED BELTFRAME PER SRM.SDR SWAA052971Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 616, BELOW LT CREASE BEAM WEB. REPAIRED FRAME PER BFG ER.SDR SWAA052970Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 303, L1 DOOR LOWER FWD STOP FITTING CUTOUT. REPAIRED FRAME PER BFG ER.SDR SWAA052968Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SRM.SDR SWAA052967Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SRM.SDR SWAA052966Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8R. REPAIRED FRAME PER SRM.SDR 05FDEA03136Frame · damagedMAIN CARGO BAY, MECHANICAL DAMAGE TO FRAME BS 950F BETWEEN STRINGER 4 LT AND 5 LT. REPAIRED FRAME AT BS 950F BETWEEN STR 4L & 5L PER SRM 53-10-4SDR 05FDEA03135Frame · corrodedCORROSION, STA 1166 RBL 20 TO LBL 20 CORROSION ON BULK CARGO FRAME UPPER FLANGE. REPAIRED FRAME AT BS 1166 RBL 20 TO LBL 20 PER SRM 51-40-3SDR SWAA052949Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME PER SRM.SDR C1HA200568004Frame · corrodedUPPER FRAME CHORD CORRODED ON LWR SURFACE IN AFT PIT BS 990 OVER STR 27R JUST BEHIND AFT DOOR CUTOUT. CUT OUT DAMAGED AREA FABBED AND INSTALLED FILLER 2" BY 1" AND DOUBLER ANGLE 8 3/4" BY 3 1/4" FROM 10134-3001 7075 T6 PO NR 9001253 IAW 727 SRM 51-40-4 FIG 1.SDR C1HA200586002Frame · corrodedFRAME LEG CORRODED IN FWD PIT AT FRAME 700 BETWEEN STRINGERS 28L AND 29L. CUT OUT DAMAGED AREA FABBED AND INST REPAIR DOUBLER AND ANGLE MADE FROM 7075 T6 .050 PO NR 9002126 DIM DOUBLER 6" BY 4 1/2" AND ANGLE 7" BY 2" IAW B727 SRM 53-10-4 FIG 11. OPENED WTB PSDR ASAA0580513Frame · corrodedOKC - DURING HV-CHECK, FOUND FRAME CORRODED. REMOVED DAMAGED SECTION. INSTALLED REPAIR FILLER, TWO REPAIR ANGLES AND TWO REPAIR PLATES. (M)SDR ASAA0580511Frame · corrodedOKC - DURING HV-CHECK, FOUND FRAME CORRODED. REMOVED DAMAGED SECTION. INSTALLED TWO REPAIR DOUBLERS, TWO REPAIR PLATES, AND ONE REPAIR FILLER. (M)SDR PIDA20050144Frame · crackedRIGHT FORWARD DOOR FRAME (FUSELAGE FRAME) CRACKED AT FLOOR LEVEL BEHIND THE ZEE ANGLE. REPAIRED DAMAGE PER SRM 51-40-3 AND SRM 51-10-1.SDR SWAA052936Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8R TO STR 9R. REPAIRED FRAME PER SRM.SDR SWAA052935Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8R TO STR 9R. REPAIRED FRAME PER SRM.SDR SWAA052934Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L TO STR 9L AND STR 8R TO STR 9R. REPAIRED FRAME PER SRM.SDR ASOA05810Frame · crackedDURING AN A-CHECK IN BTR, THE RIGHT SIDE 640 FRAME DOUBLER WAS FOUND TO POSSIBLY BE CRACKED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE RIGHT SIDE FS 640 FRAME DOUBLER IAW CRJ200 SRM 51-40-00. (M)SDR 2005UALA01032Frame · crackedMID CABIN FRAME IS CRACKED AT FASTENER HOLE AT STA 727B NEAR STR 8L. ACCOMPLISHED A REPAIR PER MM 53-10-84, FABRICATED ANGLE, FILLER AND SUPPORT AND INSTALLED PER MM.
Back to JASC 5311