N131DN, cancelled Jul 21, 2017
Service difficulty reports · 21
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 = 'N131DN' AND deregistration_id = 'N131DN-2017-07-21' 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 = 'N131DN' AND deregistration_id = 'N131DN-2017-07-21' 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 DL76S081236Engine · making metalNR 2 ENGINE OIL PRESSURE WENT TO ZERO, HEARD AUDIBLE STALL. CREW SHUT OFF FUEL LEVER. MTC FOUND METAL IN THE TAIL PIPE. NR 2 ENG REPLACED PER TRANS 1T145.SDR DL76S080845Engine · failedDURING CRUISE FLT FELT VIBS AND HEARD UNUSUAL NOISE VIBS AT5.0. WHILE PERFORMING WALKAROUND CHECK FOUND METAL IN TAILPIPE OF THE NR 2 ENG. ENG CHG IN PROGRESS.SDR DL76S080131Washer · missingFOUND RT NLG WHEEL AXLE ASSY MISSING AXLE WASHER. REMOVED RT NLG WHEEL ASSY VISUALLY INSP AXLE AND WHEEL ASSY BEARING. NO DAMAGE NOTED. REINSTALLED WHEEL ASSY AND AXLE WASHER PER AMM.SDR DL76S071402Pump · failedLEFT AFT FUEL PUMP FAILED, LIGHT AND EICAS, THEN 20 MINUTES LATER THE LT FWD FUEL PUMP FAILED. GOT BOTH PUMP LOW PRESS LIGHT AND L FUEL SYSTEM PRESS EICAS. REPLACED BOTH FUEL BOOST PUMPS (BORROWED FROM AA IN LAX).SDR DL76S070732Unknown · odorBURNING L ELECT SMELL IN AFT PART OF CABIN. SMELL WENT AWAY WHEN CEILING LIGHTS TURNED OFF. TURNED ON ALL ELECT UNITS AND LIGHT THROUGHOUT AIRCRAFT. NO BURNING SMELL DETECTED.SDR DL76S060456Pump · leakingLOST 'C' SYS HYD QTY INFLT. REPLACING ADP. FOUND CENTER SYS ADP DAMAGED AND LEAKING HYD FLUID. REMOVED CENTER SYS ADP PER M/M . INSTALLED NEW CENTER SYS ADP PER M LEAK CK OK . NEEDS OK OUT, RESET ALL EXT SWITCH AND SAFETIED.SDR DL76S040867Coffeemaker · contaminatedDIVERTED TO KJFK WITH REPORTED FUMES IN AFT GALLEY. UNKNOWN SOURCE, BUT REPORTED AS BURNING PLASTIC ODOR, WHICH DID NOT GO AWAY EVEN AFTER TURNING OFF UTILITY BUSSES AND RECIRC FANS. ATL/TMC NOTIFIED AT 1055Z. AFTER OPERATING NR 4L COFFEEMAKER FOUND DEBRIS SDR DL76S040392Fitting · crackedINSPECTION OF THE HORIZONTAL STABILIZER PIVOT FITTING ATTACH FASTENER HOLE BORES REVEALED A CRACK INDICATION IN A SINGLE FASTENER HOLE COMMON TO THE FITTING SPLICE PLATES ON THE LT & RT SIDES. THE HOLES WERE OVERSIZED TO REMOVE THE CRACKS AND PROVIDE AND INSSDR DL76S021382Mount · bentON L/O FOUND RT LOCK SPRING MISSING ON NOSE LANDING GEAR. FWD SPRING MOUNT IS BROKEN. AFT SPRING MOUNT IS BENT. REPLACED FWD AND MOUNT AND SPRING PER M/M 32-21-09. DAMAGED ALSO TO AFT BULKHEAD OF NOSE WHEEL WELL REF ITEM 003SDR DL76S011153Engine · malfunctionedRT ENG EGT EXCEEDED 979 DURING T/O. N2 VIBS 5.0 AND RT HP BLEED LIGHT ON. AIRCRAFT RETURNED TO ATL AND ON APPROACH INTO ATL RT ENG WAS SHUTDOWN BY CREW DUE EGT CONTINUING TO RISE. REMOVED AND REPLACED NR 2 ENG.SDR DL76S011074Harness · burnedWORKING MCO APU ELEC INOP. FOUND GENERATOR FEEDER CABLE BURNT. CABLE SENT TO SHOP WITH OLD GENERATOR. REPLACED CABLE.SDR DL76S991787Light · inopDURING MTC, L/O FOUND SEVERAL EMERGENCY LIGHTS IN OVERHEAD BURNED OUT.SDR DL76S990847Power Supply · inopLT OVERWING EMERGENCY LIGHTS DO NOT ILLUMINATE. REPLACED POWER SUPPLY SLED M736. OPS CHKS NML.SDR DL76S980907Floorbeam · crackedSTA 610 FLOORBEAM WAS FOUND WITH DAMAGE TO THE LWR CHORD AND WEB BETWEEN APPROX LBL14 AND RBL 13. THE DAMAGE APPEARS TO HAVE BEEN CAUSED BY GROUND DAMAGE. REPAIRED PER ERA 331621-14.SDR DL76S972720Skin · puncturedTHE FUSELAGE SKIN WAS PUNCTURED AND TRIMMED AWAY OVER AN 8 BY 8 AREA BETWEEN FS 303 AND 311 AND BETWEEN STRINGERS 26L AND 29L. STRINGERS 27L AND 28L WERE SEVERED AND REPAIRED PER SRM. THE SKIN WAS REPAIRED WITH AN EXTERNAL ALUMINUM DOUBLER PER ER/A 363527-14SDR DL76S971834Engine · failedPASSING FL 23500 ABOUT 10 SEC AFTER SELECTING CLB PWR, LEFT ENG COMPRESSOR STALL (5 BANGS). PULLED TO IDLE MAX TEMP 928 FOR 4 SEC, INDICATED AIRSPD 310 KTS. BEGAN DESCENT, LEFT ENG COMPRESSOR STALLED AGAIN 3 TIMES AS PWR WAS REDUCED. SHUTDOWN ENG PASSING 8SDR DL76S970050Outflow Valve · malfunctionedUNABLE TO PRESSURIZE A/C AFTER TAKEOFF. A/C RETURNED LAX. REPLACED OUTFLOW VALVE, OPS CHECK NORMAL.SDR DL76S962165Light · dirtyINFLIGHT F/A REPORTED ELECT ODOR IN THE MID AND AFT GALLEY AREAS. TURNED OFF COFFEE MAKERS, GALLEY OVENS AND WORK LIGHTS ODOR WENT AWAY. FOUND GALLEY LIGHT FIXTURE WITH COOKED COFFEE RESIDUE.SDR DL76S954557Battery · dischargedEMERGENCY EXIT LIGHT OVER FLIGHT DECK DOOR CAME ON EN ROUTE DFW AND DEPLETED BATTERY. REPLACED EMERGENCY LIGHT ASSY AND NEW BATTERYS OPN NML.SDR DL76S953786Cowl · wornTHE AFT FRAME AT THE LOWER END OF THE RT CORE COWL WAS WORN. THE DAMAGE WAS REPAIRED PER SRM 54-41-02.SDR DL76S953386Galley · odorDURING CRUISE, FLIGHT ATTENDANT REPORTED INTERMITTENT BURNING ODOR JUST FWD OF MID GALLEY ON RT SIDE. ODOR AND FREQUENCY WORSENED, DEACTIVATED POWER IN MID GALLEY, SMELL DISSIPATED. CEILING PANELS WERE LOWERED, AREA INSPECTED AND GALLEY EQUIPMENT TURNED ON.
Back to N131DN, cancelled Jul 21, 2017