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 UALA2011032801490Pcu · leakingWALK AROUND CHECK FOUND SPOILER NR 8 PCU LEAKING. RUNNING HYD LEAK FROM PCU CASE WHEN PRESSURIZED, CHKD HYD TUBE AND CONNECTORS NML. RPL'D PCU PER MM AND OPERATION TEST PER MM. ALL IS NORMAL. NO FAULT AND NO LEAKING FOUND.SDR UALA2011030401074Bearing · migratedNR 2 ENG AFT ENG MOUNT CENTER BEARING OF CENTER LINK ASSY. BEARING MIGRATED AFT APPROX 7-16 INCHES. REMOVED AFT MOUNT PER MM. REPLACED NR 2 ENG AFT LOWER ENG MOUNT PER MM. ACCOMPLISHED RII INSPECTION OF NR 2 ENG AFT LOWER ENG MOUNT PER MM. INSTALLATION ISDR UALA2010121504586Transceiver · inoperativeHF RADIO - TRANSMISSION PROBLEM. LEFT HF WILL NOT TUNE ABOVE 11MHZ. REPLACED HF TRANSCEIVER, OPS CHECKED OK.SDR UALA2010121304539Control Panel · faultedCSCP WILL NOT ACCEPT CONFIGURATION DATA BASE LOAD. CSCP FAULTS RESULTS DATABASE NUMBER INVALID. MAINTENANCE MESG 23-02819. RELOADED CSCP OPS SOFTWARE AND LOADED CONFIG DATABASE. NO FAULTS ON COMPLETION. OPS CHECK NORMAL.SDR UALA2010090703290Hose · leakingNR 1 ENG EVIDENCE OF HYD LEAK RT SIDE OF ENGINE. REPLACED HYD PRESS HOSE AND BLANKET. LEAKED CHECK GOOD.SDR UALA2010081602994Panel · failedCSCP WON'T GO INTO ALL TEST MODE. REPLACED CSMU, NO HELP. NEED TO CHECK SW CONFIG OF THE CSMU. THE CSCP KEPT SHOWING NO RESPONSE FROM THE CSMU, BEFORE AND AFTER CSMU REPLACEMENT. REPLACED CSCP.SDR UALA2010080902892O2 Generator · brokenVIOX OXY CASE BROKEN AT ROW 9A. REMOVED VIOX CASE FROM ROW 9A. INSTALLED NEW AVIOX UNITS AT 1EACH: 9AB & 9HJ, 26AB & 26HJ, 30AB & 30HJ. ALL UNITS REPLACED AT 15AB & 15HJ. STILL NEED 1 UNIT AT EACH 9AB, 9HJ, 26AB, 26HJ, 30AB & 30HJ. REPLACED 6 AVIOX DUO-PASDR UALA2010080202767Fseu · failedSLATS PRIMARY FAIL PRIMARY (HYDRAULIC) SLAT DRIVE FAILURE. SLATS OPERATING IN SECONDARY (ELECTRICAL) MODE. REPLACED NR 2 FSEU PER MM, CHECKS OKAY.SDR UALA2010080202766Transceiver · faultedLEFT HF RADIO FAILURE. ALL DASHES IN FREQUENCY WINDOWS. CYCLED L-HF CB, GND TEST PASSED. BUT THE DASHES APPEARED AGAIN DURING TUNING. NO HF TRANSCEIVER AVAILABLE. REPLACED LEFT HF COMM TRANSCEIVER PER MM.SDR UALA2010080202765Transceiver · faultedVHF DATALINK EICAS MSG. FOUND DEFECTIVE TRANSCEIVER. REPLACED CTR VHF TRANSCEIVER. OPS NORMAL.SDR UALA2010080202764Sdu · malfunctionedSATCOM MESSAGE HIGH GAIN STATUS MESSAGE DISPLAYED. BREAKERS PULLED. REPLACED SATELLITE DATA UNIT PER MM. SYSTEM TESTS OKAY.SDR UALA2010062502261Solenoid · faultyPRIMARY FLAP-SLAT ADVISORY MSG ON EICAS. SOLENOID FOUND FAULTY. LOW SPEED SOLENOID REPLACED. TEST PASSED.SDR UALA2010051101606Loop · damagedBODY BLEED LOOP 1 MSG. BODY BLEED LOOP 1 MSG TOTAL BODY LOOP 1 RESISTANCE WAS 150 OHMS. LOOP 2 WAS 128 OHMS. FOUND HIGH RESISTANCE AT M26146 LOOP CONNECTION. CLEANED CONNECTOR AND RESECURED. RESISTANCE NOW CK'S 128 OHMS. NO FAULTS.SDR UALA2010022400690Lamp · inoperativeSIDEWALL LIGHTS INOP AT 15AB. RELAMPED.SDR UALA2010022400689Lamp · inoperativeSIDEWALL LIGHTS INOP AT 34AB. RELAMPED.SDR UALA2009122103956Fan Blade · damagedPOSSIBLE BIRDSTRIKE TO NR 1 ENG. ACCOMPLISHED BORESCOPE INSP. HPC 5TH, 6TH, AND 10TH STAGE BLADES AND GAS PATH NO DAMAGE FOUND. BIRD STRIKE DAMAGE FOUND ON NR 1 FAN BLADE. HAS 3 DENTS ON CONVEX SIDE AT MIDSPAN 15 IN FROM BLADE ROOT. REPLACED NR 1 BLADE INDSDR UALA2009082102576Connector · looseEMERGENCY EXIT EEL LIGHT INOP, SEAT 3E FWD LIGHT ASSY. SECURED CONNECTOR, OPS CHECKS NORMAL.SDR UALA2009082102575Light · inoperativeEMERGENCY EXIT LIGHT INOP, SEAT ROW 39 RIGHT. RELAMPED, OPS CHECKS NORMAL.SDR UALA2009071302028Connector · disconnectedFWD EEL LIGHT INOP AT SEAT 3E. FOUND CONNECTOR DISCONNECTED FROM LIGHT. RESECURED, LIGHT OP CHECKS OKAY.SDR UALA2009071302027Light · damagedEEL LIGHT INOP AT SEAT 21C. FOUND LIGHT DAMAGED, REPLACED EEL LIGHT ASSY, LIGHT OP CHECKS OKAY.SDR UALA2009060301594Light · inoperativeSEAT 3E EMERGENCY LIGHT FWD INOP. RELAMPED, OP CHECK NORMAL.SDR UALA2009042701208Feeder Cable · damagedFOUND T3 FEEDER CABLE LUG BURNED AND SEPARATED AT IDG. REMOVED NR 2 ENG IDG POWER FEEDER CABLES. INSTALLED NEW ENG IDG POWER FEEDER CABLES. REPLACED NR 2 ENG IDG PRECAUTIONARY. SERVICED & OP CHECKED. FEEDER HARNESS REPLACED.SDR UALA2009041401081Valve · faultyLT PACK UPPER FCV WILL NOT SHUT OFF. REMOVED AND REPLACED LEFT UPPER FCV.SDR UALA2009040901031Control Valve · failedFOUND RT UPPER FLOW CONTROL AND SOV TORQUE MOTOR NOT IN COMMANDED POSITION. REPLACED FCV. OPERATED NORMAL.SDR UALA2009020500395B-Nut · leakingNR 1 ENGINE RIGHT HALF REVERSER HAS HYD LEAK. FOUND 2 HYD LINES LEAKING AT RIGHT SIDE OF ENG NR 1. TIGHTENED B-NUTS. B-NUTS JUST FWD OF CENTER REVERSER ACT NEED TO DEPLOY REVERSER, VERIFY NO LEAKS. RAN ENGINE, OPERATED REVERSER, NO LEAKS NOTED.SDR UALA2008122306967Sensor · failedAPU SHUTDOWN AT GATE FOR LOW OIL QTY MAT FAULTING OIL QUANTITY-SUMP TEMPERATURE SENSOR. REPLACED APU OIL QTY-SUMP SENSOR. OPS CHECK NORMAL. NO MESSAGES.SDR 2008UALA06449Connector · looseEEL LIGHTS ON SEATS 41C&G, 42C&G, 43C&G ARE INOPERATIVE DURING TEST OF LIGHTING. CONNECTED LOOSE CONNECTOR, CHECKS OKAY.SDR 2008UALA03363Controller · faultyNR 2 ENGINE PRSOV CONTROLLER FAILED HEALTH CHECK. *S/D* SUSPECT FAULTY CONTROLLER. REPLACED CONTROLLER PER MM 36-11-18-401. OPS CHECKED GOOD. AC OK FOR SERVICE.SDR 2008UALA00507Skin · nickedRIGHT I/B MAIN FLAP UPPER PANEL HAS A NICK AROUND A FASTENER HOLE, APPROX 1.8 INCHES FROM O/B END AND 36.10 FROM AFT END. SUSPECT FOREIGN OBJECT DAMAGE
REPAIRED PER SRM 51-00-04, OK TO CF PER EVA-71089. ACFT OK FOR SERVICE.SDR 2007UALA05189Light · inoperativeAFT EMERGENCY LIGHT OUT AT SEATS 2E, 2F, AND 3E. REPLACED LIGHT STRIP.SDR 2007UALA05188Light · inoperativeEMERGENCY LIGHT OUT AT SEAT 18C. RELAMPED, CHECKS GOOD.SDR 2007UALA04321Toilet · leakingRTFL DUE TO WATER LEAK FROM THE GALLEY, SOAKING THE CREW REST AREA / PASSENGER SECTION. SUSPECT TOILET ASSEMBLY. REMOVED AND REPLACED THREE TOILET ASSEMBILES AT LAV 101, 131,141. REPLACED AFT DRAIN RESTRICTOR VALVE. OPS CHECK GOOD.SDR 2007UALA04116Battery Pack · faultyFOUND DOOR 2R EPAS BITE LIGHT IS NOT BLINKING GREEN. REPLACED EPAS BATTERY PACK. OP CHECK OK FOR SERVICESDR 2007UALA02215Battery · faultyFOUND MAIN BATTERY AT 17V AND DISCHARGING AT 4A. [07-20-07] REPLACED MAIN BATTERY PER MM24-31-01. TESTS OK FOR RETURN TO SERVICE.SDR 2007UALA02158Charger · failedMAIN BATTERY MAIN BATTERY CHARGER FAILURE. [07-17-07] REPLACED MAIN BATTERY AND ELMS CARD. OP CHECKED OK FOR SERVICE.SDR 2006UALA01257Vacuum Sys · obstructedLAV PROBLEMS. AFT VACUUM SYS LAVS BLOCKED. FOUND WASTE SYSTEM VACUUM BLOWER INOPERATIVE. ALSO, DAMAGE TO DUCTING AND CLAMP AROUND DUCT. ACCCOMPLISHED DUCT REPAIR & CLAMP REPLACEMENT. REPLACED VACUUM FAN BLOWER. SECURED UNIT IN AFT CARGO COMPARTMENT. REACTISDR 2006UALA00811Terminal · overheatedINSULATION FOR (6) TERMINALS ON THE BACK ON CB 51 CHILLER AT AFT GALLEY ARE HEAT DAMAGED AND BLACK IN COLOR. PULLED PANEL ASSY FOR ACCESS. CUT OFF OVERHEATED TERMINALS TO PROVIDE SPECIMENS FOR BOEING INVESTIGATION. REPLACED CB (C51) WITH TERMINALS. RETERMISDR 2004UALA01176Packboard · crackedPACKBOARD CRACKED IN 2 PLACES. SLIDE/RAFT WAS REMOVED FROM AIRCRAFT AT NORMAL MAINTENANCE INTERVAL. PACKBOARD CRACKS WERE OBSERVED DURING SLIDE/RAFT OVERHAUL. CRACKS WERE MINOR AND WOULD NOT HAVE AFFECTED PERFORMANCE OF THE SLIDE/RAFT. IT IS POSSIBLE CRACK
Back to N227UA