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 SWAA042952Skin · crackedDURING SCHEDULED A2 CHECK, FOUND FUSELAGE SKIN AT BS 767, STRINGER 18L, CRACKED. REPAIRED SKIN PER EA AND SRM.SDR 04FDEA02904Skin · misrepairedRIGHT HAND PRIMARY STATIC PORT FAILS RVSM INSPECTION FOR EXTERNAL DOUBLER MISMATCH RATIO IAW DC10 SRM 53-00-02 NOTE 2 (FIG 1 SHEET 2). REMOVED EXISTING FUSELAGE SKIN REPAIR ON FORWARD EDGE OF FORWARD CARGO DOOR CUTOUT DOUBLERS, FABRICATED NEW EXTERNAL DOUBLERSDR SWAA042938Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT BS 793, STRINGER 18L, CRACKED. REPAIRED SKIN PER SRM.SDR ASAA0470018Skin · damagedOKC - TOW BAR SNAPPED CAUSING RT FUSELAGE DAMAGE FORWARD OF FORWARD CARGO DOOR AT STA 375 TO 410 BETWEEN STR 18R AND 20R. REPAIR IAW EA 5330-01838.SDR DLM88040959Skin · corrodedFUSELAGE SKIN FS 630 LONGERON 29-30 RT : THE FUSELAGE SKIN AND UNDERLYING DOUBLER WERE FOUND CORRODED AT FS 630 BETWEEN LONGERON 29R AND 30. THE CORROSION WAS REMOVED WITH A 9 INCH X 5 INCH CUTOUT IN THE SKIN AND A 7 INCH X 5 INCH CUTOUT IN THE DOUBLERSDR 2004UALA00922Bear Strap · corrodedAFT PIT AT STA 1415 BETWEEN STRINGER 26R & 27R BEAR STRAP CORRODED. AREA FASTENER WERE REMOVED AND CORROSION WAS BLENDED AND REMOVED.SDR SWAA042936Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN AT BS 480, STRINGER 17R, CRACKED. REPAIRED SKIN PER EA.SDR SWAA042935Skin · crackedDURING SCHEDULED C1 CHECK, FOUND 3 EACH FUSELAGE SKIN CRACKS BETWEEN BS 435 AND BS 485, STRINGER 26R. REPAIRED SKIN SECTIONS PER SRM.SDR SWAA042934Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN AT BS 944, STRINGER 22R, CRACKED. REPAIRED SKIN PER SRM.SDR USAA040834Skin · crackedSKIN, 1 INCH CRACK, BS 727D, STR 22R. INSTALLED DOUBLER IAW SRM 53-00-01. INSTALLED DOUBLER IAW SRM 53-00-01.SDR USAA040833Skin · crackedSKIN, 1.5 INCH CRACK, BS 727E, STR 22L. INSTALLED DOUBLER IAW SRM 53-00-01.SDR SWAA042932Skin · crackedDURING SCHEDULED PM CHECK, FOUND 4 EACH FUSELAGE SKIN CRACKS BETWEEN BS 500C AND BS 500C + 17, STRINGER 15L. REPAIRED SKIN PER EA.SDR SWAA042929Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN AT BS 727E + 5, BELOW STRINGER 19R, CRACKED. REPAIRED SKIN PER EA.SDR SWAA042926Skin · crackedDURING SCHEDULED C3 CHECK, FOUND 2 EACH FUSELAGE SKIN CRACKS AT BS 749, STRINGER 19R, BS 800, STRINGER 18R. REPAIRED SKIN SECTIONS PER EA.SDR CALA0400667Skin · corrodedAPB SKIN CORROSION AT BL 0, 6 INCHES ABOVE Y-ATTACH CHORD. REPAIRED PER BOEING DRAWING 65C28106.SDR 04FDEA02896Doubler · misinstalledDURING B SERVICE AT LAX AND RVSM UPGRADE, FOUND PREVIOUS SRM REPAIR INFRINGING UPON RT NORMAL STATIC PORT CONTROLLED AREA. SELECTED REPAIR IS NOT APPLICABLE TO SPEIFIC AREA PER EA 8-5320-77995. REPAIR WAS REMOVED AND APPROPRIATE REPAIR INSTALLED PER SRM 53-2SDR UIEA200400182Skin · scratchedSTA 2577-2598 RBL 12 LOWER SKIN 3 EACH SCRATCHES. SCRATCHED AREA SMOOTHED OUT IAW SRM 53-00-01 FIG 101. PROTECTED AREA IAW SRM 51-20-01. PERFORMED HFEC INSPECTION ON THE EXTERNAL SKIN NO CRACKS FOUND.SDR SWAA042916Skin · crackedDURING SCHEDULED A2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500C+16, ABOVE STR 15L. REPAIRED SKIN PER SWA EA.SDR SWAA042915Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 747, BELOW STR 24L. REPAIRED SKIN PER SWA EA.SDR DL73S040951Skin · crackedTHE LOWER AFT CORNER OF THE RIGHT WING SCANNING LIGHT CUTOUT AT FS 530 WAS FOUND WITH A .5 INCH CRACK IN THE SKIN. THE CRACK WAS REMOVED WITH A SMALL CUTOUT AND REPAIRED WITH AN EXTERNAL ALUMINUM REPAIR DOUBLER PER ER/A 094021-14.SDR ASAA0410418Skin · crackedPAE- 5 HOLES WITH CRACK INDICATIONS. OVERSIZED HOLES AND INSTALLED REPAIR DOUBLERS.SDR USAA040749Skin · crackedPIT, C3; SKIN, (3 EA) CRACKS; 1 INCH, 2.7 INCHES AND 1 INCH, AFT OF 727E-747, S18R. INSTALLED REPAIRS IAW SRM 53-00-01, FIG 228.SDR UIEA2004118Skin · dentedDENT FOUND IN THE FUSELAGE SKIN RT SIDE AT STATION 2596. ACCOMPLISHED DENT REPAIR ON FUSELAGE SKIN RT SIDE STATION 2596 STRINGER 42 AREA IAW SRM 53-00-01 FIG 215 DETAIL I. (M)SDR SWAA042908Skin · crackedDURING SCHEDULED PM CHECK, FOUND FUSELAGE SKIN AT BS 877, STRINGER 24R, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA042907Skin · corrodedDURING SCHEDULED SERVICE CHECK, FOUND KEEL BEAM SKIN AT BS 500, CORRODED. REMOVED AND REPLACED SKIN SECTION PER EA.SDR SWAA042902Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN AT BS 270, STRINGER 16L, CRACKED. REPAIRED SKIN PER EA.SDR SWAA042901Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN AT BS 937, STRINGER 22R, CRACKED. REPAIRED SKIN PER EA.SDR AWXA200401159Skin · wornDURING C-18 CHECK, A WORN AREA WAS FOUND ON FUSELAGE SKIN WHERE VERTICAL FIN MEETS FUSELAGE AT BS 967, STR 2 LT. MAINTENANCE BLENDED DAMAGED SKIN AT BS 967, STR 2 LT; FABRICATED WEAR STRIPS PER DWG 65-45772; INSTALLED REPAIR PARTS IAW ER 03-5331-04293-RA2.SDR AWXA200401150Skin · wornDURING C-18 CHECK, A WORN AREA WAS FOUND ON DOUBLER (SKIN) WHERE VERTICAL FIN MEETS FUSELAGE BETWEEN BS 867 AND BS 887, STR 1 RT AND STR 2 RT. MAINTENANCE REMOVED WORN DOUBLER FROM BS 867 TO BS 887, STR 1 RT TO STR 2 RT; FABRICATED A NEW REPLACEMENT DOUBLER PSDR QXEA200400704Skin Panel · damagedPDX - REPAIR FUSELAGE SKIN PANELS LOCATED AT STATION X167 AND X240.5 BETWEEN STRINGERS 31 AND 33 STARBOARD. MAINTENANCE REPAIRED THE SKIN PANELS IAW EA'S 2-53-576A AND 2-53-576B.SDR QXEA200400703Skin Panel · damagedREPAIR FUSELAGE SKIN PANELS LOCATED AT STATION X 123- X 167 BETWEEN STRINGERS 31S AND 33S. REPAIRED SKIN PANELS IAW EA'S 2-53-575B AND 2-53-575C.SDR QXEA200400702Skin · damagedPDX - REPAIR FUSELAGE SKIN AT STATION 110 BETWEEN STRINGER 31R AND 32R. PERFORMED REPAIR IAW EA 2-53-574A.SDR DL73S040949Skin · crackedFOUND ON X-2 LETTER CK, 3.5 INCH CRACK IN FUSELAGE SKIN STA 944 AND STR 25 RIGHT. REPAIRED PER SRM 53-30-3 FIG 48.SDR SWAA042893Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN AT BS 937, STRINGER 22R, CRACKED. REPAIRED SKIN PER EA AND SRM.SDR SWAA042882Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT BS 500D, STRINGER 16R, CRACKED. REPAIRED SKIN PER EA.SDR IXXA060195SSkin · dentedDURING ROUTINE C CHECK, FOUND SKIN DENTED AT STATION Y1190 BETWEEN LONGERONS 31 LEFT AND 33 LEFT. REPAIRED SKIN PER ALL APPLICABLE DATA.SDR IXXA060189SSkin · bulgedDURING ROUTINE C CHECK FOUND SKIN BULGING AT STATION 1582 BETWEEN LONGERONS 27 LEFT AND 28 LEFT. REPAIRED PER ALL APPLICABLE DATA.SDR USAA040698Skin · crackedSKIN, 3.125 INCH CRACK, AT STRINGER 25R, STATION 727E. INSTALLED DOUBLER IAW SRM 53-00-01, FIG 229.SDR USAA040697Skin · crackedSKIN, 1 INCH CRACK, STRINGER 24R, BETWEEN STA 727D AND 727E. INSTALLED DOUBLER IAW SRM 53-00-01, FIG 229.SDR UPS04543351Skin · corrodedINSPECTION TYPE-C, CORROSION FWD OF APU INLET BOX BS 1790 4 INCHES IB OF STR6R. REMOVED AND REPLACED STRAP AT APU INLET BOX IAW SRM 51-40-02.SDR SWAA042913Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND R1 COCKPIT WINDOW C/D POST CRACKED AT UPPER CORNER. REPAIRED SKIN PER SRM.SDR SWAA042912Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR LOWER FWD CORNER CUTOUT. REPAIRED SKIN PER SWA EA.SDR SWAA042883Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND 2 EACH FUSELAGE SKIN CRACKS AT BS 727D, BS 727B, STRINGER 14R. REPAIRED SKIN PER RA.SDR SWAA042881Skin · crackedDURING SCHEDULED C3 CHECK, FOUND 4 EACH FUSELAGE SKIN CRACKS AT BS 747, BS 755, STRINGER 24L, BS 727D, STRINGER 22R, BS 747, STRINGER 18R. REPAIRED SKIN PER EA AND SRM.SDR SWAA042880Skin · crackedDURING SCHEDULED C3 CHECK, FOUND 2 EACH FUSELAGE SKIN CRACKS AT BS 500D, BS 520, STRINGER 12L.SDR IXXA060067SDoubler · wornDURING ROUTINE C CHECK, FOUND EXTERNAL FUSELAGE DOUBLER WORN AT STATION 980 BETWEEN +X65 TO -Z54. REMOVED FASTENERS AS NEEDED TO REMOVE DAMAGED DOUBLER. FABRICATED NEW ANGLE, LOCATED, DRILLED, TRIMMED, TREATED, PRIMED, INSTALLED NEW EXTERNAL FUSELAGE DOUBLERSDR IXXA0500235SSkin · crackedDURING ROUTINE C-CHECK FOUND EXTERNAL FUSELAGE SKIN CRACKED AT STATION 17 BETWEEN LONGERONS 14 LEFT ANF 17 LEFT, FORWARD ENTRANCE HOLD OPEN PAN AREA. REMOVED DAMAGE. FABRICATED REPAIR PARTS, LOCATED, DRILLED, TREATED, PRIMED, AND INSTALLED REPAIR PARTS AND FSDR IXXA0500220SSkin · corrodedDURING ROUTINE C-CHECK FOUND CORROSION AT FORWARD CARGO COMPARTMENT INNER SKIN STATION 280. REMOVED DAMAGED AREA, FABRICATED REPAIR PARTS, LOCATED, DRILLED, TREATED, PRIMED, AND INSTALLED NEW REPAIR PARTS AND FASTENERS AT STATION 276.5 TO 280 BETWEEN LONGERONSDR ASAA0410421Skin · damagedPAE - DAMAGE IN SKIN AT LAP. BLENDED DAMAGE AND INSTALLED REPAIR DOUBLERS.SDR ASAA0410420Skin · damagedPAE - SCRIBE MARKS IN SKIN AT LAP. BLENDED SCRIBE MARKS AND INSTALLED REPAIR DOUBLERS.
Back to JASC 5330