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 SWAA052859Shear Tie · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SHEAR TIE CORRODED AT BS 500A, STR 28L TO STR 28R. REPAIRED SHEAR TIE PER SRM.SDR SWAA052858Shear Tie · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SHEAR TIE CORRODED AT BS 787, LBL 18 TO RBL 18. REPAIRED SHEAR TIE PER SRM.SDR SWAA052857Frame · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 993, RBL 46, WL 208. REPAIRED FRAME PER SRM.SDR SWAA052854Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 9R. REPAIRED FRAME PER SRM.SDR USAA051102Frame · crackedFOUND CRACK AFT E/E FRAME 312. FABRICATED AND INSTALLED NEW STRAPS IAW SRM 53-10-51, DEFECT SIZE: 1" LONG CRACKS.SDR USAA051129Frame · crackedFOUND CRACK STA 907 STR 1. INSTALLED FRAME ANGLE REPAIR PER SRM 53-00-07, DEFECT SIZE: 1".SDR USAA051131Frame · damagedBS 294.5, S-17R, CUT OUT DAMAGE, FABRICATED NEW ATTACH ANGLE AND INSTALLED IAW SRM 51-70-11 TABLE 5 OF FIG NR 1, DEFECT SIZE: .5" CRACKED DOOR FRAME.SDR USAA051097Frame · damagedSTA 294, S-16L AFT OF FRAME, NEW PART, INSTALLED WITH LOCK FASTENERS IAW SRM 51-10-02, DEFECT SIZE: SHEETMETAL NR 4365, WEB CRACKED (APPROX 1.5 INCHES LONG) S-161, AFT OF BS 294 FRAME.SDR ASAA0540492Frame · corrodedCORROSION ON FRAME AT BS 995, RBL 46, WL 209. REPAIRED FRAME AT BSTA 995, RBL 46, WL 209 IAW SRM. (K)SDR AWXA200501161Frame · crackedMCN - DURING 8 DAY CHECK, FOUND FRAME CRACKED AT FASTENER HOLE AT BS 907 BETWEEN STRINGERS 10R AND 11R. MAINTENANCE TRIMMED OUT DAMAGE TO FRAME AT BS 907 IAW BOEING 737-300 SRM 51-20-02-06. FABRICATED REPAIR CHANNELS AND FILLER IAW BOEING 737-300 SRM 53-60-0SDR SWAA052846Shear Tie · corrodedDURING SCHEDULED D-CHECK, FOUND CABIN FUSELAGE SHEAR TIE CORRODED AT BS 767, LBL 2 TO RBL 2, WL 156. REPAIRED SHEAR TIE PER SRM.SDR SWAA052844Frame · crackedDURING SCHEDULED D-CHECK, FOUND CABIN FUSELAGE FRAME CRACKED AT BS 400, STR 9R. REPAIRED FRAME PER SRM.SDR SWAA052843Frame · crackedDURING SCHEDULED D-CHECK, FOUND CABIN FUSELAGE FRAME CRACKED AT BS 907, STR 9R. REPAIRED FRAME PER SRM.SDR SWAA052842Frame · crackedDURING SCHEDULED D-CHECK, FOUND CABIN FUSELAGE FRAME CRACKED AT BS 727D, STR 9L. REPAIRED FRAME PER SRM.SDR SWAA052841Frame · crackedDURING SCHEDULED D-CHECK, FOUND CABIN FUSELAGE FRAME CRACKED AT BS 787, STR 9L & STR 9R. REPAIRED FRAME PER SRM.SDR C2XA05TY054Frame · crackedTYS - DURING A SCHEDULED INSPECTION, A CRACK INDICATION WAS FOUND ON THE OUTBOARD UPPER DOOR STOP HOLE AT FRAME 18, STRINGER 14L, CRACK IS AT 9 O'CLOCK HOLE POSITION AND GREATER THAN 50 PERCENT OF STANDARD DEFLECTION. MAINTENANCE REAMED THE DOOR STOP HOLE IAWSDR SWIA200516262Frame · crackedRT FS 280 CRACKED AT TOP SIDE, ITEM FOUND AT C CHECK INSPECTION. INSTALLED ANGLE IAW DWG 601R-11436 AT FS 280.SDR DHL2005742516Frame · corrodedBS 1070 LBL 65 WL 255 FRAME JUST AFT OF L-2 DOOR HAS A CORROSION BULGE. CUT OUT CORROSION ON FORMED WEB ANGLE ATTACHED TO FRAME AT BS 1070 LBL 65 AFT DOOR CUT OUT AT L-2 DOOR IAW SRM 51-40-3 FIG. 1. REMOVED (T) ANGLE, FABRICATED AND INSTALLED NEW ANGLE 2.75 ISDR ASOA05763Frame · crackedDURING A C-CHECK IN MCN, THE RIGHT FRAME AT FS 718, STRINGER 11 AND 12, WAS FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE REPAIRED THE RIGHT SIDE FRAME AT FS 718, STRINGER 11 AND 12, IAW ASA EO 600-53-0066. (M)SDR ASAA0540474Frame · crackedBSTA 787 FRAME CRACKED AT BIN RAIL STATION. CUTOUT DAMAGE AT FRAME BIN RAIL SUPPORT AND FABRICATED AND INSTALLED REPAIR IAW SRM. (K)SDR ASAA0540473Frame · crackedBSTA 480, FRAME CRACKED AT BIN RAIL STATION. CUTOUT DAMAGE AT FRAME BIN RAIL SUPPORT AND FABRICATED AND INSTALLED REPAIR IAW SRM. (K)SDR ASAA0540472Frame · crackedBSTA 380, FRAME CRACKED AT BIN RAIL STATION. CUTOUT DAMAGE AT FRAME BIN RAIL SUPPORT AND FABRICATED AND INSTALLED REPAIR IAW SRM. (K)SDR ASAA0540471Frame · crackedPAE - FRAME CRACKED AT BIN RAIL STATION. CUTOUT DAMAGE AT FRAME BIN RAIL SUPPORT AND FABRICATED AND INSTALLED REPAIR IAW SRM. (K)SDR 0501576718Frame · corrodedDURING L-CHECK FOUND CORROSION AND CRACK ON FRAME IN LT BLG WHEEL WELL AT BS 1146. REPAIRED IAW EA 67-165244.SDR SWAA052830Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SRM.SDR SWAA052829Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER SRM.SDR 05FDEA02944Frame · dentedLOWER FUSELAGE, LT AIRCON COMPT NR 1 INTERIOR FUSELAGE FRAME AT STA 577 LT LONGERON 44-48L, FOUND DENTED. DENTED FRAME REMOVED & NEW FRAME INSTALLED AS PER SRM 51-35-01 VOL.II. NEW FRAME FABRICATED AS PER DRAWING ACA 3352 P/N FX ACA 3352-3. MINOR REPAIR PER GSDR SWIA200515977Frame · crackedPILOT'S FLOOR PROP CRACKED AT FRAME 13, ITEM FOUND AT C-CHECK INSPECTION. SPLICED IN REPLACEMENT SECTION OF FRAME NR 13 FLOOR SUPPORT COLUMN (PILOT'S SIDE) PER EMB120 SRM 53-10-10 PG 214-220.SDR 2005FA0001497Spar · damagedFOUND LT AND RT MAIN SPAR WEBS DAMAGED FROM STATION 50 TO 63. EACH WEB HAD DIAGONAL WRINKLES FROM TOP OF SPAR, JUST IB OF LANDING GEAR ATTACH AREA, DOWN AND IB TO JUST OB OF DRAG BRACE BRACKET AND REINFORCEMENTS. AIRCRAFT HAS BEEN FOUND TO BE IN COMPLIANCE WSDR 0501566718Frame · crackedDURING L-CHECK FOUND CRACK IN FRAME AT BS 380 S27R AND S28R. REPAIRED IAW EA 67-165241.SDR SWAA052802Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8R TO STR 9R. REPAIRED FRAME PER SRM.SDR SWAA052801Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R TO STR 9R. REPAIRED FRAME PER SRM.SDR SWAA052800Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8L & STR 8R. REPAIRED FRAME PER SRM.SDR SWAA052799Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8L & STR 8R. REPAIRED FRAME PER SRM.SDR SWAA052798Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L & STR 8R. REPAIRED FRAME PER SRM.SDR SWAA052797Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L & STR 8R. REPAIRED FRAME PER SRM.SDR ASAA0540470Frame · crackedBSTA 480 FRAME IS CRACKED AT BIN RAIL SUPPORT BETWEEN STR 8 LT AND 9 LT AT IB FASTENER. CUTOUT DAMAGE AT BSTA 480 FRAME BIN RAIL SUPPORT AND FABRICATED AND INSTALLED REPAIR. (K)SDR VTZA200500185Doubler · crackedRIGHT FRAME DOUBLER CRACKED IN RADIUS AT 1 INCH IN LENGTH.SDR 05FDEA02867Frame · nickedDURING AIRPLANE' S CONVERSION FROM P TO F FOUND: AVIONIC COMPARTMENT AT STA 469 X= 33 WITH 2EA NICKS ON THE FRAME. BLEND OUT NICK AREA IAW SRM 53-00-01 FIG 1B, AND INSTALL FRAME REPAIR IAW SRM 53-30-00 FIG 4A.SDR UPS05245523Frame · corrodedCORROSION FOUND AROUND ANCHOR NUT ON FRAME UPPER CHORD LWR SIDE AT BS 680 RBL 25. REPAIR CARRIED OUT IAW SRM 51-10-01, 51-10-2 AND 51-40-3.SDR 05FDEA02847Frame · nickedMAIN DECK - DVI CARRIED OUT ON INTERIOR FUSELAGE, NICK FOUND ON FRAME 535 LEFT HAND AT G-NET CAUSED BY SUPPORT YOKES. MAIN DECK STATION 535 LEFT HAND FRAME REPAIRED AS PER DWG SRZ-53-503. THIS REPAIR CLASSIFIED AS MAJOR REPAIR AS PER GMM 6-2-100.SDR SWIA200516252Frame · crackedCRACK ON FRAME FLANGE AT FS 640 RT STR 9R, ITEM FOUND AT C CHECK INSPECTION. REPAIRED CRACKED FRAME IAW CRJ REO 601R-53-61-1543 AND RII 53-401.SDR SWIA200516251Frame · crackedFUSELAGE, FRAME STATION 265 STR 16 LT, FRAME FLANGE DAMAGED, ITEM FOUND AT C-CHECK INSPECTION. REPAIRED IAW REO 601R-53-11-927.SDR ASAA0510293Frame · corrodedYXX - FOUND CORROSION ON FRAME TO SKIN ATTACH ANGLE AT BS 360 BETWEEN STRINGER 26-27 RT. REMOVED AND REPLACED FRAME TO SKIN ATTACH ANGLE PER SRM 53-10-4. (M)SDR SWIA200515620Frame · crackedCARGO COMP, FRAME FLANGE IS CRACKED, FS 605.00 - STRL 9L, LOWER SIDE ITEM FOUND AT C-CHECK INSPECTION. REPAIRED DAMAGE FRAME FLANGE FS 605.00; STR 9L IAW CRJ REO 601R-53-61-1529SDR C1HA200581015Frame · dentedFRAME DENTED IN FWD CARGO PIT STA 680 OVER STRINGER 25R, MARKED. CUT OUT DAMAGED AREA DIM 1.375 X .875 INCHES AND FABBED ANGLE REPAIR FROM 7075T6 .063 PO9002507 DIM 15.75 X 3.75 IAW 727 SRM 53-10-2 FIG 5 AND 51-40-3 FIG 1. ANGLE TREATED AND PRIMED INSTALLED SDR C1HA200581016Frame · dentedFRAME DENTED IN FWD CARGO -B- STA 660 OVER STRINGER 26R, MARKED. CUT OUT DAMAGED AREA DIM 2.125 X 1 INCH, FABBED REPAIR ANGLE FROM 7075T6 .063 PO 9002126 DIM 13 X 4 INCHES IAW 727 SRM 53-10-2 FIG 5 AND 51-40-3 FIG 1. REPAIR ANGLE TREATED AND PRIMED INSTALLEDSDR 2005UALA00971Frame · dentedFWD PIT FRAME IS DENTED 2 PLACES AT STA 620 BETWEEN STR 26L AND 24L. *S/D* TRIMMED OUT DAMAGE AND INSURANCE CUT, FAB NEW SPLICE AND REPAIR ANGLE AND INSTALLED.SDR 2005UALA00970Frame · dentedFWD PIT FRAME AT STA 520, STR 24L, IS DENTED. TRIMMED OUT DAMAGE AND INSURANCE CUT, FABBED J-ANGLE REPAIR AND INSTALLED.SDR ASAA0540455Frame · dentedFWD CARGO BAY FRAME IS DENTED. REMOVED DAMAGED SECTION OF FRAME, FABRICATED REPAIR PARTS AND INSTALLED IAW SRM. (K)
Back to JASC 5311