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 C2XA06SH094Frame · crackedSHV - DURING C CHECK AN EDDY CURRENT INSPECTION OF THE MAIN DOOR STOP ATTACHMENT HOLE ON FRAME 15 AT STR 14L INDICATED A CRACK. MAINTENANCE REAMED THE AFFECTED HOLE AND SUBSEQUENT DYE PENETRANT INSPECTION IAW EC 5310-01386 REVEALED NO RELEVANT INDICATIONS. TSDR MALA060557Frame · chafedDURING 2 YEAR CHECK IN BNA FOUND THE RT FUSELAGE FRAME AT FS 686.888 IS CHAFED BETWEEN SL1614 AND SL1620. THE DAMAGE HAS BEEN REPAIRED IAW EO NR S53380.SDR SWAA063534Beltframe · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE BELTFRAME CRACKED AT BS 380, STR 13L. REPAIRED BELTFRAME IAW SWA EA.SDR SWAA063532Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8L. REPAIRED FRAME SECTION IAW SWA EA.SDR SWAA063531Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8R. REPAIRED FRAME SECTION IAW SWA EA.SDR SWAA063530Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8L. REPAIRED FRAME SECTION IAW SWA EA.SDR SWAA063529Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME SECTION IAW SWA EA.SDR KCSA061338Frame · corrodedBS 2360 BULKHEAD, HOLES 149 AND 150 AT STR 40L CORRODED.SDR KCSA061337Frame · corrodedBS 2360 BULKHEAD, HOLE 147 AT STR 38R CORRODED.SDR KCSA061336Frame · corrodedBS 2360 BULKHEAD, HOLE 143 AT STR 36L CORRODED.SDR KCSA061335Frame · corrodedBS 2360 BULKHEAD, HOLE 159 AT STR 46R CORRODED.SDR KCSA061334Frame · corrodedBS 2360 BULKHEAD, HOLE 156 AT STR 44L CORRODED.SDR KCSA061333Frame · corrodedBS 2360 BULKHEAD, HOLE 199 AT STR 49R CORRODED.SDR KCSA061332Frame · corrodedBS 2360 BULKHEAD, HOLE 163 AT STR 48L CORRODED.SDR KCSA061331Frame · corrodedBS 2360 BULKHEAD LOWER FWD CHORD BETWEEN STR 36R AND STR 36L HAS SEVERAL HOLES CORRODED OUT OF LIMITS.SDR KCSA061326Frame · corrodedFORWARD BILGE FUSELAGE CIRCUMFERENTIAL FRAME HAS CORROSION ON UPPER CHORD AT STA 820, LBL 45.SDR IXXA06SMN301SFrame · misrepairedDURING ROUTINE C-CHECK INSPECTION FOUND FRAME WITH NON STANDARD REPAIR AT STATION 1580.000 BETWEEN LONGERON 20 LT AND LONGERON 21 LT. REMOVED FASTENERS. REMOVED DAMAGED AREA. PERFORMED NDT INSPECTION, AFTER DAMAGE REMOVED, NO CRACKS OR CORROSION FOUND. FABRICSDR KCSA061321Tension Tie · bentBS 900 TENSION TIE FWD AND AFT CHANNELS BENT AT LBL 50.SDR KCSA061318Shear Web · crackedLT BS 820 SLOPING SHEAR WEB CRACKED ABOVE STR 12L IB RADIUS .5 INCH LONG.SDR KCSA061317Frame · crackedSTA 520 STR 20L FRAME CRACKED AT STRINGER CUTOUT.SDR 06FDEA03330Frame · damagedFOUND FRAME HAS FIGURE 8 HOLE AT BS 660 STR 7R. REMOVED DAMAGE ON FRAME BS 660 STR 7R AND REPAIRED IAW SRM 53-10-4.SDR 06FDEA03329Frame · damagedFOUND FRAME HAS A FIGURE 8 HOLE AT BS 620 STR 7R. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR PER SRM 51-40-02.SDR 06FDEA03328Frame · damagedFRAME HAS FIGURE 8 HOLE WITH FASTENERS INSTALLED AT BS 720, STR 7R. REMOVED DAMAGE FROM FRAME BS 720 STR 7R AND REPAIRED IAW SRM 53-10-4SDR 06FDEA03327Frame · damagedFOUND FRAME HAS FIGURE 8 HOLE BS 700, STR 7R. REPAIRED FRAME AT BS 700, STR 7RT IAW SRM 53-10-4, MAJOR REPAIR.SDR 06FDEA03326Frame · damagedFRAME HAS FIGURE 8 HOLE WITH FASTENERS INSTALLED AT BS 720B STR 7R. REPAIRED FRAME AT BS 720B STR 7RT IAW SRM 53-10-1 FIG 2SDR 06FDEA03325Frame · damagedFRAME HAS FIGURE 8 HOLE WITH FASTENERS INSTALLED AT BS 720E STR 7R. REMOVED DAMAGE ON FRAME BS 720E STR 7R AND REPAIRED IAW SRM 53-10-4SDR 06FDEA03318Frame · dentedFOUND FWD CARGO BAY DENT IN REPAIR DOUBLER ON FRAME STA 660 BETWEEN STR 23L - 24L. REMOVED PREVIOUS REPAIR, FABRICATED AND INSTALLED NEW REPAIR PER SRM 51-40-3.SDR 06FDEA03316Frame · gougedFRAME I/B CHORD GOUGED IN RADIUS STA 950E STR 26R. REMOVED DAMAGE I/B FRAME CHORD BS 950E STR 26R REPAIRED IAW SRM 51-40-4.SDR SWAA063493Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE BELTFRAME CRACKED AT BS 360, STR 16L. REPAIRED BELTFRAME PER SWA EA.SDR SWAA063483Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO DOOR CUTOUT AFT FRAME CRACKED AT NR 5 DOOR STOP. REPAIRED FRAME SECTION PER EA.SDR SWAA063482Frame · crackedDURING SCHEDULED SPV CHECK, FOUND AFT CARGO DOOR CUTOUT FWD FRAME CRACKED AT LOWER FWD CORNER. REMOVED AND REPLACED FRAME SECTION PER BOEING DRAWING AND SRM.SDR 06FDEA03317Frame · dentedFOUND FWD CARGO BAY DENT IN FRAME INNER FLANGE STA 500 BETWEEN STR 23R - 24R. REPAIRED FRAME AT BS 500, STR 23-24 RIGHT PER SRM 51-40-3.SDR KCSA061310Frame · corrodedCORROSION ON UPPER PART OF BS 940 CIRCUMFERENTIAL FRAME AT RBL 44SDR KCSA061307Frame · crackedFRAME CRACKED AT STA 2160 STR 25R.SDR USAA061160Frame · corrodedFWD CARGO FLOOR, 500 RBL 18 CORROSION. REMOVED DAMAGE, INSTALLED DOUBLERS AND FILLERS IAW EA 98038 LEVEL 2 C-53-208-01, DEFECT SIZE: 4 INCHES.SDR USAA061161Frame · corrodedSTA 807 RBL 2 SHEAR TIE CORROSION. CUT OUT DAMAGE, AND INSTALLED REPAIR IAW SRM 53-00-07 FIG 201 LEVEL 2, C53-107-02, DEFECT SIZE: 6 X 1 INCH.SDR PIDA06114Frame · crackedCRACK AT FRAME STA 616 RBL 64 JUST BELOW FLOOR LEVEL. REPAIRED IAW SB 737-53-1182 FIG 9.SDR CALA0600333Frame · corrodedINSPECTION FOUND LOWER O/B CHORD OF BULKHEAD CORRODED AT STA 227.8, LBL 5 TO RBL 10, S29L TO 29R. A REPAIR WAS INSTALLED IAW ECRA 5311-01268.SDR SWAA063457Beltframe · corrodedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE BELTFRAME CORRODED AT BS 1006 BETWEEN STR 27L AND 27R. REPAIRED BELTFRAME PER SWA EA.SDR AWXA200601618Frame · crackedMAJOR REPAIR - C-17 CHECK, NR 5934371. CRACK IN R2 DOORWAY CUTOUT FWD FRAME, BS 953.5, S8R - S9R, WL 264. REPLACED R2 DOORWAY CUTOUT FWD FRAME, BS 953.5, S8R - S9R, WL 264 IAW SRM 51-40-02, FIGURES 2, 3 & 8.SDR HALA0600799Frame · damagedFOUND DOUBLE HOLE IN ANGLE AT BS 287 RBL 75 FROM PREVIOUS REPAIR. REMOVED DAMAGED ANGLE AND INSTALLED NEW ANGLE PER SRM 51-40-02 PG 4 STEP 7, BS 287 RBL 75, WL 200.SDR 06FDEA03244Frame · damagedFUSELAGE UPPER LOBE, DRILL START IN FRAME FWD SIDE, 3.5" BELOW STR 8L, BS 720E. REMOVED DRILL START IN FRAME FWD SIDE 3.5" BELOW STR 8L BS 720E AND REPAIRED IAW SRM 51-40-3 FIG 1.SDR USAA061149Frame · crackedBS 440 S24R CRACK. REMOVED DAMAGE, FABRICATED AND INSTALLED NEW DOUBLER IAW EA 98032, DEFECT SIZE: 1 INCH.SDR USAA061144Frame · crackedBS 440 S-24R CRACKED. REMOVED DAMAGED, FABRICATED AND INSTALLED DOUBLER AND TRIPLER IAW EA 98032, DEFECT SIZE: 1 INCH.SDR EIA2006256Frame · crackedMAIN DECK STA 1900 STR 13 R TO STR 14R AREA FRAME CRACKED. REPAIRED IAW SRM 53-10-04, FIG 87.SDR S9BA00306Frame · corrodedDURING WING STRUT BOLT INSPECTION, FOUND CORROSION ON STS 218.11 (MAIN FRAME). REMOVED AND REPLACED MAIN FRAME IAW SERVICE BULLETIN 6/354.SDR MWEA060196Frame · bentFORWARD GALLEY DOOR CUTOUT AFT FRAME IS BENT AT FUSELAGE 200. FABRICATED AND INSTALLED FRAME SHIELD.SDR HALA0600696Frame · crackedL FUSELAGE L END OF FRAME STA237 L18LT - L19LT 2" CRACK. OK TO CONTINUE PER M105 NR 475090.SDR EIA2006245Frame · corrodedAFT CARGO STA 1800 RB LINE 40-70, FRAME INNER CHORD FOUND CRACKED. CHORD REPLACED IAW SRM 53-11-23.SDR EIA2006237Frame · crackedFOUND AFT CARGO STA 1800 RBL 70 FRAME INNER CHORD CRACKED. CHORD REPLACED IAW SRM 53-11-23 FIG 1.
Back to JASC 5311