N974UY
Service difficulty reports · 132
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 = 'N974UY' 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 = 'N974UY' 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 AALA2018071099049Girt Bar · fodR2 DOOR WILL NOT ARM. REMOVED DEBRIS FROM THE DOOR GIRT BAR. OPS CHECKED OK IAW AMM 52-70-00.SDR AALA201804049039Door · fodFLIGHT ATTENDANT WAS UNABLE TO ARM THE L4 DOOR. BARELY ABLE TO FULLY RAISE THE ARMING LEVER. REMOVED DEBRIS STUCK UNDERNEATH DOOR ASSEMBLY, CYCLED THE DOOR, OPS CHECKED NORMAL IAW AMM 52-10-00-200-002A.SDR AALA201803059005Lens · missingAIRCRAFT WAS NOT GROUNDED. 1L SEAT MOUNTED EMERGENCY LIGHT MISSING LENS. REPLACED 1L SEAT MOUNTED EMERGENCY LIGHT ASSEMBLY PER 33-51-18.SDR AALA201801269016O-Ring · leakingL3 DOOR ASSIST BOTTLE PRESSURE LOW. REPLACED THE O-RINGS IN THE 3L DOOR PERCUSSION MECHANISM IAW AMM 52-10-00.SDR AALA201801269015Bottle · false indicationL4 DOOR CHECK PRESSURE DOESN'T AGREE WITH COCKPIT STATUS. AIRCRAFT WAS GROUNDED. THE DOOR SLIDE AND ASSIST BOTTLE PRESSURES CHECK NORMAL, PROBLEM IS WITH L3 DOOR ASSIST BOTTLE LOW PRESSURE.SDR AALA201801199028Light · damagedRED FLOOR EMERGENCY LIGHT ROW 9, DAMAGED. MAINTENANCE REPLACED THE LIGHT ASSEMBLY AT ROW 9 AND PERFORMED A SATISFACTORY OPERATIONAL CHECK IAW AMM 33-51-13-0401.SDR AALA201801039010Lens · brokenBROKEN PLASTIC LENS ON THE EMERGENCY EXIT LIGHT. MAINTENANCE SECURED THE EMERGENCY LIGHT LENS.SDR AALA201712289021Damper · low pressureAIRCRAFT NOT GROUNDED. DOOR 3L CHECK DOOR PRESSURE LIGHT ILLUMINATED ON FLIGHT ATTENDANT FORWARD PANEL. SERVICED L3 DOOR DAMPER CYLINDER PER AMM 52-22-00-860-003-A, 52-22-00-410-001A, 52-22-00-010-010-001-A AND 52-22-00-614-002-A. DOOR INDICATES NORMAL ON FLIGSDR AALA201712189072Lens · missingR4 DOOR EMERGENCY LIGHT LENS MISSING. REPLACED THE LENS.SDR AALA201711149010Bottle · low pressureR4 DOOR ASSIST BOTTLE LOW. SERVICED THE DOOR ASSIST BOTTLE.SDR AALA201711139001Cylinder · low pressureON FLT ATTENDANT INDICATOR PANEL, L3 DOOR, CHECK DOOR PRESSURE ILLUMINATED. SERVICED THE CYLINDER IAW AMM .SDR AALA201710059017Bottle · low pressureL3 DOOR BOTTLE PRESSURE LOW. SERVICED THE DOOR BOTTLE IAW AMM.SDR AALA201709039013Floor Support · corrodedCORROSION ON THE FLOOR SUPPORT BETWEEN FRAMES 66 AND 68, Y765. REPLACED THE FLOOR SUPPORT IAW SRM 51-42-11, & SRM 51-43-00, TABLES 4 AND 6.SDR AALA201709039012Floorbeam · corrodedCORROSION ON THE FLOORBEAM AT FRAME 66, Y765. REPLACED THE FLOORBEAM IAW SRM 51-42-11.SDR AALA201708089017Pin · corrodedAIRCRAFT IN BASE MAINTENANCE. RIGHT HAND MAIN LANDING GEAR UPPER TORQUE LINK PIN FOUND CORRODED AND WORN BEYOND LIMITS. REPLACED UPPER TORQUE LINK PIN PER AMM 32-11-27, IPC 32-11-11, AND CARD 26C74032004.SDR AALA201709039011Door Sill · corrodedCORROSION ON THE DOOR SILL PLATE AT FRAME 66, RBL 73. REPLACED THE DOOR SILL PLATE IAW SRM 51-42-11.SDR AALA201709039010Threshold · corrodedCORROSION ON THE L1 DOOR THRESHOLD BETWEEN FRAMES 16 AND 17, Y1975. REPAIRED THE THRESHOLD IAW SRM 53-11-14-283-005.SDR AALA201709039009Threshold · corrodedCORROSION ON THRESHOLD PLATE AT FRAME 20, RBL 70. REPAIRED THRESHOLD PLATE IAW SRM 53-11-14-283-005.SDR AALA201709039008Plate · corrodedCORROSION ON R4 DOOR SILL PLATE AT FRAME 68, REPAIRED THE DOOR SILL PLATE IAW SRM 53-41-14-300-001, FIG 20101, PRINCIPLE 5.SDR AALA201709039007Plate · corrodedCORROSION ON THE R4 DOOR SILL PLATE AT FRAME 68, -Y1965. REPAIRED THE SILL PLATE IAW SRM 53-41-14-283-002, FIG 10101, SHEET 1.SDR AALA201709039006Fitting · corrodedCORROSION ON FITTING BETWEEN FRAMES 16 AND 20, -Y1970. REPLACED THE FITTING IAW SRM 51-72-11.SDR AALA201709039005Threshold · corrodedCORROSION ON THE R1 DOOR THRESHOLD PLATE AT FRAME 16, RBL 70. REPAIRED THE THRESHOLD PLATE IAW SRM 53-11-14-283-005, FIG 10108.SDR AALA201709039004Threshold · corrodedCORROSION ON L1 DOOR THRESHOLD BETWEEN FRAMES 19A TO 20, Y1732. REPAIRED THE THRESHOLD IAW SRM 53-11-14-283-005.SDR AALA201709039003Floor Support · corrodedCORROSION ON FLOOR SUPPORT BETWEEN FRAMES 66+5 & 68, Y765. REPLACED THE FLOOR SUPPORT IAW SRM 51-42-11, 51-43-00-001, TABLE 4 - 6, & D53472815.SDR AALA201701139003Bottle · low pressureL3 DOOR PRESSURE MESSAGE ON CIDS PANEL. MAINTENANCE SERVICED DOOR ASSIST BOTTLE PER AMM 52-10-00.SDR AALA201611149016Warning Light · illuminatedFLIGHT CREW REPORTED A CAUTION LIGHT CAME ON DURING THE TAKE OFF ROLL AT 40 KNOTS. ABORTED THE TAKE OFF AND THE CREW REPORTED THAT NO OTHER INDICATION OCCURRED. CREW ATTEMPTED TO RECALL THE ECAM INDICATION BUT COULD NOT. FIRST OFFICER SAW BRAKE INDICATION FSDR AALA201606279005Fan · failedAIRCRAFT WAS GROUNDED: UNUSUAL NOISE FROM BELOW FORWARD GALLEY FLOOR ACCOMPANIED BY ACRID ODOR IN COCKPIT. MAINTENANCE FOUND THE AVIONICS BLOWER FAN, 20HQ, BEARINGS WORN, GRINDING. REPLACED THE BLOWER FAN IAW AMM 21-26-51-400-001-A. A SATISFACTORY OPS CHECSDR AALA201606139006Coffeemaker · smokeAIRCRAFT WAS NOT GROUNDED: F/A REPORTED LIGHT SMOKE FROM AFT GALLEY COFFEEMAKER. SMOKE CLEARED WHEN POWER WAS REMOVED FROM THE COFFEEMAKER WHICH REMAINED UNPOWERED FOR THE DURATION OF THE FLIGHT. MAINTENANCE REPLACED BOTH AFT GALLEY COFFEEMAKERS IAW AMM 25-35SDR AALA201605289004Bottle · low pressureAIRCRAFT WAS NOT GNDED. R4 DOOR PRESS BELOW THE LIMITS. SERVICED R4 DOOR BOTTLE IAW AMM 52-13-00.SDR AALA201604269008Proximity Sensor · defectiveRETURNED & ACFT WAS GNDED. SHORTLY AFTER TAKEOFF, FLIGHT CREW REPORTED A LGCIU NR 1 ECAM MSG & RETURNED WHERE THE ACFT LANDED SAFELY. REPLACED THE RT MLG DOOR UPLOCK PROXIMITY SENSOR 26GA. ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK IAW AMM 32-31-73-400-0SDR AALA201512219011Lens · brokenAIRCRAFT WAS GNDED. L1 DOOR EMER LIGHT COVER BROKEN. R & R EMER EXIT LIGHT LENS. OPERATIONAL CHECKED GOOD, REFERENCE AMM 33-51-13.SDR AALA201512099008Power Supply · inoperativeAIRCRAFT WAS NOT GNDED. BATTERY & EPSU 15WL, MID LT FAULT. REPLACED BATTERY & EPSU 15WL MID LT IAW AMM 33-51-38-400-002-A.
Back to N974UY