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 CALA0400078Skin · dentedINSPECTION FOUND FUSELAGE SKIN DENTED AT STA 887-907, S26R. THE SKIN WAS REPAIRED IAW SRM 53-00-01.SDR MALA040206Skin · dentedFS 317 LT FUSELAGE 6 INCHES BELOW STR SL1632 DENT OUT OF LIMITS. CUT OUT DAMAGED AREA FABRICATED AND INSTALLED A DOUBLER REPAIR IAW EO NR S53005. A/C RELEASE DATE 2/26/04. REFER TO LOG PAGE NR 1264969 FOR ADDITIONAL INFORMATION.SDR SWAA040365Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 801, STRINGER 18L. REPAIRED SKIN PER SRM.SDR SWAA040364Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND SKIN CRACKED AT NOSE WHEEL WELL, BOTH LT AND RT FORWARD ACCESS PANELS. REPAIRED SKIN PER EA.SDR MALA040186Shield · dentedDURING 4K INSPECTION IN LCQ, LT FUSELAGE AFT OF NR 2 ICE SHIELD HAS NUMEROUS DENTS. FABRICATED AND INSTALLED 2 EACH EXTERNAL DOUBLERS IAW MESABA EO NR S53009. REFER TO 409 NR 1258951 FOR FURTHER DETAIL. A/C RELEASE DATE 2/16/04.SDR CALA0400074Skin · puncturedTHE FUSELAGE SKIN WAS PUNCTURED BETWEEN BS 1380 AND BS 1400 AT S28R-29R. THE SKIN WAS REPAIRED IAW ECRA 5331-01137.SDR ASAA0440030Doubler · corrodedGYR - FOUND AFT PIT, CORROSION ON SKIN DOUBLER STATION 1006. REPAIRED IAW EA 5330-1743. (M)SDR ASAA0440032Skin · gougedGYR - FOUND FUSELAGE SKIN DENT/GOUGED AT BS 847 BETWEEN S-24R AND S-25R. REPAIRED IAW EA 5330-01688. (M)SDR UPS04841868Skin · crackedINSPECTION TYPE: C3, FUSELAGE SKIN IS CRACKED AT FASTENER HOLE AT STATION 1342 LONG 31R. CUT OUT DAMAGE, NDT VERIFIED NO CRACKS AT CUTOUT. FABRICATED AND INSTALLED FILLER, DOUBLER AND FINGER DOUBLERS IAW SRM 53-2-1 FIG 7.SDR QXEA200400124Skin · dentedPDX - DENT IN FUSELAGE SKIN - LEFT HAND SIDE UNDER ICE SHIELD 10.5 INCHES ABOVE NR 2 WINDOW. REPAIRED IAW HORIZON AIR EA 2-53-541 AND RD 8-53-7768.SDR QXEA200400123Skin · dentedPDX - DENT IN FUSELAGE SKIN - LEFT HAND SIDE UNDER ICE SHIELD 4 INCHES ABOVE NR 2 WINDOW. REPAIRED IAW RD 8-53-7763 AND HORIZON AIR EA 2-53-541.SDR SWAA040361Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 758, STRINGER 19R. REPAIRED SKIN PER SRM.SDR SWAA040360Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 727, STRINGER 24L. REPAIRED SKIN PER SRM.SDR SWAA040359Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 767, STRINGER 18L. REPAIRED SKIN PER SRM.SDR SWAA040353Skin · crackedFUSELAGE SKIN CRACKED UNDER R1 DOOR BS 319, STRINGER 17R. REPAIRED SKIN PER SRM.SDR SWAA040363Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKS AT FOLLOWING, BS 320, STRINGER 19R, BS 538, BETWEEN STRINGERS 2R AND 3R, BS1011, STRINGER 23R. REPAIRED SKIN PER SRM.SDR GKZR200482301Skin · corrodedRIGHT SIDE STA 35 L30 SKIN HAS CORROSION. REMOVED FASTENERS IAW DC-8 SRM 51-1-20, DRILLED NEW DOUBLER PART NUMBER 5649028U AND INSTALLED IAW DC-8 SRM 51-1-21, DRILL AND INSTALLED NEW LONGERON PART NUMBER 3648667 IAW DC-8 SRM 51-1-21. (CLOSED)SDR UPS04841856Finger Doubler · corrodedINSPECTION TYPE: C3, INTERNAL FINGER DOUBLER IS CORRODED BEYOND LIMITS STATION 1260-1350 LONGERON 31R. REMOVED, FABRICATED AND REPLACED FINGER DOUBLER IAW SRM 53-4-1 FIG 17A, 51-1-20D, 51-1-21.SDR 2004UALA00101Skin · lightning strikeLIGHTNING STRIKE ON EXTERIOR FUSE SKIN APPROX 2.5 INCH FWD OF BS 560 STR 2R. MAJOR REPAIR ACCOMPLISHED. INSTALLED DOUBLER REPAIR.SDR COMA0460118Skin · bentPREVIOUS REPAIR TO LEFT SIDE FUSELAGE SKIN HAS SUBSTAINED FURTHER DAMAGE. PERFORMED A MAJOR REPAIR BY REMOVING DAMAGED REPAIR DOUBLER AND FILLER, FABBING NEW REPAIR DOUBLER AND FILLERS FROM 2024T3-050 PO 29672 AND 2024T3.063 PO 16956 AND INSTALLED REPAIR PARTSDR SWAA040340Skin · crackedDURING SCHEDULED PM CHECK, FOUND SKIN CRACKED AT BS 980, STRINGER 23 L. REPAIRED SKIN PER SRM.SDR COMA0460104Skin Panel · crackedRIGHT SIDE LOWER FUSELAGE SKIN IS CRACKED AT NOSE LANDING GEAR CUTOUT AT FS 235 STR 26R CRACK IS 1.0 INCH LONG. PERFORMED A MAJOR REPAIR BY CUTTING OUT DAMAGED AREA, FABBING REPAIR FILLER AND DOUBLERS FROM 2024T3.050, PO 29672/1, 2024T3.063, PO 32532 AND 2024SDR TSAA0453028Skin · crackedTRIMMED OUT DAMAGED AREA. HFEC VERIFIED CRACK REMOVED. FABRICATED DOUBLER. ALODINED AND PRIMED ALL BARE SURFACES. INSTALLED REPAIR PARTS MAKING A FAYING SEAL AROUND REPAIR. REPAIR COMPLETED IAW ECO 2840R2, DEVIATION C. AIRCRAFT RETURNED TO SERVICE. (M)SDR USAA040011Skin · crackedPIT - FOUND SKIN CRACKED .5 INCH, BS 727D AND S22L. CUT OUT DAMAGED AREA AND INSTALLED AN EXTERNAL DOUBELR PER SRM 53-00-01 FIG 229. (M)SDR UPS04441903Skin · misrepairedINSPECTION TYPE: C, DURING WORK ACCOMPLISH FOR RAP, ITEM N672-46-28 AT BS 1960-1975 STR 45R-47R EXISTING PATCH FOUND NOT MATCH WITH SRM 53-30-03 FIG 19 AS PROVIDED BY CUSTOMER RE-DO THE REPAIR REQUIRE. EXPANDED DOUBLER REPAIRED AS PER SRM 53-30-03 FIG 48 AT SDR UPS04441901Doubler · damagedINSPECTION TYPE: C, RAP ITEM N672UP 42-11 AT BS 680-703 STR 40R-41R AREA, REPAIR DOUBLER HAS LESS THAN 3 ROW FASTENERS FOR REPAIR AFTER NDT DEFINED CUTOUT RE-DO THE REPAIR REQ'D. BS 680-703 STR 40R-41R AREA DOUBLER REMOVED & DISCARDED AS PER SRM 51-30-02 BS 6SDR QXEA200400122Skin · corrodedPDX - FUSELAGE SKIN SURFACE UNDER LOWER TCAS ANTENNA HAS CORROSION. REPAIRED IAW HORIZON AIR EA 2-53-540.SDR 04FDEA00285Skin · corrodedCORROSION IN FWD CARGO BAY, CORROSION ON INNER SURFACE OF SKIN STA 684 BETWEEN STR 27 LT AND 28 LT. FOUND CORROSION ON SKIN AT BS 684, STR 27L AND 28L TO BE .015 DEEP X 4 X 6 INCHES FROM AN ORIGINAL THICKNESS OF .050 AND IS OUT OF LIMITS IAW SRM 53-30-3. CUT SDR 373PA0035Panel · crackedFWD, CENTER, AND AFT PANELS OF THE AFT CARGO DOOR THRESHOLD ARE CRACKED. REPAIRED PER SPM 20-3 AND BOEING PROCESS SPEC BAC5975.SDR TSAA0453025Skin · crackedTRIMMED OUT DAMAGED AREA. HFEC VERIFIED CRACK REMOVED. FABRICATED DOUBLER. ALODINED AND PRIMED ALL BARE SURFACES. INSTALLED REPAIR PARTS MAKING A FAYING SEAL AROUND REPAIR. REPAIR COMPLETED IAW SRM 53-30-3, FIGURE 48, DETAIL X. AIRCRAFT RETURNED TO SERVISDR UPS04841921Skin · corrodedINSPECTION TYPE: C3, FUSELAGE SKIN IS CORRODED BEYOND LIMITS AT STATION 1265 AT LONG 36. CUT OUT DAMAGED AREA, FABRICATED AND INSTALLED DOUBLER, FILLER AND FINGER DOUBLERS IAW SRM 53-2-1 FIG 7.SDR A6WA200440014Skin · damagedFOUND SKIN DAMAGED, LEFT SIDE OF AIRCRAFT AT FS 682 TO FS 718 BETWEEN STRINGERS 16L AND 18L. (M)SDR MALA040183Skin · dentedDURING 4K INSPECTION IN LCQ, RT FUSELAGE STA 329 HAS DENTS. CUT OUT DAMAGED AREA, FABRICATED AND INSTALLED A DOUBLER REPAIR IAW SAAB 340 SRM 53-70-10-2. A/C RELEASE DATE 2/16/04. REFER TO NR 1258951 FOR FURTHER DETAIL.SDR DHL2004806571Skin · wornNOSE SECTION EXTERIOR SKIN WORN (STA 8.000 - 25.000, L-15L TO L-17L) HOLD OPEN HOOK COMPT (MAJOR REPAIR). PERFORMED MAJOR REPAIR. REMOVED FASTENERS IAW SRM 561-1-21 PG 1, SRM 51-3-0 PG 1. TRIMMED OUT AND REMOVED DAMAGED AREA IAW ED-EDU80-17, DWG U80-R17. PSDR ASAA0480056Skin · dentedOKC - DURNG 15K CHECK, FOUND FUSELAGE SKIN IS DENTED AT FS 237. INSTALLED DOUBLER PER SRM 53-04. (M)SDR ASAA0480055Skin · gougedOKC - DURING 15K CHECK, FOUND FUSELAGE SKIN IS GOUGED AT STATION 235. REMOVED DAMAGED SECTION. REPAIRED WITH FILLER AND DOUBLER PER SRM 53-04. (M)SDR AUS20040047Doubler · corroded(AUS) FUSELAGE DOUBLER LOCATED AT RT EMERGENCY EXITS, BADLY CORRODED.SDR SWAA040301Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 947, STRINGER 21R. REPAIRED SKIN PER EA.SDR ABXA040056Finger Doubler · corrodedFORWARD CARGO LOWER LEFT SKIN FINGER DOUBLER CORRODED UNDERNEATH FROM STA 200 TO 220, LONGERON 35 LEFT TO 33 LEFT, BUTTLINE 7 TO BUTTLINE 20. REPAIRED AREA IAW REA D853-48505MR.SDR AWXA200400137Skin · crackedPHX - MAJOR REPAIR - DURING 8-DAY CHECK A 3 INCH CRACK WAS FOUND IN FUSELAGE SKIN JUST AFT OF WING TO BODY FAIRING BETWEEN BS 727D AND 727 E, AT STR 23 LT. MAINTENANCE CUT OUT DAMAGED SKIN AND PERFORMED A HFEC INSPECTION TO VERIFY NO CRACKS EXIST; FABRICATED SDR 0400279862Skin · crackedDURING "L" CHECK FOUND CRACK IN FUSELAGE SKIN AT BS 69.55 3.5 INCHES BELOW L14L. REPAIRED IAW EA 98-197450.SDR SWAA040291Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACK AT BS 920, BETWEEN STRINGERS 24R AND 25R. REPAIRED SKIN PER SRM.SDR MALA040176Skin · corrodedDURING INSPECTION IN LCQ, TCAS ANTENNA SKIN MATING SURFACE HAS EXFOLIATION CORROSION AND DOUBLER IS DISBONDING. MAINTENANCE REMOVED CORROSION FROM SKIN MATING SURFACE, REMOVED AND REPLACED TCAS ANTENNA DOUBLER AND INSTALLED REPAIR DOUBLER IAW MESABA, EO S5319SDR CALA0400067Skin · damagedINSPECTION FOUND FUSELAGE SKIN DAMAGED ON FORWARD CURVED SIDE AT RIGHT AFT HORIZONTAL STABILIZER ATTACH POINT. THE SKIN WAS REPLACED IAW SRM 51-40-2.SDR SWAA040280Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 932, STRINGER 24L. REPAIRED SKIN PER SRM.SDR DL73S040100Skin · damagedSCRIBE MARKS WERE NOTED IN THE LOWER SKIN AT THE S10L LAP SPLICE BETWEEN BS 259 AND 291. DAMAGE WAS REMOVED AND REPAIRED PER ERA 386027-14.SDR DL73S040096Skin · damagedA GOUGE WAS NOTED ON THE UPPER SKIN LAP SPLICE AT S26R AT BS 440. DAMAGE WAS REMOVED AND REPAIRED PER ERA 386070-14.SDR DL73S040095Skin · crackedDURING CROWN INSPECTION FOUR FASTENERS HOLES WERE NOTED WITH CRACK INDICATIONS. DISCREPANCIES WERE REPAIRED PER ERA 386057-14AD.SDR UPS04841869Skin · corrodedINSPECTION TYPE:C3 FUSELAGE SKIN IS CORRODED BEYOND LIMITS STATION 1690-1700 LONG 35L-35R. CUT OUT DAMAGE, NDT VERIFIED NO CRACKS AT CUTOUT. FABRICATED AND INSTALLED FILLER, DOUBLER AND FINGER DOUBLERS IAW SRM 53-2-1 FIG 7.SDR 04FDEA00233Skin · damagedRT EXTERIOR FUSELAGE SKIN HAS CREASE AT BS 1143 STR 18R TO 3 INCHES BELOW STR 19R. DAMAGE ON EXTERNAL SKIN BS 1143 STR 18R TO 3" BELOW STR 19R A/Y RATION=76 AREA FOUND TO BE WITHIN LIMITS PER SRM 53-30-1 FIG 1 EXCEPT AT STR 19R. FOUND TO BE OUT OF LIMITS PER
Back to JASC 5330