N972UY
Service difficulty reports · 123
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 = 'N972UY' 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 = 'N972UY' 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 AALA202111037698Battery · fault messageAIRCRAFT WAS NOT GROUNDED: EMERGENCY POWER SUPPLY UNIT BATTERY FAULT AT 15WL. REMOVED AND REPLACED EMERGENCY POWER SUPPLY UNIT BATTERY PER AMM TASK 33-51-11.SDR AALA202110113371Cylinder · low pressureAIRCRAFT WAS GROUNDED: 4R DOOR HAS PRESSURE LIGHT WARNING. REMOVED AND REPLACED R4 DOOR DAMPER/EMERGENCY OPERATION CYLINDER PER 52-13-14-000/400-001B.SDR AALA202110047685Door · low pressureAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT PANEL CAUTION LIGHT FLASHED IN DESCENT CHECK DOOR PRESSURE SHOWED AT 4R DOOR. SERVICED R4 DOOR PER AMM 52-10-00.SDR AALA202109210706Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT CIDS PANEL CAUTION TO CHECK 4R DOOR PRESSURE. SERVICED DOOR ASSIST BOTTLE IAW AMM TASK 52-10-00-614-001-A.SDR AALA202109109810Battery · inoperativeAIRCRAFT IN BASE MAINTENANCE: EMERGENCY POWER SUPPLY UNIT 15WL BATTERY IS INOPERATIVE. REPLACED BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38-400-002-AND AMM 33-51-00-710-001-A.SDR AALA202109090951Skin · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT WING TRAILING EDGE UPPER SKIN PANEL LOWER SURFACE BETWEEN WS 9704 AND WS 10204, BETWEEN RIB 18 AND RIB 19. REPAIRED SKIN PANEL PER SRM 57-21-11-283-012 AND 51-29-11-911-003.SDR AALA202108249155Access Door · wornAIRCRAFT IN BASE MAINTENANCE: RIGHT WING LOWER SURFACE ACCESS DOOR / PANEL 640NB WORN. REPLACED ACCESS DOOR / PANEL PER TASK CARD 26C64057007.SDR AALA202108231080Bracket · brokenAIRCRAFT IN BASE MAINTENANCE: EMERGENCY EXIT DOOR 833 POSITIONING PIN BRACKET OF INFLATION RESERVOIR BROKEN. REPLACED PIN BRACKET PER CMM 25-65-21.SDR AALA202108232087Floor Panel · delaminatedAIRCRAFT IN BASE MAINTENANCE: FORWARD CABIN FLOOR PANEL 221EF DELAMINATED. REPLACED FLOOR PANEL PER SRM 53-02-00-300-011 AND IRM 9701 REV L.SDR AALA202108233950Floor Panel · corrodedAIRCRAFT IN BASE MAINTENANCE CORROSION FORWARD CABIN FLOOR PANEL 221LF. REPLACED FLOOR PANEL PER SRM 53-02-00-300-011 AND IRM 9701 REV LSDR AALA202108194648Pin · frozenAIRCRAFT IN BASE MAINTENANCE: #2 ENGINE AFT ENGINE AFT MOUNT CENTER LINK UPPER POSITION INNER PIN FROZEN INSIDE OUTER PIN. REPLACED INN ER AND OUTER PIN PER AMM 71-22-11-400-010-A.SDR AALA202108184092Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORRODED AREA FOUND ON LEFT CENTER FITTING LOCATED FROM FR66 TO FR 68, STR 23L. L= 2.300 IN, W= 0.565 IN, D= 0.010 IN. REPLACED CENTER FITTING AT AFT GALLEY AREA PER SRM 51-42-11-801.SDR AALA202108165314Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND AFT PASSENGER / CREW DOOR CUT OUT LOWER SILL BETWEEN FR 66 AND FR 68 AT S23R. REPAIRED LOWER SILL PER SRM 53-41-11-14-300-001 PRINCIPLE 7.SDR AALA202108109854Floor Panel · delaminatedAIRCRAFT IN BASE MAINTENANCE: AFT CARGO COMPARTMENT FLOOR PANEL 151LF DELAMINATED. REPLACED FLOOR PANEL PER SRM 53-02-00-300-011 AND IRM 9701 REV L.SDR AALA202108067097Pin · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION #2 ENGINE AFT ENGINE MOUNT LOWER LUG INNER PIN INBOARD SIDE. REPLACED INNER PIN PER AMM 71-22-11-400-010-A.SDR AALA202108057796Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY BEARING HINGE ARM 6 ELEVATOR ON LEFT HORIZONTAL STABILIZER. REPLACED HINGE ARM 6 ELEVATOR ON LH HORIZONTAL STABILIZER IAW AMM 55-16-42-400-001-A.SDR AALA202108050462Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY BEARING HINGE ARM 5 ELEVATOR ON LEFT HORIZONTAL STABILIZER. REPLACED HINGE ARM 5 ELEVATOR ON LEFT HORIZONTAL STABILIZER IAW AMM 55-16-42-400-001-A.SDR AALA202108050184Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY BEARING HINGE ARM 4 ELEVATOR ON LEFT HORIZONTAL STABILIZER. REPLACED HINGE ARM 4 ELEVATOR ON LEFT HORIZONTAL STABILIZER IAW AMM 55-16-42-400-001-A.SDR AALA202108057881Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY BEARING HINGE ARM 3 ELEVATOR ON LEFT HORIZONTAL STABILIZER. REPLACED HINGE ARM 3 ELEVATOR ON LEFT HORIZONTAL STABILIZER IAW AMM 55-16-42-400-001-A.SDR AALA202108040450Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ELEVATOR HINGE ARM 1 ON LEFT HAND HORIZONTAL STABILIZER. REPLACED ELEVATOR HINGE ARM END FITTING 1 PER AMM 55-16-42-400-001-A.SDR AALA202108042418Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ELEVATOR HINGE ARM 1 ON RIGHT HAND HORIZONTAL STABILIZER. REPLACED ELEVATOR HINGE ARM END FITTING 1 PER AMM 55-16-42-400-001-A.SDR AALA202108041307Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ELEVATOR HINGE ARM 2 ON RIGHT HAND HORIZONTAL STABILIZER. REPLACED ELEVATOR HINGE ARM END FITTING 2 PER AMM 55-16-42-400-001-A.SDR AALA202108049955Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ELEVATOR HINGE ARM 3 ON RIGHT HAND HORIZONTAL STABILIZER. REPLACED ELEVATOR HINGE ARM END FITTING 3 PER 55-16-42-400-001-A.SDR AALA202108048830Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ELEVATOR HINGE ARM 4 ON RIGHT HAND HORIZONTAL STABILIZER. REPLACED ELEVATOR HINGE ARM END FITTING 4 PER AMM 55-16-42-400-001-A.SDR AALA202108046993Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ELEVATOR HINGE ARM 6 ON RIGHT HAND HORIZONTAL STABILIZER. REPLACED ELEVATOR HINGE ARM END FITTING 6 PER AMM 55-16-42-400-001-A.SDR AALA202108042753Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ELEVATOR HINGE ARM 5 ON RIGHT HAND HORIZONTAL STABILIZER. REPLACED ELEVATOR HINGE ARM END FITTING 5 PER AMM 55-16-42-400-001-A.SDR AALA202108045337Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ELEVATOR HINGE ARM 2 ON LEFT HAND HORIZONTAL STABILIZER. REPLACED ELEVATOR HINGE ARM END FITTING 2 PER AMM 55-16-42-400-001-A.SDR AALA202108036465Floor Panel · delaminatedAIRCRAFT IN BASE MAINTENANCE: DELAMINATED FLOOR PANEL 151MK IN AFT CARGO COMPARTMENT. REPLACED FLOOR PANEL 151MK IN AFT CARGO COMPARTMENT WITH NEW REPLACEMENT MATERIAL PER A321 SRM 53-02-00-300-011.SDR AALA202108030887Floor Panel · delaminatedAIRCRAFT IN BASE MAINTENANCE: FORWARD CARGO COMPARTMENT FLOOR PANEL 131AF DELAMINATED. REPLACED FLOOR PANEL PER SRM 53-02-00-300-011 AND IRM 9701.SDR AALA202108235104Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND AFT PASSENGER / CREW DOOR CUT OUT LOWER SILL AT FR 66 AND S23R. REPAIRED LOWER SILL PER SRM 53-41-14-300-001 PRINCIPLE 11.SDR AALA202108269437Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON THE AFT LEFT HAND PASSENGER / CREW DOOR CUT OUT LOWER SILL FORWARD CORNER FITTING AT FR 66 AND S23L. REPLACED CORNER FITTING PER SRM 51-42-11.SDR AALA202109136750Shear Plate · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CABIN SHEAR PLATE BETWEEN FR 69 AND FR 70 AT S23R. REPLACED SHEAR PLATE PER SRM 51-42-11.SDR AALA202109088168Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK FOUND ON SHEAR PLATE LOCATED BETWEEN FR69 TO FR70 STR 23L IN AFT GALLEY AREA. LENGTH: 0.740 INCHES. REPLACED SHEAR PLATE IN AFT GALLEY AREA PER A321 SRM 51-42-11-801 AND DRAWING D53470100.SDR AALA202108239119Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FROWARD CABIN FLOOR BEAM AT FR 16 AND +Y1292. REPLACED FLOOR BEAM PER SRM 51-72-11.SDR AALA202108112270Dummy Rail · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CABIN FLOOR DUMMY RAIL AT FR 16 AND Y503.2. REPLACED DUMMY RAIL PER SRM 51-42-11.SDR AALA202108114300Seat Track · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CABIN FLOOR SEAT TRACK AT FR 20 AND -Y1292. REPLACED SEAT TRACK PER SRM 51-42-11.SDR AALA202109017921Skin · wornAIRCRAFT IN BASE MAINTENANCE: RIGHT WING LEADING EDGE SLAT #2 UPPER SURFACE SKIN WORN AT WFX4920 ON THE INBOARD EDGE UPPER FACE. REPAIRED SLAT SKIN PER SRM 57-43-21-300-013 AND SRM 51-42-11-801.SDR AALA202107094243Lock · stickingAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANTS COMPLAINED DOOR 4L IS HARD TO ARM. LUBRICATED THE SLIDE LOCK MECHANISM FOR THE ARM LOCK FUNCTION PER AMM 12-20-00.SDR AALA202105259004Reservoir · low pressureAIRCRAFT WAS NOT GROUNDED. FLIGHT ATTENDANT PANEL INDICATES R3 DOOR LOW SLIDE PRESSURE. REPLACED ESCAPE-SLIDE INFLATION RESERVOIR PER AMM 25-62-49.SDR AALA202105079013Panel · unsecureAIRCRAFT WAS NOT GROUNDED: FIRST OFFICER SIDE ESCAPE ROPE PANEL WILL NOT STAY IN PLACE. REMOVED AND REPLACED ESCAPE ROPE PANEL IAW AMM 25-61-41.SDR AALA202104235532Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R4 DOOR ASSIST BOTTLE LOW PRESSURE. SERVICED R4 DOOR ASSIST BOTTLE PER AMM 52-10-00.SDR AALA202104239002Power Supply · faultedAIRCRAFT WAS NOT GROUNDED: MID RIGHT EMERGENCY POWER SUPPLY UNIT 14WL FAULTING. REPLACED MID RIGHT EMERGENCY POWER SUPPLY UNIT 14WL PER AMM 33-51-38.SDR AALA202103159004Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R4 DOOR CENTRALIZED INTERCOMMUNICATION DATA SYSTEM PANEL HAS PRESSURE LIGHT FLASHING AS REPORTED BY L-1 FLIGHT ATTENDANT. SERVICED R-4 DOOR ASSIST BOTTLE. SYSTEM OPERATIONS NORMAL. PER AMM REF 52-10-00.SDR AALA202103089003Battery · inoperativeAIRCRAFT WAS GROUNDED: FORWARD RIGHT FLIGHT ATTENDANT SEAT FLASHLIGHT INOPERATIVE. REMOVED AND REPLACED FLASHLIGHT BATTERY IAW AMM 25-60-00.SDR AALA202010039001Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R4 DOOR ASSIST BOTTLE LOW. SERVICED R4 DOOR ASSIST BOTTLE PER AMM 52-10-00SDR AALA2020081759006Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R4 DOOR ASSIST BOTTLE PRESSURE IN YELLOW. SERVICED R4 DOOR ASSIST BOTTLE PER AMM 52-22-00.SDR AALA2020062549021Computer · defectiveAIRCRAFT GROUNDED, ABORTED TAKE-OFF. WHEN ADVANCING THRUST AT TAKE-OFF, FLIGHT CONTROL SPOILER 1 AND 2 FAULT. REMOVED AND REPLACED SEC (SPOILER ELEVATOR COMPUTER) 3 PER TSM 27-94-00 AND AMM 27-94-34, OPERATIONAL CHECK OKAY.SDR AALA2020030959003Floor Panel · damagedAIRCRAFT WAS GROUNDED: FLIGHT ATTENDANT REPORT SOFT SPOT IN FLOOR/AISLE BY ROW 6. **SUPPLEMENTAL REPORT:REPLACED FLOOR PANEL PER AMM 53-12-12** (CLOSED)SDR AALA201909179002Unknown · malfunctionedAIRCRAFT NOT GROUNDED: PILOT REPORTS A/P #2 WAS ENGAGED AND DISCONNECTED BY ITSELF ABOUT 5000 FT. ABOVE AIRPORT ELEVATION. "AUTO FLT AP OFF" DISPLAYED ON ECAM UNTILAFTER LANDING. MAINTENANCE ACCOMPLISHED RESET OF FLT WARNING COMPUTERS IAW AMM 34-53-00. ACCOMPLSDR AALA201812189025Mount · corrodedRIGHT ENGINE NR 2 AFT MOUNT HAD CORROSION. REPLACED THE ENGINE MOUNT IAW 71-22-11-0401-13, AND 71-22-11-400-010-A.
Back to N972UY