N225UA
Service difficulty reports · 154
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 = 'N225UA' 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 = 'N225UA' 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 CALA2017081802757Sign · brokenM/D R3 DOOR AFT 1EA EXIT IDENTIFIER FOUND BROKEN. REPLACED THE CABIN R3 DOOR AFTER 1EA EXIT SKIN AND OP TEST CARRIED OUT, FOUND NORMAL AS PER AMM 33-51-01-960-802 REV80.SDR CALA2017081802756Light · brokenLAV 3A-LC RT AFTER EMERGENCY LIGHT FOUND BROKEN. REPLACED THE CABIN LAV 3A-LC RT AFTER EMERGENCY LIGHT AND OP TEST CARRIED OUT, FOUND NORMAL AS PER AMM 33-51-05-960-802 REV80.SDR CALA2017081802755Battery Pack · dischargedR2 DOOR EMERGENCY LT BATTERY PACK CAPACITY FOUND LOW (M33098). REPLACED THE CABIN R2 DOOR EMERGENCY LT BATTERY PACK M33098 AND OPERATIONAL TEST CARRIED OUT, FOUND NORMAL AS PER AMM 33-51-06-9 60-802 REV80.SDR CALA2017051901498Light · inoperativeEXTERIOR SLIDE EMERGENCY LIGHTS AT DOOR 1 RT AND 4 LT IS INOP. RELAMPED EXTERIOR SLIDE LIGHT AT DOORS 1R AND 4L. OPS CHECK GOOD REF AMM 33-51-04.SDR CALA2017022000431Lamp · inoperativeCEILING EMERGENCY LIGHT BURNED OUT AT THE L3 DOOR. REPLACED THE LAMPS. OPS NORMAL.SDR CALA2016111100884Unknown · malfunctionedEMER LIGHTS EICAS ON AT ALL TIMES CYCLED THE CONTROL SWITCH IN COCKPIT; DOOR 1-LEFT. THEN EMER LIGHT CHECK ON CABIN RESULT NORMAL AND NO EICAS MSG DISPLAYED.SDR CALA2016020395075Battery Pack · dischargedDOOR 3 RT PROXIMITY EXIT LIGHT AFT FOUND INOPERATIVE. DOOR 3 RT M33401 AFT BATTERY PACK REPLACED & OPERATIONS TEST CARRIED OUT FOUND NORMAL IAW AMM 33-51-06.SDR CALA2016020395074Battery Pack · dischargedDOOR 2 PROXIMITY EXIT LIGHT FWD, FOUND INOPERATIVE. DOOR 2 RT M33097 FWD BATTERY PACK REPLACED & OPERATIONS TEST CARRIED OUT, FOUND NORMAL IAW AMM 33-51-06.SDR CALA2014022590434Fan · failedRECIRCULATION FAN FAILURE OF 1 OR MORE CABIN AIR RECIRCULATION FANS. STATUS MESSAGE 2124500 LATCHED ER MODE.SDR CALA2013122693943Warning Message · activatedICE DETECTOR RT STATUS MESSAGE. COMPLIED WITH MEL IAW 3081B. PARTS NOT RECORDED.SDR CALA2013121993797Coupler · leakingNR 2 ENG HAS HYD LEAK NEAR HOSE & RACE WAY FITTING AT 1 O'CLOCK POS & EXCESSIVE COKING FROM TOP TO BOTTOM OF ENG & REVERSER. REPLACED HYD RETURN LINE COUPLER & ORING & RETORQUED PRESS LINE UPPER FITTING ON ENG 2 IAW AMM 29-11-06 AND IPC 29-11-51. CLEANED COKSDR CALA2013103092509Warning System · false activationFLAPERON STATUS MESSAGE. ACCOMPLISHED FLAPERON CONFIDENCE TEST, MESSAGE CLEARED.SDR CALA2013101892173Engine · making metalTHERE IS METAL ON THE NR 2 ENG GEARBOX CHIP DETECTOR & ALSO METAL ON THE MAIN ENG NR 2 CHIP DETECTOR. NR 2 ENG REPLACED IAW AMM 71-00-02 SEQUENCE 6102071.SDR CALA2013100991920Oxygen Mask · leakingCREW O2 NOW 980 SUSPECT POSSIBLE LEAK. FOUND FIRST OBSERVERS SEAT CREW MASK LEAKING. REPLACED MASK. ALL ACCESSIBLE FITTINGS IN NOSE TUNNEL FROM BOTTLE TO FLOOR LINE & OTHER CREW MASKS WERE LEAK CHECKED, NO ADDITIONAL LEAKS FOUND.SDR CALA2013092691482Modulating Valve · faultyBLEED FAN AIR MODULATING VALVE RT ENGINE BLEED FAN AIR MODULATING VALVE FAILED OPEN OR CLOSED, OR RT AIR SUPPLY & CABIN PRESSURE CONTROLLER FAILURE. FOUND CONTROL PRESSURE SENSE LINE ELBOW NUT LOOSE & O-RING DAMAGED. REPLACED O-RING & TIGHTENED ELBOW NUT, RASDR CALA2013092391365Control Unit · inoperativeWINDOW HEAT RT FWD STATUS MSG. RT FWD WINDOW HEAT INOPERATIVE LT. REPLACED WINDOW HEAT CONTROL UNIT IAW MM.SDR CALA2013090691088Oven · contaminatedR31 BC OVEN SMOKING WHEN-HEATING. CLEANED REMNANTS OF PLASTIC BAG FROM OVEN & OPERATIONS NORMAL.SDR CALA2013082690752Knob · looseSINGLE DIGIT KNOB ON TRANSPONDER IS LOOSE. SECURED KNOB & OPERATIONS CHECKED OKAY.SDR CALA2013081490446Sensor · faultyAPU BLEED AIR APUC DETECTED LOSS OF ABILITY TO PNEUMATICALLY LOAD APU. REPLACED APU DIFFERENTIAL PRESSURE SENSOR IAW AMM. NO ACTIVE FAULTS AFTER OPS CHECK NOTED.SDR CALA2013081390409Pressure Sensor · malfunctionedAPU DATA MEMORY MODULE HAS 76 STRAIGHT HITS IN MAT. INSTALLED APU DIFFERENTIAL PRESSURE SENSOR IAW AMM 49-53-04. NO ACTIVE FAULTS AFTER MAT AND OPS CHECK.SDR UALA2013071204882Oxygen Bottle · low pressureCREW OXYGEN PRESSURE READS 1400 PSI ON LOWER EICAS. REPLACED WITH NEW CREW OXYGEN BOTTLE AND PRESSURE & LEAK CHECKED OK.SDR UALA2013070304659Hinge · damagedGROUND POWER DOOR WILL NOT LATCH. REPLACED POWER DOOR HINGE ASSY.SDR UALA2013062404359Sleeve · discoloredNR 1 ENGINE IDG FEEDER CABLES INDENTIFICATION SLEEVES DISCOLORED. INSTALLED SHRINKABLE SLEEVES IAW SWP 20-00-10.SDR UALA2013052203559Warning Light · false activationAFTER LANDING, SMOKE WARNING IN LOWER LOBE CREW REST AREA CABIN, CREW DISCHARGED FIRE BOTTLE. INSPECTED AREA ON ARRIVAL, NO SMOKE DAMAGE FIRE EVIDENCE OR OTHER ODORS SUCH AS ELECTRICAL BURNING.SDR UALA2013051503374Bypass Valve · stuckSTATUS MESSAGE MANIFOLD SENSOR LT, FOUND LT TURBINE BYPASS VALVE STUCK AT .98, MESSAGE 21-23501. REPLACED LT TURBINE BYPASS VALVE IAW MM, OPS CKD GOOD.SDR UALA2013042602915Blanket · contaminatedNR 1 ENGINE RIGHT THRUST REVERSER COWL THERMAL INSULATION BLANKET HAS BEEN SOAKED WITH HYDRAULIC FLUID THAT HAS PENETRATED INTO THE INSULATION BLANKET. CLEANED COKE FROM BLANKET. FOUND OUTER LAYER INTACT WITHOUT FLUID PENETRATION.SDR UALA2013041802686Connector · damagedNR 1 ENGINE FUEL DIFFERENTIAL PRESSURE SWITCH CONNECTOR BACKSHELL LOOSE. CONNECTOR BACKSHELL REPLACED IAW WD 73-34-71.SDR UALA2013022701191Generator · trippedBOTH BACK UP GENERATORS LT-RT TRIPPED OFF LINE. RESET AS PER CHECKLIST.SDR UALA2013021300863Sensor · defectiveMAINTENANCE MESSAGE MANIFOLD SENSOR LEFT. MAY BE POSSIBLE MANIFOLD PRESS SENSOR. REPLACED LEFT MANIFOLD SENSOR PER MM. TEST PASS AND STATUS MESSAGE CLEARED.SDR UALA2013013000557Drive Unit · failedWEATHER RADAR SYS FAILED BOTH CHANNELS. REPLACED WEATHER RADAR ANTENNA DRIVE UNIT, OPS TEST NORMAL.SDR UALA2013012800506Gearbox · leakingFOUND TE FLAP PDU GEARBOX FLUID LEVEL EMPTY OR NEAR EMPTY. WHILE REFILLING GEARBOX FLUID FOUND LEAKING OUT WEEP HOLE AT HYD DRIVE MOTOR INPUT SHAFT. GEARBOX WILL NOT RETAIN FLUID. STARTED REMOVAL OF TE FLAP PDU GEARBOX. REMOVED ELECTRIC FLAP MOTOR ON GEARBSDR UALA2013012800482Satcom · faultySATCOM VOICE AND HIGH GAIN FAILURES. DUE TO THE HISTORY OF SATCOM VOICE AND HIGH GAIN FAILURES WITH CMC MSG 23-60101 AND 23-60151, REPLACED THE LEFT HIGH POWER RELAY K23001 (581-2259) IAW AMM 23-15-22 PB 401 AND THE LEFT BEAM STEERING UNIT M23090 (583-9020)SDR UALA2012091305163Module · faultyBOTH UPPER AND LOWER EICAS SCREENS MOMENTARILY BLINK OFF. ACCOMPLISHED TEST OF LEFT AIMS M1010 FAULT CODE 31- 81057 PRESENT. SUSPECT CPM-GG. REPLACED LEFT AMIS M010 CPM-GG REF AMM. OPS CHECKS NORMAL.SDR UALA2012091205147Charger · faultyBATTERY CHARGER APU STATUS MSG. CB K12 PULLED AND COLLARED. REPLACED APU BATTERY CHARGER, CHECKED OKAY.SDR UALA2012091205146Battery · faultyAPU BATTERY STATUS MSG. NO TIME FOR TROUBLESHOOTING. MEL APPLIED. REPLACED APU BATTERY, REF AMM. CHECKED OKAY.SDR UALA2012081304382Valve · faultedAIR SYNOPTIC, TARGET TEMPERATURE INDICATION IS BLANK CREW COMMENTS, AIR COND RESET WILL BRING BACK INDICATION BUT THEN ALWAYS BLANKS AGAIN MAT FAULTED ZONE TRIM MOD VALVE FOR ZONE C MSG. 21-2004 RENDERED ZONE C TRIM MOD VALVE INOP PER MEL 21590.SDR UALA2012080604170Oven · smokeFLIGHT ATTENDANTS REPORT SMOKE FROM BUSINESS CLASS GALLEYS. SUPPLEMENTAL DATA UPDATE, PERFORMED GENERAL VISUAL INSPECTION OF BUSINESS GALLEY AS PER AMM 25-31-02. NOTHING FOUND. CABIN CREW SAW WHITE SMOKE COMING FROM INSIDE THE OVENS R31 E R32, THROUGH OVENSDR UALA2012080604202Valve · faultyAPU BLEED AIR APUC DETECTED LOSS OF ABILITY TO PNEUMATICALLY LOAD APU. MESSAGE IS TRIGGERED BY IGV OR SURGE CONTROL SYSTEM FAULTS. APU BLEED AIR FAULT. APU BLEED WORKS BUT MESSAGE IS LATCHED. SURGE CONTROL VALVE IS IN DISAGREEMENT. REPLACED SURGE VALVE.SDR UALA2012071603846Engine · failedAPU LOST ALL ENGINE OIL DURING OPERATION INTERNAL. NO EXTERNAL OIL LEAK NOTED. MAINTENANCE SHUTDOWN APU. REMOVED AND REPLACED APU IAW MM. OPS AND LEAKS CHECK IS GOOD.SDR UALA2012070603645Switch · inoperativeFIRE EXTINGUISHER RESET LIGHT INOPERATIVE. REPLACED SWITCH L26503 PER WDM 26-22-11 AND 26-15-12. OPS CHECKED GOOD.SDR UALA2012040502116Structure · brokenRIGHT NOSE GEAR DOOR PROTECTIVE LIP METAL TRIM BROKEN. REPAIR BY APPLYING TWO LAYERS OF SPEED TAPE. NO LOOSE FASTENERS AND TAP TEST WAS GOOD.SDR UALA2012033001989Valve · malfunctionedDURING REFUELING, FOUND CENTRE TANK LT REFUEL VALVE DID NOT OPEN. DEPOWERED AND REPOWERED. CENTER TANK LT REFUEL VALVE NOW OPERATING NORMALLY.SDR UALA2012032801956Nut Plate · brokenNUT PLATE FOR VERTICAL STABILIZER ACCESS PANEL 322FL IS BROKEN, LOCATED BOTTOM FRONT LEADING EDGE CORNER. REPLACED NUT PLATE AS REQUIRED.SDR UALA2012032701935Connector · unsecureNR 2 ENGINE, FUEL DIFFERENTIAL PRESSURE SWITCH CONNECTOR, BACKSHELL IS LOOSE. *SUPPLEMENTAL DATA UPDATE* RE-SECURED CONNECTOR.SDR UALA2012032201832Unknown · unknownFLIGHT CREW REPORTED THEY COULDN'T TRANSMIT OVER ACARS AND ANY QUERY BY THEM ON ACARS DIDN'T WORK. ATTEMPTED TO TROUBLESHOOT WITH NO SUCCESS.SDR UALA2012021000804Screw · missingFOUR SCREWS MISSING IN SUCCESSION UNDER RT M WING INBOARD OF OUTBOARD FLAP RPL SCREWS AND MANY SURROUNDING SAME AREA WRONG LENGTH.SDR UALA2012011600335Sliding Window · distortedF/O SLIDING WINDOW LOWER THIRD IS DISTORTED AND AFFECT VISION. REPLACED F/O OPENABLE WINDOW. PERFORMED WINDOW INDICATION TEST PER MM, WINDOW HEAT CONT SYS OPS CHK PER MM. WINDOW CHECK PER MM. REPLACED PER MM.SDR UALA2012011600336Headset · defectiveCAPTS R INTERPHONE INOP MAINT TEXT: STATIC IN CAPTS MINITEL HAND MIC NORMAL. TRIED AUDIO CONTROL PANEL AND AUDIO MANAGEMENT UNIT, NO HELP. SUSPECT CAPTAINS AUDIO JACKS. REPLACED CAPT MINITEL HEADSET OPERATIONAL VHF CHECK NORMAL.SDR UALA2012011600334Indicator · faultyRUDDER TRIM INDICATOR BACKGROUND LIGHT INOP. INDICATOR INDICATION OPS OK, INDICATOR, PCN 483-9037 NOT STOCKED LHR. CHANGED THE RUDDER INDICATOR PER MM.SDR UALA2012011000222Plug · unknownNR 2 ENGINE DRIVE PAD & BOROSCOPE PLUGS REMOVED. PLUGS AT 1, 5, AND 10 O`CLOCK POSITIONS. REPLACED BOROSCOPE PLUGS AND DRIVE PAD.
Back to N225UA