N212SW, cancelled Apr 20, 2007
Service difficulty reports · 71
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 = 'N212SW' AND deregistration_id = 'N212SW-2007-04-20' 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 = 'N212SW' AND deregistration_id = 'N212SW-2007-04-20' 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 SWIA971267Servo · jammedRUDDER PEDALS LOCKED DURING APPROACH AND LANDING. WAS ABLE TO REGAIN CONTROL WITH TILLER ON THE RUN WAY. FOUND RUDDER SERVO JAMMED. REPLACED RUDDER SERVO. OPS CHECKS GOOD.SDR SWIA971239Seal · failedCLIMBING THROUGH F230, CABIN ALTITUDE STARTED A 2500-3500 MINUTE CLIMB. SWITCHED TO MANUAL, NO HELP. CABIN CONTINUED CLIMB. PERFORMED DESCENT, MASKS FELL. LANDED UNPRESSURIZED. NO DOOR LIGHTS NO OTHER UNUSUAL WITH A/C PERFORMANCE. FOUND CARGO DOOR SEAL BSDR SWIA971234Rudder Light · illuminatedRUDDER LIGHT ON MAP ASSOCIATED WITH RUDDER OVER BOOST ON OVER HEAD ILLUMINATED IN FLIGHT. RETURNED TO SLC. PERFORMED RUDDER OVER BOOST TEST IAW MM 27-22-00. INSPECTED IAW FAULT ISOLATION MANUAL 27-24-90 WITH PITOT STATIC PRESSURE. NO FAULT FOUND AT THIS TISDR SWIA971222Pack · malfunctionedON TAKEOFF LEFT BLEED OVERHEAT ILLUMINATED AND EXTREMELY HOT AIR CAME OUT OF AIR CONDITIONING VENTS AND BLEED EYELETS. RETURNED TO SLC. OPERATED BOTH PACKS FROM APU BLEED. NO FAULT FOUND. PACKS OPERATE NORMAL.SDR SWIA97987Antenna · corrodedREMOVE NR 2 TRANSPONDER ANTENNA DUE TO CORROSION. REMOVED AND REPLACED NR 2 TRANSPONDER ANTENNA, OPS CHECKS GOOD.SDR SWIA97835Prox Switch · failedAFTER DEPARTURE WITH GEAR HANDLE IN UP POSITION, LEFT MAIN GEAR INTRANSIT LIGHT A-SYSTEM ILLUMINATED, ACCOMPANIED BY RUMBLING NOISE. CYCLING GEAR DUPLICATED PROBLEM. RETURNED TO FIELD. REPLACED LEFT GEAR UPLOCK A-PROX SWITCH, OPS CHECKS GOOD.SDR SWIA95737Actuator · failedAFTER DEPARTURE, LEFT MAIN LANDING GEAR WOULD NOT RETRACT. GEAR DOORS SEEMED TO BE OPEN, BUT NOT CLOSING. LANDING GEAR CAME DOWN WITHOUT ANY PROBLEM. REPLACED LEFT GEAR ACTUATOR AND LEFT GEAR SHUTOFF VALUE IAW MM 32-32-11, OPS CHECK AND LEAK CHECK GOOD.SDR SWIA95728Latch Mech · malfunctionedNOSE LANDING GEAR WOULD NOT CYCLE UP AND RED TRANSIENT 'A' AND 'B' LIGHTS STAYED ON. JACKED AIRCRAFT AND INSPECTED GEAR DOORS AND LATCHING MECHANISMS, FOUND NO DEFECTS. CYCLED GEAR NUMEROUS TIMES IN HANGER, ALL CHECKS NORMAL. DID FIND LANDING GEAR LT HAND DSDR SWIA95717Sequence Valve · failedAFTER TAKEOFF, RIGHT MAIN GEAR WOULD NOT RETRACT AND RED LIGHT STAYED ON. TOWER VERIFIED THAT GEAR DID NOT RETRACT. REPLACED RIGHT MAIN LANDING GEAR OUTBOARD SEQUENCE VALVE. CYCLED GEAR SEVERAL TIMES, OPS CHECK GOOD AND TEST FLIGHT SATISFACTORY.SDR SWIA95693Prox Sensor · failedAFTER TAKEOFF AT LAX, NOSE GEAR WOULD NOT COME UP. CYCLED GEAR SEVERAL TIMES AND GEAR WOULD NOT CYCLE UP OR DOWN. ELECTRICALLY OVERRIDED GEAR SUCCESSFULLY AND RETURNED TO LAX WITHOUT INCIDENT. REPLACED A-SYSTEM DOWN INDICATION PROXIMITY SENSOR. CYCLED GEARSDR SWIA95642Control Cable · wornRT RUDDER INBD AFT CABLE WORN. REPLACED RT RUDDER INBD AFT CABLE PER MM 27-00-01.SDR SWIA95641Control Cable · wornRT RUDDER AFT OUTBD CABLE WORN. REPLACED RT RUDDER OUTBD AFT CABLE PER MM 27-00-01.SDR SWIA95640Tip · damagedRT WING TIP DAMAGED AND DELAMINATING, NEEDS TO BE REPLACED. FITTED NEW WING TIP FOR RT WING.SDR SWIA95639Clips · crackedRT WING RIB 16 HAS 2 CRACKED WING SUPPORT CLIPS ON BOTTOM. REPLACED 2 WING SUPPORT CLIPS ON RT WING RIB 16 IAW SB 120-57-0031.SDR SWIA95638Clips · crackedRT WING RIB 15 HAS 3 CRACKED WING SUPPORT CLIPS ON BOTTOM. REPLACED 3 WING SUPPORT CLIPS ON RT WING RIB 15.SDR SWIA95637Clips · crackedLT WING RIB 15 HAS THREE CRACKED WING SUPPORT CLIPS. REPLACED 3 WING SUPPORT CLIPS ON LT WING RIB 15, IAW SB 120-57-0031.SDR SWIA95636Clips · crackedLT WING RIB 16 HAS THREE CRACKED WING SUPPORT CLIPS ON UPPER SIDE. REPLACED THREE WING SUPPORT CLIPS ON LT WING RIB 16 IAW SB 120-57-0031, CLIPS INSTALLED.SDR SWIA95579Fitting · brokenRIGHT OUTBOARD NACELLE FLAP BELL CRANK BROKEN AT HARD MOUNT. REPLACED RT NACELLE FLAP IAW MM 27-50-02 AND PER RII CARD NUMBER 18. OPERATIONALLY CHECKS GOOD.SDR SWIA95554Starter Gen · failedLOST THE LEFT GENERATOR ON DESCENT. GENERATOR WILL NOT RESET. REPLACED THE LEFT STARTER/GENERATOR. OPERATIONALLY CHECKS GOOD.SDR SWIA95535Flow Valve Line · loose3 MIN AFTER TO, RIGHT DUCT LEAK WARNING CAME ON. DECREASED POWER AND LIGHT STAYED ON. SHUT DOWN THE RIGHT ENGINE AND RETURNED TO FIELD. LIGHT STAYED ON FOR FOUR MINUTES AFTER ENGINE SHUT DOWN. TIGHTENED LOOSE LINE ON FLOW VALUE. OPS CHECKS GOOD. SEE FL 7SDR SWIA95525Retract Mech · lack of lubeAFTER TAKEOFF FLAPS WOULD NOT RETRACT. THERE WAS A DISAGREEMENT BETWEEN OUTBD NACELLE AND INBOARD FLAPS. FAULT CLEARED AFTER LANDING. INSPECTED OUTBD FLAPS. CLEANED AND LUBRICATED ROLLERS. CYCLED FLAPS SEVERAL TIMES. OPS CHECKS GOOD. SEE FL 75711 FOR ME
Back to N212SW, cancelled Apr 20, 2007