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 SWAA118462Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN CRACKED AT BS 747+16, STR 24L. REPAIRED SKIN IAW SRM.SDR SWAA118456Skin · crackedDURING SCHEDULED SPV CHECK, FOUND LT FUSELAGE WINDOW SKIN CRACKED AT BS 887+10 AT UPPER AFT CORNER. REPAIRED SKIN IAW EA.SDR SWAA20111208424Skin · corrodedDURING SCHEDULED 18Y CHECK, FOUND AFT CARGO COMPARTMENT SKIN CORRODED AT BS 986.5, BETWEEN STR 26L TO STR 27L. REPAIRED SKIN PER ER AND EA.SDR FDEA201112075202Skin · dentedFUSELAGE DENTED BS 1578 STR 17L. DENT REPAIRED IAW EA F-5330-154474. REPAIR IS CLASSIFIED AS MAJOR.SDR FDEA201112075222Butt Joint · gougedUPON REMOVAL OF SEALANT FROM BUTT JOINT, FOUND VERTICAL SCRIBE LINE ON BUTT JOINT STRAP SURFACE AT BS 1621 FROM APPROX S-10 L THROUGH S-14L. REMOVED SPLICE PLATE AT STA 1621 BETWEEN S-10L TO S-14L IAW SRM 51-40-02. FABRICATED NEW SPLICE PLATE AT STA 1621 BESDR UHLA2011120700426Skin · damagedMAJOR REPAIR - BIRD STRIKE DENT RT NOSE BETWEEN FR4-5 AND BELOW STR 10R AND STR 9R 9.5"X5.25"X0.3125" WITH CREASE ON FCS WITH OIL CANNING. REPAIRED DAMAGE PER ETD 2011-170-108532 REV D, STRIPPED PAINT IAW EMB 170 SRM 51-23-02, CUTOUT DAMAGED AREA PER ETD, INSSDR TX9Y20111208010Skin · crackedDURING REMOVING TWO ADDITIONAL DOUBLERS, THREE HOLE CRACK ON THE LEFT DOUBLER FUSELAGE SKIN AND TWO HOLE CRACK ON THE RIGHT DOUBLER FUSELAGE SKIN WERE FOUND. FOR EXISTING REPAIR DOUBLERS WHICH COMMON TO NOSE WHEEL WELL AFTER CORNER SKIN BETWEEN STA 400 TO STASDR ASOA201102347Skin · chafedEXTERNAL AFT FUSELAGE SKIN CHAFED AT APROX. FS 916. REPAIR IS CLASSIFIED AS MAJOR.SDR FDEA201112075203Skin · gougedSKIN GOUGED SEVERAL PLACES AROUND CARGO DOORWAY BS 620 TO 640, STR 5L TO 16L. REPAIRED IAW SRM 51-30-2 & EA 7-5330-143955 .SDR CALA2011121200806Skin · dentedAFT CARGO DOOR OPENING AFT SIDE DAMAGED AT CUT-OUT. REPAIRED PER ECRA 5300-01313. DAMAGE IS .75 LONG BY .085 BLENDED TO .375 ON SKIN AND BEAR STRAP. PERFORMED INSPECTION PER PART 2 OF ECRA 5300-01313 HFEC. NO PROGRESSION NOTED DIP REMAINS PER ECRA 5300-013SDR USAA2011120900004Skin · crackedC11 CHECK - CRACK IN FUSELAGE SKIN BS 727F+6 INCHES, S22L. REPAIRED FUSELAGE SKIN BS 727F+6 INCHES, S22L IAW B737 SRM 53-00-01-2R-31 DETAIL XI.SDR FDEA201112075221Skin · damagedUPON REMOVAL OF SEALANT FROM BUTTJOINT FOUND VERTICAL SCRIBE LINE ON BUTT JOINT STRAP SURFACE AT BS 1621 FROM APPROX S-14L, THROUGH S-16L. HFEC INSPECTION OF SCRIBE LINE IAW NDTM53-30-09, NO CRACKS NOTE. FOUND TO BE OUT OF LIMITS IAW SRM 53-00-01, DETAIL 5, SDR SWAA118411Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN CRACKED AT BS 344, STR 17R. REPAIRED SKIN IAW SRM AND EA.SDR SWAA118402Skin · crackedDURING SCHEDULED SPV CHECK, FOUND RT FUSELAGE WINDOW SKIN CRACKED AT BS 380+12 LOWER AFT CORNER. REPAIRED SKIN IAW SB.SDR AALA20120113TUL08Skin · dentedDENT IN RIGHT FUSELAGE STATION 500D-3, BETWEEN STRINGERS 18 AND 19. INSTALLED DOUBLER PER SRM 53-00-01-2R.SDR AALA20120113TUL07Skin · dentedDENT IN LEFT FUSELAGE STATION 390. INSTALLED DOUBLER AT STATION 390 PER EA B737 53-021037.SDR AALA20120105TUL12Skin · scratchedTHREE INCH SCRATCH ON LEFT SIDE FUSELAGE AT STATION 500D-3 STRINGER 21 LEFT. ACCOMPLISHED DOUBLER REPAIR PER 53-00-01-2R1.SDR SWAA118713Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FOUND FUSELAGE SKIN CRACKED AT RT UPPER FWD WINDOW CORNER BS 520+10 AT HOLE NR 3. REPAIRED CRACK PER DOC.SDR SWAA118712Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT LWR RT AFT WINDOW, BS 420+10 AT HOLE NR 3. REPAIRED SKIN PER MM.SDR AALA20111220TUL02Skin · scratchedFOUND 3 INCH SCRATCH ON LEFT SIDE OF FUSELAGE AT STATION 500D-3 STRINGER 21 LEFT. INSTALLED DOUBLER PER SRM 53-00-01-2R.SDR DALA1167473354Skin · dentedINSTALLED REPAIR AT DENT LOCATION AFT OF FWD CARGO DOOR-REF L/P 8248652 PER A-330 SRM 53-00-11 FIG 224 SHEET 1. NEEDS A ONE TIME REINSPECT PER SRI 53-00-11-2-020-00 WITHIN 11500 FLT CYCLES. (MRR 116747)(NR 0404456)(2011-00754)SDR UALA2011120606715Skin Splice · corrodedAFT CARGO COMPARTMENT SKIN SPLICE CORRODED BS 1398 - BS 1402, STR 26L - STR 26R. MAJOR REPAIR ACCOMPLISHED. FOUND SKIN SPLICE OUT OF LIMITS PER SRM BETWEEN STRINGERS 28L-29L, 29L-30, AND 30-29R AFTER CORROSION REMOVAL. REMOVED SHEAR TIES AND FABRICATED A NESDR DALA1167451704Skin · damagedFS 266.5 BETWEEN STR 24L-25L HAD A LIGHTNING STRIKE AT A FASTENER AND THE SUBSEQUENT HOLE WAS ELONGATED. REPAIRED PER ERA 497661-14 REV ORG.SDR SWAA118383Skin · crackedDURING SCHEDULED SPV CHECK, FOUND RT FUSELAGE WINDOW SKIN CRACKED AT BS 827+10 LOWER FORWARD CORNER. REPAIRED SKIN IAW SB.SDR SWAA20111206382Skin · crackedDURING SCHEDULED SPV CHECK, FOUND RT FUSELAGE WINDOW SKIN CRACKED AT BS 787+10 LOWER FORWARD CORNER. REPAIRED SKIN IAW SB.SDR SWAA118381Skin · crackedDURING SCHEDULED SPV CHECK, FOUND LT FUSELAGE WINDOW SKIN CRACKED AT BS 767+10 LOWER FORWARD CORNER. REPAIRED SKIN IAW SB.SDR SWAA118380Skin · crackedDURING SCHEDULED SPV CHECK, FOUND RT FUSELAGE WINDOW SKIN CRACKED AT BS 480+10 LOWER AFT CORNER. REPAIRED SKIN IAW SB.SDR SWAA20111206379Skin · crackedDURING SCHEDULED SPV CHECK, FOUND RT FUSELAGE WINDOW SKIN CRACKED AT BS 420+10 LOWER AFT CORNER. REPAIRED SKIN IAW SB.SDR SWAA118378Skin · crackedDURING SCHEDULED SPV CHECK, FOUND LT FUSELAGE WINDOW SKIN CRACKED AT BS 460+10 UPPER FORWARD CORNER. REPAIRED SKIN IAW SB.SDR SWAA118377Skin · crackedDURING SCHEDULED SPV CHECK, FOUND LT FUSELAGE WINDOW SKIN CRACKED AT BS 420+10 UPPER FORWARD CORNER. REPAIRED SKIN IAW SB.SDR SWAA20111206376Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 972, STR 20L. REPAIRED SKIN PER SRM.SDR SWAA118375Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED BETWEEN BS 727D+4.25 TO BS 727D+4.65, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA20111206361Skin · crackedDURING SCHEDULED SPV CHECK, FOUND LT FUSELAGE WINDOW SKIN CRACKED AT BS 500C+10 LOWER AFT CORNER. REPAIRED SKIN IAW EA.SDR SWAA20111206360Skin · crackedDURING SCHEDULED SPV CHECK, FOUND LT FUSELAGE WINDOW SKIN CRACKED AT BS 500+10 LOWER AFT CORNER. REPAIRED SKIN IAW EA.SDR SWAA20111206359Skin · crackedDURING SCHEDULED SPV CHECK, FOUND LT FUSELAGE WINDOW SKIN CRACKED AT BS 360+10 LOWER AFT CORNER. REPAIRED SKIN IAW EA.SDR SWAA118358Skin · crackedDURING SCHEDULED SPV CHECK, FOUND LT FUSELAGE WINDOW SKIN CRACKED AT BS 500B+10 UPPER FORWARD CORNER. REPAIRED SKIN IAW EA.SDR SWAA20111206357Skin · crackedDURING SCHEDULED SPV CHECK, FOUND LT FUSELAGE WINDOW SKIN CRACKED AT BS 500A+10 UPPER FORWARD CORNER. REPAIRED SKIN IAW EA.SDR SWAA118356Skin · crackedDURING SCHEDULED SPV CHECK, FOUND RT FUSELAGE WINDOW SKIN CRACKED AT BS 500C+10 LOWER AFT CORNER. REPAIRED SKIN IAW EA.SDR SWAA118350Skin · crackedDURING SCHEDULED SPV CHECK, FOUND RT FUSELAGE SKIN CRACKED AT BS 500B+10 LOWER AFT WINDOW CORNER. REPAIRED SKIN IAW SB.SDR SWAA20111206349Skin · crackedDURING SCHEDULED SPV CHECK, FOUND RT FUSELAGE SKIN CRACKED AT BS 500+10 LOWER AFT WINDOW CORNER. REPAIRED SKIN IAW SB.SDR SWAA118348Skin · crackedDURING SCHEDULED SPV CHECK, FOUND RT FUSELAGE WINDOW SKIN CRACKED AT BS 500+10 UPPER FORWARD CORNER. REPAIRED SKIN IAW SB.SDR SWAA20111206347Skin · crackedDURING SCHEDULED SPV CHECK, FOUND LT FUSELAGE WINDOW SKIN CRACKED AT BS 440+10 LOWER AFT CORNER. REPAIRED SKIN IAW SB.SDR SWAA118346Skin · crackedDURING SCHEDULED SPV CHECK, FOUND LT FUSELAGE WINDOW SKIN CRACKED AT BS 400+10 LOWER AFT CORNER. REPAIRED SKIN IAW SB.SDR SWAA118343Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED BETWEEN BS 961 TO BS 962, STR 21L. REPAIRED SKIN IAW SRM.SDR SWAA20111206342Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED BETWEEN BS 807+7 TO BS 807+8.2, STR 19L. REPAIRED SKIN IAW SRM.SDR SWAA118341Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED BETWEEN BS 767+14 TO BS 767+14.3, STR 18L. REPAIRED SKIN IAW SRM.SDR SWAA20111206340Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED BETWEEN BS 787+16 TO BS 787+18, STR 19L. REPAIRED SKIN PER SRM.SDR REXA201100828Skin · damagedLIGHTNING DAMAGE TO THE FUSELAGE SKIN AT FS 295 BETWEEN S-25L AND S-26L. THE DAMAGE WAS REMOVED BY BLENDING RESULTING IN A 0.8 X 0.6 X 0.023 DEEP BLEND. REPAIRED IAW EA CRJ953-00242A AND ASSOCIATED 8110-3.SDR AALA20120202TUL07Skin · damagedTWO EACH DENTS WITH GOUGES FROM STATIONS 500H AND 500I, BETWEEN STRINGERS 7 AND 8 RIGHT. INSTALLED DOUBLER REPAIR PER SRM 53-00-01-2R 3.SDR UALA2011120606700Doubler · dentedEXTERNAL FUSELAGE SKIN DOUBLER HAS A DENT AT BS 610 BETWEEN STR 16L TO STR 17L. MAJOR REPAIR ACCOMPLISHED. REMOVED PREVIOUS BARN DOOR SKIN SPLICE REPAIR, AND FABRICATED A NEW SKIN SECTION AND SPLICE DOUBLERS AND FILLERS AND INSTALLED PER TIMCO REO G14217, R
Back to JASC 5330