N227UA
Service difficulty reports · 138
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 = 'N227UA' 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 = 'N227UA' 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 CALA2018102302176Battery Pack · dischargedREF NR L/P 9463740 SPEC NO. B777-33-3-6019 EMERGENCY LIGHT BATTERY PACK M33099 CAPACITY LOW (P/N D717-01-100). REPLACED EMERGENCY LIGHT BATTERY PACK M33099 & C/OUT TEST FND NORMAL AS PER AMM 33-51-06-960-802 REV 83 & SUBTASK 33-51-06-710-002 REV 83. LOCATION:DSDR CALA2018102302175Battery Pack · dischargedREF NR L/P 9463734 SPEC NO. B777-33-3-6019 EMERGENCY LIGHT BATTERY PACK M33405 CAPACITY LOW (P/N:D717-01-100). REPLACE EMERGENCY LIGHT BATTERY PACK M33405 & C/OUT TEST FND THE RESULT NORMAL AS PER AMM 33-51-06-960-802 REV 83 & SUBTASK 33-51-06-710-002 REV 83. SDR CALA2018102302174Battery Pack · dischargedREF NR LP 9463739 SPEC NO. B777-33-3-6019 EMERGENCY LIGHT BATTERY PACK M33097 CAPACITY LOW (P/N D717-01-100). REPLACED EMERGENCY LIGHT BATTERY PACK M33097 C/OUT A TEST FND THE RESULT NORMAL AS PER AMM 33-51-06-960-802 REV 83 & SUBTASK 33-51-06-710-002 REV 83. SDR CALA2018012800370Light · missingEMERG FLOOR LIGHTS AT 4R IN GALLEY MISSING LIGHT ASSY. FOUND MISSING PIECE, REINSTALLED.SDR CALA2017090102989Housing · brokenAFT GALLEY COMP 704 EMERGENCY LIGHT HOUSING BROKEN REPLACED LIGHT HOUSING. OPS CHECKED GOOD.SDR CALA2017060501686Oven · odorOVEN IN AFT GALLEY HAS BURNING ELECTRICAL ODOR WHEN IN USE. REPLACED OVEN R53 WITH NEW OVEN PER MM 25-32-02SDR CALA2017020300234Lens · damagedFOUND CABIN ZONE A PARTITION LOWER AREA TWO EMERGENCY LIGHT LENS DAMAGED. REPLACED THE MERGENCY LIGHT ASSY AND OP TESTED NORMAL IAW AMM 33-51-05-960 -802, REV 78.SDR CALA2017020300233Lens · damagedFOUND ZONE B PARTITION LOWER AREA TWO EMERGENCY LIGHT LENSES DAMAGED. REPLACED LIGHT AND OP TESTED NORMAL IAW AMM 33-51-05-960-802, REV 78.SDR CALA2017020300232Lens · damagedFOUND CABIN AFT CENTER GALLEY A4 AREA 3EA EMERGENCY LIGHT LENS DAMAGED. REPLACED THE EMERGENCY LIGHT , FOUND NORMAL IAW AMM 33- 51-05-960-802, REV 78.SDR CALA2017020300235Lens · brokenGALLEY RT ONE LOWER EMERGENCY LIGHT FOUND BROKEN. REPLACED THE EMERGENCY LIGHT AND INSTALLATION TEST FOUND NORMAL IAW AMM33-51-05-960-802, REV 78.SDR CALA2016010894974Light · inoperativeEXTERIOR EMER LIGHT AT DOOR 3L INOPERATIVE. REPLACED BULB IAW AMM 33- 51-04. OPERATIONS NORMAL.SDR CALA2015112394857Engine · making metalLEFT ENG HAD AUDIBLE SURGE DURING POWER REDUCTION AT TOP OF DESCENT. THROTTLE REDUCED TO IDLE. NO ENG LIMITS WERE EXCEEDED. WHEN THROTTLE WAS ADVANCED TO 61%, 1 AT FL 230 IT SURGED AGAIN. THROTTLE REDUCED TO IDLE FOR REMAINDER OF FLIGHT. VISUAL CHECKS IAWSDR CALA2015111894845Engine · making metalON DESCENT FL370, AFTER THRUST REDUCTION, EXPERIENCED SEVERAL COMPRESSOR STALLS LT ENG. POWER REDUCED TO IDLE FOR REMAINDER OF DESCENT FROM FL230, EMER DECLARED. FOUND METAL PARTICLES IN THE ENG TURBINE EXHAUST REQUIRING ENG REMOVAL.SDR CALA2015011292934Autothrottle Sys · malfunctionedAUTO THROTTLE DOES NOT ENGAGE, MODE DOES NOT SHOW ON PFD. ACCOMPLISH HI SPEED RJO, MAX SPEED 135 KNOTS. ACCOMPLISHED FIM 22-31-TASK 907 & AMM 22-31-00. ALL TESTS PASSED, NO FAULTS ON INBD FLIGHT DECK EFFECTS. ACCOMPLISH ALL TASKS INCLUDING THOSE REQUESTED SDR CALA2014072291495Oven · smokeOVEN SMOKING OR SPARKING R31 & R32. DEPOWERED GALLEY & SMOKE STOPPED. SLIGHT ELEC SMELL OVEN R31 INOPERATIVE & COLLARED.SDR CALA2014012090199Warning System · activatedBLEED LOSS WING RT EICAS.SDR CALA2013120393402Status Message · activatedBLEED FAMV LT STATUS MESSAGE.SDR CALA2013101592064Trim Switch · faultyPITCH TRIM ELECTRIC INOPERATIVE ON BOTH CAPTAINS & FIRST OFFICERS YOLKS IN NOSE DOWN DIRECTION. ALTERNATE PITCH TRIM OPERATED NORMALLY & INDICATED NORMALLY ON STAB TRIM INDICATOR. R & R CAPTAINS PITCH TRIM SWITCH IAW AMM, OPERATIONS GOOD.SDR CALA2013100791789Window · crackedLT FWD WINDOW SHATTERED. AFTER FINISHED COA209881, REPLACED WITH NEW WINDOW SHIELD IAW AMM 56-11-01. MAT TEST PASSED, NO DEFECT NOTED.SDR CALA2013093091570Module · faultyLT FMC INOPERATIVE INTERMITTENT. REPLACED MODEL M002 IN LT AIMS CABINET IAW AMM. OPERATIONS CHECKED OKAY, NO MESSAGES.SDR CALA2013090991117Sensor · dirtyATSCV SHOWS OPEN WHILE APU IS RUNNING. CLEANED CLUSTER PNENMATIC SENSORS RAN APU, ALL CHECKED NORMAL.SDR UALA2013062404364Smoke Detector · false activationSMOKE DETECTOR ALARMED IN FWD CREW REST AREA. REPLACED 2 SMOKE DETECTORS IN FWD REST, TEST PASSED.SDR UALA2013060503890Warning System · activatedACFT RETURNED TO FIELD DUE TO NUMEROUS OVERHEAD PANEL LIGHTS AND EICAS MESSAGES SHORTLY AFTER TAKEOFF.SDR UALA2013052903737Coupling · disintegratedLEFT A/C PACK COUPLING CONNECTING LEFT DIFFUSER TO LEFT HEAT EXCHANGER DISINTEGRATED. REPLACED CONNECTING COUPLING, IAW AMM 21-52-10.SDR UALA2013052203557Oven · contaminatedOVEN R31 SMOKING FROM LOWER SIDE, PLASTIC LOOKS BURNED. CLEANED DEBRIS. REPLACED R31 OVEN. OPS CHECKED NORMAL IAW AMM.SDR UALA2013041602613Line · leakingFOUND EVIDENCE OF HYDRAULIC LEAK ON NR 1 ENGINE RIGHT SIDE STRUT DISCONNECT, FLUID COKING ON HYD AND FUEL LINE RACEWAY, ALSO INBOARD THURST REVERSER HALF COKED WITH HYD OIL. FOUND HYD SUPPLY LINE LOOSE AT STRUT DISCONNECT. TIGHTENED LINE. SAFETIED HYD SUPPSDR UALA2013040902406Igniter · failedENGINE IGNITOR R2 RIGHT ENGINE FAILED TO IGNITE USING IGNITOR 2. STATUS MSG-7461502 INACTV ES MODE NO TIME ON TURN. PARTS: (671-1923 CH31923-5) (671-1323 MR74112)SDR UALA2013040102061Slide · improper partNEED TO REPLACE DOOR 2L SLIDE. REPLACED SLIDE AT DOOR 2L WITH CORRECT MR.SDR UALA2013020100610Sensor · dirtyUNABLE TO CONTROL CABIN TEMP. CLEANED TEMP SENSORS AND OPS CHECKED OKAY.SDR UALA2012121007159Detector · faultyICE DETECT RIGHT DISPLAYED ON STATUS. REPLACED RIGHT ICE DETECTOR PER AMM, OPS TEST GOOD.SDR UALA2012101605906Computer · malfunctionedAIMS 1) EITHER ONE (1) OR MORE OF THE SAFEBUS (TM) LANES HAS FAILED OR ONE (1) OR MORE OF THE POWER INPUT CHANNELS TO THE AIMS HAS FAILED FOR 1 SECOND OR 2) INCOMPATIBLE OPS, OPCS, OR PROGRAM PINS EXIST BETWEEN LEFT AND RIGHT CABINETS AT UNINHIBITED COLD POWERSDR UALA2012082104650Vane · damagedBOROSCOPED NR 2 ENGINE FOUND BURN THOUGH IN T1 VANE AT 3:00 POS. FOUND ANOTHER VANE 3:00 POSITION WITH BURN THROUGH AT THE RADIUS. REPLACED NR 2 ENGINE PER MM.SDR UALA2012081004343Valve · faultyZONE C TEMP CONTROL TARGET TEMP BLANK AT C ACCOMPLISHED AND ZONE C TRIM AIR VALVE FAILED ON GROUND TEST PRIOR SUSPECT ZONE TRIM MODULATING VALVE.SDR UALA2012040502118Pitot Tube · malfunctionedLOSS OF CENTER PITOT HEAT. REPLACED C-PITOT PROBE PER MM. GND TEST PASSES AND LEAK CHECK PASSED.SDR UALA2012022701132Valve · faultyPACK 2 CHRONIC TRIP. DUE TO CONTINUED REPORTS OF PACK 2 TRIP AND SUBSEQUENT RESET PLEASE ACCOMPLISH A CHECK OF THE PRIMARY HEAT EXCHANGER WITH REFERENCE TO MM FOR ANY OBSTRUCTIONS OR ISSUES THAT MAY RESTRICT AIRFLOW THROUGH THE ECHANGER. REPLACED LOW LIMIT VSDR UALA2012022401116Heat Shield · damagedAFT STRUT FAIRING LWR HEAT SHIELD FASTENERS NR 4 TAIL BROKEN, 5&6 WASHER MISSING, 14 & 15 TAIL SHEARED OFF AND NR 16 IS SHEARED AND LOOSE REF MT54-UA1 PG 4. CONT OF AMIS ITEM 8132004 STARTED REMOVING NR 1 PAN PER MM. REMOVED HEAT SHIELDS NR 3, 4, 5 & 6.
CSDR UALA2012022001033Control Valve · faultyRIGHT PACK CYCLING ON AND OFF WITH ASSOCIATED ADVISORY MESSAGE. CREW TRIED CYCLING PACK SWITCH, ADDING POWER FROM RT ENGINE, NO HELP. REPLACED RT LOWER FLOW CONTROL VALVE PER AMM AND COMPRESSOR DISCHARGE TEMP SENSOR M2 1520.SDR UALA2011122707105Unknown · malfunctionedFLIGHT CONTROLS SYSTEM BELOW MINIMUM DISPATCH REQUIREMENTS. STATUS MSG02- ACTIVE CRUISE HARD; PITCH TRIM CHANNEL (CENTER) DOES NOT FOLLOW TRIM UP COMMAND. DB- PRIMARY FLIGHT COMPUTER (LEFT) MSG03- ACTIVE CRUISE HARD; PITCH TRIM CHANNEL (CENTER) DOES NOT FOLLSDR UALA2011121206811Igniter · malfunctionedRIGHT ENGINR IGNITOR R1 FAILED TO IGNITE USING NR 1 UPPER IGNITER PLUG. OPS CHECKED ON MAT AND RUN-UP GOOD.SDR UALA2011111406229Bushing · faultyNR 2 ENG S/N 222131 REMOVED DUE TO LOWER AFT MOUNT RAIL BUSHING REPLACEMENT. INSTALLED ENG S/N 222040 PER MM.SDR UALA2011111406220Anti-Ice Valve · failedANTI-ICE EICAS, FLT DIVERTED. RPL EAI AND EAI CONTROLLER PER AMM, ENG RUNS SATISFACTORY.SDR UALA2011111006137Bushing · migratedNR 2 ENG AFT ENGINE MOUNT SHOWS BUSHING MIGRATION AT 3RD BOLT INBD FROM OTBD SIDE, LOWER ROW. SAMC TEXT: WHATEVER HARDWARE IS REMOVED, SEND TO ENG MOUNT SHOP WITH EG-ALERT TAG, FOR FAILURE INVESTIGATION. NEED TO BE SURE THAT EVERYTHING THAT MAY HAVE CONTRIBSDR UALA2011110906111Bearing · defectiveNR 2 ENG FAULT HISTORY SHOWS MAINTENANCE MSG MORE THAN ONCE IN 5 LEGS. NR 1 BEARING ACCELEROMETER SIGNAL OUT OF RANGE.
WITH THIS MSG OCCURING IN DESCENT, IT IS A NUISANCE, NO ACTION IS REQUIRED. ALSO, 483-0058 NR 1 BRG ACCELEROMETER IS AN INTERNAL ENGINE SDR UALA2011110906110Switch · faultyEMERGENCY EXT LIGHT SWITCH LOC ON NLG P40 PANEL FOUND TO BE NOT WORKING IN PROPER MANNER. FOUND ON WALK AROUND.
REPAIRED THE SWITCH, SYSTEM CHECKED OK.SDR UALA2011110105922Control Valve · faultyRIGHT A/C PACK FLOW CONTROL VALVE STATUS MESSAGE DISPLAYED. REPLACED UPPER FLOW CONTROL VALVE, OPS NORMAL.SDR UALA2011092605208Skin · tornRT MLG DOOR INBD EDGE SKIN TORN 14" LONG BY 4" DEEP. DAMAGE IS 2.5 FT FROM REAR EDGE OF DOOR. REMOVED RT MLG DOOR. DOOR REPAIRED & REINSTALLED PER MM. BONDING WIRES (3) DISCONNECTED ON RT MLG DOOR HINGE. .SDR UALA2011070503281Pitot Line · kinkedLEFT PITOT PROBE HOSE KINKED REF SMB WU X5701I. PART TO ARRIVE VIA FEDEX ON 02JUL11 OSTF#N6614. REPLACED LT PITOT HOSE LOW RANGE LEAK CHECK WILL BE ACP ON SMC012. LT PITOT PROBE AND HOSE NEEDS LOW RANGE LEAK TEST ON ACCOUNT OF KINKED HOSE REPLACEMENT REF SMSDR UALA2011070503280Structure · damagedLEFT VERT STAB BOX APPROX FS STA 340 HAS DAMAGE. REPAIR PER EVA 80994 AND CF9025 IS A MAJOR REPAIR. NO DELAM INDICATED PRIOR TO AND AFTER REPAIR. REPAIR IS NOT CONSIDERED PERM UNTIL 24 MOS AND NEEDS INSP EVERY 120 DAYS REF CF9025.SDR UALA2011052502557Light · inoperativeSEAT 3E FWD EMERGENCY LIGHT INOPERATIVE. REPLACED LIGHT ASSY, OPS CHECKED OKAY.SDR UALA2011050502209Sleeve · damagedNR 2 ENGINE THRUST REVERSER IS DAMAGED ON THE OUTBOARD TRAILING EDGE AND IS ALSO DAMAGED INBOARD AT THE 5 O'CLOCK POSITION. ACCOMPLISHED INTERIM REPAIR. INSTALLED SERVICEABLE THRUST REVERSER SLEEVE PER MM.
Back to N227UA