N767UA, cancelled Dec 19, 2011
Service difficulty reports · 24
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 = 'N767UA' AND deregistration_id = 'N767UA-2011-12-19' 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 = 'N767UA' AND deregistration_id = 'N767UA-2011-12-19' 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 2004UALA00008Engine · flamed outNR 1 ENGINE FLAMEOUT IN FLIGHT. CREW UNABLE TO RESTART ON 2 ATTEMPTS. FUEL PUMP MAIN STAGE FAILURE. IMPLEMENTING SOFT TIME THRESHOLD FOR OVERHAUL OF PUMPS AT SHOP VISIT. REMOVING HIGH-TIME PUMPS IN-SERVICE. TEARDOWN FINDINGS WILL BE ANALYZED TO DETERMINE IFSDR 2003UALA00797Actuator · failedCOULD NOT PRESSURIZE AIRCRAFT ON CLIMBOUT. DOWNLINKED CMC DATABASE SHOWED MAINTENANCE MESSAGE 21-39080, THE CABIN PRESSURE COULD NOT BE CONTROLLED DUE TO FAILED AFT OUTFLOW VALVE CONTROL UNIT (VCU). AFTER REPLACING THE FAILED ACTUATOR ASSY (COMPRISED OF THE SDR 2003UALA00342Wedge · delaminatedT/E WEDGE DELAMINATED - NR 12 SLAT MAJOR REPAIR ACCOMPLISHED. T/E WEDGE REPAIRED.SDR 2003UALA00209Skin · delaminatedTRAILING EDGE WEDGE, SLAT NR 1, DELAMINATED ON LOWER SURFACE. OUTBOARD END SEAL PLUG MISSING. REPAIRED TRAILING EDGE WEDGE. REPLACED OUTBOARD SEAL PLUG.SDR 2003UALA00207Skin · delaminatedLOWER SKIN DELAMINATED ON TRAILING EDGE WEDGE, SLAT NR 11. REPAIRED TRAILING EDGE WEDGE, SLAT NR 11.SDR 2003UALA00205Skin · delaminatedTRAILING EDGE WEDGE, SLAT NR 5, DELAMINATED. SEAL FOAM CORE MISSING SECTION. REPAIRED TRAILING EDGE WEDGE, SLAT NR 5. REPLACED SEAL FOAM CORE.SDR 2003UALA00204Skin · delaminatedDELAMINATED SKIN ON TRAILING EDGE WEDGE, SLAT NR 3, AND SEAL FOAM CORE MISSING SECTION. REPAIRED TRAILING EDGE WEDGE SLAT NR 3. REPLACED SEAL FOAM CORE SECTION.SDR 2003UALA00208Wedge · delaminatedDELAMINATION OF LOWER SKIN ON T/E WEDGE, RIGHT WING. REPAIRED T/E WEDGE, LOWER SKIN, RIGHT WINGSDR 2003UALA00206Skin · delaminatedDELAMINATED TRAILING EDGE WEDGE SKIN (SLAT NR 10). REPAIRED TRAILING EDGE WEDGE, SLAT NR 10.SDR 2003UALA00296Rib · crackedLT O/B HORIZONTAL STABILIZER CLOSE-OUT RIB POST IS DAMAGED/CRACKED. MAJOR REPAIR ACCOMPLISHED. CRACKED RIB POST WAS REPLACED.SDR 2002UALA01140Idg · malfunctionedLOSS OF RIGHT ENGINE GENERATOR ON CLIMBOUT. ENGINE NOT SHUTDOWN. MAINTENANCE MESSAGE 24-31712 WAS PRESENT. MAINTENANCE ACCOMPLISHED CH5588 WITH NO DISCREPANCIES FOUND. REPLACED RIGHT GCU. THE RIGHT IDG AND GCU WERE PREVIOUSLY REPLACED. SUSPECTED THE IDG SDR 2001UALA02238Actuator · seizedAIRCRAFT DIVERTED INTO SLC DUE TO NR 2 ENGINE OSCILLATING. N1 AND N2 DROPPED TO IDLE WITH EGT INCREASING; EGT 570 DEG. ENGINE SHUT DOWN BY FLT CREW. SUPPLEMENTAL DATA UPDATE RIGHT ENGINE SURGED FOLLOWED BY "ENG FAIL" MESSAGE. MAINTENANCE TESTED THE COMPRESSORSDR 2001UALA01041Warning Horn · activatedABORTED TAKEOFF AT APPROX 80 KTS DUE TO ENG FAILURE WARNING HORN SOUNDING.SDR 2001UALA00192Stiffener · crackedSTA 246 BUCKLED VERTICAL STIFFENERS AT LBL - 7.88, 26.05, 48 RBL - 7.88, 13.55, 20, 29.5, 47,53. *S/D* REPLACED STIFFENERS PER SRM 53-10-51, REPAIR 3.SDR 99UAL900560Acm · failedCREW REPORTED SMOKE IN COCKPIT AND AFT CABIN AREAS DURING FLIGHT. *S/D* LEFT HAND AIR CYCLE MACHINE (ACM PN:810209-3) WAS REPLACED PRECAUTIONARY. AIRCRAFT WENT BACK TO REVENUE SERVICE WITHOUT FURTHER SMOKE INCIDENT.SDR 99UAL900207Stiffener · damagedVERTICAL STIFFENERS AT STA 246 FLOORBEAM BUCKLED AND/OR CRACKED IN BEND RADIUS. LOCATIONS WERE AT RBL 50.0 (P/N 144W8518-69), RBL 44.95 (P/N 141W8518-69), RBL 38.0 (P/N 141W8518-87), RBL 32.0, RBL 26.06 (P/N 141W8518-72), RBL 17.21 (P/N 141W8518-73), RBL 7.88SDR 98ZZZX2022Bearing · failedENGINE REMOVED ON 5-6-98 DUE IN-FLIGHT SHUT DOWN FOLLOWING OIL FILTER BYPASS LIGHT AND LOW OIL PRESSURE LIGHT. DISASSEMBLY INSPECTION REVEALED FAILED NR 1 MAIN BEARING WITH HEAVY SPALLING AND 360 DEGREE CAGE SEPARATION. THE BEARING HAS BEEN TURNED OVER TO PRSDR 98UAL900178Bearing · stalledEICAS (ENGINE INDICATION AND CREW ALERT SYSTEM) MESSAGE ENG OIL FILTER R DISPLAYED IN FLIGHT AT 1700Z. AT 1920Z OIL PRESSURE STARTED DOWNWARD STEADILY UNTIL LOW PRESSURE LIGHT ILLUMINATED, SHUT DOWN ENGINE. FOUND METAL ON ALL MAGNETIC CHIP DETECTORS AND OIL SDR 97UAL900326Skin · crackedNR 6 LEADING EDGE SLAT (PN 114W4508-29) CRACKED AT INBOARD TRACK CUTOUT. ONE CRACK THREE INCHES LONG AND THE SECOND IS FIVE INCHES LONG. *S/D* INTERIM REPAIR ACCOMPLISHED AND REPETITIVE INSPECTIONS SCHEDULED AT TEN CYCLE INTERVALS. PERMANENT REPAIR ACCOMPLSDR 96UAL900980Generator · failedEN ROUTE, LOST RIGHT ENGINE DRIVEN GENERATOR. RETURNED TO MIA.SDR 96UAL900774Frame · crackedNR 2 PYLON STRUT AFT FAIRING FRAME NR 5 INBOARD ATTACH FITTING CRACKED. *S/D* FITTING WAS ADJACENT TO PREVIOUSLY REPLACED FITTING. SUSPECT PRELOAD CONDITION INTRODUCED DURING REPLACEMENT. DAMAGED FITTING REPLACED AND SENT TO BOEING FOR ANALYSIS. REPLACEMESDR 96UAL900316Pwr Cont Unit · failedSPOILERS EICAS MESSAGE DURING LANDING ROLL. *S/D* REPLACED NUMBER FOUR SPOILER POWER CONTROL UNIT.SDR 95UAL900030Circuit Breaker · damagedA/C RETURNED TO FIELD WITH LEFT ENGINE EEC AND BLEED PROBLEMS. REPLACED CIRCUIT BREAKER AND WIRE. PER BOEING ANALYSIS THE SCREW HOLDING THE WIRES IN THE CIRCUIT BREAKER WAS CROSS THREADED AND WAS NOT HOLDING THE WIRES SECURE.SDR 95UAL777001Retract Mech · malfunctionedON TAKEOFF GEAR WOULD NOT RETRACT, WOULD RAISE WITH OVER RIDE SWITCH.
Back to N767UA, cancelled Dec 19, 2011