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 SWAA085746Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 445, STR 1. REPAIRED SKIN PER SWA EA.SDR SWAA085715Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 435, STR 1. REPAIRED SKIN PER SWA EA.SDR SWAA085682Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND R2 DOOR LOWER FWD FUSELAGE SKIN CUTOUT CRACKED. REPAIRED SKIN PER SRM.SDR SWAA085676Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER AAR EA.SDR SWAA085662Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA085661Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BETWEEN BS 415 TO BS 417, STR 1. REPAIRED SKIN PER SWA EA.SDR SWAA085723Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BETWEEN BS 967 TO BS 986, STR 20L. REPAIRED SKIN PER SRM.SDR SWAA085711Skin · crackedDURING SCHEDULED MV3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 947, STR 21L. REPAIRED SKIN PER SWA EA.SDR DLM88081390Skin · corrodedFUSELAGE SKIN CORRODED AT FS 636, LONGERON 29L - 29R. DAMAGED SKIN CUTOUT AND EXTERNALLY REINFORCED WITH A DOUBLER AND TRIPLER.SDR DL757081378Skin · corrodedCORROSION FOUND AT STA 570 TO 620 AT RBL 21.5 IN FWD CARGO BAY. REPAIRED ON NR CARD 00062 PER 51-40-05.SDR 08FDEA04440Skin · gougedLT FUSELAGE EXTERIOR SKIN AT FRAME 38.2 STRINGER 40L HAS A GOUGE MEASURING 1/2 INCH BY 1 INCH BY .015 INCH DEEP. CUT OUT DAMAGED SKIN AND INSTALLED A REPAIR DOUBLER AND FILLER IAW A300-600 SRM 53-10-12 FIG 207 SHT 3.SDR UPS08854163Skin · misrepairedINSPECTION TYPE:SV REPAIR SEQUENCE 803-F1-73 AT FS 1393.5 L17-18L HAS NO SRM REF. REMOVED REPAIR, FABRICATED AND INSTALLED REPAIR PARTS IAW UPS EO DC8-5330-31417-A AND FVCI DWG 53-08540-15.SDR SWAA085698Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND R2 DOOR LOWER FWD FUSELAGE SKIN CRACKED. REPAIRED SKIN PER SRM.SDR SWAA085621Skin · corrodedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER AAR EA.SDR SWAA085620Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR UPPER HINGE CUTOUT JUST ABOVE FWD END OF HINGE CUTOUT. REPAIRED SKIN PER AAR EA.SDR SWAA085619Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR UPPER HINGE CUOUT BELOW FWD END OF HINGE CUTOUT. REPAIRED SKIN PER AAR EA.SDR 08FDEA04429Skin · gougedLOWER FUSELAGE EXTERNAL SKIN FR 59 TO 61, STRINGER 44L - 45L HAS GOUGE 26" BY 1/4 INCH BY .052 INCH RUNNING JUST BELOW LAP SEAM REPAIRED AREA AT LOWER FUSELAGE EXTERNAL SKIN FR 59 TO 61, STRINGER 44L - 45L IAW SRM 53-10-12 FIG 217.SDR QXEA2008110501138Skin · damagedPDX - C1 - FWD FUSELAGE EXTERIOR ROOF SKIN HAS LIGHTNING STRIKE AT RIVET EDGE AND SKIN AT APPROX FS X38.000 AND STR LT 6. DRILLED OUT RIVET, ENLARGED COUNTERSINK TO REMOVE DAMAGE FROM SKIN REF RD 8/4-53-1039. HFEC AROUND FASTENER FOR CRACKS IAW Q400 NDTM PARSDR QXEA2008110501132Skin · damagedPDX - C1 - FWD FUSELAGE EXTERIOR ROOF SKIN HAS LIGHTNING STRIKE AT RIVET EDGE AND SKIN AT APPROX FS X-31.000 AND STR LT 3. DRILLED OUT RIVET, NO DAMAGE TO SKIN FOUND. PERFORMED HFEC AROUND REMOVED RIVET FOR CRACKS IAW Q400 NDTM PART 6, 51-00-01, NO CRACKS NOSDR QXEA2008110501130Skin · damagedPDX - C1 - FWD FUSELAGE EXTERIOR ROOF SKIN HAS A LIGHTNING STRIKE ON RIVET HEAD AT APPROX X-55.000 AND STR LT 5. DRILLED OUT RIVET, ENLARGED COUNTERSINK TO REMOVE DAMAGE FROM SKIN REF RD 8/4-53-1039. HFEC INSPECTED IAW Q400 NDTM PART 6, 51-00-01, NO CRACKS NSDR QXEA2008110501129Skin · damagedPDX - C1- POSSIBLE LIGHTNING STRIKE DAMAGE ON UPPER FUSELAGE AT APPROX STA 71.5, 5.5 INCHES LEFT OF STRINGER NR 1. DRILLED OUT RIVET THAT WAS DAMAGED AND COUNTERSUNK TO REMOVE DAMAGE IAW Q400 RD 8/4-53-1039. HFEC AREA IAW Q400 NDTM PART 6, 51-00-01, NO CRACSDR QXEA2008110501128Skin · damagedPDX -C1-POSSIBLE LIGHTNING STRIKE DAMAGE ON UPPER FUSELAGE AT APPROX STA X13.0 LEFT OF STR 1 ON TOP OF DOUBLER. REMOVED RIVET BY DRILLING, ENLARGED HOLE AND COUNTERSINK TO REMOVE DAMAGE TO SKIN REF RD8/4-53-1039. HFEC AREA IAW Q400 NDTM PART 6, 51-00-01, NO SDR QXEA2008110501142Skin · damagedPDX C1- POSSIBLE LIGHTNING STRIKE DAMAGE ON UPPER FUSELAGE AT APPROX STA X34.5 4.5 INCH LEFT OF STRINGER 1. REMOVED LIGHTNING STRIKE DAMAGE BY BLENDING IAW RD 8/4-53-666 FOUND TO BE BEYOND LIMITS PER RD 8/4-53-666. MAPPED FOR ENGINEERING. HFEC IAW Q400 NDTMSDR SWAA085692Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 425, STR 1R. REPAIRED SKIN PER SWA EA.SDR SWAA085675Skin · crackedDURING SCHEDULED MV3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 312, STR 19R. REPAIRED SKIN PER SRM.SDR SWAA085657Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND R2 DOOR LWR FWD CUTOUT FUSELAGE SKIN CRACKED. REPAIRED SKIN PER SRM.SDR FDEA200810174406Skin · damagedEXISTING FUSELAGE SKIN EXTERNAL REPAIR DOUBLER IDENTIFIED AT STA 1700-1720, STR 15L-17L APPROX 22 INCHES X24 INCHES, COMPLY WITH ATTACHMENT 'B' OF EO F-5100-7-5001 PT 1. COMPLIED ATTACHMENT 'B' OF EO F-5100-7-5001 PT 1, PREVIOUSLY INSTALLED REPAIR AT STA 170SDR DL757081403Skin · dentedDENT FROM INSIDE OUT STA 1738 BETWEEN STRINGERS 26L-27L. REPAIRED ON CUST CARD 00153.SDR 2008UALA06174Skin · damagedLT OVERWING MANUAL BACKUP CABLE FAILS OPS CHECK. CUT OUT DAMAGED SKIN REF SRM 53-00-01 FIG 201. FAB FILLER AND DOUBLER REF BAC DWG 146N3750 AND SRM 53-00-01 FIG 201, AND INSTALLED.SDR 08FDEA04391Skin · dentedFOUND 2 DENTS ON THE LOWER FUSELAGE AT STA 690, STRINGER 50.SDR UPS08853645Skin · unknownINSPECTION TYPE:SV INSTALL EXTERNAL SKIN DOUBLERS AT STA -88 TO -50 AND -29 TO 7 L21R. INSTALLED DOUBLERS IAW SRM DC-8 53-02-01 FIG 007.SDR DL757081454Skin · corrodedWHILE ACCESSING AFT LAV SERVICE PAN FOUND SKIN UNDER LIP OF PAN TO HAVE CORROSION, OUT OF LIMITS. REPAIRED PER ER/A 465409-14 REV ORG.SDR SWAA085652Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 434, STR 1. REPAIRED SKIN PER SWA EA.SDR 2008UALA06152Skin · damagedFOUND DENT AND GOUGE JUST AFT OF DOOR 2 LEFT, ON LOWER RIGHT CORNER, AT STATION 760, 8.5 INCHES UP OF WATER LINE. LENGTH OF GOUGE IS 2 INCHES LONG AND DENT WIDTH IS 1 INCH WITH A DEPTH OF .062 DEEP. CLEANED AREA, AND SMOOTHED AREA. AREA IS FREE FROM CRACKS SDR 08FDEA04382Skin · damagedFUSELAGE LT/RT, FWD WING TO BODY ATTACHMENT AREAS, SCRIBE MARKS IN SKIN STA 700, 72D STR 19L TO STR 19R. BLEND OUT DAMAGE IAW SRM 51-10-1 AND UT AREA IAW NDTM 51-00-00. FOUND SKIN OUT OF LIMITS IAW SRM 53-30-1. CUT OUT DAMAGE AREA LT SIDE & FABRICATED 1 DOUSDR 08FDEA04380Skin · damagedCABIN STA 440 STR 10L HAS MIS-DRILLED FASTENER HOLES. CUT OUT DAMAGED AREA DIMS 2 INCH BY 7/8 INCH. FABRICATED DOUBLER USING 2024-T3 .090 PO NR 9007561 DIMS 12 5/8 BY 9 1/2 INCH, FILLER USING 2024-T3 .190 PO NR 314676 DIMS 2 INCH BY 7/8 INCH, IAW B727 SRM 53SDR FDEA200810154353Skin · dentedLOWER FUSELAGE DENT ON EXT SKIN DIM: 2" X 2" DEPTH 0.09". REPAIRED DENT IAW SRM 53-20-01 FIG 13 SHT 2A VOL I.SDR HNAA2009020100036Skin · dentedPROTRUDING DENT ON BELLY SECTION OF FORWARD FUSELAGE AT STATION X223 BETWEEN STRINGER 32S-33S. REPAIR SKIN IAW RD8-53-2181.SDR HNAA2009012500024Skin Panel · corrodedPROTRUDING DENT ON LT FUSE STA X444.8, STR 30P - STR 31P. REPAIR DAMAGE IAW EO8-53-08-3363 EDDY CURRENT AND BONT TEST.SDR UPS08854205Skin · misrepairedINSPECTION TYPE:SP REPAIR 803-F1-82, STA 1670 L8R HAS NO SRM REFERENCE AND REQUIRES EO APPX F. REMOVED EXISTING REPAIR. FABRICATED AND INSTALLED REPAIR REF SRM 53-02-01 FIG10 SHT 1.SDR UPS08854187Doubler · damagedINSPECTION TYPE:SP REPAIR SEQUENCE 803-F1-92 AT STA 1430 L16L HAS NO SRM REF AND REQUIRES APPX F OF EO DC8-5100-30418C. REPAIRED PER FVC DRAWING 53-08540-12, EO DC8-5330-31414-A SA PER SAA EAR 81426850001.SDR UPS08854185Skin · damagedINSPECTION TYPE:SV REPAIR SEQUENCE 803-F1-57 AT STA 1217 L18L HAS NO SRM REF. REMOVED REPAIR, FABRICATED AND INSTALLED REPAIR DOUBLER IAW UPS EO DC8-5330-31420-A AND DWG 53-08540-18.SDR UPS08854183Skin · misrepairedINSPECTION TYPE:SP REPAIR 803-F1-53, STA 1278-1285, L5R-L7R, HAS NO SRM REFERENCE AND REQUIRES EO APPX F. REMOVED EXISTING REPAIR. FABRICATED AND INSTALLED REPAIR REF EO DC8- 5330-31400-A AND DWG FVCI 53-08540-24.SDR UPS08854177Skin · damagedINSPECTION TYPE:SV REPAIR SEQUENCE 803-F1-77 FS 1530-1540 L16-18R HAS NO SRM REF. REMOVED REPAIR, FABRICATED AND INSTALLED REPAIR DOUBLER IAW DC-8 SRM 53-02-00 FIG 22A.SDR UPS08854176Skin · damagedINSPECTION TYPE:SV REPAIR SEQUENCE 803-F1-56 AT STA 1157-1166 L27L HAS NO SRM REF. REMOVED REPAIR, FABRICATED AND INSTALLED REPAIR DOUBLER AND FILLER IAW DC-8 SRM 53-02-01 FIG 7 SHEET 13.SDR UPS08854175Skin · damagedINSPECTION TYPE:SV REPAIR SEQUENCE 803-F1-59 AT STA 1294-1305 L14-17L HAS NO SRM REF. REMOVED REPAIR, FABRICATED AND INSTALLED REPAIR DOUBLER IAW DC-8 SRM 53-02-00 FIG 22A.SDR UPS08854174Skin · damagedINSPECTION TYPE:SV REPAIR SEQUENCE 803-F1-74 AT FS 1427 L19-20L HAS NO SRM REF. REMOVED REPAIR, FABRICATED AND INSTALLED REPAIR DOUBLER AND FILLER IAW DC-8 SRM 53-02-01 FIG 7 SHEET 10.SDR UPS08854173Skin · damagedINSPECTION TYPE:SV REPAIR SEQUENCE 803-F1-72 AT FS 1406 L20-21L HAS NO SRM REF. REMOVED REPAIR, FABRICATED AND INSTALLED REPAIR DOUBLER AND FILLER IAW DC-8 SRM 53-02-01 FIG 7 SHEET 11.SDR UPS08854172Skin · damagedINSPECTION TYPE:SV REPAIR SEQUENCE 803-F1-71 AT FS 1396 L20-21L HAS NO SRM REF. REMOVED REPAIR, FABRICATED AND INSTALLED REPAIR DOUBLER AND FILLER IAW DC-8 SRM 53-02-01 FIG 7 SHEET 10.SDR UPS08854171Skin · damagedINSPECTION TYPE:SV REPAIR SEQUENCE 803-F1-70 AT FS 1376.5-1379.5 L19-20L HAS NO SRM REF. REMOVED REPAIR, FABRICATED AND INSTALLED REPAIR DOUBLER AND FILLER IAW DC-8 SRM 53-02-01 FIG 7 SHEET 11.
Back to JASC 5330