N180UA, cancelled Jun 12, 2018
Service difficulty reports · 425
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 = 'N180UA' AND deregistration_id = 'N180UA-2018-06-12' 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 = 'N180UA' AND deregistration_id = 'N180UA-2018-06-12' 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 CALA2017100603508Light · inoperativeROW 60CB SEAT EMERGENCY LIGHT INOPERATIVE. REPLACED THE EMERGENCY LIGHT. OPS CHECKED GOOD.SDR CALA2017100603507Light · inoperativeR2 SLIDE LIGHT INOPERATIVE. REMOVED AND REPLACED R2 DOOR SLIDE LIGHT ASSY IAW AMM 33-51-06. OPS CHECKED GOOD.SDR CALA2017082802928Wire · damagedEMERGENCY EXIT LIGHT AT SEAT 57H IS INOP REF AMM 33-51-12-201. TERMINATED WIRES, OPS CHECKED GOOD.SDR CALA2017082802927Light · missingEMERGENCY EXIT LIGHT AT SEAT 52C IS MISSING AND WIRE IS EXPOSED REPLACED LAMP, OPS CHECKED GOOD REF AMM33-51-00.SDR CALA2017082802926Wire · damagedEMERGENCY EXIT LIGHT AT SEAT 19C IS INOP TERMINATED WIRES, OPS CHECKED GOOD REF AMM33-51-00.SDR CALA2017071002129Altimeter · stickingSTANDBY ALTIMETER STICKS THEN JUMPS 500FT THEN SLOWLY STOPS AT 280FT DIFFERENT FROM CAPTAIN`S ALTIMETER AT FL360. REPLACED THE STANDBY ALTIMETER INDICATOR IAW AMM 34-13-02.SDR CALA2016122101134Skin · crackedREQUEST TO ACCOMPLISH EA5331-01798 OP09 TO INSTALL SMALL REPAIR DOUBLER AT DR AFTER UPPER CORNER DUE TO FND CRACK LESS THAN 3.0 INCHES LONG. ACCOMPLISHED EA5331-01798 OP09 TO INSTALL SMALL REPAIR DOUBLER AT DOOR AFTER UPPER CORNER. DEVIATIONS ACCOMPLISHED AS PSDR CALA2016122101133Skin · crackedREQUEST TO ACCOMPLISH EA5331-01798 OP10 TO INSTALL SMALL REPAIR DOUBLER AT DOOR AFTER UPR CORNER DUE TO FND CRACK LESS THAN 3.0 INCHES LONG. ACCOMPLISHED EA5331-01798 OP10 TO INSTALL SMALL REPAIR DOUBLER AT DOOR AFTER UPPER CORNER MED R/H NO.5 DEVIATIONS ACCOMSDR CALA2016122101132Mount · corrodedNR 1 ENG AFT LWR MOUNT FND CORROSION. REPLACED NR 1 ENG AFT MOUNT PER AMM 71-21-02 REV 182.SDR CALA2016121901105Light · damaged19ABC SEAT EEL LT ASSY FOUND DAMAGED. REPLACED 19ABC SEAT EEL LT ASSY AND C/O OP CHK FOUND ''SATIS'' REF TO AMM 33-51-12 REV 182.SDR CALA2016121901104Light · damaged57HJK SEAT EMERGENCY MOUNT LT ASSY FOUND DAMAGED. REPLACED 57HJK SEAT EMERGENCY MOUNT LT ASSY AND C/O OP CHK FOUND ''SATIS'' PER AMM 33-51-12 REV 182.SDR CALA2016121901098Light · defectiveAFT CREW REST EMERGENCY LT ASSY FOUND LOW VOLTAGE. REPLACED AFT CREW REST EMERGENCY LT ASSY AND C/O OP CHK FOUND ''SATIS'' REF TO AMM 33-51-07 REV 182 AND AMM 33-51-00 REV 182.SDR CALA2016121901097Floor Support · crackedFWD CARGO FLOOR SUPPORT WEB CRACK AT STA570 RBL 45. FWD CARGO FLOOR SUPPORT WEB REPAIRED AT STA570 RBL 45 AREA AS PER ECRA 5320-02746 REV -.SDR CALA2016111400907Light · inoperativeSEAT 19, 33A, 49A EEL LIGHTS INOP. REPLACED SEAT EEL LIGHTS. OPS CK OK.SDR CALA2016111400906Sign · inoperative2L DOOR EXIT SIGN INOP. REPLACED BATTERY. OPS CK OK.SDR CALA2016111400905Light · inoperativeAFT GALLEY RIGHT WALL EMERGENCY LIGHT INOP. REPLACED EEL LIGHT. OPS CK OK.SDR CALA2016111400904Light · inoperativeAFT GALLEY EEL AISLE LIGHT INOP RELAMPED. OPS CK OK.SDR CALA2016081500534Light · malfunctionedL2 DOOR EMERGENCY EXIT LIGHT FLICKERS. OPS TEST PERFORMED IAW AMM 33-51-00, ALL LIGHTS WORKING OK, NO FAULTS DETECTED.SDR CALA2016031495217Light · inoperativeEMERGENCY EXIT LIGHT, DOWNWASH LIGHT INOPERATIVE IN STAIRWELL. RELAMPED LIGHT. OPERATIONS CHECKED GOOD.SDR CALA2016031495216Light · inoperativeEMERGENCY EXIT LIGHT, SLIDE LIGHT INOPERATIVE AT D2R. RELAMPED LIGHT. OPERATIONS CHECKED GOOD.SDR CALA2016031495215Light · inoperativeEMERGENCY EXIT LIGHT, SLIDE LIGHT INOPERATIVE AT D4L. RELAMPED LIGHT. OPERATIONS CHECKED GOOD.SDR CALA2015110694792Battery · dischargedEMERGENCY EXIT LIGHT BATTERY FOR DOOR 5R, BLUE EXIT SIGN & SEAT 54H - 60H, HALLWAY RT EMER EXIT LIGHT, NOT ENOUGH POWER. REPLACED EMER EXIT LIGHT BATTERY, BATTERY IS LOCATED BEHIND THE LAST CEILING PANEL ABOVE SEAT 60H. OPERATIONS CHECKED OK.SDR CALA2015110694787Connector · unsecureSEAT 51H - 53H EMER EXIT LIGHTS INOPERATIVE. SECURED SIDEWALL CONNECTION AT SEAT 50H. LIGHTS OPERATE NORMAL.SDR CALA2015110694786Connector · unsecureSEAT 45H - 49H EMER EXIT LIGHTS INOPERATIVE. SECURED SIDEWALL CONNECTION AT SEAT 50H, LIGHTS OPERATE NORMAL.SDR CALA2015040293500Fan · failedSTRONG ELEC ODOR IN THE UPPER CREW REST AREA. SELECTING RECIRC FAN UPPER OFF & ODOR STARTED DISSIPATING. IDENTIFIED CREW REST AREA SUPPLY FAN BAD. SYSTEMS TESTED & FAN REPLACED.SDR CALA2015020293049Battery · dischargedSEAT 33A TO 43A SEAT EMERGENCY EXIT LIGHTS DIM. REPLACED BATTERY, OPERATIONS CHECKED OK.SDR CALA2015020293048Battery · dischargedSEAT 45A TO 53A SEAT EMERGENCY EXIT LIGHT DIM. REPLACED BATTERY. OPERATIONS CHECKED OK.SDR CALA2015020293047Connector · disconnectedSEAT 30H TO 37H EMERGENCY EXIT LIGHT SEAT INOPERATIVE. SECURED DISCONNECTED CONNECTOR ON SEAT 40. OPERATIONS CHECKED OK.SDR CALA2015020293046Connector · disconnectedSEAT 39H - 43H SEAT EMERGENCY EXIT LIGHT INOPERATIVE. SECURED DISCONNECTED CONNECTOR ON SEAT 40. OPERATIONS CHECKED OK.SDR CALA2014122392854Skin · crackedNUMBER 1 STRUT TORQUE BOX SKIN AT ACCESS DOOR 452ER HAD 1 INCH CRACK AT LOWER AFT CORNER. REPAIR OF SKIN CRACK WAS ACCOMPLISHED IAW ECRA 5450-02283.SDR CALA2014122392853Fitting · crackedBS 2598 BULKHEAD RT AFT INNER CHORD SPLICE FITTING FASTENER HOLE HAD .030 INCH CRACK. FOUND DURING ACCOMPLISHMENT OF EA 5300-01642 OP12. REPAIR WAS ACCOMPLISHED IAW ECRA 5310-06333.SDR CALA2014122392852Skin · damagedRIGHT VERTICAL STAB TO FUSELAGE SKIN DOUBLER REPAIRED AT STATION 2600 - 2618 STRINGER 2R - 3R IAW SRM 53-00-01 REQUIRED. CARRY FWD FOR REPEAT INSPECTION IAW SRM 53-00-01 CAT B REPAIR.SDR CALA2014122392849Skin · damagedRIGHT VERTICAL STAB TO FUSELAGE SKIN DOUBLER REPAIRED AT STATION 2600 - 2618 STRINGER 2R - 3R IAW SRM 53-00-01 REQUIRED. THIS REPAIR IS IAW SRM 53-00-01 FIG 201 REPAIR 0NE DETAIL 3 PAGE 209. THIS REPAIR IS CAT B & REQUIRES REPEAT INSPECTION IAW TABLE 4 PAGE SDR CALA2014122392847Skin · wornRIGHT AFT VERTICAL STAB TO FUSELAGE SEAL PANEL AREA FUSELAGE SKIN WORN. REPAIRED IAW SRM 53-00-01 FIG 201 REPAIR ONE REV 91.SDR CALA2014112492731Connector · unsecureCOACH SEAT EMER EXIT LIGHT INOPERATIVE AT 39 HJK, 35ABC & 37ABC. SECURED EMER EXIT LIGHT ASSEMBLY CONNECTORS. OPERATIONS CHECKED OK.SDR CALA2014112492730Light · inoperativeTWO EACH EMER EXIT LIGHTS INOPERATIVE, WALL MOUNTED AISLE LOCATOR LIGHT AT AFT GALLEY. REPLACED ONE EMER EXIT LIGHT FWD OF GALLEY. OPERATIONS CHECKED OK.SDR CALA2014102392551Fuse · blownRIGHT WING FAIRING TWO AFT EEL INOPERATIVE. REPLACED FUSE AT M7920 POWER SUPPLY EMER LIGHTS IAW WD 33-51-41 PG 6 SHEET 1.SDR CALA2014081191930Retainer · damagedDOOR 2R GIRT BAR BRACKET RETAINER ON BOTH SIDES FOUND DAMAGED AT DEPARTURE. DOOR CLOSED WITH GIRT BAR REMOVED. SLIDE NOT SAFETY PINNED. REPLACED GIRT BAR LIFTERS & RADIUS PUSHRODS FWD & AFT IAW IPC 52-11-07-015 & RIGGED IAW AMM52-11-07 PG 511 ITEM C THRU PGSDR CALA2014081191948Connector · disconnectedPER A CHECK, SEAT SILL AT 37 LT INOPERATIVE. FOUND CONNECTOR DISCONNECTED. SECURED OPERATIONS CHECKED GOOD.SDR CALA2014081191947Power Cable · defectivePER A CHECK, AFT GALLEY EEL STRIP AT LT SIDE, TWO EACH INOPERABLE. REPLACED POWER CABLE FROM WALL. OPERATIONS CHECKED GOOD.SDR CALA2014081191945Connector · disconnectedPER A CHECK, SEAT EEL AT 25 RT INOPERATIVE. FOUND CONNECTOR TO EEL STRIP DISCONNECTED. RECONNECT, OPERATIONS CHECKED OK.SDR CALA2014081191944Connector · disconnectedPER A CHECK, SEAT EEL AT 23 RT INOPERATIVE. FOUND CONNECTOR DISCONNECTED. SECURED CONNECTOR. OPERATIONS CHECKED OK.SDR CALA2014081191943Wire · brokenPER A CHECK, SEAT EEL AT 22 RT INOPERATIVE. FOUND POWER CABLE FROM WALL HAD BROKEN WIRE. REPLACED CABLE. OPERATIONS CHECKED OK.SDR CALA2014081191942Connector · loosePER A CHECK, MID LAVATORY EEL STRIP, CTR & RT SDE INOPERATIVE. CONNECT LOOSE EEL CONNECTION. EEL IS GOOD.SDR CALA2014063091385Seal · damagedAPU DUCT LEAK EICAS STATUS MSG DISPLAYED. APU BLEED DUCT LEAK OVERHEAT. REPLACED SEALS TO DUCTING ITEM 835 IPC 36-11-55 -005 PG 44. OPERATIONS CHECKED, NO LEAKS.SDR CALA2014030390535Light · inoperativeLT CEILING EMERGENCY LIGHT ROW 6 INOPERATIVE. RELAMPED IAW MM 33-51-07- 201.SDR CALA2014030390534Light · inoperativeAFT SEAT EMERGENCY LIGHT INOPERATIVE SEAT 15AB. RELAMPED IAW MM 33-51-12- 201-C03.SDR CALA2014030390533Light · inoperativeEMERGENCY CEILING LIGHT INOPERATIVE & LENS MISSING ROW 13. RELAMPED IAW MM 33-51-07- 201 & ORDERED LIGHT ASSEMBLY 585-1836 FOR LENS.SDR CALA2014020690318Carrier Assy · unsecureEMERGENCY EXIT LIGHTS FLICKERING ENROUTE OVER EXITS 1L 1R. SECURED REMOTE EMERGENCY LIGHT CARRIER AT 1L POSITION NOW NORMAL.SDR CALA2013123094006Shield · damagedMAIN EQUIPMENT CTR DRIP SHIELD REPAIR DEVIATIONS FROM ROUTINE TASK CARD 895190303 COA 851903. MAJOR REPAIR ACCOMPLISHED IAW ECRA 2551-01151.
Back to N180UA, cancelled Jun 12, 2018