N428UA
Service difficulty reports · 197
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 = 'N428UA' 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 = 'N428UA' 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 CALA2013121893783Microphone · inoperativeHAND MICROPHONE 1 INOPERATIVE. REPLACED CAPTAIN`S HAND MIC, OPERATION CHECKED OKAY.SDR CALA2013121393651Connector · looseFLIGHT ATTENDANT`S CIDS PANEL CAUTION ON. FOUND LAVATORY SMOKE SYSTEM FAULT. SECURED LOOSE CONNECTOR 7200VC BEHIND FWD LAVATORY A IAW WD 25-41-01. LAVATORY SMOKE SYS CHECKED OK IAW AMM TK 26-17-00-710-001 & 26-16-00-710-001.SDR CALA2013120693515Smoke Detector · faultyIAW LOG 2 CIDS CAUTION LIGHT ON. FOUND SYS STATUS SHOWING LAVATORY SMOKE SYS FAIL WITH NO SDCU 1 & 2 DATA. REPLACED SDCU, NO HELP. REINSTALLED ORIGINAL UNIT. TROUBLESHOOTING DATA FAULTING FWD LAVATORY DETECTOR IAW MT 26-002.SDR CALA2013120693510Unknown · malfunctionedAFT CARGO SMOKE TEST FAILED.SDR CALA2013103092512Hydraulic Line · leakingHYD FLUID DRIPPING FROM AFT CARGO PIT CEILING, FWD END RT SIDE. YELLOW & GREEN SYSTEM RESERVOIRS AT REFILL. FOUND YELLOW SYS HYD LINE LEAKING JUST BELOW T FITTING IAW IPC 52-36-04-02C LINE-ITEM 170, PCN110-2740-PN-D291709020600. REPLACED SECTION OF LINE & SPSDR CALA2013100491730Oxygen Mask · unsecurePASSENGER SEAT OVERHEAD 02 MASK FELL AT 24ABC. PERFORMED MT 35-003 ALL PARTS LOOK NORMAL NEEDS MASK DROP TEST.SDR CALA2013100391700Battery · failedAFT LT EMERGENCY LIGHT BATTERY FAILED TEST. R & R EMERGENCY POWER SUPPLY BATTERY FOR 13-WL EPSU IAW AMM 33-51-38.SDR CALA2013092791526Anti-Ice System · inoperativeCAPTAIN'S SLIDING WINDOWS HEAT INOPERATIVE.SDR CALA2013082190621Fluid · leakingCLEANED UP RED FLUID OFF THE BELLY FROM THE AFT CARGO DOOR TO THE REAR OF THE AIRCRAFT. FOUND RED-FLUID UNDER THS ACTUATOR, FLUID IS LEAKING OUT ACCESS PANEL BOTTOM OF TAIL & RUNNING FORWARD. CLEANED OFF RED FLUID FOUND NO LEAK OR TROUBLE. AUDIO CONTROL PANSDR CALA2013081990505Deu · inoperativeBOTH COCKPIT AND FORWARD F/A ARE UNABLE TO TALK TO F/A IN AFT OF ACFT VIA INTERCOM. AFT HANDSET INOPERATIVE, R & R DEU B POSITION 300-RH-1. DISCOUNTED ALL CONNECTORS AT AFT FA SEAT ASSY, RECONNECTED, OPS CHECKED NORMAL OF AFT AND FWD HANDSETS.SDR UALA2013072205140Bearing · crackedAT ARRIVAL FOUND AFT CARGO DOOR DAMAGED AT AND AROUND DOOR OPEN LEVER AND WAS UNABLE TO OPEN DOOR. FOUND BEARING ASSY CRACKED ITEM 140 IPC 52-32-21-03 ON AFT CARGO HANDLE ASSY. INSTALLED STOP SCREWS IN NEW HANDLE ASSY. BLENDED DENTED AREA TO REMOVE STRESS RSDR UALA2013071705017Computer · failedRIGHT WINDSHIELD ANTI-ICE DISPLAYED ON UPPER ECAM SCREEN. LAST LEG REPORT SHOWS RT WINDSHIELD SENSOR. RT WINDOW HEAT COMPUTER IAW TSM 30-42-00. OPS NORMAL.SDR UALA2013032501815Switch · missingCOVER ON FIRST OFFICERS SIDE STICK RADIO SWITCH MISSING. REPLACE HANDGRIP PER MAINT TIP 23-012. INSTALLED NEW COVER.SDR UALA2013021200840Servo · faultedAILERON DAMPING TEST DOES NOT PASS TEST EFCS NR 1 & 2 IN DOWN FACTOR IN THE LEFT AILERON. REPLACED LEFT AILERON SERVO IAW AMM. PERFORMED OPERATIONAL & DAMPING TEST OF SERVO'S WORKS OK, ACFT RETURNED TO SERVICE.SDR UALA2012113006874Nut · strippedCOCKPIT DOOR HARD TO LATCH. FOUND DOOR ADJUSTMENT NUT STRIPPED PREVENTING PROPER DOOR ADJUSTMENT. REPLACE WORN NUT AND ACCOMPLISHED ADJUSTMENT AND TEST OF DOOR PER AMM.SDR UALA2012111906658Door · missingLEFT VEST DOOR FOR 2ND OBSERVER IN THE FLIGHT DECK IS MISSING. SEAT IS INOP, SHOULD HAVE COVER AND VEST. AC NOT ON COA LIST, NEED COVER AND VEST.SDR UALA2012111206491Oxygen Bottle · unknownOXYGEN PRESSURE WENT FROM 870 TO 820 PSI OVER 2 1/2 HOURS WITH NO USE. SERVICED CREW O2 BOTTLE. OPS CHECKED GOOD, NO LEAKS NOTED.SDR UALA2012111206516Regulator · leakingCREW OXYGEN SYSTEM LOW. FOUND FIRST OBSERVERS O2 REGULATOR LEAKING. BOX AND CRUSH GASKET HAVE BEEN REPLACED WITH NO LEAKS.SDR UALA2012101005763Handle · unsecureCARGO DOOR OPEN EICAS, RTFL. FOUND AFT CARGO DOOR NOT RECESSED AND FAIRED WITH CARGO DOOR SKIN. HANDLE WAS STICKING OUT THREE QUARTERS OF AN INCH. CYCLED DOOR AND SECURED DOOR HANDLE RECESSED FLUSHED TO DOOR SKIN. DOOR HANDLE FLAP DOES ENGAGE AND LOCKS HANSDR UALA2012091805271Control Panel · faultyFOUND ENGINE AND APU FIRE PANEL 1WD CAUSE OF DISCHARGE LEGEND OF ENGINE 2 AGENT 1 INSTALLED PANEL PER AMM. NEED TO OP CHECK PER AMM(S) 26-22-00-710-004 26-22-00-710-001 26-12 -00-710-001, 26-21-00-720-001 & 26-21-00-720-005. OPS CHECKED GOOD. ENG 2 PANEL 1WSDR UALA2012091005080Indicator · stuckPACK MAINT STS CLASS II MESSAGE DISPLAYED ON LOWER ECAM. PREV LEGS REPORTS SHOWS 21-51-51 'P1 FLOW CONT VALVE' 11HB MSG 7 TIMES IN THE LAST FEW DAYS. TROUBLESHOT IAW TSM 21-51-00-810-803-A, PERFORMED OP'S TEST OF PACK TEMP CONT SYSTEM IAW AMM 21-61-00-710-00SDR UALA2012090605024Bracket · brokenCOCKPIT CRASH AXE INBOARD SADDLE CLIP-BRACKET BROKEN AND SECURING STRAP MISSING. REPLACED CLIP AND STRAP.SDR UALA2012090404942Oxygen Mask · no testDURING OXYGEN MASK MANUAL RELEASE CHECK, MASKS SEATS 3E AND F DID NOT DROP. REPACKED OXYGEN MASK ASSY AND OPS CHECKED MANUAL MASK RELEASE, OPS CHECKED GOOD.SDR UALA2012081704581Lens · brokenPAX SIDE AISLE EMERGENCY LIGHT LENS BROKEN. REPLACED EMERGENCY LIGHT. OPS CHECKED GOOD.SDR UALA2012081704580Battery Pack · inoperativeEMERGENCY LIGHT TEST INDICATES 'BATTERY AFT LT'. REPLACED BATTERY PACK AND OPS CHECKED GOOD.SDR UALA2012080304148Wire · brokenTWO BROKEN WIRES ON WALL AFT OF DOOR 2R, EXIT LIGHT IDENTIFIER. REPAIRED WIRES PER ESPM 20-53-21, TYPE 1 REPAIR. OPS CHECKED NORMAL REF MM33-51 -00-710-002-C.SDR UALA2012072303984Support · crackedRT WHEEL WELL KEELBEAM SUPPORT ANGLE FOR FUSELAGE FAIRING IS CRACKED JUST AFT OF AFT DOOR HINGE AT FRAME 46.SDR UALA2012072303983Support · crackedLT WHEEL WELL KEELBEAM SUPPORT ANGLE FOR FUSELAGE FAIRING IS CRACKED JUST AFT OF AFT DOOR HINGE AT FRAME 46.SDR UALA2012072303964Stringer · corrodedAFT CARGO BAY STRINGER 31R IS CORRODED BETWEEN FR 64 AND 66. REPLACED STRINGER SECTION PER SRM.SDR UALA2012052502923Seal · wornAIRFRAME VIBRATION, FL200 UP TO FL340, MORE NOTICEABLE IN CLIMB THAN LEVEL FLT. ACCOMPLISHED TSM CHART 05-50-00 PB201 AND INFORMATION FROM VIBRATION SURVEY SUGGESTS BELLY FAIRING SOURCE OF VIBRATION. TAPED BELLY FAIRING SEALS REF MT53-004. FOUND SEAL WORN ONSDR UALA2012040502119Sensor · faultyECAM IN FLIGHT. DOOR R AFT CABIN. LASTED 1 MINUTE. DOORS PAGE SHOWED OPEN. REPEAT GRIPE. REPLACED SENSOR 17WV2 & ADJUSTED PER MM, CHECKED GOOD.SDR UALA2012032601908Oxygen Mask · unwanted deployCREW REPORTED O2 MASK DEPLOYED AT ROW 36 DEF. STOWED MASK LATCH AND CLOSED NORMAL. ACCOMPLISHED 02 MASK DROP CHECK. IAW AMM.SDR UALA2012031201619Seat · detachedROW 36 ABC DETACHED FROM FLOOR. SECURED SEAT ROW.SDR UALA2012030501379Floor Panel · damagedFLOOR SOFT IN AISLE BETWEEN ROW 35 & 36 BY FLIGHT ATTENDANT. AREA MEASURES 18' X 18' BETWEEN FRAME 61 AND 62. REPLACED CABIN FLOOR PANEL.SDR UALA2012011300276Seat · defectiveFIRST OFFICER SEAT, MANUAL HORIZONTAL ADJUSTMENT DEFECTIVE. REPLACED SEAT ASSY.SDR UALA2012010900199Pinion · failedCAPTAIN'S RUDDER PEDAL ADJUSTMENT INOPERATIVE. PEDALS DO NOT SPRING BACK FROM FULL FWD POS WITH HANDLE. REPLACED THE AIR PINTON, OPS CHECKED GOOD.SDR UALA2011121206816Fire Warning · false indicationAT GATE HAD A FALSE INDICATION OF A AFT CARGO FIRE. CYCLED BREAKERS. BITE TESTED PER AMM. TESTED OKAY.SDR UALA2011110906132Engine · vibrationCREW REPORT: NOTICEABLE LOUD ROAR AND VIBRATION ON NR 2 ENGINE THROUGHOUT FLIGHT SAMC TEXT: PER CREW. HIGHEST VIBRATION NR 2 ENGINE WAS 2.0. THROTTLES BROUGHT TO IDLE, VIBS DECREASED. FELT ON FLOOR. FBO TO ACCOMPLISH INLET AND EXHAUST CHECK PER MT 72-021 ANSDR UALA2011110706014Toilet · defectiveLAVATORY TOILET BOWL OVERFLOWING AT AFT CABIN LT FWD LAV. INOP AFT FWD LAV. REPLACED AFT-FWD TOILET, OPS CHECK OK.SDR UALA2011091605007Slide · faultyEXT LOADS FWD L' FAULT WHEN PERFORMING EMERGENCY LIGHTS TEST. ORDERED SLIDE TO TROUBLESHOOT THE FAULTY SLIDE. NOT ABLE TO TROUBLESHOOT DUE TO WORK ON RT FWD DOOR. SLIDE IS IN LSR DROP. T/S EMG LIGHT TEST. DUAL SLIDE LIGHT FAILURES DOOR 1R AND 1L.SDR UALA2011062003011Lanyard · dislodgedA CORD IS HANGING DOWN FROM SLIDE PACK AT DOOR 1R. RESTOWED CORD IN SLIDE PACK.SDR UALA2011040801701B-Nut · leakingUPON REMOVING OIL CAP TO SERVICE NR 2 ENG OIL FOUND VERY STRONG FUEL SMELL COMING FROM OIL TANK. ACP'D INSPECTION AND CHECK OF FUEL OIL COOLER, NO PROBLEMS NOTED. FOUND MAIN FUEL SUPPLY LINE B-NUT WITH SMALL SEEPAGE. TIGHTENED B-NUT AND IDLE LEAK CHECKED GOSDR UALA2011040601667Light · no testEMERGENCY LIGHT TEST FAILED MESSAGE EXT LOADS FWD L. TROUBLESHOT PER TSM. CONNECTED TESTING TOOL AT DOOR 1L TEST PASSED.SDR UALA2011032301396Oxygen Mask · unwanted deployOXYGEN MASKS DROPPED AT 18DEF. REPACKED MASKS PER AMM, DROP CHECK PER MM, OPS CHECK GOOD.SDR UALA2011032101331Wire · out of positionCABIN EMERG LIGHTING CHECK RESULT SHOWED ATA 33-51-38 INT LOADS EMER L. FOUND EXT AND INT LIGHTS FLASHING ON 11W EPSU. TRIED NEW BATTERY AND EPSU NO HELP. 11W DISCONNECTED FROM AIRCRAFT. REPLACED EPSU 11W AND BATTERY PACK, NO HELP. FOUND WIRES BELOW SEAT ROWSDR UALA2011030201031Power Supply · failedCABIN EMERGENCY LIGHT TEST FAILED ON 3 SERVICE. REPLACED POWER SUPPLY 110W L2. CABIN EMERGENCY LIGHT TEST PASSED, OPS CHECKED NORMAL.SDR UALA2010122804743Slide · faultyEMERGENCY LIGHT TEST FAILS WITH "EXT LOADS FWD L" MESSAGE. INSTALLED TEST LIGHT FIXTURES ON BOTH FWD SLIDES TO GET TEST TO PASS. FWD EMERGENCY LIGHT POWER SUPPLY AND BATTERY REPLACED (PN 3214, SN 390), NO HELP. REPLACED SLIDES. OPS CHECKED NORMAL.SDR UALA2010112904372Wire · transposedNO SMOKING SIGN BURNED OUT OVER AFT FLT ATTENDANT JUMP SEAT. RELAMPED, NO HELP. FOUND WIRES TO TERMINALS 2 AND 3 TRANSPOSED. SWAPPED WIRES AND LIGHT CHECKS GOOD IN PROPER SEQUENCE.SDR UALA2010100403677Battery · failedLEFT MID EMERGENCY LIGHT BATTERY FAILS SELF TEST. REPLACED BATTERY, ALL SYS CHECKED OK.SDR UALA2010071402522Slide · no testFAILS PTP TEST. FWD LT LOAD. CHANGED RT SLIDE. REPLACED RT FWD DOOR ESCAPE SLIDE. OPS ARE NORMAL.
Back to N428UA