N139JP, cancelled Sep 10, 2024
Service difficulty reports · 21
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 = 'N139JP' AND deregistration_id = 'N139JP-2024-09-10' 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 = 'N139JP' AND deregistration_id = 'N139JP-2024-09-10' 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 AC2A2020081013902Check Valve · separatedHEATER WILL NOT BLOW HOT AIR, DURING TROUBLESHOOTING FOUND HIGHT PRESSURE CHECK VALVE FLAPPER HALVES BEING SEPARATED FROM CHECK VALVE BODY ON ONE SIDE.SDR AC2A2020081013901Check Valve · separatedHEATER WILL NOT BLOW HOT AIR; DURING TROUBLESHOOTING FOUND HEATER TEMPERATURE CONTROL VALVE (P/N 3G2140V00751) TO BE DAMAGED FROM HIGHT PRESSURE CHECK VALVE (P/N 3G2140V00651) FLAPPER HALVES BEING SEPARATED FROM CHECK VALVE AND LODGED IN HEATER TEMPERATURE CONSDR AC2A2020033001Fuel Control · malfunctionedWHEN ADVANCING #1 ENGINE FROM IDLE TO FLIGHT POSITION, #1 ENGINE BEGAN TO "RUN AWAY" AND THE AIRCRAFT SPUN APPROXIMATELY 25-30 DEGREES ON THE PAD AND STARTED TO ROLL OVER. THE PIC WAS STILL ON THE ENGINE MODE KNOB, IMMEDIATELY RETARDED TO #1 ENGINE BACK TO IDSDR AC2A2020032313902Pressure Switch · leakingHYDRAULIC FLUID LEAKING FROM VENT HOLE.SDR AC2A2020032313901Pressure Switch · leakingFLUID LEAKING FROM VENT HOLE ON PRESSURE SWITCH.SDR AC2R2018022001Bolt · brokenHEAD OF BOLT BROKE OFF.SDR AC2R2018042002Bearing · contaminatedOIL COOLER FAN BEARING CONTAMINATED.SDR AC2R2017082402Switch · malfunctionedHIGH RESISTANCE WHEN CLOSED. REMOVED AND INSTALLED SERVICEABLE SWITCH.SDR AC2R2017082401Switch · shortedSWITCH WAS SHORTED TO CASE AND CAUSED LANDING GEAR NOT TO EXTEND PROPERLY. REMOVED AND INSTALLED SERVICEABLE SWITCH.SDR AC2R2016051701Firewall · crackedTHE NR 2 ENGINE FIREWALL HAS A 45MM CRACK AT BS 5700, WL 2670 AND BUTT LINE 780. WE ARE REQUESTING OPTIONS FOR AN REPAIR OF THE CRACKED AREA. THE NR 1 ENGINE FIREWALL HAS AN 78MM CRACK AT BS 5700 AND WL 2670. WE ARE REQUESTING OPTIONS FOR AN REPAIR OF THE CSDR AC2R2016050401Skin · corrodedRT UPPER SKIN CORRODED BS 3120 - 6700.SDR AC2R9JP03062011Link · crackedFOUND MAIN ROTOR TENSION LINK CRACKED DURING VISUAL INSPECTION. REPLACED TENSION LINK.SDR AC2R9JP02222011Fitting · crackedDURING ROUTINE 50 HR INSP, FOUND THE SUPPORT FITTING WHERE THE INTERMEDIATE GEARBOX ATTACHES TO THE TAILBOOM WAS CRACKED. REMAINING ACFT IN OUR FLEET WERE INSPECTED AND NO OTHER DESCREPANCIES WERE FOUND.SDR AC2R12062010001Angle · cracked(AC2R) CRACKED FORE AND AFT ANGLE, PN 3P5333A19561, RT SIDE FUEL DRY BAY AREA.SDR AC2A2009081482852Pressure Switch · malfunctionedTURNING DOWNWIND AFTER TAKEOFF, NR 2 SERVO LIGHT ILLUMINATED. FOLLOWED ESTABLISHED EMERGENCY PROCEDURE. PRESSURE SWITCH MALFUNCTIONED.SDR AC2A2008093078342Rod End · brokenDURING TRANSITION FROM CLIMB TO CRUISE FLIGHT THE ACFT DEVELOPED A SEVERE VIBRATION. FOUND TAIL ROTOR DAMPER ROD END BROKEN. REPLACED TAIL ROTOR BLADE AND DAMPER.SDR AC2A021408001Gearbox · making metalIN CRUISE FLIGHT, AT 3500 MSL, THE MGB CHIP SUMP CAS MESSAGE CAME ON. FOLLOWED THE EMERGENCY PROCEDURE. THE CHIP BURNER WOULD NOT CLEAR THE CHIP. LANDED AT AIRPORT WITHOUT INCIDENT. FOUND 3 SMALL FLAKES ON RT LOWER CHIP PLUG. PERFORMED SERVICEABILITY CHECK ANDSDR AC2A114524Connector · dirtyWHILE IN FLIGHT, NR 2 SERVO CAS LIGHT ILLUMINATED. ON HYDRAULIC SYSTEM SYNOPTIC PAGE, THE NR 2 FWD, RT, LT AND T/R SERVOS ALL INDICATED JAMS. EMERGENCY CHECK LIST WAS FOLLOWED AND AIRCRAFT RETURNED TO BASE. CLEANED ELECTRICAL CONNECTOR ON SERVO BYPASS SWITCHESSDR AC2A113056Attach Fitting · crackedTHREE (3) CRACKS FOUND IN FUSELAGE TO TAILBOOM ATTACH STRUCTURE ON FUSELAGE SIDE. (1 )CRACK IN THE RADIUS OF THE BULKHEAD AND (2) CRACKS RADIATING FROM HILOK FASTENERS ON OUTER STRUCTURE THAT ENCAPSULATES THE ATTACH FITTING IN THE UPPER LT ATTACH POINT.SDR AC2A111381Clamp · crackedTAIL ROTOR DAMPER CLAMP CRACKED, REPLACED CLAMP.SDR AC2A110707Seal · failedSEAL BREAKING DOWN, COMING APART AND LEAVING A GAP, REPLACED SEAL.
Back to N139JP, cancelled Sep 10, 2024