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 UALA2012060503090Tension Tie · crackedBS 1160 RT TENSION TIE DOUBLER CRACKED. INSTALLED NEW DOUBLER PER DRAWING 65B01751-10 AND SRM 51-40-02.SDR UALA2012060503089Failsafe · crackedBS 1220 LT TENSION TIE FAILSAFE CRACKED. CUT OUT DAMAGE. INSTALLED REPAIR PARTS IAW SRM 51-70-11.SDR ASOA2012061401783Crossbeam · crackedBS 280 CROSSBEAM CRACKED AT APPROX RBL 9 & CORROSION IN SEVERAL AREAS ON UPPER FLANGE. COMPLY WITH EO 700-53-0061. COMPLIED WITH EO 700-53-0061. RII FOUND TO BE SATISFACTORY.SDR DALA1238079265Door Frame · corrodedCENTER CARGO BAY DOOR FRAME AT LOWER SIDE BETWEEN BS 693 AND 750 WITH SURFACE CORROSION. REPLACED DOUBLER PER 53-00-01.SDR EIAA20120603049Reveal · crackedM/D DOOR 4R CUTOUT FWD REVEAL PANEL AT STR 23R - 24R FOUND CRACK. ET CARRIED OUT AS PER PT6/51-00-00 FIG 23, CONFIRMED CRACKED END. STOP DRILLED CRACKED END AS PER SRM 53-60-15 R-4, CONFIRMED CRACK-FREE CONDITION AS PER PT 6/51-00-00 FIG 23 REPAIR PARTS & FISDR EIAA20120603046Reveal · crackedMAIN DECK DOOR 4L CUT OUT FWD REVEAL PANEL ASTR 23L FOUND CRACK. CONFIRMED CRACK END AREA AFTER ET CHECK AS PER PT6/51-00-00 FIG 23, STOP DRILLED CRACK END PER SRM 53-60-15 FIG 201 REPAIR 4, CONFIRMED CRACK-FREE CONDITION BY NDT PER PT 6/51-00-00 FIG 23, REPASDR CA120601007Crosstube · cracked(CAN) CRACKED TUBE FOUND IN AFT FUSELAGE, UPPER LT TUBE. TUBE IS IN AREA OF AIR TRACTOR SL 266 EXCEPT FOR IT IS NOT THE DIAGONAL TUBE BUT THE 1 TO THE LT OF IT.SDR DALA1237730910Door Frame · corrodedAFT CARGO DOOR FRAME CORRODED. FABRICATED AND INSTALLED REPAIR AT BS 1155 TO 1211 IAW SRM 51-30-05 DURING CPCP/PSV.SDR SWAA2012061104842Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED BETWEEN BS 727B TO BS 727C. REMOVED AND REPLACED WEB IAW SRM AND DWG.SDR FDEA201206012046Floor Panel · crackedFLOOR PANEL 252PH HAS ONE, TEN INCH CRACK. FABRICATED REPLACEMENT FLOOR PANEL IAW DWG SRZ 25-005, REV J.SDR DALA1234940940Door Frame · corrodedCORROSION ON SPLICE OF FWD CARGO COMPARTMENT DOOR FRAME FROM STA Y=376-382 AND 417-423. REPAIRED PER ERA 503263- 14 REV A.SDR REXA2012061300852Beam · damagedRIGHT FS 280 BEAM CORRODED. REMOVED AND REPLACED IAW SRM 53-00-00.SDR REXA2012061300851Beam · damagedLEFT FS 280 BEAM CORRODED. REMOVED AND REPLACED IAW SRM 53-00-00.SDR REXA2012060100684Structure · damagedMAINTENANCE FOUND LIGHTNING DAMAGE TO A FASTENER HOLE AT FS 543 S5R. THE DAMAGE WAS REMOVED BY BLENDING RESULTING IN A 0.12 BY 0.007 BY 0.004 DEEP BLENDOUT. REPAIRED IAW EA CRJ953-00563D AND ASSOCIATED 8110-3.SDR DALA1235046305Tension Tie · crackedCRACK INDICATION FOUND DURING HFEC OPEN HOLE INSPECTION AT R TENSION TIES STATION 1140 ON LOWEST FASTENER FIRST FASTENER HOLE FROM OUTBOARD LOOKING FORWARD.SDR IPXA2M74075Door Frame · crackedINSPECTION TYPE:4C, CRACK ON R3 DOOR LOWER FORWARD JAMB LIGHTNING HOLE STA 1250. REPAIRED R3 DOOR JAMB FORWARD WEB AT LOWER LIGHTNING HOLE IAW SRM 53-40-15, REPAIR 3, FIG 201.SDR SWAA2012061104806Window Frame · crackedFLIGHT DECK CENTER BEAM BETWEEN CAPTAINS AND F/O WINDOW FRAME CRACKED AT LOWER FORWARD END. REPAIR FRAME IAW EA.SDR FDEA201205292001Rail · crackedRAIL CRACKED. REPAIRED IAW EA 8-5330-159845, PART 1C AND 1D. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100, REV 114.SDR SWAA2012060604702Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED BETWEEN BS 727E TO BS 727D. REMOVED AND REPLACED WEB IAW SRM.SDR DALA1234756305Failsafe · crackedCRACK FOUND IN FAILSAFE CHORD AT BS 1140 STRINGER S9-10R. MAINTENANCE ACCOMPLISHED ER/A 503505-14AD SECTION I REPAIR.SDR DALA1234510940Door Frame · scratchedSEVERAL SCRATCHES ON R1 DOOR JAMB INTERNAL PANEL APPROXIMATELY STA Y=170 BTW LONG 18RH-19 RT. REPAIRED PER SRM 53-05 FIG 55.SDR DALA12000366305Tension Tie · crackedDURING INSPECTION, FOUND CRACK AT RIGHT SIDE TENSION TIE AT BS 1200 ON TOP FASTENER ROW, 5TH FASTENER HOLE FROM OUTBOARD LOOKING FORWARD. MAINTENANCE REPAIRED CRACK PER SRM 53-40-03 REPAIR 1 FIG 201.SDR DALA12000356305Tension Tie · crackedDURING INSPECTION FOUND CRACK AT LEFT SIDE TENSION TIE AT BS 1120 ON TOP FASTENER ROW, 4TH FASTENER HOLE FROM OUTBOARD LOOKING FORWARD. MAINTENANCE REPAIRED CRACK PER PER SRM 53-40-30 REPAIR 1 FIG 201.SDR SIMA20120526006Crossbeam · corrodedDURING "C" CHECK, FOUND CROSSBEAM FS 280.00 CORRODED. AIRCRAFT REMOVED FROM SERVICE. REMOVED AND REPLACED CROSSBEAM IAW SRM 51-42-06 AND 51-42-13. AIRCRAFT RETURNED TO SERVICE.SDR SWAA2012060404585Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED AT BS 747. REMOVED AND REPLACED WEB IAW SRM.SDR SWAA2012060404584Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED AT BS 767. REMOVED AND REPLACED WEB IAW SRM.SDR ABXA20120525352Filler · looseLEFT EMERGENCY OVERWING EXIT HAS COMPOUND DETACHED AT THE LOWER AFT CORNER. FILLING COMPOUND REPLACED ON REA 653-59852-MR REF BOEING DWG 140T4500. ACFT WAS GROUNDED.SDR FDEA201205251971Crease Beam · damagedRT CREASE BEAM ANGLE BETWEEN STA 940-980 RBL 64 HAS TWO AREAS OF DAMAGE. BLENDED AREA IAW SRM 51-10-02 CHECKED LIMITS. ORIGINAL MATERIAL .063 REWORK .040 MATERIAL LOSS .023 CREASE BEAM FOUND TO BE OUT OF LIMITS IAW SRM 53-60-13, DETAIL VIII, FIG 101. R & R SDR DALA1236140121Door Frame · corrodedCARGO DOOR CUTOUT AFT FRAME WEB CORROSION BETWEEN S32L AND S33L BS 1461. REPAIRED PER ERA 502708-14 REV ORIG.SDR C77A20120524003Crossbeam · corrodedON THE UPPER SURFACE OF CROSSBEAM AT FRAME 17, RBL 14.5 IS CORRODED BETWEEN RT SILL AND RT SEAT TRACK. REMOVED CORROSION BY BLENDING AND TREATING IAW SRM 51-10-03 & 51-12-01.SDR FDEA201205241962Crease Beam · corrodedCREASE BEAM INNER CORD AT STA 1628 RT IS CORRODED. R & R CREASE BEAM IAW SRM 51-40-02 AND DWG 146N5590-57. MAJOR REPAIR.SDR FDEA201205241961Crease Beam · corrodedCREASE BEAM INNER CORD STA 1628 LT IS CORRODED. BLENDED AREA IAW-SRM-51-10-02, CHECKED LIMITS, ORIG MATERIAL 0.079, MATERIAL LOSS 0.070, MATERIAL REMAINING 0.009, CREASE BEAM FOUND TO BE OUT OF LIMITS IAW-SRM-53-60-13, FIG 101, DETAIL VIII. R & R CREASE BEASDR FDEA201205241949Crease Beam · crackedCREASE BEAM INNER CHORD AT BS 1141 LBL 64, CRACKED. R & R INNER CHORD FABRICATED IAW DWG 144N5200 SHT 3, REV A AND INSTALLED IAW DWG 144N5200, SHT 3, REV A AND SHT 4, REV A. REPAIR IS CLASSIFIED AS MAJOR.SDR SWAA2012061104822Window Frame · crackedR1 WINDOW FRAME LEFT UPPER CORNER POST OUTBOARD CRACKED. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR SWAA2012061104821Window Frame · crackedL1 WINDOW FRAME LEFT UPPER CORNER POST OUTBOARD CRACKED. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR FDEA201205221932Frame · crackedCRACK AT NR 1 CARGO DOOR AFT FRAME BS 620, S25R. CUT OUT DAMAGED AREA IAW SRM 51-40-3, FABRICATED AND INSTALLED REPAIR DOUBLER IAW SRM 53-10-2, FIG 3 AND SRM 51-40-2, FIG 1.SDR 7AHR201205222466Frame · corrodedAFT TAIL CONE ACCESS DOOR PANEL NR 3802 FRAME HAS CORRODED RIVET HEADS AND RUB PADS. REMOVED RIVETS AND RUB PADS FROM TAIL CONE ACCESS DOOR IAW SRM 51-30-2. FABRICATED NEW RUB PADS AND INSTALLED RUB PADS AND NEW FASTENERS AS IAW SRM 51-30-2.SDR DALA1234000979Structure · crackedRIGHT RAM AIR PACK DISCHARGE OUTLET HAS A 5.5 INCH CRACK. MAINTENANCE CUT OUT DAMAGED AREA PER SRM 53-01. HFEC INSPECTED PER NDT SRM 06-10-01, NO OTHER DEFECTS NOTED. FABRICATED DOUBLER AND FILLER. TREATED AND INSTALLED PER SRM 53- 01 FIG 2.SDR EE4Y2012102300310Window Frame · crackedCOCKPIT WINDOW FRAME CRACKED. PERFORMED A PERMANENT REPAIR IAW SB 53-290 R1. ACCOMPLISHED COCKPIT ENCLOSURE WINDOW LOWER SILL FRAMES PERMANENT REPAIRS IAW SB 53-290, REV 01.SDR DALA1239400679Failsafe · corrodedAFT CARGO FRAME HAS CORROSION FWD AND AFT SIDE AND ON FAILSAFE BS 1520 RBL 26-LBL 26. REMOVED CORROSION, FOUND AREA TO BE OUT OF LIMITS. REMOVED AND REPLACED FAILSAFE IAW SRM 51-40-5 DURING HMV.SDR ASOA20120519104Crossbeam · corrodedCORROSION WAS FOUND IN THE ISLE AT FRAME 20 CROSS-MEMBER THAT WAS BLENDED OUT OF LIMITS. MX R & R THE CROSS-MEMBER IAW SRM 51-20-03 AND 51-40-02. ALL WORK ACCOMPLISHED AND WILL BE RELEASED AT THE END OF THE CHECK.SDR FDEA201205171829Crease Beam · corrodedRT INBD CREASE BEAM CORRODED BS 1340-1380. REMOVED CORROSION AND FOUND OUT OF LIMITS IAW SRM 53-60-13, FIG 101, DETAIL VIII. R & R CREASEBEAM, BS 1290-1405, RT, IAW SRM 51-40-02, AND DWG 146N8326. MAJOR REPAIR.SDR SWAA2012060404634Crease Beam · corrodedAFT GALLEY DOOR CUTOUT CREASE BEAM UPPER SURFACE AROUND FASTENER HOLES CORRODED. REMOVED AND REPLACED CREASE BEAM IAW SRM AND DWG.SDR DALA1232930176Failsafe · crackedDURING ULTRASONIC INSPECTION, FOUND CRACK INDICATION ON FAILSAFE OF REAR SPAR SPAR BULKHEAD RT BS 955 AT 0800 POS LOOKING OUTBOARD. REPAIRED FAILSAFE IAW ERA 502640-14AD REV ORIG.SDR FDEA201205161819Crease Beam · corrodedMAIN CABIN AREA LT SIDE BETWEEN BS 760 - 740. LBL 65 CREASE BEAM INBD CHORD CORRODED. REMOVED CREASE BEAM FOUND OUT OF LIMITS IAW SRM 53-30-13, FIG 101, DETAIL VIII. REPLACED CREASE BEAM BS 670 - 750 IAW SRM 51-40-02 AND DWG 143N8328. MAJOR REPAIR.SDR SWAA2012051604075Door Frame · damagedL1 DOOR FRAME CREASED AT BS 237, BETWEEN STR 17L TO STR 18L. REPAIRED FRAME PER SRM.SDR SWAA2012051604073Crease Beam · corrodedRT CABIN FLOOR CREASE WEB CORRODED AT FS 170. REMOVED AND REPLACED WEB IAW SRM.SDR FDEA201205161821Crossbeam · gougedMAIN DECK CARGO CROSSBEAM FR 57 BETWEEN SEAT TRACK 2R AND 3R AFT SIDE OF CROSSBEAM HAS ONE GOUGE AT VERTICAL STIFFENER, ONE GOUGE ON RADIUS OF RISER, NINE GOUGES ON AFT FACE OF CROSSBEAM AT FASTENER HOLES. SMOOTHED DAMAGED AREA IAW SRM 51-73-10 PG 209, STEP SDR DALA1234300184Failsafe · crackedDURING ULTRASONIC INSPECTION, FOUND CRACK INDICATION ON FAILSAFE STRAP OF THE REAR SPAR BULKHEAD RT 955.1 AT 9 AND 4 O`CLOCK LOOKING OTBD. CRACK AREA REPAIRED AS PER ERA 503089-14AD REV ORIG DATED 05/25/12.SDR DALA1234290184Failsafe · crackedDURING ULTRASONIC INSPECTION, FOUND CRACK INDICATION ON FAILSAFE STRAP OF THE REAR SPAR BULKHEAD LT 955.1 AT 4 AND 9`OCLOCK LOOKING OTBD. CRACK AREA REPAIRED AS PER ERA 503090-14AD REV ORIG DATED 05/28/2012.
Back to JASC 5310