N221UA
Service difficulty reports · 146
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 = 'N221UA' 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 = 'N221UA' 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 CALA2013080790211Hf Comm · malfunctionedHF RADIO - TRANSMISSION PROBLEM.SDR UALA2013062704479Data Unit · inoperativeSATCOM INOPERATIVE. REPLACED RADIO FREQUENCY UNIT (RFU) AND SATELLITE DATA UNIT (SDU). CHECKED REF AMM 23-15-00, CHECKED OK.SDR UALA2013062404358Amplifier · failedSATCOM HIGH GAIN FAILED. STATUS MESSAGE 2360121 REPLACED HIGH GAIN AMPLIFIER, ALL BITE AND VOICE TEST PASSED.SDR UALA2013060703980Apu · inoperativeAPU AT ALTITUDE, DID NOT START - COLD SOAK.SDR UALA2013060503907Control Valve · failedINTERMITTENT CARGO HEAT VALVE BULK STATUS MESSAGE. CARRIED OUT SYSTEM TEST. TEST FAILS WITH MAINT MESSAGE 21-12032. CHECKED POWER AT DV21444 PER W-D 21-44-21 AND FOUND OK. REPLACED CARGO HEAT SHUTOFF AND TEMPERATURE CONTROL VALVE OPS CHECKED NORMAL IAW MM 2SDR UALA2013052103519Boot · tornRUMBLING-VIBRATING NOISE ROW 19-24 IN THE FLOOR-UNUSUALLY LOUD. FOUND LEFT PACK FAN BYPASS CHECK VALVE FLEXIBLE ROUND CONNECTOR TORN AND PRODUCING NOISE. REPLACED FLEXIBLE ROUND CONNECTOR BOOT, ALL NOW OKAY.SDR UALA2013050903251Diplexer · malfunctionedSAT LOW GAIN. REPLACED LEFT LNA DIPLEXER M23122, OPS CHECKED NORMAL.SDR UALA2013041002440Control Unit · malfunctionedLEFT OUTBOARD REFUELING VALVE OPEN LIGHT REMAINS ON WITH VALVE SWITCH IN THE CLOSED POSITION. REPLACED THE LEFT OUTBOARD REFUEL VALVE CONTROL UNIT IAW AMM.SDR UALA2013041002438Transceiver · inoperativeRIGHT HF INOPERATIVE. RIGHT HF WILL NOT TUNE. HF HAS CONSTANT TONE. WILL NOT RECEIVE OR TRANSMIT. REPLACED RIGHT HF TRANSCEIVER, VOICE OPS AND MAT TEST NORMAL.SDR UALA2012122107351Radio · malfunctionedHF RADIO TRANSMISSION PROBLEM. RT HF WILL NOT TUNE. CYCLED RT HF THRU FREQ 3.000 TO 15.000MHS IN 1 MHZ STEPS. CHECKED THAT NORMAL TUNE TONE AND TRANSMISSION EACH STEP. CHECKED RX WITH WWV AT 5.000, 10.00 0 MHZ. RT HF CHECKS OK PER MM.SDR UALA2012122107350Control Valve · faultyPACK FCV UPPER R STATUS. STATUS MESSAGE PRIOR TO DEP VALVE LOCKED CLOSED.SDR UALA2012121907305Seal · leakingFUEL DRIPPING FROM RIGHT ENGINE STRUT DRAIN AT A RATE OF 20 DROPS PER MIN. FOUND COUPLING REF IPC 28-22-51-002A DETAIL C LEAKING. REPLACED BOTH COUPLING SEALS AND ACP LEAK CHECK REF JRH 2-2-9 PG7, NO FURTHER LEAKS NOTED.SDR UALA2012111606585Coupler · defectiveRIGHT HF COMM SYSTEM INOP. NEED TO REPLACE RIGHT HF TRANSCEIVER AND ANT COUPLER. COMPLIED WITH MEL. GOT MSG 23-51012 & 23-51002, REPLACED R TRANSCEIVER PER MM, NO HELP. SAME FAULT MSG 23-51012 WITH ALL DASHES IN THE TUNING PANEL, INSTALLED OLD TRANSCEIVER SDR UALA2012111606584Static Wick · damagedFOUND LIGHTNING DAMAGE TO WICK BASE. FOUND LIGHTNING STRIKE ON UPPER TWO INCHES OF RUDDER. TOP STATIC WICK MISSING, AND DAMAGE TO BASE. SEE TOCS. PER AMM, NEED TO ACP ITEM D(2) STATIC DISCHARGER RESISTANCE CHECK. REPLACED STATIC DISCHARGER & ASSOCIATED BASDR UALA2012110706416Skin · damagedSTATIC DISCHARGE FROM LEFT FRONT OF A-C. REMOVED 12 EACH OF FASTENERS ON LEFT NOSE EXTERNAL SKIN IN SECTION 41. PERFORMED HFEC CHECK OK. INSTALLED SOLID FASTENERS FOR PERMANENT REPAIR PER ECRA#: 5310-05609.SDR UALA2012091305192Exciter · faultyRIGHT ENGINE IGNITOR 1 INOPERATIVE. FLIGHT CREW COMPLIED WITH MEL. REPLACED R1 IGNITOR PLUG PER MM. REPLACED NR 1 EXCITER PER MM. REPLACED NR 1 IGNITOR PLUG CABLE PER MM. RAN ENGINE ON NR 1 IGNITOR ONLY, OPS CHECK GOOD.SDR UALA2012082004642Shutoff Valve · failedTRIM AIR PRSOV L LEFT TRIM AIR PRESSURE RELIEF SHUT OFF VALVE (PRSOV) FAILED. STATUS MSG-2124201 ACTIVE CL MODE MSG-2124201 ACTIVE CL MODE. REPLACED TRIM PRSOV PER MM, OPS GOOD.SDR UALA2012062203347Trim Panel · unsecureCROSS AISLE 3 LAV 134 OUTSIDE CEILING MOLDING IS FALLING DOWN, FIX AC. SECURED CEILING MOLDING.SDR UALA2012040902172Relay · faultyDUE TO PREVIOUS HISTORY OF NR 1 ENG EEC POWERED WITH ENGINE SHUT DOWN AT TERMINATION OF FLT 1757-06, REPLACED RELAY K73202 RAN ENGINE TWICE, EEC INDICATIONS NORMAL WHILE RUNNING AND GONE WHEN ENGINE STOPPED.SDR UALA2012032801958O-Ring · cutFUEL IMBALANCE, LEFT FUEL INDICATION INCREASE SLOWLY. TEST FUEL QUANTITY INDICATION SYSTEM PER AMM. NO FUEL QTY STATUS MESSAGE, NO TANK UNITS & DENSITOMETERS FAULTS IN HISTORY. CONFIRMED SLOW RATE SUGGEST REMOVING LT PUMPS FOR INSPECTION AND POSSIBLE TANK ESDR UALA2012031301655Structure · dentedCLUSTER OF 3 SMALL DENTS AT BS 681-697 BELOW STR 27R. MAJOR REPAIR ACCOMPLISHED. INSTALLED EXTERNAL DOUBLER REPAIR. HOLES WERE NOT ZERO-TIMED DUE TO POSSIBILITY OF SHORT EDGE MARGIN. THIS IS A CATEGORY "B" REPAIR.SDR UALA2012020600707Valve · faultyNR 2 ENG LWR TVBC AIR SHUTOFF VALVE INDICATOR PIN FOUND. FOUND INDICATOR PIN BROKEN. REPLACED INDICATOR PIN PCN 645-4515 AND ACP CLUNK TEST REF MM, VALVE OPERATES NORMALLY. NEEDS TO BE REPLACED WITHIN 100 FLT HRS. INSTALLED VALVE ASSY AND ALL RELATED PLUMSDR UALA2012020600706Breather Tube · dentedFOUND NR 3 BREATHER TUBE PN 50U795-01 DENTED BEYOND LIMITS. REPLACED NR 3 BREATHER TUBE AND SAFETIED.SDR UALA2012020600705Helicoil · damagedTWO OF THE 6 HELI-COILS THAT RETAIN THE LT LOWER TVBC VALVE ARE DAMAGED BEYOND USE AND WILL NEED REPLACEMENT. REPLACED 2 EACH DAMAGED HELI-COIL AT THE LT LOWER TVBC VALVE.SDR UALA2012020600704Bolt · out of positionNR 2 ENGINE LT LWR TVBC MOUNT BOLT DROPPED INSIDE ENGINE CASE. ACCOMPLISHED REMOVAL OF BOLT FROM 2 ENGINE.SDR UALA2012011300273Terminal Block · damagedMID GALLEY TERMINAL BLOCKS DAMAGED UNDER COUNTER TOP. REPLACED TERMINAL BLOCK AT 205, INSTALLED TEMPORARY TERMINAL BLOCK POS 300 TO MAKE WIRING OPERATIVE.SDR UALA2011121906931Turbine Blades · damagedNR 2 ENGINE FAILED BORESCOPE. FOUND 4 EA HPT STG 2 VANES BURNED THROUGH AND CRACK ON CONVEX SIDE. PICTURES UPLOADED TO TOMC RVI SITE. ENGINE REMOVAL IS REQUIRED. REPLACED ENGINE.SDR UALA2011121206802Apu · shutdownON DEPARTURE, APU AUTO SHUTDOWN. ACCOMPLISHED SEVERAL STARTS AT GATE, LOADED APU PNEU & ELECTRICAL, OPERATED APU FOR OVER AN HOUR, APU OPERATED NORMALLY PER JRH, NO FAULTS OR FAILURE MESSAGES.SDR UALA2011121206804Indicator · damagedAPU AUTO SHUTDOWN A SECOND TIME. OIL TEMP SENSOR WOULD NOT TIGHTEN. FOUND CRACK ON SENSOR BOSS. REPLACED FUEL INDICATION ASSY REF MM, OP'S NORMAL.SDR UALA2011120806742Actuator · failedFIRST CLASS SEAT 3A WORKS ELECTRICALLY INTO BED MODE, BUT OUT OF RIG TO RETURN LATERALLY BACK (RECLINE AND FOOTLIFT WILL RETURN ELECTRICALLY BACK TO NORMAL) CAN MANUALLY SLIDE BACK TO SITTING POSITION. REPLACED TRACKING ACTUATOR, SEAT ASSY & ACCOMPLISHED CALISDR UALA2011112706478Reservoir · dischargedWHILE REPLACING SLIDE AT DOOR 2L DOOR ASSIST BOTTLE DISCHARGED. REPLACED EMERGENCY POWER ASSIST SYSTEM RESERVOIR. REPLACED EMERGENCY POWER ASSIST BATTERY PACK ON DOOR 2L, ACCOMPLISHED EPAS TEST OKAY.SDR UALA2011111506258Starter · leakingFOUND LEAK ON APU CLUSTER. FOUND OIL LEAKING FROM ELECTRIC STARTER. 1EA 651-0308, 7514051 LOB 891-14. 1EA 6510308, 751-4051 ISSUED MM. REPLACED STARTER MOTOR PER MM, NO LEAKS NOTED.SDR UALA2011111506256Boot · tornFOUND APU SURGE BLEED FLEX BOOT TORN. REPLACED FLEX BOOT.SDR UALA2011110305960Starter · faultyAPU CONTROL STATUS MESSAGE. REPLACED ELECT STARTER, OPS CHECK NORMAL.SDR UALA2011102405736Smoke Detector · inoperativeLAV 3L SMOKE DETECTOR INOPERATIVE. REPLACED SMOKE DETECTOR. OPS CHECKED NORMAL.SDR UALA2011101005457Track · jammedDOGHOUSE 4R DOOR FOR EMERGENCY WILL NOT OPEN, HAD TO DISASSEMBLE THE COMPLETE DOGHOUSE INTERIOR. FOUND LT TRACK ASSY JAMMED. FREED SAME TRACK ASSY. PUT EVERYTHING TOGETHER. DOGHOUSE DOOR 4R, OPS CHECKS OKAY THIS TIME.SDR UALA2011092305135Pump · weakFUEL PUMP CENTER R RIGHT CENTER (OVERRIDE) FUEL PUMP SWITCHED ON AND PUMP OUTPUT PRESSURE LOW. CENTER TANK ONLY HAD 2000 LBS OF FUEL. HAD TO INCREASE CENTER FUEL LOAD TO OVER 2400LBS PER MT 28-UA8. AFTER DOING SO EVERYTHING OKAY.SDR UALA2011090904872Casting · brokenFOUND DOOR 4R GIRT BAR AFT ATTACH CASTING BROKEN. SAFTIED GIRT BAR AND CASTING TO DOOR FRAME TO CLOSE DOOR. REPLACED AFT GIRT BAR CASTING ON DOOR 4R.SDR UALA2011080404070Idg · faultyELEC GEN OFF L LEFT GENERATOR CONTROL BREAKER (GCB) OPEN OR GENERATOR CONTROL SWITCH OFF AND ENGINE NOT SHUT DOWN. ADVISORY UNABLE TO FIX. DEFERRED IAW MEL 2411B FOR REPAIR. ALSO ONCE DEFECT IS FIXED IDG OIL SHOULD BE CHANGED IAW MM. REPLACED IDG PER MM. SDR UALA2011062103053Wire Harness · corrodedSPOILER NR 4 HARNESS M27825 FOUND CORROSION AT CONNECTOR D2129J WD27-61-13. HARNESS CORROSION CLEANED PER MT. HARNESS REPLACEMENT REQUIRED. PLAN 3 SHIFT SLOT FOR HARNESS REPLACEMENT. HARNESS P-N 23354-001 IPC 27-61-09-010 IS LOB. CABLE ASSY IS ABOUT 40 FESDR UALA2011052002486Wire Harness · faultyFLIGHT CONTROL SYS STATUS MSG. NEED TO REPLACE ACE L2 FOR T-S. REPLACED ACE L2 PER MM. LRU REPLACEMENT TEST PASSED. REPLACED PCU BORROWED FROM EVA & TEST STILL FAILED, REINSTALLED ORG PCU PER MM. REPLACED SHORT HARNESS W8797 PCN 585-2189, ACES LRU REPLACESDR UALA2011051702430Thermocouple · faultyNR 2 ENGINE 2.9 BLEED VALVE TC PROBE CHANNEL B IS OUT OF RANGE MESSAGE. REPLACED 2.9 START BLEED VALVE THERMOCOUPLE, OPS GOOD.SDR UALA2011051702429Feeder Cable · damagedNR 1 ENGINE IDG FEEDER CABLE PROTECTIVE SLEEVES ARE DAMAGED AT THE IDG END. REPLACED SLEEVES.SDR UALA2011051702428Strip · damagedNR 1 ENG NR 2 GAP STRIP DAMAGED. REPAIRED PER MT 54-UA2 2.375 INCH LONG .150 INCH DEEP SECOND CRACK FOUND EXCEEDS 4.0 INCHES. SECOND REPAIR EXCEEDS MT 54-UA1 LIMITS 3.875 INCH LONG .180 DEEP. ACCOMPLISHED HFEC PER 777 NDT MANUAL PART 6 CHAPTER 51-00-06, NO SDR UALA2011042501991Buss · malfunctionedFLIGHT LOST RIGHT DC BUS.SDR UALA2011032301390Wire Harness · faultyEMERGENCY EVACUATION SIGNAL SYSTEM DEFECTIVE AT ATTENDANT SEAT AT DOOR 3L. 3L POSITION DOES NOT ALARM OR LIGHT WHEN SYSTEM TESTED AT OTHER LOCATIONS, IT DOES LIGHT AND ALARM WHEN TESTED AT 3L, BUT NO ALARM OR LIGHTS AT ANY OTHER LOCATION. PIGGYBACK GOOD EVACSDR UALA2011021400775Fseu · faultyFLAP-SLAT CONTROL 2 HIGH LIFT CONTROL LANE NR 2 HAS A FAULT. STATUS MSG-2720722 LATCHED ER MODE MSG-2720722 LATCHED ER MODE. REPLACED FSEU NR 2 IAW MM, CHECKED OK.SDR UALA2011020100541Power Supply · inoperativeLT AISLE CEILING EMERGENCY LIGHTS INOP BETWEEN SEATS 17 AND 25. REPLACED POWER SUPPLY ASSY M33400, OP CK NORMAL.SDR UALA2011020100540Power Supply · inoperativeDOOR 3L AREA LAV MOUNTED LIGHTS ARE INOP. REPLACED POWER SUPPLY ASSY M33400, OP CHECK NORMAL.SDR UALA2011011900306Windshield Wiper · malfunctionedCAPT'S WIPER MALFUNCTION. REPLACED WIPER ARM ASSY PER MM.
Back to N221UA