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 aircraft_model_key = 'S76B' 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 aircraft_model_key = 'S76B' 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 20001218SH019Blower · intermittentDURING A HELICOPTER GROUND RUN, MECHANIC WAS MOVING AND SHAKING THE WIRE BUNDLE LEADING FROM THE HELICOPTER MAIN GEARBOX NR SENSOR ROUTED ALONG LEFT SIDE OF NR 1 ENG OIL COOLER BLOWER BASE, TRYING TO STIMULATE COCKPITS INTERMITTENT INDICATION. ENGINES OIL COOSDR 20010108AP003Drain Line · disconnectedLIGHT SMOKE DETECTED IN CABIN UPON ARRIVAL AT BOS. SMOKE DETECTOR/AFT BAGGAGE CAUTION LIGHT ILLUMINATED AFTER PASSENGERS DEPARTED AIRCRAFT. SMOKE DID NOT CONTINUE AFTER SHUTDOWN. ENGINE BREATHER NR 2 TYGON HOSE BEHIND BAGGAGE COMPARTMENT PANEL DETACHED FROMSDR BTEAS76B001Line · burstNR 2 HYDRAULIC PRESSURE LINE FROM HYDRAULIC PUMP TO BULKHEAD FITTING FAILED ON AIRCRAFT START-UP. LINE BURST FROM INSIDE WITHOUT WARNING, (NO LEAKS NOTED ON PREFLIGHTS). LINE WAS REPLACED, SYSTEM SERVICED AND AIRCRAFT RETURNED TO SERVICE. (X)SDR 20000912SH022Roller · detachedTHE PIN THAT HOLDS THE ROLLER FOR POSITIVE THROTTLE DETENTS FAILED COMPLETELY AND THE ROLLER AND PIN ASSEMBLY FELL INTO THE THROTTLE QUADRENT. SINCE THE QUADRENT IS IN AN OVERHEAD POSITION, THERE WAS NO THROTTLE RESTRICTION WITH THIS FAILURE. (X)SDR 20000710SH017Doubler · corrodedDOUBLER CORRODED. THE CORRODED PART WILL BE REPLACED WITH NEW PART. (X)SDR 20000710SH016Doubler · corrodedDOUBLER SHOWED SIGNS OF CORROSION. CORRODED PART WILL BE REPLACED WITH NEW PART. (X)SDR 20000710SH015Plate · corrodedPLATE CORRODED. CORRODED PART WILL BE REPLACED WITH NEW PART. (X)SDR 20000710SH020Angle · corrodedANGLE FOUND CORRODED. PART WILL BE REPLACED WITH A NEW UNIT. (X)SDR 20000710SH019Nut · crackedBARREL NUT FOUND CRACKED IN SEVERAL PLACES. REPLACED WITH NEW PART. C/W ASB 76-66-30. (X)SDR 20000710SH018Angle · corrodedANGLE FOUND CORRODED. PART WILL BE REPLACED WITH A NEW UNIT. (X)SDR 20000712SH014Nut · crackedBARREL NUT IS CRACKED. THE PART HAS BEEN IN SERVICE FOR 346.7 HOURS. ALL BARREL NUTS WILL BE REPLACED WITH NEW UNITS. ALL WORK DONE IAW MFG MM. (X)SDR 20000710SH014Angle · crackedCAP ANGLE FOUND CRACKED. PART WILL BE REPLACED WITH NEW ASSY IAW MANUFACTURERS MM AND REPAIR PROCEDURES. (X)SDR 20000712SH015Case · crackedMAIN TRANSMISSION HAS CRACK ON THE UPPER CASE IN THE AREA OF THE RIGHT REAR MOUNT LEG. (X)SDR 20000710SH026Angle · crackedANGLE CRACKED.SDR 20000710SH025Angle · crackedANGLE CRACKED.SDR 20000710SH024Strap · crackedSTRAP CRACKED.SDR 20000710SH023Angle · crackedANGLE CRACKED.SDR 20000710SH022Web · crackedWEB CRACKED.SDR 20000710SH021Floor Panel · crackedDECK CRACKED.SDR 20000531SH013Blade · delaminatedDURING POST-FLIGHT, TECHNICIAN NOTED A LARGE CRACK OR DELAMINATION OF THE INBOARD ROTOR BLADE STARTING ABOUT 20 INCHES FROM THE ROOF ON THE TRAILING EDGE, EXTENDING ABOUT 5 INCHES LENGTHWISE, THEN DIAGONALLY TO JUST BEHIND THESPAR AND THEN LENGTHWISE ABOUT 12 SDR 20000712SH007Drive Shaft · corrodedSUSPECTED CORROSION ON SHAFT TUBE AREA, BLISTERING. REPLACED SHAFT WITH A NEW UNIT IAW SIKORSKY MM. (X)SDR 20000712SH016Nut · crackedTWO EACH BARREL NUTS WERE REMOVED DUE TO CRACKS. INSTALLED 2 NEW BARREL NUTS. (X)SDR 98ZZZX2791Gearbox · crackedDURING 150-HOUR ZONE INSPECTION, FOUND APPROXIMATELY 2 INCH CRACK IN GEARBOX HOUSING NEAR INPUT SIDE. CRACK WAS NOT NEAR ANY MOUNTING BOSS, STUD OR HOLE. CRACK WAS ALMOST UNDETECTABLE BY VISUAL MEANS. MECHANIC FOUND CRACK BY WIPING CASE DOWN WITH SOLVENT ANSDR 98ZZZX737Bolt · wornUPPER BOLT IN UPPER PITCH CHANGE LINK SEVERELY WORN. SUSPECT BOLT TORQUE DOES NOT ALWAYS COMPRESS YOKE HOLDING SPHERICAL ROD END.SDR 97ZZZX4351Control Valve · miswiredTHE LANDING GEAR CONTROL VALVE REMOVED FOR OCCASIONAL POPPING OF THE 'MANUAL RESET' BUTTON WHICH KEPT THE GEAR FROM BEING RETRACTED. AN O/H VALVE, ARKWIN IND, INC., PN 0911077-004, SIKORSKY PN 76650-02802-0911077-004, SIKORSKY PN 76650-02802-104, SN 0557A WASSDR 97ZZZX3214Spar · damagedINVESTIGATION REVEALED ARCING PIT (.1562 INCH BY .3437 INCH) DEPTH .041 INCH IN UPPER HORIZONTAL STABILIZER SPAR ON LEFT SIDE OF SPAR SUPPORT FITTING KEVLAR WRAP. LEFT UPPER HORIZONTAL SUPPORT FITTING SHIM REVEALED ARCING HOLE, SUPPORT FITTING REVEALED NO APPSDR 97ZZZX3215Wire · misinstalledPOSITION LIGHT CIRCUIT BREAKER TRIPPED. INVESTIGATION REVEALED LT POSITION LIGHT POSITIVE WIRE (WIRE NR 15201J22) WAS CONNECTED TO POSITION LIGHT GROUND WIRE SPLICE, AND GROUND WIRE (WIRE NR L5204B20) WAS CONNECTED TO POSITION LIGHT GROUND WIRE SPLICE, AND GROSDR 97ZZZX1992Fitting · failedLEFT MAIN LANDING GEAR DOOR FITTING FOUND FAILED ON DAILY POST-FLIGHT INSPECTION. FITTING WAS REPLACED BY A SUPERSEDED (-048) PART NUMBERED FITTING WHICH IS DIMENSIONALLY LARGER IN SUPPORT AREA. NOTE: SEE ALERT NR 217, AUGUST 1996, PAGE 12, FOR SAME PROBLEMSDR 97ZZZX1687Longeron · crackedWHILE REPAIRING CRACK IN AFT SHEAR DECK WEB, FOUND A CRACK IN THE RIGHT TAIL BOOM LONGERON. THE LONGERON WAS REPAIRED IAW SIKORSKY SRM. THE NESTED ANGLE, P/N 76202-04001-106, WAS REPLACED WITH NEW STYLE NESTED ANGLE P/N 76202-24001-104 IAW SRM AT THE SAME TISDR 97ZZZX1673Angle · crackedWHILE DOING CABIN INSPECTION, ANGLE WAS FOUND CRACKED IN THE RIGHT CORNER. THE ANGLE WAS REPLACED WITH A NEW ANGLE FROM SIKORSKY.SDR 97ZZZX1672Angle · crackedWHILE DOING CABIN INSPECTION, ANGLE WAS FOUND CRACKED. THE ANGLE WAS REPLACED WITH A NEW ANGLE AND REINFORCED IAW SIKORSY SRM.SDR 97ZZZX1671Support Beam · crackedWHILE DOING CABIN INSPECTION, THE OVERHEAD LATERAL VIBRATION SUPPORT BEAM WAS FOUND CRACKED IN THE LOWER LEFT AND RIGHT CORNERS. THE SUPPORT BEAM WAS REPLACED WITH A NEW SUPPORT BEAM AND WAS MODIFIED IAW SIKORSKY INSTRUCTIONS AND 8110 INFORMATION.SDR 97ZZZX918Deck Web · crackedRIGHT TAIL BOOM LONGERON CRACKED AT STA 467. AIRCRAFT TT 2,855.3 HOURS.SDR 97ZZZX917Angle · crackedUPPER SHEAR DECK WEB CRACKED RT SIDE, STA 467. AIRCRAFT TT 2,855.3 HOURS.SDR 97ZZZX916Longeron · crackedANGLE CRACKED AT STA 467. AIRCRAFT TT 2,855.3 HOURS.SDR 97ZZZX913Housing · crackedWHILE DOING THE ZONE 5 INSPECTION, FOUND A CRACK IN THE UPPER MAIN GEARBOX HOUSING JUST AFT OF THE RIGHT REAR SUPPORT LEG. THE CRACK WAS FOUND IN THE AREA SHOWN IN CHAPTER 5-20-00, PAGE 23, FIGURE 16. THE MAIN GEARBOX WILL BE CHANGED TO FIX THIS PROBLEM. AISDR 97ZZZX205Housing · crackedWHILE PERFORMING 150 HR INSPECTION A CRACK WAS FOUND ON THE UPPER HOUSING AFT RIGHT FOOT OF THE MAIN GEARBOX. (UPPER HOUSING TT 2336.7). REPLACED MAIN GEARBOX ASSEMBLY WITH A SERVICEABLE GEARBOX IAW SIKORSKY MM. A/C TT 3091.8 HRS. GRBOX P/N 76351-09600-042SDR 96ZZZX5163Blade · crackedBLADE BEING INSPECTED AFTER BEING USED AS RENTAL UNIT. WHILE INSPECTING M/R BLADE ROOT END IAW SIKORSKY COMPOSITE MANUAL, SA 4047-76-5, PARAGRAPHS 2-7, A CRACK WAS FOUND COMING OUT FROM UNDERNEATH THE PHOENLIC BLOCK. BLADE REMOVED FROM SERVICE.SDR 96ZZZX5162Blade · crackedBLADE WAS BEING INSPECTED AFTER BEING USED AS A RENTAL UNIT. WHILE INSPECTING M/R BLADE ROOT END IAW SIKORSKY COMPOSITE MANUAL, SA 4047-76-5, PARAGRAPHS 2-7, A CRACK WAS FOUND COMING OUT FROM UNDERNEATH THE PHOENLIC BLOCK. BLADE REMOVED FROM SERVICE.SDR 96ZZZX3945Housing · damagedAIRCRAFT TT: 999.1 HOURS. NR 1 ENGINE TT, 999.1 HOURS. DURING REPLACEMENT OF NR 1 HMU, FOUND CORROSION DAMAGE IN THE BORE ON THE HOUSING WHERE HMU IS INSTALLED. CORROSION DAMAGE WAS AT THE 6 O'CLOCK POSITION, AND RANGED FROM MINOR TO SOME DEEP PITS UP TO .SDR 96ZZZX3546Fitting · failedLEFT MAIN GEAR DOOR LINK ATTACH FITTING FAILED DURING GEAR EXTENSION ON LANDING. COMPONENT HAS A HISTORY OF FAILURE AND MANUFACTURER HAS AN IMPROVED DASH 048 REPLACEMENT. THE PART HAS BEEN REDESIGNED TO BE STRUCTURALLY LARGER. THE ARICRAFT HAS BEEN FITTED WSDR 95ZZZX6836Vane Ring · crackedINSPECTION FOUND CRACKS IN COMPRESSOR TURBINE VANE RING WHICH CAUSE INACCURATE POWER ASSURANCE READINGS.SDR 95ZZZX5614Junction Box · defectiveNR 2 ENGINE 'CHIP' LIGHT ILLUMINATED, WOULD NOT CLEAR BY CYCLING NR 2 CHIP CIRCUIT BREAKER. INSPECTED BOTH AGB AND RGB CHIP PLUGS FOR METAL PARTICLES - BOTH WERE CLEAN (NO METAL PARTICLES ATTACHED). REINSTALLED CHIP PLUGS, LIGHT STILL ILLUMINATED. REMOVED ASDR EGRA95113Control · defectiveAC GENERATOR INTERMITTENT, DROPS OFF LINE. REPLACED AC GENERATOR CONTROL UNIT.SDR 95ZZZX3171Servo · pittedWHILE PERFORMING 750-HOUR ANNUAL REQUIREMENTS INSPECTION, THE MAINTENANCE CREW FOUND THE AFT AND FORWARD MAIN ROTOR SERVO PISTONS ASSEMBLY (IN MID-STRIKE RANGE - ON GEARBOX SIDE) SURFACE PLATING STARTING TO DEGRADE. THERE WAS VISUAL SCORING THAT WAS COPPER COSDR 95ZZZX3170Servo · pittedWHILE PERFORMING 750-HOUR ANNUAL REQUIREMENTS INSPECTION, THE MAINTENANCE CREW FOUND THE AFT AND FORWARD MAIN ROTOR SERVO PISTONS ASSEMBLY (IN MID-STRIKE RANGE - ON GEARBOX SIDE) SURFACE PLATING STARTING TO DEGRADE. THERE WAS VISUAL SCORING THAT WAS COPPER COSDR EGRA9591Audio Card · defectiveHIGH BAND RADIO RT-138 HAS CONSTANT SQUELCH ON SELECTED PL TONES RT-138F, P/N 400-014525, S/N 1285 TROUBLESHOT AND REPLACED DEFECTIVE A3 AUDIO CARD, P/N 300-2181-050. REPAIR DONE IAW VENDOR REPORT #1325, JUL 1/89.SDR EGRA9535Stabilizer · debondedHORIZONTAL STABILIZER FOUND DEBONDED. STABILIZER SHIPPED TO KEYSTONE FOR REPAIR. REPAIRED DISBONDED STABILIZER IAW CMM SA4047-76-5 REPAIR PROCEDURE #2 FOR BOND SEPERATIONS AND REPAIR PROCEDURE #3 FOR SKIN PATCH REPAIR. REPAIRED STABILIZER RETURNED AFTER REPAIRSDR 95ZZZX1084Control Tube · chafedDURING FLIGHT CONTROL INSPECTION, FOUND COLLECTIVE PUSH/PULL TUBE CHAFED ON FORWARD SIDE BOTTOM END. TUBE CHAFED ON KELVAR STRUCTURE AND RIVETS. TUBE LOCATED IN BROOM CLOSET AREA AFT OF CREW SEATS.
Back to Sikorsky S-76B