N220UA
Service difficulty reports · 172
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 = 'N220UA' 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 = 'N220UA' 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 CALA2013110692689Transmitter · faultyWX RADAR FAIL MESSAGE BOTH LT & RT. WINDSHEAR FAIL ALSO DISPLAYED ON EICAS. WEATHER MESSAGE CONTINUED INTERMITTENTLY FAILING BOTH SIDES. SEE PTT SEQ 765001, WX TRANSMITTER REPLACED & OPERATIONS CHECKED GOOD. ANTENNA DRIVE UNIT & SCANNER REPLACED, OPERATIONSDR CALA2013110692688Transceiver · inoperativeWX RADAR INOPERATIVE ON LT & RT SYSTEMS. REPLACED LT WX RADAR TRANSCEIVER, OPERATIONS CHECKED NORMAL.SDR CALA2013101792146Actuator · faultyEICAS MESSAGE LT SPAR VLV. REPLACED ACTUATOR, MESSAGE IS GONE. OPERATIONS CHECKED NORMAL.SDR CALA2013101191983Igniter · failedENG IGNITOR R1 RT ENG FAILED TO IGNITE USING IGNITOR 1.SDR CALA2013092391355Skin Panel · delaminatedLT WING LE PANEL 511KB OUTER SKIN LIFTING AWAY FROM CORE OF PANEL 6 INCHES LONG 1 INCH IN WIDTH. R & R THE DELAMINATED PANEL 511KB ON LT WING LE IAW AMM.SDR CALA2013081990566Battery · inoperativeMAIN ACFT BATTERY DEAD. REPLACED MAIN BATTERY IAW MM.SDR CALA2013081490443Seal · missingLEFT WING FLAPERON OTBD UPPER SEAL HAS APPROX 4 FT OF SEAL MISSING. REPLACED SEAL.SDR CALA2013081390405Seal · missingLT WING FLAPERON OTBD UPPER SEAL HAS APPROX 4 FT OF SEAL MISSING. REPLACED SEAL.SDR UALA2013071604986Valve · faultedLOW WATER PRESSURE THROUGH OUT ACFT ON DEPARTURE. FOUND SYS OVERFILLED. DRAINED, NO HELP. FOUND PRESELECT OVERFILL VALVE AT FAULT, MANUALLY ACTUATED CLOSED SYS, PRESSURE RESTORED. PREVIOUS HISTORY NEEDS NEW VALVE. REPLACED PRESSURE RELIEF VALVE IAW AMM ASDR UALA2013071504913Valve · malfunctionedNO WATER PRESSURE ALL AREAS. FOUND WATER FILL SELECT VALVE NOT FULLY CLOSED. CYCLED VALVE TO CLOSED POSITION, WATER PRESSURE NOW OK.SDR UALA2013060503905Display · failedFIRST OFFICER`S OTBD DISPLAY SCREEN BLACKED OUT, HAS BLACK AND RED STRIPES. TO ALTERNATE DISPLAY CONTROL DISPLAY CAME BACK FOR A MINUTE THEN BLACK AGAIN. RT OTBD DISPLAY BLANK WITH MESSAGE 31-80162. REPLACED RT OTBD DISPLAY UNIT IAW MM. INSTALLATION TEST COSDR UALA2013052803673Controller · failedRT ENGINE BLEED FAN AIR MODULATING VALVE FAILED OPEN OR CLOSED, OR RT AIR SUPPLY AND CABIN PRESSURE CONTROLLER FAILED. REPLACED THE RT ASCPC IAW MM. REACTIVATED FAMV TEST NORMAL. NO FAULTS.SDR UALA2013051503368Cooling Fins · brokenNR 2 ENGINE STARTER COOLING FINS ON REAR OF STARTER ARE BROKEN. ONE AFT COOLING FIN AT APPROX 3 O'CLOCK POSITION IS CRACKED AT RELIEF HOLE. REPLACED, SERVICED AND OPS CHECKED.SDR UALA2013032001708Actuator · failedLEFT ENGINE HIGH PRESSURE TURBINE CASE COOLING ACTUATOR IS STUCK OR REVERTED TO ITS FAIL/SAFE POSITION. REPLACED NR 1 ENGINE TCC ACTUATOR. RECONNECTED AND RIGGED TCC CONTROL. REPINNED CONNECTOR DM75004 TO NORMAL POSITION. PASSED GROUND TEST 15 AND 3.SDR UALA2013031101437Valve · faultyDURING REFUELING BOTH WING TANKS INBD VALVES AND CENTER TANK LEFT VALVE WOULDN'T OPEN. DEFERRED CENTER LEFT REFUEL VALVE. APPLIED STICKER. REFER LOG 3 AND LOG 4 FOR LEFT WING INBD VLV AND RIGHT WING INBD VLV RESPECTIVELY.SDR UALA2013020400667Heat Exchanger · crackedNR 2 ENGINE HEAT EXCHANGER CRACKED. REMOVED NUMBER 2 ENGINE PRECOOLER PER AMM. READY FOR INSTALL. ACCOMPLISHED INSTALLATION OF NR 2 ENGINE PRECOOLER PER AMM UP TO STEP G ON PAGE 41 6.SDR UALA2013011100192Relay · faultedRIGHT FUEL CUTOFF SWITCH DOES NOT TRANSMITT 'OFF' TO LT AIMS. REPLACED RELAY K26206 IN P210 PANEL REF WDM 76-21-12 AND IPC 24-09-01. RIGHT ENGINE FUEL SPAR VALVE OPERATES NORMALLY.SDR UALA2013011100191Switch · failedF/O PITCH TRIM INTERMITTENT IN DOWN POSITION. CAPTAIN`S PITCH TRIM SWITCH AND ALTERNATE PITCH TRIM LEVER CONFIRMED OPERATIONAL. REPLACED PITCH TRIM SWITCH F/O SIDE CONTROL WHEEL.SDR UALA2013010900132Relay · unsecureRIGHT ENGINE SPAR VALVE WILL NOT CLOSE WHEN FUEL LEVER IS IN CUTOFF POSITION. RESEATED RELAY K76202 AND K76206 ON P210. SPAR VALVE, OPS CHECKED OKAY.SDR UALA2012121407215Actuator · faulty"TURB CASE COOL HPT L". REMOVED AND REPLACED NUMBER 1 ENGINE TCC ACTUATOR PER MM, HPT CABLE PER MM &0 HPT VALVE PER MM. CREATED SMC ITEM FOR RIG CHECK OF THE NR 1 ENGINE TCC.SDR UALA2012121207183Valve · obstructedLEFT ENGINE TVBC AIR SHUTOFF VALVE HAS PIN DEPRESSED. TOOK OFF COVER AND FOUND PART OF SCREW IN VALVE NEED TO REPLACE VALVE. REF IPC 75-25-00A-003 PCN 645-1814. REMOVED & PARTIALLY INSTALLED TCVB VALVE NR 1 ENGINE PER MM. CONTINUED INSTALLATION OF VALVE THSDR UALA2012111406545Sealant · inadequateNOISE-SQUEAL AT DOOR 4L. REMOVED MID AND AFT SCUFF PLATE SECTIONS AT DOOR 4L PER AMM AND CLEANED AREA. FOUND INSUFFICIENT AMOUNT OF SEALANT APPLIED. INSTALLED MID AND AFT SCUFF PLATE. NEED TO LEAK CHECK DOOR 4 LT SILL AREA WHEN SEALANT IS DRY SEALANT APPLISDR UALA2012102906221Audio Panel · faultyCAPT AUDIO PANEL, NO GREEN LIGHT ON ADF, WHEN TESTED AND SELECTED. REPLACED AUDIO PANEL PCN 583-0010 ONLINE IPC 11-31-00-0051 REF; MM 23-51-01 PG 401 OP GOOD REF; MM 23- 51-01 PG 401.SDR UALA2012102906220Rfu · malfunctionedDATALINK LOST NO DATA LINKS ESTABLISHED (HF, VHF, SATCOM MODES DATALINKS LOST) ADVISORY CREW COMMENTS: OCCURRED 10+ TIMES IN 4 HOURS OF FLIGHT. REPLACED RADIO FREQUENCY UNIT REF: FIM 23-15 TASK 802 PCN 580-9105. REF; MM 23-15-11 PG 401, OPS CHECK GOOD.SDR UALA2012090605042Acoustic Liner · damagedNR 2 ACOUSTIC LINER SEGMENT 6 O'CLOCK POSITION PREVIOUS REPAIR CHIPPING OFF. ACOUSTIC LINER TO BE REPAIRED WITHIN 50 FLT HRS PER AMM. ACCOMPLISHED NEW REPAIR OF PREVIOUS REPAIRED AREA BY REMOVING AND REPLACING ADHESIVE.SDR UALA2012082004640Actuator · leakingON WALKAROUND FOUND FUEL DRIPPING OUT OF LEFT ENGINE. MAINT REPORTED DRIPPING 40 DPM FROM TCC ACT DRAIN NR 2. TCC ACT TO BE REPLACED WITHIN 2C. REPLACED TCC ACTUATOR PER MM. OP CHECK & LEAK CHECK OKAY.SDR UALA2012080904325Hose · wornRT MAIN FWD HYD RETURN LINE COVER FRAYED-RUBBING ON GEAR STRUT DURING RET. SUPPLEMENTAL DATA UPDATE, INTERIM REPAIR PER GPM 1- 0-13-008 PG 4 ITM 3.D.6 MADE BY USING SPLITTING SHRINK TUBING AND VINYL TAPE AND SECURING WITH .040 SAFETY WIRE. REF IPC 32-41-0 02 SDR UALA2012070103501Fastener · missingNR 1 ENGINE STRUT AFT FAIRING HEAT SHIELD IS MISSING FASTENER 2 REF MT 54-UA1.SDR UALA2012051102754Valve · malfunctionedRIGHT MAIN TANK WOULD NOT ACCEPT FUEL. BOTH FUEL VALVES IN RIGHT MAIN OPERATE IN MANUAL ONLY. DEFERRED BOTH RIGHT MAIN TANK FUEL VALVES PER MEL.SDR UALA2012040602143Wire Harness · damagedRAMP COULD NOT CLOSE AFT CARGO DOOR. DOOR HAD TO BE MANUALLY CLOSED. FOUND DOOR HANDLE UNLATCH PROXIMITY SWITCH WIRES OPEN IN HINGE AREA OF HARNESS 566-1162. REPLACED HARNESS PER MM. SYSTEM OPERATED NORMAL.SDR UALA2012040302074Unknown · unknownDURING REFUELING NOTICED LEFT CTR REFUEL VLV LIGHT NOT ON AT IRP AND REFUEL FLOW REDUCED. SYSTEM OP CHECKED NORMAL. COULD NOT DUPLICATE THE PROBLEM.SDR UALA2012012500511Fastener · looseNR 1 ENG AFT STRUT LOWER FWD HEAT SHIELD SEAL HAS 4 LOOSE ATTACHMENT FASTENERS. REPLACED WITH BLIND BOLTS PER MT 54-UA1 ** MF6158 CREATED TO MONITOR **^21JUL OPB INF- :PER MT 54-UA1 INTERIM REPAIR WITH BLIND BOLTS IS ACCEPTABLE UNTIL 'C' CHECK. OPBLM TSENSDR UALA2012012400490Spar · corrodedRT WING REAR SPAR WEB CORROSION AT IRSS 340.00. MAJOR REPAIR ACCOMPLISHED: BLEND OUT REPAIR ACP IAW ECRA 5720-02228 AND 777EN-57-0274-01. PER EN, THIS REPAIR IS CLASSIFIED AS CATEGORY A AND NO SUPPLEMENTAL INSP REQUIRED. TEXT INCOMPLETE, SEE ECRA.SDR UALA2011122107045Line · leakingWATER LEAKING OUT OF BELLY DRAIN SECTION 46 AREA. FOUND WATER SUPPLY LINE LEAKING AT COUPLING. REPLACED PACKING AND SECURED COUPLING, PRESSURIZED WATER SYS, NO LEAKS.SDR UALA2011111606279Valve · faultyCOND RT TEMP SENSOR EICAS MESSAGE. REPLACED RT LOW LIMIT VALVE PER MM. OPS CHECK MAT CHECK OPS OKAY.SDR UALA2011111106172Connector · dirtySTATUS MSG COND TEMP SENSOR R 21-23402. CLN'D THE LOW LIMIT VALVE CONNECTOR, MAT TEST PASSED.SDR UALA2011110305956Light · defectiveHOT ELECTRICAL SMELL, -NO SMOKE- OBSERVED. LOWER LOBE W-LIGHT TURNED ON. SAMC TEXT: IT IS THE READING LIGHT ONLY FOR THE UPPER-AFT- MOST BUNK IN THE LOWER LOBE. NO OTHER LIGHTS ARE CREATING THE SMELL. AREA LIGHT NOT AFFECTED. RELAMPED READING LIGHT, MONSDR UALA2011103105881Relay · faultyCENTER FUEL TANK ONE REFUEL VALVE WILL NOT OPEN. CHECKED CENTER FUEL TANK LT REFUEL VALVE FAIL CLOSED. FOUND 16 VOLTS AT CONNECT OR DV28305 FOR LT CENTER TANK REFUEL VALVE. SUGGEST REPLACING LT CENTER TANK REFUEL RELAY K28316 ITEM 70 PCN (562-4147) BEHIND PSDR UALA2011102105686Switch · failedNR 2 ENGINE HAD SMOKE EMITTING FROM EXAUST PIPE AFTER SHUTDOWN. CREW HAD NO EICAS MESSAGES OR INDICATIONS THE ENGINE WAS NOT SHUT DOWN. RAMP STATED IT SOUNDED LIKE THE ENGINE TRIED TO LIGHT OFF WHILE IT WAS SMOKING. RT SPAR FUEL VALVE MESSAGE APPEARED AFTERSDR UALA2011101805641Relay · failedRIGHT ENGINE HIGH PRESSURE FUEL SHUTOFF VALVE (HPSOV) OR RIGHT SPAR FUEL VALVE POSITION DISAGREES WITH COMMANDED POSITION. RT ENG SHUTDOWN ABNORMAL AFTER FUEL CONTROL SWITCH TO OFF, FUEL FLOW VARIED. REMOVED & REPLACED MAIN FUEL PUMP FILTER. FOUND FILTER CSDR UALA2011101105492Skin · damagedSIGNS OF LIGHTNING STRIKE ON LT WING TIP UPPER AND LOWER AFT FAIRING SKIN PANEL ATTACHMENT SCREWS & REAR POSITION LIGHT LENS ASSY. REPAIRED FAIRING HOLES.SDR UALA2011092805258Receptacle · brokenINTERPHONE AT L4 DOOR INOPERATIVE. REPLACED ZMU DOWN LOAD SOFTWARE. ALSO REPLACED HANDSET, NO HELP. RECEPTACLE PIN BROKEN.SDR UALA2011090704819Screen · cloggedCREW REPORT ODOR IN CABIN AROUND ROWS 14 TO 26. ODOR DID DISSIPATE SOMEWHAT WITH ENTERTAINMENT SYSTEM UNPOWERED. PLEASE SEE HISTORY FOR THIS PROBLEM. DISCUSS WITH SAMC PRIOR TO CLEARING. SAMC TEXT: F-A REPORTS ODOR CAME BACK EVEN THOUGH SEAT POWER SWITCHED SDR UALA2011090504793Outlet · obstructedVERBAL FROM TEST FLIGHT CREW, ZONE 'E' HAS LITTLE AIRFLOW. OCCURS WHEN DEMAND TO WARM UP ZONE 'E' THE HOT AIR ODOR COMES BACK (IN FLIGHT). FOUND DEBRIS IN MIX MANIFOLD OUTLETS, CLEANED SAME.SDR UALA2011083104672Wire · contaminatedCREW INFO FOR ODOR IN 'E' SECTION OF CABIN. ODOR IS A PLASTIC BURNING SMELL. AC IN CRUISE. FLT CREW NOTED THAT AC SYSTEM HAD NORMAL INDICATIONS. NO BLEED OR ELECTRICAL ANOMALIES. IN FLIGHT CREW NOTED THAT SMELL DISSIPATED WHEN IFE SYS - VIDEO SYS OFF. TUSDR UALA2011081204262Valve · faultyBURNING PLASTIC ODOR IN CABIN AFT OF ROW 20. SUSPECT DUCT OVERHEAT IN ZONE E. ACCOMPLISHED CTC LT AND RT MAT TESTS. BOTH PASSED. RAN PACKS AND FOUND ZONE E TRIM AIR VALVE NOT OPERATING TO FULL CLOSED POSITION. DF PER MEL. PROBLEM RECURRED NEAR ROW 20. COULD NSDR UALA2011072803889Gcu · faultyLEFT ENG IDG DOES NOT ON LINE AFTER PUSH BACK. REPLACED GCU PER MM, NO INSTALLED COA BORROWED.SDR UALA2011072203734Structure · damagedNR 1 ENG LT FAN COWL HAS GROUND DAMAGE FROM O2 CART. ACCOMPLISH ENGINE AND STRUT DAMAGE CONDITIONAL INSP PER MM. NR 1 ENGINE LH FAN COWL DAMAGED DUE TO CONTACT WITH OXYGEN CART. REMOVED NR 1 ENGINE OUTBOARD FAN COWL FOR REPAIR PER AMM.SDR UALA2011071903661Cowling · damagedNR 1 ENGINE LT FAN COWL DAMAGED DUE TO CONTACT WITH OXYGEN CART. REMOVED NR 1 ENGINE OUTBD FAN COWL FOR REPAIR. REPLACED FAN COWL NR 1 ENG.SDR UALA2011071903662Eec · dentedNR 1 ENGINE EEC DENT DUE TO CONTACT OXYGEN CART. REPLACED PER AMM.
Back to N220UA