N142PH, cancelled Apr 4, 2011
Service difficulty reports · 172
Matched to this aircraft by N-number and event date, checked against the reported serial number, make and model. 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 n_number = 'N142PH' AND deregistration_id = 'N142PH-2011-04-04' 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 n_number = 'N142PH' AND deregistration_id = 'N142PH-2011-04-04' 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 HEEA117034Transmitter · malfunctionedDURING CRUISE FLIGHT, NR 2 FUEL PRESSURE INDICATOR MAXED OUT AT 50 PSI INDICATED. MAINTENANCE REPLACED FUEL PRESSURE TRANSMITTER.SDR HEEA108173Blower · failedAFTER COMPLETION OF THE BEFORE LANDING CHECK LIST NOTICED NR 2 ENGINE OIL TEMPERATURE AT 135 FT - 140 FT. MAINTENANCE FOUND THE NR 2 OIL COOLER BLOWER FAILED. REPLACED BLOWER.SDR HEEA088609Crosstube · corrodedCROSSTUBE CORRODED BEYOND LIMITS IN ZONE C-3. SCRAPPED.SDR HEEA088567Bleed Valve · failedENGINE COMPRESSOR BLEED VALVE FAILED TO REMAIN CLOSED AT HIGH ENG OUTPUT CAUSING COMPRESSOR SURGES. REPLACED.SDR HEEA088554Indicator · malfunctionedSTICKS AT ZERO DURING START. SHOP REPAIR.SDR HEEA088553Indicator · stuckSTICKS AT ZERO DURING START. SHOP REPAIR.SDR HEEA088520Indicator · malfunctionedCOPILOT DME DISPLAY LIGHTS FLICKER. IN SHOP REPAIR.SDR HEEA088590Gps · malfunctionedGPS CAUSES CIRCUIT BREAKER TO POP. SHOP REPAIR.SDR HEEA088581Bearing · wornMAIN ROTOR LINK ASSY BEARINGS WORN. SHOP REPAIR.SDR HEEA088580Bearing · wornMAIN ROTOR LINK BEARINGS WORN. SHOP REPAIR.SDR HEEA088578Bearing · wornMAIN ROTOR LINK HAS BEARINGS WORN. SHOP REPAIR.SDR HEEA088509Hose · leakingHYDRAULIC HOSE LEAKING. REPLACED WITH SERVICEABLE PART.SDR HEEA088594Float · leakingMLG EMERGENCY FLOAT LEAKING. SHOP REPAIR.SDR HEEA088552Indicator · stickingSTICKS WHEN ENGINE IS FIRST STARTED UNTIL ABOUT 45 PERCENT N1. SHOP REPAIR.SDR HEEA088524Master Cylinder · malfunctionedMAIN ROTOR BRAKE MASTER CYLINDER HAS NO OUTPUT PRESSURE. IN SHOP REPAIR.SDR HEEA088491Bearing · wornTAIL ROTOR LINK HAS BEARINGS WORN. SCRAPPED.SDR HEEA088613Bearing · wornWORN BEARINGS. REPLACED BEARING DSP4, DSRP4 AND DW5 DUE TO WORN. REPAIRED.SDR HEEA087980Bearing · wornFEATHERING BEARINGS WORN. SHOP REPAIR.SDR HEEA087982Servo · inoperativeAFCS YAW ACTUATOR CHANNEL INOPERATIVE. TO BE SENT TO VENDOR.SDR HEEA087261Tarsyn · inoperativeWILL NOT ERECT PROPERLY. REPLACED WITH SERVICEABLE PART.SDR HEEA086703Brake Assy · stickingBRAKE ASSY HAS STICKING PISTON IN CALIPER. SHOP REPAIR.SDR HEEA086702Display · inoperativeRADAR SCREEN TURNS BLUE WHEN SWITCHING MODES. SENT TO MFG FOR INSPECTION AND REPAIR.SDR HEEA086696Skid · crackedMLG SKID CRACKED AT FWD CROSSTUBE SADDLE. TO BE SENT TO VENDOR FOR REPAIR.SDR HEEA086650Display · failedTCAS SCREEN IS BLUE AFTER IT GETS WARM.SDR HEEA086639Cap · wornCAP HAS RUBBER WORN.SDR HEEA086625Control Unit · splitUNCONTROLLABLE TORQUE SPLIT. TESTED AND FOUND SERVO VALVE LEAKAGE CAUSING UNEVEN FLOW BETWEEN SIDES. POLISHED SERVO VALVES AND LEVER. UNIT TESTED SATISFACTORY.SDR HEEA086602Oil Cooler · vibratesHIGH VIBRATION. REPAIRED.SDR HEEA086600Actuator · stuckACTUATOR STUCK AND CIRCUIT BREAKER KEEPS POPPING.SDR HEEA084983Indicator · malfunctionedWEATHER RADAR INDICATOR CAUSES VHF UNIT TO BREAK SQUELCH ON FREQ 129-77 MHZ AND CONSTANT NOISE.SDR HEEA084969Cap · wornMLG CROSSTUBE CAP RUBBER WORN. REPAIRED.SDR HEEA084956Control Unit · oscillatesTORQUE CONTROL UNIT CAUSES ENGINE OSCILLATIONS AND TORQUE ACCELERATIONS. COULD NOT DUPLICATE OSCILLATION. UNIT NEEDED MINOR TRIM ADJUSTMENTS. TESTED SATISFACTORY.SDR HEEA084947Crosstube · corrodedCROSSTUBE DEEP PITS OF CORROSION NEAR MOUNTING FOR STEPS .015 DEEP BEFORE CLEAN WHICH MAKES IT OUT OF LIMITS. SCRAPPED.SDR HEEA084929Bearing · wornTAIL ROTOR HEAD HAS WORN FEATHERING BEARING. REPAIRED.SDR HEEA084913Indicator · malfunctionedFLIGHT DIRECTOR HUNTS IN ROLL AXIS WHEN COUPLED.SDR HEEA084819Rod Bearing · wornM/R HEAD HAS A WORN ROD BEARING. REPAIRED.SDR HEEA084818Rod Bearing · wornMAIN ROTOR HEAD HAS A WORN ROD BEARING. REPAIRED.SDR HEEA084809Seatback Cushion · tornCREW SEAT BACK CUSHION TORN. REPAIRED.SDR HEEA084807Yoke · damagedVERY ROUGH VIBRATION IN FLIGHT. WILL NOT TRACK OUT. RADS GEAR CALLS FOR VERY LARGE AMOUNT OF WEIGHT ON THE BLUE SPINDLE. REPAIRED.SDR HEEA084805Clip · brokenCLIP FOR LIFE VEST STRAP BROKEN.SDR HEEA084789Actuator · malfunctionedSTEP ACTUATOR ONLY TRAVELS HALF WAY BEFORE STOPPING.SDR HEEA084773Cover · wornEMERGENCY FLOAT COVER IS WORN.SDR HEEA084735Switch · dirtyINTERPHONE BOX IS SCRATCHY. FOUND S1 SELECTOR SWITCH NOISY. CLEANED SWITCH. REPAIRED. BENCH CHECK GOOD.SDR HEEA084720Brake Assy · wornMAIN ROTOR BRAKE HAS WORN PUCKS. REPAIRED.SDR HEEA084713Control Box · damagedADF CONTROL BOX DAMAGED, CAN'T CHANGE FREQUENCY. FOUND DISPLAY DS302, PHOTOCELL V301, PHOTOCELL LENS BAD AND SWITCH SPOOL NOT PROPERLY ALIGNED WITH SWITCH S304. REPLACED DISPLAY, PHOTOCELL, PHOTOCELL LENS AND ALIGNED SWITCH. REPAIRED. BENCH CHECK GOOD.SDR HEEA084635Indicator · malfunctionedDISPLAY TOO DIM. REPLACED V901 PHOTOCELL, REPAIRED. CLEANED BOARDS AND CONNECTORS. BENCH CHECK GOOD.SDR HEEA084614Transceiver · malfunctionedVHF TRANSCEIVER HAS SCRATCHY SIDETONE. REPLACED Q109 AND Q110 TRANSISTORS AND Q110 TRANSISTOR SOCKET. REPAIRED. ALIGNED TRANSMITTER AND ADJUSTED CARRIER SQUELCH. REMOVED LIGHT CORROSION FROM UNIT. BENCH CHECK GOOD.SDR HEEA084609Pump · leakingFUEL PUMP SEAL LEAKING AT AFCU. POLISHED GEAR SET AND RETESTED UNIT. UNIT TESTED SATISFACTORY.SDR HEEA084596Link · wornHUB AND SLEEVE ASSY HAS A WORN LINK. REPAIRED.SDR HEEA084590Link · wornHUB AND SLEEVE ASSY HAS A WORN LINK. REPAIRED.SDR HEEA084588Link · wornHUB AND SLEEVE ASSY HAS A WORN LINK. REPAIRED.
Back to N142PH, cancelled Apr 4, 2011