N173DN, cancelled Sep 6, 2017
Service difficulty reports · 49
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 = 'N173DN' AND deregistration_id = 'N173DN-2017-09-06' 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 = 'N173DN' AND deregistration_id = 'N173DN-2017-09-06' 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 DL76L081773Actuator · frozenRIGHT PACK WAS PUTTING OUT EXCESSIVE TEMP AIR MAIN CABIN WAS 87. ONLY WAY TO CONTROL CABIN TEMP WAS TO SHUT OFF RIGHT PACK. TEMP RETURNED TO NORMAL WITH PACK OFF. T/S IAW FIM BITE PERFORMED ON PACK TEMP CONTROL BOX ALL OK. INSP RT PACK FOUND RT RAM AIR EXTSDR DL76L081768Engine · malfunctionedNR 2 ENG CHANGE DUE TO STAGGER. INSTALLED S/N 724715.SDR DL76L081767Engine · malfunctionedNR 1 ENG CHANGE FOR STAGGER, INSTALLED S/N 727678.SDR DL76L081710Computer · malfunctionedAFTER PUSHBACK GOT STATUS MSG ELEV FEEL, IT CLEARED AFTER STARTING BOTH ENGINES READ NEEDED HYD PRESSURE IN MDM. AFTER A COUPLE OF MINUTES IT RETURNED AND WOULD NOT CLEAR. MSG FIRST APPEARED AFTER STARTING FIRST ENGINE. REMOVED AND INSTALLED ELEV FEEL COMPUSDR DL76L080730Wire · chafedWHEN THROTTLES ADVANCED FOR TAKEOFF RT ENG OIL PSI LIGHT ILLUMINATED AND RT ENG OIL PSI EICAS MSG ANNUNCIATED, LIGHT EXT WITH THROTTLES AT IDLE, RE-ILLUMINATED EACH TIME THROTTLE IS ADVANCE OIL PSI INDICATES NORMAL. INSP MAIN ENG OIL FILTER CHIP DETECTORS NO SDR DL76L071168Wire Harness · damagedDURING DRC CHECK, FOUND APU EGT HARNESS BURNED WIRE INSULATION DAMAGED EXHAUST LEAK. REMOVED AND REPLACED APU PER OPN 6051 AND OPN 7951.SDR DL76L070384Angle · crackedTHE NR 2 PYLON CLOSEOUT ANGLE WAS FOUND WITH A CRACK IN THE OUTBOARD SIDE. THE MIDSPAR FITTINGS ALSO HAD TOOLING DAMAGE. THE DAMAGED ANGLE WAS REPAIRED WITH REPAIR STRAPS.SDR DALA1108510173Fitting · damagedFLAP COLLAR FITTING REPLACED IAW EA 01-073591-12, ME12, ME13, ME20, ME21.SDR DL76L070321Relay · unknownLT ENG EEC MODE STATUS. REPLACED K402 RELAY FOR THE LT ENG PROBE HEAT. RAN ENG, OP CKS GOOD.SDR DL76L070047Wire · chafedDURING BRAKE RELEASE WHILE PUSHING THROTTLES FORWARD AT APPROX 1.3 EPR, THE RIGHT ENG OIL PRESSURE LIGHT ILLUMINATED AND PRESSURE GAUGE READ AT APPROX 213PSI. IMMEDIATE ABORT PERFORMED. AT IDLE RIGHT ENG OIL PRESS IS NORMAL APPROX 106 PSI. R ENG OIL PRESS ESDR DL76L060670Display · inoperativeF/O MCDU FROZE. UNABLE TO HAVE A SUCCESSFUL RESET. DIVERTED TO JFK WHERE PARTS ARE AVAIL. REMOVED AND REPLACED F/O MCDU, OPS NORMAL.SDR DL76L060578Fmu · malfunctionedDURING ENG START ACHIEVED STARTER CUTOUT THEN N2 ROLLED BACK REPLACED FMU AND PUMP. C/W LEAK CK. BORO INSP NR 2 ENG, OPS CK ENG START AND OPS PER MM. OK FOR SERVICE.SDR DL76L060370Lamp · inoperativeFOUND LT SIDE EMERGENCY OVERWING LIGHT INOP. RELAMPED CKS OK.SDR DL76L060273Engine · shutdownAT GATE WITH LT ENG RUNNING LT BLEED ON AND 1 PACK RUNNING ENG BEGAN TO VIB THEN SHUTDOWN. BOOST PUMPS WERE TURNED OFF JUST PRIOR TO SHUTDOWN. PERFORMED BITE OF LT ENG PIMU. FAULTED 354-26 EEC CH A/B 28V PERF SOL PWR MSG CLEARED. INSPECTED INLET AND TAILPISDR DL76L050747Angle · crackedNR 1 ENGINE PYLON MID SPAR CLOSE OUT ANGLE WAS FOUND CRACKED. REPLACED CRACKED MID SPAR CLOSE OUT ANGLE AND INSPECTED MID SPAR FITTINGS, REF AD 2005-19-23.SDR DL76L050454Battery · inoperativeIR - ON L/O, FOUND EMERGENCY EXIT SIGNS AT DOOR 1L AND 1R. REMOVED AND REPLACED BATTERY PACK FOR DOOR 1L AND 1R EXIT SIGNS, NOW OPS NORMAL.SDR DL76L050448Oven · smokeBOTH AFT GALLEY OVENS PRODUCED SMOKE. C/BS PULLED. CKD OVENS FOUND BUN BEHIND THE TRAY. OPERATED FOR 30 MINS. OPS NORM, OVEN CLEANED.SDR DL76L050127Engine · surgesDURING T/O FROM ATL, NR 2 ENGINE SURGED APPROX 5 TIMES. AIRCRAFT RETURNED TO ATL. REPLACED ENGINE.SDR DL76L050063Logic Card · failedFWD CARGO FIRE WARNING LIGHT AND FIRE BELL ACTIVATED IN FLT. REPLACED M10427 CARD.SDR DL76L040151Latch · corrodedDURING OFFWING SLIDE COMPARTMENT DOOR LATCH INSPECTION OPN 5894AD, MISC HARDWARE FOUND TO BE CORRODED. REPLACED DELTA PART NUMBERS: 251211768, 011216100, 251210507, 251210349, 011214656, MFG 416T2824-3, 416T2075-1, 416T2836-9, NAS43HT4-10, BACT32G64-1072, 251SDR DL76L030108Engine · damagedNBR 1 ENGINE STRUCK BY DEICING BUCKET CREATING 1 FT HOLE IN NOSE COWL. REPLACED NBR 1 ENG INLET COWL PER M/M 71-11-01-4 SDR DL76L021321Probe · failedDIVERTED TO AMS FOR TAT PROBE REPLACEMENT DUE TO TAT PROBE MESSAGE AND AUTOTHROTTLES DISCONNECTED. THE REASON THE CREW GAVE WAS POSSIBLE ICING CONDITIONS IN FRA. REMOVED AND REPLACED TAT PROBE IAW MM 34-12-02-4, TESTED IAW 30-33, OK.SDR DL76L020306Blade · damagedJFK MTC FOUND SURGE MESSAGE ON EICAS. MTC THEN BORESCOPED ENGINE FOUND COMPRESSOR BLADE DAMAGE. REPLACED RT ENGINE PER TRANSMITTAL 1T149.SDR DL76L011753Shutoff Valve · malfunctionedLEFT DUCT PRESS FLUCTUATED PLUS/MINUS 15 PSI DURING CLIMBOUT. RETURNED TO JFK. REPLACED PRV CONTROLLER AND PRSOV VLV PER M/M. T/O PWR RUN PER PFHB, ALL NORMAL.SDR DL76L010889Charger · failedCREW REPORTED BATTERY CHARGER MSG WITH VOLTAGE AT 24 VOLTS. REPLACED BATTERY CHARGER.SDR DL76L992106Wire · chafedINSP WIRING FOR LEFT ENG EEC, FOUND DAMAGE TO LEFT ENG CONTROL WIRE. MADE APPROVED REPAIR PER BOEING WIRING STD PRACTICE MNL, FW TO MCO.SDR DL76L991247Actuator · damagedEICAS C HYD QTY MSG AND CENTER HYD QTY .45. TURNED CENTER ELEC PUMPS OFF, LEAK CONTINUED. TURNED CENTER DEMAND PUMP OFF. FLUID SLOWLY DECREASED .01 PER 20 MINS. FOUND HYD LEAK FROM LEFT ELEVATOR CENTER PCA. TEFLON SEAL CRACKED FROM ROD. REPLACED PCA PER SDR DL76L991241Actuator · leakingCENTER SYS HYD QUANTITY DROPPED INFLT TO .38. SHUTOFF PUMPS AND QTY STABILIZED. FOUND RT ELEV PCA LEAKING. REPLACED SAME.SDR DL76L991229Actuator · leakingRT HYD QTY DROPPED TO BELOW .5, RT HYD SYSTEM RSVR LIGHT AND RT HYD QTY MESSAGE. SECURED PRI PUMP AND DEMAND PUMP PER POM AND QTY STABLIZED AT .3. DIVERTED TO JFK. LEAK CHECKED RUDDER AREA AND LANDING GEAR WITH SIMULATED RETRACTION, NO LEAKS FOUND. FOUND RSDR DL76L991165Hyd Syst · required serviceRIGHT HYD SYS RSVR LIGHT AND RIGHT HYD QUANT EICAS MESSAGE. SECURED RT PRIM PUMP AND DEMAND PUMP AS PER ABN PROC QTY CONT TO DROP. LEFT BOTH PUMPS OFF QTY STAB AT .43. SERVICED RT HYD SYSTEM TO FULL. PRESSURIZED SYSTEM FOR APPROX 2 HRS, VISUALLY INSPECTED SDR DL76L991142Battery Pack · dischargedEMERGENCY PATH LIGHTS LT SIDE BUSINESS CLASS FROM ROW 6 TO FIRST ROW T/C INOP. REPLACED BATTERY PACK AT 6 A/B, CKS OK.SDR DL76L990598Pump · failedRIGHT SYSTEM HYDRAULIC QTY STARTED TO DROP SLOWLY. TURNED ENGINE DRIVEN PUMP OFF AND QTY STILL DROPPED SLOWLY. QTY STOPPED DROPPING AT 0.12. FOUND ENG DRIVEN HYD PUMP LEAKING AT CASE SPLIT LINE. REPLACED PUMP ASSY. ALSO, REPLACED PRESSURE FILTER AND CASE SDR DL76L990069Spar Web · crackedPYLON NR 1 ENGINE STRUT AFT UPPER SPAR WEB, STA 222, LBL 4 CRACK REPAIR. THE AFT UPPER SPAR WEB OF THE NR 1 ENGINE PYLON STRUT WAS FOUND WITH .5 CRACK IN THE AFT, OUTBD CORNER OF THE ECS DUCT CUTOUT AT STA 222 AND LBL 4. THE CRACK WAS ROUTED OUT WITH A SMOOTSDR DL76L981856Bulb · failedON LAYOVER, FOUND LEFT OVERWING EMERGENCY EXIT LIGHT INOP. REPLACED BULB.SDR DL76L981050Battery Charger · failedDURING L/O, FOUND EMERGENCY AISLE EXIT SIGN INOP RT OVERWING AND AISLE ILLUMINATION LIGHT INOP. REMOVED AND BATTERY CHARGER ASSY, M732. EMERGENCY LIGHTS OP CK GOOD. ETOPS CATEGORY 'E': PROBLEMS WITH SYSTEMS CRITICAL TO ETOPS.SDR DL76L980893Wedge · delaminatedWING, NR1 LEADING EDGE SLAT, TRAILING EDGE WEDGE. DELAMINATION REPAIR A 1.5 BY 1.2 AREA OF DELAMINATION WAS FOUND ON THE UPPER SURFACE OF THE TRAILING EDGE WEDGE ON THE NR 1 SLAT. THE DELAMINATION WAS REPAIRED PER THE B676 SRM 57-43-02 AND DOCUMENTED PERSDR DL76L980671Seat Elect Box · failedPROBLEM OCCURED 7 HRS INTO FLT, A SMOKE ODOR WAS OBSERVED COMING FROM THE CAPTS SIDE OF THE ACFT NEAR ROW 24. C/B' S WERE NORMAL. THE F/A WERE DIRECTED TO SHUT OFF POWER TO THE MID GALLEY AND PAX ENTERTAINMENT SYSTEM. THE ODOR DISSIPATED SHORTLY THEREAFTER.SDR DL76L980371Pump · leakingLT HYD SYS QTY DECREASED TO .81, SECURED LT ENG HYD PUMPS. DIVERTED TO LGW. FOUND LEFT ENGINE DRIVEN PUMP LEAKING, REPLACED SAME. OPS CHECK NORMAL.SDR DL76L970578Door Seal · out of positionSHORTLY AFTER LEVEL OFF AT FL330, THE CABIN ALTITUDE WARNING CAME ON. CABIN ALTITUDE WAS AT 10,000 FT AND STILL CLIMBING. WENT TO MANUAL FULLY CLOSED AND DESCENDED TO 10,000 FT TO MAINTAIN A CABIN ALTITUDE OF 5700 FT. UNABLE TO FURTHER DESCEND CABIN. FLT ASDR DL76L970217Slide · failedRIGHT OVERWING ESCAPE SLIDE SQUIB WOULD NOT TEST ON LAYOVER CHECK.SDR DL76L962534Power Supply · inoperativeON L/O, FOUND EMERGENCY PATH LIGHTS BETWEEN ROWS 23 AND 28 BOTH AISLE INOP. REPLACED PWR SUPPLY AT ROW 28A, OPS CK OK.SDR DL76L961673Cdu · failedLEFT CDU FAILED 1 HR AFTER T/O. PULLED C/B AND LEFT OUT FOR 20 MINS, RESET AND CDU DID NOT WORK. RETURNED TO JFK. REPLACED LEFT CDU, OPS CHECK GOOD.SDR DL76L961302Fmc · failedRT FMC LOCKED UP THEN LEFT FMC LOCKED. AFTER A PERIOD OF TIME, BOTH RESUMED NORMAL OPERATION FOR APPROXIMATELY 2 MINUTES, THEN RT FMC FAILED. THEN LEFT FMC FAILED. RE-PROGRAMMED ALL DATA IN FMC. AFTER APPROXIMATELY 2 MINUTES, BOTH FMC'S FAILED AGAIN. ON ASDR DL76L960505Skin · crackedTWO ADDITIONAL CRACKS WERE FOUND AT HMV, 2/96. ONE CRACK IS IN THE NR 2 PYLON, RT SKIN AND DOUBLER, AND IS 1.38 INCHES LONG, RUNNING DIAGONALLY UP AND AFT FROM THE UPPER AFT CORNER OF THE FWD TORQUE BOX ACCESS OPENING AT NAC STA 170. THE SECOND CRACK IS IN TSDR DL76L960239Skin · crackedAT LETTER CHECK IN DFW, A .5 INCH CRACK WAS FOUND IN THE NR 2 ENGINE PYLON OUTBOARD STRUT SKIN. THE CRACK EMANATES FROM THE FORWARD TORQUE BOX ACCESS HOLE AT THE UPPER FORWARD CORNER AT APPROXIMATELY NAC STA 158 AND EXTENDS DIAGONALLY UPWARD AND FWD TO A FASTSDR DL76L960186Slide Relay · defectiveON ALL CABIN SERVICE AND ENTRY DOORS, THE SLIDE ARMED LIGHT WILL NOT FLASH IN ARMED MODE WITH THE HANDLE SLIGHTLY PULLED. REPLACED DEFECTIVE RELAY, OPERATION NORMAL.SDR DL76L953235Sensor · failedAFTER DEPARTING JFK HAD LAV SENSOR FOUL LIGHT WITH F/C RT AFT AND FWD MID LAVATORIES INOP, RETURNED JFK. REPLACED CONTROL MODULE AND SENSORS, OPERATION NORMAL.SDR DL76L952950Hpt Blade · missingDURING BORESCOPE INSPECTION, FOUND AN HPT BLADE MISSING. ENGINE WAS REMOVED AND ROUTED TO SHOP.SDR DL76L950627Engine · high oil consumpAFTER REVIEWING OIL CONSUMPTION HISTORY, IT WAS DETERMINED CONSUMPTION RATE WAS BEYOND LIMITS, ENGINE WAS REMOVED AND ROUTED TO SHOP.
Back to N173DN, cancelled Sep 6, 2017