N942ML, cancelled Feb 28, 2017
Service difficulty reports · 37
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 = 'N942ML' AND deregistration_id = 'N942ML-2017-02-28' 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 = 'N942ML' AND deregistration_id = 'N942ML-2017-02-28' 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 GTIA9901060Bulb · failedLEFT COCKPIT EMERGENCY LIGHT INOPERATIVE. REPLACED BULB OPERATION CHECKED GOOD IAW 33-50-DC-9 MAINTENANCE MANUAL. (M)SDR GTIA9901032Bulb · failedDTW - FLT 592 - LEFT COCKPIT EMERGENCY LIGHT INOPERATIVE. REPLACED BULB. OPERATIONAL CHECKED GOOD IAW 33-50 DC9 MM. (X)SDR GTIA9900572Slide · disengagedL1 SLIDE PACK FELL OFF COMPLETELY CASING AND SLIDE. REINSTALLED L1 SLIDE PACK AND SLIDE COVER IAW DC-9 MM 25-62-0. SLIDE PACK AND COVER SECURED. OPERATION CHECK GOOD. (M)SDR GTIA9800100Skin · tornDTW - AT GATE, BAGGAGE CART DRIVER INTO RT AFT OF AIRCRAFT. PUNCTURE IN SIDE OF FUSELAGE JUST AFT OF BAGGAGE DOOR. PERFORMED FUSELAGE SKIN EXTERNAL RPAIR FROM FS 937 TO FS 950 BETWEEN L23R AND L26R IAW 08-98-53-012 FROM 8-28-98. DRAWING 53-98445-1 PAINTED ASDR GTIA9800058Power Supply · inoperativeON DAILY, FOUND FORWARD GALLEY AND COCKPIT OVERHEAD EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED FORWARD GALLEY AND COCKPIT OVERHEAD EMERGENCY BATTERY POWER SUPPLY IAW DC0 MM 33-53-0. OPERATIONAL CHECK GOOD. (M)SDR GTIA9800047Battery Pack · dischargedCOCKPIT EMERGENCY LIGHT (BOTH BULBS) WILL NOT TEST WHEN CABIN EMERGENCY LIGHT SWITCH PULLED IN ON POSITION. RESET BATTERY PACKS OPERATIONAL GOOD AIW MM 33-50. (M)SDR GTIA9800042Battery Pack · dischargedFOUND EMERGENCY LIGHT OVER OBSERVERS SEAT INOP. REMOVED AND REPLACED BATTERY PACK IAW MM 33-50, OPERATIONAL CHECK GOOD. (M)SDR GTIA9800002Power Unit · inoperativeDTW - THE UPPER EMERGENCY FLASHLIGHT IS OUT IN AFT CABIN. REPLACED POWER UNIT IN FLASHLIGHT IN AFT CABIN. (M)SDR GTIA9800001Wire · cutDTW - EMERGENCY FLOOR TRACK LIGHTING IS OUT IN TAILCONE. FOUND WIRES CUT UNDER MOST AFT CABIN FLOOR TRACK LIGHTING. RE-ATTACH WIRES, OPS CHECK IAW DC-9 MM CH 20-50-1. (M)SDR GTIA9700402Wire · brokenBOS - FLT 1605 - EMERGENCY TRACK LIGHTS INOPERATIVE BY AISLE 16. REPAIRED WIRE AT SEAT 16. INSTALLED COVER. OPS CHECK OK IAW MM 33-00. (M)SDR GTIA9700399Slide Cover · looseDTW - FLT 640 - SLIDE PACK COVER CAME LOOSE ON FORWARD CABIN ENTRY DOOR WHEN DOOR WAS OPENED IN DTW. REINSTALLED FWD LEFT EMERGENCY ESCAPE SLIDE IAW DC9MM 25-61-0. RII INSPECTION PERFORMED. (M)SDR GTIA9700383Tires · out of roundDTW - ABORTED TAKEOFF (70 KIAS), EXTREME VIBRATION AND NOISE POSSIBLE FROM NOSE WHEEL. FOUND BOTH NOSE TIRES OUT OF ROUND. REPLACED LEFT AND RIGHT NOSE WHEEL ASSEMBLIES IAW CH 32-40-2. TIRES SERVICED TO 140 PSI. PERFORMED REJECTED TAKEOFF INSPECTION IAW GMSDR GTIA9700352Lens · missingTPA - FLT 215 - RED TRACK LIGHT LENS MISSING AT ROW 1. REPLACED MISSING TRACK LENS AT ROW 1. LIGHT OPS OK. (M)SDR GTIA9700342Lens · missingDTW - FLT 640 - LENS COVER MISSING FROM VERY FORWARD PART OF EMERGENCY FLOOR LIGHTING. RE-INSTALLED LENS COVER IAW DC-9 MM 33-50. (M)SDR GTIA9700314Throttle · stuckDTW - FLT 637 - ABORTED TAKEOFF, RETURNED TO GATE. ON TAKEOFF, LEFT THROTTLE LEVER STUCK THREE-FOURTHS OF THE WAY. TAKEOFF ABORTED AT DTW. INSPECTION REVEALED LOOSE HARDWARE ASSY AT NR 1 GEARBOX, SECURED AND SAFETIED LOOSE HARDWARE; ALSO, REPLACED POWER CONSDR GTIA9700304Light · looseDTW - FLT 640 - THE FORWARD SECTION OF THE EMERGENCY FLOOR LIGHTING NEEDS SECURED. RE-SECURED EMERGENCY FLOOR LIGHTING TRACK. OPS CHECK GOOD. (X)SDR GTIA9700301Lens · missingDTW - FLT 428 - BOTH FORWARD AND AFT CABIN EMERGENCY EXITS STRIP LIGHTS BROKE. REPLACED MISSING LENS AND RE-SECURED LIGHTING STRIP. OPS CHECK NORMAL PER DC-9 MM 33-50-0. (X)SDR GTIA9700281Pitch Control · malfunctionedACY - FLT 181 - AUTO-PILOT CONTROL IS UNRELIABLE IN CLIMB, DESCENT, OR ALT HOLD MODES. WILL NOT HOLE ASSIGNED VERT SPEED AND STARTED A SUDDEN DESCENT WHEN IN ALT HOLD. DMI'D PER MEL 22-16-1-6. DMI NR 00460. PLACARD INSTALLED CAT 'C'. (M)SDR GTIA9700277Torque Link · damagedMYR - FLT 1703 - TOWER FLY BY FOR GEAR DOWN INDICATION. WITH GEAR HANDLE DOWN AMBER 'GEAR DOOR OPEN' LIGHT ILLUMINATES WITH HANDLE UP 'LEFT GEAR UNSAFE' LIGHT ILLUMINATES. FOLLOWED FLOM. REMOVED LEFT MLG DOOR. REPAIRED LEFT MLG DOOR IAW SRM CH 52. REINSTASDR GTIA9700253Bolt · looseDTW - FLT 174 - CHECK FORWARD CARGO DOOR, NWA RAMP CREW SAID IT WAS LOOSE. INSPECTED HINGE BRACKETS ON FORWARD CARGO DOOR. FOUND FORWARD HINGE SPRING BOLT LOOSE. ADJUSTED SAME IAW 52-30-0. DOOR OPS CHECK NORMAL. (M)SDR GTIA9700166Connector · looseDTW - REPLACED ROLL COMPTER FOR AUTO-PILOT TROUBLESHOOTING. REPLACE PITCH COMPUTER CANNON PLUG FOR AUTO-PILOT SYSTEM TROUBLESHOOTING. REF DMI NR 00196 AUTO-PILOT WILL NOT ENGAGE WITH ELEVATOR SERVO ON. REMOVED AND REPLACED AUTO-PILOT ROLL COMPUTER, AUTO-PILSDR GTIA9700159Roll Computer · malfunctionedDTW - REPLACED ROLL COMPUTER FOR AUTO-PILOT TROUBLESHOOTING. REPLACE PITCH COMPUTER CANNON PLUG FOR AUTO-PILOT SYSTEM TROUBLESHOOTING. REF DMI NR 00196 AUTO-PILOT WILL NOT ENGAGE WITH ELEVATOR SERVO ON. REMOVED AND REPLACED AUTO-PILOT ROLL COMPUTER, AUTO-PISDR 97ZZZM450Pitch Computer · malafunctionedDTW - REPLACED ROLL COMPUTER FOR AUTO-PILOT TROUBLESHOOTING. REPLACE PITCH COMPUTER CANNON PLUG FOR AUTO-PILOT SYSTEM TROUBLESHOOTING. REF DMI NR 00196 AUTO-PILOT WILL NOT ENGAGE WITH ELEVATOR SERVO ON. REMOVED AND REPLACED AUTO-PILOT ROLL COMPUTER, AUTO-PISDR GTIA9700177Wheel · shimmiesDTW - FLT 566 - NOSE WHEEL SHIMMIES DURING TAKEOFF. REMOVED AND REPLACED NR 2 NOSE WHEEL ASSY IAW DC-9 MM 32-42. OPS CHECK GOOD. (X)SDR GTIA9700185Fuel Probe · leakingMYR - AFTER FUELING IN MYR, FUEL STARTED LEAKING AT WING ROOT ON AIRCRAFT, LEFT. INSPECTED WING ROOT AND UPPER WING SURFACE, FOUND NR 2 FUEL PROBE LEAKING. REMOVED AND REPLACED DEFECTIVE O-RING PACKING. LEAK CHECK GOOD. (X)SDR GTIA9700165Trim Switch · failedDTW - FLT 174 - AFTER LANDING, ALT TRIM RUNAWAY. RAN PRIMARY TRIM IN OPPOSITE DIRECTION AND RUNAWAY STOPPED. REMOVED AND REPLACED HORIZ STABILIZER ALT TRIM SWITCH IAW DC-9 MM 27-40-9, OPS CHECK GOOD. (M)SDR 97ZZZM261Autopilot · malfunctionedFLT 640 - DTW - AUTOPILOT VIOLENTLY PITCHES UP AND DOWN DURING CRUISE FLIGHT. AUTOPILOT CONTINUED TO AUTOMATICALLY DISCONNECT. BOTH PILOTS HAD TO OVERRIDE THE AUTOPILOT TO MAINTAIN ALTITUDE AND CONTROL. TRANSFERRED TO DMI NR 00151 MEL 22-1 CATEGORY 'C'. (MSDR 97ZZZM252Mach Trim Act · malfunctionedBUF - ACY - FLT 869 - AUTO-PILOT SEVERE PITCH UP DURING CRUISE. REMOVED AND REPLACED MACH TRIM ACTUATOR. OPS CHECK NORMAL IAW MM 22-20-1. AUTO-PILOT SYSTEM OPS CHECK NORMAL IAW MM 22-10, CLEARS DMI NR 0134, PLACARDS REMOVED. (M)SDR 97ZZZM226Pitch Computer · malfunctionedDTW - FLT 512 - PASSNG 2800 FOR 2900 FEET ON AUTOPILOT A/C PITCHED UP VIOLENTLY THEN KICKED OFF. RE-ENGAGED OK FOR REST OF FLT. TRANSFERRED TO DMI NR 00089 MEL 22-1. PLACARD INSTALLED, CATEGORY C, ON LOG PAGE 026218 1/10/97. 1/19/97, LOG PAGE 026386, REMOVSDR 97ZZZM225Auto Pilot · malfunctionedACY - FLT 256 - DURING CLIMB CONFIGURATION THE AUTO PILOT DIS-ENGAGED EXPERIENCED A VERY BRISK PITCH DOWN CONDITION. MAINTENANCE COULD NOT DUPLICATE MALFUNCTION. RAN FULL SYSTEM SELF TEST, FOR HALF HOUR OPERATIONAL CHECKS GOOD IAW DC-9 MM, CHAPTER 22-10-01. SDR 97ZZZM5Wire · looseFLT 841 - ACY - DURING LANDING ROLL, TAILCONE WARNING LIGHT FLASHED ON AND OFF SEVERAL TIMES. MAINTENANCE FOUND AND SECURED LOOSE WIRE ON TAILCONE MICROSWITCH. OPERATIONAL CHECKED NORMAL IAW DC9 MM 53-5-3. (M)SDR 97ZZZM4Switch · out of adjustDTW - FLT 927 - TAIL CONE WARNING LIGHT FLICKERED ON LANDING ROLL. CHECKED SECURITY OF TAILCONE AND TAILCONE ATTACH HANDLES, ALL CHECKED NORMAL. FOUND TAIL CONE MICROSWITCH TO BE OUT OF ADJUSTMENT, ADJUSTED MICROSWITCH AND ACCOMPLISHED TAIL CONE DROP CHECK, SDR 97ZZZM6Light · damagedDTW - FORWARD WHITE EMERGENCY FLOOR EVACUATION LIGHT CRUSHED. REPLACED BULB AND LENS. OPERATIONAL CHECKED NORMAL IAW MM 33-50-0. (M)SDR GTIA96NK178Water Line · looseCOFFEE MAKER SMOKING AND SPARKS COMING OUT FROM BACK. FOUND DE-ACTIVATED WATER LINE SPARKING AGAINST TERMINAL END. RE-POSITIONED AND SECURED LINE. (M)SDR GTIA96NK203Filters · dirtyON APPROACH, NOSE GEAR DID NOT SHOW DOWN. EXTENDED NOSE GEAR WITH MANUAL EXTENSION LEVER, LANDING UNEVENTFUL. REMOVED AND REPLACED HYD SYSTEM FILTERS, FLUSHED SYSTEM, DID GEAR SWING (SEVERAL TIMES). NO DEFECTS NOTED. (M)SDR GTIA96NK003Bungee Cylinder · failedON GEAR EXTENSION, NOSE GEAR WOULD NOT EXTEND, F-COM PROCEDURE FOLLOWED. REPLACED NOSE LANDING GEAR BUNGEE CYLINDER IAW DC-9MM 32-32-7. ACCOMPLISHED THREE GEAR SWINGS, GEAR OPERATED OK. NO LEAKS. (M)SDR GTIA96NK002Retract Mech · malfunctionedNOSE GEAR WOULD NOT EXTEND FOR LANDING. RECYCLED, LOWERED NOSE GEAR WITH MANUAL EXTENSION NORMAL, OPERATION FROM THE EXT HANDLE WAS SECURED AND DOOR LIGHT WENT OUT. PERFORMED GEAR SWING ON NOSE IAW 32-30. NO DEFECTS NOTED. UNABLE TO DUPLICATE. (M)
Back to N942ML, cancelled Feb 28, 2017