N799UA
Service difficulty reports · 174
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 = 'N799UA' 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 = 'N799UA' 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 CALA2015110694798Engine · overtempDURING CLIMB NR 1 ENG HAD EGT EXCEEDANCE, CREW REPORTS IN THE MID 700`S. AHM SHOWS 710.5. DURING CLIMB & HOLDING PATTERN ENG WOULD ONLY PROVIDE 1/3 AMOUNT OF POWER AS RT ENG. REPLACED ENG IAW 71-00 -02. REMOVAL REQUIRED FOR HPT AIRFOILS METALLOGRAPHIC ANALSDR CALA2015092294391Actuator · malfunctionedDOOR FLIGHT LOCK 3L, NR 3 LT PAX ENTRY DOOR FLIGHT LOCK COMMAND, FLIGHT LOCK RELAY SENSOR DISAGREEMENT. R & R ACTUATOR IAW MM 52-11-26-400-801 & REMOVAL 52-11-26-000-801.SDR CALA2014072291494Unknown · faultyDETECTOR CHANNEL 1 EE SMOKE EE COOLING SMOKE DETECTOR CHANNEL 1 FAILS BITE CHECK. STATUS MSG 01 ACTIVE ENG START HARD. EE COOLING SMOKE DETECTOR HAS NO OUTPUT OR IS FAILED. DB CARGO SMOKE DETECTOR CH 2 LOWER FWD MSG-2620070 ACTIVE ES HARD. IAW FIM TASK 26-SDR CALA2014060991231Door · dentedRAMP REPORTED DENT ON BULK CARGO DOOR NEAR FWD EDGE APPROX 18 INCHES ABOVE HANDLE & 2 INCHES AFT OF FWD EDGE MEASURES 3 INCHES X 3 INCHES ACROSS & .125 INCHES DEEP. FOUND DENT TO BE WITHIN LIMITS IAW SRM 52-30-01 MEASURING AT 3.250 INCHES X 3.250 INCHES & .1SDR CALA2014041790848Filter · contaminatedON TAXI CREW REPORTED STRONG ELEC ODOR IN FIRST CLASS. FLIGHT ATTENDANT ALSO NOTED PLASTIC TYPE DEBRIS FROM AIR CONDITION SYS IN F - C AREA AS WELL. ACCOMPLISHED SMOKE ODOR INSPECTIONS IAW AMM 05-51-50. FOUND DEBRIS IN ICE DUCT FILTER, CLEANED, PERFORMED OPSDR CALA2014010990117Battery Pack · dischargedNR 2 RT PAX DOOR EPAS BATTERY PACK GREEN FLASHING LIGHTS WILL NOT TEST. REPLACED EPAS BATTERY PACK IAW AMM 52-11-20, OPERATIONS CHECKED GOOD.SDR CALA2014010290043Radio · malfunctionedLT HF RADIO WOULD NOT TUNE.SDR CALA2013121693721Valve · faultyBLEED FAMV LT ENG BLEED. FAMV FAILED OPEN OR CLOSED OR LT AIR SUPPLY & CABIN PRESS CONTROLLER FAILURE. REPLACED CONTROLLER, NO HELP. PIGGY BACKED NEW FAMV CMC TEST PASSES SUSPECT VLV AT FAULT. IAW SMC 6 BLEED FAMV IS REPLACED, NEEDS ENG RUN. REPLACED LT FASDR CALA2013121893782O-Ring · wornAPU ALTITUDE NO START, COLD SOAK. APU SHUTDOWN AFTER REACHING 95% SPEED AFTER 10 SECONDS. REACHES 100 O-O THEN SHUTS DOWN FL330 ACCOMPLISHED FIM 49-53-TA SK 804, APU STARTED WITH NO FAULTS. FOUND STATIC PRESSURE LINE O RING WORN IAW IPC 49-53-53 ITEM 136. SDR CALA2013102292253Thermocouple · out of toleranceNR 1 ENG TCA THERMOCOUPLE OUT OF RANGE CH. B. REPLACED NR 1 ENG TCA PROBE IAW AMM, OPERATIONS CHECKED OKAY.SDR CALA2013100891832Idg · faultyLT GEN DRIVE LT PREVIOUS GRIPE REPLACED LT ENG IDG DUE TO METAL FOUND IN FILTER. RAN ENG, OPERATIONS CHECKED NORMAL.SDR CALA2013092591445Coupler · faultyLT HF TRANSMIT ISSUES, DUE TO SEVERAL SQUAWKS OF LT HF NOT TRANSMITTING IN FLT BUT CHECKS GOOD ON GROUND. REPLACED LT HF ANTENNA COUPLER IAW AMM 23-11-03. OPERATIONS CHECKED GOOD.SDR CALA2013083090872Oven · dirtyMID GALLEY HAS SMOKE. WARMER OVEN W33 SMOKES WHEN IN USE. FOUND BURNED CHOCOLATE IN OVEN.SDR CALA2013080790214Connector · unsecureTRIM AIR PRSOV LEFT TRIM AIR PRESSURE RELIEF SHUTOFF VALVE (PRSOV) FAILED. STATUS MSG-2124201 ACTIVE ES MODE SECURED CONNECTORS ON THE UPPER FCV & THE LOW LIMIT VALVE ALL TEST PASSED ON MAT WITH NO MESSAGES PRESENT.SDR UALA2013071004802Module · failedRECIRCULATION FAN FAILED. MESSAGE STATES THAT THE UPPER FAN SWITCH FAILED. REPLACED UPPER RECIRCULATION FAN SWITCH CAP MODULE. CMC GROUND TEST OPCF-L AND RECIRCULATION FAN PASSED. NO MESSAGE.SDR UALA2013051703425Slide · deployedESCAPE SLIDE AT R2 DOOR HAS BEEN DEPLOYED ON TO RAMP. CSDR UALA2013042502878Controller · malfunctionedEICAS RT WING LOOP 2 MESSAGE FAULT HISTORY LEG 5, SHOWS MESSAGE 26-37043, MESSAGE IS NOT ACTIVE. ACCOMPLISHED RESISTANCE CHECK PER FIM 28-18 TASK 802. RT WING LOOP 2 RESISTANCE TO GROUND IS 1.495K OHMS, AND IS IN LIMITS. THERE ARE NO OTHER EICAS MESSAGES OSDR UALA2013041902705Bypass Switch · inoperativeE & E BAY P-MA IS INOPERATIVE. INSTALLED A NEW P-MAT AND REPLACED NR 1 BYPASS SWITCH SYSTEM, OPS CHECKED GOOD.SDR UALA2013041802689Packing · leakingFUEL LEAKING IN NR 1 PYLON AT FUEL SUPPLY LINE LOWER COUPLING. REPLACED PACKINGS ON ENGINE FUEL LINE INSIDE NR 1 PYLON. DRY MOTOR LEAK CHECK GOOD. ACCOMPLISHED IDT OF FUEL LINE LEAK CHECK. NO LEAK FOUND.SDR UALA2013020700740Seal · obstructedLOUD NOISE COMING FROM L1 DOOR. SOUNDS LIKE AIR LEAK. FL 330. 3 HOURS AFTER TAKE OFF. THE NOISE HEARD FROM UPPER OF L1 DOOR. CHECKED PAX ENTRY DOOR SEAL PER AMM. NO DAMAGE FOUND, REMOVED DEBRIS AND CLEANED. PRESSURIZED CABIN. NO AIR LEAK FOUND AT L1 DSDR UALA2013012900539Seal · dirtyEXCESSIVE NOISE DURING CLIMB, RTFL. FOUND DEBRIS ON SEAL AT TOP FWD EDGE. CARRIED OUT CLEANING AND ADJUSTMENT OF DOOR SEAL REF MM 52-09-01 PG801. CARRIED OUT LEAK PRE AND POST ADJUSTMENT REF MM 52-09-01 PG605 PARA D ALL COMPLIANT PER TEST NO NOISE AND CABINSDR UALA2013012800496Smoke Detector · failedDET ZONE 1 CARGO AFT AFT CARGO COMPARTMENT SMOKE DETECTOR ZONE FAILURE. REPLACED CARGO SMOKE DETECTOR, OP CHECKED NORMAL.SDR UALA2013010300027Fuel · leakingNR 1 ENGINE LEAKING FUEL FROM NR 9 DRAIN TUBE, STRUT DRAIN. RAN ENGINE 1 PER JRH REF AMM 71-71-00. DRAIN LINES CLEAR. NO HISTORY LAST 30 DAYS. ONLY EQ4825 FUEL FEED MANIFOLD CHECK ENGINE RUN NORMAL.SDR UALA2012122107317Wire Harness · chafedNR 2 ENGINE FIRELOOP HARNESS IS CHAFED AT 3 O'CLOCK POS BY HEAT SHIELD. CLAMP REMOVED. REPLACED FIRE LOOP WIRING HARNESS FROM M26004 (A1-B2) TO M26005 (A1-B2).SDR UALA2012110806420Circuit Card · faultyON GROUND FOUND STATUS MSG "FIRE CARD ENG R" DISPLAYED ON EICAS. REPLACED R-ENGINE FIRE DET CARD P84A10, STATUS MSG EXTINGUISHED AND FIRE TEST NORMAL.SDR UALA2012101705946Panel · delaminatedFOUND AFT FAIRING PANEL P/N 149W5231-1 WITH TWO INCH DELAM DURING WALK AROUND INSPECTION. ROUTED TO SHOP FOR REPAIR. REMOVED AND INSTALLED AFT FAIRING PANEL P/N 149W5231-1.SDR UALA2012080704252Idg · faultyLEFT GENERATOR INOPERATIVE, FLT DIVERTED. REPLACED IDG. FLUSHED SYSTEM, LEAK AND OPS CHECKED GOOD DURING ENGINE RUN.SDR UALA2012073004103Structure · damagedFWD CARGO DOOR HAS EDGE DAMAGE ON LOWER EDGE. BEND IS 6 INCHES LONG BY 1 INCH WIDE AND IS BENT IN 0.13 5 INCH. ACCOMPLISHED CHECKS PER SRM 52-30-01 FIG 102. BEND AT AN EDGE IN ZONE 2. ACCOMPLISHED NDT CHECK PER NDT PART 6 51-00-01. ACCOMPLISHED PRESSURE RSDR UALA2012062203378Light · missingONE EMERGENCY LIGHT MISSING AT SEAT 1F. NEED TO REPLACE EMERGENCY LIGHT ASSY. EMERGENCY LIGHT ASSY & FUNCTIONAL CHECKED OK.SDR UALA2012062203362Window · scratchedR2 WINDOW SCRATCHES. REMOVED 2R WINDOW PER MM. REPLACED FO NR 2 WINDOW PER MM.SDR UALA2012042402471Seal · damagedFOUND HEAT SHIELD SEAL DAMAGED. REPLACED SEAL PER AMM.SDR UALA2012040202041Plate · looseNR 2 ENGINE PYLON ELECRICAL FEEDER CABLES W8100 & W8101 RETAINMENT PLATE IS LOOSE & HAS MIGRATED AFT. VIEWED FROM INSIDE OF PYLON DISC BOX ON FWD FACE OTBRD MOST FEED THRU.SDR UALA2012032801955Attach Fitting · damagedTWO FILLER PANELS BETWEEN PASSENGER SERVICE UNITS, BETWEEN LEFT AND RIGHT CENTER OVERHEAD BINS ARE HANGING DOWN. REPLACED MISSING CLIPS.SDR UALA2012030701460Connector · improper partWIRE BUNDLE W6236 AT STA 1590 STR 12R CONNECTOR D5188P IS NON COMPLIANT PER FCD 3321-01019 REV B PG 36 STE P 13. REPLACED CONNECTOR PER FCD NO 3321-01019.SDR UALA2012030601441Connector · improper partWIRE BUNDLE W6236 AT STA 1591 STR 12R CONNECTOR D5188J IS NON COMPLIANT PER FCD 3321-01019 REV B PG 36 STEP 13. REPLACED CONNECTOR PER FCD JOB INSTRUCTIONS.SDR UALA2012030601440Connector · improper partWIRE BUNDLE W236 ON OTBD FAIRING M33036 AT STA 1990 RBL 90 ABOVE LAV PER FIG 8 CONNECTOR DM33036C IS NON COMPLIANT PER FCD 3321-01019 REV B PG 40 STEP 23. REPLACED CONNECTOR PER FCD JOB INSTRUCTIONS.SDR UALA2012030601439Connector · improper partWIRE BUNDLE W236 ON OTBD 35IN FAIRING M330 36 AT STA 1990 LBL 90, ABOVE LT AFT LAV, CONNECTOR DM33036C IS NON COMPLIANT PER FCD 3321-01019 REV B PG 36 STEP 12. REPLACED CONNECTOR PER FCD JOB INSTRUCTIONS.SDR UALA2012030601438Connector · improper partWIRE BUNDLE W236 ON OTBD 35IN FAIRING M3303 6 AT STA 1990 LBL 90 ABOVE LT AFT LAV, CONNECTOR DM33036B IS NON COMPLIANT PER FCD NO 321-01019 REV B PG 36 STEP 12. REPLACED CONNECTOR PER FCD JOB INSTRUCTIONS.SDR UALA2012030601437Connector · improper partWIRE BUNDLE W210 ON OTBD 10IN TRANSITION BIN M33010 AT STA 540 LBL 90, CONNECTOR FOR 9IN SIDEWALL LIGHT M33010L1 IS NON COMPLIANT PER FCD 3321-01019 REV B PG 9 STEP 6. REPLACED CONNECTOR PER FCD JOB INSTRUCTIONS.SDR UALA2012030601436Connector · improper partCEILING LIGHT ASSY L33145 LOCATED ABOVE LAV AT STA 1980 RBL 90, CONNECTOR IS NON COMPLIANT PER FCD 3321- 01018 REV B PG 15 STEP 23. REPLACED CONNECTOR PER FCD JOB INTRUCTIONSSDR UALA2012030601435Connector · improper partCEILING LIGHT ASSY L33146 LOCATED AT 84IN OVER DOOR FAIRING M33200 AT STA 1520 RBL 90, CONNECTOR IS NON COMPLIANT PER FCD 3321-01018 REV B PG 11 STEP 39. REPLACED CONNECTOR PER FCD JOB INSTRUCTIONS.SDR UALA2012030601434Connector · improper partCEILING LIGHT ASSY L33145 LOCATED ABOVE LAV AT STA 830 RBL 90, CONNECTOR IS NON COMPLIANT PER FCD 3321-01018 REV B PG 9 STEP 21. REPLACED CONNECTOR PER FCD JOB INSTRUCTIONS.SDR UALA2012030601433Connector · improper partCEILING LIGHT ASSY L33145 LOCATED AT 84IN OVERDOOR FAIRING M33200 AT STA 1520 LBL 90, CONNECTOR IS NON COMPLIANT PER FCD 3321-01018 REV B PG 9 STEP 20. REPLACED CONNECTOR PER FCD INSTRUCTIONS.SDR UALA2012030601432Connector · improper partCEILING LIGHT ASSY L33146 LOCATED AT 84IN OVERDOOR FAIRING M33200 AT STA 1520 LBL, CONNECTOR IS NON COMPLIANT PER FCD 3321-01018 REV B PG 8 STEP 19. REPLACED CONNECTOR PER FCD INSTRUCTIONS.SDR UALA2012030601431Connector · improper partCEILING LIGHT ASSY L33146 LOCATED AT 84IN OVERDOOR FAIRING M33200 AT STA 760 RBL 90, CONNECTOR IS NON COMPLIANT PER FCD 3321-01018 REV B PG 6 STEP 21. REPLACED CONNECTOR PER FCD INSTRUCTIONS.SDR UALA2012030601430Connector · improper partCEILING LIGHT ASSY L33145 LOCATED AT 84IN OVERDOOR FAIRING M33200 AT STA 760 RBL, CONNECTOR IS NON COMPLIANT PER FCD 3321-01018 REV B PG 5 STEP 20. REPLACED CONNECTOR PER FCD JOB INSTRUCTIONS.SDR UALA2012030601429Connector · improper partCEILING LIGHT ASSY L33146 LOCATED AT STA 760 LBL90 AT 84IN OVERDOOR FAIRING, CONNECTOR IS NON COMPLIANT PER FCD 3321-01018 PG 4 STEP 10. REPLACED CONNECTOR PER FCD JOB INSTRUCTIONS.SDR UALA2012030601426Connector · improper partWIRE BUNDLE W236 ON OTBD FAIRING M33036 AT STA 1990 RBL 90 ABOVE LAV PER FIG 8 CONNECTOR DM33036A IS NON COMPLIANT PER FCD 3321-01019 REV B PG 40 STEP 23. SHOULD BE CONNECTOR DM33036B. REPLACED CONNECTOR PER FCD JOB INSTRUCTIONS.SDR UALA2012021600952Flex Hose · rupturedINBOARD FLEX HOSE FOR CENTER HYD SYSTEM FOR NOSE WHEEL STEERING IS RUPTURED AND LEAKING AT TOP OF NOSE LANDING GEAR IN AFT SECTION OF NLG WHEEL WELL. REPLACED BOTH HOSE ASSYS PER REF MM. PRESSURIZED HYD SYS, NO LEAKS FOUND.SDR UALA2012020900783Controller · faultyAPU AUTO SHUTDOWN TWICE. NO TIME TO FIX, DEFER PER MEL. REPLACED APU CONTROLLER.
Back to N799UA