N401UA
Service difficulty reports · 141
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 = 'N401UA' 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 = 'N401UA' 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 CALA2013123094031Manifold · leakingHYD LEAK NEAR NORMAL BRAKE SERVO VLV ON THE RT MLG. R & R BRAKE MANIFOLD ASSEMBLY IAW MM 32-42-16 TO STEP E & REQUIRE COTTER KEY INSTALLED & SEALANT.SDR CALA2013122093843Window · defectiveCAPTAIN'S FIXED SIDE WINDOW'S VISIBILITY IS AFFECTED BY DEFECTS. REPLACED CAPTAIN`S FIXED WINDOW IAW AMM 56-11-12-400-002-A, OPERATIONS CHECKED GOOD.SDR CALA2013102392300Connector · dirtyLGCIU 1 FAULT DISPLAYED ON UPPER ECAM SCREEN LG. CLEANED PLUGS ON LT MLG DOOR UP LOCK SENSORS 27GA & 29GA. RESET LGCIU1 CB RAN BITE ON LGCIU1 USING MCDU IAW MM 32-69-00-740-001-A, NO FAULTS FOUND. ECAM STATUS IS NORMAL.SDR CALA2013102192199Door Seal · leakingFLIGHT ATTENDANT REPORTS PRESSURE LEAK AT DOOR 2L. PRESSURIZED A-C FOUND AFT LOWER CORNER LEAKS & SMALL LEAK AT FWD LOWER CORNER, HAS HISTORY. REPLACED DOOR SEAL IAW MM.SDR CALA2013082690722Switch · inoperativeFWD FLIGHT ATTENDANT CALL CHIME FROM COCKPIT INOP-INTERMITTENT. REPLACED FWD FLIGHT ATTENDATNT PUSH BUTTON SWITCH INSIDE COCKPIT, OPERATIONS CHECKED GOOD.SDR UALA2013062004274Skin · damagedLEFT WING TANK PLATE LANDING AT 540PB HAS 2EA ELONGATED HOLES. REPAIRED IAW REO-L01400 AND ECRA 5720-02413. CAT "B" REPAIR.SDR UALA2013062004273Skin · damagedLEFT WING TANK PLATE LANDING AT 540LB HAS 1EA ELONGATED HOLE. REPAIRED IAW REO-L01400 AND ECRA5720-02413. CAT "B" REPAIR. MAJOR REPAIR.SDR UALA2013062004272Access Panel · damagedRIGHT WING FUEL TANK LANDING AT 640HB HAS 1 EA DAMAGED HOLE. MAJOR REPAIR. HOLE REPAIRED IAW REO-L01401 AND ECRA 5720-02412. THIS REPAIR HAS NO SUPPLEMENTAL INSPECTIONS REQUIRED. THIS ITEM CREATED FOR MAJOR REPAIR -SDR REPORTING.SDR UALA2013061904236Panel · damagedRT WING FUEL TANK PANEL 640MB HAS 4 HOLES REPAIRED IAW SRM. TOTAL OF 5 HOLES REPAIRED ON RT WING PANEL 640MB NOT 4 DURING LCQ CK TO WHICH SRI APPLIES.SDR UALA2013061904233Skin · damagedRIGHT WING TANK LANDING FOR PANEL 640NB HAD ONE HOLE REPAIRED IAW SRM. REPAIR REQUIRES GENERAL VISUAL INSPECTION EA 3600C OR 4500T WHICHEVER OCCURS FIRST IAW SRI 57-21-11-2-002-00, TBL 203. NOTE: ACFT HAS EXCEEDED ORIGINAL INSP CRITERIA OF 54,600 T. BY- 0866SDR UALA2013061904232Panel · damagedRT WING TANK LANDING FOR PANEL 640KB HAS 1 BOLT HOLE REPAIRED IAW SRM. REPAIR REQUIRES GVI INSPECTION EA 3600C OT 4500 T WHICHEVER COMES FIRST IAW SRI 57-21-11-2-002-00 TBL 20. NOTE: INITIAL INSP CRITERIA OF 54,600 T HAS BEEN EXCEEDED.SDR UALA2013041802656Actuator · leakingLARGE FLUID PUDDLE IN FRONT OF LEFT MAIN LANDING GEAR. RUNNING FROM ACTUATOR. REPLACED LEFT MLG LOCKSTAY ACT PER AMM. OPERATIONAL AND LEAK CHECK GOOD.SDR UALA2013041502537Floor Panel · delaminatedFWD CARGO COMPT FLOOR PANEL 131AF DELAMINATED NEAR AFT RIGHT CORNER. REMOVED FLOOR PANEL 131AF INSTALLED SERVICEABLE FLOOR PANEL PER.AMM 53-22-14-400-001-A CONTINUTE FROM PG 3 OF 5 PAR.B7. ACCOMPLISHED FINAL INSTALLATION OF FLOOR PANEL PER MM.SDR UALA2013030101227Trim Panel · out of positionCREW REPORT: ROW 24DEF LOWER BULKHEAD TRIM PIECE STICKING UP. STRAIGHTENED METAL TRIM AND TAPED IN PLACE. NO PASSENGER HAZARD.SDR UALA2013022601165Rub Strip · unsecureCREW REPORT: 6 IN SEAL HANGING FROM ENG 2. FOUND TO BE THE ENG 2 REV LOWER DOOR TEFLON STRIP HANGING OUT AND LOOSE. REPAIR SEAL PER MT78-016 REPAIR PROCEDURE 2C. INSTALLED NEW LATCH DOOR SEAL.SDR UALA2013022201077Spinner · damagedENGINE 2 SPINNER HAS MINOR DAMAGE. REMOVED NR 2 ENGINE CONE SPINNER REF AMM 72-38-11-000-010-A 13 & INSTALLED NEW SPINNER CONE.SDR UALA2013012800508Floor Panel · damagedROW 11 AISLE FEELS SPONGY. REPLACED AISLE FLOOR PANEL ROW 10 AND 11ABC.SDR UALA2013011600257Fastener · missingENGINE 2 EXHAUST NOZZLE LOWER FIXED STRUT HAS ONE MISSING RIVET AFT MOST HOLE INBOARD SIDE. LOWER STRUT FAIRING AT 6:00 INBOARD IS MISSING ONE FASTENER. PER MT78-001 ITEM N (2) REPLACED MISSING FASTENER.SDR UALA2013010900175Socket · looseEMERGENCY LIGHT TEST FAILED. MAINTENANCE MESSAGE ON F/A PANEL IS "EXT LOADS EMER R". REPLACED LAMPS EXTERNAL EMERGENCY LIGHTS. FOUND LOOSE SOCKET. SECURED SOCKET. OPS CHECKED GOOD.SDR UALA2012122407386Pump · faulty'G' HYD SYS LOSS, RTFL. PERFORMED MANUAL GEAR EXTENSION. REPLACED NR 1 ENGINE DRIVE PUMP AND FILTERS. SERVICED SYSTEM OPS AND LEAK CHECKS GOOD.SDR UALA2012121007122Panel · inoperativeATTENDANT CALL INDICATOR PANEL INOPERATIVE AT 998 (LOCATION NOT DEFINED - CHECK CABIN FORM FOR SPECIFIC LOCATIONS). CREW COMMENTS: PANEL AT DOOR 2L INOP. FOUND TO BEGIN WORKING NORMALLY ON GROUND DENVER DUE TO PREVIOUS HISTORY REPLACED AFT ATTENDANT PANEL SDR UALA2012112606746Screen · damagedNR 2 ENGINE, LEFT C-DUCT INNER WALL SHOWS WIRE MESH SCREEN DAMAGE. ACCOMPLISHED PERMANENT REPAIR REF MT 78-010.SDR UALA2012112606764Control Panel · inoperativeCAPT MIC STAYS HOT AND UNABLE TO SELECT VHF NR 1 AND VHF NR 2. SWITCHED TO CAPT ON 3 AND CLEARED HOT MIC. OK TO DF REF MEL 2351AK. REPLACED CAPT ACP. INSTALLED NEW ACP AMM & TESTED PER AMM. ALL TESTS OKAY. REV'D DF #060 AC OK FOR SERVICE.SDR UALA2012111206474O-Ring · leakingWATER COMING OUT OF 4 DRAIN HOLES LOCATED BETWEEN FWD CARGO COMPT AND WING ROOT. REPLACED POTABLE WATER TANK LOWER SERVICE LINE FITTING O-RING. PRESSURE LEAK TEST REF AMM 38-10-00-614-001A CHECK GOOD. PERFORMED WATER CLEAN UP REF GNMM 4-06-004.SDR UALA2012102206040Radome · damagedLOUD THUMP ON UNDERSIDE OF COCKPIT DURING DESCENT. SUSPECT POSSIBLE BIRD STRIKE. FOUND 5" CIRCULAR DAMAGE AREA LOWER LEFT OF RADOME. PER AMM OUT OF LIMITS, DISBOND OF SKIN TO HONEYCOMB.SDR UALA2012100805671Circuit Breaker · faultyL WING LEAK EICAS, FLIGHT DIVERTED. RESET CB D11, D12.Z22, Z23, F1, Q 7. NO FAULTS NOTED. PERFORMED BITE TEST OF BMC 1 & 2. NO FAULTS NOTED. PERFORMED IDLE RUN ON ENGINE 1 AND 2 FOR 5 MINS, RUNNING BOTH BLEED SYS. NO FAULTS NOTED.SDR UALA2012082704781Power Supply · faultyMESSAGE 'EXT LOAD BAT RT' APPEARED ON CIDS SCREEN DURING 3SV EMERGENCY LIGHT TEST. REPLACED RIGHT SIDE BATTERY SUPPLY-CABIN EMERGENCY EXIT ALONG WITH BATTERY AND EXT OVERWING LIGHT BULB. EMERGENCY LIGHT A TEST OKAY.SDR UALA2012041502265Socket · dirtyEXT OVERWING EMERGENCY LIGHTS INOPERATIVE BOTH SIDES OF ACFT. TROUBLESHOT PER MM, CLEANED FWD LIGHT SOCKET ON AFT LIGHT ASSY. OPS CHECKED GOOD.SDR UALA2012040902165Knob · looseCAPTAIN`S RMP UPPER FREQUENCY KNOB LOOSE. BOTH KNOBS AND THE RMP OPS OK, JUST LOOSE. REMOVED AND REPLACED CAPTAIN`S RMP PANEL, OPS CHECKED GOOD.SDR UALA2012040302064Ram Air Turb · no testRAT FAILED TEST. OPENSDR UALA2012032301849Transceiver · faultyNR 1 RADIO TRANSMIT BROKEN-UNINTELLIGIBLE MULTIPLE FREQS AND MICS. NEEDS VHF TRANSCEIVER. SWAPPED POSITION 2 WITH POSITION 3, NOW VHF-1 NORMAL. VHF-2 S-N 3393, VHF-3 S-N 3623, VHF-1 S-N 4612. VHF FAULT SEEMS TO BE VOICE TRANSMISSION PROBLEM ONLY, ACARS DATSDR UALA2012011100229Skin · wornEXTERNAL FUSELAGE FRAME 34 STR 43L - FUSELAGE SKIN HAS DEEP WEAR FROM SCREW. ACP'D ON DOCK WU E5765G BY AMTS 38425, 054888, 181147, 163495. RPR'D PER SRM.SDR UALA2013010900174Power Supply · no testEMERGENCY LIGHT TEST FAULT, "EXT LOAD EMER R" ON CIDS. RIGHT OVERWING EMERGENCY POWER SUPPLY WILL NOT TEST. REPLACED EPSU PER MM AND BATTERY PER MM. EPSU AND EMERGENCY LIGHT SYSTEM OPS TEST NORMAL.SDR UALA2011121906932Skin · dentedACCOMPLISHED VISUAL INSPECTION OF L1 DOOR DENTED AT LOWER DOOR EDGE. DOOR OPENS AND CLOSES WITH NO OBSTRUCTIONS, IS FAIRED AND SITS SQUARELY IN THE OPENING. REPAIRED PER SRM.SDR UALA2011101805639Windscreen · delaminatedCAPTAIN'S WINDSCREEN DELAMINATING. DELAMINATION WITHIN LIMITS. LEFT LOWER CORNER MOISTURE INGRESSION, WINDOW REPLACED.SDR UALA2011090704858Flap · dentedRIGHT OTBD AFT FLAP HAS 2 EA DENTS. 1 EA AT 1 8 IN INBD OF CANOE AND 1 IN FROM TRAILING EDGE, 1.125 IN DIA NR 2 DENT LOCATED 2.5 IN INBD OF CANOE 4 IN FROM TRAILING EDGE. DENT IS 1.5 X 2.0 IN SIZE. BOTH DENTS ARE .062 DEEP. FOA ON ARR BY RAMP. NOT ENVIRONSDR UALA2011082204485Computer · faultyFLT CONTROL ELAC NR 1 PITCH FAULT. RESET ELAC NR 1 TWICE, COMES BACK ON FLT CONTROL CHECK. REPLACED ELAC NR 1 PER MM AND CAT III AUTOLAND PER MM. OPS CHECKED OKAY.SDR UALA2011080404072Sealant · deterioratedNOISE IN AREA OF THE UPPER TCAS ANTENNA. ANTENNA SEALANT FOUND DETERIORATED AND BLACK AIR STREAKS EMITTING FROM AREA. ACCOMPLISH CABIN PRESSURIZATION AND CHECK AREA FOR POSSIBLE NOISES ON THE INSIDE OF A-C AND OUTSIDE OF A-C AFTER REPLACEMENT OF TCAS ANTENNASDR UALA2011080103964Unknown · odorELECTRICAL SMELL IN CABIN, FLT DIVERTED.SDR UALA2011070503292Light · inoperativeEMERGENCY LIGHT TEST AT FAP FAILS. *33-51-38 EXT LOADS EMER R*. RELAMPED, ALL BULBS ON RIGHT OVERWING EEL, OPS CHECKED GOOD P/N GE1810.SDR UALA2011061502942Fdu · failedNR 2 ENG FIRE TEST INOPERATIVE. NO ECAMS NO FIRE LIGHTS, ONLY SQUIB - DISCHARGE. REPLACED NR 2 FDU. TESTS OKAY.SDR UALA2011051802446Skin · damagedRT WHEEL WELL AFT SIDE OF WHEEL WELL FUSELAGE FAIRING DAMAGED. FAIRING SKIN CRACKED AROUND ATTACHMENT BASE OF FAIRING SUPPORT ROD FITTING. REMOVED PANEL 148FB AND BEGAN REPAIR REF SRM.SDR UALA2011051202360Slide · obstructedREPLACE THE LT OVERWING SLIDE ACCT. ONE OF THE SLIDE ENCLOSURE BALL-LOCK-PINS IS PAINTED OVER. REPLACED LEFT HAND OVERWING SLIDE PER MM.SDR UALA2011011300219Autopilot Sys · disengagedAUTOPILOT DISENGAGED, FLIGHT DIVERTED. THIS OCCURRED 4 TIMES IN FLIGHT, ALSO HAD THE AUTOTHROTTLE DISENGAGE, AND THE NAV SCREENS GO BLANK WITH THE AUTOPILOT KICKING OFF. MX REMOVED FCU TO CHECK FOR DAMAGED PINS OR SOCKETS - NONE FOUND. REPLACED FCU CONTROSDR UALA2010110904162Lamp · failedEMERGENCY LIGHT TEST FAILS EXT LOADS EMER R. RELAMPED, OP CHECKED GOOD.SDR UALA2010101403813Lamp · inoperativeCABIN EMERGENCY LIGHT CHECK IAW NR 3 SERVICE CHECK FAILS. (EXT LOADS EMER R). FOUND RT OVERWING LIGHT POWER SUPPLY 12WL SHOWING EXT FAULT AT ROW 11DEF. RELAMPED RT OVERWING AFT SLIDE LIGHT ASSY. 12WL BITE TEST OK, EMERGENCY LIGHT CK REF 3SVC, OP CKS OK.SDR UALA2010101403819Power Supply · out of tolerancePOWER SUPPLY 11WL USED FOR TROUBLESHOOTING. REPLACED EMERGENCY LIGHT POWER SUPPLY 11WL. OP CKS OK.SDR UALA2010101103788Mount · crackedFOUND DOOR OPENING HANDLE MOUNT CRACKED LETTING HANDLE INTERFERE WITH AND DAMAGING EXTERIOR SKIN PANEL UPON OPENING DOOR. BRACKET PLATE BROKEN, WILL NEED REMOVAL OF ENTIRE DOOR MECHANISM (HANDLE MECH) TO INSPECT FOR FURTHER DAMAGE. DOOR SKIN PANEL INSIDE AFT PSDR UALA2010083003183Adiru · inaccurateNAV ACCURACY LOSS, FLIGHT DIVERTED. ACCOMPLISHED REALIGNMENT OF ADIRU'S. REALIGNMENT NORMAL. ACCOMPLISHED AFS TEST. FMGC'S OK. ENTERED LOCAL VOR-DME INTO MCDU. INDICATION NORMAL ON ND'S.SDR UALA2010062102179Lamp · failedEMERGENCY LIGHTS TEST FAILS WITH 'EXTERNAL LOADS EMER R' MESSAGE. RELAMPED AFT OVERWING LIGHT ASSY.
Back to N401UA