N791UA
Service difficulty reports · 188
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 = 'N791UA' 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 = 'N791UA' 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 UALA2013042302807Module · faultyUNABLE TO DIM CABIN CEILING LIGHTS BACK 1-2 BUSINESS +ECON PLUS. REPLACED NR 2 ZMU.SDR UALA2013041502590Actuator · failedAPU STATUS MESSAGE DISPLAYED, APU SHUTDOWN, APU REMAINED OPEN. APU INOPERATIVE IN FULL OPEN POSITION, DOOR WILL NOT CLOSE. REPLACED INLET DOOR ACTUATOR PER MM.SDR UALA2013041502597Light · missingSEAT 1F AFT EMERGENCY LIGHT MISSING. REPLACED EMERGENCY LIGHT. TESTED OKAY.SDR UALA2013041502557Idg · failedLT ENGINE IDG FAILED. REPLACED LEFT ENGINE IDG. OPS TESTED NORMAL. LEFT ENGINE RAN, OPS NORMAL IDG, GENERATOR LIGHTS, VOLTS AND FREQS CHECKED NORMAL.SDR UALA2013041502555Gcu · failedLEFT ENGINE GCU OFF LIGHT ON, AFTER PUSHBACK. REPLACED LEFT GCU PER MM, TESTED OKAY.SDR UALA2013040902360Switch · failedLEFT GENERATOR DRIVE LIGHT INOPERATIVE. CONFIRMED IDG OPERATION. FAULT IS IN SWITCH. REPLACED CAP. RAN ENGINE. VERIFIED NORMAL, OPS CHECKED OK.SDR UALA2013032701974Exciter · inoperativeRIGHT ENGINE IGNITOR 1 INOPERATIVE. ENGINE WAS SLOW TO START WITH RI IGNITION. REPLACED EXCITER 671-1323 AND LEAD 671-1324 AS PER AMM. R ENG IGNITOR SYSTEM 1 OPERATING NORMALLY.SDR UALA2013032701973Connector · dirtyAPU CONTROL STATUS MESSAGE DISPLAYED ON LOWER EICAS. FOUND SPEED SENSOR NR 2 CIRCUIT FAILED AND SPEED SENSOR NR 2 LOWER THAN SENSOR 1. CLEANED AND SECURED SPEED SENSOR 2 CONNECTOR IAW AMM 49-61-02. RAN APU TEST, NO FAULTS.SDR UALA2013030601332Indicator · faultySTANDBY ALT KEEPS FLICKERING AND RESETS TO LOCAL-ALT SETTING. REPLACED INDICATOR.SDR UALA2012101705938Overheat Loop · failedBLEED LOOP 2 BODY FAILURE. REPLACED LOOP, TESTED OK.SDR UALA2012100305608Light · looseSEAT 3F ARMREST EMERGENCY LIGHT LOOSE. SECURED LIGHT ASSY OK.SDR UALA2012090705052Antenna · erodedORANGE ANTENNA BEHIND NOSE GEAR DAMAGED. AIRPHONE ANTENNA HAS EROSION AT BASE SERVICEABLE BUT NEEDS UPGRADE. VERIFY NO DAMAGE JUST EROSION. CF PER GMM 05-30-06. REPLACED ANTENNA AND APPLIED SEALANT OK.SDR UALA2012080904322Valve · faultyECON COOL VALVE RIGHT PACK ECONOMY COOLING VALVE NOT IN COMMANDED POSITION. STATUS MSG01- ACTIVE CRUISE MODE DEPENDENT; ECONOMY COOLING VALVE (R PACK) IS NOT IN COMMANDED POSITION. DB- CABIN TEMPERATURE CONTROLLER (R CHAN2) MSG-2124902 ACTIVE ER MODE. REPLASDR UALA2012080704245Drive Unit · failedWINDSHEAR SYSTEM EITHER PREDICTIVE OR REACTIVE WINDSHEAR ALERTING FUNCTIONS ARE FAILED SUCH THAT WINDSHEAR ALERTING CAPABILITY IS REDUCED OR NOT AVAILABLE. A REACTIVE WINDSHEAR FAILURE WILL ONLY SET THE MESSAGE WITH THE REACTIVE WINDSHEAR OPTION ACTIVE. ADVISDR UALA2012080104133Spar · corrodedLEFT WING REAR SPAR WEB CORRODED AROUND FASTENERS BETWEEN IRSS 340 AND 350 WHERE FUEL BOOST PUMP IS INSTALLED. BLENDED OUT CORROSION. NO CRACKS FOUND BY HFEC. ACCOMPLISHED PERMANENT REPAIR PER ECRA 5720-02313 .SDR UALA2012062903435Helicoil · failedWHEN REMOVING IDG OIL-FUEL HEAT EXCHANGER TUBE SEAL FOR INSPECTION THE ATTACHMENT BOLT HELICOIL CAME OFF FROM THE MAIN FUEL PUMP. REPLACED LEFT FUEL PUMP AS PER A MM 73-11-01. ACCOMPLISHED ENG WET MOTOR AND IDLE LEAK TEST PER AMM 71-00-00, NO FAULT FOUND.SDR UALA2012052702937Mount · out of positionNR 1 ENGINE AFT MOUNT HAS MIGRATED LINK BEARING. MIGRATION APPROXIMATELY 0.125 INCH. REPLACED AFT LOWER ENGINE MOUNT PER AMM.SDR UALA2012050802662Warning Message · illuminatedELMS P110 STATUS DISPLAYED.SDR UALA2012050402646Skin · damagedLIGHTNING STRIKE DISCHARGE ON FUSELAGE BELLY SKIN FOR AND AFT OF WING TO BODY FAIRING. REPAIRED, ALODINED AS NECESSARY.SDR UALA2012050402624Module · faultyELMS P110 STATUS DISPLAY. -MTC MESSAGE 24-11069 DISPLAYED DURING TROUBLESHOOTING.SDR UALA2012031301659Fmu · faultyREPLACE FUEL PUMP AND METERING UNIT FMU AS FOLLOW UP TO TAILPIPE FIRE REMOVED NR 1 ENGINE FMU REF MM. MR73205-57 OFF PER EG6769-1. REPLACED NR 1 ENG FUEL METERING UNIT PER MM, REFERENCE EG6769-1.SDR UALA2012031301649Panel · damagedLT LOWER WING PNL 561AB IS DAMAGED. RMV'D PANEL & ROUTED TO SHOP FOR REPAIR R57160, PANEL RE-INSTALLED BY AMT.SDR UALA2012031301648Panel · damagedLEFT WING LOWER PANEL 552HB REMOVED FOR HEAT DAMAGE AND SENT TO SHOP 273. PART ROUTED TO SHOP 273 FOR PANEL REPAIR R57043, PANEL RE-INSTALLED BY AMT.SDR UALA2012031301647Panel · damagedLT WING LOWER PANEL 552KB REMOVED FOR HEAT DAMAGE AND SENT TO SHOP FOR REPAIR R57042, PANEL RE-INSTALLED BY AMT 024668.SDR UALA2012031301646Panel · damagedLEFT LOWER WING PNL 552LB IS DAMAGED. REMOVED PANEL AND ROUTED TO SHOP FOR REPAIR R57157, PANEL RE-INSTALLED BY AMT.SDR UALA2012031301644Panel · damagedLEFT WING LOWER PANEL 552JB REMOVED FOR HEAT DAMAGE AND SENT TO SHOP 273. PART ROUTED TO SHOP FOR PANEL REPAIR, PANEL RE-INSTALLED.SDR UALA2012030701461Battery · dischargedSEAT 35C EEL LIGHT INOPERATIVE. OPS CHECK OKAY AFTER BATTERY CHARGED.SDR UALA2012030601442Power Supply · inoperativeREF JC 2-2020-A, SEAT MOUNTED EMER LT INOP AT LT SIDE, SEAT 31CDE UP TO 43DE. REPLACED POWER SUPPLY AND BATTERY M33401 & M33409 PER MM.SDR UALA2012030601443Power Supply · inoperativeREF JC 2-2020A, SEAT MOUNTED EMER LIGHT INOP AT RT SIDE, SEAT 31HJ UP TO 43GF. RPL POWER SUPPLY AND BATTERY M33401 & M33409 PER MM.SDR UALA2012030601414Flaperon · damagedREMOVED DAMAGED LT FLAPERON PER MM. REMOVED AND REPLACED R57039. ACP SMC 058 ON WU U8736K LT WING FLAPERON REMOVED. INSTALLED FLAPERON AND TORQUE MOUNTS BOLTS AND ACTUATOR BOLTS. ACP PER AMT. ADJUSTED FLAPERON, OP CHECK GOOD.SDR UALA2012030501374Fairing · damagedLEFT I/B FLAP O/B FWD CANOE FAIRING IS DAMAGED. REMOVED CANOE PER MM.SDR UALA2012030501373Fairing · damagedLEFT I/B FLAP O/B AFT CANOE FAIRING IS DAMAGE. REMOVED CANOE PER MM.SDR UALA2012030501368Connector · faultyWIRE BUNDLE W236 ABOVE LT AFT LAV ON OTBD FAIRING M33036 AT STA 1990 LBL 90, CONNECTOR DM33036A IS NON COMPLIANT PER FCD NO 3321-01019 REV A PG 35 STEP 11. REPLACED CONNECTOR PER FCD NO 3321-01019 REV A PG 35 STEP 11, OPS CKS GOOD.SDR UALA2012030601415Panel · damagedPANEL ABOVE HEAT SHIELD ON ENG 1 OTBD SIDE PNL PART 313W3701-3 REMOVED FOR HEAT DAMAGE AND ROUTED TO THE SHOP FOR REPAIR IR TAG 313W3801-3. REMOVED AND REPLACED R57041. REMOVED AND REPAIRED PNL.SDR UALA2012030501369Connector · improper partRIGHT AFT LAV WIRE BUNDLE W236 ON OTBD 35IN FAIRING M33036 AT STA 1990 RBL 90, CONNECTOR DM33036A IS NON COMPLIANT PER FCD NO 3321-01019 REV A PG 39 STEP 21 BY- 138136. REPLACE CONNECTOR DM33036A PER FCD 3321-01019 REV A PAGE 39 STEP 21. REPLACE CONNECTOR DMSDR UALA2012030701507Fmu · faultyNR 1 ENG WOULD NOT SHUT DOWN AFTER TWO ATTEMPTS. FUEL VALVE L ENG STATUS. MAINT MSG 73-60211. STATUS MSG WAS ALSO DISPLAYED WHEN ACFT WAS PICKED UP FROM GATE. ACCOMPLISHED CALLOUT EG6740 (PTT SEQ 7032006), NO FAULTS, NO MESSAGES. NR 1 ENG REQUIRES START ASDR UALA2012030501367Connector · faultyWIRE BUNDLE W236 ABOVE LT AFT LAV ON OTBD 35IN FAIRING M33036 AT STA 1990 LBL 90, CONNECTOR DM33036C IS NON COMPLIANT PER FCD 3321-01019 REV A PG 35 STEP 11. REPLACED CONNECTOR.SDR UALA2012030501365Light · defectiveCEILING LIGHT ASSY L33146 LOCATED AT 84IN OVERDOOR FAIRING M33200 AT STA 1520 LBL 90, CONNECTOR IS NON COMPLIANT PER FCD NO 3321-01018 REV B PG 8 STEP 19. REPLACED LIGHT ASSY, OPS CHECKED OKAY.SDR UALA2012030501364Connector · faultyCABIN LIGHTING HARNESS W6236 LOCATED ON STR CLIP BETWEEN STA 1580 & 1601 ON STR 12R, CONNECTOR D5188J IS NON COMPLIANT PER FCD NO 3321-01019 REV A PG 41 STEP 4. REPLACED CONNECTOR PER FCD 3321-01019.SDR UALA2012030501363Connector · faultyCEILING LIGHT L33146 OVER DOOR 2R FAIRING AT STA 760 RBL 90, CONNECTOR IS NON COMPLIANT PER FCD NO 3321-01 018 REV B STEP 21 PG 6. REPLACED CEILING LIGHT CONNECTOR REF FCD 3321-01018.SDR UALA2012030501362Connector · faultyCEILING LIGHT ASSY L33145 AT STA 760 RBL 90, CONNECTOR IS NON COMPLIANT PER FCD NO 3321-01018 REV B STEP 20 PG 5. REPLACED CEILING LIGHT CONNECTOR REF FCD 3321-01018.SDR UALA2012030501361Light · defectiveCEILING LIGHT ASSY L33146 LOCATED ABOVE LAV AT STA 830 LBL 90, CONNECTOR IS NON COMPLIANT PER FCD 3321-0 1018 REV B PG 6 STEP 2. REPLACED LIGHT ASSY, OPS CHECKED OKAY.SDR UALA2012030501360Light · defectiveCEILING LIGHT ASSY L33146 AT 84IN OVERDOOR FAIRING M33200 AT STA 1520 RBL 90, CONNECTOR IS NON COMPLIANT PER FCD NO 3321-01018 REV B PG 11 STEP 39. REPLACED LIGHT ASSY PER MM.SDR UALA2012030501359Light · defectiveCEILING LIGHT ASSY L33145 LOCATED ABOVE LAV AT STA 830 RBL 90, CONNECTOR IS NON COMPLIANT PER FCD NO 3321- 01018 REV B PG 9 STEP 21 BY- 138136. REPLACED LIGHT ASSY PER MM.SDR UALA2012030501358Light · faultyRIGHT AFT LAV WIRE BUNDLE W236 ON OTBD 35IN FAIRING M33036 AT STA 1990 RBL 90, CONNECTOR DM33036B IS NON COMPLIANT PER FCD NO 3321-01019 REV A PG 39 STEP 21. REPLACED LIGHT ASSY PER MM. PLANE SIDE CONNECTOR STILL NON COMPLIANT.SDR UALA2012030501357Light · defectiveCEILING LIGHT ASSY L33145 OVER DOOR 2L FAIRING AT STA 760 LBL 90, CONNECTOR IS NON COMPLIANT PER FCD NO 3321 -01018 REV B STEP 11 PG 4. REPLACED LIGHT ASSY, OPS CHECKED OKAY.SDR UALA2012030501356Light · defectiveCEILING LIGHT L33146 OVER DOOR 2L FAIRING AT STA 760 LBL 90, CONNECTOR IS NON COMPLIANT PER FCD NO 3321-0101 8 REV B STEP 10 PG 4. REPLACED LIGHT ASSY, OPS CHECKED OKAY.SDR UALA2012030501366Connector · faultyCABIN LIGHTING HARNESS W6169 LOCATED ON STR CLIP BETWEEN STA 1580 & 1601 ON STR 12R, CONNECTOR D5188P IS NON COMPLIANT PER FCD NO 3321-01019 REV A PG 41 STEP 4. REPLACED CONNECTOR. TESTS OKAY.SDR UALA2012022701195Pump · faultyC2 HYD DEMAND PUMP FAILING MAT TEST, OVERSPEED FAULT. REPLACED C2 AIR DRIVEN PUMP TURBINE GEARBOX ASSY PER AMM AND LOGIC-SPEED CONTROL UNIT.SDR UALA2012022401123Pump · faultyHYD PUMP DEM C1 LOW CENTER HYDRAULIC DEMAND PUMP NR 1 PRESSURE WHEN COMMANDED ON, OR CENTER DEMAND PUMP NR 1 OVERHEATED. RPLC'D C1 ADP HYDRAULIC PUMP, NO HELP. MODULATING SOV OPERATES AND PNEU PRESS AVAIL TO AIR DRIVE UNIT. INOP ADP PER MEL 2911F. NEEDS AD
Back to N791UA