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 SWAA096668Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND SKIN CRACKED AT BS 372, STR 26R. REPAIRED SKIN PER SRM.SDR SWAA096667Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND SKIN CRACKED AT BS 802, STR 22L. REPAIRED SKIN PER SRM.SDR CA091020001Splice · missing(CAN) DURING INSP OF FUSELAGE BELLY SKINS JUST AFT OF FWD WING SPAR, AN UNUSUAL SKIN BUTT SPLICE WAS FOUND. SPLICE HAS ONLY A SINGLE ROW OF RIVETS IN A PRESSURIZED VESSEL, WHERE THERE IS NORMALLY A DOUBLE ROW. FURTHER INVESTIGATION OF THE INSTALLATIOIN DWG FORSDR FDEA200910203736Skin · damagedTRIPLER EXT SKIN BS 620 STR 25L TWO DRILL STARTS. REMOVED FASTENERS AT EXT SKIN BS 620 STR 25L IAW SRM 51-30-2, CUT OUT DAMAGED AREA APPROX 1.05" X 4.6" IAW SRM 53-30-3 FIG 1A. TREATED & PRIMED REPAIR PARTS IAW SRM 51-10-2. INSTALLED PARTS IAW B727 SRM 51-30SDR FDEA200910203650Skin · damagedTRIPLER EXTERIOR SKIN BS 480 STR 25L HAS TWO DRILL STARTS CUT OUT DAMAGE 3 1/4 SQ IAW SRM REV H 53-30-3 FIG 1A. FABRICATED REPAIR DOUBLER AND STRUCTURAL FILLER IAW SRM 53-30-3 FIG 1A. INSTALLED REPAIR DOUBLER AND FILLER IAW SRM 53-30-3 FIG 1A.SDR FDEA200910203655Skin · damagedMAIN CARGO AREA BS 640 STR 3L & STR 4L, NO EDGE DISTANCE. CUT OUT DAMAGED AREA OF SKIN IAW SRM 53-30-3, CUT OUT DAMAGED AREA OF TEAR STRAP IAW SRM 53-30-4 FIG 9. FABRICATED TEAR STRAP REPAIR IAW SRM 53-30-4 & 51-30-5, FABRICATED EXTERNAL REPAIR DOUBLER. FASDR SWAA096656Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND SKIN CRACKED AT BS 952, STR 24R. REPAIRED SKIN PER SRM.SDR SWAA096651Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 505A, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA096648Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 787, STR 18L. REPAIRED SKIN PER SRM.SDR QXEA2009102100833Skin · corrodedFUSELAGE BELLY SKIN INTERNAL SPLICE PLATE HAS CORROSION AT AND AROUND RIVETS AT STA X115.5 OB OF STR 31R. REMOVED 1 EA RIVETS TO FOM AREA, REMOVED LIGHT SURFACE CORROSION SRM 51-21-00 PG 2 PARA A (2). MAX MATERIAL LOSS IS .001. FOUND WITHIN LIMITS. HFEC INSDR QXEA2009102100832Skin · corrodedFUSELAGE BELLY SKIN INTERNAL SPLICE PLATE HAS CORROSION AT AND AROUND RIVETS AT STA X114.75 AND X115.5 IB OF STR 31R. REMOVED 2 EA RIVETS TO FOM AREA, REMOVED LIGHT SURFACE CORROSION IAW SRM 51-21-00 PG 2 PARA A(2). HFEC INSPECTED BLENDED AREA FOR CRACKS IAWSDR SWAA096692Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 435, STR 16R. REPAIRED SKIN PER EA.SDR DL75E091651Skin · gougedACCOMPLISHED ERA-477621-14- REV 1 TO REPAIR A SKIN GOUGE AT S-14R LAP JOINT STA 660. LOWER SKIN WAS GOUGED AND HAD PITTING CORROSION.SDR SWAA096678Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 512D, STR 10L. REPAIRED SKIN PER EA.SDR COEA2009101908821Skin · dentedHEAVY CHECK COE: FOUND DENT IN SKIN OUT OF LIMITS .5 INCH FWD OF FR 12L 6 INCH BELOW STR 11L. EDDY CURRENT CONFIRMED CRACK .5 INCH FWD OF FR 12 6 INCH BELOW STR11L. FABRICATED AND INSTALLED DOUBLER REPAIR IAW SRM.SDR COEA2009101907821Skin · dentedHEAVY CHECK COE: MAJOR REPAIR, FOUND DENT IN SKIN OUT OF LIMITS 1.5 IN AFT OF FR 9L BETWEEN STR 20 AND 21L. VERIFIED CRACK FREE CONDITION. PERFORMED DOUBLER REPAIR IAW ATR72 SRM.SDR TIPR20090029Skin · misrepairedDURING MX CHECK, FUSELAGE SKIN ASSY PN 146T3220 WAS FOUND TO HAVE 2EA EXISTING EXT REPAIRS WITH NO PRIOR APPROVAL. THE REPAIRS, AS INSTALLED, DO MEET MINIMUM GENERAL SRM REQUIREMENTS BUT ARE WITHIN 22" OF ONE AN ANOTHER. NO SPECIFIC SRM ARE AVAILABLE FOR THISDR UIEA201000184Skin · damagedDURING JACKING OF DATUM AIRPLANE, MX DAMAGED THE FUSELAGE SKIN SECTION 48 - BS2594.5 AT S-26R (ABOVE THE TAIL JACK PAD). MEASURING 2.5 IN. D AND 0.437 IN DEPTH. THE DAMAGE IS LOCATED APPROX 3.5 IN FWD OF BS 2598 BUTT JOINT. "INTERIM REPAIR PERFORMED AS DESCRIBSDR USAA2009102992938Skin · crackedSAL - Q2 - MAJOR REPAIR - CRACK IN FUSELAGE SKIN AT FORWARD ENTRY DOOR LOWER HINGE CUTOUT BETWEEN BS 294.5 TO BS 312 & BETWEEN S12L TO S14L. REPAIRED FUSELAGE SKIN AT FORWARD ENTRY DOOR LOWER HINGE CUTOUT BETWEEN BS 294.5 TO BS 312 & BETWEEN S12L TO S14L IAW SDR CALA2009101900632Skin · damagedFUSELAGE SKIN DAMAGED ON BOTTOM EDGE OF AFT CARGO DOOR CUTOUT LOCATED UNDER THE OUTBOARD SILL PLATE. REPAIRED AFT CARGO DOOR CUTOUT LOWER FUSELAGE SKIN PER ECRA 5331-01471, REINSPECT PER PART 2 EC5331-01471AT INTERVALS NOT TO EXCEED 500 FLT CYCLES PERMANENT RSDR QXEA2009101900819Doubler · corrodedEVIDENCE OF CORROSION AT STR 27 DOUBLER AROUND COAX CABLE BETWEEN FS 295 AND FS 310. REMOVED DME ANTENNA AND RIVETS FOR ACCESS IAW AMM 20-70-00 AND SRM 51-42-06. BLENDED OUT CORROSION, PERFORMED LPI ON STR DOUBLER AROUND CABLE, NO CORROSION FOUND AT THIS TIMESDR DL757100192Skin · dentedLT FUSELAGE HAS 1 DENT AT FS 600 JUST BELOW S23L. INSTALLED DOUBLER REPAIR AT SAA SAT REF NON ROUTINE CARD 135790.SDR LR7A2009101900138Skin · crackedDURING SCHEDULED B-2 CHECK IAW JOB CARD HB5301, FOUND LT MAIN WHEEL WELL BOTTOM SKIN CRACKED AT FS607, WL138, LBL65. REPAIRED IAW SRM SMP583 FIG 51-140-12, NR 2043.SDR LR7A2009101900134Skin · crackedDURING SCHEDULED B-2 CHECK IAW JOB CARD HB5301, FOUND MAIN WHEEL WELL BELLY SKIN CRACKED AT FS577, WL138, LBL40. REPAIRED IAW SRM SMP583 FIG 51-140-12. NR 2024SDR LR7A2009101900133Skin · crackedDURING SCHEDULED B-2 CHECK IAW JOB CARD HB5301, FOUND MAIN WHEEL WELL BELLY SKIN CRACKED AT FS496, WL138, RBL40. REPAIRED IAW LOCKHEED SRM SMP583 FIG 51-140-12. NR 2023.SDR LR7A2009101900130Skin · warpedDURING SCHEDULED B-2 CHECK IAW JOB CARD HB5301, FOUND BELLY SKIN WARPED AND 4 RIVETS SHEARED AT FS 573, WL 135, LBL30. REPAIRED IAW SRM SMP583 FIG 51-140-12 NR 2007.SDR QXEA2009101600800Skin · chafedSKIN CHAFED UNDER BELLY FAIRINGS 196DR AND 195DL AFT OF FS 977.0 FROM FAIRING SPLICE ANGLE AT STR 27. REMOVED BLEED AIR DUCT FOM, IAW SRM 51-41-00-001-001-A01. REPAIRED CHAFE AREA IAW REO 670-53-00-223 REV A. PERFORMED LPI ON CUTOUTS NO CRACKS FOUND AT THISSDR AALA20091019TUL12Doubler · puncturedPUNCTURE IN DOUBLER SKIN AT HINGE CUTOUT ON AFT LEFT DOOR. INSTALLED DOUBLER PER SRM 53-05-00.SDR DL75E091649Skin · corrodedACCOMPLISHING THIS ERA (477585-14) TO REPAIR A SKIN CUTOUT. C/W PER ERA (477391-14) AT S-19L / STA 660. SAMPLE CUTOUT WAS TAKEN DUE TO FINDINGS OF PITTING CORROSION ALONG THE LOWER SKIN AT THE LAP JOINT WHILE ACCOMPLISHING SCRIBE LINE INSPECTIONS.SDR SWAA096630Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND SKIN CRACKED AT BS 947, STR 23R. REPAIRED SKIN PER EA.SDR SWAA096629Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND SKIN CRACKED AT BS 703, STR 10R. REPAIRED SKIN PER EA.SDR SIMA200928904Skin · crackedDURING MAINTENANCE INSPECTION, FOUND MULTIPLE CRACK LIKE INDICATIONS ON EXTERIOR SKIN AROUND RIVET HEADS AT FRAMES 77, 78 AND 79 BETWEEN STRINGERS 3L AND 7L AND 3R AND 7R. AIRCRAFT REMOVED FROM SERVICE. REMOVED FASTENERS & REAMED HOLES TO REMOVED SKIN CRACKSSDR SWAA096601Skin · corrodedDURING SCHEDULED 20Y CHECK, FOUND SKIN CORRODED BETWEEN BS 727A TO BS 727B, BETWEEN RBL 3 TO LBL 3. REPAIRED SKIN PER SRM.SDR SWAA096596Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND SKIN CRACKED AT BS 503C, STR 15R. REPAIRED SKIN PER EA.SDR USAA2009101592776Skin · crackedPHX - RON - MAJOR REPAIR - CRACK IN FUSELAGE SKIN AT BS 757, S19R. REPAIRED FUSELAGE SKIN AT BS 757, S19R IAW B757 SRM 53-00-01 FIG 201 REPAIR CATEGORY A DETAIL XI.SDR USAA2009101592775Skin · crackedPHX - RON - MAJOR REPAIR - CRACK IN FUSELAGE SKIN AT BS 727E, S21L. REPAIRED FUSELAGE SKIN AT BS 727E, S21L IAW B737 SRM 53-00-01 FIG 201 REPAIR CATEGORY A DETAIL 11.SDR IPXA09657655Skin · damagedLIGHTNING STRIKE DMG TO FASTENER AT STA 325 STR 24R. DMI D363083 LIGHTNING STRIKE AT STA 325 STR 24R DAMAGE FASTENER REPLACED AS PER SRM 53-00-01-2R8 FIG 201 REV 45.SDR DALA1312710681Skin · damagedLIGHTNING STRIKE AT FS 520 BETWEEN STR 7 AND 8L. REPAIRED REF ERA ON N/R 100-2.SDR GUUA94053101309ASkin · corrodedDURING SCHEDULED ROUTINE INSP RT BELLY SKIN HAS SKIN DEBONDING AT FS 288.00. REMOVED SURFACE CORROSION FROM SKIN REQUIRES REPAIR. REMOVED DAMAGED SKIN AND INSTALLED SKIN FILLER AND EXTERNAL DOUBLER REPAIR.SDR AALA20091019TUL13Skin · dentedDENT IN FUSE SKIN STATION 218, LONGERON 18 RIGHT TO LONGERON 19 RIGHT. DENT MEASURES .7 X .037 OVER SHEAR TIE, OUT OF LIMITS PER SRM 53-04 FIG 38 TABLE C AND AARD 53-30-00-04 1B. INSTALLED DOUBLER PER SRM 53-04-00 FIG 12B AND AARD 53-30-00-9.SDR DL75E091650Skin · dentedACCOMPLISHED THIS ERA (477583-14) TO REPAIR A DENT AT S-19L/ STA 609. PITTING CORROSION WAS ALSO FOUND ALONG THE LOWER SKIN AT THE LAP NEAR THE DENT.SDR SWAA096592Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND SKIN CRACKED AT BS 773, STR 19R. REPAIRED SKIN PER SRM.SDR SWAA096591Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND SKIN CRACKED AT BS 500C, STR 15R. REPAIRED SKIN PER EA.SDR SWAA096590Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND SKIN CRACKED AT BS 500D, STR 16R. REPAIRED SKIN PER EA.SDR SWAA096548Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND SKIN CRACKED AT BS 390, STR 26R. REPAIRED SKIN PER SRM.SDR SWAA096538Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN CRACKED AT BS 265, STR 10L. REPAIRED SKIN PER ER.SDR SWAA096533Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER AAR EA.SDR ASAA0946924Skin · dentedDENT BELOW THE R1 DOOR STA 328 STR 20. REPAIRED DENT.SDR C2XA09SH336Skin · crackedSHV - DURING C-CHECK VISUAL INDICATION OF CRACKS AROUND RIVET HEADS AT EXTERNAL FUSELAGE FRAME 79 STR 7L & 8L. MAINTENANCE REPAIR OF CRACKS AROUND RIVET HEADS AT EXTERNAL FUSELAGE FR 79 STR 7L & 8L IAW EMB-145XR EC5330-01985. THE AIRCRAFT WAS APPROVED FOR RESDR C2XA09SH327Skin · crackedSHV - DURING C-CHECK CRACKS ON FUSELAGE SKIN BELOW LT SIDE OF VERTICAL STAB AROUND RIVET HOLES. MAINTENANCE PERFORMED REPAIR OF CRACKS ON FUSELAGE SKIN BELOW LT SIDE OF VERTICAL STAB AROUND RIVET HOLES IAW EMB-145XR EC5330-01981. THE AIRCRAFT WAS APPROVED FO
Back to JASC 5330