N798UA
Service difficulty reports · 187
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 = 'N798UA' 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 = 'N798UA' 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 CALA2017051201339Battery · no testDURING AN EMERGENCY LIGHT CAPACITY TEST, FOUND M33409 BATTERY RUN TIME 15 MINUTES. REPLACED THE BATTERY AND OPS TESTED NORMAL IAW AMM 33-51-00-710-801, REV 79.SDR CALA2016061595451Structure · dentedDENT BETWEEN FRAME 676 LT AND FRAME 679 LT, STR39L AND STR 40L DIMENSION L 6.5" X W 6.0" X
D 0.216" REF ECRA 5300-02342, PERFORMED PARTS 1 AND 2 OF ECRA.SDR CALA2016061395443Structure · dentedDENT BETWEEN FRAME 676 LT AND FRAME 679 LT, STR 39L AND STR 40L DIMENSION L6.5 IN X W6.0 IN DEPTH 0.216 IN CUTOUT DAMAGE, REF SRM 5 3-00-01, REPAIR-7 AND NR 6696869.SDR CALA2015112394854Skin · scratchedUPON ARRIVAL, FOUND A SCRATCH APPROX 4 X 2 INCHES NEAR FWD CARGO DOOR LT SIDE. BLENDED AREA & PERFORMED EDDY CURRENT INSPECTION. PRIMED & PAINTED AREA.SDR CALA2014081891996Connector · not seatedEMERGENCY LIGHTS SEATS 39 - 46 INOPERATIVE. SWAPPED POWER PACKS FOR EMER LIGHTS AT DOOR 4R & 4L, NO HELP. RESEATED SEVERAL EMER LIGHT CONNECTIONS. OPERATIONS CHECKED OK EXCEPT FOR SEATS 40D & 36D EMER LIGHTS. RESEATED SEVERAL EMER LIGHT CONNECTIONS. OPERATSDR CALA2014081591994Light · inoperativeEMERGENCY LIGHTS SEATS 39 - 46 INOPERATIVE. SWAPPED POWER PACKS FOR EMER LIGHTS AT DOOR 4R & 4L, NO HELP. RESEATED SEVERAL EMER LIGHT CONNECTIONS. OPERATIONS CHECKED OK EXCEPT FOR SEATS 40D & 36D. DEF SEAT 40D & SEAT 36D EMER LIGHTS DEFERRED.SDR CALA2014051691024Spacer · damagedRIGHT HORIZONTAL STABILIZER OUTER PIVOT PIN PN 182W6401-303 DAMAGED. SPACER REPAIRED IAW ECRA 5510-02421. RII INSP ACCOMPLISHED ON AMECO NON-ROUTINE 0412123.SDR CALA2014051691023Spacer · damagedLEFT HORIZONTAL STABILIZER OUTER PIVOT PIN SPACER PN 182W6402-4 THREADS DAMAGED. SPACER REPAIRED IAW ECRA 5510-02420. RII INSPECTION ACCOMPLISHED ON AMECO NON-ROUTINE 0412124.SDR CALA2014050990990Door · damagedFORWARD CARGO DOOR AT AFT BOTTOM CORNER HAS A CREASE THAT RUNS DIAGONALLY. REMOVED REPAIR DOUBLER & REPLACED WITH NEW DOUBLER IAW SRM 52-30-01 REPAIR 17 WHICH IS A CATEGORY A REPAIR IAW SRM.SDR CALA2014010290044Screw · missing1ST OBSERVER`S STOWAGE AREA BELOW SLIDE OUT TABLE DOOR SLIDE BRACKET BROKEN. REPLACED MISSING BRACKET SCREWS.SDR CALA2013112593211Actuator · stuckTURBINE CASE COOL LPT RT ENG LPT CASE COOLING ACTUATOR IS STUCK OR REVERTED TO ITS FAIL SAFE POSITION. REPLACED NR 2 ENG TCC ACT. IAW MM 75-24-05 PG401 & ACCOMPLISHED RIG IAW MM75-24-00 PG501. ACCOMPLISHED TEST 3,6,&15 IAW MM71-00-00 PG501. OPERATIONS & LESDR CALA2013102992490Unknown · failedELMS P210 CHANNEL ONE, BUT NOT BOTH, OF THE ELMS 210 PANEL CHANNELS IS INOPERATIVE DUE TO FAILURE OF THE P210 PANEL POWER SUPPLY, CENTRAL PROCESSING UNIT, OR ARINC 629 CARD OR FAULTED SUCH THAT THE CHANNEL CANNOT SUPPORT ITS COMPLETE SET OF FUNCTIONALITIES.SDR CALA2013100791763Pin · missingRT AIR COND PACK BAY, FOUND RT AMC BOTTOM SIDE MISSING AN INDEX ROLL PIN, HOT AIR BLOWING IN COMPARTMENT. INOPED SECOND STAGE TURBINE BYPASS VALVE IN OPEN POSITION, REMOVED & CAPPED CONNECTOR. SWAPPED LT & RT LOW LIMIT VALVE. SECOND STAGE TURBINE BYPASS VALSDR CALA2013091091184Connector · corrodedENGINE SLOW TO SHUT DOWN ON ARRIVAL & ENG FUEL VALVE STATUS MESSAGE DISPLAYED. MAINT MESSAGE 73-60211 IAW FIM 73-22 TASK 801. ACCOMPLISHED WIRING CHECKS, INCORRECT VOLTAGE NOTED AT FMU CONNECTOR DM76001C. FOUND HIGH RESISTANCE BETWEEN D71074P ENGINE RT CORESDR CALA2013080790213Strip · damagedNR 2 ENGINE, NR 4 GAP COVER STRIP DAMAGED. BLENDED MINOR NICKS T/E NR 4 GAP STRIP, REQ HFEC REF SRM 54-50-70, TABLE A. ACCOMPLISHED HFEC INSPECTION TO NR 2, ENG NR 4 GAP STRIP BLENDS IAW NDT PART 6, 51-00-06. NO DEFECTS NOTED. TOTAL AREA OF DAMAGE TRIM OUT TSDR UALA2013072505229Module · faultyELMS P210, CHANNEL STATUS MESSAGE P210 EU SELF TEST NO HELP. FAULTS PSU CARD A 566-9036, REPLACED ELMS POWER SUPPLY, NO HELP.SDR UALA2013071705014Tru · failedGROUND HANDLING BREAKER TRIPPING OPEN IN CENTER E&E BAY. REPLACED GROUND HANDLING TRU, OPS CHECKED GOOD.SDR UALA2013060703989Feeder Cable · damagedNR 1 ENGINE HAS SIGNS OF OVERHEATING ON THE POWER FEEDER CABLES AT THE IDG. REPLACED IDG POWER FEEDER CABLES IAW AMM.SDR UALA2013032501849Control Valve · failedCARGO HEAT VALVE AFT FAILURE OF AFT CARGO HEAT SHUTOFF VALVE OR (SOV) OR TEMP CONTROL VALVE (TCV). INTERMITTENT STATUS MSG-2112031 INACTV ER MODE. REPLACED AFT CARGO TEMP. CONTROL VALVE PER AMM.SDR UALA2013032501814Charger · failedMAIN BATTERY DISCHARGED. MAIN BATTERY DISCHARGING OR HOT BATTERY BUSS NOT POWERED. REPLACED MAIN BATTERY CHARGER AS PER AMM, INSTALLATION TEST PASSED.SDR UALA2013030401271Sleeve · crackedNR 2 ENGINE HAS CRACKED BLUE TERMINAL SLEEVE AT IDG TERMINAL BLOCK. FOUND BLUE SHRINK TUBING ON UPPER & LOWER IDG CABLES.SDR UALA2013030401265Vane · damagedNR 2 ENGINE HAS 1 STG VANE ID PLATFORM FILLET RADIUS BURN THRU LOCATED 3 O'CLOCK POSITION THAT EXCEEDS ADDITIONAL REDUCED INSPECTION LIMITS PER MM 72-00-00. REPLACED NR 2 ENGINE IAW AMM.SDR UALA2013030401264Oxygen Mask · damagedFIRST OFFICERS O2 MASK HAS BROKEN 100%-N SWITCH. REPLACED FIRST OFFICERS O2 MASK PER AMM35-11-18 PG 201.SDR UALA2013022001031Unknown · inoperativeFLT ATTENDANT CREW REST ACCESS DOOR INOP. LOWER LOBE ATTENDANTS REST INOP. DEFERRED FOR TIME.SDR UALA2012110606366Unknown · malfunctionedAPU APUC DETECTED FAULT THAT WOULD CAUSE AUTOMATIC SHUTDOWN OF APU IN UNATTENDED MODE OPERATION, OR COMPLETE LOSS OF APUC BUS ACTIVITY (BOTH L AND R 629) FOR 3 SECONDS AFTER THE APU MASTER CONTROL SWITCH HAS BEEN IN THE ON POSITION FOR TEN SECONDS. FAULT CAMESDR UALA2012110506351Inverter · faultyNO LAND 3 EICAS ON FINAL AT APPROX 1500 AGL. REPLACED STATIC INVERTER PER MM. (ACTION). REPLACED STATIC INVERTER PER MM. AIRCRAFT IS IN CAT 111 STATUS.SDR UALA2012092405385Skin · delaminatedON WALK AROUND FOUND POSSIBLE DELAMINATION ON RIGHT SIDE OF VERT STAB. ITEM ROLLED FORWARD. REF IPC55-34-51-008, PANEL HAS 11 BY 8 AREA OF DELAM IN MIDDLE OF PANEL. REF SRM 55-30-01. NEED TO ACP INTERIM REPAIR PER ECRA 5530-01666 AVAILABLE ON EDOCS. ACCOSDR UALA2012091905312Shutoff Valve · failedTRIM AIR PRSOV LEFT TRIM AIR PRESSURE RELIEF SHUT OFF VALVE (PRSOV) FAILED. REPLACED LEFT TRIM AIR PRSOV PER MM, OPS CHECK NORMAL, NO MESSAGE.SDR UALA2012080804295Battery · failedAPPROX 30 MINUTES AFTER GROUND POWER HOOKED UP, SMOKE EXITING E/E EXHAUST. OPENED E/E DOOR AND SMOKE IN AREA. BATTERY BOX RED HOT. ALSO NOTE AIRCRAFT LOG 6. REPLACED MAIN BATTERY AND BATTERY CHARGER. BATTERY STILL IN PROCESS OF FULLY CHARGING. NEED TO VESDR UALA2012042702518Coupler · faultyHF RADIO TRANSMISSION PROBLEM. NO TRANSMIT. REPLACED COUPLER.SDR UALA2012042702517Computer · faultyRIGHT PFC COMPUTER REQUIRES REPLACEMENT PER LINE COA 209901. REPLACED RIGHT PFC COMPUTER PER AMM.SDR UALA2012042702516Module · failedCENTER VHF RADIO WILL NOT GO TO DATA MODE. RIGHT VHF WORKS OK IN DATA. T-S REF FIM 23-27 TASK 80 6, REPLACED LEFT AMIS CPM-COMM MODULE M001 (M31101) & GROUND TEST LEFT AMIS, OP TESTED, LEFT DCMF -MODEM RESET PASSED. AND NO MORE MESSAGES.SDR UALA2012031901756Striker · faultyFLIGHT DECK DOOR (ENHANCED SECURITY DOOR) - DOES NOT UNLOCK WITH SWITCH SET TO UNLKD. CREW COMMENTS: PUSH BEFORE ROTATE FUNCTION INOP. POSSIBLE BAD PRESSURE SENSOR M52006?????. RPLC'D ELECTRIC STRIKER, OPS NORMAL.SDR UALA2012022801240Oven · dirtySMOKE CAME OUT OF OVEN 31. OVEN OFF NOW NO SMOKE OR FIRE. DEACTIVATED OVEN R31 AT MID GALLEY. CIRCUIT BREAKER PULLED AND COLLARED. CLEANED OVEN, OPS CHECK NORMAL.SDR UALA2012022201080Computer · faultyAFTER ENGINE RUN CHECK OF EICAS, MESSAGES SHOW AUTOPILOT FLIGHT DIRECTOR CENTER COMPUTER FAULT. REPLACED AFDC COMPUTER AS PER MM.SDR UALA2011122107013Skin · puncturedLT ELEVATOR UPPER INBD SURFACE STA 83.0 APPROX 40 INCHES AFT OF LEADING EDGE HINGE LINE HAS SMALL PUNCTURE .375" X .375". ACCOMPLISH RII INSPECTION OF AMIS ITEM 3012002 :REPAIRED PER SRM 51-7-04 AND CALCULATED WEIGHT ADDED AT .058LBS. NEW BALANCE CALCULATIONSDR UALA2011101705624Control Panel · inoperativeSECOND OBSERVER'S AUDIO CONTROL PANEL INOPERATIVE. FOUND MINITEL BAD. REPLACED MINITEL, OPS CHECKED GOOD.SDR UALA2011101305555Idg · faultyACFT RETURNED TO GATE AFTER TAKE OFF ABORT AT 60 KTS FOR A GENERATOR FAULT. MTC MSG:24-31632. R-ENG IDG DISCONNECTED PER MEL. ALSO VISUAL INSPECTED REJECT TAKE OFF CONDITION PER MM. NO ABNORMAL CONDITION FOUND. REPLACED RT ENG IDG & ENG RUN TEST CHECK IDGSDR UALA2011093005300Module · failedFAILURE OF ALTITUDE CALLOUTS (MODE 6) FUNCTION. ADVISORY REF SAME FLT 5 CMC MESSAGES, CHECKED MAT SHOW ACTIVE PER FIM 34-46 TASK 803, RESET CB, MAT GPWS SYS TEST FAILED, REPLACED CPM-GG (M010) L AIMS, IAW MM. TEST PASSED. ALL MESSAGES CLEARED.SDR UALA2011092605192Line · chafedHYDRAULIC SUPPLY LINE NR 2 ENGINE HAS RUBBER INSULATION WORN THROUGH EXPOSING BRAIDED METAL. INSTALLED AND LEAK CHECKED LINE. LEAK CHECKED GOOD ON ENGINE RUN. REPLACED NR 2 ENGINE HYD CLAMPS PER MM.SDR UALA2011082904587Hydraulic Line · leakingPRIOR TO DEPARTURE HEAVY HYDRAULIC LEAK FROM CENTER SYSTEM NLG STEERING PRESS FLEX LINE AT SWAGED SECTION AT CONNECTION TO SOLID LINE TOP OF NLG. REPLACED HYDRAULIC LINE ASSY CARRIED OUT LEAK CHECKS & OPS CHECKS. ALL OPS & INDICATIONS SATISFACTORY.SDR UALA2011081004195Transceiver · failedON PREFLT RT RADAR FAILURE-T CAL. REPLACED RT TRANSCEIVER PER MM, OP CHECKS NORMAL.SDR UALA2011081004194Transceiver · faultyWEATHER RADAR - DOES NOT SHOW RETURNS. REPLACED TRANSCEIVER AND OPS CHECKS NORMAL.SDR UALA2011071103452Clamp · looseSTATUS MESSAGE L BLEED LOOP 1 DISPLAYED. STICKER APPLIED PER MEL. MSG 26-31093, INSPECTED LOOP 1 IN ZONE 9 AND FOUND DUCT CLAMP AIR LEAK ON OTBOARD SIDE OF LT ISO VLV CLAMP - SECURED. ALSO FOUND DUCT BLANKET UNTIED EXPOSING DUCT TO LOOP. REPOSITIONED AND SSDR UALA2011061302893Valve · failedCENTER TANK SCAVENGE SYSTEM TRANSFERED FUEL BEFORE MAINS REACHED 50000LB SAMC TEXT: FUEL SHEET NOTED WITH \NR 2 TANK VTO EARLY'. FUEL SCAVENGE SYS FUNCTIONALTEST IAW MM. FOUND BOTH OUTLET FLOAT VALVES FAILED OPEN. FUEL KEEPS SCAVENGING FROM CTR TANK TO BOTSDR UALA2011041101751Unknown · odorPAX NOTED ELEC ODOR VICINITY 23HJ AND 24HJ. CREW CHECKED, NO ODOR. TURNED ON ALL LIGHTS, MONITORS IN ROWS 22HJ-25HJ. NO OVERHEATING OR ODORS FROM THIS AREA. ALL OVERHEAD AND SIDEWALL LIGHTS WORKING OKAY. NO ODORS NOTED.SDR UALA2011041101750Battery · inoperativeOVERHEAD EMERGENCY LIGHTS FROM 2LH MED TO LH3 MED INOPERATIVE. RESEATED BATTERY PACK AT DOOR 2L. ALL EMERGENCY LIGHTS OPS CHECKED OKAY.SDR UALA2011040701684Clamp · brokenFOUND BAND CLAMP BROKEN ON LEFT GEAR RETRACT ACTUATOR. ACP INSTRUCTIONS ON EVA-8074 3. ACCOMPLISHED A DETAILED VISUAL INSPECTIONS OF LANDING GEAR STRUT AN RETRACT ACTUATOR HYDRAULIC LINES. NO DAMAGE IS PRESENT. NO WEAR NO LEAKS OR NO OTHER DAMAGE FOUND. RSDR UALA2011032301398Generator · faultyAPU GEN INOP AT DEPARTURE. REPLACED APU GENERATOR AND T1 & T2 FEEDER CABLE PER MM. GEN OPS NORMAL.SDR UALA2011032301399Insulation · damagedELEC GEN OFF APU AUXILIARY POWER BREAKER (APB) OPEN AND AUXILIARY POWER UNIT (APU) GENERATOR RUNNING OR APU GENERATOR SWITCH OFF - ADVISORY. LATCHED MSG 24-31663 ON ARRIVAL. ACCOMPLISHED RESET PER FIM, NO HELP. ELECTRIC PAGE SHOWS NIL VOLTAGE & FREQUENCY.
Back to N798UA