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 SWAA2012082406967Skin · crackedSKIN CRACKED AT BS 727E+5, STR 10L. REPAIRED SKIN PER EA.SDR FDEA201208213095Skin · dentedEXTERNAL FUSELAGE SKIN STA 1400-1420 BETWEEN S-25L TO S-26L DENTED. FOUND OUT OF LIMITS IAW SRM-53-00-01, FIG 101, DET III, REPAIRED DAMAGE IAW SRM-53-00-01, FIG 201 REPAIR NR 16, PG 201-206. CATEGORY"B", MAJOR REPAIR.SDR DALA12005725521Skin · damagedFOA 2 INCH HOLE IN FUSELAGE BELOW AND AFT OF L4 DOOR THRESHOLD OPENED AFT CARGO. INSTALLED REPAIR DOUBLER PER ERA 506410-14 REV ORIG PRI INSTRUCTIONS MATCH ERA506410-14 REV ORIG REPAIR GOOD PER ERA CLOSED AFT CARGO BIN AFT BULKHEAD WALL COMPLETED ALL STEPS ONSDR FDEA201208213093Skin · crackedFUSELAGE SKIN CRACKED AT FWD LT SIDE OF NOSE GEAR W/W CUTOUT. COMPLIED WITH EA 8-5350-157364 & REPAIRED AREA USING SRM 53-50-00.SDR KCSA201208211170Skin · corrodedEXTERIOR FUSELAGE AT LAP SEAM 4 FROM BS 1170 TO 1188 AREAS OF LIGHT CORROSION.SDR KCSA201208211169Skin · corrodedEXTERIOR FUSELAGE AT LAP SEAM 4 FROM BS 1226.5 TO 1228.5 AREAS OF LIGHT CORROSION.SDR KCSA201208211168Skin · corrodedEXTERIOR FUSELAGE AT LAP SEAM 4 FROM BS 1252.5 TO 1254 AREAS OF LIGHT CORROSION.SDR KCSA201208211167Skin · corrodedEXTERIOR FUSELAGE AT LAP SEAM 4 FROM BS 1350 TO 1357 AREAS OF LIGHT CORROSION.SDR KCSA201208211166Skin · corrodedEXTERIOR FUSELAGE AT LAP SEAM 4 FROM BS 1465 TO 1480 AREAS OF CORROSION AT LAP SEAM.SDR FDEA201208213092Skin · crackedFUSELAGE SKIN CRACKED AT FWD RT SIDE OF NOSE GEAR W/W CUTOUT REPAIRED USING SRM 53-50-00 AS A REFERENCE.SDR DALA1246810921Skin · damagedDURING HMV, FOUND LIGHTNING STRIKE ON WINDOW BELT AT LOWER FWD CORNER BTW STA Y=788-807 AT FUSELAGE SKIN LT. BLENDED DAMAGE AREA AND INSTALL DOUBLER IAW ER/A 504382-14 REV ORIG.SDR SWAA2012082707001Skin · crackedSKIN CRACKED AT BS 913, STR 22L. REPAIRED SKIN PER SRM.SDR SWAA2012082707000Skin · crackedSKIN CRACKED AT BS 500B+18, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA2012082706999Skin · crackedSKIN CRACKED AT BS 939, STR 21R. REPAIRED SKIN PER SRM.SDR AALA20120827001Skin · dentedDENT AT LEFT STATION 275 BETWEEN STRINGERS 23 AND 24 LEFT. INSTALLED INTERNAL DOUBLER PER SRM 53-04-02 FIGURE 02 SHEET 36.SDR AALA20120820015Skin · crackedCRACK IN FUSELAGE SKIN AT LIGHTNING STRIKE STATION 500 E + 15 STRINGER 2 LEFT. INSTALLED DOUBLER REPAIR PER SRM 53-00-01-2R3.SDR DALA1246730921Skin · corrodedDURING HMV, CORROSION WAS FOUND ON OUTER FUSELAGE SKIN UNDERNEATH LOWER TCAS ANTENNA PLATE. CUT OUT DAMAGED FUSELAGE SKIN AND INSTALL FILLER DOUBLER PLATE IAW ER/A 504387-14 REV ORIG.SDR 2012FA0000580Skin · crackedA 1 INCH PRESSURE SKIN CRACK WAS FOUND BETWEEN THE LOWER BEACON AND THE NR 2 VHF ANTENNA. LOCATED AT FS 409+32, STR 26L TO STR 26R. REPAIRED WITH REO 601R-53-31-759.SDR 29GA2012082293753Skin · gougedDURING SCHEDULED ROUTINE INSPECTION DISCOVERED AIRSTAIR DOOR FRAME INNER SKIN 2.0 INCH GOUGE DAMAGE AT FS 150 STRINGER 8. REMOVED DAMAGED SECTION OF SKIN AND INSTALLED COVER PATCH REPAIR.SDR SWAA2012082306916Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 461 TO BS 462, STR 15R. REPAIRED SKIN REPAIRED IAW EA.SDR WX0A071282Skin · damagedUPPER FUSELAGE LIGHTING STRIKE STA 1276 BETWEEN LONGERON 2L & 3L. REMOVED DAMAGE AREA, FABRICATED REPAIR PARTS AND INSTALLED IAW MD80 SRM 53-04-2 FIG 2.SDR ASOA20120821133Skin · damagedDENT BETWEEN FRM 15 & 16 AND BETWEEN STRINGER 17L & 18L. REPAIRED DAMAGE, INSTALLED PATCH AND REPLACED SHEAR CLIP IAW ETD2012-145-011674 REV B. ACFT RELEASED AND RETURNED TO SERVICE.SDR DALA1246540921Skin · corrodedDURING HMV, FOUND CORROSION ON FUSELAGE SKIN AT FILLET PANEL SETTLEMENT AREA FROM Y=761-766 BTW LONGERON 27R TO 30. REMOVED PREVIOUS REPAIR DOUBLER AND CORROSION AND INSTALLED REPAIR DOUBLER IAW ER/A 504390-14 REV ORIG.SDR KCSA201208171162Skin · corrodedSPOTS OF POSSIBLE CORROSION ON EXTERNAL FUSELAGE LAP SEAM AT BS 900 - 950 STR 6L.SDR KCSA201208171161Skin · corrodedSPOTS OF LIGHT CORROSION ON EXTERNAL FUSELAGE LAP SEAM AT BS 980 - 1000 STR 12L.SDR KCSA201208171160Skin · corrodedSPOTS OF LIGHT CORROSION ON EXTERNAL FUSELAGE LAP SEAM AT BS 810 - 840 STR 6L.SDR KCSA201208171159Skin · corrodedSPOTS OF LIGHT CORROSION ON EXTERNAL FUSELAGE LAP SEAM AT BS 660 - 690 STR 6L.SDR KCSA201208171158Skin · corrodedSPOTS OF LIGHT CORROSION ON EXTERNAL FUSELAGE LAP SEAM AT BS 740 - 780 STR 6L.SDR KCSA201208171157Skin · corrodedSPOTS OF CORROSION ON EXTERNAL FUSELAGE LAP SEAM AT BS 610 - 650 STR 6L.SDR KCSA201208171155Skin · corrodedEXTERIOR FUSELAGE AT LAP SEAM 4 FROM BS 1429 TO 1447 FOUND AREAS OF CORROSION.SDR DALA1248506700Skin · dentedDENT ON FUSELAGE SKIN AT APPROX BS 550 AT S15L. INSTALLED DOUBLER REPAIR AND FILLER REPAIR IAW ERA 505971-14, REV ORIGINAL.SDR FDEA201208173054Frame · misrepairedFRAME BS 535, L23L MISREPAIRED. REPAIRED IAW SRM 53-30-00 FIGURE 13 VOLUME I REVISION 99 AND E.A. 8-5310-159883. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100 REVISION 115.SDR FDEA201208173044Frame · misrepairedFRAME AT CABIN BS 535, L19R MISREPAIRED. REPAIRED AS PER SRM 53- 30-00 FIGURE 14 VOLUME 1 REVISION 99. REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-100 REVISION 115.SDR UALA2012082004637Skin · dentedFOUND DENT IN SKIN PROTRUDING FROM FWD CARGO BAY OUTWARD AT BS 498. DENT IS BETWEEN STRINGERS . FOUND OUT OF LIMITS PER SRM DETAIL III. CUT OUT DENTED SKIN FOR REPAIR PER MM. ACCOMPLISHED HFEC INSPECTION OF DAMAGE CUTOUT. NO CRACK FOUND. MANUFACTURED DOSDR SWAA2012083007226Skin · crackedFUSELAGE SKIN CRACKED AT BS 831, STR 17L. REPAIRED SKIN IAW SRM.SDR SWAA2012083007225Skin · crackedFUSELAGE SKIN CRACKED AT BS 810, STR 19L. REPAIRED SKIN IAW SRM.SDR FDEA201208173046Skin · damagedFUSELAGE CROWN SKIN FOUND LIGHTNING STRIKE UNDER VHF ANTENNA BETWEEN FR 20-21. REPAIRED EA 6-5330-149057.SDR UALA2012082004625Skin · dentedSKIN DENTED BS 500, BETWEEN S13 - 14L. FOUND OUT OF SRM LIMITS. CUT-OUT DAMAGE AND ACCOMPLISHED HFEC OF CUT-OUT. ACCOMPLISHED INSURANCE CUT AND NDT OF OPEN HOLES COMMON TO REPAIR. NO CRACKS. FABRICATED AND INSTALLED EXTERNAL DOUBLER AND FILLERS REPAIR REF SDR UALA2012081704579Skin · dentedAFT LOWER FUSLAGE SKIN DENTED BELOW SPLICE BS 1572 S26L. DENT FOUND TO BE WITHIN LIMITS IAW SRM 53-00-01. HFEC ACCOMPLISHED AND NO CRACK INDICATIONS. OK FOR SERVICE. REMOVED DAMAGE. HFEC, NO CRACK. MFG AND INSTALLED REPAIR IAW SRM (REPAIR 12).SDR FDEA201208173062Skin · dentedRT FUSELAGE SKIN DENTED BETWEEN BS 278 TO 288, S16-17R. FOUND TO BE OUT OF LIMITS IAW SRM 53-00-01, FIG 101, DETAIL III. REPAIR DENT IAW SRM 53-00-01, FIG 201. REPAIR 7, CATEGORY B REPAIR.SDR KCSA201208171154Skin · corrodedBS 677 - 693 STRINGER 12R EXTERIOR SKIN HAS CORROSION.SDR KCSA201208171153Skin · corrodedBS 695 - 722 STRINGER 12R EXTERIOR SKIN HAS CORROSION.SDR KCSA201208171152Skin · corrodedBS 740 - 750 STRINGER 12R EXTERIOR SKIN HAS CORROSION.SDR KCSA201208171151Skin · corrodedEXTERIOR FUSELAGE LAP SEAM AT STRINGER 12R FROM BS 2180 TO 2360 FOUND AREAS OF CORROSION.SDR KCSA201208171150Skin · corrodedBS 778 - 795 STRINGER 12R EXTERIOR SKIN HAS CORROSION.SDR HNAA2012081700920Skin · corrodedPOSSIBLE CORROSION UNDER FORWARD RADIO ALTIMETER ANTENNA. UPON REMOVAL OF RADIO ALTIMETER ANTENNA AND PLATE. FOUND PITTING AND TOOLING GOUGE MARKS ON SKIN OF FUSELAGE. AFTER FURTHER INSPECTION. FOUND DEEPER SCRATCHES TO BE .003". FOUND TO BE WITHIN LIMITS SDR 2012F00167Skin · crackedDURING INSPECTION OF WINDOW BELT IAW AD 89-25-03, A 1" VERTICAL CRACK WAS DISCOVERED AT STA 447, ABOVE STRINGER L-15L.SDR CHQA20120816314Skin · dentedDURING HEAVY MAINTENANCE A PREVIOUSLY DAMAGED SECTION OF SKIN AFT OF THE PASSENGER DOOR NEAR FRAME 19-20 AND STRINGER 12L -13L WAS REPAIRED IN ACCORDANCE WITH ETD 2011-145-03683A CLOSING DMI 591816/3 AND 591816/1.SDR FDEA201208163020Skin · misrepairedFORWARD CARGO DOOR CUTOUT EXTERIOR SKIN BS 959, BETWEEN LONGERON 40 - 41 RT MISREPAIRED. CARRIED OUT REPAIR AS PER 53-50-00 FIG.26 VOL.I REV.99. REPAIR CLASSIFIED MAJOR AS PER GMM 6-2-100 REV.115SDR DALA12006169237Skin · corrodedRIGHT FUSELAGE AT BS 826, L28R SKIN HAS CORROSION. CUTOUT DAMAGED AREA PER SRM 53-31-03 VOL 1. FABRICATED DOUBLER, FILLER AND FOUR FINGER DOUBLERS. INSTALLED FILLER, DOUBLER REPAIR AND FOUR FINGER DOUBLERS PER SRM 51-30-02 AND 51-30-05.
Back to JASC 5330