N801UA
Service difficulty reports · 104
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 = 'N801UA' 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 = 'N801UA' 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 CALA2014080691736Skin · dentedEXTERNAL FUSELAGE SKIN DENTED AT THREE EACH LOCATIONS FRAME 23 & 24, STRINGER 23L & 24L. FOUND DENTS TO BE OUT OF LIMITS IAW SRM 53-11-11 FIG 115. FABRICATED REPAIR DOUBLER & INSTALLED IAW SRM 53-00-11 FIG 232 PG 505 - 506.SDR CALA2014080691735Skin · dentedSMALL DENT FOUND ON ARRIVAL ON RT FUSELAGE, 1 FT ABOVE UPPER WINDOW LINE & 7 WINDOWS FT OF OVERWING EXIT. DENT WAS OUT OF LIMITS IAW SRM 53-41-11. FABRICATED REPAIR DOUBLER 7 INSTALLED IAW SRM 53-00-11.SDR CALA2014080191589Door Sill · corrodedL2 DOOR SILL HAS CORROSION AT 7 E. LOCATIONS BETWEEN FRAME 66 & 68. REPAIRED THE AREA IAW SRM 53-41-14.SDR CALA2014080191588Door Sill · corrodedR2 DOOR SILL FRAME 66 - 68 CORROSION FOUND OUT OF LIMITS. REPAIRED IAW SRM 53-41-14 PARA 5A FIG 201.SDR CALA2014071191412Panel · damagedON ARRIVAL PANEL 192MB FOUND OPENED & DAMAGED. ALSO DAMAGED PANEL 192FB AC BAY RT. TWO PUNCTURES DIRECTLY BELOW PANEL 192MB. REPLACED PANEL 192MB.SDR CALA2013102292275Oxygen Mask · missingO2 ABOVE 34 DEF MISSING MASK. REPLACED MISSING MASK.SDR CALA2013082990852Valve · leaking'Y' SYSTEM LOW PRESSURE MESSAGE, RETURN TO FIELD. REPLACED POWER TRANSFER UNIT MANIFOLD 2-WAY VALVE. OPERATIONS & LEAK CHECKED OKAY.SDR CALA2013082090593Fastener · missingFOUND TWO NOSE CONE INNER BARREL RIVETS MISSING AT THE SIX O'CLOCK POSITION. REPLACED MISSING RIVETS ON NUMBER ONE ENGINE REFERENCE MT 71-002.SDR UALA2013070104596Contactor · damagedELECTRICAL DC ESS BUSS SHED ECAM, RETURNED TO FIELD. REMOVED & REPLACED DC SHED ESSENTIAL BUSS CONTACTOR, ALL OPS CHECKED NORMAL.SDR UALA2013050703186Closeout Panel · crackedRIGHT WING INBD SLAT CLOSING PLATE CRACKED. RPL- :INSTALLED PANEL.SDR UALA2013040102107Transceiver · inoperativeWEATHER RADAR SYSTEM INOPERATIVE, DISPLAYS ONLY WR ANT. REPLACED WEATHER RADAR TRANSCEIVER PER MM, TESTED OKAY.SDR UALA2013032801991Oxygen Mask · unwanted deployOXYGEN MASK FELL OVER SEAT ROW 30 DEF. PACKED MASK. TESTED OXYGEN MASKS IAW MT 35-003. ALL TEST OKAY.SDR UALA2013032001724Life Vest · unsecureLIFE VEST LOOSE ON FLOOR ROW 25 ABC. SECURED LIFEVEST.SDR UALA2013031101445Engine · bird ingestionEVIDENCE OF BIRD STRIKE INGESTION IN NR 2 ENGINE. PERFORMED VISUAL INSPECTION OF ENGINE 2 ESN V10991 AND INLET COWL PER MT72-021. NO DAMAGE OBSERVED. BIRD DEBRIS OBSERVED ON SPLITTER FAIRING. ACP BORESCOPE OF NR 2 ENGINE, NO LIMITING DEFECTS NOTED. REF AMSDR UALA2012102906166Oxygen Mask · misinstalledCREW REPORT: OXY MASK ON WRONG AT OXY BOTTLE OVER 1A. RE-INSTALLED MASK TO PROPER POSITION.SDR UALA2012101705934Transformer · faultyINOP LIGHTS ARE APU MASTER, APU START, DITCHING, CAB PRESS MODE SEL, EMERGENCY EXIT, ETC. -TS, CLEANED & CHECKED CONNECTORS AT 25VU OVERHEAD PANEL, TRIED ANOTHER 7LP ANN & INTC CARD, SAME RESULTS. RE-INSTALLED SAME 7LP INTC CARD. SUSPECT BAD ESS XFMR 35LP PESDR UALA2012091805275Washer · leakingCREW OXYGEN IS LEAKING AT A RATE OF 50 PSI PER HOUR. REMOVED AND REPLACED FIRST OBS CRUSH WASHER FOR INLET LINE TO BOX B-NUT, AFTER T-S AND OLD WASHER LEAKING. SERVICED O2 TO FULL, LET SIT FOR ONE HOUR AND O2 PRESS DID NOT GO DOWN FROM 1770.SDR UALA2012060103045Engine · vibrationVIBRATION FROM NR 1 ENG, FELT IN FLIGHT DECK. NEED TO ACP TAP TEST INSPECTION OF THE NR 1 ENGINE FAN BLADES. ACCOMPLISHED TAP TEST PER AMM. ALL BLADES HAVE AN ACCEPTABLE VALUE. ACP'D LP COMPRESSOR (FAN) ONE SHOT METHOD TRIM BALANCE PER MM. OPERATIONAL TESSDR UALA2011122107040Wire Harness · pinchedPA FAULT RETURNED. STAYS HOT AND SQUEALS. FOUND WIRE BUNDLE BEHIND F/A INBD SEAT PINCHED. REPAIRED WIRE AND RE-ROUTED BUNDLE AND SECURED, OPS CHECKED GOOD. NO FAULTS.SDR UALA2011112706491Computer · faultyFQI CHANNEL 2 FAULT DISPLAYED ON UPPER ECAM SCREEN. REPLACED FQIC PER AMM.SDR UALA2011103105901Container · faultyCAPTAIN'S OXY MASK TEST AND RESET SLIDING SWITCH WILL NOT RESET CAPTAIN'S OXYGEN MASK. REPLACED CAPTAINS O2 BOX. CHECKS OKAY.SDR UALA2011102505793Slide · delaminatedRT OFF WING SLIDE PANEL DELAM ALONG UPPER AFT CORNER. REPLACED ESCAPE SLIDE ASSY.SDR UALA2011081704363Diaphragm · damagedNR 2 RT MAIN DOOR EMERGENCY CYLINDER (ASSIST BOTTLE) FOUND AT 0 PRESSURE DURING 3SVC. SERVICED TO 1900 PSI LOST 200 PSI IN 20 MINUTES. REPLACED CYLINDER DIAPHRAM PER MM. PRESSURE HOLDS NOW.SDR UALA2011081204251Slide · faultyR2 DOOR SLIDE ASPIRATOR IS NOT SPRING LOADED IN CLOSED POSITION. ALL OTHER SLIDES ARE SPRING LOADED IN CLOSED POSITION. REMOVED AND REPLACED R2 DOOR SLIDE ASSY.SDR UALA2011080304057Pedal · faultyF/O RUDDER PEDAL ADJUSTMENT HAVE NO TENSION. CHECKED BELOW RUDDER PEDALS. PNEU BUFFER "PUSHROD" HAS NO INTERNAL PRESSURE. REPLACED F/O RUDDER PEDAL. ADJ BUFFER ASSY.SDR UALA2011070503282Elt · damagedAFT ELT FOAM DAMAGED AND TORN. NIS DENVER. DF REF MEL2560. REPLACED AFT CABIN TRANSMITTER EMERGENCY LOCATOR ELT PER AMM.SDR UALA2011051002314Recorder · damagedCREW DEBRIEF AIRCRAFT SPEED WAS .79 MACH AT FL370 AIRCRAFT EXPERIENCED EXCESSIVE TURBULENCE FOR 30 SECONDS. AIRCRAFT CLIMBED 1500FT IN 15 SECONDS. FLIGHT CREW REPORT BEING THROWN ABOUT IN SEAT AND 5 TO 6 'G -FORCE' ALONG WITH A -1 'G FORCE'. STARTED EXCESSISDR UALA2011021500797Unknown · odorSMOKE IN CABIN, FLIGHT DIVERTED. ATTENDANT REPORTED GETTING WHIFFS IN AFT GALLEY AREA. NO VISIBLE SMOKE SEEN. ODOR DISSIPATED DURING DECENT. NO BURNING ODOR PRESENT AT ARRIVAL. FIRE DEPT INSPECTED PITS ON ARRIVAL, NO EVIDENCE OF BURNING. ODOR WAS PRECEDED WITSDR UALA2011020800676Fan · odorRETURNED TO GATE DUE TO UNIDENTIFIED ODOR IN CABIN AND FLIGHT DECK. REPLACED RECIRCULATION FAN, OPS NORMAL. NO ODOR IN ACFT.SDR UALA2010082303096Oven · fireR12 FWD GALLEY OVEN IGNITED A PIECE OF PAPER CAUSING SMALL FIRE & SMOKE. HALON EXTINGUISHER USED. REMOVED AND REPLACED FORWARD GALLEY OVEN R12. OPS TEST OKAY.SDR UALA2010051301627Warning Light · illuminatedIDG 1 OIL LO PR DISPLAYED ON UPPER ECAM SCREEN. - ELEC REMOVED WIRE HARNESS FROM IDG AND MEGGERED TO FIREWALL CONNECTOR NO FAULTS. RANG WIRING FROM EGIU PIN AA-5B TO GCU PIN AA-15D ALL NORMAL, NO FAULTS FOUND. REPLACED EGIU 22XU1 PER AMM. RAN ENGINE IAW JRH ASDR UALA2010032200939Unknown · faultyREF CARGO PIT FIRE BOTTLE WRITE-UP, FOUND 26VDC ON FWD SQUIB CONNECTOR WITH T19 CB PULLED. REPLACED SDCU PRECAUTIONARY, NO HELP. RANG OUT OVERHEAD PNL, WIRING FROM PNL TO SQUIBS AND PANEL TO SDCU. FOUND 26VDC ON PINS R AND S OF 2400VC A. PULLING SDCU CB'S SDR UALA2010012800358Strut · lack of lubeSHOCK ABS FAULT ECAM, RTFL. PERFORMED MAINT TIP 32-022. FOUND IN NEED OF LUBE IAW THIS MAINT TIP. ACP'D PRECAUTIONARY BITE CK OF LGCIU 1&2, NO FAULTS FOUND.SDR UALA2009092503030Filter Element · faultyGREEN/BLUE HYD OVHT MSG, RTFL. ACP WALK AROUND, FOUND NO SIGNS OF HYDRAULIC OR OIL LEAKS. HYDRAULIC AND OIL QTY INDICATIONS ON ECAM CHECK NORMAL. FAULTS CLEARED. NO ECAM, STATUS OR MAINT MSGS DISPLAYED. RAN HYD SYS FOR 1 HR & CYC FLIGHT CONTROLS, NO MSGS.SDR UALA2009092102962Power Supply · shortedDURING CABIN EMERGENCY LIGHTS CHECK, SYSTEM TEST FAILED WITH MESSAGE 'EPSU UNIT FWD L'. REPLACED FWD EPSU, NO HELP. FOUND SHORT FOR FLOOR LIGHTS AT SEAT 6 WHICH WAS TAKING OUT THE EPSU AT DOOR 1L. REPAIRED SHORT, GROUND CHECKED OKAY.SDR UALA2009092202987Power Supply · faultyEMERGENCY FLOOR LIGHTS INOP AT SEATS 1, 2, 8, 9 & 10. SEAT 10 WAS INOP; REPAIRED CONNECTOR. NOW 10 WORKS OK. REF WDM 33- 51-06 POST SB 33-1041 WIRE MOD TO EMERG LIGHT CIRCUITS, WORKING WITH SAMC TO FIND BASE COA FOR PWR TO THESE SEATS OR LOCATION OF BATTERYSDR UALA2009091602932Blade · damagedNR 1 ENG BIRD STRIKE, RTFL. ON CLIMBOUT, ABOUT 800FT, CREW HEARD A LOUD BANG FOLLOWED BY A BAD ODOR AND MILD ACFT VIBRATION. ACFT HAD A BIRD STRIKE ON THE LT SIDE NR 1 ENGINE. ALL INDICATIONS WERE NORMAL. NO CABIN PREP AND CREW MADE A NORMAL LANDING. NR 1 ESDR UALA2009082502651Switch · malfunctionedELECTRICAL PROBLEM, RTFL. REPLACED STROBE SWITCH, TESTS OKAY.SDR 2008UALA03626Windshield · shortedODOR IN COCKPIT, FLIGHT DIVERTED. *S/D* FOUND WHC2 HAD OVERHEATED. REMOVED COVER AND FOUND CHARRED RESISTORS, THIS CAUSED BY AN INTERNAL SHORT WITHIN THE RT (F/O) WINDSHIELD. REPLACED WHC2, AND AND F/O WINDSHIELD, ALL OPS CHECKS NORMAL.SDR 2008UALA03300Oxygen Bottle · underservicedCREW OXYGEN BOTTLE NEEDS SERVICE. SERVICED CREW O2 TO FULL, NO LEAKS NOTED AT TIME.SDR 2008UALA01621Lever · obstructedDOOR 1R WILL NOT ARM. CAUSE, INTERFERENCE WITH BENT FLOOR PLATE, UNKNOWN DAMAGE. REWORKED FLOOR COVER PLATE TO ALLOW CLEARANCE FOR DOOR, OPS OK.SDR 2008UALA01116Transducer · faultyDIVERTED DUE TO LEFT ENGINE VIBRATION. REPLACED EVM (TRANSDUCER). ENGINE RUNS WERE NORMAL AFTERWARD.SDR 2008UALA00988Floorboard · damagedCARGO FLOORBOARD RPL S GLS PNL. MAJOR REPAIR ACCOMPLISHED AT LCQ (COA ACCOMPLISHED).SDR 2008UALA00370Oxygen Mask · leakingWHEN TESTING OBSERVERS O2 MASK, MASK DID NOT RESEAT AND CONTINUED TO PURGE O2. OBSERVER`S MASK LEAKING. REPLACED OBSERVERS MASK ASSY AND LEAK CHECKED. NO LEAKS NOTED.SDR 2006UALA01983Skin · gougedFOUND FUSELAGE SKIN HAS A GOUGE ON THE RIGHT SIDE OF AIRCRAFT IN FRONT OF FWD CARGO DOOR. DAMAGE IS APPROXIMATELY 6" BELOW UPPER RVSM BORDER. REPAIRED GOUGE. PER AMM 51-73-11 PAGE BLOCK 801.SDR 2006UALA01939Light · inoperativeFOUND SEAT 12C EMERGENCY ESCAPE PATH LIGHT ON SEAT INOP. REPLACED LIGHT ASSEMBLY. OPS CHECKED OK.SDR 2006UALA01650Fan · failedCREW REPORTED THAT IN FLIGHT, HEARD A LOW RUMBLING SOUND AND EQUIP COOLING EXTRACT CB POPPED AND SHORTLY AFTER GOT SMOKE AND SMELL IN COCKPIT. REPLACED AVIONICS FAN AND OPS CHECKS GOOD.SDR 2006UALA01613Bleed Valve · defectiveRETURNED TO FIELD DUE TO NR 1 ENGINE COMPRESSOR STALL. STALL-RTF. HPC WAS BOROSCOPED, OK. FOUND BAD 7TH STG BLEED VALVE, REPLACED. NR 1 ENGINE ACCOMPLISHED BORESCOPE OF HPC 3 AND 4, NO LIMITING DAMAGE FOUND. ACCOMPLISHED 7TH STAGE BLEED VALVE SOLENOID CHESDR 2006UALA01459Battery Pack · dischargedFOUND EMERGENCY LIGHTS FAILED 3 SVC TEST. FAULT IS EPSU BATTERY LEFT AFT. REPLACED BATTERY PACK.SDR 2006UALA01417Hydraulic System · failedGREEN HYDRAULIC SYSTEM FAILURE.
Back to N801UA