N914UY
Service difficulty reports · 127
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 = 'N914UY' 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 = 'N914UY' 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 AALA202010309035Link · wornAIRCRAFT IN BASE MAINTENANCE. EXCESSIVE PLAY ON LEFT WING SPOILER NR 3 LINK INBOARD. REPLACED INBOARD LINK, PER CMM57-73-21-400-803-A01 AND AMM 27-64-43-400-001-A.SDR AALA202010259005Hinge Arm · crackedAIRCRAFT IN BASE MAINTENANCE. FOUND CRACK ON HINGE ARM 2 ELEVATOR ON RIGHT HORIZONTAL STABILIZER. REPLACED HINGE ARM 2 ELEVATOR ON RIGHT HORIZONTAL STABILIZER, IAW SRM A321 51-42-11-801 AND DWG D92480076.SDR AALA202010209026Floor Panel · delaminatedAIRCRAFT IN BASE MAINTENANCE. FOUND DELAMINATED AREA ON FLOOR PANEL 251PG MEASURING L=11 IN, W=4 IN. REMOVED AND REPLACED FLOOR PANEL, REF A321 SRM 53-02-00-300-011 FIG.001 & IRM 9701 REV I.SDR AALA202011099015Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE. FOUND L=1.091 INCHES CRACK IN SHEAR PLATE AT STR 23L BETWEEN FR 69 TO FR 70 AT AFT GALLEY AREA. REPLACED SHEAR PLATE, IAW A321 SRM 51-72-11-911-001, 51-42-11-801 & DWG D53471480.SDR AALA202011069013Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE. FOUND L=1.120 INCHES CRACK IN SHEAR PLATE AT FR 69 TO FR 70 AND STR 23R IN AFT GALLEY AREA. REPLACED SHEAR PLATE, IAW SRM A321 51-72-11-911-001, SRM 51-42-11-801 AND DRAWING D53474180.SDR AALA202010309043Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE. FOUND CORRODED AREA LOCATED AT CENTER FITTING ON LOWER SILL AFT LEFT SIDE MEASURING L=3.02 INCHES, W=0.579 INCH, D=0.090 INCH. REPLACED CENTER FITTING LOCATED AT LEVEL STRG 23L AND BETWEEN FR 66/FR 68 AFT GALLEY AREA, REF A321 SSDR AALA202010269028Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION OF FLOOR BEAM BETWEEN FR 12 AND FR 24 AT BL -Y1292, MEASURING L=3.704 IN, W=0.779 IN, D=0.058 IN. REPLACED FLOOR BEAM WITH NEW, IAW A321 SRM 51-72-11-911-001 AND 51-42-11-801 AND DRAWING D53110920000.SDR AALA202010129021Support · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION OF LOWER SILL AT FR 67+19.5 AND STR 23R, MEASURING L=0.275 IN, W=0.180 IN, D=0.029 IN. ACCOMPLISHED PERMANENT REINFORCING SPLICE REPAIR, IAW SRM 53-41-14-300-001 AND 51-42-11-801.SDR AALA202010129015Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION ON LEFT HAND AFT PASSENGER/CREW DOOR CUT OUT LOWER SILL AT FR 67 AND S23L. REPAIRED LOWER SILL, PER SRM A321 SRM 53-41-14-300-001 REPAIR PRINCIPLE 5.SDR AALA202009189008Brake · overheatedAIRCRAFT WAS GROUNDED: ON TAKE OFF ROLL AT 50 KNOTS, ELECTRONIC CENTRALIZED AIRCRAFT MONITOR HOT BRAKE CAME ON. REJECTED TAKE OFF. NUMBER 1 BRAKE WAS SHOWING 320 DEGREES CELSIUS, ALL OTHER BRAKES WERE BELOW 120 DEGREES CELSIUS. PEAK TEMPERATURE WAS 420 DEGRSDR AALA2020032099008Battery · dischargedAIRCRAFT WAS NOT GROUNDED: EMERGENCY POWER SUPPLY UNIT SYSTEM TEST SHOWED "EMERGENCY POWER SUPPLY UNIT 11WL" MESSAGE. MAINTENANCE REPLACED EMERGENCY POWER SUPPLY UNIT 11WL BATTERY PER AMM 33-51-38.SDR AALA2020032099005Light · inoperativeAIRCRAFT NOT GROUNDED - SEAT 27C AISLE EMERGENCY EXIT LIGHT IS INOPERATIVE. REMOVED AND REPLACED SEAT 27C SEAT MOUNTED EMERGENCY LIGHT PER AMM 33-51-19. OPERATIONAL CHECK GOOD.SDR AALA202001219010Smoke Detector · activatedAIRCRAFT WAS NOT GROUNDED: OVERWING LAVATORY SMOKE ALARM INDICATION DUE TO PASSENGER VAPING. PROCEDURES FOLLOWED AND ACCOMPLISHED SATISFACTORY LAVATORY SMOKE DETECTION TEST PER AMM 26-17-00. ALARM CLEARED, NO FURTHER ISSUES NOTED.SDR AALA2018121849015Outflow Valve · failedAIR RETURNED TO DEPARTURE DUE TO A CABIN PRESSURIZATION ISSUE AT OR BELOW 10,000 FEET. VENT SKIN VALVE FAULTED, EXTRACT VALVE POSITION HAD XX DISPLAYED. NO EMERGENCY DECLARED. FLIGHT LANDED WITHOUT FURTHER INCIDENT. AIRCRAFT WAS GROUNDED. MAINTENANCE REPLASDR AALA201809069007Light · damagedSEAT 18L EMERGENCY LIGHT WAS DAMAGED. REPLACED THE EMERGENCY LIGHT IAW AMM 33-51-18. OPS OK.SDR AALA2018081439022Cover · missingDOOR ASSIST HANDLE COVER MISSING. REPLACED AFT DOOR ASSIST HANDLE IAW AMM 52-20-00.SDR AALA201806189029Lens · brokenR4 DOOR EMERGENCY EXIT LIGHT LENS BROKEN. REPLACED THE LENS IAW AMM 33-51-13.SDR AALA201803299016Floor Panel · crackedFORWARD CARGO BAY FLOOR PANEL 131EF JUST AFT OF THE DOOR FOUND CRACKED. REPLACED THE FLOOR PANEL IAW AMM 53-22-14. THE AIRCRAFT WAS GROUNDED.SDR AALA201708239016Proximity Sensor · faultyL2 DOOR FWD EMERGENCY EXIT SHOWS OPEN PRESSURIZATION IS NORMAL. REPLACED PROXIMITY SENSOR IAW AMM.SDR AALA201707109034Lens · brokenSEAT MOUNTED EXIT LIGHT COVER BROKEN. REPLACED SEAT MOUNTED EXIT LIGHT PER AMM 33-51-18.SDR AALA201707109033Lens · brokenR1 DOOR WALL MOUNTED EMERGENCY LIGHT COVER BROKEN. REPLACED R1 DOOR WALL MOUNTED EMERGENCY LIGHT COVER.SDR AALA201707059027Battery Pack · no testEMERGENCY POWER SUPPLY UNIT BATTERY AT THE L3 DOOR FAILED TEST. REMOVED AND REPLACED EPSU BATTERY IAW AMM 33-51-38. OPERATIONAL CHECKED GOOD.SDR AALA201704179037Lens · missingAIRCRAFT NOT GROUNDED. SEAT 1L EMERGENCY LIGHT LENS MISSING. REPLACED EMERGENCY LIGHT LENS.SDR AALA201703279022Lens · unsecureR2 DOOR EMERGENCY LIGHT LENS UNSECURE. INSTALLED THE LENS.SDR AALA201609029012Bottle · low pressureAIRCRAFT WAS NOT GROUNDED. DOOR 3L BOTTLE PRESSURE MESSAGE. SERVICED 3L DOOR ASSIST BOTTLE IAW AMM 52-22-00-614-002.SDR AALA201511029004Unknown · odorAPU BLEED AFTER ENG SHUTDOWN AT GATE, PRODUCES A FOUL ODOR THROUGHOUT CABIN & COCKPIT. APU BLEED SHUTOFF. ACCOMPLISHED TASK CARDS 26L00021001 & 26L00021002 TO IDENTIFY ANY AIR QUALITY ISSUES & POSSIBLE SOURCES WITH NO EVIDENCE OF INGESTION OR LEAKS BEING NOTSDR USAA2014111200007Terminal · brokenROW 7 - 8 CTR CEILING PANEL EMER LIGHT FEMALE PLUG IS BROKEN OFF THE WIRE. REPLACED TERMINAL ON EMER LIGHT AT ROW 7 - 8 IAW ESPM 20-48-14.
Back to N914UY