N216SW, cancelled Oct 23, 2014
Service difficulty reports · 93
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 = 'N216SW' AND deregistration_id = 'N216SW-2014-10-23' 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 = 'N216SW' AND deregistration_id = 'N216SW-2014-10-23' 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 SWIA200717777Skin · crackedFUSELAGE SKIN CRACKED AT MID FUSELAGE STATION BETWEEN FRAMES 21 LEFT AND 21 RIGHT, DISCOVERED DURING C-CHECK INSPECTION. FABRICATED AND INSTALLED DOUBLER FILLER PER EMBRAER AUTHORIZED REPAIR 1C 2007-120/00663 DATED 1/28/07 AND RII 53-800-1000.SDR SWIA200617218Sensor · malfunctionedAFTER TAKEOFF NOSE DOOR/GEAR WOULD NOT CYCLE TO THE UP POSITION. RED A INDCIATOR ILLUMINATED AND VIBRATION FROM NOSE OF THE ACFT. RETURNED TO SMX. REPLACED NOSE GEAR A UPLOCK HARNESS SENSOR IAW AMM 32-11-01. OPERATIONAL CHECKS GOOD.SDR SWIA200616923Fuse · blownEMERGENCY LIGHTS AT ROW 6 ARE INOPATIVE. REPLACED FUSE FOR EMERGENCY LIGHTS AT ROW 6. OPERATIONAL CHECKS GOOD.SDR SWIA200616410Switch · malfunctionedFIRST OFFICER'S ELEC TRIM SWITCH CONTINUALLY STICKS IN A SPLIT TRIM SETTING, CAUSING CONTINUAL "TRIM FAIL" WARNINGS. REPLACED THE FO'S ELECTRIC TRIM SWITCH. OPERATIONAL CHECK GOOD.SDR SWIA200616375Actuator · malfunctionedON CLIMBOUT IT FELT LIKE A JAMMED RUDDER ON THE RIGHT SIDE. REPLACED BLUE SYSTEM RUDDER ACTIVATOR. REF EMB 120 MM 27-22-02. OPERATIONAL CHECK GOOD.SDR SWIA200514836Control Panel · inoperativeSTALL PANEL INOPERATIVE. REPLACED STALL PANEL. OPERATIONAL CHECK GOOD.SDR SWIA200514485Actuator · malfunctionedELEVATOR TRIM WHEEL MORE FIRM THAN NORMAL TO OPERATE IN FLIGHT. REMOVED AND REPLACED LEFT ELEVATOR TRIM ACTUATOR IAW MM 27-32-02.SDR SWIA200514410Actuator · malfunctionedELEVATOR TRIM IS DIFFICULT TO MOVE AND RATCHETS DURING HAND MOVEMENT INFLIGHT. REPLACED LEFT AND RIGHT TRIM ACTUATOR ASSEMBLIES IAW MM 27-32-02. P/N 5299-1, S/N OFF 980, 728.SDR SWIA200413996Servo · bindingLT RUDDER PEDAL BINDING AT MID AND BOTTOM TRAVEL. REPLACED RUDDER SERVO MOTOR. OPERATIONAL TEST GOOD.SDR SWIA200413081Frame · crackedLEFT NACELLE FRAME ONE IS CRACKED ON INBOARD AND OUTBOARD SIDES. DISCOVERED DURING C-CHECK INSPECTION. REPLACED LEFT NACELLE FRAME ONE IAW 120 SB 120-54-0036 & 120 SRM 51-10-02 PG 3 PAR 3. ACCOMPLISHED PART II OF SB 120-54-0036.SDR SWIA200413080Frame · crackedRIGHT NACELLE FRAME ONE CRACKED ON INBOARD AND OUTBOARD SIDES. DISCOVERED DURING C-CHECK INSPECTION. REPLACED RIGHT NACELLE FRAME ONE IAW 120 SB 120-54-0036 PART II AND 120 SRM 51-10-02 PG 3 PAR 3, ACCOMPLISHED PART II OF SB 120-54-0036.SDR SWIA200412952Servo · malfunctionedFIRST FLIGHT RUDDER CHECK NOT SMOOTH WITH HYDRAULICS ON AND OFF. REMOVED AND REPLACED NR 1 RUDDER SERVO IAW MM 22-10-09. P/N: 622-5734-002, S/N ON: 10055, S/N OFF: 7980.SDR SWIA200412794Control Panel · malfunctionedCO-PILOT SIDE SHAKER/PUSHER ACTIVATES ON GROUND. REMOVED AND REPLACED STALL WARNING PANEL WITH A SERVICEABLE PANEL IAW 27-34-08. OPS CHECK GOOD. P/N: 120-34428-505.SDR SWIA200312706Computer · malfunctionedCAPTAINS AUTOPILOT WILL NOT ENGAGE. INSTALLED SERVICEABLE NR 1 AUTOPILOT COMPUTER AS NEEDED. OPS CHECKS GOOD. P/N ON 622-8315-403, S/N OFF 2901.SDR SWIA200312584Cooling Fan · malfunctionedSMOKE IN PASSENGER CABIN WHILE PARKED AT GATE WITH APU RUNNING. REMOVED AND REPLACED RIGHT GROUND COOLING FAN IAW 21-51-03.SDR SWIA200311927Connector · shortedAFTER TAKEOFF LANDING GEAR (ALL 3 WHEELS) WOULD NOT RETRACT. ALL SIX A & B GREEN LIGHTS REMAINED ILLUMINATED. ONLY RIGHT GEAR -A- LIGHT EXTINGUISHED. WITH LANDING GEAR LEVER IN THE DOWN POSITION ALL RED LIGHTS EXTINGUISHED. REMOVED AND REPLACED CONNECTOR PSDR SWIA200210862Control Box · malfunctionedGEAR WILL NOT RETRACT AFTER TAKEOFF. ALL GREEN LIGHTS ILLUMINATED AND ALL RED ILLUMINATED EXCEPT RIGHT MAIN -A- SYSTEM LIGHT DID NOT ILLUMINATE. BULBS TEST GOOD. RETURNED TO DRO. REPLACED LANDING GEAR RELAY BOX. OPS CHECKS GOOD.SDR SWIA200210709Switch · out of adjustON TAKEOFF ROLL THE CARGO DOOR LIGHT ILLUMINATED ALONG WITH A TRIPLE CHIME WARNING. ABORTED TAKEOFF. ADJUSTED FORWARD MICROSWITCH IAW MM 52-72-02. OPS CHECK GOOD.SDR SWIA200210529Wire Harness · faultyRT NP GAUGE FLUCTUATES IN FLIGHT. REMOVED AND REPLACED RIGHT ENGINE EEC WIRING HARNESS. OPS CHECKS GOOD.SDR SWIA200210498Sequence Valve · out of adjUPON GEAR RETRACTION LEFT MAIN GEAR DID NOT COME UP. RED A/B LIGHTS WITH RED B-LIGHT. CYCLED GEAR 3 TIMES. EACH TIME GEAR UP LIGHT INDICATION DID NOT CHANGE. RETURNED AND LANDED. ADJUSTED LT MLG O/B SEQUENCE VALVE CONTROL STOP. OPS CHECK GOOD.SDR SWIA200110450Controller · malfunctionedAFTER TAKEOFF, CABIN PRESSURE DIFFERENTIAL INCREASED TO 5 PSI AND CABIN ALTITUDE DROPPED TO 0 MSL. COULD NOT CONTROL WITH MANUAL CONTROLLER. RETURNED TO SLC. PERFORMED OPERATIONAL CHECK OF MANUALLY CONTROLLED OUTFLOW VALVE IAW MM 21-30-00. OPS CHECK GOOD.SDR SWIA200110376Ejector Valve · failedLEFT OUTBOARD STAB AND RT ENGINE INLET DEICE BOOTS FAILED INFLIGHT. RAN QRH, RETURNED TO IDA. REMOVED AND REPLACED EJECTOR VALVE FOR RT ENGINE INLET BOOTS. OPS CHECK GOOD WITH BOTH ENGINES RUNNING. CYCLED BOOTS 6 CYCLES. ALL CHECKS GOOD. P/N: 3D2376-06 SDR SWIA200110160Control Servo · malfunctionedEXCESSIVE AILERON FORCE REQUIRED ONCE AIRBORNE ALONG THE LONGITUDINAL AXIS. AIRCRAFT ROLLED LEFT ON TAKEOFF AND REQUIRED 3 3/4 UNITS OF AILERON TRIM WITH A CENTERED INCLINOMETER (BALL). ALMOST FELT AS IF THE AUTOPILOT WAS ENGAGED.REMOVE AND REPLACE AUTOPILOTSDR SWIA200110135Engine · fluctuatesLEFT ENGINE TORQUE FLUCTUATED 20 PERCENT DURING TAKEOFF RUN.FOUND LT ENGINE NH AND NP SENSORS BAD BY USING EEC BREAKOUT BOX. REMOVED AND REPLACED LH ENIGNE NH AND NP SENSORS. TRIMMED ENGINE AS REQUIRED.SDR SWIA200110138Filter · malfunctionedNR 2 HYDRAULIC FILTER LIGHT AFTER DEPARTURE. RETURNED TO SLC. REMOVED AND REPLACED BLUE SYSTEM RETURN FILTERS IAW 29-10-06. OPS CHECK AND LEAK CHECK SATISFACTORY.SDR SWIA200110122Hmu · malfunctionedLEFT ENGINE TORQUE SURGE FROM 71% TO 100% WITH ASSOCIATED YAW ON TAKEOFF.REMOVED AND REPLACED HMU AND FUEL PUMP PER EMB120 MM 73-21-00, 73-13-00. RAN LEFT ENGINE PER 71-00-00. OPS CHECK GOOD. NO LEAKS NOTED.SDR SWIA972474Fuel Door · unlatchedSERVICED DOOR LIGHT CAME ON ON TAKEOFF ROLL. ABORTED TAKEOFF. FOUND A CAMLOCK POPPED OPEN ON FUEL SERVICE DOOR. SECURED LOCK. SERVICE LIGHT OUT.SDR SWIA972394Fastener · unsecureSERVICE DOOR LIGHT COMES ON IN FLIGHT. RETURNED TO SLC. FOUND FASTENER OPEN ON FUEL DOOR. LATCHED FASTENER. OPS CHECK GOOD.SDR SWIA972285Indicator · failedLEFT ANALOG TORQUE GAUGE DROPPED TO ZERO ON TAKEOFF ROLL BELOW V1. ABORTED TAKEOFF. REMOVED AND REPLACED LEFT TORQUE GAUGE AS PER MM. OPS CHECKS GOOD. P/N ON: SEDL-OC2R, S/N ON: 961D, S/N OFF: 141.SDR SWIA971922Computer · malfunctionedABORTED TAKEOFF AFTER GETTING MASTER ''''CAUTION'''' LIGHT AND CONTINUOUS SINGLE CHIME AURAL WARNING. RETURNED TO THE GATE. RESET AURAL WARNING COMPUTER. NO MASTER ''''CAUTION'''' LIGHTS AND CHIMES ASSOCIATED WITH GROUND TEST.SDR SWIA971895Servo · failedAFTER AP DISENGAGED, LEFT AND RIGHT AILERONS WERE NEARLY LOCKED UP. REMOVED AND REPLACED AILERON SERVO IAW MM 22-10-05. REMOVED AND REPLACED AUTO PILOT TRANSFER BOX IAW MM 22-10-01. INSPECTED AILERON CONTROL PATH FROM YOKE TO AILERONS. OPS CHECKS GOOD PER SDR SWIA971494Sensor · failedWHEN RAISING LANDING GEAR LEFT MAIN A SYSTEM GAVE UNSAFE INDICATION ACCOMPANIED BY BAD VIBRATION. RETURNED TO ACV. REMOVED AND REPLACED LEFT MAIN LANDING GEAR A UPLOCK PROXIMITY SENSOR, OPS CHECK GOOD.SDR SWIA971507Switch · dirtyFORWARD DOOR LIGHT ILLUMINATED IN FLIGHT. RETURNED TO STS, COULD NOT DUPLICATE. ON GROUND OPS CHECK GOOD. CLEANED MICROSWITCHES.SDR SWIA971504Rccb · failedLOUD RELAY CYCLING TYPE SOUND EMITTING FROM CAPTAIN'S SIDE CONSOLE. RETURNED TO LAX. REPLACED GASPER FAN RCCB. OPS CHECK GOOD.SDR SWIA971449Computer · failedSTICK SHAKER ACTIVATED DURING CRUISE FLIGHT WITH AUTO PILOT ENGAGED. RETURNED TO LAX. CHECKED STALL PANEL, SAS COMPUTERS, AOA VANE AND ALL CHECKED GOOD. REPLACED KD127 AIR/GROUND RELAY. OPS CHECK GOOD.SDR SWIA971350Filter · dirtyRIGHT ENGINE FUEL FILTER LIGHT ILLUMINATED DURING FLIGHT. DIVERTED TO LAX. REPLACED RIGHT ENGINE FUEL FILTERS. RAN ENGINE AND OPS CHECKS GOOD. NO LEAKS NOTED.SDR SWIA971214Engine · malfunctionedHIGH PITCHED WHINE (GRINDING SOUND) COMING FROM RIGHT ENGINE AREA. RETURNED TO FIELD. INSPECTED RIGHT ENGINE TURBINE COMPRESSOR BLADES AND FOUND NO PROBLEMS. RAN RIGHT ENGINE FOR SEVERAL MINUTES. NO PROBLEMS NOTED.SDR SWIA971165Air/Ground Relay · malfunctionedAFTER NORMAL TAKEOFF UPON FLAP RETRACTION, FLAP AURAL WARNING SOUNDED, AUTO FEATHER WARNING THEN SOUNDED. ALL WARNINGS BRIEFLY STOPPED WHEN POWER LEVERS WERE MOVED TO DIFFERENT PLACE. HOWEVER, AURAL WARNING NEVER COMPLETELY SILENCED. RETURNED TO PSP. COULDSDR SWIA971072Actuator · out of adjustRIGHT MAIN GEAR WOULDN'T RETRACT UNTIL GEAR WAS CYCLED TWICE THEN THE RIGHT MAIN GEAR CAME UP AFTER 1 MIN AT 180 KIAS. RETURNED TO FIELD. FOUND RIGHT INBOARD FORWARD GEAR DOOR ACTUATOR TO BE TO LONG AND PUSHING GEAR DOOR PAST INBOARD SEQUENCE VALVE. ADJUSTEDSDR SWIA971009Duct · failedRIGHT DUCT LEAK LIGHT AND LOUD BANG IN FLIGHT. LIGHT REMAINED ON FOR 3 MINUTES. RIGHT ENGINE SECURED AND SHUTDOWN, DIVERTED TO PT MUGU NAVAL AIR STATION. FOUND RIGHT BLEED AIR DUCT SPLIT WITHIN RIGHT INBOARD LEADING EDGE. REMOVED DUCT FOR REPLACEMENT AND ISDR SWIA97843Relay Box · malfunctionedON DEPARTURE SELECTED GEAR UP, ALL GREEN AND RED LIGHTS REMAIN ON WITH NO GEAR OR GEAR DOOR MOVEMENT. CYCLED GEAR 3 TIMES, CHECKED CIRCUIT BREAKERS AND REFERENCES QRH. UNABLE TO RETRACT. RETURNED TO SMF. REPLACED LANDING GEAR RELAY BOX ASSEMBLY WITH SERVICSDR SWIA95594Pcu · malfunctionedRT SIDE PROP OVERSPEED ON TAKEOFF. ABORTED TAKEOFF. PROPELLER NP STABILIZED AT 102.5 TO 102.6 PERCENT AFTER 103.1 MAX. INSPECTED THE PCU (PROPELLER CONTROL UNIT) RIGGING AND INSPECTED BETA TUBE SEALS. REINSTALLED BETA TUBE IAW 61-10-02. FOUND TO BE WITHINSDR SWIA95553Prox Sensor · failedON TAKEOFF ROLL, AS POWER WAS APPLIED, RECIEVED AURAL WARNING FOR TAKEOFF TRIM. TAKEOFF WAS ABORTED. RETURNED TO GATE AND NOTICED AURAL WARNING CIRCUIT BREAKER OPEN. CIRCUIT BREAKER WOULD NOT RESET. REPLACED THE LEFT ELEVATOR TRIM PROXIMITY SENSOR WITH A N
Back to N216SW, cancelled Oct 23, 2014