N520US, cancelled May 16, 2017
Service difficulty reports · 22
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 = 'N520US' AND deregistration_id = 'N520US-2017-05-16' 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 = 'N520US' AND deregistration_id = 'N520US-2017-05-16' 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 DALA1012245520Battery Pack · inoperativeOVERHEAD EMERGENCY EXIT SIGN FWD OF LAV D INOPERATIVE. REPLACED POWER SUPPLY AND BATTERY AT DOOR 3R IAW AMM. OPS CHECK OK.SDR NWAA093705520Battery · dischargedON 3 DAY FLIGHT DECK MODIFICATION FOUND RT DOOR EMERGENCY LIGHT INOP. MAINTENANCE REPLACED POWER SUPPLY BATTERY. OPS CHECK OKAY. RETURNED TO SERVICE.SDR NWAA092105520Brake Assy · bindingDURING THE TAKEOFF ROLL, THE AIRCRAFT BEGAN TO DRIFT LEFT OF THE RUNWAY CENTERLINE, THE CREW ATTEMPTED TO CORRECT THE DRIFTING WITH THE APPLICATION OF RIGHT RUDDER BUT WERE UNSUCCESSFUL AND ABORTED THE TAKE OFF BETWEEN 70 AND 80 KNOTS. AFTER AN UNEVENTFUL RETSDR NWAA091405520Battery Pack · defectiveDURING AN OVERNIGHT LINE CHECK THE EMERGENCY LIGHTS IN ROW 14 THROUGH ROW 23 WOULD NOT TEST. MAINTENANCE FOUND TWO BATTERY PACK TO BE DEFECTIVE AND REPLACED THEM. SYSTEM OPERATION WAS NORMAL AFTER THE BATTERY PACKS WERE REPLACED.SDR NWAA084565520Battery Pack · defectiveDURING AN OVERNIGHT LINE CHECK THE EMERGENCY ESCAPE PATH LIGHTING IN THE AFT SECTION OF THE PAX CABIN WAS FOUND TO BE INOPERATIVE. MX FOUND THE ASSOCIATED BATTERY PACK TO BE DEFECTIVE AND REPLACED IT. ALL OPS CHECKED GOOD AFTER REPLACEMENT.SDR NWAA074365520Power Supply · dischargedDURING OVERNIGHT CHECK, FOUND EMERGENCY FLOOR LIGHTS FROM ROW 14 TO 23 INOP. MAINTENANCE REMOVED AND REPLACED POWER SUPPLY. OPERATIONAL CHECKED GOOD AND AIRCRAFT WAS RETURNED TO SERVICE.SDR NWAA072955520Power Supply · inoperativeDURING OVERNIGHT CHECK, FOUND EMERGENCY FLOOR TRACK LIGHTS IN FIRST CLASS INOP. MAINTENANCE REMOVED AND REPLACED POWER SUPPLY. OPERATIONAL CHECKED GOOD AND AIRCRAFT RETURNED TO SERVICE.SDR NWAA071965520Wire · cutFIRST CLASS EMERGENCY FLOOR PROXIMITY LIGHTS WILL NOT TEST. FOUND FLOOR PROXIMITY LIGHT WIRES CUT AND SEAT TRACK COVER INSTALLED INCORRECTLY AT SEATS 2 C/D. REPAIRED WIRES PER SWPM 20-15-26, OPS CHECKS GOOD. OK FOR SERVICE.SDR 0601445520Battery Pack · inoperativeDURING LINE CHECK FOUND MID CABIN EMERGENCY LIGHTS INOPERATIVE. REPLACED EMERGENCY LIGHT BATTERY PACK ASSEMBLY. OPERATIONALLY CHECKED AND RETURNED TO SERVICE.SDR 0402195520Floor Support · corrodedDURING H-CHECK FOUND CORROSION ON GALLEY FLOOR SUPPORT AT BS 365 RBL 24. REPAIRED PER EA 55-201148.SDR 0104905520Actuator · failedDURING APPROACH, UPON SELECTION OF FLAPS 1, THE LEADING EDGE SLAT DISAGREE WARNING LIGHT ILLUMINATED. AN EMERGENCY WAS DECLARED, THE FLIGHT CONTINUED THE APPROACH, AND LANDED WITHOUT INCIDENT. MAINTENANCE REPLACED THE NR 20 LEADING EDGE ACTUATOR. SUBSEQUENTSDR 0102805520Line · rupturedON GEAR EXTENSION, THE LEFT HYDRAULIC SYSTEM QUANTITY DECREASED TO ZERO AND A "L HYD SYS PRESS" MESSAGE WAS DISPLAYED. FLIGHT LANDED WITHOUT INCIDENT. MAINTENANCE REPLACED THE LEFT MAIN LANDING GEAR DOWNLOCK RETURN LINE. OPERATIONAL TESTS WERE SATISFACTORY.SDR 0004095520Slide · rupturedDURING SLIDE SHOP TEST AT PERATING PRESSURE, INFLATABLE SEAM RUPTURED AT LEFT DOG LEG. SLIDE WILL BE OVERHAULED AND RECEIVE A NEW INFLATABLE.SDR 0003785520Circuit Breaker · trippedR RECIR FAN EICAS MESSAGE AND RECIRCULATION FAN INOPERATIVE LIGHT ILLUMINATED WITH SWITCH POSITIONED ON. MAINTENANCE FOUND FIRE DAMAGE TO THE FAN WIRE HARNESS, INSULATION BLANKETS, FAN ELECTRICAL PLUG, AND LOWER FAN BRACKET. REPAIRED FAN WIRE HARNESS. REPLASDR 0002875520Battery Pack · inoperativeEMERGENCY FLOOR LIGHTS FROM SEAT 23 - 33 INOPERATIVE DURING TEST. MAINTENANCE REPLACED THE BATTERY PACK AT DOOR 3R, OPERATIONAL CHECK OK.SDR 9811435520Floorbeam · corrodedDURING T CHECK, FOUND CORROSION ON UPPER SURFACE OF FLOORBEAM AROUND FASTENER HOLE FS 1681, LBL 39.5. REPAIRED PER EA 55-163314.SDR 9706955520Floorbeam · corrodedDURING PERIODIC CHECK, FOUND CORROSION ON CABIN FLOORBEAM AROUND NUT PLATES ON TOP SURFACE FS 1660, BL 0 THROUGH LBL 56. REPAIRED PER EA 55-123842.SDR 9623285520Oil Filter Light · illuminatedAFTER PUSHBACK, THE NR 1 ENGINE OIL FILTER EICAS MESSAGE WAS DISPLAYED. AIRCRAFT RETURNED TO THE GATE. GROUND MAINTENANCE CHECKED MAG PLUGS AND REPLACED MAIN OIL STRAINER. NO CONTAMINATES WERE FOUND.SDR 9511805520Door Warning · malfunctionedDURING TAKEOFF ROLL DTW-MEM, LEFT AFT DOOR WARNING LIGHT ILLUMINATED. ABORTED TAKEOFF WITHOUT INCIDENT. OPERATIONAL CHECK OK, NO TROUBLE FOUND.SDR 9501755520Idg · malfunctionedAT THE START OF TAKEOFF, THE LEFT GENERATOR DRIVE LIGHT FLICKERED AND THE LEFT GENERATOR CONTROL LIGHT ILLUMINATED; ABORTED TAKEOFF. PLACED THE LEFT IDG ON MEL 24-00-1. REPLACED THE LEFT INTEGRATED DRIVE GENERATOR AT MSP. SYSTEM CHECK ON RUN-UP WAS NORMAL.SDR 9500715520Control Cable · lack of lubeRECEIVED CONFIGURATION WARNING AFTER TAKEOFF THRUST AND EPR MODE WAS SET. ABORTED TAKEOFF. SET AND RELEASED THE PARKING BRAKE HANDLE AND THE LIGHT REMAINED OUT. CONTINUED TAKEOFF. LUBRICATED BRAKE CABLE ON ARRIVAL IN DCA. PARKING BRAKE RELEASE CHECKED NORSDR 9500405520Indication · malfunctionDURING CRUISE, RECEIVED 'L ENG OIL COOL' AND 'L ENG PRICONT' STATUS MESSAGE. THE EPR BLANKED OUT AT THE LOWER POWER SETTINGS BELOW 1.1 EPR. OIL TEMPERATURES REMAINED IN NORMAL POWER RANGES. AIRCRAFT DIVERTED TO DTW AND LANDED WITHOUT INCIDENT. MAINTENANCE
Back to N520US, cancelled May 16, 2017