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 EIA2007164Frame · corrodedWHALE BONE (WING TO BODY FAIRING FRAME) CORRODED AT STA 880 STRINGER 46R TO 48R UPPER SURFACE OF LOWER BEAM. REPLACED WHALE BONE AT STA 880 BETWEEN STR 46R TO 48R PER ECRA NR 486-53-059-2.SDR SWAA074662Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA074673Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 597, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA074661Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 559, STR 8R. REPAIRED FRAME PER SWA EA.SDR 07FDEA03913Coupling · corrodedFOUND CORRODED STRINGER COUPLING AT FRAME 55/58, STRG 52 RT. REPLACEMENT OF COUPLING IAW SRM 51-72-10.SDR 07FDEA03912Coupling · corrodedFOUND CORRODED STRINGER COUPLING AT FRAME 55/58, STRG 56 LT AND RT SIDE. REPLACEMENT OF BOTH COUPLINGS IAW SRM 51-72-10.SDR 07FDEA03911Coupling · corrodedFOUND CORRODED COUPLING AT FRAME 55/58, STRG 55 LT AND RT SIDE. REPLACEMENT OF COUPLING IAW SRM 51-72-10.SDR 07FDEA03910Coupling · corrodedFOUND CORRODED COUPLING AT FRAME 55/58, STRG 44 LT. REPLACEMENT OF COUPLING IAW SRM 51-72-10.SDR 07FDEA03897Frame · chafedFOUND CHAFING MARKS ON MILLED FRAME FLANGE, C 28, P 8-21, LT. REPAIR PERFORMED BY BLEND OUT THE AFFECTED AREA IAW EA 6-5314-114895 AND RAS/DABRE/7008329/2007 ISS ASDR 07FDEA03896Frame · chafedFOUND CHAFING MARKS ON MILLED FRAME FLANGE, C 28, P 8-21, LT REPAIR PERFORMED BY BLEND OUT THE AFFECTED AREA IAW EA 6-5314-114895 AND RAS/DABRE/7008329/2007 ISS A.SDR KCSA071381Frame · crackedBS 520 FRAME CRACKED AT STR 12L CUTOUT.SDR EIA2007171Frame · crackedAFT CARGO BS 1560 STR 37L FRAME FOUND CRACKED. AFT CARGO BS 1560 STR 37L FRAME REPAIRED PER EA-53-1185.SDR 07FDEA03867Frame · corrodedAFT LWR CARGO PIT FUSE. CUTOUT FOR NR 3 DOOR, STA 1130 PLUS 13" AFT SIDE FRAME HAS CORROSION DOWN LOW WHERE SCUFF PLATE MOUNTS AT STR 26R. REMOVED FRAME AT STA 1130 PLUS 13, FROM STRINGER 18R-28. REPLACED WITH NEW FRAME STA 1130 PLUS 13, FROM STRINGER 18R -SDR 07FDEA03820Frame · crackedMAIN CABIN STRUCTURE HAS CRACK ON FRAME. REPAIRED FRAME IAW SRM 53-30-00 FIG 5 VOL I.SDR KCSA071377Frame · crackedFUSELAGE FRAME AND DOUBLER CRACKED AT BS 400, STR 16L.SDR KCSA071376Frame · dentedFUSELAGE FRAME DENTED AT BS 1880, STR 13R.SDR KCSA071375Frame · crackedFUSELAGE FRAME CRACKED AT STR 13R.SDR EIA2007180Frame · corrodedAFT CARGO BS 1960 STR 37L FRAME FOUND CORRODED. AFT CARGO BS 1960 STR 37L FRAME REPAIRED PER EA-53-1186.SDR EIA2007174Frame · crackedMAIN DECK BS 488 LT FRAME WEB FOUND CRACK AT STR 25 AREA. MAIN DECK BS 488 LT FRAME WEB REPAIRED PER SRM 53-10-04 FIG 92.SDR SWAA074619Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA074620Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8L AND STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA074618Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA074617Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR 2007UALA04143Frame · gougedAFT PIT FRAME AT BS 787 & RBL 22 HAS A 0.40 DEEP GOUGE ON UPPER FLANGE. SUSPECT DAMAGED DUE TO NORMAL LOADING AND OFF LOADING OF AC. REMOVED DAMAGE & ACP NDT FOR CRACK CONTAINMENT. FABRICATED & INSTALLED REPAIR DOUBLER. AC OK FOR SERVICE.SDR FDKA200709497Frame · crackedTHE APU AIR INLET FRAME IS CRACKED. REPAIRED DAMAGE.SDR EIA2007167Frame · damagedAFT PIT BOOR CUT OUT FWD LOWER SIDE FRAME WEB AND SKIN CUT. FOUND UPON REMOVAL OF SEAL DEPRESSOR FOR REPAIR. REPAIRED PER ECRA NR 486-53-064-2.SDR EIA2007160Frame · damagedFWD PIT DOOR CUT OUT, AFT LOWER SIDE, FRAME WEB HAS DRILL STARTS, NEXT TO ATTACH LOCATIONS, FOUND UPON REMOVAL OF SEAL DEPRESSOR FOR REPAIR. REPAIRED DAMAGED AREA ON WEB AT FWD PIT DOOR CUT OUT AFT LOWER SIDE PER ECRA 3 486-53-063-2.SDR SIMA200727302Frame · bentDURING A HMBV INSPECTION, THE RIGHT FUSELAGE FRAME AT STATION 668.0 WAS FOUND BENT. INSTALLED NEW FRAME P/N 7253813-117 IAW SAAB SRM CHAPTER 51-40-21. AIRCRAFT RETURNED TO SERVICE.SDR ASAA0782038Frame · crackedAFT ACCESSORY COMPARTMENT FRAME CRACKED. STOP DRILLED CRACKED AND REPAIRED PER SRM 53-03.SDR ASAA0782037Frame · puncturedAFT ACCESSORY COMPARTMENT FRAME PUNCTURED. REPLACED DAMAGED SECTION OF FRAME WITH REPAIR DOUBLER PER SRM 51-70-4 AND 53-14.SDR ASAA0782021Frame · chafedFRAME CHAFED. REMOVED DAMAGED AREA. INSTALLED REPAIR ANGLE FILLER AND REPAIR PLATE PER SRM 53-03.SDR SWAA074627Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500D, STR 20R. REPAIRED FRAME PER SRM.SDR 07FDEA03790Frame · failedFOR REPLACEMENT OF STRINGER 50 LT AND RT FROM THE COUPLING FWD OF FRAME 55 (NON ROUTINE DR106) IT IS NECESSARY TO CUT FRAME 54.2 BETWEEN STRG 50-51, LT AND RT FRAME SPLICE REPAIR PERFORMED ON BOTH SIDES LT AND RT AS PER A300-600 FREIGHTER SRM 53-10-13/ FIG 203SDR 07FDEA03789Frame · dentedFWD PIT FRAME, STA 660 UPPER FLANGE HAS A DENT BETWEEN STR 23R-24R FOUND 3 DENTS ON UPPER FLANGE OF STA 660, BETWEEN S-22R -S-25R AND FOUND OUT OF LIMITS, CUTOUT DAMAGE, FORMED NEW FRAME SPLICE DOUBLER OUT OF 7075 O .050, HEAT TREATED MATERIAL 7075-T6 THEN DSDR 07FDEA03788Frame · crackedFRAME CRACKED IN FASTENER HOLE AT FRAME 43A LOWER HOLE COMMON TO CRUCIFORM FITTING LT SIDE SEE JOB CARD 41X5271ALI FROM CABIN SIDE 1ST LAYER RUNNING IN THE 5 O`CLOCK DIRECTION .075 DEEP AND RUNNING TO THE 2ND LAYER 100 PERCENT ON SCREEN AMPLITUDE REMOVED AND RSDR 07FDEA03786Frame · crackedFRAME CRACKED IN FASTENER HOLE AT FRAME 42A LOWER HOLE COMMON TO CRICIFORM FITTING SEE JOB CARD 41 BY 5271ALI. RT SIDE FROM CABIN SIDE THE FIRST LAYER RUNNING IN THE 6 O`CLOCK AND 9 O`CLOCK DIRECTIONS APPROX .100 DEEP TO THE 2ND LAYER 100 PERCENT + AMPLITUDE SDR 07FDEA03745Frame · damagedNICK ON FRAME 61, STRG 15 LT AND THREE OPEN FASTENER HOLES. REPAIR PERFORMED BY BLEND OUT NICK AND CLOSING BLIND OPEN FASTENER HOLES IAW EA 6-5317-92170 AND RAS/DATLS/0002688/2005 ISSUE A.SDR DU4R2007168Frame · crackedFOUND DENT/CRACK ON FRAME BS 1560 BETWEEN S-24L AND S-23L IN AFT PIT. REPAIRED BY CUTTING OUT DENT/CRACK SECTION OF FRAME, HFEC NO RELEVANT INDICATION. FABRICATED AND INSTALLED FRAME REPAIR 13.5" BY 3" FROM 7075-T6 .063 IAW B757 SRM 51-40-02, 51-20-01.SDR NWAA073269989Frame · crackedDURING "H" CHECK, FOUND CRACKS AND WEAR IN FRAME ANGLE AT BS 1004 BS 0. REPAIRED PER EA 99-210176.SDR ASAA0782019Frame · corrodedFRAME CORRODED. REPLACED FRAME PER SRM 53-03.SDR SWAA074572Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727E, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA074609Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8R ABD STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA074608Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8R AND STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA074607Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA074592Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 947, STR 18L. REPAIRED FRAME PER SRM.SDR SWAA074574Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 767, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA074567Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 663, STR 3R. REPAIRED FRAME PER SRM.SDR SWAA074610Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA074611Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500D, STR 22L. REPAIRED FRAME PER SWA EA.SDR SWAA074573Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.
Back to JASC 5311