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 USAA040014Skin · crackedCLT - FOUND SKIN CRACKED .008 INCH, FS 727E JUST BELOW S24L. INSTALLED DOUBLER PER SRM 53-00-01. (M)SDR DHL2004365507Skin · damagedREPAIR AT RIGHT FUSE FR19 STR 23R GOUGED. REMOVED EXISTING DOUBLER AT RIGHT FUSE FR19 STR23R IAW A300 SRM 51-30-30. SMOOTHED OUT FUSELAGE SKIN SECTION NEXT TO DOUBLER AREA AS PER A300 SRM 51-40-11. MAXIMUN MATERIAL LOSS-.011 ORIGINAL THICKNESS 0.63 FOUND TOSDR HNAA0400004Skin · corrodedR/S UNDERFLOOR STR 27 BETWEEN REAR SPAR FRAME AND X467 WAFFLE DOUBLER IS DEPARTING SKIN PANEL.SDR DHL2007806543Skin · crackedEXTERNAL FUSELAGE FWD SVC DOOR JAMB FWD UPPER CORNER CRACKED 1.000 AT STA 160.000 L-11R - L-12R (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW SRM 53-2-0 FIG 14 SHEET 3, TR 53-181, DWG SRO8530021, DWG 5750776. REMOVED FASTENERS IAW SRM 51-1-21 PG 1. TRIMMED OUTSDR SWAA040137Skin · crackedDURING SCHEDULED C2 CHECK, FOUND SKIN CRACKED AT BS 823, STRINGER 23L. REPAIRED SKIN CRACK PER SRM.SDR SWAA040133Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN BUTT STRAP CRACKED AT BS 360, STRINGER 10L. REPAIRED BUTT STRAP PER SRM.SDR ASAA0410020Skin Panel · corrodedOKC - DURING SCHEDULED D-CHECK, FOUND THE INTERNAL SKIN PANEL AT FUSELAGE STATION 382, STRINGER 28R-28L CORRODED. REPAIRED SKIN PANEL PER EA. (M)SDR ASAA0410019Bear Strap · damagedOKC - DURING SCHEDULED D-CHECK, REPLACED INTERIM REPAIR TO THE BEAR STRAP AT FUSELAGE STATION 259-277, LEFT BUTTOCK LINE 15.47. REPAIRED BEAR STRAP PER EA. (M)SDR DL764040031Skin · dentedTHE FUSELAGE SKIN WAS DENTED BY GROUND EQUIPMENT NEAR FS 1367 AND STRINGER 29R. THE DAMAGE WAS REMOVED WITH A CUTOUT IN THE SKIN AND REPAIRED WITH 2 EXTERNAL ALUMINUM REPAIR DOUBLERS PER ER/A 088020-14, REV B.SDR ARWA20040101Skin · damagedDURING A-CHECK INSPECTION, THE FOLLOWING WAS FOUND, FUSELAGE EXTERIOR STA 1690 BETWEEN L-35R AND L-36 SKIN BROKEN, NEAR BUTT JOINT. PERFORMED REPAIR OF THE SKIN NEAR BUTT JOINT AT STA 1690, BTW LONGERON 35R & 36R IAW DC8SRM 53-2-1, FIG8, SHEET 1,2, PAGES 123/SDR DHL2004806541Skin · crackedUPPER FUSELAGE EXTERIOR SKIN WITH 1.000 CRACK IN IT (STA 1742.000-1743.000, L-16R TO L-17R), MAJOR REPAIR. PERFORMED MAJOR REPAIR IAW SRM 53-2-1 FIG 7, SRM 53-5-3 FIG 1. REMOVED FASTENERS IAW SRM 51-1-21 PG 1. CUT OUT DAMAGED SKIN AREA AND FABRICATED FILLERSDR SWAA040128Skin · crackedDURING SCHEDULED SC, FOUND SKIN CRACKED AT BS 515 TO BS 517 AT STRINGER 12L. REPAIRED SKIN CRACK PER SRM.SDR SWAA040126Skin · crackedDURING SCHEDULED C2 CHECK, FOUND SKIN CRACKED AT BS 737, STRINGER 19R. REPAIRED SKIN CRACK PER SRM.SDR SWAA040120Skin · crackedDURING SCHEDULED RON, FOUND SKIN CRACKED AT BS 740, STRINGER 20R. REPAIRED SKIN CRACK PER SRM.SDR SWAA040118Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND SKIN CRACK AT BS 761, STRINGER 19R. REPAIRED SKIN CRACK PER SRM.SDR SWAA040129Skin · crackedDURING SCHEDULED PMC, FOUND SKIN CRACKED AT BS 757, STRINGER 18R. REPAIRED SKIN CRACK PER SRM.SDR 2004UALA00029Skin · dentedDENT ON LEFT SIDE OF FUSELAGE, MEASURES .125 INCH DEEP BY 3 INCH WIDE, LOCATED AT BS 610 BETWEEN STR 15L-16L JUST BELOW WL 208. MAJOR REPAIR ACCOMPLISHED. INSTALLED DOUBLER REPAIR.SDR SWAA040115Skin · crackedDURING SCHEDULED SC, FOUND SKIN CRACK AT BS 487, STRINGER 17R. REPAIRED SKIN CRACK PER SRM.SDR SWAA040114Skin · crackedDURING SCHEDULED SC, FOUND SKIN CRACKED AT BS 960, WL 185 LT SIDE. REPAIRED SKIN CRACK PER SRM.SDR SWAA040113Skin · crackedDURING THRU FLIGHT CHECK, FOUND SKIN CRACKED AT BS 520, STRINGER 16L. REPAIRED SKIN CRACK PER EA.SDR 2004FA0000181Skin Panel · crackedON INSPECTION, FOUND CRACKS .50 INCH LONG ON BOTH RT AND LT SIDES, ON BOTTOM OF STABILIZER, HOLE CUTOUTS ONE INCH AFT BULKHEAD N 14. STOP DRILLED AND REPAIR WITH PLATS OF 2024T3 .050 ALUM. IAW AC.SDR MALA040128Shield · dentedDURING 4K INSPECTION IN LCQ, NUMEROUS DENTS ON LT FWD NR 3 ICE SHIELD. MAINTENANCE CUT OUT DAMAGED AREA, FABRICATED AND INSTALLED REPAIR PLATE IAW MESABA EO NR S53005 DATED 24 FEB 1999.SDR DHL2004806545Skin · crackedAFT SERVICE DOOR JAMB WITH 1.000 INCH CRACK IN UPPER FWD CORNER, STA 1620.000 L-11R TO L-12R (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW SRM 53-2-0 FIG 17 SHEET 3, DWG SRO8530021, DWG 5750776, TR 53-184. REMOVED FASTENERS IAW SRM 51-1-21 PG 1. CUT OUT DAMAGESDR SWAA040102Skin · crackedDURING SCHEDULED C1 CHECK, FOUND 4 EACH SKIN CRACKS AT BS 480, STRINGER 16R, BS 270, STRINGER 9C, BS 500D, STRINGER 15L AND BS 578, STRINGER 10R. REPAIRED SKIN CRACKS PER SRM.SDR DL73S040021Skin · dentedTHE FUSELAGE SKIN WAS FOUND DENTED FROM BS 328 TO BS 344, BETWEEN S20R AND S21R. DENT WAS REPAIRED PER ERA 386008-14.SDR MALA040129Skin · dentedDURING 4K INSPECTION IN LCQ, EXTERIOR FUSELAGE HAS DENTS AT FS 350. MAINTENANCE FABRICATED AND INSTALLED 2 EACH EXTERNAL DOUBLER REPAIRS IAW MESABA EO NR S53009 DATED 21 SEPT 2001.SDR SWAA040092Buttstrap · crackedDURING SCHEDULED 1/2D CHECK, FOUND CRACK AT FASTENER HOLE ON BUTT SPLICE STRAP AT BS 908, BELOW STRINGER 4L. REPAIRED BUTT STRAP SPLICE PER SRM.SDR SWAA040089Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACK AT BS 440 + 6, STRINGER 16R. REPAIRED SKIN CRACK PER SRM.SDR ASAA0410016Skin · damagedOKC - DURING SCHEDULED D-CHECK, A PREVIOUS SKIN REPAIR WAS NOT CONFIGURED TO THE CURRENT AND REVISED SRM AT FUSELAGE STATION 344, STRINGER 19R. (M)SDR DL73S040020Skin · crackedTHE FUSELAGE SKIN IN THE KEEL AREA BETWEEN FS 661 & 727 WAS FOUND WITH CRACKS AT SEVERAL OF THE ACCESS CUTOUTS IN THE PANEL. THE CRACKING IS TYPICAL OF BAC S/B 737-53-1104. THE SKIN PANEL WAS REMOVED AND A MODIFIED PANEL MANUFACTURED AND INSTALLED. THE REPASDR 0400259918Skin · crackedDURING L-CHECK FOUND CRACK IN FUSELAGE SKIN AT BS 76.55 RBL 16. REPAIRED PER EA 99-197447.SDR CALA0400072Skin · dentedINSPECTION FOUND A DENT IN FUSELAGE SKIN AT BS 420 BELOW S17L. THE SKIN WAS REPAIRED IAW ECRA 5331-01133.SDR SWAA040083Skin · crackedDURING SCHEDULED C4 CHECK, FOUND SKIN CRACKS AT BS 520, STRINGER 10R AND BS 747, STRINGER 23R. REPAIRED SKIN CRACKS PER SRM.SDR DHL2004753503Skin · crackedDURING C-CHECK, FWD ENTRY DOOR (L1) LWR HINGE CUTOUT CRACKED NDT VERIFIED BS 310. REMOVED FASTENERS PER ACCESS AT FWD ENTRY DOOR LOWER HINGE IAW B-727 SRM 51-30-2. CUT OUT DAMAGE AREA DIM APPROX 1 INCH X BY .375 INCH IAW S/B 727-53-0198. PART MADE FROM P/N SDR QXEA200400005Skin · dentedPDX- DENT IN FUSELAGE SKIN PANEL BETWEEN STATION X312.35 AND X333.3 AND STRINGERS 11P AND 12P. REPAIRED IAW HORIZON AIR EA 2-53-186A.SDR ASAA0410013Skin Panel · dentedOKC - DURING SCHEDULED D-CHECK, FOUND THE SKIN PANEL AT FUSELAGE STATION 350, STRINGER 24L DENTED. REPAIRED SKIN PANEL PER SRM. (M)SDR DHL2004806535Skin · crackedFUSELAGE NOSE SECTION EXTERIOR SKIN CRACKED 0.250 AT STA 53.000 L-30L (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW SRM 53-2-0 FIG 13. REMOVED EXISTING REPAIR IAW SRM 51-1-20D PG 21. TRIMMED OUT CRACKED AREA IAW SRM 53-2-0 FIG 13. FABRICATED FILLER (2024T3AL SDR SWAA040071Skin · crackedDURING SCHEDULED SPV, FOUND SKIN CRACKED AT BS 432, STRINGER 16L, BS 777, STRINGER 18L, BS 933, STRINGER 24L. REPAIRED SKIN PER SRM.SDR SWAA040067Buttstrap · crackedDURING SCHEDULED 1/2D CHECK, FOUND BUTTSTRAPS CRACKED AT BS 360 STRINGER 14L, BS 908, BETWEEN STRINGERS 15L AND 16L. REPAIRED STRAPS PER SRM.SDR QXEA200400031Skin · scratchedPDX - SCRATCHES IN FUSELAGE SKIN UNDER AFT SIDE OF 262DT. REPAIRED IAW HORIZON AIR EA 2-53-530.SDR DHL2004752509Skin · crackedDURING C-CHECK, FUSELAGE SKIN CRACK AT FWD ENTRY DOOR LOWER HINGE CUT OUT, VERIFIED BY NDT INSP. CUT OUT DAMAGED AREA DIM 1.625 X 1 INCH AND FABBED FILLER FROM 2024-T3 .080 PO 900474 DIM 1.625 X 1 INCH AND DOUBLER FROM 301 1/2 HD .063 PO 900125 DIM 15.75 X 6 SDR 2004UALA00016Skin · damagedFWD CARGO DOOR CUTOUT UPPER FWD CORNER SKIN IS BENT. MAJOR REPAIR ACCOMPLISHED. INSTALLED DOUBLER REPAIR.SDR COMA0460030Skin · damagedREPAIR FUSELAGE DAMAGE FROM FS 280.0 TO FS 379.0 DAMAGED STRINGERS 25R, 24R AND 23R; FRAME DAMAGE AT FS 349.00 BETWEEN STRINGER 23R AND 24R AND AT FS 319.70 BETWEEN STRINGER 25R AND 26R. REMOVED DAMAGED SKIN AND STRINGERS AND FRAMES IN AREA OF DAMAGE. INSTALSDR USAA040026Skin · corrodedPIT - FOUND SKIN CORRODED 1 INCH BY 1 INCH AREA, STATION 106, LBL 13 AFT CARGO INTERIOR BELLY SKIN. BLENDED CORROSION AREA TO INSURE CONTAINMENT OF CORROSION PER EA 95089. (M)SDR USAA040015Skin · crackedCLT - FOUND SKIN CRACKED 6.250 INCH, FS 500D PLUS 3 INCHES JUST BELOW S15R. INSTALLED DOUBLER PER SRM 53-00-01. (M)SDR ASAA0410007Skin · damagedOKC - DURING SCHEDULED D-CHECK, A PREVIOUS SKIN REPAIR WAS NOT CONFIGURED TO THE CURRENT AND REVISED SRM AT FUSELAGE STATION 927, STRINGER 20R. REMOVED PREVIOUS REPAIR AND REPLACED THE NEW REVISED SRM REPAIR. (M)SDR ASAA0410008Skin Panel · dentedOKC - DURING SCHEDULED D-CHECK, FOUND THE SKIN PANEL AT FUSELAGE STATION 440-455, STRINGER 25R DENTED. REPAIRED SKIN PANEL PER EA. (M)SDR DLM88040010Skin · crackedA CRACK WAS FOUND IN THE UPPER, FWD CORNER OF THE C-1 DOOR JAMB IN BOTH THE SKIN AND ALUM DOUBLER. A TYPICAL SRM REPAIR ALSO EXISTS IN THE NEARBY AREA. NEW DAMAGE AND OLD DAMAGE INCORPORATED INTO ONE REPAIR PER ERA 386012-14.SDR UPS04841823Doubler · misrepairedINSPECTION TYPE: C1, L1 DOOR UPPER FWD CORNER REPAIR IS NOT PER SRM. REMOVED EXISTING DOUBLERS ABOVE L1 DOOR UPPER FWD CORNER IAW DC8 SRM 51-1-21. FABBED -15 & -17 DOUBLERS IAW DC8 SRM 53-2-0 FIG 15, TR 53-182. ALODINED & PRIMED IAW DC8 SRM 51-1-8. INSTALLSDR DHL2004F00000Skin · misrepairedDURING C-CHECK, VERIFY CONFORMITY OF EXTERNAL REPAIR BS 259-264 STR 11L-12L 5 X 6 INCH DIM. REMOVED FASTENERS AND EXTERNAL REPAIR BS 259, 264, STR 11L-12L IAW B-727 SRM 51-30-2. FABRICATED NEW DOUBLER, MATERIAL USED 2024 T-3 .050, PO 900414. DIMENSION 7.75
Back to JASC 5330