N591ML, cancelled Jun 29, 2017
Service difficulty reports · 79
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 = 'N591ML' AND deregistration_id = 'N591ML-2017-06-29' 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 = 'N591ML' AND deregistration_id = 'N591ML-2017-06-29' 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 MASA200600051Warning Message · illuminatedASH 7142 BUF - ABORTED TAKEOFF. FLIGHT SPOILER STATUS MESSAGE. MAINTENANCE PLACED ON MEL. OPS CHECK GOOD.SDR MASA200600040Warning Message · illuminatedASH 7215 BMI - ABORTED TAKEOFF AND RETURNED TO GATE. STALL FAIL CAUTION MESSAGE. MAINTENANCE RESET SPOILER SYSTEM, RAN ENGINES AT HIGH POWER. OPS CHECK GOOD.SDR MASA200600013Computer · faultedASH 7248 ORD - ABORTED TAKEOFF DUE TO A STALL FAIL EICAS MESSAGE. MAINTENANCE RESET STALL PROTECTION COMPUTER. NO FURTHER DEFECTS NOTED.SDR MASA200501097B-Nut · leakingASH 7230 ORD - FUEL LEAKING FROM APU SHROUD. RESECURED TWO FUEL LINE B-NUTS. MAINTENANCE PLACED APU ON DEFERRAL SO SHROUD COULD COMPLETELY PURGE OF FUMES. AIRCRAFT RETURNED TO SERVICE. MAINTENANCE COULD NOT DUPLICATE LEAK.SDR MASA200501018Connector · unsecureFORWARD FACING EXIT SIGN IN CABIN INOPERATIVE. MAINTENANCE SECURED THE CONNECTION AT THE EMERGENCY LIGHT POWER SUPPLY.SDR MASA200500903Spoiler Sys · faultedASH 7212 IAD - INBOARD/OUTBOARD GROUND SPOILER FAULT AFTER TAKEOFF. MAINTENANCE RESET THE SPOILER SYSTEM AND THE OPS CK WAS NORMAL.SDR MASA200500791Wire · brokenASH 2762 PHL - ONE FLOOR PATH LIGHTING SEGMENT BROKEN. MAINTENANCE REPLACED THE SEGMENT.SDR MASA200500776Stall Warning · unknownASH 2699 PHL - ABORTED TAKEOFF DUE TO A STALL FAIL AND A CONFIG SPOILER MESSAGE. MX PERFORMED, OPS CHECK OF STALL SYSTEM. OPS CHECK GOOD.SDR MASA200500713Proximity Sensor · out of adjustASH 2621 PHL - NOSE GEAR DOOR OPEN MESSAGE IN FLIGHT. MX ADJUSTED PROXIMITY SENSOR, JACKED A/C AND DID GEAR SWINGS. NO FURTHER DEFECTS FOUND.SDR MASA200500633Light · inoperativeTHE EMERGENCY PATH LIGHTS AFT OF ROW 9 WERE NOT ILLUMINATED. MX REPOSITIONED THE LAST FLOOR STRIP AND OPS WERE NORMAL.SDR MASA200500530Wire · damagedOUT BOUND PILOT FOUND EMERGENCY FLOOR LIGHTS BETWEEN ROW 1 & 5 TO BE INOP. MX REPLACED CABLE ASSY & ACFT CONTINUED OPERATIONS.SDR MASA200500385Door · lack of lubeASH 2631 PHL TO ATL - THE CREW FOUND THE MAIN PASSENGER DOOR DIFFICULT TO OPEN. MAINTENANCE APPLIED LUBRICATION.SDR MASA200500271Control System · malfunctionedREJECTED TAKEOFF FOR SPOILER CONFIG MESSAGE ON EICAS AT 70 KTS. MESSAGE CLEARED AT 80 KTS. MX INSP MDC FOR FAULTS. NONE NOTED. MX RESET SPOILER CONTROL SYSTEM AND PERFORMED OPS CHECK. SYSTEM OPERATED NORMALLY.SDR MASA200500167Engine · leakingEMERGENCY DECLARED. SHUTDOWN NR 2 ENGINE AND DIVERTED TO IAD DUE TO LOSS OF OIL PRESSURE. MX IS IN THE PROCESS OF TROUBLESHOOTING.SDR MASA200500084Bulb · burned outONE EMERGENCY LIGHT IN OVERHEAD INOP. MAINTENANCE COMPLIED WITH MEL PROCEDURES. 2/7/05 MAINTENANCE RELAMPED, OPS CHECK GOOD.SDR MASA200500054Lamp · brokenEMERGENCY FLOOR LIGHTS INTERMITTENT AFT OF THE EXIT ROW. ACFT AOG FOR A POWER CABLE ASSY. 1/24/05 MAINTENANCE REPLACED EMERGENCY LIGHT CABLE STRIP, OPS CHECKED GOOD.SDR MASA200400522Apu · fireAFTER LANDING IN YUL AND SHUTTING DOWN THE APU FOR THE NIGHT THE GROUND CREW NOTICED FLAMES EMITTING FROM THE APU EXHAUST AREA. AS GROUND CREW WAS MOVING TO NOTIFY THE CREW, THE APU FIRE WARNING ALERTED IN THE COCKPIT AND SIMULTANEOUSLY DISCHARGED THE FIRE BOSDR MASA200400332Light · inoperativeASH 2810 YUL - CLT, EMERGENCY EXIT FLOOR STRIPS INOP. CONTRACT MX TROUBLESHOOTING, MX REPLACED LIGHTING STRIP AND BATTERY. BATTERY PART NR 2013-1A.SDR MASA200400305Light · inoperativeEMERGENCY EXIT LIGHT SWITCH LEFT IN THE ON POSITION. LIGHTS WERE INOPERATIVE. MX FOUND NO FAULT WITH EMERGENCY EXIT LIGHTING SYSTEM. OPS GOOD NO PARTS USED.SDR MASA200400109Angle · crackedLT FS 625 OBLIQUE ANGLE IS CRACKED. REPLACED 625 OBLIQUE ANGLE IAW BOMB CRJ SRM 51-42-21.SDR MASA200400108Angle · crackedRT FS 625 OBLIQUE ANGLE IS CRACKED. REPLACED CRACKED OBLIQUE ANGLE IAW BOMB CRJ SRM 51-42.21SDR MASA200400107Floor Support · crackedFS 621, RBL 40, WL 73 UNDER FLOOR SUPPORT ANGLE FROM RBL 32 TO RBL 44. FABRICATED REPAIR ANGLES IAW BOMB REO 601R-53-61-117 REV BSDR MASA200400106Angle · crackedFS 621, LBL 40, WL 73 UNDER SUPPORT ANGLE IS CRACKED. FABRICATED REPAIR ANGLES FROM P/N 601R-53-61-004-1 AND 601R-53-61-004-5 AND INSTALLED IAW BOMB REO 601R-53-61-117 REV BSDR SWIA200210879Tail Cone · cutAIRCRAFT'S RIGHT ENGINE JET PIPE MISSING INSPECTION COVER AND TAIL CONE HAS A 1.5 INCH CUT. REPLACED RIGHT ENGINE TAIL CONE ASSEMBLY. OPS CHECKS GOOD.SDR JBXA000288Flap · malfunctionedFLAPS FAIL AT 30 DEGREES ON SHORT FINAL. PERFORMED OPERATIONAL CHECK OF FLAP SYSTEM PER AMM 27-54-00. SYSTEM OPERATIONAL CHECKS NORMAL. OK FOR SERVICE.SDR JBXA000266Selector Valve · failedUPON APPROACH INTO LGA NOSE DIAGREE MESSAGE ON EICAS, NOSE GEAR FAILED TO EXTEND NORMALLY. A/C DIVERTED TO SWF WHERE EMERGENCY GEAR HANDLE WAS PULLED. A/C LANDED WITH OUT INCIDENT. LANDING GEAR WAS PINNED AND MAINTENANCE FERRIED TO RDU. TROUBLSHOOTING INDISDR JBXA000238Handle · detachedLANDING GEAR HANDLE FELL OFF IN HAND ON CLIMBOUT. REMOVED AND REPLACED IAW AMM 32-31-01.SDR JBXA000204Controller · failedSTAB CH1 INOP. STATUS MSG AND ASSOCIATED CB POPPED IN FLIGHT(2B8). REMOVED AND REPLACED HSTA IAW 27-42-01. REMOVED AND REPLACED HSMCU IAW CRJ AMM 27-42-05, OPS CK GOOD.SDR JBXA0000191Actuator · intermittentNO MANUAL OR AUTOPILOT STABILZER TRIM AFTER T/O. NO ASSOCIATED CAUTIONS. MOMENTARY STAB CH 1 INOP STATUS MESSAGE, F/O HAD MOMENTARY TRIM. REMOVED AND REPLACED STAB TRIM ACTUATOR IAW AMM 27-42-01. OPS CHECK GOOD.
Back to N591ML, cancelled Jun 29, 2017