N402UA
Service difficulty reports · 143
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 = 'N402UA' 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 = 'N402UA' 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 CALA2013123094032Fastener · looseTWO FASTENERS LOOSE UNDERBELLY FWD OF RT PACK INLET DOOR. TIGHTENED TWO FASTENERS UNDER BELLY FWD OF RT PACK INLET DOOR.SDR CALA2013120993537Solenoid · faultyAPU WILL NOT START HANGS AT 17% THEN AUTO SHUTS DOWN. AHM ASD RPT 14 INDICATES NO FLAME. HOWEVER DATA ALSO INDICATES POSSIBLE COLD SOAK, EGT NEVER GOT ABOVE -8C, OIL SUMP TEMP -18C & LCIT -16C. DRILL DOWN MCDU TO APU FAULTS CONDITION PG & NOTE LRU ID & TROSDR CALA2013111292854Table · bindsFIRST OFFICER'S FLIGHT DECK TABLE IS BINDING. NEEDS ADJUSTMENT WHEN IN THE FULL OPEN SETTING, IT WOBBLES UP & DOWN. REPLACED ROLL PIN, OPERATIONS CHECKED GOOD.SDR CALA2013110192558Fuse · faultyBCL 2 FAULT DISPLAYED ON UPPER ECAM SCREEN, ELECTRICAL. REPLACED FUSE 4PB2 IAW WD24-38-01. CHECKED NORMAL IAW 24-38-00-710-001.SDR CALA2013091191201Cover · missingEMERGENCY LIGHTS BUTTON ON AFT FLIGHT ATTENDANT PANEL MISSING CLEAR PROTECTIVE COVER. COMPLIED WITH MEL 2373AU.SDR CALA2013090991098Switch · intermittentFIRST OFFICER`S MIC SWITCH ON SIDE STICK STILL INTERMITTENT. FIRST OFFICER`S SIDESTICK TRIGGER SWITCH ARE CAPPED & STOWED.SDR CALA2013090691089Cover · missingEMERGENCY LIGHTS BUTTON ON AFT FLIGHT ATTENDANT PANEL MISSING CLEAR PROTECTIVE COVER. IAW MEL 2373AU.SDR CALA2013082790784Uplock · malfunctionedLANDING GEAR RETRACT, RETURN TO FIELD. REPLACE RT UPLOCK.SDR CALA2013082390694Indicator · failedEIS 2 WOULD NOT TEST. REPLACED CFDIU REF AMM 31-32-34. MR31333-71 "ON" SN C12860007285 "OFF" REF TSM 31-32-00 MX MESSAGE NO DMC 2 DATA STILL PRESENT. FOUND NO CONTINUITY BETWEEN CFDIU AB 6F AND DMC2 AB 1C. REPAIRED WIRE 3132-7386 AND REINSTALLED ORIGINAL CFDSDR CALA2013080890260Wire · misrepairedELECTRIC HYD PUMP WIRES ARE TERMINATED WITH BLACK ELECTRIC TAPE AND CARGO TAPE. REMOVED BLACK TAPE. LUGS ARE INTACT ON WIRES. SECURED WIRES TO C-B 3802GX, REF W-D 29-24-01. YELLOW PUMP TEST GOOD BY EXTENDING CARGO DOOR ON GROUND POWER ONLY.SDR UALA2013053003778Circuit Breaker · trippedLOST E-WD AND F/O SCREENS. LOST BRAKE, SYS 2. FOUND THAT CB "BUS 2-204XP SPLY"(50A), LOCATION: AB2 AT 123VU PANEL HAD TRIPPED, RESET AND ALL AFFECTED SYS INCLUDING THE F/O'S PFD & ND PLUS THE LWR ECAM SCREENS RETURNED TO NORMAL. RAN BOTH ENGINES FOR 10 MINUTSDR UALA2013050603158Hinge Pin · missingOXYGEN MASK DOOR ON FIRST OFFICER`S SIDE IS DAMAGED. FOUND OXYGEN MASK COMPARTMENT COVER MISSING HINGE PIN AT LEFT UPPER CORNER. REPLACED PIN.SDR UALA2013050203065Bullnose · dentedRAMP REPORTED DENT IN LEFT BULLNOSE OF NR 3 SLAT. ACCOMPLISHED PERMANENT REPAIR IAW SRM.SDR UALA2013042302812Switch · faultyCREW REPORT: F/O COMM-MIC TRIGGER INTERMITTENT. CUTS OUT. COMM PANEL MIC SWITCH OK. DEACTIVATED F/O SS PTT SWITCH. DF STICKER APPLIED.SDR UALA2013042202766Control Unit · faultyRIGHT TRANSFER VALVE OPEN DISPLAYED ON UPPER ECAM SCREEN. LEFT AND RIGHT TRANSFER VALVES OPENED AS EXPECTED BUT WERE ACCOMPANIED BY ECAM MESSAGES. LEFT TRANSFER VALVE OPEN DISPLAYED ON UPPER ECAM SCREEN. REFUELING PANEL BATTERY POWER SWITCH MUST NOT BE SDR UALA2013041802651Sdac · intermittentOVERWING SLIDE INDICATION IS INTERMITTENT. VERIFIED LT OVERWING SLIDE IS ARMED. REMOVED AND REPLACED OF NR 1 SDAC, OVERWING SLIDE INDICATION OPS CHECKED GOOD.SDR UALA2013040402235Seat · looseSEAT ROW 32 DEF LOOSE IN SEAT TRACK. SECURED SEAT ASSY, OPS CHECKED GOOD. VERIFIED SEAT PITCH AND SECURITY.SDR UALA2013012400443Valve · leakingAFT CARGO HEAT ECAM MESSAGE DISPLAYED. REPLACED AFT CARGO HEATING PRESSURE REGULATING VALVE PER AMM. LEAK AND OPS CHECKED GOOD.SDR UALA2013011600258Bracket · damagedHALON EXTINGUISHER IN BACK CABIN HAS DAMAGED BRACKET. REPLACED BRACKET.SDR UALA2012120306908Brake · wornNR 3 BRAKE IS WORN TO ULTIMATE LIMIT AND NEEDS TO BE REPLACED. RESET NR 3 BRAKE SAFETY VALVE AND FLOW AND BRAKE ACTUATION NOW NORMAL. BRAKE ASSY REPLACED UNDER SEPARATE WRITE UP.SDR UALA2012120406963Brake Sys · inoperativeNUMBER 3 BRAKE 60 NUMBER 4 BRAKE 390. ACTUATED RT BRAKE AND WITNESSED PUCK MOVEMENT ATTEMPTED BRAKE BLEED OF NORMAL AND ALTERNATE SYSTEMS AND GOT GOOD FLOW OUT OF GREEN BLEED PORTS NO FLOW OUT OF YELLOW BLEED PORTS RENDERED NR 3 MLG BRAKE YELLOW SYSTEM INOP PSDR UALA2012110506337Seat · looseSEAT 32D IS LOOSE IN TRACKS. FOUND FLOOR TRACK ATTACH FOOT ON SEAT ASSY WITH WORN STAR FASTENER. REPLACED FASTENER AND SECURED.SDR UALA2012102306081Start Valve · faultyNR 2 ENGINE NO STARTER CUTOUT ON START. REPLACED STARTER AND REPLACED START VALVE. ACP ENGINE START AND OP'S CHECKED NORMAL.SDR UALA2012101805958Carpet · out of positionDOOR 2L WILL NOT ARM AND APPEARS TO BE JAMMED. FOUND CARPET COVERING GIRT BAR FITTING. REPOSITIONED CARPET AND DOOR ARMED WITH NO FURTHER PROBLEMS.SDR UALA2012082304714Sliding Window · stuckCAPTAIN'S WINDOW STUCK OPEN. SECURED CAPTAIN'S COCKPIT SLIDING WINDOW CLOSED.SDR UALA2012072504031Paint · peelingRADOME PEELING PAINT IS NOT WITHIN LIMITS. ACCOMPLISHED PAINT PER MM 51-75-11.SDR UALA2012072003953Coupling · leakingLT WING LOOP 'A' MESSAGE. FOUND AIR DUCT LEAK AT SLIP COUPLING, REPLACED SEAL.SDR UALA2012071803882Sleeve · damagedINBD BLOCKER DOOR AT 7 O'CLOCK POS ON NR 2 ENGINE HAS TWO BROKEN SUPPORT FITTINGS AND ONE BENT CONTROL ROD. FOUND ON LANDING. REPLACED NR 2 TRANSLATING SLEEVE PER MM.SDR UALA2012070503614Controller · faultyCFDS TEMP CONTROL TEST IN CDU FAULTS P1 AND P2 CONTROLLERS. REPLACED NR 1 PACK TEMP CONTROLLER (7HH) PER MM. DURING OPS TEST OF CABIN TEMP CONTROLLER, FAILS NR 1 PACK RAM AIR IN ACTUATOR (8HH).SDR UALA2012061103179Handle · unsecureAFT CARGO DOOR ECAM ON TAKEOFF ROLL. FOUND AFT CARGO DOOR HANDLE POPPED OUT, CLEANED AND LUBED DOOR HANDLE AND OPS CHECKED OK WITH HANDLE STOWED AND LIGHT CHECKED OK REF MT 52-019.SDR UALA2012052702958Battery Pack · failedON NR 3 SERVICE DOOR, EMERGENCY LIGHT CHECK, FAILED FWD LEFT BATTERY PACK. REPLACED FWD LEFT BATTERY PACK PER MM, OPS CHECKED GOOD.SDR UALA2012032901971Girt Bar · out of adjustDOOR 2L WILL NOT INDICATE ARMED. ADJUSTED GIRT BAR, OPS CHECK OKAY.SDR UALA2012022801223Wire · brokenCABIN - NR 2 RT PAX-CREW DOOR SLIDE- RAFT P/N MR25115-028 ELECTRICAL WIRES ARE BROKEN. FROM BASE WRITE-UP L3760M. (NOTE: WIRES APPEAR TO HAVE BEEN BROKEN WHILE SLIDE RAFT WAS IN STORAGE DURING DOOR MAINTENANCE. REPLACED 2R DOOR SLIDE.SDR UALA2012022101055Window · out of toleranceLT FIREX WINDOW DAMAGED. REMOVED AND REPLACED LT FIREX WINDOW.SDR UALA2012022101045Container · no testRT SEAT ROWS NR 1 & 2 - O2 CONTAINER FAILED TO OPERATE DURING MANUAL RELEASE TEST. REPLACED CONTAINER ASSY PER MM. OPS CHECKED GOOD.SDR UALA2012021700957Container · no testLEFT SEAT ROWS NR 1 & 2 O2 CONTAINERS FAILED TO OPEN DURING MANUAL RELEASE TEST. REPLACED CONTAINER ASSY PER MM, OPS CHECKED GOOD.SDR UALA2011072203737Extinguisher · out of toleranceFIRE EXTINGUISHER IN AFT CABIN MISSING SAFETY WIRE. REPLACED AND SECURED WATER FIRE EXTINGUISHER.SDR UALA2011070103227Battery · faultyNR 2 SHIP BATTERY IS DRAWING 60 AMPS. REPLACED NR 2 BATTERY & NR 2 BCL PER MM.SDR UALA2011062703134Fuse · faultyINTEGRAL LIGHTING OVERHEAD PANEL INOP. LIGHTS CREW COMMENTS: BACKGRND LGTS FOR FUEL AND FIRE PANEL ON OVHD INOP. REPLACED FUSE IN 6LF CONTROLLER. PANEL BACKGROUND LIGHT OP CHECK GOOD.SDR UALA2011061502949Motor · malfunctionedWATER SYSTEM C-B AT 2001VU POPPING. FOUND DRAIN VALVE 14MP POPPING C-B AND OVERFILL VALVE DRIVING OPEN 8MP. WITH CONNECTOR REMOVED C-B STAYS CLOSED. CONNECTOR REMOVED, CAPED AND TYED BACK. WILL NEED TO BE MANUAL FILL. VALVES LOCATED IN FWD PIT BEHIND RT AFTSDR UALA2011060602738Coupling · corrodedCOUPLING ON LAV TANK DUMP TUBE FOUND CORRODED. EXPANDED BROKEN AND FLUID LEAKING FROM SAME. REPLACED O-RINGS AND COUPLINGS, LEAK CHECKS OKAY.SDR UALA2011060802798Unknown · leakingFOUL ODOR THROUGHOUT ACFT. FLEW ACFT LAST 2 DAYS. NOTICED POOL OF BLUE WATER FROM SMALL AREA IN REAR PIT.SDR UALA2011060602739Cone · crackedNR 2 ENGINE EXHAUST CONE HAS MULTIPLE CRACKS ON THE FWD END BETWEEN APROX 8 O'CLOCK AND 10 O'CLOCK POSITION AND HAS A 2 1-8" CRACK AT THE AFT END AT 9 O'CLOCK POSITION. REPLACED EXHAUST CONE PER MM. ROBBED EXHAUST CONE FROM ENG 2 ACFT 4238.SDR UALA2011030801137Bracket · brokenAFT CABIN FWD LAVATORY UNDERSINK VANITY DOOR BROKEN. DOOR HINGE BROKEN AWAY FROM VANITY ASSEMBLY. PART OF FIRE INTERGRITY OF LAVATORY FIRE EXT SYSTEM. LAVATORY NOT USEABLE. INSTALLED NEW BOTTOM BRACKET.SDR UALA2011030701084Bypass Switch · leakingABNORMAL ODOR IN COCKPIT AND CABIN DURING CLIMB AND DESCENT. FLT ATTENDANTS REPORTED ODOR CAUSING EYE AND THROAT IRRITATION AND WAS STRONG IN THE CABIN. ACCOMPLISH TROUBLESHOOTING STEPS AS OUTLINED IN MT 72-016. TROUBLESHOOTING TO INCLUDE BORO OF HPC STAGESSDR UALA2011022100868Accumulator · overservicedDOOR 1L SLIDE ARMING LEVER IS STIFF DIFFICULT TO ARM. FOUND DOOR DAMPNER ACCUMULATOR OVERSERVICED. SERVICED TO CORRECT PRESSURE IAW AMM.SDR UALA2010122904758Linkage · looseDOOR 1L DIFFICULT TO CLOSE. DOOR L/E IS .75 TO 1 INCH FROM FAIRED WHILE DOOR T/E IS FLUSH WITH FUSELAGE. PULLING ON DOOR HANDLE FROM INSIDE DID NOT HELP, COULD NOT LOCK DOOR. DOOR WILL CLOSE SOMETIMES BUT NOT AFTER OPENING ALL THE WAY. DOOR PIVOT POINTS ANSDR UALA2010122104676Light · no testEMERGENCY LIGHTS CHECK FAILED ON 3 SVC. RESET EMERGENCY LIGHT CB, OPS TEST NORMAL.SDR UALA2010072302628Module · malfunctionedABORTED TAKEOFF 80-100 KNOTS DUE TO F/O AIRSPEED IND MALFUNCTION. REPLACED ADM 19FP2 PER MM. OPS NORMAL.SDR UALA2010071202456Lanyard · brokenLEFT SLIDE HAS GIRT BAR LACING BROKEN. REPLACED SLIDE ASSY IAW MM. OPS TEST IAW MM.
Back to N402UA