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 HEED95132Tab Locknut · seal leakSEAL LEAKING. ORDERED NEWSDR HEED95122Valve Assy · adj brokenVALVE ADJUSTMENT CONTROL BROKEN. ORDER NEWSDR HEED95121Spring · bearing failedBEARING SEPERATED BEYOND LIMITS. ORDER NEWSDR HEED9592Window · crackedWINDOW CRACKED. ORDERED NEWSDR HEED9584Gasket · leakingENGINE OIL TANK CRACKED AND LEAKING. ORDERED NEWSDR HEED9583Seal · leakingENGINE OIL TANK CRACKED AND LEAKING. ORDERED NEWSDR HEED9582Seal · leakingENGINE OIL TANK CRACKED AND LEAKING. ORDERED NEWSDR HEED9581Tank Assy · crackedENGINE OIL TANK CRACKED AND LEAKING. ORDERED NEWSDR HEED9580Panel Assy · damagedUPPER AFT CORNER BROKEN OFF. ORDERED NEWSDR HEED9579Bellcrank Assy · bearing wornWORN BEARING. ORDERED NEWSDR HEED9575Seal · leakingT/R GEARBOX INPUT SEAL LEAKING. ORDER NEW.SDR HEED9574Packing · leakingT/R GEARBOX INPUT SEAL LEAKING. ORDER NEW.SDR HEED9573Fan · defectiveFAN HAS HIGH FREQ. VIBRATION. ORDER NEW.SDR HEED9571Panel Assy · crackedCRACKED AND STAINED FROM OIL LEAKS. ORDER NEW.SDR HEED9570Packing · leakingMAST SEAL LEAKING. ORDER NEW.SDR HEED9569Seal · leakingMAST SEAL LEAKING. ORDER NEW.SDR HEED9568Clock · defectiveONE SECOND ON CLOCK = THREE SECOND OF TIME. ORDER NEW.SDR HEED9567Packing · leakingT/R GEARBOX INPUT SEAL LEAKING. ORDER NEW.SDR HEED9566Panel Assy · defectiveUPPER AFT CORNER CATCHS ON AIRFRAME AND BREAKS OFF. ORDER NEW.SDR HEED95120Spring · bearing failedBEARING SEPARATED BEYOND LIMITS. ORDER NEWSDR HEED95112Lamp · inoperativeLAMP INOPERATIVE. REPLACED WITH ONE FROM EXXON STOCKSDR HEED95111Temperature Bulb · inoperativeTEMP BULB INOPERATIVE REPLACED WITH ONE FROM EXXON STOCKSDR HEED95110Packing · leaking#1 INPUT QUILL SEAL CHANGE LEAKING. ORDER NEW PACKINGSDR HEED95109Packing · leaking#1 INPUT QUILL SEAL CHANGE LEAKING. ORDER NEW PACKINGSDR HEED95108Packing · leaking#1 INPUT QUILL SEAL CHANGE LEAKING. ORDER NEW PACKINGSDR HEED95107Packing · leaking#1 INPUT QUILL SEAL CHANGE LEAKING. ORDER NEW PACKINGSDR HEED95106Tab Loc-Nut · defective#1 INPUT QUILL SEAL CHANGE LEAKING. ORDER NEW SEALSDR HEED95103Temp Bulb · failed#1 ENGINE OIL TEMP WENT TO ZERO. INSTALLED NEW TEMP BULB FROM EXXON STOCK.SDR HEED9565Switch · failedPOSITION LIGHTS STAY ON WHEN SWITCH IS TURNED OFF. ORDER NEW.SDR HEED9563Lamp · failedSEARCH LIGHT BURNT OUT. ORDERED NEWSDR HEED9558Solenoid · inoperativeNR 1 ENGINE FLIGHT IDLE SOLENOID INOPERATIVE.SDR HEED9557Lamp · failedBULB BLOWN. ORDER NEWSDR HEED9556Link · wornT/R LINK WORN ORDER NEWSDR HEED9555Switch · defectiveDEFECTIVE PILOT TRIGGER SWITCH. ORDER NEWSDR HEED9553Rt Unit · failedNO POWER OUTPUT, SCOPE HAS A BLANK SCREEN.SDR HEED9552Lamp · failedLAMP BURNT. ORDERED NEW PARTSDR HEED9545Bulb · failedNO-SMOKING SIGN INOPERATIVE. ORDERED NEW PARTSDR HEED9540Air Valve Assy · brokenHALF OF AIR VALVE ASSY BROKE OFF. ORDERED NEW PARTSDR HEED9539Latch · brokenLATCH UNIT BROKEN. ORDERED NEW PARTSDR HEED9538Switch · defectiveDOOR LOCK LIGHT WILL NOT COME ON WHEN DOOR IS OPEN. ORDERED NEW PARTSDR HEED9537Tube Assy · damagedTUBE SMASHED. ORDERED NEW PARTSDR HEED9535Tube Assy · chafedFOUND TUBE CHAFED AT AFT FRD ON 600 HOUR INSPECTION. ORDERED NEW PARTSDR HEED9533Link Assy · wornLINK ASSY WORN. ORDERED NEW PARTSDR HEED9532Bearing Pad · unbondedUNIT UNBONDING. ORDERED NEW PARTSDR HEED9531Stack · crackedCRACKED STACK. ORDERED NEW PARTSDR HEED9530Lens · crackedUNIT CRACKED . ORDERED NEW PARTSDR HEED9529Actuator · inoperativeUNIT INOPERATIVE ORDERED NEW PARTSDR HEED9527Horn Assembly · link failedPART OF T/R ASSY PITCH CHANGE LINK FAILED.SDR HEED9526Hub Assy · link failedPITCH CHANGE LINK FAILEDSDR HEED9525Blade · link failedPITCH LINK FAILED. SN A513 & A517
Back to N236X, cancelled Jan 13, 2003