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 SCNA97303Structure · damagedFOUND AIRCRAFT SKIN DAMAGE CAUSED BY JET WAY NEAR L-1 DOOR AT STATION 380, WL 206.1. INSTALLED NEW FRAME WEB, STRINGER REPAIRS AND FUSELAGE REPAIRS PER B727 SRM 51-40-4 AND 53-30-3.SDR AALA971204Structure · corrodedTUL - FOUND CORROSION ON FLOOR SUPPORT STRUCTURE. REMOVED SUPPORT AND REPLACED PER SRM 51-74-10-2. (M)SDR CA970902005Fuselage · lightning strike(CAN) ON APPROACH AIRCRAFT STRUCK BY LIGHTNING. CAUTION LIGHT PANEL, PRESSURIZATION CONTROL, BOTH DC GENERATORS, TAXI LIGHT, MASTER WARNING AND AUTO PILOT DISCONNECT ALL LOST. AIRCRAFT LANDED SAFELY. INSPECTION CARRIED OUT AND ALL FOUND SERVICEABLE. ALL AFFECTSDR QXEA9700482Structure · damagedLT APERATURE FORWARD INBOARD TO OUTBOARD RUN HAS HEAVY RUB DAMAGE. BLENDED AREA AND ACCOMPLISHED REPAIR PER EA 9-57-274.SDR CA970709011Fabric · torn(CAN) PILOT NOTED A SLIGHT BUFFETING FOLLOWED BY A SLIGHT ROLL TO THE RIGHT. TEARING AND OIL CANNING SOUND WAS HEARD. ANOTHER AIRCRAFT NOTED THAT THE FABRIC ON UPPER FUSELAGE WAS TORN. REPAIRS CARRIED OUT. AIRCRAFT TT: 9,920 HOURS.SDR UPS97823667Structure · corrodedINSPECTION TYPE:C/CK, INTERIM REPAIR TO FWD CORNER NR 4 PIT DOOR OPENING. REPAIRED PER TIMCO REO 03320 REV IR.SDR MWEA97466Skin · crackedDURING C-CHECK, ABOVE PAX DOOR HOLD OPEN RECEPT FUSE SKIN CRACKED. MAINT REPAIRED IAW SRM 53-04 FIG 24 SHT 1.SDR 97ZZZM863Structure · crackedUPPER FRAME IN STRUCTURE AFT OF FRAME NR 50 HAS ITS LOWER RIGHT CORNER CRACKED AND THE CLEAT THAT ATTACHES IT TO THE UPPER RIGHT HINGE MEMBER IS LOOSE WITH ONE RIVET MISSING (REF SRM 53-40-31 PG 3 ITEM 14). REPAIRED UPPER FRAME STRUCTURE AFT OF FRAME 50 AT RISDR P5CA9700568Web · corrodedLEVEL 1 CORROSION CREW ENTRY DOOR AFT REVEAL LOWER WEB. REMOVED CORROSION PER BOEING SRM 51-10-01, WITHIN LIMITS PER 53-10-01 AND TREATED PER 51-10-02, 51-24-11.SDR AU970588Tube · damaged(AUS) TWO STRUCTURAL TUBES DAMAGED - PERSONNEL/MAINTENANCE ERRORSDR AALA970913Structure · corrodedTUL - STRUCTURE CORRODED IN AREA FWD OF BATTERY, LIGHT CORROSION ON SKIN. INSTALLED NEW LONGERONS 52, 51L, 51R. NEW SUPPORT FOR BATTERY BOX. SPLICED FRAME BETWEEN 48L AND 48R. REMOVED LIGHT CORROSION ON SKIN. TST: 81,156 HRS. CYCLES, 24,004. (X)SDR 97UAL900350Structure · damagedLWR FUSELAGE WAS DAMAGED BY AN A/C TUG. A/C HAD SKIN, STR AND FRAME DAMAGE TO FUSE. LWR LOBE (BELLY) STA 840 TO 1015 BTW STR 23 LT AND 26 RT FUSE. BELLY SKIN TORN STA 840/STR 26 RT FWD TO STA 920/STR 24 LT. STR 26R, 27R, 27L, 26L, 25L, 24L, 23L SEVERED. FSDR HAIHEEA9765Structure · crackedFOUND NUMEROUS CRACKS IN DOOR POSTS, WINDOW FRAME AND ROOF AS SHOWN IN FIG. 1 ATTACHED DRAWING. SANDED DAMAGED AREAS. LAID FIBERGLASS REPAIRS USING 510N RESIN OVER CRACKED AREAS. REPAIRED CABIN STRUCTURE AS PER 8110-NO. 89-047 DATED 9-13-89.SDR AALA970871Structure · corrodedAFW - FLOOR SUPPORT STRUCTURE SEC 41 HAS CORROSION REMOVAL ON UPPER SURFACE. MATERIAL REMAINING BEYOND SRM LIMITS REF E 58 NR'S 1697045, 1697051, 1697057, 1697058, 1697139. TST: 15,561.43 HOURS. CYCLES: 5,712. (X)SDR CA970505031Fuselage · lightning strike(CAN) LIGHTNING STRIKE RH SIDE OF FUSELAGE NOSE SECTION. NOSE AREA INSPECTED AS PER A.M.M. 05-51-18. NO DAMAGE FOUND.SDR AALA970797Structure · corrodedAFW - FLOOR STRUCTURE AT STATION 403 RBL 60 HAD CORROSION BLENDED BEYOND SRM LIMITS E58 NR 1692360. REPAIRED PER MRB NR 757-1142. (M)SDR AALA970802Structure · corrodedAFW - FLOOR STRUTURE AT STATION 303 RBL 40 HAD CORROSION BLENDED BEYOND SRM LIMITS E58 NR 1692351. REPAIRED PER MRB NR 757-1137. (M)SDR AALA970798Structure · corrodedAFW - FLOOR STRUCTURE AT STATION 365 RBL 23 HAD CORROSION BLENDED BEYOND SRM LIMITS E58 NR 1692358. REPAIRED PER MRB NR 757-1141. (M)SDR AALA970800Structure · corrodedAFW - FLOOR STRUCTURE AT STATION 330 TO 332.5 RBL 3 HAD CORROSION BLENDED BEYOND SRM LIMITS E58 NR 1692355. REPAIRED PER MRB NR 757-1139. (M)SDR 97ZZZX1923Structure · corrodedREPORT RECEIVED WHICH INDICATES THE EXTENSIVE USE OF FIRE RETARDANT CHEMICALS (BROMIDES AND SALINES) ON ACFT FABRICS, IS A MAJOR CAUSE OF STRUCTURAL CORROSION.SDR AALA970627Structure · corrodedAFW - FLOOR STRUCTURE AT STATION 404 RBL 55 HAD CORROSION BLENDED BEYOND SRM LIMITS E58 NR 1668873. REPAIRED PER MRB NR 757-1100. (M)SDR AALA970623Structure · corrodedAFW - FLOOR STRUCTURE AT STATION 393 RBL 60 HAD CORROSION BLENDED BEYOND SRM LIMITS, E58 NR 1668875. REPAIRED PER MRB NR 757-1102. (M)SDR AALA970622Structure · corrodedAFW - FLOOR STRUCTURE AT STATION 373 RBL 60 HAD CORROSION BLENDED BEYOND SRM LIMITS, E58 NR 1668876. REPAIRED PER MRB NR 757-1103. (M)SDR AALA970618Structure · corrodedAFW - FLOOR STRUCTURE AT STATION 332 RBL 3 HAD CORROSION BLENDED BEYOND SRM LIMITS E58 NR 1668880. REPAIRED PER MRB NR 757-1105. (M)SDR AALA970611Structure · corrodedAFW - FLOOR STRUCTURE AT STATION 407 RBL 60 HAD CORROSION BLENDED BEYOND SRM LIMITS E58 NR 1668872. REPAIRED PER MRB NR 757-1109. (M)SDR AU970279Structure · corroded(AUS) AIRCRAFT STRUCTURE CONTAINED EXTENSIVE CORROSION:-1. MAINPLANES HAD SEALING MATERIAL MISSING FROM LOWER SPAN LAMINATES BETWEEN FUSELAGE AND ENGINE NACELLE ALLOWING MOISTURE INGRESS AND CORROSION 2. WING SKINS PEELED BACK TO REVEAL EXFOLIATION CORROSION SDR CA970312006Lintel · chafed(CAN) DOOR CHAFING ON THE UPPER DOOR LINTEL CAUSING LINTEL TO WEAR THIN. LINTEL REPLACED AND DOOR ADJUSTED.SDR AU970455Fuselage · corroded(AUS) FUSELAGE CONTAINED LEVEL 2 CORROSION - FOUND DURING INSPECTIONSDR AU970454Fuselage · corroded(AUS) LEVEL 2 CORROSION FOUND DURING INSPECTIONSDR AU970453Fuselage · corroded(AUS) FUSELAGE CONTAINED LEVEL 2 CORROSION. FOUND DURING INSPECTIONSDR AU970406Structure · corroded(AUS) AIRCRAFT STRUCTURE CONTAINED LARGE AMOUNTS OF CORROSION. FOUND DURING UNSCHEDULED INSPECTION IAW AD/BN-2/53. SEE MDR 97/0380 FOR ADDITIONAL INFORMATIONSDR CA970311087Support · corroded(CAN) EXTENSIVE CORROSION OF SUPPORT.SDR AALA970234Structure · corrodedAFW - FLOOR STRUCTURE AT STA 407 TO STA 418, RBL 45 HAD CORROSION BLENDED BEYOND SRM. E58 NR 1803716. REPAIRED PER MRB NR 757-1057. TST: 14,920.38 HOURS. CYCLES: 5,447. (X)SDR AWXA9700015Threshold · corrodedDURING ROUTINE MAINTENANCE CHECK, FOUND RT THRESHOLD CHORD CORRODED AT STA 294.5. INSTALLED CHORD SUPPORT STIFFENERS AND STRAPS IAW B737 DRAWING 65-45875 AND SRM 51-40-02.SDR AWXA9700013Structure · corrodedDURING ROUTINE MAINTENANCE CHECK, FOUND RT AFT SERVICE DOOR FLOOR STRUCTURE STA 947 TO 967 CORRODED. REMOVED AND FABRICATED NEW SUPPORT AND FILLER IAW BOEING DRAWING 65-46812 AND INSTALLED PER SRM 51-40-02.SDR 98ZZZX312Frame · corrodedCORROSION AT TUBING CLUSTER 27 INCHES AFT OF FIREWALL ON LOWER LONGERON. GUSSETS SUPPORTING THE VERTICAL MEMBER HAD ALLOWED DEBRIS AND MOISTURE TO COLLECT ON LONGERON. LONGERON WAS PERFORATED BY RUST FORE AND AFT OF VERTICAL MEMBER ON RT SIDE. A SMALLER PERSDR CALA9700053Structure · damagedINSPECTION FOUND SKIN PUSHED IN AND SHEAR TIES BROKEN DUE TO GROUND DAMAGE AT BS 420, LONGERONS 27L TO 27R. THE AREA WAS REPAIRED IAW SRM 53-00-07.SDR AALA970125Structure · corrodedAFW - FLOOR STRUCTURE AT STATION 300 RBL 39 HAD CORROSION BLENDED BEYOND SRM LIMITS, REF E58 1814624. REPAIRED PER MRB NR 757-1049. (M)SDR AALA970124Structure · corrodedAFW - FLOOR STRUCTURE AT STATION 405 RBL 59 HAD CORROSION BLENDED BEYOND SRM LIMITS, REF E58 1814605, ITEM NR 1. REPAIRED PER MRB NR 757-1048. (M)SDR 97ZZZX832Tube · crackedFUSELAGE STEEL TUBE CRACKED .50 INCH FROM AFT WELD LOCATION. CRACK SEPARATION WAS APPROXIMATELY .25 INCH WIDE THROUGH THE TUBE. CRACK WAS DETECTED DURING AN ANNUAL INSPECTION. TUBE ALSO HAD A NOTICEABLE DOWNWARD BEND MID-POINT OF THE TUBE. THE BEND IS APPROSDR GTIA9700093Structure · corrodedMHV - FWD CARGO COMPT FROM FS 598 TO FS 550 LONGERONS 28 LT, 29 LT, 30 CENTER, AND 29 RT, ATTACH ANGLES, SPLICE PLATE, AND INTERIOR SKIN CORRODED. REMOVED SURFACE CORROSION (IN LIMITS). ALODINE AND PRIMED AREA IAW SRM 51-10-3. LONGERON AND SPLICE INSULATIONSDR GTIA9700075Structure · damagedMHV - FLOOR BOARD, WINGS BOX AREA, UPPER AREA HAS SEVERAL CRACKS AND TORN OUT HOLES. HAT CHANNELS HAVE CRACKS AT THE FORWARD ENDS, INSULATION TAPE IS LOOSE. FLOOR SKIN DAMAGED BEYOND REPAIR. REMOVED FLOORBOARD PANEL SKIN AND FABRICATED NEW PANEL SKIN. REMOSDR GTIA9700038Structure · damagedMHV - FLOORBOARD 27, 3 HAT SECTIONS CRACKED AT ONE END AND 2 SECTIONS CRACKED AT OTHER END. INSULATION BATTING MISSING ON ONE END, FALLING APART ON THE OTHER, AND UNBONDED AND FALLING APART AT A FEW AREAS IN THE CENTER SECTION. REMOVED 5 CRACKED HAT SECTIONSSDR 97ZZZX6231Structure · corrodedDURING SCHEDULED C/W BAG COMPT BEHIND PANEL INSP PER CMP CODE 532045, CORROSION WAS NOTED WHERE STR 2L PASSED THROUGH BULKHEAD 539.75. INVESTIGATION REVEALED THAT POTABLE WATER HOSE ASSY LOCATED ABOVE HEADLINER IN LAVATORY AREA HAD OVERHEATED WHICH LED TO CONSDR 97ZZZX1783Structure · corrodedDURING A SCHEDULED INSPECTION AT AERO CORP, CORROSION FOUND AROUND NUTPLATES ON LT AND RT KIDNEY PANELS (AFT OF AUXILIARY FUEL TANK). REMOVED STR'S 30, 29R, 29L, 28R, 28L, 27R, 27L, 26R, 26L, INTERCOSTALS 26L AND 27L, AND 26R AND 27R, FRAMES 580, 585, 600, ANSDR CALA9601604Structure · damagedA LAV SERVICE TRUCK STRUCK THE FUSELAGE 29 INCHES BELOW FORWARD EDGE OF SUGAR SCOOP RESULTING IN DAMAGE TO SKIN AND LONGERON. THE DAMAGED AREA WAS APPROXIMATELY 4 INCHES X 4 INCHES. A CLASS III REPAIR WAS INSTALLED IAW SRM 53-04, FIGURE 12B, SHEET 18. A DISDR ARWA961002Structure · corrodedDURING C-CHECK, FOUND LEVEL 2 CORROSION IN LT WHEEL WELL BETWEEN L33L AND L34L FS STA 1090. REPAIRED PLATING IAW FAA 8110 FORM APPROVED DRAWING CF-N661AV 02/90 DATED 09-09-96. TREATED AND INSTALLED REPAIR PARTS IAW DC-8 SRM 51-1-8, 51-1-17, 51-1-21.SDR 96UAL900833Structure · damagedTHE LOWER SIDE OF THE FUSELAGE BETWEEN BODY STATIONS 727 AND 787 FROM STRINGER 25 LEFT TO 25 RIGHT WAS DAMAGED WHEN A TOW TRACTOR IMPACTED THE AIRCRAFT. DAMAGE CONSISTS OF TORN SKIN, SEVERED STRINGERS, DAMAGED FRAMES AND MISCELLANEOUS DAMAGE TO INTERNAL BRACKSDR 96ZZZX5429Truss Clip · weld crackedA CRACKED WELD WAS DISCOVERED ON THE PORT SIDE UPPER WELD JOINT OF THE FORWARD TRUSS AND A CRACKED WELD ON THE LOWER STARBOARD REAR TRUSS CLIP. SUBMITTER STATED THIS AIRCRAFT IS OUT-OF-SERVICE AND HAS BEEN FOR APPROXIMATELY 15 YEARS. OWNER IS INTERESTED IN RSDR 96ZZZX5428Truss · weld crackedA CRACKED WELD WAS DISCOVERED ON THE PORT SIDE UPPER WELD JOINT OF THE FORWARD TRUSS AND A CRACKED WELD ON THE LOWER STARBOARD REAR TRUSS CLIP. SUBMITTER STATED THIS AIRCRAFT IS OUT-OF-SERVICE AND HAS BEEN FOR APPROXIMATELY 15 YEARS. OWNER IS INTERESTED IN R
Back to JASC 5310