N77181, cancelled Sep 13, 2018
Service difficulty reports · 87
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 = 'N77181' AND deregistration_id = 'N77181-2018-09-13' 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 = 'N77181' AND deregistration_id = 'N77181-2018-09-13' 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 MASA200500780Light · dischargedASH 2910 AVP - EMERGENCY LIGHTS ARE INOPERATIVE. CONTRACT MX CHARGED THE LIGHTS AND THEY OPS CHECKED.SDR MASA200500716Fuel Control · malfunctionedASH 2763 GRR. ABORTED TAKEOFF DUE TO THE NR 1 ENG NOT MAKING TAKEOFF POWER. CONTRACT MAINTENANCE PERFORMED A PERFORMANCE RUN OF THE ENGINE AND COULD NOT FIND A FAULT. FERRIED THE PLANE TO PHL WHERE MX REMOVED AND REPLACED NR 1 FUEL CONTROL.SDR MASA200500689Engine · malfunctionedASH 2828 CLE. ABORTED TAKEOFF DUE TO THE NR 1 ENG WOULD NOT ACCELERATE PAST 70 PERCENT N1. CONTRACT MAINTENANCE PERFORMED A VISUAL INSPECTION OF THE FAN AND ENGINE AREAS AND FOUND NO DEFECTS. PERFORMED ENGINE RUNS AND THE DISCREPANCY COULD NOT BE DUPLICATEDSDR MASA200500294Lamp · inoperativePILOT REPORTED AN OVERWING EMERGENCY EXIT EXTERIOR LIGHT INOP. THE CREW MEL'ED THE LIGHT AND MAINTENANCE RELAMPED IT ON THE NEXT LEG.SDR MASA200500127Priority Valve · failedASH 9430 YUL - PHL, CAPT RETURNED TO THE FIELD DUE TO NOSE GEAR WOULD NOT RETRACT. MAINTENANCE IS TROUBLESHOOTING. MAINTENANCE REMOVED AND REPLACED PRIORITY VALVE AND SERVICED THE STRUT.SDR MASA200500126Proximity Sensor · icedASH 2839 YUL RETURNED TO THE FIELD IN YUL FOR A NOSE GEAR THAT WOULD NOT RETRACT. MAINTENANCE FOUND THE NOSE GEAR COVERED WITH ICE. MAINTENANCE IS NOW IN THE PROCESS OF REMOVING THE ICE AND PERFORMING A GEAR SWING. 2/17/05 MAINTENANCE ADJUSTED THE PROX SENSSDR MASA200500077Light · malfunctionedEMERGENCY LIGHTS IN CABIN ILLUMINATE WITH THE FLIGHT DECK SWITCH IN THE ARMED POSITION. MAINTENANCE RESET THE CIRCUIT BREAKER, OPERATIONAL CHECK GOOD.SDR MASA200400635Windshield · crackedASH 2912 PHL -PHL - AIRCRAFT RETURNED TO FIELD DUE TO A CRACKED PILOTS WINDSHIELD ON CLIMB-OUT. MAINTENANCE CHANGED THE PILOTS WINDSHIELD.SDR MASA200400539Door · out of adjustUPON ARRIVAL IN CLT FLIGHT CREW COULD NOT OPEN PASSENGER DOOR. MAINTENANCE ADJUSTED PASSENGER DOOR AND PERFORMED OPERATIONAL TEST. NO FURTHER DEFECTS WERE NOTED AT THAT TIME.SDR MASA200400410Warning System · activatedCREW REPORTED THE AILERON TRIM AND TAKEOFF CONFIG MESSAGE. MX RESET THE SYSTEM AND OPS CHECK GOOD.SDR MASA200400327Door · stiffASH 2835 CLT. PAX DOOR HARD TO OPEN. MAINTENANCE INSPECTED DOOR AND NO DEFECTS NOTED. OPS CHECKED GOOD, NO PARTS USED.SDR MASA200300466Warning Light · illuminatedON TAKEOFF ROLL A/C CAME OUT OF TAKEOFF CONFIG, ABORTED T/O. MX RESET SYSTEM, OPS CHECKED OK.SDR 2003F00184Light · inoperativeEMERGENCY ESCAPE PATH LIGHT INOPERATIVE FROM ROW 2 TO ROW 5. MAINTENANCE PERFOREMD OPS CHECK IAW MM 33-51-04 AND LIGHTS FUNCTION NORMALLY. (M)SDR MASA200200019Bulb · burned outAT ACCEPTANCE INSPECTION, THE CREW FOUND THE AFT CEILING EMERGENCY EXIT LIGHT INOPERATIVE. ITEM WAS PLACED ON MEL AND CONTINUED OPS. PHX MX REPLACED THE BULB. OPS NORMAL.SDR 2003F00082Bpsu · failedFLT 6416 - EUG-PHX - PILOT DECLARED AN EMERGENCY DUE TO FLAPS FAILING AT ZERO. THE AIRCRAFT RETURNED TO THE GATE WHERE MAINTENANCE REMOVED AND REPLACED THE BPSU AND THE RIGHT NR 5 FLEXSHAFT. OPS CHECKED GOOD AND THE AIRCRAFT RETURNED TO SERVICE. (M)SDR MAS2002F00007Bpsu · failedFLAPS FAIL CAUTION MESSAGE ON CLIMB OUT. AFTER AN UN-EVENTFUL LANDING. MECHANIC COMPLIED WITH. PART A AND B REPLACED THE BPSU AND THE NR 5 FLEX DRIVE. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR 2002F00221Light · inoperativeDURING OVERNIGHT MAINTENANCE, IT WAS DISCOVERED THAT THE NR 3 EMERGENCY CEILING LIGHT WAS INOPERATIVE. REPLACED BULB. OP CHECKS GOOD. THE AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR MASA00156Bulb · burned outFLT 5053 - CMH-LGA - DURING PRE-FLIGHT WALK AROUND IT WAS DISCOVERED THAT THE CABIN NR 2 EMERGENCY EXIT CEILING LIGHT WAS INOPERATIVE. MAINTENANCE REPLACED THE BULB. OPS CHECKS GOOD. THE AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR MASA00085Lens · missingFLT 6070 - PHX-EUG - DURING PREFLIGHT, PILOT REPORTED THAT THE EMERGENCY EXIT LIGHT LENS WAS MISSING. MAINTENANCE REPLACED THE LENS. OPS CHECKED GOOD. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR MASA00068Bulb · burned outFLT 6082 - SBA-PHX - CREW OBSERVED CEILING EMERGENCY LIGHT ROW 11 INOPERATIVE. ASSIGNED MEL 33-51-1. AIRCRAFT ARRIVED IN PHX. MAINTENANCE REPLACED LIGHT, OPS CHECKS GOOD. MEL WAS CLEARED. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR MASA00036Door · openFLT 6110 - PHX-PSP - AFTER TAKEOFF, THE CREW NOTED THE GROUND O2 SERVICING DOOR CAME OPEN INFLIGHT. THE AIRCRAFT RETURNED TO THE FIELD WHERE MAINTENANCE INSPECTED AND RESECURED THE O2 SERVICING DOOR. OPS CHECKED GOOD AND THE AIRCRAFT WAS RETURNED TO SERVICE.SDR MASA00033Light · inoperativeFLT 6021 - PHX-FAT - DURING PREFLIGHT CHECK, THE CREW NOTED THE RIGHT OVERWING EXIT LIGHT WAS INOPERATIVE. MAINTENANCE WAS CALLED OUT AND REMOVED AND REPLACED THE RIGHT OVERWING EMERGENCY EXIT LIGHT. OPS CHECKED GOOD AND THE AIRCRAFT WAS RETURNED TO SERVICE.SDR MASA00029Battery Pack · inoperativeFLT 6001 - PHX-DSM - DURING STANDARD PREFLIGHT CHECK, THE CREW NOTED THE EMERGENCY EXIT ESCAPE PATH LIGHTS BY THE OVERWING EXIT WERE INOPERATIVE. MAINTENANCE INSPECTED AND RESECURED THE PIN AT THE NR 3 BATTERY PACK. OPS CHECKED GOOD AND THE AIRCRAFT WAS RETUSDR MASA00025Battery · dischargedFLT 6003 - FAT-PHX - DURING STANDARD PREFLIGHT CHECK, THE CREW NOTED THE CENTER FLOOR RIGHT SIDE EMERGENCY LIGHTING WAS INOPERATIVE. MAINTENANCE INSPECTED AND REMOVED AND REPLACED THE BATTERY THAT IS SECURED TO THE TOP PLATE ASSY. OPS CHECKED GOOD AND THE AISDR MASA99138Prox Sensor · out of adjustFLT 6138 - PHX-MRY - AFTER DEPARTURE FROM PHX, THE CREW REPORTED THAT THE NOSE GAER WOULD NOT RETRACT. THE AIRCRAFT RETURNED TO THE FIELD. MAINTENANCE FOUND THAT THE NOSE PROXIMITY SENSOR HAD BEEN HIT BY A PUSH CART. MAINTENANCE READJUSTED THE PROXIMITY SENSDR MASA99131Prox Sensor · out of adjustFLT 6162 - MAS-PHX - AFTER DEPARTURE FROM MAS, THE AIRCRAFT RETURNED TO THE FIELD DUE TO THE NOSE LANDING GEAR WOULD NOT RETRACT. MAINTENANCE FOUND PROXIMITY SENSOR HAD BEEN BENT BY THE PUSH BACK CART. MAINTENANCE REPAIRED THE PROXIMITY SENSOR. OPS CHECKED SDR MASA99085Bulb · failedFLT 6082 - MAF-PHX - PRIOR TO DEPARTURE, THE CREW REPOTED AN EMERGENCY LIGHT IN THE CEILING AT ROW 11 WAS NOT ILLUMINATING. MAINTENANCE DEFERRED THE CEILING EMERGENCY LIGHT PER MEL 33-51-1. AIRCRAFT WAS RETURNED TO SERVICE. IN SUBSEQUENT MAINTENANCE THE BULSDR MASA99082Latch · out of adjustFLT 6021 - PHX-FAT - THE CREW REPORTED THE PASSENGER DOOR HARD TO OPEN. MAINTENANCE INSPECTED, CLEANED, LUBED AND ADJUSTED THE LOCK LATCHES. OPS CHECK GOOD. THE AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR MASA99079Mechanism · lack of lubeFLT 6130 - PHX-MRY - CREW REPORTED THE PASSENGER DOOR HARD TO OPEN. MAINTENANCE LUBED THE DOOR, OPS CHECK GOOD. THE AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR MASA99049Actuator · failedFLT 6001 - FAT-PHX - PRIOR TO DEPARTURE, MAINTENANCE NOTICED THAT THE DOOR WOULD NOT CLOSE WITH THE POWER ASSIST. MAINTENANCE REPLACED THE DOOR ASSIST ACTUATORS. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR 99ZZZM363Actuator · failedFLT 6001 - FAT-PHX - PRIOR TO DEPARTURE, MAINTENANCE NOTICED THAT THE DOOR WOULD NOT CLOSE WITH THE POWER ASSIST. MAINTENANCE REPLACED THE DOOR ASSIST ACTUATORS. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR MASA99024Bulb · failedFLT 6020 - PHX-MRY - PRIOR TO DEPARTURE, CREW REPORTED THAT TWO OF THE FOUR CEILING EMERGENCY LIGHTS WERE INOP. MAINTENANCE REPLACED TWO BULBS, OPS CHECKED GOOD. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR 99ZZZX1498Brake · leakingFOUND HYDRAULIC FLUID LEAKING FROM NR 1 BRAKE. TEAR-DOWN DATA HAS IDENTIFIED A PROBLEM WITH THE PISTON LEAKING AROUND THE PIN, AND THE T-SEALS HAVING TO BE REPLACED. AIRCRAFT BRAKING SYSTEMS HAS IDENTIFIED A PROBLEM WITH THE BRAKE PIN NOT BEING FINISHED PROPSDR 99ZZZX1511Brake · leakingFOUND HYDRAULIC FLUID LEAKING FROM NR 3 BRAKE. TEAR-DOWN DATA HAS IDENTIFIED A PROBLEM WITH THE PISTON LEAKING AROUND THE PIN, AND THE T-SEALS HAVING TO BE REPLACED. AIRCRAFT BRAKING SYSTEMS HAS IDENTIFIED A PROBLEM WITH THE BRAKE PIN NOT BEING FINISHED PROPSDR 99ZZZX1513Brake · leakingFOUND HYDRAULIC FLUID LEAKING FROM NR 4 BRAKE. TEAR-DOWN DATA HAS IDENTIFIED A PROBLEM WITH THE PISTON LEAKING AROUND THE PIN, AND THE T-SEALS HAVING TO BE REPLACED. AIRCRAFT BRAKING SYSTEMS HAS IDENTIFIED A PROBLEM WITH THE BRAKE PIN NOT BEING FINISHED PROPSDR MASA98165Bulb · failedWHILE PERFORMING ROUTINE MAINTENANCE, FOUND THE AFT CABIN OVERHEAD EMERGENCY LIGHT INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE BULB, OPS CHECKED GOOD. (X)SDR MASA97177Rod Assy · out of adjustFAT/PHX - FLT 5228 - WHEN ATTEMPTING TO DEPLANE PASSENGERS IN PHX, CREW FOUND THE MAIN CABIN DOOR WOULD NTO OPEN. WHEN MAINTENANCE ASSISTED IN OPENING THE DOOR, THEY FOUND THE LOWER AFT LOCKING PIN WOULD NOT RETRACT ALL THE WAY. MAINTENANCE ADJUSTED THE LOCK
Back to N77181, cancelled Sep 13, 2018