N195UA
Service difficulty reports · 98
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 = 'N195UA' 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 = 'N195UA' 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 2007UALA03030Oxygen System · faultyOXY MASK STOWAGE COMPT DEFECTIVE - 1ST OFFICER. CREW COMMENTS: TEST - RESET SWITCH DOES NOT RESET COM OR AIR ON F/O O2 COMPARTMENT. 08-31-07 REPLACED F-O'S O2 STOWAGE BOX AND CLEANED MASK AT EMERGENCY FLOW KNOB. OPS CHKS GOOD. CREW O2 BOTTLE CLOSED DURSDR 2007UALA02971Feeder Cable · shortedBEFORE DEPARTURE FOUND F-C SEATS 1A-5A, 4E, 5E EEL LIGHT INOP. AFTER TROUBLESHOOTING, FOUND SHORT IN EEL CABLE HARNESS AT SEAT 5E. REPLACED HARNESS. OP CHECKS GOOD FOR SERVICE.SDR 2007UALA02850Feeder Cable · faultyEMERGENCY LIGHT INOP, DOOR 5R CROSS AISLE. BAD RIBBON CABLE. REPLACED RIBBON CABLE. CHECKS NORMAL.SDR 2007UALA02849Light · inoperativeWALL EEL INOP, MID LAV CROSS AISLE. FOUNDED DISCONNECTED. RECONNECTED. CHECKS NORMAL.SDR 2007UALA02848Lamp · inoperativeEMERGENCY LIGHT INOPERATIVE: DOORS 2R AND 5L SLIDE ILLUM. RELAMPED. CHECKS NORMAL.SDR 2007UALA02847Lamp · inoperativeEEL INOP:SEATS 5E FWD AND 5J AFT SECTIONS. RELAMPED. CHECKS NORMAL.SDR 2007UALA02846Lamp · inoperativeCEILING EMERGENCY LIGHTS INOP AT COCKPIT, ROW 16, ROW 18 AND ROW 32. REPLACED LAMP.SDR 2007UALA02845Lamp · inoperativeEEL INOP:ROW 42 LT, REPLACED LAMP.SDR 2007UALA02844Connector · damagedWALL EEL INOP: MID GALLEY LT WALL. REPAIRED CONNECTOR.SDR 2007UALA02736Unknown · unknownGEAR DISAGREE CAUTION MESSAGE WITH GEAR DOOR ADVISORY MESSAGE & GEAR MONITOR MESSAGE DISPLAYED AFTER GEAR RETRACTION. ALL NORMAL WITH GEAR LEVER NOW IN THE UP POSITION. [08-14-07] PERFORM NLG WHEEL WELL AREA CONDITION CHECK DUE TO FOREIGN OBJECT (STOWAWAY)SDR 2007UALA02151Connector · unsecureEEL INOP, SEAT 5E BOTH SECTIONS. RESECURED CONNECTOR ON EEL LAMPS, OPS CHECK GOOD.SDR 2007UALA02150Fuse · inoperativeEMERGENCY LIGHTS INOP, RT OVERWING 2 FWD ASSEMBLIES. REPLACED FUSE FOR OVERWING ESCAPE LIGHTS. OPS CHECKS GOOD.SDR 2007UALA02149Light · inoperativeEEL INOP ROW 57HJK. REPLACED SEAT EEL LIGHT AT 57H, OPS CHECK GOOD.SDR 2007UALA02138Lamp · inoperativeEMERGENCY LIGHT INOP, DOOR 2 RIGHT SLIDE ILLUM. REPLACED LAMP.SDR 2007UALA02137Connector · unsecureWALL EEL INOP BETWEEN MID LAVS. RESECURED CONNECTOR. CHECKS OK.SDR 2007UALA01517Skin · corrodedEXTERNAL FUSELAGE SKIN CORRODED AT RIGHT WASTE VENT OUTLET APPROX BS 2080 STR 35R. [SUP 06-01-07] MAJOR REPAIR ACCOMPLISHED: CUTOUT CORROSION. INSTALLED EXTERNAL DOUBLER/TRIPLER REPAIR.SDR 2007UALA01317Light · missingEXIT PATH LIGHTING AT 4F MISSING. REPLACED EEL STRIP.SDR 2007UALA00729Lamp · inoperativeWALL EEL INOP BETWEEN MID LAVS. REPLACED LAMP, EEL OP CHECKED NORMALLY.SDR 2007UALA00728Lamp · inoperativeEMERGENCY LIGHT INOP ROW 35 ABC. REPLACED LAMP. OP CHECKED OK FOR SERVICE.SDR 2006UALA02278Wire · smokePIGTAIL P53 OVERHEATED AND BEGAN SMOKING. UNIT DISCONNECTED. REPLACED FOOD CART "PIG TAIL" AND FUNCTIONAL CKD. OK. SUSPECT PINCHING & KINKING CAUSED BROKEN CONNECTOR.SDR 2006UALA01853Fuse · inoperativeEMERGENCY LIGHTS INOP AT RIGHT OVERWING 2 EA FWD ASSYS. REPLACED FUSE, LIGHTS OPS CHECK NORMAL.SDR 2006UALA01852Lamp · burned outEEL INOP AT SEAT 46 LEFT. REPLACED LIGHT ASSY. OPS CHECKS NORMAL.SDR 2006UALA01851Lamp · burned outWALL EEL INOP AT CROSS AISLE ON FWD SIDE MID GALLEY AND RT SIDE FWD GALLEY. REPLACED LIGHT ASSY. OPS CHECKS NORMAL. REPLACED LIGHT ASSY. OPS CKS NORMAL.SDR 2006UALA01078Light · inoperativeCEILING EMERGENCY LIGHT INOP AT ROW 16 AND 17.SDR 2006UALA01077Light · inoperativeEMERGENCY EEL LIGHT INOP AT MID GALLEY WALL LEFT AISLE. REPLACED LAMP ASSY. OPS. CKS. NORMAL. [06-29-07] REPLACED LAMP ASSY. OPS. CKS. NORMAL.SDR 2006UALA01076Light · inoperativeEMERGENCY EEL LIGHT INOP AT SEAT 2J AFT, SEAT 33 ABC, SEAT 37 ABC AND SEAT 48 ABC.SDR 2006UALA00554Lamp · inoperativeEEL AT ROW 47 H,J,K INOP. REPLACED LAMP.SDR 2006UALA00553Lamp · burned outOVERWING EMERGENCY LIGHT INOP FWD ASSY LEFT SIDE.SDR 2006UALA00286Light · inoperativeEEL INOP AT SEAT 22 RT, SEAT 47HJK, SEAT 5E AFT, SEAT 5F AFT.SDR 2006UALA00285Light · inoperativeEMERGENCY LIGHT INOP, LT UD EXIT SIGN ABOVE DOOR AND AFT EXIT SIGN CEILING AISLE.SDR 2006UALA00284Light · inoperativeEMERGENCY LIGHT INOP AT DOOR 2R SLIDE AND DOOR 1L SLIDE.SDR 2006UALA00283Light · inoperativeEEL INOP, MAIN STAIRS.SDR 2006UALA00282Light · inoperativeEMERGENCY LIGHT INOP, AFT CREW REST STAIR ILLUMINATED.SDR 2005UALA01300Light · inoperativeDOOR 1 RIGHT EMERGENCY LIGHT ON BUSTLE INOP. RESECURED EMERGENCY LIGHT.SDR 2005UALA01299Connector · looseEMERGENCY EEL LIGHT AT UPPER DECK WALL ACROSS ROW 18R INOP. RESECURED EMERGENCY LIGHT CONNECTOR.SDR 2005UALA01297Connector · unsecureEMERGENCY EEL LIGHT AT SEAT ROW 56R INOP. RESECURED EEL LIGHT CONNECTOR.SDR 2005UALA01296Lamp · inoperativeFLIGHT DECK CEILING EMERGENCY LIGHT INOP. REPLACED LAMP.SDR 2005UALA01295Bulb · inoperativeRT OVERWING FAIRING EMER LT 2ND FROM AFT HAS ONE BULB INOP. REPLACED LAMP.SDR 2005UALA01148Light · inoperativeFWD GALLEY FWD RIGHT WALL MOUNTED EEL LIGHT INOP.SDR 2005UALA01147Light · inoperativeSEAT 4B LEFT HAND EEL LIGHT INOP.SDR 2004UALA00592Compressor · bird ingestionABORTED TAKEOFF AT 108 KTS DUE TO NR 2 ENG COMP STALL AT 100 KTS. DETERMINED STALL DUE TO A BIRD STRIKE.SDR 2004UALA01178Aspirator · crushedBOTH ASPIRATORS WERE CRUSHED DURING THE PACKING PROCEDURE OF THE PREVIOUS OVERHAUL. ASPIRATOR DAMAGE LIKELY CAUSED BY EXCESSIVE PRESSURE APPLIED DURING THE PREVIOUS PACKING PROCESS. NO INDICATIONS OF SHIPPING DAMAGE. BOTH ASPIRATORS WERE REPLACED.SDR 2002UALA00689Light · inoperativeCEILING EEL INOP ON CENTER AFT UPPER DECK DROP DOWN PANEL.SDR 2002UALA00688Light · inoperativeEEL STRIP AT SEATS 49ABC INOP.SDR 2002UALA00687Light · inoperativeOUTSIDE EMERGENCY LIGHT INOP, AFT LEFT HAND BULB.SDR 2002UALA00023Skin · crackedFORWARD CARGO DOOR AFT LOWER SKIN WAS CRACKED. MAJOR REPAIR WAS ACCOMPLISHED.SDR 2001UALA00026Terminal · burnedIN CRZ HAD ELEC BURNING ODOR AND VISIBLE SMOKE AROUND CAPTS SIDE OF THE COCKPIT. UNABLE TO DETERMINE SOURCE. SCHEDULED: MEL TO LAX, DIVERTED TO PAGO PAGO. *S/D* PERFORMED DETAILED VISUAL INSPECTION OF THE COCKPIT AND FOUND LOWER LEFT L1 WINDSHIELD HEAT LUGSDR 99UAL900105Switch · malfunctionedEMERGENCY LIGHTS ON WHEN SELECTED TO OFF. *S/D* RESET EMERGENCY LIGHT SWITCH AT DOOR 1L, OVERHEAD SWITCH. NOW CHECKS NORMAL.
Back to N195UA