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 SWAA2013073018662Crease Beam · corrodedRT CREASE BEAM WEB CORRODED AT BS 794 TO BS 807. REPAIRED WEB IAW SRM.SDR FDEA201307201605Window Frame · chafedF/O SLIDING WINDOW FRAME SHOWS EVIDENCE OF CHAFING/FRETTING DAMAGE FROM AN ADJACENT SOLID RIVET TAIL WHEN IN THE CLOSED POSITION. DAMAGED AREA BLENDED, ASSESSED AND NDT INSPECTED IAW CMM 56-12-11 AND NTM 51-10- 08 WITHIN LIMITS AND EA 6-5300-167476 ,PAGES 1SDR UALA2013072205103Window Frame · corrodedSECOND WINDOW FRAME FWD OF LT FWD OVERWING HATCH HAS LIGHT CORROSION. REMOVED CORROSION AND MATERIAL REMAINING EXCEEDED LIMITS OF SRM 56-20-02. REMOVED WINDOW FRAME AND INSTALLED SERVICEABLE FRAME.SDR FDEA201307191588Support Fitting · crackedDURING HIGH FREQUENCY EDDY CURRENT FOR OPEN HOLE INSPECTION FOUND TWO CRACK INDICATIONS ON NR 1 MAIN DECK CARGO DOOR LOWER FRAME SUPPORT FITTING AT HOLE "C" AND "D". R & R IAW SRM 51-31-01, REV 52. REPAIR CLASSIFIED MAJOR IAW GMM 6-2-100, REVISION 116.SDR CHQA20130719305Beam · corrodedDURING INSPECTION, CORROSION WAS FOUND ON THE SERVICE DOOR CUTOUT LOWER BEAM. THE THRESHOLD PLATE WAS REPAIRED IAW SRM 53-40-02.SDR UHLA2013071900331Retainer · gougedFWD PASSENGER DOOR AFT METAL SEAL HAS TWO GOUGES. R & R L1 DOOR SEAL RETAINER AFT. MAJOR REPAIRSDR ASOA2013073108820Crossbeam · corrodedCORROSION ON CROSSBEAM AT BS 349, APPROX RBL 9. REPAIRED IAW SRM 53-21-43-101-001-A01, 51-42-06-001-001-A01 AND 51-40-11-001-001-A01.SDR UHLA2013072800328Crossbeam · corrodedCROSSBEAM AT FRAME 14 CORRODED BETWEEN RT SEAT TRACK AND OTBD FLOOR SUPPORTS. REPAIRED FR 14 IAW ETD 2013-170-019325. MAJOR REPAIR.SDR USAA2013072300020Door Frame · crackedC11 CHECK - SEVERAL CRACKS IN FRAME ONE, OF RT FWD OVERWING EXIT BETWEEN FR38 TO FR39. REPLACED FRAME IAW EO 5210Y228.SDR USAA2013072300019Door Frame · crackedC11 CHECK - SEVERAL CRACKS IN FRAME ONE, OF LT FORWARD OVERWING EXIT BETWEEN FR38 TO FR39. REPLACED FRAME IAW EO 5210Y228.SDR USAA2013072300018Door Frame · crackedC11 CHECK - SEVERAL CRACKS IN FRAME 1 OF LT AFT OVERWING EXIT BETWEEN FR40 TO FR41. REPLACED FRAME IAW EO 5210Y228.SDR USAA2013072300017Door Frame · crackedC11 CHECK - SEVERAL CRACKS IN FRAME SEGMENT 1 OF RT AFT OVERWING EXIT BETWEEN FR40 TO FR41. REPLACED FRAME 1 OF RT AFT OVERWING EXIT IAW EO 5210Y228.SDR UALA2013071905094Structure · crackedRIGHT AC PACK RAM AIR EXHAUST DUCT OUTLET VERTICLE SIDE WALLS ARE CRACKED. REPLACED RT AC PACK RAM AIR OUTLET FLAP IAW AMM. FLAP ACTUATOR NEEDS TO BE INSTALLED IAW AMM 21-61-52.SDR IXXA20130718041Angle · crackedTWO CRACKS IN THE INNER ANGLE OF THE AFT LOWER CARGO DOOR JAMB AT BS 1440 BY THE NR 6 DOOR STOP. FABRICATED THE CHORD SPLICE SECTION FROM 7075-T6511 EXTRUSION. ANNEAL AND FORM THE REPAIR SPLICE TO CONTOUR AND HEAT TREAT TO T-6. FABRICATED REPAIR WEB FROM 707SDR C77A20130721002Beam · corrodedFORWARD CARGO DOOR LOWER BEAM HAS CORROSION. X=7828, Y=390 BLENDED CORRODED AREAS IAW SRM 51-10-03 & 51-12-01.SDR FDEA201307171580Structure · damagedCLIMBING THROUGH 11,000 MSL, HEARD A LOUD PRESSURIZATION BUMP. CABIN RATE CLIMBING AT 2000 FPM AND CABIN ALT CLIMBING. LEVELED AT APPROX 14000 MSL AND STARTED DESCENT TO 10,000 AT APPROX 11000 MSL CABIN, ALT 1 EICAS. COMPLIED WITH QRH, SELECTED AUTO 2 AND SDR MTNA20130716029HCrease Beam · corrodedFOUND CORROSION ON CREASE BEAM WEB, OUT OF LIMITS. REPLACED WEB IAW SRM.SDR SWAA2013080218812Window Frame · crackedFLIGHT DECK RT NR 3 WINDOW E-F POST SECOND FROM BOTTOM FASTENER HOLE CRACKED. R&R FRAME IAW EA.SDR SWAA2013080218811Window Frame · crackedFLIGHT DECK LT NR 3 E-F WINDOW POST SECOND FROM BOTTOM FASTENER HOLE CRACKED. R&R FRAME IAW SWA EA.SDR ASOA20130716122HRib · crackedDURING 2A INSPECTION, THE RT WHEELWELL AFT RIB WAS FOUND TO HAVE MULTIPLE CRACKS. MX REMOVED THE CRACKED SECTION OF RIB AND PERFORMED A FILLER & DOUBLER REPAIR IAW EC5320-01974 AND THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR SWAA2013071618272Window Frame · crackedRT NR 1 FLIGHT DECK WINDOW FRAME CRACKED IN UPPER OTBD CORNER. REPAIRED FRAME IAW SWA EA.SDR FDEA201307161576Crease Beam · misrepairedCREASE BEAM BS 1620 MISREPAIRED. R & R CREASE BEAM BS 1370-1630 WITH A NEW ONE IAW-SRM-51-40-02 AND DWG 146N5590, CAT "A" MAJOR REPAIR.SDR MTNA20130717030HCrease Beam · corrodedFOUND CORROSION ON CREASE BEAM WEB, OUT OF LIMITS. REPLACED WEB IAW SRM.SDR C77A20130715004Depressor · corrodedFWD CARGO DOOR CENTER SEAL DEPRESSOR, HAS CORROSION. R & R CENTER SEAL DEPRESSOR IAW SRM 51-41-01 AND 51-43-01.SDR C77A201307015003Depressor · corrodedDURING HEAVY CHECK, FOUND FWD CARGO DOOR LOWER FWD SEAL DEPRESSOR CORRODED. R & R FWD SEAL DEPRESSOR IAW SRM 51-41-01 AND 51-43-01.SDR MTNA20130715028Crease Beam · corrodedFOUND CORROSION ON CREASE BEAM WEB OUT OF LIMITS. REPLACED WEB IAW SRM.SDR FDEA201307141558Door Frame · crackedLEFT WHEEL WELL DOOR UPPER FRAME AT CENTER HINGE AREA, FOUND CRACKED. REPAIRED IAW EA 1-3210-T0301171 PART 1. REPAIR CLASSIFIED MAJOR AS PER GMM 6-2-100 REVISION 116SDR UALA2013071604962Stop Fitting · looseRT FWD EMERGENCY EXIT CUTOUT, FWD UPPER DOOR STOP PAD LOOSE. REINSTALLED LOOSE DOOR STOP PAD ON THE RT FWD EMER EXIT CUTOUT IAW DWG 144N8641.SDR UALA2013071604967Structure · damagedLIGHTNING STRIKE BS 518 BETWEEN STR 7L AND 8L.SDR UALA2013071604966Structure · damagedLIGHTNING STRIKE BS 536 BETWEEN STR 7L AND 8L. REPAIRED IAW SRM 53-00-01, REPAIR 6, FIG 201.SDR FDEA201307131561Crease Beam · corrodedCREASE BEAM INBD ANGLE AT BS 900 TO 940 HAS CORROSION AROUND FASTENER HOLES RT SIDE. FOUND TO BE OUT OF LIMITS IAW SRM 53-40-14, FIG 101, DET VII. R & R CREASE BEAM INBD ANGLE AT STA 900-1040 IAW SRM 51-40-02 & DWG 144N5152. CATEGORY "A" MAJOR REPAIR.SDR UALA2013071504907Structure · corrodedAFT CARGO INNER STRUCTURE CORRODED AT BS 1440, RBL 19 AFT OF DOOR CUTOUT. CORROSION FOUND TO BE OUT OF LIMITS IAW SRM 53-00-53, FIG 101. REMOVED STRUCTURE IAW SRM 51-40-02. FABRICATED, LOCATED, DRILLED, ALODINED, PRIMED, TOP COATED AND INSTALLED NEW STRUCTUSDR A6WA201307241093Drag Angle · crackedLT MLG WHEEL WELL DRAG ANGLE COMMON TO INBD BATT RIB IS CRACKED. R & R IAW SRM.SDR A6WA201307241092Drag Angle · crackedRIGHT MLG WHEEL WELL DRAG ANGLE COMMON TO INBD BATT RIB IS CRACKED. R & R IAW SRM.SDR FDEA201307121547Crease Beam · misrepairedCREASE BEAM MISREPAIRED AT BS 1620. REMOVED CREASE BEAM BS 1410- 1630, IAW SR 51-40-02 . LOCATED & DRILLED NEW CREASE BEAM IAW SRM 51-40-05 AND DWG 146N5590. TREATED & PRIMED IAW SRM 51-20-01, INSTALLED CREASE BEAM FROM BS 1410 -1630 IAW SRM 51-40-02 ASDR DALA13034749205Casting · gougedELEVATOR AND TAB MECHANISM INSTALLATION, BS 1160, RBL6, 5" BELOW FLOOR LEVEL, CASTING IS GOUGED. REPAIRED IAW PRI ERA 51603-14, REV O AND FINAL ERA 516031-14.SDR YN8R201307120001Door Frame · crackedFOUND APPROXIMATELY 4 INCH CRACK IN RADIUS OF LOWER CABIN DOOR FRAME AT AFT HINGE.SDR SIMA20130712001Door Frame · corrodedDURING HMBV INSPECTION, FOUND CORROSION AROUND NUTPLATE HOLE ON AFT LOWER SURFACE OF DOOR CUTOUT BELOW DOOR STOP. ACFT REMOVED FROM SERVICE. PERFORMED REPAIR OF DOOR FRAME IAW EO-EM-53MR-2166.SDR REXA2013071101407Spacer · corrodedAT RADIO ALTIMETER TRANSMIT NR 1 ANTENNA FUSELAGE SPACER PITTED. REPAIRED NR 1 RADIO ALT SPACER.SDR VNAA2013071100007Structure · damagedCREW REPORTED LIGHTNING STRIKE IN FLIGHT, ALONG LEFT SIDE OF AIRCRAFT FROM NOSE AREA BACK. MX PERFORMED LIGHTNING STRIKE INSPECTION, R & R STATIC DISCHARGERS ON HORIZONTAL STABILIZER AND WINGLETS AND PERFORMED CHECKS USING AMM. ACFT RELEASED FOR SERVICE.SDR FDEA201307111538Crease Beam · corrodedBS 1183, LT CREASE BEAM WEB UPPER SKIN FOUND CORRODED. R & R IAW DWG 146N5590, SHT 9, REV.-. REPAIR IS MAJOR.SDR FDEA201307111536Crease Beam · corrodedBS 1421, RT CREASE BEAM WEB UPPER SKIN FOUND CORRODED. R & R IAW DWG 146N5590, SHT 4, REV E. REPAIR IS MAJOR.SDR FDEA201307111529Door Frame · chafedFORWARD CARGO DOOR AFT DOOR FRAME FOUND CHAFED BETWEEN LONGERON 40- 41R. TRIMED OUT AND CARRIED OUT REPAIR IAW SRM 53-00-15, FIG 202. REPAIR 8, REV 52, REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100, REV 116.SDR SWAA2013071118143Window Frame · crackedRT NR 3 FLIGHT DECK WINDOW FRAME ON E-F POST, SECOND LOWER CORNER FASTENER HOLE CRACKED. REPAIRED FRAME IAW SWA EA.SDR SWAA2013071118144Window Frame · crackedLT NR 3 FLIGHT DECK WINDOW FRAME ON E-F POST, SECOND LOWER CORNER FASTENER HOLE CRACKED. REPAIRED FRAME IAW SWA EA.SDR 5XWR201307110363Structure · misoverhauledPERFORMED A PHASE 2, 3, & D, TASK A361004, BLEED AIR LINE EXHIBITED CORROSION WHERE ITS FLANGE FASTENS TO THE FUSELAGE SKIN BS 187.87 RBL 27, AND WL 62.79. ON DISASSEMBLY, FLANGE TO FUSELAGE JOINT FOUND WITH HEAVY DISSIMILAR METAL CORROSION. INVESTIGATION SDR SWAA2013072418500Door Frame · corrodedFWD CARGO DOOR CUTOUT LOWER JAMB CORRODED. R&R JAMB IAW SRM.SDR FDEA201307101523Crease Beam · damagedMDC LT CREASE BEAM INBD ANGLE FROM BS 1370-1630 HAS DOUBLE DRILLED HOLES, NUMEROUS SHORT EDGED MARGIN HOLES AND SEVERAL AREAS AROUND FASTENERS HOLES SHOW BARE METAL. R & R INBD CHORD FROM BS 1370 - 1630 LT IAW SRM 51-40-02, DWG 146N5590. PART OUT OF LIMITS FOSDR DALA13034440976Door Frame · crackedOVERWING FRAME BS 886 LT CRACKED, IN UPPER RADIUS OF FRAME TAB. REPAIRS COMPLETED.SDR DALA13034430947Window Frame · crackedCRACK ON THE FWD LOWER CORNER AT CABIN WINDOW CUTOUT BETWEEN BS 541 - 560 RT SIDE. REPAIR WAS ACCOMPLISHED IAW AMR 09531242, REV 1, AND ER/A 516230-14, REV ORIG.
Back to JASC 5310