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.
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
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 UALA2011090904877Light · inoperativeSEAT 54 EEL LIGHT INOPERATIVE. RELAMPED, CHECKS OKAY.SDR UALA2011090904876Light · inoperativeSEAT 46L EEL LIGHT INOPERATIVE. RELAMPED, CHECKS OKAY.SDR UALA2011090904875Light · inoperativeSEAT 39R EEL LIGHT INOPERATIVE. RELAMPED, CHECKS OKAY.SDR UALA2011080804151Fire Bottle · dischargedCREW REPORT: PORTABLE HALON BTL IN AFT LAV SELF DISCHARGED. REPLACED AFT CABIN HALON FIRE EXT.SDR UALA2011080304012Battery Pack · inoperativeUPPER DECK LEFT LIGHT OUT ON PRESSURE GAUGE WHEN EMERGENCY EXIT LIGHTS ON. REPLACED BATTERY PACK, LIGHTS CHECKED OK.SDR 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.SDR UALA2011062903213Stringer · corrodedFOUND STR 51R CORRODED BETWEEN STA 1800 TO 1960. SKIN HAS BULGED SKIN AT STA 1944. REPLACED S51R. INSTALLED DOUBLER REPAIR.SDR 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.SDR UALA2011062703176Lamp · inoperativeEMERGENCY EXIT LIGHT INOPERATIVE. RELAMPEDSDR UALA2011062703175Lamp · inoperativeEMERGENCY EXIT LIGHT INOPERATIVE. RELAMPED.SDR UALA2011062703174Feeder Cable · inoperativeEMERGENCY EXIT LIGHT INOP DOOR 5 RIGHT GALLEY AREA AFT LOWER WALL. SPLICED NEW CABLE.SDR UALA2011062703173Lamp · inoperativeEMERGENCY EXIT LIGHT INOPERATIVE SEAT ROW 33 LEFT. RELAMPED.SDR UALA2011062703172Lamp · inoperativeEMERGENCY EXIT LIGHT INOPERATIVE. RELAMPED.SDR UALA2011062703171Light · missingEMERGENCY EXIT LIGHT MISSING DOOR 4 GALLEY AREA LOWER WALL CROSS AISLE. REPLACED LIGHT.SDR 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.SDR UALA2011042802070Light · looseAFT GALLEY EMERGENCY EXIT LIGHT STRIP UNDER FRIG IS LOOSE. SECURED LIGHT STRIP. ALL GALLEY LIGHTS CHECKED, OPS NORMAL.SDR 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 PERSDR UALA2011040401593Connector · damagedEEL SEAT 46ABC INOP. REPAIRED CONNECTOR ON EEL LIGHT, OPS NORMAL.SDR UALA2011040401592Light · inoperativeLWR AISLE DOOR 2 LT INOPERATIVE. RELAMPED, OPS NORMAL.SDR UALA2011040401591Light · inoperativeLAV EEL LIGHT DOOR 3 RT INOP. REPLACED EMERGENCY LIGHT PWR STRIP ON FLOOR, OPS CHECK OKAY.SDR 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.SDR 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.SDR 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.SDR UALA2011011400227Light · corrodedDOOR 4 GALLEY LWR WALL LIGHT IS FAULTY. REPLACED CORRODED POWER EEL STRIPPING.SDR UALA2011011400231Lamp · inoperativeEMERGENCY LIGHT AT 33 LEFT INOPERATIVE. REPLACED LAMP ASSY.SDR UALA2011011400230Lamp · inoperative33HJK SEAT EMERGENCY LIGHT INOPERATIVE. RELAMPED.SDR UALA2011011400229Lamp · inoperativeSEAT 45 LEFT. RELAMPED.SDR UALA2011011400228Lamp · inoperativeDOOR 4 LEFT BUSTLE. RELAMPED.SDR UALA2010123004769Light · looseEMERGENCY LIGHT STRIP ALONG LAV WALL BY DOOR 1R IS FALLING OFF THE WALL AND WIRES EXPOSED. EMERGENCY LIGHT STRIP RESECURED, OPS NORMAL.SDR 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.SDR 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.SDR 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 SDR UALA2010113004395Battery Pack · inoperativeUPPER DECK CEILING EXIT SIGN IS INOP. REPLACED EXIT BATTERY PACK, OPS CK OKAY.SDR UALA2010113004394Connector · damagedSEAT 45 ABC EMERGENCY LIGHT IS INOP. SUPPLEMENTAL DATA UPDATE, REPAIRED CONNECTOR TO EMERGENCY LIGHT UNDER SEAT, OPS CK OK.SDR UALA2010113004393Lamp · inoperativeSEAT 40HJK EMERGENCY LIGHT IS INOPERATIVE. REPLACED EMERGENCY LIGHT LAMP, OPS CK OK.SDR UALA2010113004392Wire · damagedSEAT 43 ABC EMERGENCY LIGHT IS INOP. SUPPLEMENTAL DATA UPDATE, REPAIRED WIRE TO EMERGENCY LIGHT, OPS CHECK OKAY.SDR UALA2010113004391Battery · dischargedUPPER DECK SEAT EMERGENCY LIGHT 14AB INOP. BATTERY CHARGED UP. TURNED ON EMERGENCY LIGHTS. CHECKS NORMAL.SDR UALA2010113004390Battery · dischargedUPPER DECK SEAT EMERGENCY LIGHTS 13AB IS INOP. BATTERY CHARGED UP. TURNED EMERGENCY LIGHTS ON. CHECKS NORMAL.SDR 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.SDR UALA2010110804144Light · looseEMERGENCY PATH LIGHTING AT LAV 101 IS LOOSE. SECURED LOOSE EMERGENCY PATH LIGHT AT LAV 101.SDR 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 HOSDR UALA2010091603438Light · looseEXIT PATH LIGHTING IS LOOSE AT LAV100 BY DOOR 1 LT. INTERIM REPAIRED WITH TAPE. EXIT PATH LIGHT FUNCTIONS NORMAL. ACCOMPLISHED REPAIR.SDR 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 SDR 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.SDR 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 LOWSDR 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&SDR 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.SDR UALA2010061402083Light · unsecureEMERGENCY LIGHT ASSY LOOSE FWD EDGE OF LAV 101 BY DOOR 1 RT. RESECURED UPPER LIGHT ASSY TO FWD EDGE, OPS CK OK.SDR UALA2010061402082Feeder Cable · saturatedFLOOR EMERG EMERGENCY LIGHT INOP, SEAT 45ABC TO SEAT 53ABC INOP LT. REMOVED WATER UNDER FLOOR MAT.SDR UALA2010061402081Feeder Cable · saturatedL4 DOOR LOWER EMERGENCY LIGHTS AT GALLEY INOP. CLEANED AND REMOVED WATER UNDER FLOOR MAT.
Back to N173UA, cancelled Jan 9, 2012