N236X, cancelled Jan 13, 2003
Service difficulty reports · 213
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 = 'N236X' AND deregistration_id = 'N236X-2003-01-13' 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 = 'N236X' AND deregistration_id = 'N236X-2003-01-13' 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 HEED95384Latch · brokenCO-PILOT VENT WINDOW LATCH AND HINGE BROKEN REPLACED UNITSDR HEED95383Hinge Half · brokenCO-PILOT VENT WINDOW LATCH AND HINGE BROKEN REPLACED UNITSDR HEED95382Hinge Half · brokenCO-PILOT VENT WINDOW LATCH AND HINGE BROKEN REPLACED UNITSDR HEED95367Actuator Assy · bearing wornUPPER BEARING WORN. REPLACE UNITSDR HEED95366Rod End · bearing wornBEARING WORN ON ISOLATION MOUNT. REPLACE UNITSDR HEED95365Swashplate · bushing unbondedSLIDER BUSHING UNBONDED. REPLACE UNITSDR HEED95362Air Valve Assy · brokenL/H AFT DOOR AIR VALVE BROKEN. REPLACE UNITSDR HEED95351Packing · leakingLEAKING STARTER GENERATOR. REPLACED UNITSDR HEED95350Latch · brokenLATCH ON CO-PILOT WINDOW BROKEN. REPLACED UNITSDR HEED95348Switch · failedINOPERATIVE REPLACED UNITSDR HEED95346Filter · defectiveFILTER BYPASS BUTTON EXTENDED. REPLACED UNITSDR HEED95341Lamp · failedSEARCH LIGHT INOPERATIVE REPLACED UNITSDR HEED95340Lamp · inoperativeMARKER BEACON SWITCH LIGHT INOPERATIVE REPLACED UNITSDR HEED95339Bulb · failedINOPERATIVE REPLACED UNITSDR HEED95337Indicator · defectiveRADAR INDICATOR FUZZY AND HARD TO READ.SDR HEED95300Actuator · defectiveBEEP MOTOR WILL NOT EXTEND OR RETRACT. REPLACE UNITSDR HEED95299Valve · sticksSTICKS IN NORM POSITION CAN NOT SWITCH FCU TO ECONOMY MODE. REPLACE UNITSDR HEED95287Exhaust Stack · crackedEXH CRACKED AFT SIDE CENTER SEAM ABOVE MOUNTING FLANGE. REPLACE UNITSDR HEED95267Nut Plate · strippedNUT PLATE STRIPED OUT IN BELLY PANELS. ORDER REPLACEMENT PARTSDR HEED95263Lamp · failedSEARCH LIGHT INOPERATIVE ORDER REPLACEMENT PARTSDR HEED95260Trim Panel · brokenPANEL UPPER HALF CORNER BROKEN OFF, CATCHES ON AIRFRAME. ORDER REPLACEMENT PARTSDR HEED95258Trim Panel · stainedTRIM PANEL STAINED FROM LEAKS IN TRANSMISSION PAN. NEW A/C PURCHASED FROM SIKORKSYSDR HEED95249Solenoid · inoperativeSOLENOID INOPERATIVE ON #1 ENGINE FLIGHT IDLE. ORDERED NEW UNITSDR HEED95246Panel Assy · crackedPANEL CRACKED. ORDERED NEW UNITSDR HEED95245Switch · defectiveCAUTION PANEL LIGHT ILLUMINATED. ORDERED NEW UNITSDR HEED95242Packing · leakingSTARTER GEN GARLOCK SEAL CHANGE DUE TO LEAKING. ORDERED NEW UNITSDR HEED95240Spring · separationM/R FLAPPING SPRING SEPERATION. ORDERED NEW UNITSDR HEED95239Flapping Spring · separationFLAPPING SPRING SEPERATION. ORDERED NEW UNITSDR HEED95238Bulb · failedLAMP BURNT OUT. ORDERED NEW UNITSDR HEED95237Lamp · inoperativeFOUND LANDING LIGHT INOPERATIVE ON DAILY INSPECTION. ORDERED NEW UNITSDR HEED95231Hinge · brokenHINGE BROKEN ON PILOT VENT WINDOW. ORDERED NEW UNITSDR HEED95230Seal · leakingSTARTER GEN GARLOCK SEAL CHANGE DUE TO LEAKING. ORDERED NEW UNITSDR HEED95209Packing · wornINNER SURFACE WORN FLAT CAUSING DELAY IN STINGER. ORDER NEWSDR HEED95208Lining · wornLININGS WORN. ORDER NEWSDR HEED95207Lamp · failedBULB BURNT OUT. ORDER NEWSDR HEED95206Lamp · failedSEARCH LIGHT INOPERATIVE ORDER NEWSDR HEED95205Shim Flex Rest · chafingFOUND CAM ARMS CHAFING, RESHIMMED. ORDER NEWSDR HEED95203Strobe Light · malfunctionPOWER SUPPLY CAUSES CIRCUIT BREAKER TO POP. ORDER NEWSDR HEED95197Plug · seal leakingT/R GEARBOX INPUT SEAL LEAKING. ORDER NEWSDR HEED95195Seal · leakingT/R GEARBOX INPUT SEAL LEAKING. ORDER NEWSDR HEED95191Servo · leakingWORN BEARINGS AND LEAKING. ORDER NEWSDR HEED95173Link · failedPITCH LINK FAILED. ORDER NEWSDR HEED95172Retention Nut · failedREPLACE DUE TO T/R PITCH CHANGE LINK FAILURE. ORDER NEWSDR HEED95170Lamp · failedBULB BLOWN. ORDER NEWSDR HEED95169Gearbox · link failureT/R PITCH LINK FAILURE. ORDER NEWSDR HEED95157Actuator · failedACTUATOR FAILED TO RESPOND TO SWITCH. ORDERED NEWSDR HEED95156Packing · looseTAIL SKID STINGER LOOSE, REPLACE 2 EACH O'RING SEAL IN STINGER SUPPORT ASSEMBLY. REMOVED FROM CONSIGNMENT KIT,SDR HEED95154Actuator · seizedACTUATOR WOULD NOT MOVE. ORDERED NEWSDR HEED95138Control Head · defectiveLOSES MEMORY WHEN RADIO IS OFF. ORDERED NEWSDR HEED95137Bolt · wornMAIN ROTOR TRUNNION BOLTS WORN. FOUND ON 50 HOUR INSPECTION ORDERED NEW
Back to N236X, cancelled Jan 13, 2003