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 UALA2011031401213Seal · leakingLEFT WING HAS TWO FUEL PANELS THAT ARE LEAKING. REPLACED SEALS ON UNDER LT WING ACCESS DOOR NR 7 AND NR 11. LEAK CHECKED AFTER WING REFUELED, NO LEAKS.SDR SWAA111844Skin · crackedDURING SCHEDULED OTS CHECK, FOUND CRACK AT STA 819-819.5, ABOVE STR 4R. REPAIRED PER ER/EA.SDR SWAA111843Skin · crackedDURING SCHEDULED OTS CHECK, FOUND CRACK IN RADIUS OF CHEM-MILL POCKET STA 496-498 , BELOW STR 2L. REPAIRED PER EA.SDR SWAA111842Skin · crackedDURING SCHEDULED OTS CHECK, FOUND CRACK STA 838 TO 839.5, ABOVE STR 4R. REPAIRED SKIN PER SRM.SDR SWAA111705Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR UPPER FWD CORNER. REPAIRED SKIN PER EA.SDR SWAA111680Skin · crackedDURING SCHEDULED 26Y CHECK, FOUND SKIN CRACKED AT BS 887+13, STR 16R. REMOVED AND REPLACED SKIN PER SRM.SDR SWAA111679Skin · crackedDURING SCHEDULED 26Y CHECK, FOUND SKIN CRACKED AT BS 755, STR 24L. REMOVED AND REPLACED SKIN PER SRM.SDR SWAA111678Skin · crackedDURING SCHEDULED 26Y CHECK, FOUND SKIN CRACKED AT BS 740D, STR 21L. REMOVED AND REPLACED SKIN PER SRM.SDR SWAA111670Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 514D, STR 16L. REPAIRED SKIN PER EA.SDR SWAA111664Skin · corrodedDURING SCHEDULED 16Y CHECK, FOUND SKIN CORRODED BETWEEN BS 867 TO BS 907, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA111640Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 787+17, STR 18L. REPAIRED SKIN PER EA.SDR SWAA111630Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND SKIN CRACKED AT BS 514C, STR 28L. REPAIRED SKIN PER EA.SDR SWAA111629Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND SKIN CRACKED AT BS 294.5+13, STR 18L. REPAIRED SKIN PER EA.SDR SWAA111625Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR UPPER FORWARD CORNER CRACKED. REPAIRED SKIN PER SRM.SDR TAMF201103110067Skin · corrodedDURING C4 CHECK FUSELAGE SECTION 41/43 CORROSION DAMAGE ON SKIN SPLICE PLATE STA 434, STR 38 RT. REPAIR WAS PERFORMED WITH EWO 767-53-121.SDR TAMF201103110064Skin · dentedDURING C4 CHECK FUSELAGE SECTION 43 SKIN DENT DAMAGE STRINGER CRACK, STA 720 S22L - S24L. REPAIR WAS PERFORMED WITH EWO 767-53-118.SDR COEA2011031141805Skin Panel · corrodedHEAVY CK COE / MAJOR REPAIR / LEVEL 2 CORROSION: LOWER EXTERIOR FUSELAGE SKIN PANEL BETWEEN FRAME 23 AND FRAME 23A BL 0 HAS TWO CORRODED AREAS (LENGTH 1.4". WIDTH .600", DEPTH .009"). CUT OUT DAMAGED SKIN AND FABRICATED AND INSTALLED DOUBLER IAW ATR72 SRM.SDR DALA1118499851Skin · crackedON T/A CHECK FOUND CRACK IN SKIN APPROX 2 INCHES LONG ON LEFT SIDE AFT OF ENGINE ON FUSELAGE NEXT TO EXISTING REPAIR. REMOVED EXISTING REPAIR, CUTOUT DAMAGE, INSTALLED REPAIR OF 2024T3.050 PER SRM 53-04 FIG 4 SH 4 ID PER PS 900-5-1 NR 4.SDR C2XA11SH063Skin Panel · damagedAC N29917 FERRIED INTO SHV BECAUSE OF GROUND DAMAGE BY LAVATORY TRUCK. SKIN PANEL AT FRAME 61-66 STRINGER 16R TO 19L HAS DAMAGE. FERRY FLIGHT CONDITIONS WERE TO "SECURE BOTH OUTFLOW VALVES, TRIM JAGGED MATERIAL FROM AROUND PUNCTURED AREAS, RE-CONTOUR PUNCTURSDR CA110516027Skin · crackedDURING A PRE-PURCHASE INSP, THE ABOVE SKIN FOUND TO BE SEVERLY CRACKED. THE SURROUNDING AREA WAS FURTHER INSPECTED AND OTHER DAMAGE WAS FOUND.SDR A6WA201140179Skin · dentedFUSELAGE SKIN AROUND PAX DOOR CUT OUT DENTED. COMPLIED WITH REO 601R-53-21-1251, DENT ACCEPTABLE AS FS.SDR IPXA1B65784Doubler · corrodedINSPECTION TYPE:D, M/D R4 DOOR FWD LWR CUTOUT REMOVAL DOUBLER AT BS 1665 STR 24R FOUND CORRODED. REVEAL DOUBLER AND REVEAL PANEL EXISTING CUTOUT & REVEAL PANEL CHAFED AREA REPAIRED IAW RS R-53-60-36999 REV A & EO B747-5310-42053 REVEAL DOUBLER ORG MATL IS 707SDR UHLA2011031000132Doubler · corrodedLEVEL 2 CORROSION AROUND AFT LAV SERVICE PANEL, UNDER REAR LAV FLOOR. REMOVED AND REPLACED DOUBLER, NO FURTHER DAMAGE FOUND IAW EMB 175 SRM 51-43-01.SDR FDEA201103100937Skin · damagedPREVIOUS OPERATORS MULTIPLE FUSELAGE SKIN BLENDS, FOUND OUT OF LIMITS. REPAIRED PER SRM 53-00-01, REPAIR 16, CAT. "B" MAJOR REPAIR.SDR AALA20110316DWH02Skin · corrodedCORROSION OF THE FUSELAGE SKIN INNER SURFACE AT STATION 439 AND UNDER STRINGER 34 LEFT. ACCOMPLISHED DOUBLER REPAIR PER EA B767-53-015392.SDR SWAA111876Skin · crackedDURING SCHEDULED 26Y CHECK, FOUND CRACK STA 500D, STR 15R. REPAIRED PER EA.SDR SWAA111875Skin · crackedDURING SCHEDULED 26Y CHECK, FOUND CRACK STA 754, STR 20L. REPAIRED PER SRM.SDR AALA20110310TUL05Skin · dentedDENT AT STATIONS 1620 TO 1640 STRINGER 21 TO 23 RIGHT. INSTALLED DOUBLER PER EA 015630.SDR UIEA2011030900236Skin · dentedFOUND EXTERNAL SKIN HAD DENT AT AFT CARGO DOOR; AFT & AMP; LWR SIDE. STA 1914 TO STA 1918 (REPAIR - IAW EI T2011A52B-565, REV 00 & AMP; REV 01)SDR USAA2011032991276Skin · crackedCLT - Q2 - CRACK ON FUSELAGE SKIN AT BS 867 + 3 INCHES, S23R. REPAIRED FUSELAGE SKIN AT BS 867 + 3 INCHES, S23R IAW B737 SRM 53-00-01 REPAIR 31.SDR UIEA2011030900152Skin · dentedDENT- FWD EXTERNAL SKIN HAD A DENT AT AFT AND LOWER SIDE, STA 1917 TO 1918 (IN PROCESS).SDR FDEA201103090922Skin · misrepairedEXISTING DOUBLER AT FR72-73, STR 24-25 LT FOUND TO NOT BE IAW SRM 53-10-12, FIG 225. ONLY 2 ROWS OF FASTENERS HAVE PREVIOSLY BEEN INSTALLED EITHER SIDE OF CUTOUT, SRM REQUIRES 3 ROWS. REPAIR CARRIED OUT IAW EA6-5330-97590 AND SRM 53-10-12 FIG 225.SDR SWAA111649Skin · crackedDURING SCHEDULED 18Y CHECK, FOUND SKIN CRACKED BETWEEN BS 979 TO BS 982, STR 21L. REPAIRED SKIN PER SRM AND BAC DWG.SDR SWAA111614Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND SKIN CRACKED AT BS 390, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA111613Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND SKIN CRACKED AT BS 967 + 5, STR 25L. REPAIRED SKIN PER SRM.SDR SWAA111612Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND SKIN CRACKED AT BS 927 + 6, STR 25L. REPAIRED SKIN PER SRM.SDR SWAA111611Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND SKIN CRACKED AT BS 747 + 16, STR 21L. REPAIRED SKIN PER SRM.SDR SWAA111610Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND SKIN CRACKED AT BS 747 + 13, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA111609Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND SKIN CRACKED AT BS 747 + 7, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA111608Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND SKIN CRACKED AT BS 747 + 4, STR 19L. REPAIRED SKIN PER SRM.SDR USAA2011031191022Skin · crackedCLT - C2 - MAJOR REPAIR - CRACK IN FUSELAGE SKIN AT BS 379, S28L. REPAIRED FUSELAGE SKIN AT BS 379, S28L IAW EA 102774.SDR COEA2011030936805Plate · corrodedHEAVY CK COE / LEVEL 2 CORROSION: FWD RADIO ATL ANTENNA MOUNTING SURFACE HAS LEVEL 2 CORROSION. CORROSION REMOVED AND INSTALLED NEW OEM ANTENNA PLATE IAW STRUCTURAL REPAIR MANUAL.SDR SWAA111542Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 913, STR 25R. REPAIRED SKIN PER EA.SDR SWAA111541Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 274, STR 15R. REPAIRED SKIN PER EA.SDR SWAA111540Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 371.5, STR 26L. REPAIRED SKIN PER EA.SDR SWAA111539Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 386, STR 15R. REPAIRED SKIN PER EA.SDR DALA1116915523Skin · dentedDURING INSP OF LOG PAGE 2969760 FOUND DENT OVER S16L AT STA 414. CUT OUT DAMAGE AREA ON SKIN FROM B STA 409-414 STR 16L AND INST .071" THK REPAIR DOUBLER AND FILLER .06 3" THK PER SRM 53-00-01. INSP TO START AT 69,509 FLIGHT CYCLES WITH REPEAT INSP EVERY 300SDR DALA1116899878Skin · gougedFUSELAGE EXTERIOR STA 908 BETWEEN L20L AND L21L SKIN GOUGED. FABRICATED INTERNAL DOUBLER LOCATED, DRILLED DEBURRED. TREATED & PRIMED IAW DC9 SRM 51-10-3 INSTALLED INTERNAL DOUBLER & REPAIR IAW DC9 DWG SG09530001 & INSTALLED ID REPAIR TAG IAW DELTA PS 900-5-1SDR DALA1116889870Skin · gougedFWD SERVICE DOOR JAMB AFT LOWER CORNER HAS GOUGES IN SKIN WHERE SCUFF PLATE WAS REMOVED. INCOMING BLENDED GOUGES IAW DC-9 SRM 53-01 FIG 1 SHT 3 ORIG MAT .050 IAW DC-9 SRM 53-33-0 FIG 1 SHT 3. MAT REMAIN .036 OUT OF LIMITS IAW DC-9 SRM 53-01 FIG 1. NDT SPM 0SDR AALA20110309TUL01Skin · dentedFUSELAGE LEFT SIDE DENT IN FUSELAGE SKIN AT STATION 370 APPROXIMATELY JUST BELOW LONGERON 27 LEFT. REPAIRED DAMAGE AT STATION 370 LONGERON 27 LEFT PER SRM 53-04-00 FIGURE 38 VIEW E.
Back to JASC 5330