N642UA
Service difficulty reports · 354
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 = 'N642UA' 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 = 'N642UA' 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 UALA2012010600136Skin · damagedAIRCRAFT DAMAGED BY LOADER, DAMAGE AFT OF AFT CARGO DOOR ABOUT 10 INCHES IN FRONT OF EXTERIOR AREA LIGHT. DAMAGE IS LOCATED BETWEEN STRINGER 27R AND 28R. BS 1373. MEASURES 4"X4".350 DEEP, GOUGES ARE .030 AND .060 DEEP. FRAME SHEAR TIE FOUND CRACKED AT BS 1SDR UALA2012010400095Shear Tie · damagedFOUND SHEAR TIE DAMAGED AT STA 1373 BTWN STRINGERS S27-R AND S28-R. SHEAR TIE HAS 3 SHEARED RIVETS ALONG WITH 5 AND HALF INCH TEAR, WHICH HAS BUCKLED THE FRAME. MAJOR REPAIR ACCOMPLISHED. FABRICATED & INSTALLED NEW SHEAR TIE PER SRM.SDR UALA2012010400094Skin · damagedDURING OPEN UP OF DAMAGED AREA AFT OF THE AFT CARGO DOOR, FOUND BENT FRAME AT STA 1373 BETWEEN STR 27R AND 28R. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED REPAIR FILLERS (2 EA), STIFFENERS (2 EA), CHANNEL, AND SHEAR TIE PER ECRA 5360-01171 AND EA PDSDR UALA2012010400093Intercostal · puncturedFOUND PUNCTURE IN AFT CARGO PIT INTERCOSTAL AT REAR OF CARGO DOOR OPENING STRINGER 28R LEVEL. APPEARS TO BE UNRELATED TO INITIAL DAMAGE (FOUND WHILST EVALUATING) PUNCTURE IS APPROX 4.5" X 2.5". FABRICATED AND INSTALLED NEW INTERCOSTAL STA 1351 - 1373, STR 28SDR UALA2012010300015Floorbeam · corrodedPASSENGER CABIN FLOOR STRUCTURE AT BS 347, BTWN RBL 19 - 40 HAS CORROSION. MAJOR REPAIR ACCOMPLISHED. FOUND CORROSION OUT OF LIMITS, FABRICATED AND INSTALLED TEE, STRAPS, AND ANGLES FROM RBL 19 - RBL 60 PER SRM ON NR 3872N00504.SDR UALA2012010300011Frame · corrodedCORROSION ON FRAME STA 916, NEAR STR 20L. CORROSION OUT OF LIMITS, FABRICATED AND INSTALLED REPAIR PER SRM ON PEMCO NR 3872N 00597.SDR UALA2012010300010Floorbeam · corrodedCORROSION ON FLOORBEAM UPPER CAP AT BS 1196.66 ACROSS ENTIRE BEAM IN REAR CARGO.SDR UALA2012010300014Floorbeam · corrodedPASSENGER CABIN FLOOR STRUCTURE AT BS 287 FROM RBL 40 TO RBL 73 HAS CORRODED FLOORBEAM. MAJOR REPAIR ACCOMPLISHED. RPLC'D T-CHORD, T-CAP, ANGLES AND BRACKET AT STA 287, RBL 31 - RBL 82 PER SRM.SDR UALA2011122807139Skin · dentedFUSELAGE SKIN DENTED BS 440, S25 - 26R. FOUND DENT OUT OF LIMITS. CUT-OUT DAMAGED AREA, INSTALLED DOUBLER AND FILLER IAW SRM.SDR UALA2011122307078Floorbeam · corrodedCORROSION ACROSS TOP OF FLOORBEAM AT STA 1197 IN AFT CARGO COMPARTMENT. REMOVED CORROSION ON TOP OF FLOORBEAM. FOUND TO BE OUT OF LIMITS. REMOVED FLOORBEAM AND FABRICATED NEW FLOORBEAM FROM BAC 1506-3123 7075T651L IAW B767 SRM 53-60-53. ALODINED, PRIMED ANSDR UALA2011122107010Seat Track · corrodedCORROSION ON SEAT TRACK STA 795, LBL 60. MAJOR REPAIR ACCOMPLISHED: RPLC'D SEAT TRACK FROM STA 775 TO 795, LBL 60 PER SRM ON PEMCO NR 3872N00683.SDR UALA2011120706725Floorbeam · damagedFLOORBEAM AT BS 654.121 LBL 54 TO 88 HAS DRILL BIT PILOT HOLES PART WAY INTO UPPER CHORD SURFACE. MAJOR REPAIR ACCOMPLISHED. REMOVED DAMAGED FLANGE & FABRICATED REPAIR PARTS IAW B767 SRM 53-00-51. INSTALLED PARTS ON FLOORBEAM AT BS 654 LBL 54 TO LBL 88. NDSDR UALA2011120506650Intercostal · crackedCABIN FLOOR STA 334, LBL 40 INTERCOSTAL CRACKED. MAJOR REPAIR ACCOMPLISHED. FABBED AND REPLACED INTERCOSTAL PER SRM.SDR UALA2011110806089Skin · damagedAIRCRAFT HIT BY HILOADER AFT OF AFT CARGO DOOR ABOUT 10 INCHES IN FRONT OF EXTERIOR AREA LIGHT. NDT HI-FREQ EC INSP SKIN AFTER DAMAGE BLENDED. NO CRACKS FOUND. BLEND SKIN DAMAGE AT STA 1373 BTWN S27-R AND S28-R PER SRM. BLENDED OUT GOUGES AND PRIMERED DAMAGE SDR UALA2011110806090A/C Pack · malfunctionedAT GATE RT PACK INOP IN AUTO WITH APU ON WORKS IN SSBY MODE. RT TEMP INOP EICAS MSG INTERROGATED RT PACK CONTROLLER FOUND RAM OUTL ACTR FLAGGED. UNABLE TO RESET REMOVED PLUG ON RAM AIR OUTLET ACTUATOR NOW SYSTEM RESET. PACK IS WORKING NOW IN AUTO MODE BUT DSDR UALA2011102705827Limit Switch · dirtyRAM AIR TURBINE SHOWS UNLOCKED. EXTENDED RAT AND CLEANED UP LIMIT SWITCH S369. RETRACTED RAT. RAT UNLOCKED LIGHT AND EICAS MESSAGE CLEARED.SDR UALA2011102505787Pca · leakingRT ELEVATOR INBD PCA IS LEAKING A STEADY STREAM OF HYD. REMOVED PNL FOR ACCESS, PUT PNL IN AFT BULK CARGO COMPARTMENT. REPLACED RIGHT INBD PCA.SDR UALA2011101905658Circuit Breaker · faultyRUDDER RATIO LIGHT ILLUMINATED ON THE GROUND. RUDDER RATIO LIGHT CIRCUIT BREAKER RECYCLED LIGHT WENT OUT. ACCOMPLISHED BYTE TEST PER FIM 27-09-00 BLOCK 106B. FOUND PCA FAULT BALL. AFTER RESET OF PCA BALL ON BOTH LEFT AND RTB RRC ACCOMPLISHED TEST PER MM ASDR UALA2011100705434Indicator · inoperativeLEFT ENGINE VALVE ANNUNCIATOR LIGHT INOPERATIVE. REPLACED INDICATOR LIGHT ASSY. OPS CHECKED GOOD.SDR UALA2011090204716Connector · brokenLT PACK TEMP CONTROL VLV CONNECTOR BROKEN AND WIRING DISCONNECTED. CONNECTOR D676. PCN 563 -1806 AOG N3982. BY- 8256 : D676 STRAIN RELIEF BROKEN, WIRING INTACT, D678 AT OTHER END OF VLV HAS WIRING PULLED. REPLACED CONNECTOR D676, NEEDS OP CHECK, CONNECTOR DSDR UALA2011090204717Wire · damagedRIGHT PACK DOOR HINGE AREA, WIRE BUNDLE HAS DAMAGED WIRING RUNNING ALONG KEEL BEAM. FOUND WIRE W982-002-20 INSULATION DAMAGE CONDUCTOR STRAND OK, FIX INSULATION. NEED OP CHECK.SDR UALA2011083004648Door · separatedLEFT AC BAY DOOR LOST IN FLIGHT. FOUND LEFT AC BAY ACCESS DOOR NOT WITH ACFT UPON ARRIVAL IN ORD. LT PACK BAY ACCESS DOOR 4 EA HINGE ASSY REMOVED DUE TO DAMAGE. BEGAN INSTALLATION OF LT AC BAY DOOR. BEGAN INSTALLING HI-LOKS IN HINGES. REPLACED 4EA DAMAGED HINSDR UALA2011082604583Control Unit · malfunctionedFWD GALLEY HAS NO POWER. REPLACED ELCU M225, OPS CHECK OF LOAD SHED AND FWD GALLEY POWER OKAY.SDR UALA2011082204462Computer · faultyR IRS ON DC MESSAGE ON ADVISORY PAGE. REPLACED L EICAS COMPUTER PER MM AND LOADED OPC AND OPS SOFTWARE PER MM, MESSAGE CLEARED.SDR UALA2011082204461Control Unit · malfunctionedCREW REPORTS NO POWER IN FWD GALLEY. REPLACED FWD GALLEY ELCU M225 AND TESTED OKAY PER MM.SDR UALA2011082204437Receptacle · faultyIN CONDUCTING THE BUS POWER CONTROL UNIT TEST PER MM FOUND THAT AIRCRAFT WILL NOT ACCEPT EXTERNAL POWER. FOUND PIN-A OF THE EXTERNAL POWER CONNECTOR LOOSE AND THE INSULATION BETWEEN PIN-A AND PIN-B CRACKED. REPLACED EXTERNAL POWER RECEPTICAL PER MM. SEALANTSDR UALA2011082204489Battery · dischargedTOW CREW REPORTS LOW BATT VOLTAGE. REPLACED MAIN BATTERY, CHECKS GOOD.SDR UALA2011082204488Control Unit · malfunctionedUTILITY BUS WILL NOT COME ONLINE. REPLACED BUS POWER CONTROL UNIT, BUSSES NOW ON LINE.SDR UALA2011081204259Cap · missingF/O J1 & J4 WINDSHIELD TERMINAL BLOCK MISSING "HIGH VOLTAGE" CAP. FOUND BASE MISSING RETAINING RING. SPLICED IN A NEW HARNESS ASSY. TESTED WINDOW HEAT REF AMM, TESTS OKAY.SDR UALA2011080804143Oxygen Bottle · odorMID GALLEY RIGHT AISLE ELECTRICAL BURNING SMELL. SMELL GETS STRONGER THEN DISSIPATES. RAN ALL OVENS, RE-HEATERS, LIGHTS, VIDEOS, AND CHILLERS. NO BURNING SMELL NOTED. CHECKED LAV WATER HEATERS. CH'D ALL CB'S NONE TRIPPED. CHECKED CLOSET LIGHT AND OVERHEADSDR UALA2011072803881Duct · crackedFOUND RT PACK INBOARD LWR DUCT BETWEEN REHEATER AND HEAT EXCHANGER CRACKED. RIGHT PACK OUTPUT TEMP 58 DEG WILL NOT GO COLDER TEMP VALVE SHOWS 0.00 POSITION DCT PRSS 31. REPLACED DAMAGED DUCT ASSY.SDR UALA2011070603335Servo · faulty'ELEV SERVO L FAIL' MSG ON MCDP AFTER TEST NR 8. COMPLETED MM FIM 22-00-03 PG 144 MCDP TEST NR 8. TRACED FAULT TREE TO PG 146 BLOCK 210, NEED TO REPLACE LEFT ELEVATOR AUTOPILOT SERVO M21. *NOTE, RPL LEFT FCC FOR TROUBLESHOOTING PER FIM, NO HELP. RE-INSTALLSDR UALA2011060302712Power Supply · inoperativeEMERGENCY PATH LIGHTS RT AISLE L896, LT AISLE L897, AND CROSS AISLE PATH LIGHT L905 ARE INOPERATIVE. REPLACED RT AISLE PATH LIGHT L896, CHECKED OKAY. REPLACED POWER SUPPLY M1559 FOR L897 AND L905, CHECKED OKAY.SDR UALA2011051202351Starter · lowQUANTITY OF OIL DRAINED FROM NR 2 ENG STARTER IS BELOW MINIMUMS IAW MM. STARTER MUST BE CHANGED. REPLACED NR 2 ENGINE STARTER IAW MM.SDR UALA2011051002307Oil Cooler · leakingNR 1 ENG HOC. REPLACED FCOC PER MM. NO LEAKS.SDR UALA2011041501809Actuator · faultyAFTER GEAR RETRACTION WHEN HANDLE SELECTED TO OFF, LDG GEAR MONITOR EICAS MSG AND AIR NOISE AND VIB. GEAR SELECTED TO UP NOISE AND VIB CLEARED. REPLACED NOSE GEAR LOCK ACTUATOR PER MM, CYCLED GEAR AND OPS NORMAL.SDR UALA2011031501232Actuator · leakingLT ELEVATOR L ACTUATOR LEAKING. REPLACED ELEVATOR PCA PER MM, OPS NORMAL. CONFIRMED INSTALLATION OF LEFT CENTER SYSTEM ELEVATOR PCA PER MM. LINES SECURE AND ALL BOLTS TORQUED. NO LEAKS NOTED.SDR UALA2011022200904Floorboard · delaminatedAISLE FLOORBOARDS STARTING AT SEAT 1A PAST SEAT 2A DELAMINATED. AT SEAT 1A FLOORBOARD MAKES CRACKING SOUND WHEN PRESSURE APPLIED. DELAMINATED AREA EXCEEDS 3 FT IN LENGTH. REPAIR REQUIRES PICKING UP FASTENERS INBD AND OTBD OF DELAMINATION. EDGE FASTENERS ARSDR UALA2011020400618Drain · leakingFOUND HYD LEAK FROM NR1 ENG DURING WALK AROUND. FOUND LEAK FROM HYD PUMP PAD WITNESS DRAIN, CLEANED AREA DRY MOTORED ENG FOUND 1 DROP IAW 1 MIN 10 SEC LEAK WITHIN LIMITS IAW MM. HYD QTY NORMAL. ACCOMPLISHED LEAK CHECK OF NR 1 ENGINE HYD PUMP FOR LEAKS, NONE NSDR UALA2011013100501Pump · faultyRIGHT HYD EICAS, FLIGHT DIVERTED. PUMP OFF LIGHTS OUT AFTER 10 MINS METAL IN FILTERS CHANGING ENG PUMP & FILTERS. WILL RUN CHANGE FILTERS AGAIN. REPLACED EDP ON NR2 ENGINE DUE TO PUMP FAILURE, LEAKED CHECKED IAW MM, NO LEAKS NOTED.SDR UALA2011012800486Computer · malfunctionedCAPT FLT DIRECTOR DISAPPEARED WHEN CTR AUTOPILOT WAS DISCONNECTED AND NO AUTOLAND 3 APPEARED. REPLACED LT FCC REF MM, ALL CHECKS OK. PERFORMED CATIII CHECK IAW MM AND ALL OPS NORMAL. ACFT RECERTIFIED TO CATIII STATUS.SDR UALA2011012800485Actuator · leakingON ARRIVAL LT HYD QTY INDICATING 14 OPENED LT FAN COWLS TO LET HYD FLUID DRAIN OFF. UNABLE TO DETERMINE SOURCE OF LEAK, BUT SUSPECT THRUST REVERSER ACTUATOR HYD LINE. HYD LEAK COMING FROM LOWER RT NON LOCKING ACTUATOR ON NR1 ENGINE. REPLACED LT ENG RT LOWESDR UALA2010122804744Isolation Valve · stuckLEFT BLEED ISOLATION VALVE ON EICAS AND LT ON OVERHEAD PANEL APPEARS STUCK OPEN. LEFT BLEED ISOLATION VALVE REPLACED IAW AMM. OPS OK.SDR UALA2010121304549Audio Panel · faultyCAPT BOOM MIC NOT WORKING. REPLACED AUDIO SELECTOR PANEL, OPS CHECKS OKAY.SDR UALA2010102503930Priority Valve · faultyLT ENG PRV EICAS MSG PRIOR TO ENG SHUTDOWN. REPLACED PRV IAW MM, ACCOMPLISHED ENGINE RUN ALL. OPS AND INDICATION NORMAL.SDR UALA2010093003627Logic Card · faultyEMERG DOORS LIGHT ON OVERHEAD PANEL WITH LT WING SLIDE DOOR LIGHT ON EICAS. INSPECTED LT WING SLIDE INTERIOR AND EXTERIOR FOUND NO OBVIOUS IRREGULARITIES. SLIDE LIGHT IS OUT AND HAS BEEN FOR 15 PLUS MINUTES. NO HISTORY NOTED. OK FOR SERVICE. INSPECTED LEFT WSDR UALA2010091603465Valve · leakingNR 2 ENG AIR-OIL HEAT EXCHANGER VALVE LEAKING FROM CORE. REPLACED NR 2 ENG AIR OIL COOLER. OPS NORMAL.SDR UALA2010091603466Engine · malfunctionedRT ENG BLEED LGT & RT ENG HPSOV EICAS MSG & ACFT ON GND, WITH ENG BLEED SWITCH ON, & ENG RUNNING. LT & RT DUCT PSI ARE. TRIED NEW M860, NO HELP. REINSTALLED ORIGINAL M860. CIRCUIT BREAKER C1340 STILL POPS WITH HPSOV, HPSOV CONTROLLER, PRSOV DISCONNECTED. RESDR UALA2010090903337Clamp · missingRT ENG FIRE WARNING, RTFL. CAPTAIN RETURNED NR 2 THROTTLE TO IDLE POSITION BY 17,000 AND FIRE WARNING CEASED. FURTHER TEST OF FIREWARNING SYSTEM CHECKED NORMAL & ENG WAS SHUTDOWN PER CREW CHECKLIST. CREW VERIFIED NO FIRE BOTTLES WERE DISCHARGED AND NO FURTHSDR UALA2010083003207Battery Pack · inoperativeEMERG EXIT FLOOR LTS FLICKRING LT SIDE BUSINESS NEAR LAV. REPLACED BATTERY PACK IAW MM 33-51-00 DUE TO PREVIOUS HISTORY.
Back to N642UA