N194UA
Service difficulty reports · 162
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 = 'N194UA' 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 = 'N194UA' 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 UALA2010071502537Light · inoperativeEMERGENCY LIGHT SEAT 1A AFT INOP. RELAMP SEAT EMERGENCY LIGHT, OPS CHECK OKAY.SDR UALA2010071502536Lamp · inoperativeUPPER DECK EMERGENCY CEILING LIGHT ROW 11 INOP. RELAMPED CEILING LAMP, OPS CHECK OKAY.SDR UALA2010061502101Bottle · reads lowNR 2 LT DOOR SLIDE BOTTLE PRESSURE LOW. DEFERED IAW MEL 52010 REF 5211A. REPLACED DOOR 2L DOOR MOUNTED ESCAPE SLIDE RAFT.SDR UALA2010061402060Bearing · migratedRT WING NR 8 FLAP TRACK FWD MOUNT BEARING MIGRATION. ACP BEARING REPLACEMENT IAW SB 747-57-2325, REV 2 AND FIELD REPAIR RECORD UAL-744-0635. REPAIRS ACCOMPLISHED ON THE NR 8 FLAP TRACK FWD MOUNT.SDR UALA2010061402059Bearing · migratedRT WING NR 7 FLAP TRACK FWD MOUNT BEARING MIGRATION. ACP BEARING REPLACEMENT IAW SB 747-57-2325, REV 2 AND FIELD REPAIR RECORD UAL-744-0634. NON ROUTINE 270160.SDR UALA2010061402058Bearing · migratedRH WING #6 FLAP TRACK FWD MOUNT BEARING MIGRATION. ACP BEARING REPLACEMENT IAW SB 747-57-2325 REV 2 AND FIELD REPAIR RECORD UAL-744-0633.SDR UALA2010061402057Bearing · looseLT WING TE FLAP NR 2 TRACK FWD FITTING BEARING ROTATION. ACP BEARING REPLACEMENT IAW SB 747-57-2325 REV 2 AND FIELD REPAIR RECORD UAL-744-0632.SDR UALA2010061402056Bearing · looseLT WING T/E FLAP NR 1 TRACK FITTING BEARING ROTATION. ACP BEARING REPLACEMENT IAW SB 747-57-2325 REV 2 AND FIELD REPAIR RECORD UAL-744-0631.SDR UALA2010061402055Light · inoperativeEMERGENCY LIGHT INOP, DOOR 5L. REPLACED EMERGENCY EXIT LIGHT ASSY AND OP CK NORMAL.SDR UALA2010061002024Fuse · faultyNR 4 RT DOOR EMERGENCY LIGHT INOPERATIVE. REPLACED FUSE. OPS CK NORMAL.SDR UALA2010061002023Battery Pack · inoperativeSEAT EMERGENCY LIGHT INOP AT SEAT 22HG-26HG. REPLACED PACK-EMERGENCY LIGHT. OPS CK NORMAL.SDR UALA2010061002022Battery Pack · faultyCEILING EMERGENCY LIGHT INOP AT C-ZONE, BOTH AISLES. REPLACED BATTERY PACK. OPS CK NORMAL.SDR UALA2010060902007Terminal Block · faultyRH 3RD OVERWING EMERGENCY LIGHT TERMINAL BLOCK (GROUND) BROKEN. REPLACED LIGHT ASSY. OP CK NORMAL.SDR UALA2010060401954Tension Tie · crackedCRACK- 8 EACH FWD TENSION TIE HOLES AT STA 1200 LT. MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGED TENSION TIE. HFEC-NO CRACKS. FABRICATED AND INSTALLED REPAIR PARTS IAW SRM.SDR UALA2010060101883Floorbeam · crackedCRACKED UPPER DECK FLOORBEAM STA 440 RBL 58. REMOVED DAMAGE. HFEC. FABRICATED AND INSTALLED REPAIR IAW KAL FIELD REPAIR RECORD UAL-744-0637 REVISION 00 DATED 27 MAY, 2010.SDR UALA2010060101875Frame · crackedFRAME CRACKED AT TENSION TIE ATTACH POINT STA 1160 LT SIDE. MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGED FRAME. HFEC. FABRICATED AND INSTALLED REPAIR PARTS IAW SRM.SDR UALA2010060101874Frame · crackedCRACK-TENSION TIE ATTACH FRAME HOLE AT STA 1140 RT. MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGED FRAME. FABRICATED AND INSTALLED REPAIR PARTS IAW SRM.SDR UALA2010052701828Tension Tie · damagedTENSION TIE CRACK IN UPPER RADIUS AT STA 1120 LT. REMOVED DAMAGED TENSION TIE. HFEC-NO CRACKS. FABRICATED AND INSTALLED REPAIR PARTS.SDR UALA2010052701827Tension Tie · crackedCRACK- FWD AND AFT TENSION TIE HOLE AT STA 1160 LT. MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGED TENSION TIE. HFEC-NO CRACKS. FABRICATED AND INSTALLED REPAIR PARTS.SDR UALA2010052701826Tension Tie · damagedCRACK-FWD & AFT TENSION TIE HOLE AT STA 1180 RT. MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGED TENSION TIE. HFEC-NO CRACKS. FABRICATED AND INSTALLED REPAIR PARTS.SDR UALA2010052701825Tension Tie · crackedCRACK-FWD TENSION TIE HOLE AT STA 1180 LT. MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGED TENSION TIE. HFEC-NO CRACKS. FABRICATED AND INSTALLED REPAIR PARTS.SDR UALA2010052701824Shear Web · damagedCANTED SHEAR WEB AT STA 1120 RT SIDE CRACKED. REMOVED DAMAGE. HFEC-NO CRACK. REPAIRED IAW MM.SDR UALA2010052701823Failsafe · crackedCRACK-FRAME ATTACH FAIL SAFE CHORD HOLE AT STA 1140 RT. MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGED CHORD. HFEC-NO CRACKS. FABRICATED AND INSTALLED REPAIR PARTS.SDR UALA2010052701822Tension Tie · crackedCRACKED - AFT TENSION TIE UPPER RADIUS AT STA 1120 RT. MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGED TENSION TIE. HFEC-NO CRACKS. FABRICATED AND INSTALLED REPAIR PARTS IAW SRM.SDR UALA2009072002136Skin Panel · crackedRT WING FIXED L/E SKIN PNL HAS CRACK. FOUND ALTERNATE BOLTS FOR SANDWICH DOUBLER. WILL MFG ANOTHER DOUBLER TO PICK UP MORE HOLES. CONTINUED DRILLING AND TRIMMING DOUBLER. REPAIRED PER EVA 72800 REQUIRES REINSPECT EVERY 75 HRS TO BE REPAIRED MAX AUG 19 2009SDR UALA2009071702112Light · inoperativeROW 13 CEILING EEL LIGHT INOPERATIVE. RELAMPED EMERGENCY LIGHT.SDR UALA2009071702111Light · inoperativeSEAT 34L EEL LIGHT INOP. RELAMPED, CHECKS OKAY.SDR UALA2009071702110Light · inoperativeROWS 45 TO 54 LT SEAT EEL LIGHT INOP, MAIN GALLEY FWD LT CORNER TWO LIGHTS INOP, DOOR 4L FWD EEL LIGHT INOP, DOOR 5R AFT EEL LIGHT INOP. RELAMPED, CHECKS OKAY.SDR UALA2009032300870Scanner · malfunctionedEICAS MSG WINDSHEAR SYSTEM. REPLACED SCANNER ASSY AND CMC GND TEST PASS, MSG 34005.SDR UALA2009022000580Slide · deployedUPPER DECK ESCAPE SLIDE DEPLOYED. SLIDE REPLACED.SDR UALA2009021000467Connector · looseEEL LIGHT INOP SEAT 56L. SECURED LOOSE CONNECTOR UNDER SEAT.SDR UALA2009021000466Battery Pack · dischargedEMERGENCY LIGHTS INOP CEILING A AND B ZONE CEILING. REPLACED EMERGENCY BATTERY PACK.SDR UALA2009021000439Battery Pack · activatedEMERGENCY LIGHTS INOP CEILING A AND B ZONE CEILING. REPLACED EMERGENCY BATTERY PACK.SDR UALA2009021000438Light · inoperativeEEL LIGHT INOP SEAT 56L.SDR 2008UALA06014Aspirator · damagedASPIRATOR DAMAGED & ROTOR STATOR BLADES. FOREIGN OBJECT GOT INSIDE ASPIRATOR AND DAMAGED BARREL AND ROTOR STATOR BLADES. REPLACED ASPIRATOR.SDR 2008UALA05909Power Supply · dischargedLEFT OVERWING EXTERIOR EMERGENCY LIGHTS INOP TWO MOST FWD LIGHT ASSY'S. LIGHTS FOUND INOP. REPLACED POWER SUPPLY ASSY. OP CHECKS NORMAL.SDR 2008UALA05908Battery · dischargedEMERGENCY EXIT EEL LIGHT INOP ACROSS DOOR 1 RIGHT LOWER WALL EEL. LIGHT INOPERATIVE. REPLACED BATTERY. OPS CHECKS NORMAL.SDR 2008UALA05907Battery · dischargedEMERGENCY EXIT EEL LIGHT SIGN INOP JUST AFT OF DOOR 1 RIGHT. EXIT SIGN FOUND INOP. REPLACED BATTERY. OPS CHECKS NORMAL.SDR 2008UALA05906Battery · dischargedEMERGENCY EXIT EEL LIGHTS INOP ALL RIGHT SIDE OF FIRST CLASS SEATS. LIGHT INOPERATIVE. REPLACED BATTERY. EEL LIGHTS OPS CHECK NORMAL.SDR 2008UALA04119Light · missingAFT EMERGENCY LIGHT PLATE IS MISSING AT SEAT 4E. *S/D* REPLACED LIGHT ASSEMBLY. OPS CHECK NORMAL.SDR 2008UALA03949Light · missingWFS REPORTED, EMERGENCY LIGHT IS MISSING AT SEAT 51C. *S/D* LIGHT ASSEMBLY MISSING. REPLACED LIGHT ASSEMBLY, OP CHECK GOOD. AC OK FOR SERVICE.
SDR 2008UALA03646Lamp · inoperativeEMERGENCY EXIT EEL LIGHT INOP AT SEAT 35 LEFT. FOUND BURNED OUT LAMP. REPLACED LAMP, OP CHECKED GOOD. AC OK FOR SERVICE.SDR 2008UALA03645Lamp · inoperativeEMERGENCY EXIT LIGHT INOP AT CEILING ROW 14. FOUND BURNED OUT LAMP. REPLACED LAMP, OP CHECKED GOOD. AC OK FOR SERVICE.SDR 2008UALA03644Lamp · inoperativeEMERGENCY EXIT EEL LIGHT INOP AT SEAT 4J AFT LIGHT ASSY. FOUND BURNED OUT LAMP. REPLACED LAMP, OP CHECKED GOOD. AC OK FOR SERVICE.SDR 2008UALA03643Lamp · inoperativeEMERGENCY EXIT EEL LIGHT INOP AT SEAT 4A FWD LIGHT ASSY. FOUND BURNED OUT LAMP. REPLACED LAMP, OP CHECKED GOOD. AC OK FOR SERVICE.SDR 2008UALA03550Engine · bird ingestionBIRDSTRIKE TO NR 2 ENGINE. RTFL. CREW SUSPECTED A BIRDSTRIKE, AND SHUT THE ENGINE DOWN AS A PRECAUTION. BORESCOPE INSPECTION REVEALED NO CORE DAMAGE; BIRDSTRIKE DAMAGE CONFINED TO FAN BYPASS AREA. FIVE FAN BLADES WERE BENT FORWARD, WITH MINOR NICKS TO OTHERSDR 2008UALA02471Relay · faultedGALLEY 415 ALL ELECTRICAL PANELS VERY HOT 1HR INTO FLT. SECURED GALLEY EMERGENCY POWER SWITCH PANELS COLD. FOUND FAULTY CHILLER RELAY. REPLACED RELAY OP CHECKED GOOD. AC OK FOR SERVICE.SDR 2008UALA02327Vent · leakingAIRCRAFT HAD 2 MAJOR FUEL SPILLS OUT OF RT WING VENT WHILE DEFUELING TO FERRY. ALL WING TANKS WERE FULL AT THE TIME EXCEPT CENTER WHICH WAS BEING PUMPED OUT. PROBLEM HAS TO BE FUEL LEAKING INTO A TANK, NOT VTO PROBLEM.SDR 2008UALA01800Bulb · inoperativeRIGHT EXT SLIDE LIGHT, 3RD LIGHT AFT HAS ONE BULB INOP. REPLACED LAMP OPS CHECKED GOOD. AC OK FOR SERVICE.SDR 2008UALA01799Light · inoperativeFOUND SEAT 4J EMERGENCY LIGHT IS INOPERATIVE. REPLACED AFT LIGHT STRIP.
Back to N194UA