N197UA
Service difficulty reports · 352
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 = 'N197UA' 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 = 'N197UA' 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 CALA2013080690180Engine · fodNR 4 ENGINE SUFFERED A BIRD STRIKE, RETURNED TO FIELDSDR UALA2013070204633Charger · faultyMAIN BATTERY FAILED STBY POWER TEST. WILL ONLY CHARGE FOR ABOUT 3 SECONDS. REPLACED MAIN BATTERY IAW 24-31-01. STBY POWER TESTED OK.SDR UALA2013040402253Wire · brokenUPPER EEL LIGHT ON WALL OUTSIDE LAV 101 HAS ONE BROKEN WIRE. NEEDS NEW LIGHT ASSY. REPLACED EEL LIGHT ASSY, OPS CHECKS OK.SDR UALA2013012100366B-Nut · looseBLEED FAMV ENGINE 4 CAME ON AT LVL OFF AT FL 330. FOUND B-NUT LEAKING AT FAN AIR VALVE MUSCLE AIR CONNECTION. REPLACED MUSCLE AIR LINE AND TEMP SENSE LINE. BACKED OFF B-NUT AND SAW METALLIC PARTICLES. STEM FITTING LOOKED OK, LOOSENED ADJ LINE STAND OFFS. HSDR UALA2012111906660Fuel Sys · leakingFUEL LEAKING FROM NR 3 ENGINE DRAIN SYSTEM. FOUND FUEL LEAKING FROM DRAIN NR 4. RAN ENGINE FOR FIVE MINUTES. NO LEAKS DURING RUN OR AFTER ENGINE SHUTDOWN.SDR UALA2012111206497Panel · crackedWING PANEL JUST OUTBOARD OF THE NR 1 DRYBAY PANEL HAS A 6 INCH CRACK ACROSS THE TOP, RUNNING FWD TO AFT, AT APPROX THE MIDDLE OF THE PANEL. REPAIRED PANEL PER SRM.SDR UALA2012101805975Cylinder · leakingNOSE GEAR COMPLETELY FLAT UPON ARRIVAL AT GATE WITH EVIDENCE OF FLUID LEAKAGE ON LOWER PART OF STRUT ASSY. FOUND UPPER CAM LOCK HEAD BROKEN OFF, DAMAGE TO UPPER CAM AND STRUT. REPLACED INNER STRUT CYLINDER WITH NEW UNIT FROM BOEING. LEAK CAUSED BY UPPER CAM KSDR UALA2012100905733Light · missingTHE 24C & 56C SEAT MOUNTED EEL MISSING. REPLACED SEAT MOUNTED EEL, OPS CHECKED OK.SDR UALA2012100205589Cotter Pin · missingRIGHT WING INBOARD MIDFLAP INBOARD CARRIAGE SPINDLE AFT ATTACH LINK LOWER CASTLELATED NUT IS MISSING COTTER KEY. FOUND WASHER MS15795-828 NOT INSTALLED AS CALLED OUT PER AMM. TORQUED CASTLE NUT AND INSTALLED COTTER PIN PER AMM. RIGHT WING INBOARD MIDFLAP, ISDR UALA2012093005545Light · inoperativeEMERGENCY LIGHT INOP: DOOR 5R AFT SILL. RELAMPED, OP CHECK NORMAL.SDR UALA2012093005544Light · inoperativeEMERGENCY LIGHT INOP: FWD GLY RIGHT SIDE OF WALL. RELAMPED, OP CHECK NORMAL.SDR UALA2012093005543Charger · inoperativeEMERGENCY LIGHTS INOP: RIGHT OVERWING 2 FORWARD ASSYS, TOP. REPLACED BATTERY CHARGER ASSY, OP CHECK NORMAL.SDR UALA2012090404966Skin · corrodedLEFT LAV TANK EXHAUST VENT CUTOUT SKIN IS CORRODED AND CRACKED APPROX .5 INCH LOWER EDGE. GAINED ACCESS, REMOVED VENT NOZZLE ASSY, STARTED REMOVING INNER DOUBLER REF AVO 1408. REMOVED DAMAGE, MANUFACTURED REPAIR PIECES, STARTED INSTALLATION. REPAIRED LEFT LSDR UALA2012082004618Fuse · faultyRIGHT OVERWING EMERGENCY LIGHT INOPERATIVE. REPLACED FUSE IN POWER SUPPLY, OPS CHECKED OKAY.SDR UALA2012082004617Feeder Cable · damagedEMERGENCY LIGHT ALONG STAIRS UPPER DECK INOPERATIVE. REPLACED EMERGENCY LIGHT CABLE, OPS CHECKED GOOD.SDR UALA2012082004615Light · inoperativeL4 DOOR FWD EMERGENCY EXIT SIGN INOPERATIVE. SECURED EMERGENCY LIGHT, OP CHECKED NORMAL.SDR UALA2012082004614Connector · unsecureEMERGENCY LIGHT INOPERATIVE. SECURED CONNECTOR, OP CHECKED NORMAL.SDR UALA2012082004613Connector · unsecureEMERGENCY LIGHT ROW 45 THRU 53 LT INOPERATIVE. SECURED EMERGENCY LIGHT CONNECTOR. OPS CHECKED NORMAL.SDR UALA2012082004612Lamp · inoperativeEMERGENCY LIGHT ALONG R2 DOOR, TWO LIGHTS INOPERATIVE. REPLACED LAMPS, OP CHECKED NORMAL.SDR UALA2012080704257Controller · faultyREPLACED NR 1 LAC DUE TO MULTIPLE INBOUND FAULTS DETECTED IAW MM 23-30-04.SDR UALA2012073104121Warning Message · false indication'PACK 1' EICAS STATUS MESSAGE DISPLAYED. NEITHER PTC IN CONTROL OF PACK 1 OR PACK COMPONENT FAILURE OR OVERHEAT OR PACK TRIP DUE TO OVERHEAT OR OUT OF SEQUENCE. THE NR 1 PACK FCV IS SECURED CLOSED. PACK IS INOP EICAS MSG: TURB BYPASS VALVE -1 WIRING FAIL MSSDR UALA2012080104139Warning Message · false indicationNR 1 PACK EICAS STATUS MESSAGE DISPLAYED. NEITHER PAC TEMP CONTROLLERS IN CONTROL OF PACK 1 OR PACK COMPONENT FAILURE OR OVERHEAT OR PACK TRIP DUE TO OVERHEAT OR OUT OF SEQUENCE. THE NR 1 PACK FLOW CONTROL VALVE IS SECURED CLOSED. PACK IS INOPERATIVE EICAS MSDR UALA2012073004114Controller · inoperativeFLIGHT ATTENDANT UPPER DECK LIGHTING CONTROL PANEL INOPERATIVE, REPLACED NR 4 LAC AND RELOADED ACCESS SOFTWARE.SDR UALA2012060303057Door · damagedNR 4 ENG THRUST REVERSER DEACTIVATION DOOR HAS CRACK COMING FROM UPPER SCREW HOLE. NO CRACK FOUND, UPPER FASTENER HOLE WORN AND OVERSIZED. INSTALLED FLUSH WASHER IN DAMAGED HOLE. REINSTALLED PANEL.SDR UALA2012053103032Lamp · inoperativeEMERGENCY ESCAPE PATH LIGHT AT SEAT 54G IS INOPERATIVE. REPLACED LAMP, CHECKED GOOD.SDR UALA2012052702943Sign · inoperative4 RT MED AFT EMERGENCY SIGN LIGHT INOPERATIVE. REPLACED SIGN, OPS CHECKED OK.SDR UALA2012052702942Feeder Cable · saturatedBUSINESS CLASS GALLEY WALL EMERGENCY LIGHT INOPERATIVE. SUPPLEMENTAL DATA UPDATE, REPLACED EMERGENCY LIGHT FEEDER ON ACCOUNT OF WATER DAMAGE.SDR UALA2012052702941Connector · looseFWD GALLEY RT WALL EMERGENCY LIGHT INOPERATIVE. SUPPLEMENTAL DATA UPDATE, FOUND LOOSE CONNECTOR AT LIGHT ASSY.SDR UALA2012052402916Sign · inoperativeEMERGENCY SIGN INOPERATIVE. REPLACED SIGN OPS CHECKED OK.SDR UALA2012052402915Feeder Cable · shortedEMERGENCY LIGHT INOPERATIVE. REPLACED WATER DAMAGED FEEDER CABLE.SDR UALA2012052402914Connector · looseFWD GALLEY EMERGENCY LIGHT INOPERATIVE. FOUND LOOSE CONNECTOR .SDR UALA2012052302896Connector · looseFWD GALLEY EMERGENCY LIGHT INOPERATIVE. FOUND LOOSE CONNECTOR AT LIGHT ASSY.SDR UALA2012052302895Feeder Cable · shortedEMERGENCY LIGHTS INOPERATIVE BETWEEN L4 AND L5 DOORS. REPLACED FEEDER CABLE DAMAGED BY WATER ON FLOOR.SDR UALA2012051002726Seal · leakingWHILE ACCOMPLISHING ENG CK 13 PER FIM71-08 FAULT TREES ON NR 4 ENGINE, FOUND EXCESSIVE AMOUNT OF OIL COMING OUT OF OVERBOARD BREATHER. COWLING IS COVERED WITH OIL AND FOUND OIL PUDDLING INSIDE COWLING DIRECTLY BELOW BREATHER. NEED TO ACCOMPLISH PARA (14) (B)SDR UALA2012042002395Slide · unwanted deployR1 DOOR SLIDE DEPLOYED. INSTALLED DOOR LINER, INSTALLED RT ASST BOTTLE.SDR UALA2012042002394Slide · unwanted deployUPPER DECK SLIDE DEPLOYED. REPLACED SLIDE ASSY.SDR UALA2012040502111Blade · damagedNR 4 ENG VIBES, FLIGHT DIVERTED. REPLACED BLADE SETS 8,27 AND 15,34 PER MM.SDR UALA2012040202036Lamp · inoperativeEMERGENCY OVERHEAD LIGHTS INOPERATIVE. RELAMPED, OPS CHECKED GOOD.SDR UALA2012040202026Power Supply · inoperativeRIGHT OVERWING FWD LIGHTS INOPERATIVE. REPLACED BATTERY POWER SUPPLY.SDR UALA2012040202025Feeder Cable · corrodedEMERGENCY LIGHTS AT SEATS 45-50 INOPERATIVE. REPAIRED WET AND CORRODED EMERGENCY LIGHT FEEDER CABLE AT AFT GALLEY BY DOOR 5.SDR UALA2012040202024Lamp · inoperativeENTRANCE LIGHTS BY STAIRS INOPERATIVE. RELAMPED, OPS NORMAL.SDR UALA2012040202022Connector · inoperativeEMERGENCY LIGHTS AT SEAT 40H INOPERATIVE. SECURED CONNECTOR, OPS CHECKED NORMAL.SDR UALA2012040202021Lamp · inoperativeEMERGENCY LIGHTS AT DOOR 5R FWD SEAL INOPERATIVE. RELAMPED, OPS NORMAL.SDR UALA2012040202023Lamp · inoperativeEMERGENCY LIGHT AT CEILING 15 INOPERATIVE. RELAMPED, OPS NORMAL.SDR UALA2012032801946Light · malfunctionedEMERGENCY LIGHT INOPERATIVE AT 37C. THE EMERGENCY LIGHT CHECKED, BACK TO NORMAL.SDR UALA2012032601884Power Supply · faultyEMERGENCY EXIT SIGN ABOVE DOOR FAIRING AT 2R IS BLINKING. REPLACED POWER SUPPLY & TESTED OKAY USING EMERGENCY LIGHT SW AT DOOR 1L.SDR UALA2012031901747Light · faultyEEL LTS AT DOOR 1R & 2R FLASHED AFTER TAKEOFF LATER DURING FLIGHT LTS GOT DIMMER AND FLASHED LESS FREQUENTLY REPEAT PROBLEM. REPLACED DOOR 1 RIGHT EMERGENCY LIGHT ASSY PER MM. RELAMPED DOOR 2 RIGHT. CHECKS NORMAL.SDR UALA2012020200643Light · inoperativeEMERGENCY EXIT LIGHT INOP CEILING ROW 20 LEFT. REPLACED LAMP.SDR UALA2012020200641Connector · unsecureEMERGENCY EXIT EEL LIGHT INOP SEAT ROW 23 LEFT. SECURED CONNECTOR, OPS CHECKS NORMAL.SDR UALA2012020200647Connector · unsecureEMERGENCY EXIT EEL LIGHT INOP SEAT ROW 45 RIGHT. SECURED LOOSE CONNECTOR.
Back to N197UA