JASC 5730
Service difficulty reports · 27,279
Reports filed under 5730 · Wing, 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 = '5730' 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 = '5730' 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 COMA0260167Plank · crackedCRACK FOUND ON RT LOWER WING PLANK AT PANEL 650AB.REPAIRD I/A/W 601R-57-21-030.SDR COMA0260166Plank · crackedCRACK FOUND ON RT LOWER WING PLANK AT PANEL 650BB.REPAIRED I/A/W 601R-57-21-030.SDR COMA0260165Plank · crackedCRACK FOUND ON RT LOWER WING PLANK AT PANEL 650CB.REPAIRED I/A/W 601R-57-21-030.SDR COMA0260164Plank · crackedCRACK FOUND ON RT LOWER WING PLANK AT PANEL 650DB.REPAIRED I/A/W 601R-57-21-030.SDR COMA0260163Plank · crackedCRACK FOUND ON RT LOWER WING PLANK AT PANEL 640DB.REPAIRED I/A/W 601R-57-21-030.SDR COMA0260162Plank · crackedCRACK FOUND ON RT LOWER WING PLANK AT 650GB.REPAIRED I/A/W 601R-57-21-030.SDR QXEA0200461Seal · deterioratedPDX - LT WING ROOT FAIRING HAS DETERIORATED FILLET SEAL AND LOOSE RIVET AT X427.0 AND Z152.0. REPAIRED IAW 51-40-11.SDR COMA0260140Plank · crackedCRACK FOUND ON R/H LOWER WING PLANK AT PANEL 650DB.REPAIRED I/A/W 601R-57-21-030.SDR COMA0260139Plank · crackedCRACK FOUND ON R/H LOWER WING PLANK AT PANEL 650BB.REPAIRED I/A/W 601R-57-21-030.SDR COMA0260138Plank · crackedCRACK FOUND ON R/H LOWER WING PLANK AT PANEL 650 AB.REPAIRED I/A/W 601R-57-21-030.SDR COMA0260137Plank · crackedCRACK FOUND ON L/H LOWER WING PLANK AT PANEL 550AB.REPAIRED I/A/W 601R-57-21-030.SDR COMA0260136Plank · crackedCRACK FOUND ON L/H LOWER WING PLANK AT PANEL 550BB.REPAIRED I/A/W 601R-57-21-030.SDR COOSDR02034Panel · delaminatedRIGHT WING, TRAILING EDGE PANEL (PN: 65-21655) DELAMINATED.SDR COOSDR02040Panel · corrodedLEFT WING, TRAILING EDGE UPPER FIX PANEL (PN 65-21655-477) CORRODED.SDR COOSDR02035Panel · delaminatedLEFT WING, TRAILING EDGE UPPER FIX PANEL (PN 65-21657-245) DELAMINATED.SDR UPS02837902Doubler · crackedINSPECTION TYPE:C23 MOULD-LINE DOUBLER AT NR 1 PYLON HAS PREVIOUSLY INSTALLED REPAIR DOUBLER ON THE I/B SIDE THATS CRACKED AT FASTENER HOLE. REMOVED DOUBLER, PERFORMED HFEC AND BOLT HAVE HFEC IAW NDT SPM 06-10.001 AND 06-10.003. CRACKS PRESENT IN 5 EA HOLES,SDR COOSDR010155Skin · delaminatedLEFT WING ACCESS PANEL OUTER SKIN DELAMINATED.SDR COOSDR010153Skin · delaminatedLEFT WING UPPER FIXED PANEL INNER SKIN DELAMINATED.SDR COOSDR010152Skin · delaminatedRIGHT WING ACCESS PANEL INNER SKIN DELAMINATED.SDR AT0200053Skin · crackedRIGHT WING LEADING EDGE SKIN LOWER AREA CRACKED WING STA 215 XRS, JUST INBOARD FUEL PANEL DOOR. CUT OUT CRACK AREA, ACCOMPLISHED NDT CRACK CONTAINMENT CONFIRM. INSTALLED REPAIR PER DC-9 SRM 57-06B F1.SDR 2002UALA00318Splice · crackedRIGHT WING LE SKIN SPLICE CRACKED OUTBD #8 SLAT OUTBD. ROTARY ACTUATOR. SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. INSTALLED NEW SPLICE.SDR P5CA0200653Panel · crackedCRACK LT WING REAR SPAR TO INBOARD AILERON TRAILING EDGE UPPER PANEL (573ST). PANEL ASSY REPLACED REF SRM 51-10-01.SDR ABXA010767Skin · crackedINBOARD WING UPPER TRAILING EDGE UPPER SKIN WAS CRACKED ALONG THE TRAILING EDGE NEXT TO INBOARD SPOILER. REPAIRED TRAILING EDGE IAW DC-9 SRM 57-01.SDR ABXA010771Finger Doubler · debondedOUTBOARD REMOVABLE TRAILING EDGE LOWER SKIN FINGER DOUBLERS WERE DEBONDED. REPLACED UPPER/LOWER SKINS IAW REA D957-43379.SDR P5CA0200654Panel · damagedDAMAGE LT WING UPPER PANEL STATION WS 440.62, ABOVE KRUEGER FLAPS 11/13. NO CRACK FOUND. REPAIR CARRIED OUT WITH REF TO SRM 51-40-09 & 51-40-15.SDR COMA0260121Skin · crackedCRACK FOUND ON RT LOWER WING PLANK AT PANEL 650EB. REPAIRED IAW 601R-57-21-030.SDR IXXA0200029SSkin · corrodedDURING ROUTINE C-CHECK INSPECTION, CORROSION WAS DETECTED AROUND THE HI-LOK HEAD ON THE LEFT WING UPPER LEADING EDGE APPROXIMATELY 21 INCHES OUTBOARD OF THE NR 2 PYLON. REPAIR ACCOMPLISHED, REMOVAL OF DAMAGED AREA, FABRICATION AND INSTALLATION OF REPAIR DOUBLSDR QXEA0200458Skin · crackedPDX - CRACK IN DOUBLER SKIN BETWEEN RIVETS ABOVE LT MAIN LANDING GEAR STRUT. REPAIRED IAW HORIZON AIR EA 4-57-578.SDR CA020221015Access Panel · cracked(CAN) WHILE PERFORMING SCHEDULED MAINTENANCE, TASK CARD 002-57-510/610-603, A CRACK WAS FOUND ON ONE OF THE FUEL BOOST PUMP ACCESS SCREW HOLES.SDR DHL2002364503Skin · corrodedTWO SQ INCHES OF LEVEL 1 CORROSION AT RIB 7A, TRAILING EDGE OF BOTTOM SKIN IN BOOSTER BAY RT WING. REMOVED CORROSION PER SRM 51-40-11 A300.SDR Q2XEA0200343Panel · chafedPDX - RIGHT WING STATION 5280, PANEL 82CE AFT ATTACH POINTS ON PANEL HAVE MOUNT BRACKET CHAFE ON ONE SIDE AND THE OTHER SIDE IS ELONGATED. REPAIRED IAW FOKKER SRM 57-61-04 AND SRM 51-31-01.SDR QXEA0200397Skin · chafedPDX - LT WING UPPER SURFACE AT STATION 9890, MINOR CHAFED AREA. REPAIRED IAW FOKKER SRM 53-01-01, SRM 51-10-4 AND SRM 51-30-03.SDR QXEA0200158Skin · corrodedPDX - PANEL 72A APERTURE HAS FRETTING CORROSION AROUND SCREW HOLES. REPAIRED IAW F-28 SRM 51-10-04, PARAGRAPH 4, 57-12-01, PAGE 9 AND SRM 51-10-4.SDR QXEA0200272Panel · damagedPDX - PANEL 75E HAS TWO HOLES WITH MINOR DAMAGE WHERE SCREWS WERE REMOVED.SDR QXEA0200174Flange · corrodedPDX - LT WING FLANGE FOR PANEL 71A HAS FRETTING CORROSION. REPAIRED IAW FOKKER SRM 57-01-01 AND SRM 51-10-4.SDR TSAA0253042Skin · corrodedFOUND CORROSION ON LOWER SKIN SURFACE AT WS 435.5, WS 542, WS 567, WS 514.5, AND WS 461. CONFIRMED COMPLETE REMOVAL OF CORROSION WITH A 10X VISUAL INSPECTION. EVALUATED REMAINING WING SKIN THICKNESS AND FILLED DEPRESSIONS WITH BMS 5-95 SEALANT REFERRING TO SSDR QXEA0200190Flange · corrodedPDX - LIGHT FRETTING CORROSION ON FLANGE OF WING FOR PANEL 73J. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9, PARAGRAPH 4B.SDR QXEA0200189Flange · corrodedPDX - ALODINE DETERIORATED ON LT WING FLANGE FOR PANELS 73E-73J, LIGHT CORROSION FILM FORMING. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9, PARAGRAPH 4B.SDR QXEA0200185Flange · corrodedPDX - LIGHT FRETTING CORROSION AROUND ATTACH HOLES AT WING FLANGE FOR PANEL 73H. REPAIRED IAW FOKKER SRM 87-01-01 AND SRM 51-10-4, PAGE 9, PARAGRAPH 4B.SDR QXEA0200184Flange · corrodedPDX - LIGHT FRETTING CORROSION AROUND ATTACH HOLES, AT WING FLANGE FOR PANEL 73G. REPAIRED IAW FOKKER SRM 57-01-01 AND SRM 51-10-4, PAGE 9, PARAGRAPH 4B.SDR QXEA0200183Flange · corrodedPDX - LIGHT FRETTING CORROSION AROUND ATTACH HOLES, AT WING FLANGE FOR PANEL 73F. REPAIRED IAW FOKKER SRM 57-01-01, PAGE 5, PARAGRAPH 4C, SRM 57-01-01, PARAGRAPH B(2)(A) AND SRM 51-10-4.SDR QXEA0200182Flange · corrodedPDX - MINOR FRETTING CORROSION AROUND ATTACH HOLES, AT WING FLANGE FOR PANEL 73E. REPAIRED IAW FOKKER SRM 57-01-01, PAGE 5, PARAGRAPH 4C AND SRM 51-10-4, PAGE 9, PARAGRAPH 4B.SDR QXEA0200181Flange · corrodedPDX - MINOR FRETTING CORROSION AROUND ATTACH HOLES AT WING FLANGE FOR PANEL 73D. REPAIRED IAW FOKKER SRM 57-01-01 AND SRM 51-10-4, PAGE 9, PARAGRAPH 4B.SDR QXEA0200180Flange · corrodedPDX - LIGHT FRETTING CORROSION ON WING FLANGE FOR PANEL 73C. REPAIRED IAW FOKKER SRM 57-01-01 AND SRM 51-10-4, PAGE 9, PARAGRAPH 4B.SDR QXEA0200176Flange · corrodedPDX - LT WING FLANGE FOR PANEL 73B HAS FRETTING CORROSION. REPAIRED IAW FOKKER SRM 57-01-01, PAGE 5 AND SRM 51-10-4, PAGE 9, PARAGRAPH 4B.SDR QXEA0200175Flange · corrodedPDX - LT WING FLANGE FOR PANEL 73A HAS FRETTING CORROSION. REPAIRED IAW FOKKER SRM 57-01-01, PAGE 5, PARAGRAPH 4C, SRM 57-12-01, PAGE 32 AND SRM 51-10-4.SDR QXEA0200169Panel · corrodedPDX - PANEL 73D HAS VERY LIGHT FRETTING CORROSION ON FLANGE. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9.SDR QXEA0200168Panel · corrodedPDX - PANEL 73G HAS VERY LIGHT FRETTING CORROSION ON FLANGE. REPAIRED IAW FOKKER SRM 51-10-04, PAGE 9.SDR QXEA0200173Panel · corrodedPDX - PANEL 73B HAS FRETTING CORROSION ON FLANGE. REPAIRED IAW FOKKER SRM 57-01-01, PAGE 5 AND SRM 51-10-4.SDR QXEA0200172Panel · corrodedPDX - PANEL 73A HAS FRETTING CORROSION ON FLANGE. REPAIRED IAW FOKKER SRM 51-10-4.
Back to JASC 5730