N8938E, cancelled Nov 19, 2013
Service difficulty reports · 36
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 = 'N8938E' AND deregistration_id = 'N8938E-2013-11-19' 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 = 'N8938E' AND deregistration_id = 'N8938E-2013-11-19' 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 NWAA092949947Battery Pack · inoperativeDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY PATHWAY LIGHTING IN ROWS 1417 OF THE CABIN WERE INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACK AND THE LIGHTS RETURNED TO AN OPERATIONAL CONDITION.SDR NWAA092719947Battery Pack · dischargedDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY PATHWAY LIGHTING IN ROWS 14 -17 OF THE CABIN WERE INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACK AND THE LIGHTS RETURNED TO AN OPERATIONAL CONDITION.SDR NWAA2599947Battery Pack · dischargedDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY PATHWAY LIGHTING IN ROWS 14–17 OF THE CABIN WERE INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACK AND THE LIGHTS RETURNED TO AN OPERATIONAL CONDITION.SDR NWAA092529947Battery Pack · inoperativeDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY PATHWAY LIGHTING IN ROWS 14-17 OF THE CABIN WERE INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACK AND THE LIGHTS RETURNED TO AN OPERATIONAL CONDITION.SDR NWAA074299947Skin · damagedDURING GROUND OPERATIONS PASSENGER ENTRY DOOR L1 JAMB INNER SKIN AND INTERCOSTAL AT FORWARD STOP NR 5 DAMAGED. REPAIRED PER EA 99-211510.SDR 0601969947Actuator · burnedWHILE IN CRUISE FLIGHT THE CREW NOTED A BURNING SMELL IN THE COCKPIT AND THEN SAW SMOKE COMING FROM THE THROTTLE QUADRANT. AN EMERGENCY WAS DECLARED AND THE FLIGHT DIVERTED TO A SAFE LANDING AT IND. THE COCKPIT FIRE EXTINGUISHER WAS DISCHARGED DOWN INTO THE THSDR 0501379947Skin · crackedDURING L-CHECK FOUND CRACK IN FUSELAGE SKIN AT FORWARD SERVICE DOOR FRAME LOWER AFT CORNER. REPAIRED PER EA 99-204703.SDR 0500189947Line · leakingDURING FLIGHT, THE AIRCRAFT LOST PRESSURE AND A TOTAL LOSS OF FLUID FROM THE RIGHT HYDRAULIC SYSTEM. COMPLIED WITH COM PROCEDURES AND AIRCRAFT CONTINUED TO ORIGINAL DESTINATION. THE LANDING AT BTR WAS UNEVENTFUL. MAINTENANCE FOUND A LINE COMING FROM THE ELESDR 0203679947Door Frame · crackedWHILE IN FOR A L CHECK. A CRACK WAS FOUND IN THE LOWER FORWARD CORNER OF THE R1 SERVICE DOOR JAMB. REPAIRED PER EA.SDR 0203689947Frame · crackedDURING L CHECK, A CRACK WAS FOUND IN THE UPPER AFT CORNER OF THE R1 SERVICE DOOR JAMB. REPAIRED PER EA.SDR 9902319947Sensor · malfunctionedDURING APPROACH INTO DTW, THE LEFT MAIN LANDING GEAR UNSAFE LIGHT ILLUMINATED AFTER GEAR EXTENSION. CREW EXECUTED GO-AROUND PROCEDURES AND TOWER VERIFIED GEAR TO BE DOWN. EMERGENCY WAS DECLARED AND ALTERNATE GEAR EXTENSION PROCEDURES WERE UTILIZED AS A PRECASDR 9901549947Power Supply · inoperativeDURING LINE MAINTENANCE INSPECTION, FOUND CATWALK EMERGENCY LIGHTS INOPERATIVE. REPLACED POWER SUPPLY. OPERATIONAL CHECK NORMAL.SDR 9807179947Wire · misinstalledDURING LINE CHECK, FOUND CEILING EMERGENCY LIGHT INBOARD OF FORWARD LAVATORY INOPERATIVE. MAINTENANCE CORRECTED LIGHTING WIRING. OPERATIONAL CHECKS NORMAL.SDR 9804589947Spar Web · crackedDURING H CHECK, FOUND A CRACK IN THE UPPER AFT SPAR IN THE CENTER TANK ACROSS THE VERTICAL LEG RADIUS AT WS 58. REPAIRED PER EA 99-153041.SDR 9714719947Unsafe Light · illuminatedAFTER TAKEOFF FROM MSP ON GEAR RETRACTION, THE RIGHT GEAR UNSAFE LIGHT REMAINED ILLUMINATED. FOLLOWED COCKPIT OPERATING MANUAL PROCEDURES AND RETURNED TO MSP. AIRCRAFT LANDED WITHOUT INCIDENT. MAINTENANCE TROUBLESHOOTING REVEALED NO DISCREPANCIES. AIRCRAFTSDR 9712329947Switches · failedALL THREE MAIN LANDING GEAR RED UNSAFE LIGHTS REMAINED ON AFTER GEAR RETRACTION. CREW RECYCLED GEAR WITH SAME RESULTS. FLIGHT RETURNED TO MEM AND LANDED WITHOUT INCIDENT. MAINTENANCE REPLACED THROTTLE LIMIT SWITCHES, OPERATIONAL CHECK NORMAL.SDR 9711529947Battery Pack · dischargedDURING LINE MAINTENANCE INSPECTION, FOUND FORWARD OVERWING EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED BATTERY PACK, OPERATIONAL CHECK NORMAL.SDR 9711479947Power Supply · failedDURING LINE MAINTENANCE INSPECITON, FOUND BOTH FORWARD OVERWING EMERGENCY EXIT LIGHTS INOPERATIVE. REPLACED POWER SUPPLY, OPERATIONAL CHECK NORMAL.SDR 9708399947Battery Pack · dischargedDURING LINE MAINTENANCE INSPECTION, FOUND FORWARD FLIGHT ATTENDANT UPPER FLASHLIGHT INOPERATIVE. REPLACED BATTERY PACK, OPERATIONAL CHECK NORMAL.SDR 9701079947Switches · malfunctionedTAKEOFF WARNING HORN SOUNDED WHEN THROTTLES WERE ADVANCED FOR TAKEOFF. ABORTED TAKEOFF AND RETURNED TO GATE. MAINTENANCE REPLACED THE LEFT AND RIGHT SLAT EXTEND SWITCHES S1-299 AND S1-300, OPERATIONAL CHECK NORMAL.SDR 9624729947Battery · dischargedDURING L-CHECK, FOUND THAT THE LEFT FORWARD OVERWING EVACUATION SLIDE BATTERY FAILED THE CHECK. REPLACED THE SLIDE (P/N 11331-3), (S/N 53).SDR 9623369947Ac Relay · failedAC CROSSTIE LOCKOUT LIGHT ILLUMINATED EN ROUTE. FLIGHT DIVERTED TO DTW AND LANDED WITHOUT INCIDENT. MAINTENANCE REPLACED RIGHT GENERATOR AC POWER RELAY, OPERATIONAL CHECK NORMAL.SDR 9623359947Generation · malfunctionedDURING TAKEOFF ROLL AT 100 KNOTS, THE RIGHT GENERATOR DROPPED OFF LINE ACCOMPANIED BY AC CROSSTIE LOCKOUT LIGHT ILLUMINATION. ABORTED TAKEOFF AND RETURNED TO GATE. MAINTENANCE REPLACED VOLTAGE REGULATOR, GENERATOR CONTROL PANEL, BUS CONTROL PANEL AND CURRENTSDR 9614759947Gasket · blownTAIL COMPARTMENT TEMPERATURE HIGH LIGHT ILLUMINATED AFTER TAKEOFF. FLIGHT RETURNED TO DTW AND LANDED WITHOUT INCIDENT. MAINTENANCE FOUND BLOWN GASKET AT RIGHT AIR CONDITIONING HIGH TEMPERATURE SENSOR. REPLACED GASKET AND LEFT HIGH TEMPERATURE SENSOR AS A PRSDR 9609189947Unsafe Light · illuminatedRIGHT MAIN LANDING GEAR UNSAFE LIGHT REMAINED ON AFTER GEAR WAS RETRACTED. RECYCLED GEAR WITH SAME RESULTS. FLIGHT RETURNED TO MSP AND LANDED WITHOUT INCIDENT. MAINTENANCE CHECKED CONTINUITY OF UPLOCK AND DOWNLOCK SWITCHES. SWITCHES WERE REINSTALLED AND GESDR 9606159947Stall Warn Comp · failedSTALL WARNING INDICATION FAILURE LIGHT ILLUMINATED AFTER TAKEOFF. FLIGHT RETURNED TO DTW AND LANDED WITHOUT INCIDENT. REPLACED NR 2 STALL WARNING COMPUTER AND TONE GENERATOR, OPERATIONAL CHECK NORMAL.SDR 9521229947Wire · brokenDURING APPROACH, THE NOSE LANDING GEAR SAFE LIGHT DID NOT ILLUMINATE AFTER LANDING GEAR EXTENSION. A DOWNLOCK CHECK WAS PERFORMED WHICH VERIFIED THE NOSE LANDING GEAR WAS DOWN AND LOCKED. AIRCRAFT LANDED WITHOUT INCIDENT. REPLACED BROKEN WIRE FROM DOWNLOCK SDR 9519259947Elect Terminal · brokenDURING CLIMB, THE RIGHT GENERATOR TRIPPED OFF LINE. RESET RIGHT GENERATOR AND RIGHT BUSS CAME BACK ON LINE. AIRCRAFT RETURNED TO MSP AND LANDED WITHOUT INCIDENT. REPAIRED BROKEN ELECTRICAL TERMINAL, OPERATIONAL CHECK GOOD.SDR 9510669947Fuel Control · malfunctionedDURING CLIMBOUT, NR 1 ENGINE EPR AND FUEL FLOW INDICATORS WERE FLUCTUATING. FLIGHT RETURNED TO MSP AND LANDED WITHOUT INCIDENT. MAINTENANCE INSPECTED THE ENGINE, DRAINED THE F.C.U. MOISTURE TRAP, AND RAN THE ENGINE. NO ANOMALIES WERE NOTED. AIRCRAFT RETURNSDR 9510209947Switch Wire · brokenDURING APPROACH INTO BWI, NOSE GEAR GREEN LIGHT DID NOT ILLUMINATE ON GEAR EXTENSION. ALSO, RED UNSAFE LIGHT WAS INOPERATIVE. PERFORMED GO-AROUND AND TOWER VISUALLY CONFIRMED THAT GEAR WAS EXTENDED. REQUESTED EMERGENCY EQUIPMENT ON STANDBY. AIRCRAFT LANDEDSDR 9510339947Bulbs · failedDURING APPROACH INTO MSP, NEITHER GEAR UNSAFE LIGHTS OR DOWN AND LOCK GREEN LIGHTS ILLUMINATED ON GEAR EXTENSION. RECYCLED GEAR AND ALL INDICATIONS WERE NORMAL. AIRCRAFT LANDED WITHOUT INCIDENT. RELAMPED ALL GEAR POSITION ANNUNCIATORS. OPERATIONAL CHECK OK,SDR 9507969947Connector · contaminatedLOSS OF CABIN PRESSURIZATION OCCURRED AT 33,000 FEET. CABIN ALTITUDE CLIMBED TO 11,000 FEET. OXYGEN MASKS DID NOT DEPLOY. CABIN PRESSURE WAS REGAINED AT 23,000 FEET AND FLIGHT CONTINUED WITHOUT FURTHER INCIDENT. CLEANED CANNON PLUG ON PRESSURE AMPLIFIER. SDR 9501589947Fitting · corrodedDURING ACCEPTANCE CHECK AND PRIOR TO SERVICE, FOUND CORROSION ON LEFT AND RIGHT MAIN LANDING GEAR ATTACH FITTINGS AT THE FIXED STRUT. REPAIRED BOTH PER EA 99-095679.SDR 9501499947Trap Panel · crackedDURING ACCEPTANCE CHECK AND PRIOR TO SERVICE, FOUND CRACKS IN LEFT AND RIGHT TRAPEZOIDAL PANEL INBOARD FITTINGS AT FASTENER HOLES. REPLACED BOTH PER BULLETIN 53-115, AC54284.SDR 9500459947Fitting · corrodedDURING PERIODIC CHECK, FOUND CORROSION ON 'FISHTAIL' FITTING FS 604 AT LONGERON 28R. REPLACED FITTING PER SRM 51-01 AND DWG 5911418.SDR 9500449947Bracket · corrodedDURING PERIODIC CHECK, FOUND CORROSION IN BOTH LEFT AND RIGHT HORIZONTAL STABILIZER 'A' BRACKETS UPPER FASTENER BORES. OVERSIZED BORES AND INSTALLED BUSHINGS PER EA 99-094108 AND -094107 RESPECTIVELY.
Back to N8938E, cancelled Nov 19, 2013