N122UA
Service difficulty reports · 353
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 = 'N122UA' 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 = 'N122UA' 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 CALA2013090591042Shear Web · crackedBS 1120 RT CANTED SHEAR WEB CRACKED AT FASTENER HOLE. REMOVED DAMAGE, MANUFACTURED & INSTALLED REPAIR DOUBLER IAW AMM 53-10-99 PAGE 208 PARA 10 D.SDR CALA2013090591041Shear Web · crackedBS 1120 LT CANTED SHEAR WEB CRACKED AT FASTENER HOLE. REMOVED DAMAGE, MANUFACTURED & INSTALLED REPAIR DOUBLER IAW AMM 53-10-99 PAGE 208 PARA 10 D.SDR UALA2013062504404Apu · odorVERY STRONG OIL ODOR IN ENTIRE CABIN WITH APU BLEED ON AND PACKS ON. REPLACED APU IAW AMM 49-11-01-401. OPS AND LEAK CHECKED NORMAL.SDR UALA2013061304078Transmitter · inoperativeNR 1 HYD QUANTITY INDICATION INOPERATIVE ON LOWER EICAS DISPLAY. WHEEL WELL INDICATOR ALSO INOP FOR NR 1 SYS. . REPLACED HYD QTY TRANSMITTER IAW MM, OP CHECKED NORMAL.SDR UALA2013050803226Sensor · faultyFAN AIR VALVE FAILED TO OPEN WHEN BLEED AIR APPLIED. BLEED AIR TEMP SENSOR SNAP SHOT SHOWS ERRATIC READ INDICATION NR 4 ENG. REPLACED TEMP SENSOR PER AMM 36-22-02-401. OPS CHECKED NORMAL.SDR UALA2013041502532Display · malfunctionedSTATUS NO LAND 3 AND IDS DU DISPLAYED. CREW REPORTED F/O PFD BLANKED AND SMELL OF BURNING IN AREA OF DISPLAY UNIT. REMOVED F/O PFD PER MM AND CONFIRMED BURNING ODOR FROM DU. REPLACED DU PER MM AND ACP SOFTWARE INSTALLATION PER MM, F/O PFD NOW OPS NORMAL.SDR UALA2013041502531Thermostat · faultyFIRST OFFICER'S AFT SIDE WINDOW NOT BEING HEATED KEEPS FROSTING OVER. REPLACED NR 3 WINDOW CONTROL THERMOSTAT PER MM, WINDOW HEATS OKAY.SDR UALA2013041502586Display · failedNO LAND 3 AND IDS DU DISPLAYED. CREW REPORTED F/O PFD BLANKED AND ODOR OF BURNING IN AREA OF DISPLAY UNIT. REMOVED F/O PFD PER MM AND CONFIRMED BURNING ODOR FROM DU. REPLACED DU PER MM 31-61-02 AND ACCOMPLISHED SOFTWARE INSTALLATION PER MM, F/O PFD NOW OPS SDR UALA2013040902384Light · brokenFOUND 34C EMERGENCY LIGHT BROKEN. REPLACED EMERGENCY LIGHT AND CHECKED OK.SDR UALA2013040802305Controller · faultyPASSENGER ADDRESS STATUS MESSAGE. REPLACED PASSENGER AREA CONTROLLER, OPS CHECKED GOOD.SDR UALA2013040402263Packing · leakingRT OUTBD AILERON PACKAGE LEAKING HYD FLUID. FLUID FOUND BOTH BOTTOM AND TOP OF WING. OPERATED AILERON THROUGH MULTIPLE CYCLES, NO LEAKS FOUND.SDR UALA2013040402262Skin · damagedAFT RIGHT INBD FLAP, FABRIC ON INBD SIDE OF FLAP HAS A .5 INCH HOLE IN FWD EDGE. REPAIRED HOLE IN SEAL.SDR UALA2013040402256Skin · damagedBARE METAL IS VISIBLE ON THE SURFACE OF SPOILERS ON LT WING, TOP SURFACE. SANDED AND PAINTED NR 5 SPOILER REF GN MM 5-0-4-033.SDR UALA2013040402255Fastener · missingON TOP OF RIGHT WING, ABOVE NO THREE ENGINE ON SMALL PANEL, SINGLE FASTENER HEAD MISSING FROM PANEL. REPLACED MISSING HEAD FASTENER PER MM.SDR UALA2013040402264Seal · tornMID INBD FLAP, ACCORDIAN SEAL ON FWD UPPER SEAL WHAT 2.5 INCH RIP. ACP REPAIR ON MID INBD FLAP ACCORDIAN SEAL PER MM.SDR UALA2013040402258Fastener · damagedON TOP OF RIGHT WING BETWEEN ENG 3 AND 4, BUT CLOSER TO ENG 3, SIX FASTENER HEADS IN A ROW ARE MISSING FROM THE PANEL, AND ARE MARKED WITH MASKING TAPE. REPLACED 11 FASTENERS INSTEAD OF 6 ON ORIGINAL TEXT WITH SCREWS AND NUTS REF 51-40-03.SDR UALA2013040402257Rub Strip · damagedMID AND AFT PHENOLIC RUB STRIP ON INBD SIDE OF RIGHT MID AND AFT FLAPS HAVE SECTIONS OF PHENOLIC MISSING AROUND THE EDGES. AFTER SEALANT CURES ON RIGHT AFT FLAP INBD RUB STRIP, REMOVE SAFETY WIRE & MICARTA STRIPS AND SECURE LOOSENED SCREWS ON ACCORDION SEAL. SDR UALA2013032902030Controller · faultedAFTER ACFT POWER UP, CHECKED "E" ZONE BETWEEN DOOR 4 AND 5, CEILING AND SIDEWALL LIGHTS KEEPS ON, CANNOT TURN OFF. RESET E & E BAY P414 E-ZONE CEILING & SIDEWALL LIGHT CIRCUIT BREAKER TWICE, CEILING & SIDEWALL LIGHTS BEEN TURN OFF. E-ZONE SOME SEATS READING SDR UALA2013031801598Wire Harness · defectiveNR 2 EGT ROSE TO 450 PRIOR TO ADDING FUEL W/FUEL CONTROL ON EGT ROSE ABOVE 650. REPLACED EGT HARNESS W006 PER MM. OP CHECKED GOOD PER MM 77-21-00-501 ON ENG RUN.SDR UALA2013022601166Controller · failedINTERPHONES INOPERATIVE AT 4L, 4R AND 5L, 5R. REPLACED NR 3 LAC PER MM .SDR UALA2013022501130Sill · dirtyDOOR 1R WON`T ARM. CLEANED DEBRIS FROM DOOR SILL DOOR ARMING, OP CHECKS GOOD.SDR UALA2013020500707Thermostat · failedWINDOW HEAT 2L EICAS STATUS MESSAGE DISPLAYED. POWER OFF, OVERHEAT OR WINDOW HEATER FAILURE. REPLACED CONTROL THERMOSTAT S760, GROUND CHECKED OK AND MESSAGE GONE.SDR UALA2013020400681Skin · crackedON WALKAROUND FOUND 3 INCH CRACK ON NR 3 ENGINE PYLON PANEL. FOUND CRACKED FROM SCREW HOLE TO EDGE ABOUT 1.5 INCH. MM 06-09-99,PG 215 PANEL 472WR. INTERIM REPAIRED PER ECRA 5450-02013.SDR UALA2012121407205Power Supply · inoperativeDURING A6 CHECK, FOUND EMERGENCY LIGHT EXIT R2 DOOR SIGN DIM. REPLACED POWER SUPPLY PER AMM TASK 33-51-04-002-017 AND TASK 33-51-04-402-023.SDR UALA2012103106259Light · missingPER LOW TECH EMERGENCY LIGHT MISSING AT SEAT 33C. REPLACED LIGHT ASSY.SDR UALA2012103106270Module · failedNR 4 ENGINE SQUIB TEST FAILS TEST NR 2 REF NR 3 SVC. DEFERRED DUE TIME, COMPLIED WITH MEL 2621ZF. INTEGRITY TEST OK. REPLACED SQUIB TEST MODULE PER AMM. TESTS NORMAL.SDR UALA2012090605025Windshield Wiper · out of adjustFLIGHT DECK F/O SIDE WINDSHIELD WIPER STUCK BELOW STOP POSITION, CANNOT MOVE. ADJUSTED WIPER ARM AT CORRECT POSITION AND OPS CHECKED WIPER NORMAL.SDR UALA2012090404934Light · inoperativeEMERGENCY LIGHT INOPERATIVE AT L1 DOOR. REPLACED LIGHT ASSEMBLY, SYSTEM OKAY.SDR UALA2012083104916Wire Harness · deterioratedWINDSHIELD R1 FOUND WIRING HARNESS END BADLY DETERIORATED. GLARESHIELD AND WINDSHIELD REMOVED, WIRING HARNESS REPLACED. ACCOMPLISH OPERATIONAL CHECK OF WINDSHIELD HEATER SYSTEM.SDR UALA2012083104908Power Supply · failedEMERGENCY EXIT LIGHTS VERY DIM SEAT ROWS 33 LEFT THRU 43 LEFT. REPLACED POWER SUPPLY. OPS NORMAL.SDR UALA2012083104907Lamp · inoperativeEMERGENCY EXIT LIGHT INOPERATIVE SEAT ROW 36 LEFT. REPLACED LAMP, OPS NORMAL.SDR UALA2012083104906Connector · unsecureEMERGENCY EXIT LIGHT INOPERATIVE SEAT ROW 43 LEFT. SECURED CONNECTOR UNDER SEAT 43C. OPS NORMAL.SDR UALA2012083104905Lamp · inoperativeEMERGENCY EXIT LIGHT INOPERATIVE. RIGHT EXTERIOR OVERWING SECOND FROM FORWARD LIGHT ASSY FORWARD LAMP. REPLACED LAMP, OPS NORMAL.SDR UALA2012083104904Lamp · inoperativeEMERGENCY EXIT LIGHT INOPERATIVE UPPER DECK SEAT ROW 14 LEFT. RELAMPED, OPS NORMAL.SDR UALA2012083104901Lamp · inoperativeEMERGENCY EXIT LIGHT INOPERATIVE. UPPER DECK CEILING ROW 16. REPLACED LAMP, OP CHECKED NORMAL.SDR UALA2012083104900Lamp · inoperativeEMERGENCY EXIT LIGHT INOPERATIVE. UPPER DECK CEILING ROW 15. REPLACED LAMP, OP CHECKED NORMAL.SDR UALA2012083104899Lamp · inoperativeEMERGENCY EXIT LIGHT INOPERATIVE CEILING ROW 2. SUPPLEMENTAL DATA UPDATE, REPLACED LAMP, OP CHECKED NORMAL.SDR UALA2012083104898Lamp · inoperativeFLIGHT DECK EMERGENCY EXIT LIGHT INOPERATIVE . REPLACED LAMP, OP CHECKED NORMAL.SDR UALA2012072003942Lamp · inoperativeEMERGENCY LIGHT UPPER DECK STAIRS CEILING LIGHT INOP. RELAMPED, OP CHECKED NORMAL.SDR UALA2012072003941Lamp · inoperativeEMERGENCY LIGHT ROW 33 RT INOPERATIVE. RELAMPED, OP CHECKED NORMAL.SDR UALA2012062203353Ballast · inoperativeTHE 13JK SIDEWALL LIGHT INOP. RELAMPED, NO HELP. BALLAST REPLACED AND LIGHT TUBE REPLACED, NIL HELP. NEED MORE TIME FOR TROUBLESHOOTING. REPLACED BALLAST. OPS OK.SDR UALA2012062203333Cable · defectivePIGTAIL P43 SPARKED WHEN IT WAS PLUGGED INTO THE GALLEY CART MODULE. DEACTIVATED FOOD CART CONTROLLER N43, BREAKER PULLED AND WRAPPED WITH DF STICKER. COLLARED BREAKER AND SECURED PIGTAIL END. REPLACED THE PIGTAIL P43 NEW TECH CART CABLE PER AMM. TESTED THSDR UALA2012062203318Cable · sparksPIGTAIL P43 SPARKED WHEN IT WAS PLUGGED INTO THE GALLEY CART MODULE. DEACTIVATED FOOD CART CONTROLLER N43, BREAKER PULLED AND WRAPPED WITH DF STICKER. COLLARED BREAKER AND SECURED PIGTAIL END. PARTS: 561-2282 9F21904-503 CABLE.SDR UALA2012052402912Structure · damagedLEFT WINGLET OTBD SIDE HAS LIGHTNING STRIKE ON ONE FASTENER LOCATED 1-3 UP ON VERTICAL ROW OF REAR SPAR. LOCATED WITHIN CRITICAL AREA REF CF987 AND 989 REMOVED LEFT WINGLET. NEW WINGLET UP AND TORQUED. BUT MID FAIRING FWD SECTION DOES NOT FIT. TRIED SWAPPISDR UALA2012042302437Panel · erodedNR 3 ENG PYLON UPPER FWD PANEL HAS EROSION ON INBRD LEADING EDGE OF PANEL. REPAIRED & PRIMED, PAINTED.SDR UALA2012042302418Skin · damagedRT WING UPPER FIXED L/E PANEL PREVIOUS REPAIR IS ERODED. LOCATED 2ND PANEL I/B OF NR 3 ENGINE. AT I/B LEADING EDGE STATION 495. REPAIRED PANEL PER SRM.SDR UALA2012042302406Panel · crackedRT WING UPPER FIXED L/E PANEL HAS A FOUR INCH CRACK LOCATED 2ND PANEL I/B OF NR 3 ENGINE. AT INBOARD L/E SKIN STATION 498, 8 INCHES FROM L/E AND 16IN FROM OUTBOARD EDGE OF PANEL, 1. REPAIRED PANEL PER SRM.SDR UALA2012042302405Lamp · burned outAFT CREW REST AREA EXIT EMERGENCY SIGN HAS BURNED OUT LAMPS. RELAMPED, OP CHECKED NORMAL.SDR UALA2012042302403Battery Pack · inoperativeDOOR 3R EXIT EMERGENCY SIGN IS INOPERATIVE. REPLACED BATTERY PACK FOR LIGHT ASSY, OPS NORMAL.SDR UALA2012042302402Lamp · inoperativeSEAT ROW 49HJK EMERGENCY LIGHT IS INOPERATIVE. RELAMPED, OPS NORMAL.
Back to N122UA