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 U2RA1013Frame · corrodedDURING COCKPIT AREA CORROSION INSPECTION PER AD92-22-07 (CPCP 5), LEVEL 2 CORROSION WAS FOUND ON RT FRAME AT FS -67, L23R AND ADJACENT AREA. AFFECTED AREA IS IN PROCESS OF BEING REPAIRED.SDR U2RA1013865Frame · corrodedDURING COCKPIT AREA CORROSION INSPECTION PER AD92-22-07 (CPCP 5), LEVEL 2 CORROSION WAS FOUND ON RT FRAME AT FS -67, L23R AND ADJACENT AREA. AFFECTED AREA IS IN PROCESS OF BEING REPAIRED.SDR SWAA060500Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT FWD CARGO BAY CUTOUT, LOWER OUTBOARD CORNER, NR 5 STOP FITTING. REPAIRED FRAME PER SRM.SDR 06FDEA0624Frame · crackedFWD CARGO COMPT BILGE FOUND 2 CRACKS ON CAP ANGLE AT STA 715 FROM L49 RT TO L50 RT. CUTTED AND REMOVED CAP FRAME BTWN L51-52 RT AND BTWN L47-48 RT INSTALLED NEW SECTION OF FRAME CAP AND NEW SPLICES IAW SRM 53-30-00 FIG 5 VOL 1 REF SRM 53-30-00 FIG 8 SHT 1 NOTSDR 06FDEA0623Frame · crackedFWD CARGO COMPT BILGE FOUND CRACK 0.25" LONG ON CAP ANGLE AT STA 695 FROM L49 RT TO L50 RT. CUT AND REMOVED CAP FRAME BTWN L51-52 RT AND BTWN 47-48 RT INSTALLED NEW SECTION OF FRAME CAP AND NEW SPLICES IAW SRM 53-30-00 FIG 5 VOL 1 REF SRM 53-30-00 FIG 8 SHT 1SDR 2006UALA00254Frame · corrodedAFT PIT FLOOR FRAME UPPER CHORD AT BS 1153, LBL 24 TO RBL 18 CORRODED ON TOP AND BOTTOM SURFACES. CORRODED FRAME ASSY PIECES REPLACED AND SPLICED PER SRM.SDR 2006UALA00246Frame · crackedFWD CABIN STA 440 FRAME IS CRACKED JUST BELOW STR 8R. REPAIR OF FRAME ACCOMPLISHED REF MM 53-10-84.SDR 06FDEA0602Frame · damagedFOUND BS 660 ABOVE STR 26 LT FRAME HAS DOUBLED HOLE. REPAIRED FRAME IAW SRM 51-40-03.SDR ASAA0640144Frame · corrodedFOUND CORROSION ON FRAME SHEAR TIE. REPAIRED PER SRM 53 00 07.SDR SWAA060482Frame · crackedDURING SCHEDULED 8Y CHECK, FOUND FUSELAGE FRAME CRACKED AT R1 DOOR CUTOUT, FWD LOWER CORNER. REPAIRED FRAME PER SRM.SDR ABXA060112Frame · corrodedLOWER AFT CARGO, STA 1040, BUTT LINE 0, LOWER FRAME SURFACE CORRODED. REMOVED FASTENERS AND CARGO TRACK TO ACCESS CORROSION SITE. FOUND TO BE OUT OF LIMITS. FABRICATED REPAIR PARTS FOR FRAME AND SHEAR TIE IAW DC8 SRM 53-4-1, 53-2-0 AND DC8 SSRM DRAWING K048SDR UPS06446372Frame · crackedBS480 STR 11L FOUND O/B AREA FOUND CRACK. CRACK LENGTH 7/8" TO 1". BS 480 S10L AND ABOVE U/B FLOORBEAM AREA FRAME REPAIRED AS PER RS R53-10-35447 CONTINUED INSPECTION REQUIRE WHILE PERFORMING SB747-53A2265 INSPECTIONS AND REPLACEMENT WITH SB747-53-2272 MOD RSDR UPS06446370Frame · crackedBS 500 STR 11L FRAME O/B AREA FOUND CRACK. CRACK LENGTH 3/4". BS 500 BETWEEN STR 8L TO STR 13L FRAME REPAIRED AS PER SRM 51-40-03 FIG2.SDR UPS06446369Frame · crackedBS480 STR11-12R FRAME O/B AREA FOUND CRACKED. CRACK LENGTH 5/8" TO 1". BS480 BETWEEN STR 10R AND ABOVE U/D FLOORBEAM AREA FRAME REPAIRED AS PER RS R53-10-35447. CONTINUED INSPECTION REQUIRE WHILE PERFORMING SB747-53A2265 INSPECTIONS AND REPLACEMENT WITH SB7SDR UPS06446364Frame · crackedCOCKPIT BS 360 STR 10L TO STR 10AL FRAME O/B AREA FOUND CRACK, CRACK LENGTH 1" & 0.125". COCKPIT BS360 STR9L TO STR10AL FRAME REPAIRED AS PER RS R53-12-35434 CONTINUED INSPECTIONS REQUIRE WHILE PERFORMING SB 747-53A2265 INSPECTIONS AND REPLACEMENT WITH SB747-SDR UPS06446362Frame · crackedINSPECTION TYPE:C U/D BS400 STR10L FRAME O/B AREA FOUND CRACK. CRACK LENGTH 1/2" U/D BS400 STR9L TO STR10AL FRAME REPAIRED AS PER RS R53-10-35442 CONTINUED INSPECTIONS REQUIRE WHILE PERFORMING SB 747-53A2265 INSPECTIONS & REPLACEMENT WITH SB747-53-2272 AT SDR UPS06446360Frame · crackedBS 420 STR 10L FRAME O/B AREA FOUND CRACK, CRACK LENGTH 1/2". BS420 STR9/10 TO STR 11 FRAME REPAIRED AS PER RS R53-10-35441 CONTINUED INSPECTION REQUIRE WHILE PERFORMING SB 747-53A2265 INSPECTIONS AND REPLACEMENT WITH SB747-53-2272 MOD AT OR BEFORE 20000 FLIGSDR ABXA060102Frame · corrodedLOWER AFT CARGO STA 1100, LOWER FRAME RIGHT BUTT LINE 5 TO LEFT BUTT LINE 5, SURFACE CORROSION. REMOVED CORROSION IAW DC8 SRM 51-1-8 AND 53-2-0. OUT OF LIMITS. INSTALLED DOUBLER IAW DC8 SRM 51-1-20.SDR 06FDEA0582Frame · misdrilledSTA 400 STR 8L, DRILL STARTS ON FRAME WEB. DRILL STARTS STA 400 STR 8L ON FRAME WEB FOUND TO BE OUT OF LIMITS. REMOVED DAMAGE, INSTALLED REPAIR ON FRAME REF SRM 53-10-4 FOUND TO BE A MAJOR REPAIR.SDR SWAA060469Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STUB FRAME CRACKED AT BS 188, STR 17L. REPAIRED FRAME PER SRM.SDR DHL2006753514Frame · puncturedFOUND NR 019639, AFT CARGO COMPT, FRAME AT STA 1090 HAS PUNCTURE IN UPPER FLANGE ABOVE STR 27L LBL 20. CUT OUT DAMAGED AREA DIM 2 1/2 BY 2, FABBED AND INSTALLED REPAIR FILLER (7075-T6 .071 PO>955573 DIM. 2 1/2 BY 2) AND REPAIR ANGLE (7075-T6 .080 PO> 9552619 SDR DHL2006753513Frame · gougedFOUND AFT CARGO COMP UPPER FLANGE OF FRAME IS GOUGED AT STA 1070 AT STR 27R, RBL 20 UNDER TRANSITION PANEL. CUT OUT DAMAGED AREA, (2.5 X 1 INCH) IAW B727 SRM 51-40-3 FIG 1, FABRICATED REPAIR PARTS, DOUBLER 7075-0 PO 5096275,.071 (16 X 4 INCH) AND FILLER, 7075SDR DHL2006753512Frame · dentedFOUND NR 019691, AFT CARGO COMPT FRAME AT STA 1070 IS DENTED ABOVE STR 26R. CUT OUT DAMAGED AREA (2" BY 1"). FABRICATED REPAIR DOUBLER 7075-0, .071 PO 5096275(16" BY 4") IAW B727 SRM 51-40-3 FIG 1 AND 53-10-2 FIG 5. HEAT TREATED REPAIR PART TO 7075-T6 IAW SDR UPS06446366Frame · crackedBS 440 STR9-10R FRAME O/B FLANGE FOUND CRACK. CRACK LENGTH 1.5". BS440 STR9-10R FRAME O/B FLANGE. REPAIRED AS PER RS R53-12-35438 AND UPS RO B747-5310-23800-A.SDR UPS06446365Frame · crackedCOCKPIT BS 287 S10-10A RHS FRAME O/B AREA FOUND CRACK. CRACK LENGTH 0.25" AND 1". COCKPIT BS 287 S10-10A FRAME REPAIRED AS PER RS R53-12-35435 AND UPS EO B747-5310-23811-A.SDR UPS06446361Frame · crackedCOCKPIT BS 360 STR8-9R FRAME O/B FLANGE FOUND CRACK, CRACK LENGTH 0.19" TO 1 1/4". COCKPIT BS 360 STR8-9R FRAME O/B FLANGE REPAIRED AS PER RS R53-12-35433 CONTINUED INSPECTIONS REQUIRE WHILE PERFORMED SB 747-53A2265 INSPECTIONS AND REPLACEMENT WITH SB747-2272SDR DHL2006753505Frame · dentedFOUND NR 019566; FRAME HAS DENT BETWEEN STR 24R 25R BS 700. CUT OUT DAMAGED AREA 1 X 1 INCH FABBED DOUBLER 7075-0 .050 PO 9002695, 9.5 X 3.5 INCH IAW B727 SRM 51-40-3 AND 53-10-2 FIG 3. TREATED AND PRIMED PART IAW B727 SRM 51-10-2, INSTALLED DOUBLER IAW B727SDR DHL2006753504Frame · dentedFOUND NR 019565; FRAME DENTED AT STR 24L BS 680 (RED DOT). CUT OUT DAMAGED AREA 2 X 2 INCH IAW B727 SRM 51-40-3, FABBED FRAME REPAIR DOUBLER 7075-0 .050, 10 X 4 INCH PO 9002695 IAW B727 SRM 51-40-3 AND 53-10-2 FIG 2. HEAT TREATED PART TO 7-75 T6 IAW FAS ER 2SDR 06FDEA0556Frame · dentedAFT CARGO BAY, FRAME UPPER FLANGE IS DENTED, BS 950C, BETWEEN STRINGERS 26R AND 27R. REPAIRED PER SRM 51-40-3 MAJOR REPAIR.SDR 06FDEA0555Frame · dentedAFT CARGO BAY, FRAME UPPER FLANGE IS DENTED, BS 950B, BETWEEN STRINGERS 23L AND 24L. REPAIRED PER SRM 51-40-3.SDR 06FDEA0557Frame · dentedAFT CARGO BAY, FRAME UPPER FLANGE IS DENTED, BS 950F, BETWEEN STRINGERS 23L AND 26L. DENT FOUND TO BE OUT OF LIMITS PER SRM 53-10-1. REPAIRED FRAME BS 950F BETWEEN STR 23L TO 26L USING 7075-T6 .071 M672773 PER SRM 51-40-3. FOUND TO BE A MAJOR REPAIR.SDR 06FDEA0561Frame · dentedAFT CARGO BAY, FRAME UPPER FLANGE IS DENTED, BS 1070, AT STR 26R. REPAIRED FRAME AT BS 1070 STR 26R IAW SRM 51-40-3.SDR 06FDEA0560Frame · dentedAFT CARGO BAY, FRAME UPPER FLANGE IS DENTED, BS 1050 ABOVE AND BELOW STR 26R. REPAIRED FRAME AT BS 1050 ABOVE & BELOW STR 26R IAW SRM 51-40-3.SDR 06FDEA0559Frame · dentedAFT CARGO BAY, FRAME UPPER FLANGE IS DENTED, BS 990, BETWEEN STR 25L AND 26L. REPAIRED FRAME AT BS 990, BETWEEN STR 25L AND 26L PER SRM 51-40-3.SDR 06FDEA0558Frame · dentedAFT CARGO BAY, FRAME UPPER FLANGE IS DENTED, BS 970, BETWEEN STR 25L AND 26L. REPAIRED FRAME BS 970 BETWEEN STR 25L AND 26L IAW SRM 51-40-3.SDR ASAA0610133Frame · crackedFRAME ATTACH AT BS 294.5 STR 12C CRACKED WEB. WEB AT BS 294.5 STR 12L FABRICATED IAW SRM 57 20 1 FIG 3 7 8 9.SDR ASAA0640146Frame · crackedFRAME AT STA 767 IS CRACKED AT FASTENER HOLE BETWEEN STR 26 27RH. CUTOUT DAMAGED AREA OF FRAME FABRICATED AND INSTALLED REPAIR PIECES PER SRM 51 70 11 FIG 1.SDR ASAA0640136Frame · dentedDENT IN FRAME. DENT REPAIRED IAW SRM 5 00 07 FIG 201 REPAIR 1 AND ERO 5523.SDR SWAA060448Beltframe · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE BELTFRAME CRACKED AT BS 500B, STR 21L. REPAIRED BELTFRAME PER SWA EA.SDR SWAA060442Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 303, STR 16L. REPAIRED FRAME PER BAC DRAWING & SRM.SDR SWAA060453Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME PER SRM.SDR 2006UALA00206Frame · crackedFWD CABIN STA 400 FRAME CRACKED JUST BELOW STR 8R. ACP REPAIR REF MM 53-10-84 REPAIR III PG 811. REMOVED DAMAGE REF MM 53-10-84. HFEC REF B73 7 NDT MAN PART 6, 51-00-00 FIG 23. (NO DEFECTS NOTED AFTER DAMAGE REMOVAL) .040 INSURANCE CUT OF DAMAGED AREA. MM 53SDR ASAA0610131Repair · damagedAFT ACCY BAY FRAME REPAIR AT BS 967 BL 0 DOUBLER IS GAPPED AT BOTH ENDS OF UPPER FRAME. REPAIRED FRAME DOUBLER PER EA 5310 02566.SDR ASAA0640127Frame · corrodedFOUND FRAME CORRODED AT FASTENER HOLES. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR FILLER AND DOUBLER PER SRM 51-70-11 FIG 1.SDR ASAA0640123Frame · corrodedFRAME CORRODED AROUND FASTENERS. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR PIECES PER SRM 53-00-07.SDR ASAA0640122Frame · corrodedFRAME CORRODED AROUND FASTENERS AT BSTA 727D STR 27L-27R. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR PIECES PER SRM 53-00-07 REPAIR 7.SDR UPS06446367Frame · crackedBS240 FRAME CRACKED AT S11L CUTOUT. CRACK LENGTH 0.75". M/D BS240 S11L FRAME REPAIRED AS PER RS R53-12-35440 AND UPS EO B747-5310-23825-A AFTER CRACK FREE CONFIRMED BY NDT INSPECTION PER NTM PT6 51-00-00 FIG4.SDR UPS06446345Frame · crackedFOUND LT STA 500 FRAME CRACKED AT BETWEEN STR 13L & 14L U/D FLOORBEAM LOWER CHORD ATTACHMENT AREA, CRACK LENGTH 7/8". BS 500 BETWEEN STR 13L TO STR 16/17L AREA FRAME REPAIRED AS PER SRM 51-40-03 FIG 2.SDR UPS06446221Splice · crackedINSPECTION TYPE:C M/D BS 400 STR 23-25R FRAME I/B CHORD ATT SPLICE FOUND CRACK,CRACK LENGTH .375 INCH. BS 400 STR 23-25R FRAME I/B CHORD ATT SPLICE ANGLE REPLACED AS PER SRM 51-10-01 PG 9.SDR DHL2006804533Frame · maint errorMAIN CARGO COMPT FRAME 3EA MISDRILLED HOLES AT STA 220.000 L-10R (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW FAA FORM 8110-3 DATED 01-31-06, DWG AA66-53-R04 REV IR DATED 01-16-06. CUT OUT DAMAGED SECTION AND FABRICATED REPAIR ANGLE (EXTRUSION BAC 1505-1006477
Back to JASC 5311