JASC 5330
Service difficulty reports · 79,365
Reports filed under 5330 · Fuselage Main, Plate/Skin, 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 = '5330' 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 = '5330' 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 QXEA2014012100045Skin · corrodedLT FUSELAGE SKIN, BS 321 - 337, LOCATED 18 CORRODED RIVETS ON STR 24P. REMOVED 18 RIVETS FROM LT FUSELAGE SKIN, FSX321 TO X337 STR24P IAW SRM 51-42-05. INSTALLED 18 RIVETS INTO LT FUSELAGE SKIN FSX321 TO X337, STR 24P IAW SRM 51-42-05. RESTORED FINISH IAW SSDR SWAA2014020324803Skin Splice · crackedSKIN CHORD SPLICE CRACKED AT BS 540, BETWEEN STRINGER 22L TO STRINGER 23L. REPAIRED SPLICE IAW EA.SDR SWAA2014020324802Skin Splice · crackedSKIN CHORD SPLICE CRACKED AT BS 540, BETWEEN STRINGER 22R TO STRINGER 23R. REPAIRED SPLICE IAW EA.SDR IPXA2014020381750Skin · crackedINSPECTION C, BS 400, S44-45R RT NLG WW AFT CORNER SKIN PANEL FOUND CRACKED RUNNING FWD & AFT APPROXIMATELY .1875" IN LENGTH. REPAIRED IAW RI-53-11-10439, REV A AND EO B747-5330-53290.SDR SWAA2014012224425Skin · crackedSKIN CRACKED AT BS 727B+12 STRINGER 10R. REPAIRED SKIN IAW EA.SDR SWAA2014012024306Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 425 TO BS 428 STRINGER 26L. REPAIRED SKIN IAW SRM.SDR IPXA2014020381751Skin · crackedINSPECTION C, BS 400, S44-45R NLG WW AFT CORNER SKIN PANEL FOUND CRACKED AT SECOND LAYER COUNTED FROM SKIN SURFACE RUNNING FWD & AFT THROUGH THICKNESS. SPLICE PLATE FABRICATED AND INSTALLED IAW RI-53-11-10439, REV A AND EO B747-5330-39256-C, APPENDIX D.SDR IPXA2014020381747Skin · crackedINSPECTION C, BS 400 LT SIDE NOSE WHEEL WELL AFT CORNER FOUND CRACKED AT SKIN LAYER. REPAIRED AT BETWEEN BS 380 - 420, S43-47L IAW NR RI-53-11-10442 REV A AND EO-5330-53287-A.SDR FDEA201401180136Skin · corrodedRIGHT SIDE OF FUSELAGE, STRINGER 26R LAP SEAM HAS FASTENERS PULLING THRU SKIN LAP SEAM AT BS 1670. EVIDENCE OF CORROSION. CUT OUT DAMAGE AT RT SIDE AT FUSELAGE, STRINGER 26R LAP SEAM BS 1670. FABRICATED DOUBLER & FILLER & INSTALLED IAW EA F-5330-T0 305495 SDR ASAA2014011812514Doubler · corrodedRIGHT FUSELAGE FWD OF BS 1088 AT TAILSKID DOUBLER HAS CORROSION. R & R TAILSKID DOUBLER IAW SRM 51-40-02-0G-0.SDR NACA201401180001Skin · crackedCRACK IN FUSELAGE SKIN AT BS 530, S16R. INSTALLED REPAIR IAW SRM 5-30-3, FIG 48, DETAIL VII.SDR CALA2014012090197Skin · corrodedFUSELAGE EXTERIOR SKIN WAS FOUND CORRODED ON INNER SURFACE BETWEEN STATION 480 - 500 & STRINGER 46R TO 47R, IN THE AREA COMMON TO THE TCAS ANTENNA. REPAIR WAS ACCOMPLISHED.SDR CALA2014012090193Skin · dentedEVALUATED FUSE SKIN BETWEEN BS 320 - 478 LT BETWEEN STRINGER 21L TO 23L. FOUND TWO DENTS AT BS 471 & STRINGER 23L OUT OF LIMITS IAW SRM 53-00-01. DENT CROSSES STRINGER 23L, NO OTHER DEFECTS NOTED. CUT OUT DAMAGED AREA OF SKIN AT BS 471 & STRINGER 23L. FABRSDR CALA2014012090192Skin · dentedRT FUSELAGE SKIN DENTED AT STATION 654+66, STRINGER 29R. EVALUATED DENT & FOUND TO BE WITHIN LIMITS OF SRM 53-00-01. DENT WIDTH 2.65, DEPTH.054 & A OVER Y RATIO 49. DENT IS SMOOTH & CRACK FREE, OK TO ARCHIVE. ^18JAN GSO RPR RE-EVALUATED DENT AT S CHECK & FOSDR CALA2014012000090Skin · dentedDENT AFT OF AFT CARGO DOOR BS 1581 BETWEEN STRINGER 20 - STRINGER 21 RT. REPAIRED DENT IN FUSELAGE SKIN AFT OF AFT CARGO DOOR BS 1581 BETWEEN STRINGER 20R - STRINGER 21R IAW B757-300 SRM 53-00-01 REPAIR 2 FIG 201.SDR WVER2014011851501Skin · dentedFUSELAGE SKIN DENTED AT BS 1029-1031 BETWEEN STRINGERS 19-20L, BELOW THE AFT CARGO DOOR. REPAIRED IAW REO 670-53-61-1028, REV.SDR DALA14015660961Window Frame · scratchedNON-ROUTINE CHECK, SCRATCHES FOUND ON WINDOW FRAME BETWEEN BS 769-788, RT AFT SIDE. REWORKED, FOUND WITHIN OF LIMITS IAW ON DAMAGE "B", ER/A 521192-14, REV ORIGINAL.SDR DALA14004886817Skin · damagedFOUND LIGHTNING STRIKE DAMAGE ABOVE 2L DOOR, BS 700. REPAIRED IAW ERA 522482-14AD, REV A.SDR SIMA20140117003Skin · crackedCRACK DAMAGE FOUND ON FWD FUSELAGE SKIN II AT UPPER PORTION OF WINDSHIELD LATERAL POST BETWEEN PILOT WINDOW & DV WINDOW. PERFORMED TEMPORARY STRUCTURAL REPAIR IAW ERS-EM-53MR-187 PART A.SDR DALA14015640961Skin · crackedNON-ROUTINE CHECK, CRACK ON FUSELAGE SKIN BS 375 AND LONGERON 20R FWD UPPER CORNER OF FWD CARGO BAY DOOR CUT OUT. REPAIRED IAW SRM 53-05, FIG 105.SDR DALA14015620961Skin · damagedNON ROUTINE CHECK, REPORTED LIGHTNING STRIKES ON WINDOW BELT ON FWD LOWER CORNER BETWEEN BS 788 AND 807 LT SIDE. REPAIRED IAW ER/A 521186-14, REV ORIGINAL.SDR MASA2014021030927Skin · corrodedFUSELAGE HAS SMALL AREA OF CORROSION. CORROSION REMOVED.SDR MASA2014021030926Skin · corrodedFUSELAGE SKIN HAS A SMALL AREA OF CORROSION AT DRAIN HOLE. COMPLIED WITH CORROSION REMOVAL.SDR MASA2014021030925Skin · corrodedFUSELAGE SKIN HAS A SMALL AREA OF CORROSION. CORROSION REMOVED.SDR SWAA2014012424520Skin · crackedFUSELAGE SKIN CRACKED AT BS 540, STRINGER 22R. REPAIRED SKIN IAW SWA EA.SDR SWIA201436037Skin · dentedDENT FOUND ON LT NOSE FWD OF PITOT TUBE. FLT 6480 REPLACED UPPER LT HAND SKIN & STRINGER 14 IAW SRM, PN1 CC670-33105-1 & PN2 CC670-33145-1.SDR DALA14004260199Skin · gougedAFT CARGO BAY AFT SIDE OF DOOR, 18 INCHES BELOW TOP CORNER, 10 INCHES AFT OF AFT SIDE OF DOOR, GOUGED. REMOVED DAMAGE IAW SRM 53-00-01.SDR DALA14004150921Skin · canningFUSELAGE SKIN OIL CANNING. BS 560-579, LONGERON 16-18R. HFEC IAW SPM 06-10-01.001, NO CRACKS NOTED. REPAIRES IAW ER/A 5622329-14, REV O COMPLETED & MATCHING PRI.SDR AALA20140116013Skin · damagedLIGHTNING STRIKE DAMAGE AT STATION 447.75 & LONGERON 22 RT. INSTALLED DOUBLER IAW SRM 53-04-02.SDR AALA20140116012Skin · damagedLIGHTNING STRIKE DAMAGE AT STATION 331 APPROXIMATELY 2 INCHES ABOVE STRINGER 22 RT. INSTALLED DOUBLER IAW SRM 53-04-02 FIGURE 2.SDR SWAA2014021125036Skin · crackedFUSELAGE SKIN CRACKED AT BS 540, STRINGER 22R. REPAIRED SKIN IAW EA.SDR GLBA2014011600371Skin · dentedDURING A SCHEDULED INSPECTION, MX FOUND THE LT AFT SKIN DENTED AT BS 446 BETWEEN STRINGERS 11-12L. REPAIREDS IAW EO 14-1900-53-005.SDR 8EKA20140121001Skin · dentedFOUND DENT IN UPPER SKIN OF FUSELAGE DURING INSPECTION, BETWEEN FRAMES 17 & 18. REPAIRED WITH PATCH IAW SRM.SDR DALA14004299258Skin · crackedFUSELAGE SKIN CRACKED AT BS 1475, 3 INCHES RT OF VERTICAL STABILIZER/TAIL. CUTOUT DAMAGE, INSTALLED DOUBLER, TRIPLER AND LONGERON SPLICE IAW PRI 522196, REV O AND FINAL ERA 5221914, REV O.SDR GTIA201401151113Skin · dentedBIRD STRIKE RT FUSELAGE 3 INCHES BELOW RVSM AREA. REPAIRED IAW EO 5310-1401.SDR SWAA2014022625546Skin · damagedFUSELAGE SKIN DAMAGED BETWEEN BS 887 TO BS 976, BETWEEN STRINGER 25L TO STRINGER 24R. R & R SKIN IAW DRAWING & SRM.SDR SWAA2014022625545Skin · damagedFUSELAGE SKIN DAMAGED BETWEEN BS 840 TO BS 887, BETWEEN STRINGER 25R TO STRINGER 25L. REPAIRED SKIN IAW ER & EA.SDR SWAA2014012924664Skin · crackedNR 1 LT WINDOW SILL POINT D SPLICE FITTING FASTENER HOLE COMMON TO SKIN FWD FASTENER ROW CTR HOLE 3.5 INCHES BELOW WINDOW CUTOUT CRACKED. REPAIRED SKIN IAW SRM & DRAWING.SDR SWAA2014012124368Forging · crackedRT BS 400+10 UPPER FWD CORNER OF WINDOW FORGING CRACKED IN HOLE NR 7. R & R FORGING IAW BAC DRAWING.SDR SWAA2014012124367Forging · crackedRT BS 440+10 UPPER FWD CORNER OF WINDOW FORGING CRACKED IN HOLE NR 7. R & R FORGING IAW BAC DRAWING.SDR SWAA2014012124380Skin · crackedFLIGHT DECK LT NR 3 WINDOW FRAME WINDOW PANE ATTACH FASTENER HOLES SKIN CUTOUT CRACKED. REPAIRED SKIN IAW SRM.SDR CALA2014011490142Skin · crackedCRACK REVEALED ON SKIN UNDERNEATH LOWER DRAG SPLICE FITTING ANGLE. FUSELAGE CRACKED SKIN BETWEEN BS 950 - 980 & STRINGER 37R TO 39R. REPAIRED IAW SRM 53-20-01,RPR 2,FIG 201,TABLE III. CAT B REPAIR, SUBSEQUENT INSPECTION REQUIRED IAW SRM 53-20-01, RPR 2, FIGSDR IPXA2014021781948Skin · dentedFUSELAGE TAIL SECTION SKIN FWD OF TAIL BALL FRAME 85 BETWEEN S44L AND 44R HAS MULTIPLE DENTS. REPAIRED IAW SRM 53-10-12, FIG 210, SHEET 1.SDR SWAA2014020324758Skin · crackedFUSELAGE SKIN CRACKED AT BS 540, STRINGER 22R. REPAIRED SKIN IAW EA.SDR IPXA2014020381755Skin · crackedINSPECTION C, RT SIDE OF NLG WHEEL WELL AFT CORNER SKIN PANEL CRACKED. REPAIRED IAW RI-53-11- 10439, REV A & EO B747-5330-53290-A. MAJOR REPAIR.SDR IPXA2014020381741Skin · crackedINSPECTION C, BS 400, NOSE WHEEL WELL LT AFT CORNER SKIN PANEL CRACKED. REPAIRED BETWEEN BS 380-420 S43-47L IAW RI-53-11-10442, REV A AND EO-5330-53287-A. MAJOR REPAIR.SDR SWAA2014012824641Skin · crackedLT BS 767+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED BETWEEN HOLES 4 & 5. REPAIRED SKIN IAW SWA EA.SDR SWAA2014012424494Skin · crackedLT BS 887+10 LOWER FWD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 7. REPAIRED SKIN IAW TC.SDR SWAA2014012424493Skin · crackedRT BS 787+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE NR 7. REPAIRED SKIN IAW TC.SDR SWAA2014012324475Skin · crackedLT BS 867+10 LOWER FWD WINDOW SKIN CUTOUT CRACKED BETWEEN HOLES 7 TO 8. REPAIRED SKIN IAW SWA EA.
Back to JASC 5330