N196UA, cancelled Mar 17, 2014
Service difficulty reports · 106
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 = 'N196UA' AND deregistration_id = 'N196UA-2014-03-17' 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 = 'N196UA' AND deregistration_id = 'N196UA-2014-03-17' 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 2008UALA05876Battery Pack · dischargedLEFT OVERWING FWD 2 EMERGENCY LIGHT ASSY INOP. REPLACED BATTERY PACK.SDR 2008UALA05875Light · inoperativeSEAT 4A FWD EEL LIGHT INOP. RELAMPED EMERGENCY LIGHT.SDR 2008UALA05874Light · inoperativeSEAT 2F FWD EEL LIGHT INOP. RELAMPED EMERGENCY LIGHT.SDR 2008UALA04227Connector · inoperativeEMERGENCY LIGHT ROW 55 LT INOP. FOUND LOOSE CONNECTOR. RE-SECURED EEL CONNECTOR. OP CHECK NORMAL.SDR 2008UALA04231Connector · unsecureEMERGENCY LIGHT ON WALL FWD OF LAV 110 DOOR 2L INOP. RESECURED EMERGENCY LIGHT CONNECTOR. OP CHECK NORMAL.SDR 2008UALA04230Connector · unsecureEMERGENCY LIGHT ON LT WALL LAV 110 DOOR 2L INOP. *S/D* RESECURED EMERGENCY LIGHT CONNECTOR. OP CHECK NORMAL.SDR 2008UALA04229Lamp · inoperativeEMERGENCY CEILING LIGHT TOP OF STAIRS UPPER DECK INOP. RELAMPED, OP CHECK NORMAL.SDR 2008UALA04228Lamp · inoperativeEMERGENCY CEILING LIGHT ABOVE ROW 16 INOP. RELAMPED, OP CHECK NORMAL.SDR 2008UALA04226Lamp · inoperativeEMERGENCY LIGHT ROW 44LT INOP. RELAMPED, OP CHECK NORMAL.SDR 2008UALA04225Charger · inoperativeOVERWING EMERGENCY LIGHT LT 2 TOP INOP. REPLACED BATTERY CHARGER. CHECKS OKAY.SDR 2008UALA03747Lamp · inoperativeEEL STRIP AT 2A INOP. FOUND LAMP INOP. REPLACED LAMP, OP CHECKED GOOD. AC OK FOR SERVICE.SDR 2008UALA03715Smoke Goggles · damagedSMOKE GOGGLES DAMAGED OR MISSING. *S/D* SUSPECT PRE FLIGHT CHECKS. REPLACED SMOKE GOGGLES. AC OK FOR SERVICE.SDR 2008UALA03569Light · brokenSEAT 4J EMERGENCY LIGHT BROKEN. FOUND BROKEN LIGHT ASSEMBLY. REPLACED LIGHT ASSEMBLY OP CHECKED GOOD. AC OK FOR SERVICE.
SDR 2008UALA02920Girt Bar · damagedDOOR 5L, AFT LOWER GIRT BAR MECH CRANK ASSY IS SHEARED OFF. SUSPECT FAULTY GIRT BAR CRANK ASSY. REPLACED GIRT BAR CRANK ASSY OP CHECKED GOOD. AC OK FOR SERVICE.SDR 2008UALA02929Girt Bar · faultyDOOR 5L WILL NOT ARM. REPLACED AFT GIRT BAR LATCH MECHANISM CONTROL ROD BELL CRANK OP CHECKED GOOD. AC OK FOR SERVICE.SDR 2008UALA02523Connector · looseEMERGENCY EXIT LIGHTING TURNED ON MID FLIGHT ROWS 6-8. SUSPECT LOOSE CONNECTION. SECURED CONNECTION AT BATTERY PACK OP CHECK OK. AC OK FOR SERVICE.SDR 2008UALA01803Connector · separatedEEL STRIP INBOARD OF LAV 110 INOP. FOUND EEL CABLE CONNECTION SEPARATED. RECONNECTED AND OP CKD NORMALSDR 2008UALA01802Light · inoperativeFOUND SEAT 39ABC EMERGENCY FLOOR LIGHT INOP. REPLACED LIGHT ASSEMBLY OPS CHECKED GOOD. AC OK FOR SERVICE.SDR 2008UALA01801Lamp · inoperativeCEILING EMERGENCY LIGHT INOP DOOR 3R. SUPPLEMENTAL DATA UPDATE, RELAMP. OPS CHECK OKAY.SDR 2008UALA01210Connector · looseFOUND SEVERAL SEAT EEL LIGHTS LOOSE FIRST CLASS SECTION. RESECURED ALL LOOSE CONNECTIONS.SDR 2008UALA00927Light · inoperativeEMERGENCY LIGHT ROW 5F INOP. RELAMPED EMERGENCY LIGHT.SDR 2008UALA00926Connector · unsecureEMERGENCY LIGHT ROW 1J INOP. RESECURED CONNECTOR.SDR 2008UALA00925Connector · unsecureEMERGENCY LIGHT ROW 39 LT INOP. RESECURED CONNECTOR.SDR 2008UALA00924Skin · corrodedFUSELAGE INTERNAL SKIN CORRODED, BS 2080 STR 35R AT WASTE VENT OUTLET. MAJOR REPAIR ACCOMPLISHED: INSTALLED DOUBLER/TRIPLER REPAIR.SDR 2008UALA00674Bottle · low pressureCREW O2 PRESSURE 1550, SUPPLEMENTAL DATA UPDATE, SUSPECT PRE-FLIGHT CHECKS. SERVICED OXYGEN BOTTLE. AC OK FOR SERVICE.SDR 2008UALA00555Disk · leakingLOW BOTTLE. BURST DISK LEAKING. REPLACED BURST DISK.SDR 2008UALA00297Light · inoperativeEMERGENCY LIGHT AT SEATS 1A AFT, 35H, 37A & 41H ARE INOP. REPLACED LIGHT ASSEMBLY.SDR 2007UALA05056Light · inoperativeEMERGENCY LIGHTS INOP.SDR 2007UALA05055Lamp · inoperativeEMERGENCY LIGHT AFT GALLEY RT BOTTOM WALL INOP. RELAMPED.SDR 2007UALA05054Feeder Cable · inoperativeEMERGENCY LIGHT AT SIDE OF LAV 111 LT BOTTOM WALL INOP. REPLACED EEL CABLE.SDR 2007UALA05053Lamp · inoperativeEMERGENCY LIGHT ALONG UPPER DECK WALL ACROSS ROW 18 INOP. RELAMPED WALL UNIT.SDR 2007UALA04763O-Ring · leakingLEFT UPPER DECK SLIDE AFT BOTTLE PRESSURE READING 1500 PSI NOT WITHIN GREEN BAND. THE O-RING THAT SEALS THE SPOOL WAS LEAKING. REPLACED O-RING.SDR UALA2008111304567Control Unit · leakingPAX O2 LOW. RECURRED ON FLT 916-22NOV. REPLACED LEAKING PAX O2 FLOW CONTROL UNIT. LEAK FOUND ON PRESSURE LINE CONNECTED TO THERMAL COMPENSATOR AT CREW O2 BOTTLE. REPLACED VERTICAL LINE AND CONNECTING ELBOW AND SUBSEQUENT THERMAL COMPENSATOR LINE. NO FURTHSDR 2007UALA04567Oxygen System · reads lowPAX O2 LOW.
SDR 2007UALA03951Relay · faultedLOST PRIMARY FLAPS ON ALT MODE. 10-23-07 REPLACED RELAYS R7515 & R7513 IN PANEL P54 AS PER SSM 27-51-02 & 03 AND PER FIM TASK 27-51 883-8 84.
RAN FLAPS ON GROUND-NO FAULTS-OP CHECKS NORMALLY.SDR 2007UALA03903O-Ring · leakingUNWANTED FUEL TRANSFER. NR 2 MAIN TO CENTER 100LBS EVERY 4+ MINUTES. *S/D* FOUND COUPLINGS ON THE SCAVENGE SYSTEM LEAKING IN THIRD BAY, LEFT SIDE, AT THE BOTTOM. REPLACED O-RINGS. OPS CHECK AND LEAK CHECK GOOD. SUSPECT VIBRATION & MULTIPLE USE CYCLES LEDSDR 2007UALA03852Lamp · inoperativeEEL AT DOOR 1L SIDEWALL INOP. 10-19-07 RELAMPED. OP CHECKS NORMALLY.SDR 2007UALA03851Battery Pack · faultyDOOR 2L SIDEWALL EXIT SIGN INOP. 10-19-07 EXIT SIGN COMES ON AFTER REPLACEMENT OF BATTERY UNIT. OP CHECKS NORMALLY.SDR 2007UALA03850Battery Pack · faultyEEL INOP AT LAV 104 SIDEWALL AND SIDEWALL XAISLE BETWEEN DOORS 2L AND 2R. 10-19-07 EEL LIGHTS IN ALL POSITIONS COME ON AFTER REPLACEMENT OF BATTERY-POWER SUPPLY. OP CHECKS NORMALLY.SDR 2007UALA03849Power Supply · inoperativeEEL INOP ROWS 6AB-8AB. 10-19-07 REPLACED POWER SUPPLY UNIT AT DOOR 2 LEFT. OP CHECKS NORMALLY.SDR 2007UALA03848Wire · disconnectedEEL INOP ROWS 12-14 & 18. 10-19-07 FOUND CABLE DISCONNECTED. RECONNECTED. OP CHECKS NORMALLY. SUSPECT CABLE DISCONNECTED FOR CLEANING/ MTCE AND NOT RECONNECTED.SDR 2007UALA03847Connector · disconnectedEEL ADJACENT TO LAV 100 SIDEWALL & UD LAV ARE INOP. 10-19-07 FOUND EEL LAMP DISCONNECTED. RECONNECTED. OP CHECKS NORMALLY. SUSPECT CONNECTOR SNAGED ON CABIN SERVICE EQUIPMENT AND BECAME DISCONNECTED.SDR 2007UALA03846Connector · unsecureEEL INOP AT 5E AFT. 10-19-07 SECURED LAMP CONNECTOR. OP CHECKS NORMALLY.SDR 2007UALA03845Lamp · inoperativeDOOR 3L EMERGENCY FWD SILL LIGHT INOP. 10-19-07 RELAMPED. OP CHECKED OK FOR SERVICE.SDR 2007UALA03844Lamp · inoperativeEEL AT 35 HJK, 33 ABC, 4E AFT & AT 43 ABC ARE INOPERATIVE. 10-19-07 RELAMPED ALL SEAT POSITION EEL. OP CHECKS GOOD FOR SERVICE.SDR 2007UALA03277Light · inoperativeDOOR 4R FWD SILL EMERGENCY LIGHT INOPERATIVE. 08-31-07 RELAMPED. OP CHECKED OK FOR SERVICE.SDR 2007UALA03276Connector · looseEEL 33 LEFT INOP. 08-31-07 SECURED CONNECTOR TO LAMP. OP CHECKS OK FOR SERVICE.SDR 2007UALA03275Light · inoperativeEMERGENCY CEILING LIGHT INOP ROW 13. RELAMPED EMERGENCY LIGHT.SDR 2007UALA03274Light · inoperativeEEL 4J AFT & 39 LEFT ARE INOPERATIVE. RELAMPED EEL.SDR 2007UALA02674Lamp · inoperativeEMERGENCY CEILING LIGHT ABOVE ROW 48ABC INOPERATIVE. RELAMPED EMERGENCY LIGHT. OP CHECKED NORMAL.
Back to N196UA, cancelled Mar 17, 2014