N226SW, cancelled Mar 9, 2011
Service difficulty reports · 62
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 = 'N226SW' AND deregistration_id = 'N226SW-2011-03-09' 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 = 'N226SW' AND deregistration_id = 'N226SW-2011-03-09' 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 SWIA972062Boot · failedMIDDLE LEFT WING DEICE BOOT FAILED ON CLIMBOUT, BOTH TIMERS. RETURNED TO LAX. REMOVED AND REPLACED PRESSURE SWITCH FOR LEFT WING MIDDLE DEICE BOOT WITH SERVICEABLE UNIT. OPS CHECKS GOOD. P/N ON: 211C117-183, S/N: M414, S/N OFF: V08082A.SDR SWIA971991Afcs · malfunctionedON TAKEOFF ROLL ''''AUTO PILOT FAIL'''' AND TRIM FAIL LIGHTS ILLUMINATED ON MAP. TAKEOFF WAS ABORTED ON THE RUNWAY. INSPECTED WIRING TO AUTO PILOT COMPUTERS, FCP''S, APP-65A AND MAP PANEL. ALSO INSPECTED ALL APPLICABLE CONNECTORS FOR CONDITION AND SECURITY.SDR SWIA971678Switch · failedRIGHT ENGINE AIR INLET BOOT FAILED. RETURNED TO FIELD. REPLACED INLET PRESSURE SWITCH, OPS CHECK GOOD IAW MM CH 30. (P/N 211C117183) ON, (S/N V10043A) ON, (S/N 008) OFF.SDR SWIA971259Synchronizer · malfunctionedPROP SYNC CAUSES 3 PERCENT NP FLUCTUATION ON RIGHT PROPELLER. RETURNED TO LAX, MEL 61-24-1. REPLACED PROP SYNCHROPHASER IAW MM 61-24-01, OPS CHECKS GOOD.SDR SWIA971082Prop De-Ice · failedAFTER TAKEOFF, THE LEFT INLET FAILED. RETURNED TO LAX. ON APPROACH LEFT PROPELLER DE-ICE FAILED ON TIMER 1 AND NORMAL.OPERATED LEFT PROPELLER AND DE-ICE FOR 20 MIN AND ALL CHECKS GOOD.SDR SWIA97997Hinge · brokenATTEMPTED TO RETRACT LANDING GEAR, BOTH A AND B RED LIGHTS REMAINED ON FOR RIGHT MAIN GEAR. CYCLED GEAR AND ALL GREEN AND RED LIGHTS FOR RIGHT GEAR REMAINED ON. RETURNED TO LAX FOUND OUTBOARD RIGHT MAIN LANDING GEAR DOOR HINGE BROKEN. REPLACED HINGE WITH NESDR SWIA97920Handle · not latchedAFTER DEPARTURE CLIMBING THROUGH 10,000 FT, CABIN ATTITUDE WARNING CAME ON AND CABIN WILL NOT PRESSURIZE. RETURNED TO SLC. FOUND HANDLE ON RIGHT EMERGENCY DOOR AT ROW 6 CRACKED OPEN. RESET SAME.SDR SWIA97880Actuator · out of adjustRED GEAR LIGHT REMAIN ILLUMINATED AFTER GEAR RETRACTION. B-SYSTEM RED LIGHT EXTINGUISHED BUT A-SYSTEM LIGHT REMAINED ILLUMINATED, LEFT HAND GEAR LIGHTS. RETURNED TO FIELD. ADJUSTED LANDING GEAR ACTUATOR ON LEFT GEAR, SYSTEM OPS CHECKS GOOD.SDR SWIA97871Sequence Valve · malfunctionedAFTER TAKEOFF, LEFT MAIN GEAR FAILED TO FULLY RETRACT. BOTH A AND B RED LIGHTS REMAINED ILLUMINATED. RETURNED TO FIELD. TOOK AIRCRAFT TO GARRETT, SWUNG LANDING GEAR. ALL DOORS WOULD NOT CLOSE. CHANGED GEAR DOOR SEQUENCE VALVE, ADJUSTED LEFT STRUT GEAR ACTSDR SWIA97860Connector · water contamFLAP DISAGREEMENT LIGHT CAME ON AFTER TAKEOFF. RETURNED TO THE FIELD. CLEANED WATER FROM LEFT OUTBOARD FLAP CANNON PLUG. OPS CHECKS GOOD.SDR SWIA95689Eec · malfunctionedAFTER TAKEOFF, WITH CLIMB POWER SET, RT ENGINE TORQUE CLIMBS TO 109 PERCENT. UNABLE TO CONTROL WITH POWER LEVER. RETURNED TO YUM. SWAPPED EEC FROM SIDE TO SIDE. PROBLEM STAYED WITH RT SIDE. RAN ENGINE AT TAKEOFF POWER FOR 20 MINUTES WITH EEC OFF, NO PROBLSDR SWIA95688Ground Block · not groundedAFTER DEPARTURE, ON CLIMB OUT, AFTER SETTING CLIMB DOWN, AIRCRAFT SURGED AND RT ENGINE TORQUE SETTING WENT TO 127 PERCENT. WHILE REDUCING POWER, PROP WAS AT 127 PERCENT, TORQUE MOMENTARILY 1 SEC OR LESS. AFTER INSPECTION, FOUND CASE GROUND BLOCK NOT GROUNDED
Back to N226SW, cancelled Mar 9, 2011