N175UA, cancelled Jul 30, 2018
Service difficulty reports · 348
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 = 'N175UA' AND deregistration_id = 'N175UA-2018-07-30' 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 = 'N175UA' AND deregistration_id = 'N175UA-2018-07-30' 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 CALA2017081402691Light · inoperativeEMERGENCY LIGHT AT SEAT 54H INOPERATIVE. REPLACED SEAT MOUNTED EMERGENCY LIGHT ASSY. OPS CHECK PASSED.SDR CALA2017081402690Light · inoperativeEMERGENCY LIGHT AT SEAT 57C INOPERATIVE. REPLACED THE SEAT MOUNTED EMERGENCY LIGHT ASSY. OPS CHECK PASSED.SDR CALA2017081402689Connector · looseEMERGENCY LIGHT AT SEAT 47H INOPERATIVE. SECURED THE CONNECTOR. OPS CHECKED PASSED.SDR CALA2017060501693Lamp · inoperativeEMERGENCY LIGHT AT LAV 104, INOPERATIVE. REPLACED THE LAMP. OPS NORMAL.SDR CALA2017052601578Oven · smokeLAVATORIES 100 AND 101, SMOKE ALARMS SOUNDED MULTIPLE TIMES DURING FLIGHT. LAVATORIES ARE IN CLOSE PROXIMITY TO THE FIRST CLASS GALLEY, SUSPECT SMOKE WAS EMITTED FROM ONE OF THE OVENS. BOTH LAVATORY SMOKE DETECTORS WERE SOUNDING. PERFORMED THE SMOKE DETECTOR SDR CALA2017051901497Light · inoperativeOPERATIONAL TEST FOUND G5 LT EMER LIGHT INOP. REPLACED G5 L EMER LIGHT AND CABLE ASSY AND OPERATION TEST C/O FOUND NORMAL AS PER AMM 33-51-12-422-005-002 REV 87.SDR CALA2017050501271Light · brokenEEL LIGHT ON END BAY OF SEAT 42C BROKEN AND MISSING. REPLACED EEL LIGHT CKS GOOD INSPECTED SAFETY, SECURITY AND OPERATION CHKS GOOD.SDR CALA2017042801140Control Panel · faultyALTITUDE SELECTOR KNOB INOP. UNABLE TO CHANGE ALTITUDE FROM 3190 0. NON-RVSM COMPLIANT FOR FORIEGN AIRSPACE. REPLACED MCP REF IPC 22-11-02-01. MODE CONTROL PANEL GRND TEST PASSED REF AMM 22-10-00. ACFT RETURNED TO CAT-III STATUS REF AMM 22-10-99.SDR CALA2017041400999Light · inoperativeEMERGENCY EXIT LIGHTING ON END CAP AT SEAT 33C DOES NOT ILLUMINATE. REPLACED LIGHT STRIP OP CK OK REF AMM33-51-00SDR CALA2017031000565Power Supply · inoperativeTWO EACH EXIT SIGNS AT UPPER DECK DOORS, ONE IN CENTER CEILING FORWARD AND ONE ABOVE THE R/H DOOR STAY ON WHEN EMERGENCY LIGHT SWITCH IS MOVED FROM ON TO ARMED. FOUND POWER SUPPLY M7050 BAD. REPLACED POWER SUPPLY AND BATTERY. OPS CHECK GOOD SYSTEM OPERATES NORSDR CALA2017031000564Light · inoperativeEMERGENCY LIGHTS, LT OUTSIDE SLIDE, TWO EACH BULBS IN EACH OF AFT TWO FIXTURES INOP. ALL BULBS CHECKED GOOD. REF WDM 33-51-42 PG 3 FOUND ALL EXTERIOR SLIDE LTS AND ALL INTERIOR LTS OP CHK OK REF AMM 33-51-00 501 BULB REPLACEMENT CORRECTED FAULT REF WDM 33-51- SDR CALA2017031000563Light · inoperativeAISLE EMERGENCY LIGHT AT SEAT 47H INOP. RPL EMERGENCY LT AT SEAT ISLE 47H PER AMM 33-51-00/001. OP CHK NORMAL.SDR CALA2017031000562Battery · dischargedEMERGENCY LIGHT IN CEILING OF UPPER DECK, JUST AFT OF THE AFT EMERGENCY EXIT SIGN AT THE TOP OF THE STAIRS MOMENTARILY GOES ON THEN GOES OFF AFTER EMERGENCY LIGHT SWITCH IS TURNED ON. BATT WAS REPLACED. INSTALLED LT ASSY AND CHARGED BATT PER AMM 33 -51-07-402SDR CALA2016091900658Charger · inoperativeEMERGENCY LIGHTS INOPERATIVE, UPPER DECK AFT CEILING AND FLOOR. REPLACED THE LAMPS. REPLACED THE BATTERY AND CHARGER ABOVE SEAT 16AB, REPLACED THE BATTERY IN THE CEILING BETWEEN UPPER DECK DOORS. LIGHTS CHECKED GOOD. ACCOMPLISHED IDT INSPECTION OF ON THE BSDR CALA2016060195420Light · inoperativeUPPER DECK FWD EMERGENCY EXIT LIGHT INOPERATIVE. REPAIRED THE EMERGENCY LIGHTSDR CALA2016052795419Light · missingPER A CHECK, SEAT 19HJK, EMER EXIT LIGHT STRIP MISSING. REPLACED EMER EXIT LIGHT STRIP AT SEAT 19HJK. OPERATIONS CHECKED OK.SDR CALA2016052795418Connector · disconnectedPER A CHECK, SEAT 49HJK EMER EXIT LIGHT STRIP INOPERATIVE. FOUND CONNECTOR ON EMER EXIT LIGHT STRIP DISCONNECTED UNDER SEAT AT 49HJK, SECURE. OPERATIONS CHECKED OK.SDR CALA2016052795417Connector · loosePER A CHECK, SEAT 45ABC EMER EXIT LIGHT STRIP INOPERATIVE. FOUND LOOSE CONNECTOR ON EMER EXIT LIGHT STRIP UNDER SEAT 45ABC. OPERATIONS CHECKED OK.SDR CALA2016052795416Light · inoperativePER A CHECK, DOOR 1L SLIDE LIGHT INOPERATIVE. REPLACED SLIDE LIGHT ASSEMBLY AT DOOR 1L. OPERATIONS CHECKED OK.SDR CALA2016041895275Light · inoperativeDOOR 2 RT CTR GALLEY FLOOR, SINGLE EMER EXIT LIGHT INOPERATIVE. RELAMPED, OPERATIONS CHECKED OK.SDR CALA2016030395203Skin · corrodedEXTERNAL FUSELAGE BELLY SKIN AT BS 770 FOUND CORRODED, BETWEEN STRINGER 46R - 47R. REMOVED DAMAGE, FABRICATED & INSTALLED EXTERNAL DOUBLER REPAIR IAW ECRA 5330-05547.SDR CALA2016022995195Doubler · crackedNUMBER 1 ENG RT 452ER CUT OUT SURROUND SKIN FOUND REPAIR DOUBLER CRACKED AT NAC 228. REPAIRED IAW ECRA 5430-02069.SDR CALA2016022995194Support · crackedBS 2598, LT FRAME SUPPORT, 65B02508-3 WAS FOUND CRACKED FROM A FASTENER HOLE. CRACK EXISTS IN FRAME SUPPORT ONLY. REMOVE CRACK & FABRICATED & INSTALLED DOUBLERS & FILLER REPAIR IAW ECRA 5310-06753.SDR CALA2016022995193Skin · damagedPITTING ON FUSELAGE EXTERNAL BELLY SKIN AT BS 740 - 840, STRINGER 44L - 44R. REPAIRED IAW ECRA 5330-05547.SDR CALA2016022995192Skin · corrodedCORROSION ON FWD CARGO STATION 822, STRINGER 47L - 47R, INTERIOR SKIN. REPAIRED IAW ECRA 5330-0554 7.SDR CALA2016021995117Wire · brokenLEFT NR 3 DOOR LAVATORY, EMER LIGHT CABLE IS BROKEN. WIRE IS PART OF LIGHT ASSEMBLY PN 8054-1. REPLACED LIGHT ASSEMBLY PN 8054-1 IAW AMM 33-31-12.SDR CALA2016021995116Wire · brokenUPPER DECK STAIR EMER LIGHT CABLE BROKEN. INSTALLED NEW WIRE, PN 5919-1, IAW SWPM 20-10-11, AMM 33-51-00 & AMM 33-51-12.SDR CALA2016020995098Door Sill · crackedMAIN DECK L1 MED, UPPER SILL WEB STATION 460, FOUND CRACK, AD 2012-22 -03. REPAIRED IAW ECRA 5310-06747.SDR CALA2016020995097Door Sill · crackedMAIN DECK RT NR 1 MED, UPPER SILL WEB STATION 460, FOUND CRACK, AD 201 2-22-03. REPAIRED AC IAW ECRA 5310-06747.SDR CALA2015121494893Connector · disconnectedSEAT 50C EMER EXIT LIGHT INOPERATIVE. FOUND THE CONNECTOR DISCONNECTED. CONNECTED & SECURED. OPERATIONS CHECKED OK.SDR CALA2015121494892Connector · disconnectedSEAT 19H, EMER EXIT LIGHT INOPERATIVE. FOUND THE CONNECTOR DISCONNECTED. CONNECTED & SECURED. OPERATIONS CHECKED OK.SDR CALA2015091894374Connector · unsecureSEAT 40H EMERGENCY EXIT LIGHT INOPERATIVE. SECURED LIGHT ASSEMBLY CONNECTOR. OPERATIONS CHECKED OK.SDR CALA2015050693663Connector · looseEMERGENCY PATH LIGHT AT SEAT ROW 25H INOPERATIVE. SECURED LOOSE CONNECTOR AT ROW 25H. PERFORMED OPERATIONAL CHECK IAW AMM 33-51-00.SDR CALA2015032093450Battery · dischargedUPPER DECK AFT OVERHEAD EXIT LIGHT INOPERATIVE. REPLACED THE BATTERY & POWER SUPPLY. PERFORMED INSTALLATION TEST IAW AMM 33-51-04 REV 172.SDR CALA2014102192539Light · inoperativeCABIN DR 5 CREW REST AISLE EMER LIGHT NEAR ENTRY LIGHT FOUND INOPERATIVE. REPLACED & ASSEMBLY TEST CARRIED OUT NORMAL IAW AMM 33-51-07.SDR CALA2014102192531Light · inoperativeCABIN MAIN DECK TO UPPER DECK STAIRWAY OVERHEAD EMER LIGHTS INOPERATIVE. REPLACED TWO EACH LIGHT ASSEMBLIES PN S1356B37.SDR CALA2014102192530Light · inoperativeUPPER DECK CEILING MOUNTED EMER LIGHTS INOPERATIVE AT TOP OF STAIRWAY & FLIGHT ATTENDANT SEAT. REPLACED LIGHT ASSEMBLIES PN S1356B37 CHANGE IAW AMM 33-51-07.SDR CALA2014081591993Wire · brokenEMERGENCY ESC LIGHTING INOPERATIVE AT SEAT ROWS 23, 24, 25 & 33 ABC. FOUND BROKEN WIRE AT SEAT 24ABC CONNECTOR. REPAIRED IAW SWPM 20-64-17. OPERATIONS TESTED OK IAW AMM 33-51-00-715-004 PG 503 PARAGRAPH D.SDR CALA2013121393666Light · unsecureEMERGENCY STRIP LIGHTING AT 1R HANGING OFF THE WALL. SECURED EMERGENCY LIGHT ASSEMBLY AT 1R ALL, OPERATIONS NOW NORMAL.SDR CALA2013111592950Battery Pack · dischargedAISLE EMERGENCY EXIT SIGN ATTACHED TO MONITOR INOPERATIVE AT DOOR 3 RT. ORDERED CHARGER 563-1046 & BATTERY PACK 563-1188. OVERHEAD PANEL BY 3 RT IS OPENED UP FOR ACCESS. REPLACED BATTERY PACK M7920 LOCATED AT DOOR 3RT OVER DOOR FAIRING IAW SSM33-51-02 PG 10SDR CALA2013111392901Light · looseEXIT LIGHT STRIP AT SEAT 58B TORN & LOOSE. SECURED TO SEAT, OPERATIONS CHECKED GOOD.SDR CALA2013102892442Relay · failedLAVATORY GALLEY FANS EICAS STATUS MESSAGE DISPLAYED. BOTH LAVATORY GALLEY VENT FANS FAILED OR INTERFACE FAIL, AFTER TOP OF CLIMB F340. REPLACED RELAY R8671 IAW SSM 21-26-01 PAGE 103.1. OPERATIONS CHECKED SYSTEM IAW AMM 21-26-00-501, ALL OPERATIONS NORMAL, NSDR CALA2013102492367Satcom · malfunctioned'SATCOM HIGH GAIN' EICAS STATUS MESSAGE DISPLAYED. SATCOM HIGH GAIN ANTENNAE SUBSYSTEM FAILURE. DEFERRED IAW SAMC. SATCOM SYSTEM EICAS MESSAGE DISPLAYED, SATCOM SYSTEM IS INOPERATIVE. HF & IRIDIUM OK.SDR CALA2013102392327Ballast · faultyON CM CHECK FOUND SEAT 6K FWD SIDEWALL LIGHT NOT ILLUMINATED. REPLACED BALLAST AT SEAT 6K, OPERATIONS CHECKED OKAY.SDR CALA2013102292280Structure · tornCM CHECKED GALLEY 420 FLOOR EXTRUSION LT TORN. REPLACED EXTRUSION OKAY.SDR CALA2013101592059Light · inoperativeMID GALLEY, RT SMALL INCANDESCENT LAMP INOPERATIVE. REPLACED LIGHT ASSEMBLY. OPERATIONS CHECKED OKAY.SDR CALA2013092491399Light · missing24H SEAT MOUNTED EMERGENCY EXIT LIGHT MISSING. REPLACED SEAT MOUNTED EMERGENCY EXIT LIGHT AT 24H IAW MM, OPERATIONS CHECKED OKAY.SDR CALA2013082190637Isolation Valve · faultyAPU BLEED VALVE WILL NOT OPEN. REPLACED APU BLEED ISOLATION VALVE PER MM. CHECKED OKAY.SDR UALA2013060503896Roller · crackedRAMP REPORTED THAT A CRACK AROUND ROLLER SHAFT ON VERTICAL SECTION OF ROLLER TRAY. LOCATION ZONE V IN AFT CARGO PIT, STA 1800, RBL 5.5. THE CRACK IS 1 SIDE ONLY AND DOES NOT REACH TO BASE. CRACK LENGTH IS .5", POSITION 27 AND 28 IN THE AFT PIT, SHOULD NOTSDR UALA2013041902722Amplifier · failedCREW REPORTED SATCOM HIGH AND LOW GAIN ARE BOTH INOPERATIVE. NO DATALINK AND NO VOICE AVAILABLE. REPLACED THE HIGH POWER AMPLIFIER PER AMM. ACCOMPLISHED SATCOM SYSTEM GROUND TEST PER AMM. TESTED GOOD.
Back to N175UA, cancelled Jul 30, 2018