JASC 5310
Service difficulty reports · 38,573
Reports filed under 5310 · Fuselage Main, Structure, 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 = '5310' 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 = '5310' 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 DALA13063973143Fitting · corrodedAFT UTILITY AREA RT AFT DOOR CUTOUT FITTING AT FRAME 68, LOWER CORNER CORRODED. REMOVED CORROSION IAW SRM 51-74-00. NO ESTABLISH LIMITS IN SRM. REPLACED CORNER FITTING.SDR CA131126005Window Frame · corroded(CAN) DURING RT WINDSHIELD REPLACEMENT, FOUND CORROSION ON RT LOWER POST FRAME.SDR FDEA201311202834Floorbeam · corrodedCABIN STATION 440 RBL 2 FLOOR BEAM UPPER FLANGE FOUND CHAFFED. REPAIR CARRIED OUT. REFER TO DRC 0045, STAE EA 757-5335-08-E2457 REV A WITH 8110-3 DATED JAN 16 2014 FOR WORK DETAIL. REPAIR CLASSIFIED MINOR PER GMM 6-2-100SDR FDEA201311202838Crease Beam · corrodedCABIN STATION 1000 - STATION 1040 RT CREASE BEAM INNER CHORD CORROSION. CORROSION REPAIR CARRIED OUT ON RT CREASE BEAM INNER CHORD FROM STA 1010 TO STA 1040, RBL 64, IAW DWG LOR5L53017 REPAIR 2 REV A AND DWG 144N5140 SHT 2 REV C. REPAIR IS MAJOR.SDR SWAA2013121123163Window Frame · crackedLT NR 3 WINDOW FRAME E-F POST 2ND FASTENER HOLE FROM BOTTOM CRACKED. R & R FRAME IAW E.SDR DALA13062790962Beam · corrodedDURING SCHEDULED CHECK, CORROSION ON AFT CARGO BAY DOOR FRAME LOWER BEAM, BS 1155 - 1212.SDR DALA13062559002Door Frame · corrodedDURNG SCHEDULED CHECK, CORROSION WAS FOUND ON A FWD CARGO DOOR FRAME SPLICE AT THE FORWARD SEAL DEPRESSOR SEAM. REPLACED CORRODED MATERIAL AND INSTALLED SPLICE DOUBLER IAW DWG 5910142.SDR CA131121006Tube · cracked(CAN) DURING WHAT WAS THOUGHT TO BE A ROUTINE WELD OVERLAP REPAIR, IT WAS BROUGHT TO OUR ATTENTION THAT IT WAS ACTUALLY A CRACK. .7500 OF THE DIAMETER OF TUBE NUMBER 11029-7, AT802 IPC REF FUSELAGE GRP 1 ITEM 169, WAS FOUND TO BE CRACKED AROUND DIAMETER OF TUBSDR SWAA2013121123160Window Frame · crackedRT NR 1 WINDOW FRAME CRACKED AT OTBD FASTENER HOLE. R & R FRAME IAW ACO.SDR SWAA2013121123159Window Frame · crackedRT NR 1 WINDOW FRAME CRACKED AT UPPER OTBD CORNER. R & R FRAME IAW ACO.SDR SWAA2013120322931Crease Beam · crackedCREASE BEAM CRACKED AT BS 520, STRINGER 17R. REPAIRED CHORD IAW EA.SDR SCNA20131122228Window Frame · damagedFLIGHT DECK LT WINDOW FRAME NR 3 CRACKED AND OUT OF LIMITS AND REQUIRES REPLACEMENT. R & R FLIGHT DECK LT NR 3 WINDOW FRAME.SDR SWAA2013121123158Window Frame · crackedLT NR 1 WINDOW FRAME CRACKED IN UPPER OTBD CORNER. R & R WINDOW IAW ACO.SDR WX0A2013111800757Door Frame · corrodedAFT CARGO DOOR CUT-OUT FRAEM BEAM CORRODED OUT OF LIMITS. REMOVED DAMAGED FRAME BEAM, LOCATED, DRILLED, AND INSTALLED IAW SRM 51-30-5.SDR ASAA2013111696577Strap · crackedAFT CARGO DOOR SILL VERTICAL WEB UPPER STRAP CRACKED. FABRICATED NEW STRAP IAW SRM 51-40-05-0G-0.SDR USAA2013111800042Crease Beam · corrodedDURING C4 CHECK. CABIN CREASEBEAM CORRODED BETWEEN BS 754 AND 763 AT LBL 64. REPAIRED CREASE BEAM IAW SRM 51-10-02, 53-30-13, 51-40-02, 51-70-12 & 51-20-21.SDR 39LA2013111500011Beam · corrodedCORROSION FOUND ON NLG WELL BEAM AT FS 3223, WL 0, LT BUTT LINE 310. REPAIRED IAW DWG 13021-2029.SDR 39LA2013111500008Structure · crackedWHILE PERFORMING P4 INSPECTION, FOUND UPPER DECK STRUCTURE CRACKED IN THREE PLACES AT FS 6405, RT SIDE, BUTT LINE RBL260. REPAIRED IAW AIRLIFT DWG 13021-2027 AND 13021-2028.SDR 39LA2013111500007Structure · crackedWHILE PERFORMING P4 INSPECTION, FOUND UPPER DECK STRUCTURE CRACKED IN FOUR PLACES BETWEEN FS 6138 AND 6405, LT SIDE. REPAIRED IAW DWG 13021-2026.SDR SWAA2013112522733Window Frame · crackedL1 COCKPIT WINDOW FRAME CRACKED AT UPPER OTBD CORNER. R & R FRAME IAW ACO.SDR EVCA2013111400052Stiffener · crackedDURING A ROUTINE INSPECTION, FOUND A CRACK IN LT STIFFENER.SDR SWAA2013120923118Window Frame · crackedRT NR 3 FLIGHT DECK WINDOW FRAME 2ND FROM BOTTOM WINDOW ATTACH FASTENER HOLE ON WINDOW FRAME E-F POST CRACKED. R & R FRAME IAW SWA EA.SDR SWAA2013120923117Window Frame · crackedLT NR 3 FLIGHT DECK WINDOW FRAME 2ND FROM BOTTOM WINDOW ATTACH FASTENER HOLE ON WINDOW FRAME E-F POST CRACKED. R & R FRAME IAW SWA EA.SDR ASAA2013111396522Doubler · bentEXTERNAL FUSELAGE, POWER RECEPTACLE DOOR 114AR CUTOUT INNER DOUBLER BENT AT FWD CENTER AREA. ACFT GROUNDED. REPAIRED EXT POWER DOOR DOUBLER IAW REO G16904, REV A DATE 11-24-13 AND EA 800-53EA-11655, REV NEW DATE 25, NOV 2013.SDR USAA2013111800051Crease Beam · corrodedDURING C4 CHECK, CREASEBEAM CORRODED AT BS 750 AND LBL 55. R & R CREASE BEAM IAW SRM 51-10-02, 51-40-02 & 53-30-13-1A AND DWG 143N8322.SDR USAA2013111800044Crease Beam · corrodedDURING C4 CHECK. CREASE BEAM CORRODED BETWEEN BS 680 AND 740 AT RBL 56. R & R CREASE BEAM IAW SRM 51-10-02, 53-00-51-1A & 51-40-02-0G.SDR ASAA2013111396435Attach Bracket · crackedINTERCOSTAL ATTACH BRACKET IS CRACKED IN RADIUS AT BS 360 S11L. ACFT GROUNDED. R & R INTERCOSTAL ATTACH BRACKET IAW SRM 51-40-02-0G-0.SDR DALA13060486301Structure · crackedCRACK FOUND AT HOLE LOCATION F ON LEFT BS 1265. REPAIRED IAW ERA518840-14AD REV ORIGINAL.SDR SIMA20131112009Door Frame · crackedDURING HMBV INSPECTION, FOUND COCKPIT UNDERFLOOR HATCH IS CRACKED IN TWO SPOTS AT THE AFT RT LOCKING PIN BRACKET. REMOVED AND REPLACED HATCH SURROUND FRAME IAW SRM 51-40-02. PRESSURE LEAK CHECKED GOOD IAW AMM 21-31-00-700-808A. NO LEAKS NOTED.SDR FDEA201311122743Crease Beam · corrodedBS 600 -620 RT CREASEBEAM WEB FOUND CORRODED. REMOVED IAW SRM 51-40-02 REV 110 & REPLACED WITH FABRICATED CREASE BEAM WEB IAW DWG 143N5520, SHT 3, REV B.SDR SWAA2013111922592Window Frame · crackedFLIGHT DECK RT NR 1 WINDOW FRAME UPPER OTBD RADIUS CRACKED. REPAIRED FRAME IAW EA.SDR FDEA201311112726Door Frame · corrodedAFT LOWER CARGO DOOR, FWD SIDE FRAME WEB SEAL HAS CORROSION AROUND ATTACHED SNAP FASTENER, BETWEEN LOWER EDGE BEAM AND NR 6 BEAM OUTER TEE. REPAIRED IAW EA F-5230-T0303889. REPAIR CLASSIFIED AS MAJORSDR ASAA2013111196479Seat Track · crackedSEAT TRACK AT BS 727B, RBL 24.75 OTBD FLANGE CRACKED. REPAIRED SEAT TRACK IAW REO G16888, REV B AND EA 800-53EA-11635.SDR MTNA20131111046Crease Beam · gougedFOUND GOUGES IN CREASE BEAM WEB, OUT OF LIMITS. REPLACED WEB IAW SRM.SDR IPXA2013111300839Structure · corrodedEVIDENCE OF APU TAIL PIPE FIRE. PAINT BLISTERED SHOWING ALUMINUM ALSO ADDITIONAL ITEM, DURING HFEC INSPECTION OF FUSELAGE, FOUND HEAVY CORROSION UNDER FAIRING. REMOVED CORROSION IAW SRM 51-21-01. MAPPING INFO SENT TO ENG TRANSFERRED TO NR 551043 AS A MAJOR RSDR QMLA2013110913163Housing · crackedDURING INSPECTION OF THE FDC INLET BARRIER FILTER SEAL, DISCOVERED LARGE CRACK IN THE FIBERGLASS FILTER HOUSING JUST BELOW SEAL.SDR ASOA20131109269Beam · corrodedDURING C-CHECK, THE CARGO DOOR CUTOUT LOWER BEAM WAS FOUND TO BE CORRODED BETWEEN FRAMES 65-68 AND STRINGERS 15-16L. MAINTENANCE R & R THE BEAM IAW SRM 51-40-02. ACFT APPROVED FOR RETURN TO SERVICE.SDR SWAA2013120222832Crease Beam · corrodedCREASE BEAM WEB CORRODED BETWEEN STATION 598 TO STATION 617, STRINGER 18L. REPAIRED WEB IAW SRM.SDR AALA20131108004Beam · corrodedAFT CARGO DOOR BEAM CORRODED. INSTALLED DOUBLER IAW AARD 53-10-00-3.SDR ASAA2013110796720Doubler · damagedUPON REMOVAL OF AFT CARGO DOOR CUTOUT FWD FRAME FOUND INNER PRODUCTION DOUBLER TO HAVE ELONGATED HOLES. ACFT GROUNDED. R & R 794 FRAME INNER PRODUCTION DOUBLER IAW SRM 51-40-02-0G-0.SDR CALA2013110792709Failsafe · crackedBS 1140 FAILSAFE CRACKED. FAILSAFE REPAIRED IAW SRM 53-40-07 REPAIR 2 FIG201 STEP F.SDR FDEA201311072711Support Fitting · crackedCARRIED OUT HIGH FREQUENCY EDDY CURRENT OPEN HOLE INSPECTION AND FOUND LOWER DOOR FRAME NR 7 SUPPORT FITTING CRACKED AT HOLE "B" AND "C". REMOVED AND REPLACED IAW SRM 51-33-01, REVISION 53. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100 REVISION 118.SDR FDEA201311072710Support Fitting · crackedCARRIED OUT HIGH FREQUENCY EDDY CURRENT INSPECTION AND FOUND LOWER DOOR FRAME NR 3 SUPPORT FITTING WITH CRACK INDICATION AT HOLE NO "A" AND "C". REMOVED AND REPLACED IAW SRM 51-33-01, REVISION 53. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100 REVISION 118.SDR CHQA20131106417Stop Fitting · crackedDURING INSPECTION, A CRACK WAS FOUND ON THE PAX DOOR FRAME AT THE FWD STOP SECOND FROM THE TOP. THE STOP WAS REPLACED IAW SRM 51-40-02.SDR CHQA20131106413Stop Fitting · corrodedDURING INSPECTION, CORROSION WAS FOUND ON THE PASSENGER DOOR STOP INTERNAL BACKUP STRUCTURE ON THE FWD LOWER STOP. THE STOP WAS REPLACED IAW SRM 51-40-02.SDR SWAA2013111122068Window Frame · crackedLT NR 3 WINDOW FRAME CRACKED ON 2ND FASTENER HOLE FROM BOTTOM OF E-F POST. REPAIRED FRAME IAW SI.SDR SWAA2013111122067Window Frame · crackedRT NR 3 WINDOW FRAME CRACKED ON 2ND FASTENER HOLE FROM BOTTOM OF E-F POST. REPAIRED FRAME IAW SI.SDR CALA2013110792714Door Frame · crackedAFT RT CARGO DOOR AFT SIDE OF DOOR CUTOUT FRAME WEB CRACKED & TORN BELOW E-6 EQUIPMENT RACK. REPAIRED IAW B767-300 SRM 53-00-07, REPAIR 3, FIG 201.SDR SWAA2013120423019Window Frame · crackedLT NR 3 FLIGHT DECK WINDOW FRAME FASTENER HOLE NR 2 FROM THE BOTTOM CRACKED AT THE 3 & 9 O'CLOCK POSITION. REPAIRED FRAME IAW EA.SDR SWAA2013112722827Window Frame · crackedCOCKPIT RT NR 3 WINDOW FRAME, E-F POST CRACKED AT 2ND HOLE. REPAIRED FRAME IAW SWA EA.
Back to JASC 5310