N917UY
Service difficulty reports · 90
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 = 'N917UY' 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 = 'N917UY' 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 AALA202012079002Hinge Fitting · wornAIRCRAFT IN BASE MAINTENANCE. LEFT ELEVATOR NR 1 HINGE HAS EXCESSIVE PLAY/WEAR ON THE LEFT HAND HORIZONTAL STABILIZER. REPLACED HINGE FITTING, PER AMM 55-16-42.SDR AALA202012069007Hinge Fitting · wornAIRCRAFT IN BASE MAINTENANCE. RIGHT ELEVATOR NR 6 HINGE HAS EXCESSIVE PLAY/WEAR ON THE RIGHT HAND HORIZONTAL STABILIZER. REPLACED HINGE FITTING, PER AMM 55-16-42.SDR AALA202012069006Hinge Fitting · wornAIRCRAFT IN BASE MAINTENANCE. RIGHT ELEVATOR NR 4 HINGE HAS EXCESSIVE PLAY/WEAR ON THE RIGHT HAND HORIZONTAL STABILIZER. REPLACED HINGE FITTING, PER AMM 55-16-42.SDR AALA202012069005Hinge Fitting · wornAIRCRAFT IN BASE MAINTENANCE. RIGHT ELEVATOR NR 3 HINGE HAS EXCESSIVE PLAY/WEAR ON THE RIGHT HAND HORIZONTAL STABILIZER. REPLACED HINGE FITTING, PER AMM 55-16-42.SDR AALA202012069004Hinge Fitting · wornAIRCRAFT IN BASE MAINTENANCE. RIGHT ELEVATOR NR 2 HINGE HAS EXCESSIVE PLAY/WEAR ON THE RIGHT HAND HORIZONTAL STABILIZER. REPLACED HINGE FITTING, PER AMM 55-16-42.SDR AALA202012069003Hinge Fitting · wornAIRCRAFT IN BASE MAINTENANCE. RIGHT ELEVATOR NR 1 HINGE HAS EXCESSIVE PLAY/WEAR ON THE RIGHT HAND HORIZONTAL STABILIZER. REPLACED HINGE FITTING, PER AMM 55-16-42.SDR AALA202012069002Hinge Fitting · wornAIRCRAFT IN BASE MAINTENANCE. LEFT ELEVATOR NR 6 HINGE HAS EXCESSIVE PLAY/WEAR ON THE LEFT HAND HORIZONTAL STABILIZER. REPLACED HINGE FITTING, PER AMM 55-16-42.SDR AALA202012069001Hinge Fitting · wornAIRCRAFT IN BASE MAINTENANCE. LEFT ELEVATOR NR 5 HINGE HAS EXCESSIVE PLAY/WEAR ON THE LEFT HAND HORIZONTAL STABILIZER. REPLACED HINGE FITTING, PER AMM 55-16-42.SDR AALA202012049001Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE. FOUND EXCESSIVE PLAY ELEVATOR HINGE ARM 5 ON RIGHT HORIZONTAL STABILIZER. REPLACED ELEVATOR HINGE ARM END FITTING NR 5 ON RIGHT HORIZONTAL STABILIZER, IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001.SDR AALA202101049010Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE. CRACKED AFT CABIN FLOOR SHEAR PLATE BETWEEN FR 69 AND FR 70 AT S23L. REPLACED SHEAR PLATE, PER SRM 51-42-11.SDR AALA202012289006Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE. FOUND L=0.838 INCH CRACK ON 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, 51-42-11-801 AND DRAWING D53474180.SDR AALA202012179011Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE. FOUND CORRODED AREA ON CENTER SHAPE FITTING BETWEEN FR 66 AND FR 68 AT STR 23L, MEASURING L=9.670 INCH, W= 0.500 INCH D=0.045 INCH. REPLACED CENTER FITTING, IAW SRM A321 51-72-11-911-001, 51-42-11-801 & DWG D53480505.SDR AALA202012159010Support · corrodedAIRCRAFT IN BASE MAINTENANCE. FOUND CORRODED AREA ON SILL AT FR 68 AND STR 23R AT AFT GALLEY AREA, MEASURING L=1.196 INCHES W=0.850 INCHES D=0.063 INCHES. PERMAMENT REPAIR PERFORMED ON LOWER SILL AT LEVEL AT AFT GALLEY AREA, IAW A321 SRM 53-41-14-300-001 REPSDR AALA202012079026Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE. FOUND CORROSION ON CENTER SHAPE FITTING LOCATED AT STGR 23R BETWEEN FR 66 AND FR 68 AT AFT GALLEY AREA, MEASURING L=1.650 INCHES W=0.650 INCHES D=0.0450 INCHES. REPLACED CENTER FITTING, IAW SRM A321 51-72-11-911-001 AND DWG D534SDR AALA202012029012Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE. FOUND CORRODED AREA ON LOWER SILL AT FR 68 AND STR 23L. CORROSION AREA MEASURED L=1.151 INCH, W=0.783 INCH, D=0.063 INCH. PERFORMED PERMANENT REPAIR ON LOWER SILL IN AFT GALLEY AREA, IAW A321 SRM 53-41-14-300-001 PRINCIPLE 5 FISDR AALA2020070989013O-Ring · damagedAIRCRAFT WAS GROUNDED: DURING CLIMB NOTICED LEFT ENGINE OIL QUANTITY DROPPING BELOW 4.0 QUARTS. EVENTUALLY WENT TO 0. 10 MIN LATER OIL PRESSURE SLOWLY DROPPED TO MIN WHICH TRIGGERED ENGINE SHUTDOWN MESSAGE APPEARED ON THE ECAM AND THE PILOT ENGAGED THE NR 1 SSDR AALA201904169022Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L1, L2, R1, R2, R3 DOOR ASSIST BOTTLES LOW. MAINTENANCE CHARGED L1 (SEE AALA201904159006), L2 (SEE AALA201904169019), R1 (SEE AALA201904169020), R2 (SEE AALA201904169021), R3 DOOR CYLINDER PER AMM 52-10-00 AND PERFORMED SATISFACTORY SDR AALA201904169021Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L1, L2, R1, R2, R3 DOOR ASSIST BOTTLES LOW. MAINTENANCE CHARGED L1 (SEE AALA201904159006), L2 (SEE AALA201904169019), R1 (SEE AALA201904169020), R2, R3 (SEE AALA201904169022) DOOR CYLINDER PER AMM 52-10-00 AND PERFORMED SATISFACTORY SDR AALA201904169020Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L1, L2, R1, R2, R3 DOOR ASSIST BOTTLES LOW. MAINTENANCE CHARGED L1 (SEE AALA201904159006), L2 (SEE AALA201904169019), R1, R2 (SEE AALA201904169021), R3 (SEE AALA201904169022) DOOR CYLINDER PER AMM 52-10-00 AND PERFORMED SATISFACTORY SDR AALA201904169019Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L1, L2, R1, R2, R3 DOOR ASSIST BOTTLES LOW. MAINTENANCE CHARGED L1 (SEE AALA201904159006), L2, R1 (SEE AALA201904169020), R2 (SEE AALA201904169021), R3 (SEE AALA201904169022) DOOR CYLINDER PER AMM 52-10-00 AND PERFORMED SATISFACTORY SDR AALA2019041659006Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L1, L2, R1, R2, R3 DOOR ASSIST BOTTLES LOW. MAINTENANCE CHARGED L1, L2 (SEE AALA201904169019), R1 (SEE AALA201904169020), R2 (SEE AALA201904169021), R3 (SEE AALA201904169022) DOOR CYLINDER PER AMM 52-10-00 AND PERFORMED SATISFACTORY SDR AALA201811199009Fan · faultyDURING TAXI, THE ACFT HAD A LOUD AIR NOISE IN THE COCKPIT AND STRONG ELECTRICAL ODOR, VENT EXTRACT FAN FAULTED. FLIGHT RETURNED TO GATE. THE AIRCRAFT WAS GROUNDED. FOUND EXTRACT FAN TO BE FAULTY. REPLACED EXTRACT FAN IAW MM 21-26-51-400. SYSTEM OPS CHESDR AALA201805179006Pressure Switch · failedDOOR PRESSURE SWITCH 14WN FAILED A LEAK CHECK. REPLACED THE PRESSURE SWITCH IAW 52-73-12.SDR AALA201709129027Landing Light · faultyLANDING LIGHT CIRCUIT BREAKER TRIPPED IN FLIGHT AND HAD A BRIEF ELECTRICAL ODOR. REMOVED AND REPLACED LT LANDING LIGHT ASSY IAW AMM.SDR AALA201709089004Acquisition Unit · failedELECTRICAL ODOR AND FAULTS. FOUND THE NR 1 SYSTEM DATA ACQUISTION UNIT BAD. REPLACED SYSTEM DATA ACQUISTION UNIT.SDR AALA201706289005Warning Message · false activationAFTER COMPLETION OF A R & R OF THE R1 DOOR SLIDE CIDS 1 GROUND REPORT SHOWS SLIDE BOTTLE FWD R1 DEU B AND SLIDE BOTTLE FWD L1 MESSAGES. PERFORMED CIDS GROUND SCAN IAW AMM 23-73-00-740-012-A & CIDS INTERFACE AND POWER-UP TESTED IAW AMM 23-73-00-740-005-B NO SDR AALA201706199044Diaphragm · failedDOOR DAMPER AND EMERGENCY OPERATION CYLINDER FOR THE L4 DOOR DISCHARGED. REPLACED THE DIAPHRAGM IN THE PERCUSSION MECHANISM IAW AMM TASK 52-10-00-610-001-A.SDR AALA201705019018Lens · missingEMERGENCY EXIT LIGHT IN AFT GALLEY AREA COVER MISSING AND NO LIGHT BULBS FOUND DURING PREFLIGHT.SDR AALA201704249012Girt Bar · obstructedL1 DOOR SLIDE WAS DIFFICULT TO ARM. REMOVED DEBRIS FROM GIRT BAR ARMING SURFACE.SDR AALA201605299001Battery · dischargedAIRCRAFT WAS NOT GNDED. EMER POWER SUPPLY UNIT 15WL FAILS TEST. REPLACED EMER POWER SUPPLY UNIT BATTERY & ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK IAW AMM 33-51-38.SDR AALA201512239014Seal · leakingAIRCRAFT WAS NOT GNDED. 3L DOOR HAS CHECK DOOR PRESS ON FLIGHT ATTENDANT CIDS PANEL. TROUBLE SHOT IAW TSM 52-22-00-810-815-A. R & R 3L DOOR, DOOR DAMPER CHARGING VLV & PERCUSSION MECHANISM SEAL. LEAK CHECK OK IAW AMM 52-22-00.SDR AALA201512239004Valve · leakingAIRCRAFT WAS NOT GNDED. 3L DOOR HAS CHECK DOOR PRESS ON FLIGHT ATTENDANT CIDS PANEL. TROUBLE SHOT IAW TSM 52-22-00-810-815-A. R & R 3L DOOR, DOOR DAMPER CHARGING VLV & PERCUSSION MECHANISM SEAL. LEAK CHECK OK IAW AMM 52-22-00.SDR AALA201512149007Bottle · low pressureAIRCRAFT WAS NOT GNDED, DOOR 3L CHECKED DOOR PRESS ON CIDS PANEL. SERVICED 3L DOOR ASSIST BOTTLE IAW AMM 52-10-00-614-001-A.SDR AALA201512069007Cylinder · low pressureAIRCRAFT WAS NOT GNDED. BELOW 10,000 FT CHECK DOOR PRESS LIGHT ILLUMINATED FOR 3L DOOR. SERVICED DOOR DAMPER & EMER OPERATION CYLINDER IAW AMM 52-22-00-614-002-A.SDR AALA201511039004Bottle · low pressureCIDS PANEL MSG, CHECK 3L DOOR PRESS. SERVICED DOOR ASSIST BOTTLE 3L DOOR.SDR AALA201509109005Bottle · low pressureANNUNCIATION 3L, CHECK DOOR PRESS, ON FLIGHT ATTENDANT PANEL. CHARGED 3L DOOR IAW AMM 52-22-00 TO NORMAL PRESS, OK FOR SERVICE.SDR AALA201509079009Damper · low pressureEMERGENCY EXIT DOOR L3 CYLINDER BOTTLE, PRESS LOW YELLOW RANGE AT 74F. SERVICED EMER EXIT DOOR L3 CYLINDER DAMPER IAW AMM 52-22-00-614-002.SDR AALA201509039003Cylinder · low pressureCHECK DOOR PRESS ILLUMINATED ON SIDS PANEL AT ABOUT 10,000' ON ARRIVAL. AIR CHARGING OF DOOR DAMPER & EMER OPERATIONS CYLINDER IAW MM 52-22-00-614-002-A. OPERATIONS CHECK LEAK. CHECKED GOOD.SDR AALA201508319002Damper · low pressure3L DOOR SLIDE LOW PRESS. CHARGED THE 3L DOOR DAMPER IAW AMM 52-10-00-614-001. ALL INDICATIONS NORMAL.SDR USAA2015012800004Connector · looseEMERGENCY LIGHT CONNECTOR ROW 30L, NEEDS CONNECTOR CRIMPED INTO PLACE, MARKED WITH RED & WHITE TAPE. CRIMPED CONNECTOR.
Back to N917UY