N173UA, cancelled Jan 9, 2012

Service difficulty reports · 212

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 = 'N173UA' AND deregistration_id = 'N173UA-2012-01-09'
  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.

SDR UALA2011090904877Light · inoperativeSEAT 54 EEL LIGHT INOPERATIVE. RELAMPED, CHECKS OKAY.Sep 8, 2011 · N173UA · Boeing 747422 · Emergency LightingSDR UALA2011090904876Light · inoperativeSEAT 46L EEL LIGHT INOPERATIVE. RELAMPED, CHECKS OKAY.Sep 8, 2011 · N173UA · Boeing 747422 · Emergency LightingSDR UALA2011090904875Light · inoperativeSEAT 39R EEL LIGHT INOPERATIVE. RELAMPED, CHECKS OKAY.Sep 8, 2011 · N173UA · Boeing 747422 · Emergency LightingSDR UALA2011080804151Fire Bottle · dischargedCREW REPORT: PORTABLE HALON BTL IN AFT LAV SELF DISCHARGED. REPLACED AFT CABIN HALON FIRE EXT.Aug 7, 2011 · N173UA · Boeing 747422 · Fire Bottle, PortableSDR UALA2011080304012Battery Pack · inoperativeUPPER DECK LEFT LIGHT OUT ON PRESSURE GAUGE WHEN EMERGENCY EXIT LIGHTS ON. REPLACED BATTERY PACK, LIGHTS CHECKED OK.Aug 1, 2011 · N173UA · Boeing 747422 · Emergency LightingSDR UALA2011072003693Stringer · corrodedFOUND CORROSION IN STR 51L APPROX STA 1800 TO STA 1820. MAJOR REPAIR ACCOMPLISHED: REPLACED STR 51L FROM STA 1740 TO 1960 REF SFOOV WRITE UP E9664H.Jul 20, 2011 · N173UA · Boeing 747422 · Fuselage Main, Longeron/StringerSDR UALA2011062903213Stringer · corrodedFOUND STR 51R CORRODED BETWEEN STA 1800 TO 1960. SKIN HAS BULGED SKIN AT STA 1944. REPLACED S51R. INSTALLED DOUBLER REPAIR.Jun 25, 2011 · N173UA · Boeing 747422 · Fuselage Main, Longeron/StringerSDR UALA2011062703177Skin · deterioratedLEFT WING UPPER WING PANEL AT APPROXIMATE LOCATION WS 1056 INBOARD OF NR 1 ENG HAS DETERIORATED SURFACE PROTECTION AND EXPOSED MATERIAL. REPAIRED PER SRM. REPAIR TAP CHECKED GOOD.Jun 25, 2011 · N173UA · Boeing 747422 · Wing, Plate/SkinSDR UALA2011062703176Lamp · inoperativeEMERGENCY EXIT LIGHT INOPERATIVE. RELAMPEDJun 25, 2011 · N173UA · Boeing 747422 · Emergency LightingSDR UALA2011062703175Lamp · inoperativeEMERGENCY EXIT LIGHT INOPERATIVE. RELAMPED.Jun 25, 2011 · N173UA · Boeing 747422 · Emergency LightingSDR UALA2011062703174Feeder Cable · inoperativeEMERGENCY EXIT LIGHT INOP DOOR 5 RIGHT GALLEY AREA AFT LOWER WALL. SPLICED NEW CABLE.Jun 25, 2011 · N173UA · Boeing 747422 · Emergency LightingSDR UALA2011062703173Lamp · inoperativeEMERGENCY EXIT LIGHT INOPERATIVE SEAT ROW 33 LEFT. RELAMPED.Jun 25, 2011 · N173UA · Boeing 747422 · Emergency LightingSDR UALA2011062703172Lamp · inoperativeEMERGENCY EXIT LIGHT INOPERATIVE. RELAMPED.Jun 25, 2011 · N173UA · Boeing 747422 · Emergency LightingSDR UALA2011062703171Light · missingEMERGENCY EXIT LIGHT MISSING DOOR 4 GALLEY AREA LOWER WALL CROSS AISLE. REPLACED LIGHT.Jun 25, 2011 · N173UA · Boeing 747422 · Emergency LightingSDR UALA2011062103050Tire · wornGEAR VIBRATION AT 75 KTS UNTIL ABOUT 100KTS ON TAKEOFF. SEEMS TO BE BODY OR WING NOT NOSE. FLT CREW FELT IT AND LASTED AROUND 5 SECONDS EA TIME. GOT VIB AGAIN ON LANDING PER CREW. REPLACED NR 15 & 16 MLG TIRES ON R WING GEAR FOR UNEVEN WEAR.Jun 17, 2011 · N173UA · Boeing 747422 · Tire TubeSDR UALA2011042802070Light · looseAFT GALLEY EMERGENCY EXIT LIGHT STRIP UNDER FRIG IS LOOSE. SECURED LIGHT STRIP. ALL GALLEY LIGHTS CHECKED, OPS NORMAL.Apr 27, 2011 · N173UA · Boeing 747422 · Emergency LightingSDR UALA2011041101748Fuel/Oil Cooler · leakingON ARRIVAL TO SFO FLIGHT 870-10, NR 2 ENGINE IS STILL LEAKING FUEL ONTO THE RAMP FROM UNDER COWLING. DRY MOTORED NR 2 ENGINE, FOUND IDG AIR-OIL COOLER LEAKING FROM BETWEEN HEAT EXCHANGER AND VALVE BODY AT INBOARD AREA. REMOVED IDG AIR-OIL COOLER ASSEMBLY PERApr 11, 2011 · N173UA · Boeing 747422 · Engine Fuel/Oil CoolerSDR UALA2011040401593Connector · damagedEEL SEAT 46ABC INOP. REPAIRED CONNECTOR ON EEL LIGHT, OPS NORMAL.Apr 3, 2011 · N173UA · Boeing 747422 · Light System WiringSDR UALA2011040401592Light · inoperativeLWR AISLE DOOR 2 LT INOPERATIVE. RELAMPED, OPS NORMAL.Apr 3, 2011 · N173UA · Boeing 747422 · Emergency LightingSDR UALA2011040401591Light · inoperativeLAV EEL LIGHT DOOR 3 RT INOP. REPLACED EMERGENCY LIGHT PWR STRIP ON FLOOR, OPS CHECK OKAY.Apr 3, 2011 · N173UA · Boeing 747422 · Emergency LightingSDR UALA2011021600812Charger · failedAFTER STBY BAT TEST BAT DISCHARGE MAIN EICAS MSG COMES BACK ON FOR 10 TO 15 SEC INTERMITTENT. REPLACED MAIN BATTERY CHARGER AND TESTS OK IAW MM.Feb 16, 2011 · N173UA · Boeing 747422 · Battery/Charger SystemSDR UALA2011020100556Controller · faultyLEFT WINDOW HEAT CONTROL FAILED. LT WINDOW HEAT CONTROLLER REPLACED WITH QF LOAN ITEM. MR30408 DASH 13 OFF. P-NO. ON: 2915-5 SN ON 1428. OPS CK OK.Jan 31, 2011 · N173UA · Boeing 747422 · Windshield/Door Rain/Ice RemovalSDR UALA2011012700464Battery · dischargedSTANDBY TEST FAILED. MAIN BATTERY CHARGER SHOWED ONLY 25 AMPS CHARGING. REPLACED MAIN BATTERY IAW MM24-31-01-401 & MAIN BATTERY CHARGER IAW MM. SYS NORMAL.Jan 26, 2011 · N173UA · Boeing 747422 · Battery/Charger SystemSDR UALA2011011400227Light · corrodedDOOR 4 GALLEY LWR WALL LIGHT IS FAULTY. REPLACED CORRODED POWER EEL STRIPPING.Jan 13, 2011 · N173UA · Boeing 747422 · Emergency LightingSDR UALA2011011400231Lamp · inoperativeEMERGENCY LIGHT AT 33 LEFT INOPERATIVE. REPLACED LAMP ASSY.Jan 13, 2011 · N173UA · Boeing 747422 · Emergency LightingSDR UALA2011011400230Lamp · inoperative33HJK SEAT EMERGENCY LIGHT INOPERATIVE. RELAMPED.Jan 13, 2011 · N173UA · Boeing 747422 · Emergency LightingSDR UALA2011011400229Lamp · inoperativeSEAT 45 LEFT. RELAMPED.Jan 13, 2011 · N173UA · Boeing 747422 · Emergency LightingSDR UALA2011011400228Lamp · inoperativeDOOR 4 LEFT BUSTLE. RELAMPED.Jan 13, 2011 · N173UA · Boeing 747422 · Emergency LightingSDR UALA2010123004769Light · looseEMERGENCY LIGHT STRIP ALONG LAV WALL BY DOOR 1R IS FALLING OFF THE WALL AND WIRES EXPOSED. EMERGENCY LIGHT STRIP RESECURED, OPS NORMAL.Dec 30, 2010 · N173UA · Boeing 747422 · Emergency LightingSDR UALA2010122804750Cart · failedPIG TAIL P42, INOP, HAS ELECTICAL ODOR, AND HOT TO THE TOUCH. COMPLIED WITH MEL PROC, D. CYC: TEST PASS IAW NEW GALLEY CART TESTER, SUSPECT CART WAS BAD.Dec 27, 2010 · N173UA · Boeing 747422 · Buffet/GalleysSDR UALA2010120704478Battery · failedSTANDBY TEST FAILED. MAIN BATTERY CHARGER DOES NOT CHARGE BATTERY. CHARGER & BATTERY FOUND FAULTY. REPLACED MAIN BATTERY AND MAIN BATTERY CHARGER. OPS ARE NORMAL.Dec 6, 2010 · N173UA · Boeing 747422 · Battery/Charger SystemSDR UALA2010120104419Channel · damagedNR5 LT MED SLIDE PACK BUSTLE, AFT SECURING LATCH DOES NOT SECURE IN LATCHED POSITION. LATCH REMOVED FOR REPAIR. MANUFACTURED & INSTALLED NEW CHANNEL. ACCOMPLISH RII OF DOOR 5L SLIDE ASSY DUE TO REMOVAL FOR DOOR MX. DOOR 5LT EVAC SLD INSTALLED CORRECTLY IAW Nov 30, 2010 · N173UA · Boeing 747422 · Escape SlideSDR UALA2010113004395Battery Pack · inoperativeUPPER DECK CEILING EXIT SIGN IS INOP. REPLACED EXIT BATTERY PACK, OPS CK OKAY.Nov 30, 2010 · N173UA · Boeing 747422 · Emergency LightingSDR UALA2010113004394Connector · damagedSEAT 45 ABC EMERGENCY LIGHT IS INOP. SUPPLEMENTAL DATA UPDATE, REPAIRED CONNECTOR TO EMERGENCY LIGHT UNDER SEAT, OPS CK OK.Nov 30, 2010 · N173UA · Boeing 747422 · Light System WiringSDR UALA2010113004393Lamp · inoperativeSEAT 40HJK EMERGENCY LIGHT IS INOPERATIVE. REPLACED EMERGENCY LIGHT LAMP, OPS CK OK.Nov 30, 2010 · N173UA · Boeing 747422 · Emergency LightingSDR UALA2010113004392Wire · damagedSEAT 43 ABC EMERGENCY LIGHT IS INOP. SUPPLEMENTAL DATA UPDATE, REPAIRED WIRE TO EMERGENCY LIGHT, OPS CHECK OKAY.Nov 30, 2010 · N173UA · Boeing 747422 · Light System WiringSDR UALA2010113004391Battery · dischargedUPPER DECK SEAT EMERGENCY LIGHT 14AB INOP. BATTERY CHARGED UP. TURNED ON EMERGENCY LIGHTS. CHECKS NORMAL.Nov 30, 2010 · N173UA · Boeing 747422 · Emergency LightingSDR UALA2010113004390Battery · dischargedUPPER DECK SEAT EMERGENCY LIGHTS 13AB IS INOP. BATTERY CHARGED UP. TURNED EMERGENCY LIGHTS ON. CHECKS NORMAL.Nov 30, 2010 · N173UA · Boeing 747422 · Emergency LightingSDR UALA2010111004175Girt Bar · out of positionDOOR 5 RT SIDE WILL NOT DISARM OR ARM. FOUND THAT THE FORWARD SIDE OF THE GIRT BAR HAD JUMPED OUT OF ALIGNMENT. PLACED BACK INTO ALIGNMENT, OPS NORMAL.Nov 10, 2010 · N173UA · Boeing 747422 · Emergency EquipmentSDR UALA2010110804144Light · looseEMERGENCY PATH LIGHTING AT LAV 101 IS LOOSE. SECURED LOOSE EMERGENCY PATH LIGHT AT LAV 101.Nov 8, 2010 · N173UA · Boeing 747422 · Emergency LightingSDR UALA2010100403660Fuel Tank · leakingRAMP REPORTED FUEL COMING OUT OF FWD SMALL HOLE ON APU DRAIN MASK. WHILE IN STAB COMPARTMENT, OBSERVED RUNNING FUEL LEAK (ALMOST A STEADY STREAM) FROM THE AFT LT CORNER OF CTR SECTION OF STABILIZER TANK. FUEL IS EXITING ACFT FROM FUSELAGE DRAINS AND DRAIN HOOct 3, 2010 · N173UA · Boeing 747422 · Fuel StorageSDR UALA2010091603438Light · looseEXIT PATH LIGHTING IS LOOSE AT LAV100 BY DOOR 1 LT. INTERIM REPAIRED WITH TAPE. EXIT PATH LIGHT FUNCTIONS NORMAL. ACCOMPLISHED REPAIR.Sep 14, 2010 · N173UA · Boeing 747422 · Emergency LightingSDR UALA2010082603154Valve · faultyPRESSURE CHECKED SYS AND FOUND FUEL GOING INTO 2R AND 2M WITH ALL VALVES CLOSED, SUSPECT FUEL GOING INTO 2R AND UNWANTED FUEL TRANSFERRING INTO 2M. REPLACED NR 2 RESERVE FUELING VALVE. OP CHECKED NR 2 RESERVE TANK STILL TAKING FUEL. REMOVED FUEL PANEL 545BB Aug 25, 2010 · N173UA · Boeing 747422 · Aircraft Fuel Distribution SystemSDR UALA2010082603141Battery · faultyAPU BATTERY CHARGER STATUS MSG DISPLAYED AFTER 7.5 HRS OF FLT. VOLTAGE READING 25 DCV. REPLACED APU BATTERY AND BATTERY CHARGER PER MM. REPLACED DM7432B BACKSHELL.Aug 24, 2010 · N173UA · Boeing 747422 · Battery/Charger SystemSDR UALA2010062102182Skin · delaminatedLEFT UPPER WING FIXED T/E PANEL HAS WATER INGRESS AND DELAMINATED IN 2 LOCATIONS. WATER INGESTING FOUND ON LT UPPER WING TE PANEL AT TWO LOCATIONS DIRECTLY BELOW PREVIOUS REPAIR. ONE AREA IS APPROX 10 X 6" AND THE OTHER IS ABOUT 3" DIAMETER, MARKED AREA ON LOWJun 20, 2010 · N173UA · Boeing 747422 · Wing, Plate/SkinSDR UALA2010061502106Wire · burnedFOUND VARIOUS WIRES BURNED AND DAMAGED GOING TO AFT LAV 117 I-OEU DB7506. CABIN SVC ZONE E (A10) CB ON THE P414 PANEL STILL POPS. STARTED REMOVING CLAMPS ABOVE LAV 117 CEILING PANEL TO ACCESS DAMAGED WIRES. REPLACED OEU ABOVE LAV FC3. FOUND WIRES W8851-208&Jun 15, 2010 · N173UA · Boeing 747422 · Electrical Power System WiringSDR UALA2010061502114Skin · delaminatedLT WING FIXED T/E INBD UPPER PANEL HAS A 6X10 AREA OF DELAMINATION. REMOVED TOPCOATS DOWN TOP REVIOUS REPAIRS. TAP TESTED, FOUND NO DELAMINATIONS ON UPPER OR LOWER SKINS AND ATTACHING HARDWARE SECURE. REPAIRED REF UA-EVA-73860.Jun 14, 2010 · N173UA · Boeing 747422 · Wing, Plate/SkinSDR UALA2010061402083Light · unsecureEMERGENCY LIGHT ASSY LOOSE FWD EDGE OF LAV 101 BY DOOR 1 RT. RESECURED UPPER LIGHT ASSY TO FWD EDGE, OPS CK OK.Jun 14, 2010 · N173UA · Boeing 747422 · Emergency LightingSDR UALA2010061402082Feeder Cable · saturatedFLOOR EMERG EMERGENCY LIGHT INOP, SEAT 45ABC TO SEAT 53ABC INOP LT. REMOVED WATER UNDER FLOOR MAT.Jun 14, 2010 · N173UA · Boeing 747422 · Light System WiringSDR UALA2010061402081Feeder Cable · saturatedL4 DOOR LOWER EMERGENCY LIGHTS AT GALLEY INOP. CLEANED AND REMOVED WATER UNDER FLOOR MAT.Jun 14, 2010 · N173UA · Boeing 747422 · Light System Wiring
Back to N173UA, cancelled Jan 9, 2012