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 HEED064562Wheel · damagedBRAKE KEYS BROKEN. ORDERED REPLACEMENTSDR HEED064560Lift Link · wornLIFT LINK ASSEMBLY'S ELASTOMETRIC BEARING WORN. ORDERED REPLACEMENT.SDR HEED064550Indicator · failedINDICATOR WILL NOT HOLD STARTER ON. ORDERED REPLACEMENT.SDR HEED064549Bearing Pad · separatedBEARING PAD SEPARATED. ORDERED REPLACEMENT.SDR HEED064548Bearing · separatedBEARING PAD SEPERATED. ORDERED REPLACEMENT.SDR HEED064547Bearing Liner · chafedLINER CHAFED. ORDERED REPLACEMENT.SDR HEED064546Bearing Liner · brokenLINER BROKEN. ORDERED REPLACEMENT.SDR HEED064545Seal · leakingMAG SEAL LEAKS. ORDERED REPLACEMENT.SDR HEED064544Seal · leakingSEAL LEAKS. ORDERED REPLACEMENT.SDR HEED064543Seal · leakingMAG SEAL LEAKS. ORDERED REPLACEMENT.SDR HEED064542Light · malfunctionedMOTOR LOCKED UP. REPLACED UNIT.SDR HEED064539Restraint · frayedRESTRAINT HAS FRAYED SHOULDER HARNESS. ORDERED REPLACEMENT.SDR HEED064538Bearing · wornBELLCRANK HAS WORN BEARINGS. ORDERED REPLACEMENT.SDR HEED064537Chip Detector · looseCHIP DETECTOR HAS PLUG LOOSE IN HOUSING AND BODY VALVE WILL NOT SEAT. ORDERED REPLACEMENT.SDR 98ZZZX1346Switch · failedIN CRUISE FLIGHT, NR 1 HYDRAULIC SYSTEM PRESSURE DROPPED TO ZERO, LANDED WITHOUT INCIDENT. MAINTENANCE FOUND ON/OFF SWITCH FAILED. REPLACED SWITCH DUE TO WEAK LOCK IN THE ON POSITION. REF: IPC, CHAPTER 96-99-00, PAGE 80, ITEM 16, FIGURE 96-1022.SDR HEEA0010515Panel · crackedREPAIR CRACKED ROOF.SDR HEEA0010489Mast · corrodedCORROSION ON MAST MIDDLE SPLINES.SDR HEEA0010487Actuator Assy · wornREPLACE WORN SERVO BEARINGS.SDR HEEA0010486Actuator Assy · wornREPLACE WORN ACTUATOR BEARINGS. SERIAL NUMBERS REMOVED ARE 0007A AND 0137A.SDR HEEA0010399Pins · brinelledPINS BRINELLED ON RACE.SDR HEEA0010398Inner Race · brinelledBEARING BRINELLED ON RACE.SDR HEEA0010397Inner Race · brinelledBEARING BRINELLED ON RACE.SDR HEEA0010396Support · wornSUPPORT WORN THROUGH HARD ANODIZED SURFACE.SDR HEEA0010161Fuel Control · malfunctionFUEL CONTROL UNSTABLE IDLE, SLOW ACCEL.SDR HEEA968677Nozzle · defectiveFUEL NOZZLE NEEDS TO BE REPLACED, NOT ENOUGH THREADS TO ADD SHIMS.SDR HEEA968433Indicator · malfunction"SEC" SCAN SWITCH INTERMITTENT, NOT SWITCHING AT ALL AT TIMES. TIME SINCE REPAIR 0:00.SDR HEEA967663Indicator · defectiveNO COLOR ON DISPLAY.SDR HEEA966674Blade · errodedT/R BLADE PAINT EROSION. S/N A542 &A547SDR HEED95454Brake Assy · pucks loosePUCKS LOOSE ON PISTONS. REPLACED UNITSDR HEED95453Panel · crackedCRACKED PANEL. REPLACED UNITSDR HEED95452Hinge Half · crackedHINGE HALF CRACKED. REPLACED UNITSDR HEED95450Seal · leaking#1 TRANSMISSION INPUT QUILL LEAKING REPLACED SEAL UNITSDR HEED95449Mating Ring · leaking#1 TRANSMISSION INPUT QUILL LEAKING REPLACED MATING RING UNITSDR HEED95448Packing · leaking#1 TRANSMISSION INPUT QUILL LEAKING REPLACED UNITSDR HEED95447Packing · leaking#1 TRANSMISSION INPUT QUILL LEAKING REPLACED UNITSDR HEED95446Tab Loc-Nut · leaking#1 TRANSMISSION INPUT QUILL LEAKING REPLACED UNITSDR HEED95444Link · defectiveT/R LINK DEFECTIVE. REPLACED UNITSDR HEED95441Brake · pucks wornON ZONE INSP. FOUND ROTOR BRAKE PUCKS WORN. REPLACED UNITSDR HEED95437Panel · missingTRIM PANEL AROUND A/C VENT MISSING REPLACED UNITSDR HEED95436Bumper · missingBUMBER ON M/R GRIP MISSING REPLACED UNITSDR HEED95435Light · inoperativeON DAILY INSPECTION FOUND SEARCH LIGHT INOPERATIVE REPLACED UNITSDR HEED95434Packing · leakingT/R OUTPUT SEAL ON TRANSMISSION LEAKING. REPLACED UNITSDR HEED95433Packing · leakingT/R OUTPUT SEAL ON TRANSMISSION LEAKING. REPLACED UNITSDR HEED95432Packing · leakingT/R OUTPUT SEAL ON TRANSMISSION LEAKING. REPLACED UNITSDR HEED95431Tabloc-Nut · seal leakT/R OUTPUT SEAL ON TRANSMISSION LEAKING. REPLACED TAB LOC UNITSDR HEED95430Seal · leakingT/R OUTPUT SEAL ON TRANSMISSION LEAKING. REPLACED UNITSDR HEED95407Ejector · crackedEXHAUST EJECTOR HAS CRACK ABOUT 1" LONG. SENT TO LOCAL PHI BASE TO HAVE COWLING WELDED UP IN CRACK AREA.SDR HEED95389Indicator · failedHYD PRESSURE WENT TO ZERO, ON NEXT START HYD PRESSURE FLUCTUATE FROM 0-2000 PSI. REPLACED UNITSDR HEED95387Link · bearing wornBEARING WORN TO EXXON LIMITS .REPLACED UNITSDR HEED95385Gasket · leakingTRANSMISSION DRAIN PAN LEAKING. REPLACED UNIT
Back to N236X, cancelled Jan 13, 2003