N579SW, cancelled Mar 3, 2017
Service difficulty reports · 112
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 = 'N579SW' AND deregistration_id = 'N579SW-2017-03-03' 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 = 'N579SW' AND deregistration_id = 'N579SW-2017-03-03' 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 SWIA972618Sensor · unserviceableON DEPARTURE LANDING GEAR WOULD NOT RETRACT NORMALLY. USED OVERRIDE BUTTON FOR RETRACTION. AFTER GEAR EXTENSION ''IDLE 1 UNLK'' AND ''IDLE 2 UNLK'' ILLUMINATED. CONTINUED PER QRH WITH NO REVERSE ON LANDING. UPON LANDING ''ELEC'' LIGHT ILLUMINATED. NO NOSEWSDR SWIA972446Anti-Ice System · failedLEFT AOA HEAT FAILS IN FLIGHT, EVERY 5 TO 15 SECONDS. RETURNED TO LAX. INSTALLED NEW AOA RELAYS K0185 AND K0187. RAN FOR 20 MINUTES. OPS CHECK GOOD ON GROUND AT THIS TIME.SDR SWIA972419Sensor · failedLEFT AOA FAILED AND STAYED FAILED AFTER RESETTING. RETURNED TO LAX. REPLACED CURRENT SENSOR. ALL CHECK GOOD. P/N ON 120-41406-501, S/N OFF 120-347.SDR SWIA972417Warning System · false activationTAKEOFF TRIM FAIL AURAL WARNING WITH APPLICATION OF TAKEOFF POWER. ALL SWITCHES AND TRIM SETTINGS VERIFIED IN LIMITS. ABORTED TAKEOFF. RAN AIRCRAFT AT TAKEOFF POWER IN TAKEOFF CONFIGURATION. CYCLED TRIM THROUGHOUT GREEN BAND WITH NO DEFECTS NOTED. OPS CHESDR SWIA972130Windshield · failedLEFT FRONT WINDSHIELD SHATTERED. INSPECTED AND FOUND OUTER LAYER OF GLASS TO BE CRACKED. NO DAMAGE TO INNER LAYERS. INSTALLED SERVICEABLE CAPTAIN WINDSHIELD IAW EMB MM 56-10-01. ALSO SEE ATTACHED RII 56-301 CARD. WINDSHIELD HEAT CHECKS GOOD. PRESSURIZATISDR SWIA972091Control Panel · malfunctionedAUTOPILOT ENGAGED AND PITCHED UP WHILE AIRCRAFT WAS ON GROUND. FOUND WATER INSIDE AP CONTROL PANEL. REPLACED AP CONTROL PANEL. OPS CHECK GOOD. P/N: 622-6684-006, S/N ON: 2118, S/N OFF: 2803.SDR SWIA971938Aileron · malfunctionedHEAVY AND SLUGGISH ROLL CONTROL IN AILERON. RETURNED TO LAX. INSPECTED AILERONS, FOUND NOTHING PROTRUDING. ALSO INSPECTED ALL BOLTS, ALL ARE SECURE. CONTROL YOKES FEEL NORMAL. OPS CHECKS GOOD.SDR SWIA971882Switch · out of adjSERVICE DOOR LIGHT CAME ON DURING TAKEOFF. ABORTED TAKEOFF, ADJUSTED MICRO SWITCHES FOR FUEL DOOR AND OPS CHECKS GOOD.SDR SWIA971477Control Box · failedAFTER TAKEOFF, RIGHT MAIN GEAR WOULD NOT RETRACT AND INTRANSIT LIGHTS WERE ILLUMINATED. RETURNED TO LAX. REPLACED LANDING GEAR CONTROL BOX. RETRACTED GEAR A DOZEN TIMES, OPS CHECK GOOD.SDR SWIA971448Boot · failedBOTH ENGINE INLET DEICER BOOTS FAILED IN FLIGHT. RETURNED TO SBA. INSPECTED LEFT AND RIGHT ENGINE INLET DEICE BOOTS AND BLEED LINES. PERFORMED MONITOR TEST AND RAN AIRCRAFT FOR LEFT AND RIGHT ENGINE INLET DEICE BOOTS. OPS CHECKS GOOD ON GROUND .SDR SWIA971438Switch · failedON DEPARTURE, NOSE WHEEL INDICATED 1 B GREEN, 1 -B+ RED. RETURNED TO PSP. REPLACED NOSE GEAR B INDICATION DOWNLOCK PROX SWITCH HARNESS. SWUNG GEAR NUMEROUS TIMES. ALL INDICATIONS GOOD. OPS CHECK GOOD.SDR SWIA971444Monitor · failedALL LEADING EDGE DEICING BOOTS FAIL (17,000 AUTO/NORM) INCLUDING ENGINE AIR INLET FAILURE (BOTH INLET BOOTS). DIVERTED TO PSP FROM LAX. REPLACED DEICE MONITOR. CYCLED ALL DEICE BOOTS SEVERAL TIMES, OPS CHECKS GOOD.
Back to N579SW, cancelled Mar 3, 2017