N228UA
Service difficulty reports · 168
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 = 'N228UA' 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 = 'N228UA' 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 CALA2018051501260Oven · overheatedOVEN SMOKING OR SPARKING OVEN R52-AFT GALLEY-UPR VENT SMOKE W/ELEC SMELL. PWR OFF-NO FIR E. / CAP ADVISED NO ACTUAL FIRE OBSERVED WHEN FA REPORTED THE OVERHEATING CONDITION TO FLIGHT CREW. / PERFORMED VISUAL INSPECTIONS OF EVIDENCE OF ACTUAL FIRE AND SMOKY SDR CALA2017120904378Light · inoperativeEMERGENCY EXIT EXTERIOR LIGHT IS INOP. RELAMPED LIGHT. OPS CHECK GOOD.SDR CALA2017092203284Battery · inoperativeR2 DOOR EMERGENCY FLASHLIGHT BATTERY INOPERATIVE. REPLACED THE BATTARY, OPS CHECKED OK.SDR CALA2017091503158Sign · brokenMAIN DECK L2 DOOR AFT & L4 DOOR AFT, TWO EXIT SIGNS FOUND BROKEN. REPLACED THE SIGN ASSEMBLIES AND OP TESTED NORMAL IAW AMM 33-51-01-960-802, REV 80, & AMM 33-51-00-710-801, REV 80.SDR CALA2017091103140Light · brokenMAIN DECK A & B ZONE PARTITION LOWER EMERGENCY LIGHT FOUND BROKEN. REPLACED THE EMERGENCY LIGHT AND OP TESTED, FOUND NORMAL IAW AMM 33-51-05-960-802, REV 80, & AMM 33-51-00-710-801, REV 80.SDR CALA2017091103139Light · brokenMAIN DECK 3F-LC LAVATORY, LT LOWER EMERGENCY LIGHT FOUND BROKEN. REPLACED THE EMERGENCY LIGHT AND OP TESTED, FOUND NORMAL IAW AMM 33-51-05-960-802, REV 80, & AMM 33-51-00-710-801, REV 80.SDR CALA2017091103138Light · brokenMAIN DECK A4 GALLEY CENTER AREA, HAD THREE LOWER EMERGENCY LIGHTS BROKEN. REPLACED THE EMERGENCY LIGHTS AND OP TESTED, FOUND NORMAL IAW AMM 33-51-05-960-802, REV 80, & AMM 33-51-00-710-801, REV 80.SDR CALA2017091103137Light · brokenFWD ENTRY DOOR ONE LOWER EMERGENCY LIGHT FOUND BROKEN. REPLACED THE EMERGENCY LIGHT AND OP TESTED, FOUND NORMAL IAW AMM 33-51-05-960-802, REV 80, & AMM 33-51-00-710-801, REV 80.SDR CALA2017091103136Light · brokenMAIN DECK M1 GALLEY CTR RT LWR EMERGENCY LIGHT FOUND BROKEN. REPLACED THE EMERGENCY LIGHT AND OP TEST CARRIED OUT, FOUND NORMAL IAW AMM 33-51-05-960-802, REV 80, & AMM 33-51-00-710-801, REV 80.SDR CALA2017060901739Wire · burnedFA REPORT ELECTRICAL SMELL WHILE USING OVENS IN AFT OF BUSINESS GALLEY NR 232. FOUND WIRE W074-0005-18 BURNED BEFORE CONNECTOR D06118P. ACCOMPLISHED SPLICE OF WIRE W0074-0005-18 PER SWPM20-30-12. WIRE SPLICE AND CONNECTOR D06118P IS DIRECTLY OVER FWD PART OF BSDR CALA2016012895060Light · inoperative3L AFT LAVATORY OVERHEAD TUBE SMOKED & WENT OUT, TUBE REMOVED. CREW INFO, SMOKE ODOR HAS GONE AFTER LIGHT TUBE REMOVED. LIGHT SOCKET CONDITION CHECKED OK.SDR CALA2015052693818Antenna · defectiveT CAS RESOLUTION ADVISORY OCCURS WITH NO OTHER AIRPLANE IN CONFLICT AIRSPACE. CREW COMMENTS, INTRUDER SYMBOL STAYS DIRECTLY IN FRONT OF AIRPLANE SYMBOL ON ND, LATE FINDINGS + HOLIDAY. REPLACED CTR RA TRANSMIT & RECEIVE ANTENNA IAW 34-33-02. R & R LT ATC MODSDR CALA2015052193809Antenna · defectiveT CAS RESOLUTION ADVISORY OCCURS WITH NO OTHER AIRPLANE IN CONFLICT AIRSPACE. INTRUDER SYMBOL STAYS DIRECTLY IN FRONT OF AIRPLANE SYMBOL ON ND. REPLACED CTR RA TRANSMIT & RECEIVE ANTENNA IAW 34-33-02. R & R LT ATC MODE S XPONDER IAW 34-53-01.SDR CALA2014041090791Pump · faultedRIGHT BOOST PUMP FAULT AFTER TAKEOFF & SUBSEQUENT BLANKING OF FLIGHT DECK SCREENS. CREW DETECTED ELEC SMELL IN FLIGHT DECK MOMENTARILY & IN FWD CABIN ON DESCENT. FLIGHT RETURNED TO DXB. 160,000 LBS FUEL DUMPED. INSPECTIONS CARRIED OUT IAW AMM 05-51-50, NO OBSDR CALA2013121393668Warning System · activatedSTATUS MSG L2 DISPLAYED.SDR CALA2013120993560Pressure Switch · failedFUEL PUMP STATUS MESSAGE. REPLACED FUEL PUMP PRESSURE SWITCH IAW MM, OPS CHECKED GOOD.SDR CALA2013101191964Pump · leakingEVIDENCE OF HYD LEAK FLUID IN THE RT WW. FLUID IN THE RT WW. FOUND C2 ACMP CENTER ELEC HYD PUMP LEAKING AT PUMP HOUSING, PUMP NEEDED 611-9025 - MR29183. NO LEAK NOTED WHEN C1 ACMP IS IN USE. C2 ACMP ELEC PUMP INOPERATIVE. NO LEAK NOTED WHEN REMAINING HYD SDR CALA2013101191963Valve · faultyECON COOL VLV LT PACK ECONOMY COOLING VLV NOT IN COMMANDED POSITION. PERFORMED AIR ON TEST IAW FIM 21-52-811. VLV RESETS AT BEGINNING OF TEST BUT FAILS DURING ECON VLV OPERATION. IAW NEW VALVE 646-0029. REPLACED VLV IAW AMM 21-52-31 NEED TO ACP LEAK & OPESDR CALA2013100391720Transceiver · inoperativeVHF RADIO 3 INOPERATIVE. REPLACED CENTER VHF TRANSCEIVER IAW MM. OPERATIONS CHECKED OK.SDR CALA2013092691483Valve · malfunctionedLT ENGINE BLEED FAN AIR MODULATING VALVE DEACTIVATED. WIRING CHECKED FROM E/E CONNECTOR DM36111A TO VALVE, IAW WDM 36-11-13. LEAK CHECKED MUSCLE LINE FROM HPFA CONTROL TO VALVE, NO FAULTS NOTED. REPLACED LT ENGINE FAN AIR MODULATING VALVE IAW AMM, NO FAULTSSDR CALA2013092491391Circuit Card · failedHYDRAULIC PUMP EICAS MESSAGE DISPLAYED. REPLACED HYD IM CARD IAW AMM, MESSAGE CLEARED.SDR CALA2013091191197Exciter · failedLEFT ENGINE FAILED TO IGNITE USING IGNITER 2. STATUS MESSAGE 7461501 INACTV ES MODE. EXAMINED NR 2 IGNITER CHECKED FROM IGNITER PLUG TO ERU, NO FAULTS FOUND IAW WDM74-11-71. REPLACED EXCITER, LEAD & PLUG IAW AMMS. ACCOMPLISHED IGNITER AUDIBLE TEST &TWO SUSDR CALA2013090591039Packing · deterioratedSIGNS OF OIL LEAKAGE AROUND FAN CASE EXIT, OBSERVED ON ARRIVAL. AFTER EVALUATION FOUND LEAK COMING FROM AGB CONNECTION TO INTERMEDIATE CASE. CONFIRMED AGB PACKING DETERIORATING. REPLACED AGB, LAY SHAFT & TOWER SHAFT IAW EC -AR 7261-01349. RAN NR 1 ENGINESDR CALA2013082690736Fuel Heater · leakingSTATIC OIL LEAK ON NR 1 ENGINE DIRECTLY UNDER SERVO FUEL HEATER, DRIPPING A FEW DROPS PER MINUTE. REMOVED HYDRAULIC LINE CLAMP BRACKET UNDER SERVO FUEL HEATER TO FIND OIL LEAK. OIL IS LEAKING FROM THE SPLIT ON THE BOTTOM OF THE SERVO HEATER. REPLACED SERVO SDR UALA2013072305181Light · brokenEMERGENCY LIGHT BROKEN.SDR UALA2013072205106Pressure Switch · faultyLEFT ENGINE THRUST REVERSE STATUS MESSAGE. REPLACED HYD PRESSURE SWITCH IAW MM.SDR UALA2013071805034Structure · damagedLIGHTNING STRIKE ON RUDDER, INSPECTED IAW AMM.SDR UALA2013071504912Window · out of positionR1 DOOR SLIDE ARMED INDICATOR WINDOW ONLY SHOWS YELLOW IN 1 WINDOW, NOT THE OTHER. SLIDE ARMED NOT CONFIRMED. TURNED FWD VIEWING WINDOW AROUND TO CORRECT POSITION. DOOR FOUND LOCKING CORRECTLY. BOTH FLAGS VISIBLE WHEN ARMED.SDR UALA2013071204884Actuator · failedRIGHT RAM AIR INLET DOOR NOT IN COMMANDED POSITION OR LOSS OF POSITION FEEDBACK. REPLACED RT FWD RAM AIR DOOR ACTUATOR, OPS TESTED OK.SDR UALA2013060503908Cap · missingFIRST OFFICER`S WINDSHIELD HAS BARE HIGH VOLTAGE ELECTRICAL CONNECTOR. REPLACED MISSING PROTECTIVE CAP.SDR UALA2013053003761Cap · missingPROTECTIVE CAP LOWER RT CORNER, RT WINDSHIELD MAY BE MISSING. INSTALLED CAP.SDR UALA2013040902407Feeder Cable · crackedIDG FEEDER CABLES, COLOR CODE SHRINK WRAP CHARED CRACKED & MISSING. SHOULD READ NR 2 ENGINE IDG FEEDER CABLES, COLOR CODE SHRINK WRAP CHARDED, CRACKED & MISSING. REPLACED CABLE COLORED SHRINK WRAP AND SECURED.SDR UALA2013032501848Warning Light · illuminatedENGINE THRUST REVERSER LT STATUS MESSAGE ON STATUS PAGE. ACCOMPLISHED TASK 78-34, TASK 811, ACTIVATED THRUST REVERSER, RESET LT THRUST REVERSER CONTROL CIRCUIT BREAKER. THRUST REVERSER OPS NORMAL SEVERAL TIMES, NO FAULTS NOTED.SDR UALA2013021100796Generator · warning messageLEFT BACK UP GENERATOR HAS FILTER BLOCKED INDICATION ON MAINTENANCE PAGE AT ETOPS PRE DEPARTURE CHECK. REPLACED BACKUP GENERATOR, OPS CHECKED PER AMM. TEST 3 AND FOUND OK.SDR UALA2012122107338Windshield · damagedCAPTAIN'S WINDSHIELD WINDOW HEAT CONNECTORS SHOW SIGNS OR ELECTRICAL ARC AND MELTED CAPS. CAPTAIN'S WINDOW NEEDS CHANGE.SDR UALA2012122407402Filter · contaminatedFUEL TANK MICROBE CHECK IAW ROUTINE JOB CARD 253105010 FOUND MODERATE CONTAMINATION. NR 1 ENG AND NR 2 ENG FUEL PUMP FILTER PER MM, LEAK CHECKS GOOD.SDR UALA2012121407211Seat Track · wornBS 1035-1287 MAIN DECK SEAT TRACK HAS WEAR DAMAGE. BLENDED OUT IAW ECRA 5320-02216. CATEGORY A REPAIR.SDR UALA2012110506350Shutoff Valve · faultyCARGO HEAT VALVE AFT FAILURE OF AFT CARGO HEAT SHUTOFF VALVE OR (SOV) OR TEMP CONTROL VALVE (TCV). STATUS MSG-2112031 INACTV ER MODE MSG-2112021 INACTV DC MODE. COMPLIED WITH MEL PROCEDURE AND MAINT ACTION CARRIED OUT. PSBL VLV (PCN 646-0013), EXPEDITED ON SDR UALA2012101705929Strip · crackedRIGHT PYLON AFT FAIRING HEAT SHIELD GAP COVER STRIP NR 2 HAS FOUR CRACKS AT OUTBOARD EDGES OF PREVIOUS REPAIRS. FOUND CRACK IN E2 HEATSHIELD GAP STRIP. STRIP HAS BEEN CUTOUT AND MEASUREMENTS TAKEN. REPLACED THE SUBJECT GAP COVER STRIP WITH NEW PER ECRA 5454SDR UALA2012092705455Unknown · vibrationHUMMING AND VIBRATION COMING FROM DOOR 3L. INSPECTED AREA, NO OVERHEAT, OR LEAKS, HUMMING VARIES WITH APU PNEUMATICS OFF OR WHEN PACKS ARE TURNED ON. SUSPECT AIR PRESSURE BUILDUP IN DUCTS WHEN NO DEMAND CALLED FOR. THIS IS A KNOW CONDITION. INSPECTED PAX ANSDR UALA2012091905300Duct · brokenFLEXIBLE DUCT OF THE APU SURGE DUCT ASSY FOUND WITH BELLOWS BROKEN OFF. REPLACED FLEX DUCTSDR UALA2012071103735Converter · failedFAILURE IN THE BACKUP ELECTRICAL SYSTEM HAS OCCURRED THAT CANNOT BE ATTRIBUTED TO A BACKUP GENERATOR. REPLACED GEN BACKUP CONVERTER, ALL TESTED NORMAL. REPLACED GENERATOR BACKUP CONVERTER, ALL TESTS NORMAL. SUCCESSFUL ENGINE RUN TEST.SDR UALA2012062203364Fseu · faultyFLAP - SLAT CONTROL NR 1 MSG WOULD NOT CLEAR. SEE HISTORY. REPLACED FSEU-1 AS PER MM 27-51-01, ACCOMPLISHED SYSTEM TEST OF BOTH PRIMARY AND SECONDARY SYSTEM.SDR UALA2012060303079Motor · failedAFTER RECIRCULATION FAN FAILED, FLIGHT ATTENDANT REPORTED ACRID ODOR IN CABIN. REPLACED UPPER FWD FAN MOTOR PER MM. UPPER FILTERS REPLACED PER MM, OP CHECKED OKAY.SDR UALA2012060303080Switch · brokenRIGHT ENGINE BLEED AIR SWITCH LOOSE WILL NOT RESET. RIGHT ENGINE BLEED SWITCH BROKEN AND COULD NOT REINSTALL. REPLACED SWITCH ASSY. OPS AND ASCPC TEST PASSED.SDR UALA2012041702318Solenoid · faultySLATS PRIMARY FAIL PRIMARY (HYDRAULIC) SLAT DRIVE FAILURE. SLATS OPERATING IN SECONDARY (ELECTRICAL) MODE. CAUTION MSG01-LATCHED DESCENT MODE DEPENDENT; SLATS PRIMARY LOW SPEED SOLENOID CIRCUIT IS OPEN. DB- FSEU 2 MSG02- LATCHED DESCENT MODE DEPENDENT; SLATSDR UALA2012040902156Pump · out of toleranceFUEL PUMP NR 2 MALFUNCTIONED. REPLACED MAIN FUEL PUMP PER MM. OPS & LEAK CHECKED OK.SDR UALA2012030701463Unknown · malfunctionedELMS P110 PANEL THE ELECTRICAL LOAD MANAGEMENT SYSTEM (ELMS) P110 PANEL IS FAULTED SUCH THAT IT CANNOT SUPPORT AIRPLANE DISPATCH. AIMS HAS LOST ARINC 629 COMMUNICATION WITH THE P110 PANEL. ONE P110 PANEL CHANNEL IS INOP AND THE OTHER IS FAULTED AND IS OPERATISDR UALA2012011600340Scavenge Pump · leakingDUE TO REPORT OF NR 2 ENG LUBE AND SCAV PUMP BEING OIL SOAKED AFT ENG RUN, VERIFY THAT THE CORRECT PUMP IS INSTALLED. SHOULD BE PCN 615-1113 PN 764224-600U. REPORT P/N INSTALLED IN THE SIGN-OFF. REPLACED SCAVANGE PUMP PER MM 79-21-04. PART# (OFF - 764224A)SDR UALA2012011600352Starter · faultyAPU CONTROL STATUS MSG. MSG 49-10760 REPLACED ELECTRIC STARTER PER MM, OPS GOOD. STARTED APU 3 TIME WITH NO FAULTS AND MSG NOT ACTIVE.
Back to N228UA