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 SWAA073120Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 745, STR 25R. REPAIRED SKIN PER SWA EA.SDR USAA070470Skin · crackedAFT ENTRY DOOR LOWER HINGE SKIN CUTOUT HAS CRACK. REMOVED DAMAGE & INSTALLED FABRICATED REPAIR PARTS PER TR 53-60-10, DEFECT SIZE: 2 INCHES.SDR QXEA200701112Skin · dentedC3 OKC - REPAIR DENT IN FUSELAGE SKIN PER REO 670-53-11-228. REPAIRED IAW REO 670-53-11-228.SDR QXEA200701114Skin · corrodedC3 OKC - FORWARD LOWER FUSELAGE SKIN UNDER LOWER ADF ANTENNA AROUND RIGHT AFT MOUNT HOLE THERE IS CORROSION. REPAIRED IAW SRM 51-21-06, 53-22-21, 51-21-11.SDR DLM90070876Skin · dentedFOUND FUSELAGE SKIN DENTED AT LONG 17 LT STA 220 ON LONGERON. REPAIRED SKIN IAW MD90 SRM 51-30-01 FIG 5 VOL I.SDR ASAA0791825Skin · gougedFUSELAGE SKIN GOUGED 22 INCHES AFT OF L2 DOOR 18 INCHES UP FROM BOTTOM OF L2 DOOR CUTOUT. TEMP REPAIR INSTALLED PER ASA EA 5330 02215.SDR 2007UALA02159Skin · crackedPASSENGER CABIN BELOW FLOOR LEVEL BD 663 LBL 32, PRESSURE DECK UPPER SKIN CRACKED. MAJOR REPAIR ACCOMPLISHED: FABRICATED & INSTALLED DOUBLER/FILLER REPAIR.SDR 07FDEA02252Skin · corrodedFWD LOWER FUSELAGE BELLY SKIN, BS 680 TO 740 STR 26L TO S-26R NEEDS TO BE REPLACED DUE TO MULTIPLE AREAS OF CORROSION AND DAMAGES. [08-29-07] BELLY SKIN AT STA. 680 TO 740, BETWEEN STR 26L TO 26R, WAS REMOVED. NEW SKIN WAS DRILLED UP TO MATCH EXISTING STSDR UIEA200700255Panel · corrodedLOWER FUSELAGE CENTER PANELS 191HH AND 191JJ BETWEEN NR 1 AND NR 3 ACM'S HAVE AREA OF CORROSION. PERMANENT REPAIR WAS ACCOMPLISHED AS PER 747-200 SRM 51-40-02 FIG 1. ALSO, REFERENCE ATLAS AIR XEO NR 53-062007.SDR 07FDEA02234Skin · cracked1 CRACK LONG 1" ON EXT SKIN LOWER AT STA 485 RT SIDE DOOR FWD W/W REPAIRED IAW SRM 53-50-00 FIG 25 VOL 1.SDR 07FDEA02233Skin · misrepairedEXISTING REPAIR EXT FUS FROM STA 1901 TO 1921 BETWEEN LONGERONS 37 LT AND 35 LT REPAIRED IAW SRM 53-20-00 FIG 6 VOL I.SDR QXEA200701044Skin · dentedC4 PDX - THERE IS A DENT AND SCRATCH ON THE TOP OF FUSELAGE AFT OF X222 APPROXIMATELY 3" BETWEEN STRINGERS 5R AND 6R. REPAIRED IAW DHC 8 SRM 51-20-16 AND 1-20-41.SDR DLM88070810Skin · corrodedSURFACE CORROSION ON INNER FUSELUGE SKIN BETWEEN STA 244 AND LONGERONS 29-30 LT. REPAIRED PER DWG 5936434 ON N/R T0059277 HMV/GDL.SDR DLM88070808Skin · crackedCRACKED FUSELAGE SKIN AROUND FASTENERS AT STA 1380 LONG 14 RT. REPAIRED PER SRM 53-04D FIG 18 ON N/R T0059314 HMV/GDL.SDR 2007UALA02123Skin · gougedFWD UPPER FUSELAGE CROWN AT STA 290 STR 2L SKIN IS GOUGED. MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGE. FABRICATED AND INSTALLED DOUBLER, TRIPLER AND FILLER.SDR 2007UALA02122Skin · crackedEXTERNAL FUSELAGE SKIN CRACKED BS 470 STR 14R. MAJOR REPAIR ACCOMPLISHED: CUT OUT DAMAGED SECTION. INSTALLED DOUBLER/FILLER REPAIR.SDR DL738070756Skin · gougedAIRCRAFT STUCK BY GROUND EQUIP AT FS 904, S-23R LAP JOINT. SKIN CUT OUT, DOUBLER INSTALLED. UNDERLYING STRUCTURE REMOVED AND REPLACED.SDR SWAA073060Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 271, STR 15L. REPAIRED SKIN PER SWA EA.SDR SWAA073077Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 925, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA073076Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 415, STR 16L. REPAIRED SKIN PER SWA EA.SDR SWAA073067Skin · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT BS 410, LBL 1. REPAIRED SKIN PER SWA EA.SDR GLBA20060957Blade · damagedEXTENDED ROLLOUT, UPON LANDING, PILOTS REPORTED THAT DUE TO LANDING ROLLOUT BEYOND THE END OF THE RUNWAY, THE RT PROP NR 2 ENGINE STRUCK A RECTANGULAR BOX. PRELIMINARY DAMAGE INDICATES PROP BLADE DAMAGE AND HOLE IN FUSELAGE. [08-01-07] MX INSTALLED TEMP RESDR MASA200700377Skin · damagedFS 310 HAS DAMAGE ON PREVIOUS SKIN REPAIR. PERFORMED A PERMANENT REPAIR TO FUSELAGE SKIN FS 310 STR 16-17.SDR SWIA200718531Skin · damagedFOUND ONE RIVET DAMAGED BY LIGHTNING AT FS 1098.2 JUST FORWARD OF THE EQUIPTMENT BAY DOOR, DISCOVERED AT C-CHECK. REMOVED AND INSTALLED NEW RIVET IAW CRJ700/900 SRM 51-42-06-001-001-A01.SDR ZZDA070619191Doubler · corrodedAFT CARGO COMPARTMENT REAR LAVATORY DUMP DOUBLER CORROSION ON LT LOWER EDGE FROM STA 1022 TO 1037 AND BETWEEN LONGERON 23 TO LONGERON 25. INSTALLED REAR LAVATORY DUMP DOUBLER AT AFT CARGO COMPARTMENT STA 1022 TO 1037 AND BETWEEN LONGERON 23L AND LONGERON 25L SDR UPS07850095Skin · crackedINSPECTION TYPE:C3 FUSELAGE EXTERIOR SKIN CRACKED AT STA 1742 L17L. CUT OUT DAMAGED AREA OF FUSELAGE SKIN AT STA 1742 L17L IAW SRM 53-02-01-0 FIG 7. FABRICATED AND INSTALLED REPAIR DOUBLER, FINGER DOUBLER, AND FILLERS AT STA 1742 L17L IAW SRM 53-03-02-0 FIG SDR VNAA0706012Skin · damagedCREW REPORTED ON DESCENT A LIGHTNING STRIKE. MAINTENANCE COMPLIED WITH AN EN ROUTE AND DETAILED LIGHTNING STRIKE INSPECTION. MAINTENANCE INSPECTED AND FOUND EVIDENCE OF A STRIKE TO THE LOWER RIGHT FORWARD FUSELAGE. MAINTENANCE FOUND ALL DAMAGE TO BE WITHIN SDR 2007UALA02121Skin · damagedEXTERNAL FUSELAGE SKIN FRAME 23LT AT STR 10LT TO STR 11LT IS DAMAGED. MAJOR REPAIR ACCOMPLISHED: INSTALLED DOUBLER REPAIR.SDR 2007UALA02120Skin · damagedEXTERNAL FUSELAGE SKIN FRAME 22LT AT STR 12LT TO STR 13LT IS DAMAGED. MAJOR REPAIR ACCOMPLISHED: INSTALLED DOUBLER REPAIR.SDR DLM88070750Skin · dentedTWO SKIN DENTS AT FS 1193 BETWEEN L-29L AND L-30. REPAIRED WITH AN INTERNAL FINGER DOUBLER AND EXTERNAL SKIN DOUBLER. DTA RESTRICTION OF 8000 CYCLE INSPECTION INTERVALS APPLIES TO THIS REPAIR.SDR COMA0760446Skin · crackedFUSELAGE SKIN AFT OF NOSE LANDING GEAR CUTOUT AT RIGHT RADIUS IS CRACKED. REPAIRED FUSELAGE SKIN AFT OF NOSE LANDING GEAR CUTOUT RIGHT SIDE, IAW REO 601R-53-11-048.SDR WRNA200700043Skin · damagedDURING -B- CHECK, OUT OF LIMIT LIGHTNING STRIKE DAMAGE WAS FOUND BETWEEN BS 765 & 775 AT LBL 4.5. DRILLED OUT DAMAGE IAW SRM 53-30-03 FIG 3A AND INSTALLED RIVETS IAW SRM 51-30-02. THIS IS A CATEGORY-C REPAIR AND REQUIRES INSPECTION AT 1,000 CYCLES.SDR SWAA073057Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SWA EA.SDR SWAA073053Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 747, STR 19R. REPAIRED SKIN PER SWA EA.SDR SWAA073049Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 386, STR 17R. REPAIRED SKIN PER SWA EA.SDR SWAA073051Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 482, STR 10L. REPAIRED SKIN PER SWA EA.SDR ASAA0781792Skin · dentedRIGHT EXTERNAL FUSELAGE MULITPLE PROTRUDING DENTS. CUT OUT DAMAGED AREA, FABRICATED A REPAIR DOUBLER, STRIP DOUBLER FILLERS AND INSTALLED IAW SRM 53-04 FIG 12B.SDR 07FDEA02210Skin · crackedLOWER EXTERNAL SKIN IS CRACKED AT BS 1082, RBL 4. R EMOVED SURROUNDING STRUCTURE TO ACCESS DAMAGE. REMOVED DAMAGE, NDT VERIFIED DAMAGE REMOVAL, NO DEFECTS. INSTALLED DOUBLER AND FILLER WHERE DAMAGE WAS REMOVED. INSTALLED SURROUNDING STRUCTURE REF SRM 51-3SDR 07FDEA02188Doubler · corrodedUPPER SKIN PANEL C87 RT JOINT STRAP DOUBLER WITH CORROSION REPAIR PERFORMED BY BLEND OUT THE CORRODED AREA IAW EA 6-54319-112442 AND RAS/DAHAM/4022370/2007 ISS. B.SDR CA070705007Skin · cracked(CAN) A (5) INCH CRACK WAS DISCOVERED IN THE SKIN AT APPROX F/S 584.50 AND W/L100. CAUSE AT THE TIME IS NOT KNOWN AND IS UNDER FURTHER INVESTIGATION. (TC NR 20070705007)SDR CA070705006Skin · cracked(CAN) A 3 INCH CRACK WAS DISCOVERED IN THE SKIN. CAUSE AT HIS TIME IS UNKKOWN AIND IS UNDER FURTHER INVESTIGATRION (TC NR 20070705006)SDR A6WA2007410323Skin · crackedNLG AFT DOOR CUTOUT CRACKED IN LT AND RT RADIUS .5 INCH EACH SIDE. MAINTENANCE REPAIRED CRACKED AREAS IAW REO 601R53-11-010, REV C. (K)SDR A6WA200740323Skin · crackedNLG AFT DOOR CUTOUT CRACKED IN LT AND RT RADIUS .5 INCH EACH SIDE. (K)SDR ZZDA070618190Skin · corrodedAFT CARGO COMPARTMENT AREA FUSELAGE SKIN, EXTERNAL SURFACE HAS CORROSION BETWEEN STA 860 AND 880 AND L-29L TO 27L. INSTALLED DOUBLER REPAIR AT AFT CARGO COMPARTMENT BETWEEN STA 851 AND STA 874 AS PER AIRTRAN EA 1753-00542 IR. MATERIAL USED .063 7075T6, 7.0 XSDR ZZDA070618189Skin · corrodedAFT CARGO COMPARTMENT, INNER SURFACE OF SKIN HAS CORROSION BETWEEN STA 813 AND 898.5 AND L 26L TO 25L LAP SEAM AREA. INSTALLED DOUBLER AND TRIPLER REPAIR AT AFT CARGO COMPARTMENT, INNER SURFACE SKIN BETWEEN STA 813 AND 898.5 AND L-26L AND L-25L IAW BOEING MESSDR 2007UALA02099Bear Strap · corrodedAFT PIT, BS 847, STR 26R, BEAR STRAP CORRODED ON UPPER SURFACE AND IS EMITTING CORROSION BETWEEN STRAP & SKIN (SKIN BULGING). MAJOR REPAIR ACCOMPLISHED: FABRICATED & INSTALLED SHEAR TIE DOUBLER REPAIR. BEAR STRAP REPAIR ACCOMPLISHED.SDR 2007UALA02098Skin · damagedRIGHT AFT LOWER FUSELAGE HAS A DENT APPROX 13 INCHES LONG BELOW AFT CARGO DOOR CUTOUT, 2 INCHES INBOARD OF STR 25R SKIN LAP BETWEEN BS 827-847. MAJOR REPAIR ACCOMPLISHED: CUT OUT DAMAGED SKIN & CORRODED BEAR STRAP. INSTALLED EXTERNAL SKIN DOUBLER-TRIPLER & SDR 2007UALA02097Skin · crackedUPPER FUSELAGE SKIN CRACKED AT CHEM-MILLED STEP BELOW STR 12L AT BS 518 TO BS 519. MAJOR REPAIR ACCOMPLISHED: FABRICATED & INSTALLED EXTERNAL DOUBLER REPAIR.SDR 2007UALA02096Skin · crackedFWD ENTRY DOOR UPPER HINGE CUTOUT IN FUSELAGE HAS ONE FASTENER HOLE WITH CRACK INDICATION LOCATED APPROXIMATELY 1 INCH BELOW FWD END OF UPPER HINGE CUTOUT. MAJOR REPAIR ACCOMPLISHED: FABRICATED & INSTALLED STAINLESS DOUBLER & FILLER.SDR 2007UALA02095Skin · crackedFWD ENTRY DOOR LOWER HINGE CUTOUT IN FUSELAGE HAS TWO FASTENER HOLES WITH CRACK INDICATIONS LOCATED APPROXIMATELY 1 INCH ABOVE AND 1 INCH FWD END OF LOWER HINGE CUTOUT. MAJOR REPAIR ACCOMPLISHED: FABRICATED & INSTALLED STAINLESS DOUBLER & FILLER REPAIR.
Back to JASC 5330