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 DLM88081705Skin · gougedFUSELAGE SKIN AT FS 125, BETWEEN L-29L AND L-30 WAS FOUND WITH A LIGHTNING STRIKE BEYOND SRM 53-04 FIG 38 LIMITS. THE DAMAGE WAS CUT OUT AND AN EXTERNAL REPAIR DOUBLER INSTALLED. REPAIR IS TIME-LIMITED FOR DTA PURPOSES.SDR DHLA200800133Skin · damagedACFT SKIN DAMAGE 2 IN HOLE LOWER RT SIDE BELOW PITOT TUBE. ACFT DAMAGED BY CARGO CONTAINER. INSTALLED REPAIR IAW SRM 53-30-3 AT STA 212 RT STR 25R.SDR SWAA086871Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 227, RBL 15. REPAIRED SKIN PER AAR EA.SDR SWAA086870Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 286, STR 13R. REPAIRED SKIN PER AAR EA.SDR SWAA086867Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER AAR EA.SDR SWAA086862Skin · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER AAR EA.SDR SWAA086861Skin · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER AAR EA.SDR SWAA086860Skin · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER SWA EA.SDR SWAA086846Skin · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER CUTOUT, BS 430, BL 0. REPAIRED SKIN PER AAR EA.SDR SWAA086845Skin · crackedDURING SCHEDULED 14Y CHECK, FOUND NOSE WHEEL WELL UPPER PRESSURE SKIN CRACKED AT BS 252, BETWEEN LBL 9 TO RBL 9. REPAIRED SKIN PER ACO.SDR SWAA086836Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR LOWER HINGE CUTOUT CRACKED. REPAIRED SKIN PER SWA EA.SDR UPS08B54086Skin · damagedINSPECTION TYPE:N/A HOLE IN FUSELAGE 40 INCHES FWD OF LWR AFT CARGO DOOR BS 1770, BETWEEN STRINGERS 28R & 29R. FABRICATED PATCH PER EO B747-5330-31394A, AND SRM 53-00-01 OUT OF 2024 -T-3 .125 CLEANED DAMAGE ON A/C REPAIRS MATERIAL AND A/C ETCHED, ALODINE & PRSDR FDEA200812035061Skin · damagedNUMEROUS FASTENERS WITH IMPROPER ED AND SPACING STA 440 STR'S 8L TO 10L. REPAIRED THE AFFECTED AREA IAW FEDEX EA NR 7-5330-126864, FUSELAGE SKIN AD 98-11-03R1. MCD CUTOUT REINFORCEMENT DOUBLER AND FUSELAGE SKIN LAP JOINT REPAIR AT STA 440, S10L.SDR SWAA086806Skin · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE BELLY SKIN CRACKED AT EQUIPMENT COOLING DUCT CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA086802Skin · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER AAR EA.SDR SWAA086794Skin · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR UPPER HINGE CUTOUT AT BS 291, WL 253. REPAIRED SKIN PER SWA EA.SDR SWAA086793Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 996, STR 25L. REPAIRED SKIN PER SRM.SDR SWAA086787Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 749, STR 24L. REPAIRED SKIN PER SWA EA.SDR SWAA086785Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND SKIN CRACKED AT BS 518, STR 28L. REPAIRED SKIN PER SRM.SDR SWAA086770Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 727E, STR 22L. REPAIRED SKIN PER SWA EA.SDR SWAA086769Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 773, STR 25L. REPAIRED SKIN PER SRM.SDR SWAA086768Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 767, STR 25L. REPAIRED SKIN PER SRM.SDR SWAA086782Skin · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER AAR EA.SDR SWAA086781Skin · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE BELLY SKIN CRACKED AT RADIO ALTIMETER SKIN CUTOUT, BS 450. REPAIRED SKIN PER AAR EA.SDR SWAA086780Skin · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE BELLY SKIN CRACKED AT RADIO ALTIMETER SKIN CUTOUT, BS 430. REPAIRED SKIN PER AAR EA.SDR SWAA086779Skin · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE BELLY SKIN CRACKED AT RADIO ALTIMETER SKIN CUTOUT, BS 390. REPAIRED SKIN PER AAR EA.SDR SWAA086778Skin · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE BELLY SKIN CRACKED AT RADIO ALTIMETER SKIN CUTOUT, BS 410. REPAIRED SKIN PER AAR EA.SDR FDEA200812035062Skin · corrodedBS 1183 - 1148 OB AND STR 26L HAS SURFACE CORROSION. REMOVED CORROSION AND FOUND OUT OF LIMITS IAW SRM 53-30-1 FIG 1 AND 2 AND 53-30-2 FIG 2. REPAIRED SKIN IAW EA NR 7-5330-126867 FUSELAGE SKIN AD 98-11-03 R1, STA 1152 STA 1175 STR 26L 65-54583 LAP JOINT UPPSDR DLM88090040Panel · corrodedEXFOLIATION CORROSION ON AFT LAVATORY SERVICE PANEL. REMOVE CORROSION IAW SRM 51-10-3 PAR 35, FOUND OUT OF LIMITS. REPAIR PARTS FABRICATED IAW ERA 472127-14 REV ORIG. REPAIR PARTS INSTALLED IAW ERA 472127-14 REV ORIG AND IDENTIFIED IAW PS 900-5-1 NR 4.SDR SWAA086764Skin · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER AAR EA.SDR SWAA086754Skin · corrodedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SKIN CORRODED AT BETWEEN BS 520 TO BS 530, STR 28R. REPAIRED SKIN PER SRM.SDR SWAA086776Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER SWA EA.SDR SWAA086775Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA086738Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 749, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA086710Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND FWD CARGO SKIN CRACKED AT BS 518, STR 28L. REPAIRED SKIN PER SRM.SDR SWAA086730Skin · corrodedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CORRODED AT BS 500D, STR 27L. REPAIRED SKIN PER SRM.SDR SWAA086728Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND L1 DOOR SKIN CUTOUT CRACKED AT BS 305, BELOW WL 236. REPAIRED SKIN PER SWA EA.SDR SWAA086726Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT E/E EXHAUST PORT OPENING AT BS 379, LBL 2, STR 18R. REPAIRED SKIN PER SWA EA.SDR UHLA2008120100061Doubler · corrodedLEVEL 2 CORROSION WASTE SERVICE BAY INNER FWD DOUBLER, FOUND OUT OF LIMITS. FABRICATED DOUBLER AND REPLACED IAW SRM 51-43-02.SDR FDEA200812015021Skin · corrodedEMPENNAGE, RIGHT AFT FUSELAGE EXTERNAL SKIN COMMON TO BODY FAIRING NR 347DF MATING SURFACE FOUND WITH CORROSION. CORRODED SKIN AT EMPENNAGE RIGHT AFT FUSELAGE EXTERNAL SKIN COMMON TO BODY FAIRING NR 347DF. REPAIRED AS PER SRM 53-20-00 FIGURE 13 VOLUME I. RESDR COMA2008120150020Skin Panel · damagedCOMPLIED WITH MODIFICATION K601R36009-3 ON LT FS 640.00 FRAME AND DOUBLER PER S/B601R-53-061 KIT DRWG K601R36009 REV B, 601R-53-61-506 REV C AND 601R53-61-569. REMOVED AND REPLACED SKIN PANEL BETWEEN LT AND RT TRU DOORS IAW CRJ SRM 51-42-06. DAMAGED SKIN JUSSDR SWAA086638Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BETWEEN BS 375 TO BS 378, STR 15L. REPAIRED SKIN PER SWA EA.SDR UPS08854052Skin · corrodedINSPECTION TYPE:N/A AREA OF CORROSION CAUSING RIVET HEADS TO DEFORM ON A/C SKIN LOWER CENTERLINE LOCATED NEAR VHF BLADE ANTENNA. INSTALLED INTERIM REPAIR DOUBLER REF NRC 224311 REF E/O DC8-5330-3135 3-A FOR REPEAT INSP AND PERM REPAIR REQUIREMENTS. THIS IS ASDR CALA2008120101109Bear Strap · corrodedL1 DOOR HAS CORROSION ON INNER DOOR FRAME SKIN UPPER AFT INITIATED "DIP" TO ACCOMPLISH PERMANENT REPAIR WITHIN 12 MONTHS REF ECRA 5330-03849. L1 DOOR CUTOUT BEAR STRAP CORRODED. PER ECRA 5330-03849 COMPLETED INTERIM REPAIR. COMPLY WITH PERMANENT REPAIR WITHSDR DLM88081651Skin · damagedFUSELAGE BELLY SKIN FROM FS 313 TO FS 427, AND L26L TO L26R WAS SPLICED DUE TO NUMEROUS GOUGES, TWO PREVIOUS SKIN REPAIRS, AND REMNANTS OF AN ANTENNA MODIFICATION THAT IS NO LONGER USED. THE SKIN SPLICE WAS PER THE SRM, AND INCLUDED PLUGGING PREVIOUS REPAIR FSDR UALA2008120106683Skin · damagedAFT LOWER FUSELAGE FR70 TO FR72 HAS TAIL STRIKE DAMAGE TO EXTERNAL SKIN BETWEEN STR 42R TO STR 41L. MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGED SECTION OF SKIN. FABRICATED & INSTALLED EXTERNAL DOUBLER.SDR SWAA086664Skin · crackedDURING SCHEDULED MV4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 400, STR 15L. REPAIRED SKIN PER SWA EA.SDR SWAA086663Skin · crackedDURING SCHEDULED MV4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 370, STR 15L. REPAIRED SKIN PER SWA EA.SDR SWAA086659Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 793, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA086647Skin · crackedDURING SCHEDULED MV4 CHECK, FOUND SKIN CRACKED AT BS 438, STR 31L. REPAIRED SKIN PER SRM.
Back to JASC 5330