N977UY
Service difficulty reports · 159
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 = 'N977UY' AND registry_match = 'registration' 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 = 'N977UY' AND registry_match = 'registration' 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 AALA201811239003Hinge · looseLEFT FORWARD HINGE BEARING OF MAIN LANDING GEAR DOOR WAS LOOSE. REPLACED THE HINGE IAW SRM 51-44-11-001.SDR AALA201812129003Tab · delaminatedAIRCRAFT WAS IN BASE MAINTENANCE. DELAMINATION ON INBOARD FLAP TAB LOCATED AT STA RIB 4 TO RIB 6. REPAIRED INBOARD FLAP TAB ON RIGHT HAND WING PER EA 287340.SDR AALA201812109048Support · corrodedCORROSION WAS FOUND ON THE LOWER SILL FRAME 62, STRINGER 38R IN THE BULK CARGO BAY. REPAIRED THE SILL IAW SRM 53-41-49-300-003.SDR AALA2018121329004Shear Plate · crackedCRACK INDICATION FOUND ON THE SHEAR PLATE BETWEEN FRAMES 69-70, STRINGER 23R IN THE AFT GALLEY AREA. REPLACED SHEAR PLATE IAW SRM 51-72-11.SDR AALA2018121109049Support · corrodedCORROSION FOUND ON THE LOWER SILL BETWEEN FRAMES 66 - 68, STRINGER 23R, IN THE AFT GALLEY. REPLACED THE LOWER SILL IAW SRM 51-72-11, AND DRAWING D53480505.SDR AALA201811279005Shear Plate · crackedSHEAR PLATE FOUND CRACKED AT FRAMES 69 TO 70, STRINGER 23L. REPLACED THE SHEAR PLATE IAW SRM 51-72-11, AND DWG D5347112420200.SDR AALA201812119002Floor Panel · delaminatedDELAMINATION FOUND ON FLOOR PANEL 131EF, FRAMES 28 - 31, Y765 TO -Y765 IN THE FORWARD CARGO COMPARTMENT. REPLACED FLOOR PANEL IAW SRM 53-02-00-300-011, PARA 2, FIGURE 20109, AND IRM 9701 REV I.SDR AALA201810059001Floor Panel · delaminatedFORWARD GALLEY FLOOR PANEL 222EF DELAMINATED. THE AIRCRAFT WAS GROUNDED. REPLACED THE FLOOR PANEL.SDR AALA201810049010Floor Panel · delaminatedAIRCRAFT WAS GROUNDED. FORWARD GALLEY FLOOR PANEL 221EF WAS DELAMINATED AFT OF FLIGHT DECK DOOR. REPLACED FLOOR PANEL PER AMM 53-00-00-400-801A.SDR AALA201810029032Seat Track · corrodedCORROSION FOUND ON THE SEAT TRACK AT FRAME 16, Y+254. THE AIRCRAFT WAS GROUNDED. REPLACED THE SEAT TRACK IAW 51-42-11.SDR AALA201810029029Seat Track · corrodedCORROSION FOUND ON THE SEAT TRACK AT FRAME 16, Y-254. THE THE AIRCRAFT WAS GROUNDED. REPLACED THE SEAT TRACK.SDR AALA201810039004Seat Track · corrodedCORROSION FOUND ON THE FORWARD GALLEY SEAT TRACK AT FRAME 16, Y-1292. THE AIRCRAFT WAS GROUNDED. REPAIRED THE SEAT TRACK IAW EA 285569.SDR AALA201807029050Lens · missingL4 DOOR, EMERGENCY EXIT LIGHT MISSING THE LENS. MAINTENANCE INSTALLED THE LENS IAW AMM 33-51-13-400-001-A, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201802219042Floor Panel · damagedAFT CARGO FLOOR PANEL 151PF SPONGY. REPLACED AFT CARGO FLOOR PANEL IAW AMM 53-42-00.SDR AALA201801169032Battery Pack · inoperativeR4 DOOR, FORWARD CIDS PANEL INDICATED CHECK SLIDE PRESSURE. REMOVED AND REPLACED THE SLIDE IAW JC 26L00025010 AND REPLACED THE L1 EMERGENCY LIGHT BATTERY PACK IAW MM 33-51-38. SYSTEM CHECKED GOOD.SDR AALA201801099013Arming Lever · looseARMING LEVER ON THE R3 DOOR IS LOOSE. SECURED THE HANDLE. OPS CHECKED OK.SDR AALA201801029048Light · brokenSEAT 22 LEFT, MOUNTED EMERGENCY LIGHT FOUND BROKEN. REPLACED THE EMERGENCY LIGHT ASSY IAW AMM 33-51-18.SDR AALA201712159017Floor Panel · damagedAIRCRAFT GROUNDED. CENTER AISLE FLOOR PANEL 241AF AT ROW 13 SOFT AND SPONGY. REPLACED CABIN FLOOR PANEL 241AF AT ROW 13 AS PER SRM TASK #53-32-12-400-002 CHECK GOOD. AIRCRAFT OK FOR SERVICE.SDR AALA201709139013Lens · missingEMERGENCY LIGHT LENS MISSING AT THE R3 DOOR. INSTALLED A LENS.SDR AALA201709089015Wire · brokenAIRCRAFT WAS GROUNDED: GREEN ENGINE 1 PUMP FAILURE AFTER POWER REDUCTION ON TAKEOFF, AN EMERGENCY WAS DECLARED, THE AIRCRAFT RETURNED TO CLT WHERE IT LANDED SAFELY AND WAS TOWED TO THE GATE. MAINTENANCE FOUND BROKEN WIRES (8P057 AND 8P073) TO CONNECTOR 107(4)GSDR AALA201709089014Switch · faultyAIRCRAFT WAS GROUNDED: GREEN ENGINE 1 PUMP FAILURE AFTER POWER REDUCTION ON TAKEOFF, AN EMERGENCY WAS DECLARED, THE AIRCRAFT RETURNED TO CLT WHERE IT LANDED SAFELY AND WAS TOWED TO THE GATE. **SUPPLEMENTAL REPORT TO UPDATE SECTIONS 4 AND 5. MAINTENANCE REPLACESDR AALA201709069005Pressure Switch · faultyAIRCRAFT WAS GROUNDED: GREEN ENGINE 1 PUMP FAILURE AFTER POWER REDUCTION ON TAKEOFF, AN EMERGENCY WAS DECLARED, THE AIRCRAFT RETURNED TO CLT WHERE IT LANDED SAFELY AND WAS TOWED TO THE GATE. MAINTENANCE REPLACED PRESSURE SWITCH 1074GK PER AMM 29-11-17. (CLOSEDSDR AALA201709019019Floor Panel · delaminatedAIRCRAFT WAS GROUNDED. DELAMINATION ON AFT CARGO BIN FLOOR PANEL 151LF. REPLACED CARGO FLOOR PANEL PER AMM 53-42-14.SDR AALA201709019018Floor Panel · delaminatedAIRCRAFT WAS GROUNDED. DELAMINATION ON AFT CARGO FLOOR PANEL 151MK. REPLACED CARGO FLOOR PANEL PER AMM 53-42-14.SDR AALA201709019017Floor Panel · delaminatedAIRCRAFT WAS GROUNDED. DELAMINATION ON AFT CARGO FLOOR PANEL 151GF. REPLACED CARGO FLOOR PANEL PER AMM 53-42-14.SDR AALA201708249010Lens · missingEXIT LIGHT COVER NEAR THE L4 DOOR SLIDE BUSTLE IS MISSING. INSTALLED EXIT LIGHT LENS COVER AT 4L DOOR IAW AMM.SDR AALA201707059005Transducer · faultyAIRCRAFT WAS GROUNDED. EMERGENCY DECLARED. RETURNED TO CLT. ENGINE 1 HYDRAULIC PUMP LOW PRESSURE ON CLIMB OUT. NO SYSTEM LOSS. OVER WEIGHT LANDING ACCOMPLISHED IN CLT 182.7 LBS/FLAPS FULL/100 FPM VERTICAL SPEED AT TOUCHDOWN. MAINTENANCE REPLACED HYDRAULIC PRESSDR AALA201707039024Pump · failedAIRCRAFT WAS GROUNDED. DIVERTED TO MCO. EMERGENCY DECLARED. FLIGHT CREW REPORTED FAILURE OF NR 1 HYDRAULIC GREEN PUMP INFLIGHT AND LOSS OF GREEN SYSTEM PRESSURE. ACCOMPLISHED TSM 29-11-00-810 FOR LOSS OF PRESSURE NR 1 PUMP. REMOVED AND REPLACED CASE DRAIN FILSDR AALA201706029012Lens · brokenR4 DOOR EXIT LIGHT LENS BROKEN. REPLACED EMERGENCY LIGHT LENS.SDR AALA201705239016Power Supply · faultedFIVE EMERGENCY EXIT ROW LIGHTS WERE INOPERATIVE WHEN TESTED. TROUBLESHOT AND FOUND THE EPSU 11WL FAULTED, REMOVED AND REPLACED EMERGENCY POWER SUPPLY UNIT 11WL IAW AMM 33-51-38-000-001-A.SDR AALA201705229031Power Supply · faultedFIVE EMERGENCY EXIT ROW LIGHTS WERE INOPERATIVE WHEN TESTED. TROUBLESHOT AND FOUND EPSU 11WL FAULTED , REMOVED AND REPLACED EMERGENCY POWER SUPPLY IAW AMM 33-51-38-000-001-A.SDR AALA201704279028Lens · missingAIRCRAFT NOT GROUNDED. R1 DOOR EMERGENCY LIGHT LENS MISSING. INSTALLED EMERGENCY LIGHT LENS ON R1 DOOR AS REQUIRED.SDR AALA201701289003Diaphragm · leakingL4 DOOR CYLINDER HAS PREVIOUS HISTORY FOR REQUIRING SERVICING. REPLACED DOOR DAMPER DIAPHRAGM PER AMM 32-22-00-860-002-A. NO LEAKS NOTED. AIRCRAFT WAS GROUNDED.SDR AALA201701269019Bottle · low pressureL4 DOOR SHOWING LOW DOOR PRESSURE. MAINTENANCE SERVICED THE DOOR ASSIST BOTTLE IAW AMM 52-10-00. AIRCRAFT WAS GROUNDED.SDR AALA201701269016Bottle · low pressureCREW REPORT THE L4 DOOR SHOWS LOW PRESSURE. MAINTENANCE SERVICED THE DOOR ASSIST BOTTLE IAW AMM 52-10-00. AIRCRAFT WAS GROUNDED.SDR AALA201701229002Bottle · low pressureAIRCRAFT WAS NOT GROUNDED. FLIGHT ATTENDANT #1 STATUS DISPLAY INDICATES CHECK DOOR PRESSURE AT 4L DOOR. MAINTENANCE SERVICED 4L DOOR ASSIST BOTTLE PER AMM 52-10-00.SDR AALA201701199002Bottle · low pressureAIRCRAFT WAS NOT GROUNDED. 4 L DOOR INDICATES NOT ARMED AT DOOR. ECAM UP FRONT INDICATES NORMAL MAINTENANCE SERVICED L4 DOOR ASSIST BOTTLE PER MM 52-10-00.SDR AALA201701189011Arming Lever · brokenAIRCRAFT WAS GROUNDED. BROKEN SLIDE ARM-DISARM LEVER AT DOOR 3R. MAINTENANCE REPLACED ARM-DISARM UNIT PER AMM 52-22-22.SDR AALA201701149002Bottle · low pressureAIRCRAFT WAS NOT GROUNDED. WHEN 4L DOOR CLOSED, FORWARD FLIGHT ATTENDANT MONITOR SAYS CHECK DOOR PRESSURE. MAINTENANCE SERVICED DOOR ASSIST BOTTLE PER AMM 52-10-00.SDR AALA201701119008Bottle · low pressureAIRCRAFT WAS NOT GROUNDED. DOOR 4L PRESSURE LOW. MAINTENANCE SERVICED DOOR 4L ASSIST BOTTLE PER AMM 52-10-00.SDR AALA201701069014Bottle · low pressureAIRCRAFT WAS NOT GROUNDED. CIDS CAUTION ON FLIGHT ATTENDANT PANEL FOR DOOR 4L SERVICED 4L DOOR ASSIST BOTTLE PER 52-10-00.SDR AALA201701029003Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: DOOR BOTTLE AFT 4L LOW PRESSURE. SERVICED DOOR ASSIST BOTTLE AT DOOR 4L PER AMM 52-10-00.SDR AALA201612309005Bottle · low pressureCIDS PANEL DISPLAYED AN AMBER WARNING CHECK L4 DOOR PRESSURE WARNING. SERVICED THE L4 DOOR ASSIST BOTTLE IAW AMM 52-10-00.SDR AALA201612279003Bottle · low pressureFLIGHT ATTENDANT CIDS PANEL MESSAGE FOR L4 DOOR BOTTLE LOW. SERVICED THE DOOR ASSIST BOTTLE IAW AMM 52-10-00.SDR AALA201612229004Bottle · low pressureFORWARD FLIGHT ATTENDANT PANEL SHOWS L4 DOOR LOW PRESSURE. SERVICED DOOR ASSIST BOTTLEAND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201612199002Bottle · low pressureL4 DOOR PRESSURE LOW. SERVICED THE DOOR ASSIST BOTTLE IAW AMM 12-14-00.SDR AALA201612159010Bottle · low pressureAFTER PUSHBACK, NR 1 FLIGHT ATTENDANT ADVISED THAT 4L DOOR LOW PRESSURE ANNUNCIATED ON FORWARD FLIGHT ATTENDANT PANEL. SERVICED L4 DOOR DAMPER IAW AMM 52-10-00.SDR AALA201612089004Bottle · low pressureCID SCREEN INDICATES CHECK DOOR PRESSURE AT THE L4 DOOR. MAINTENANCE SERVICED DAMPER AT L4 DOOR IAW AMM 52-10-00.SDR AALA201610259017Cover · missingAIRCRAFT WAS NOT GROUNDED. MISSING AFT LEFT EXIT DOOR LIGHT COVER. REPLACED LIGHT COVER.SDR AALA201610249002Cover · missingAIRCRAFT WAS NOT GROUNDED. MISSING AFT RIGHT EXIT DOOR LIGHT COVER. REPLACED LIGHT COVER.
Back to N977UY