N642UA
Service difficulty reports · 354
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 = 'N642UA' 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 = 'N642UA' 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 UALA2012042402454Light · inoperativeTHE 4TH EMERGENCY OVERWING EGRESS LIGHT AFT ON LEFT SIDE IS INOP. RELAMPED, NO HELP. CENTER CONTACT SPRING IS SHOT. NEEDS LIGHT ASSY. NON-STOCK P-N S283T008-45.SDR UALA2012042002355Ground Wire · unsecureEQUIPMENT COOLING FAULT ON TAXI OUT. FWD EQUIPMENT VALVE MESSAGE DISPLAYED. SECURED GROUND WIRE AND FAULT CLEARED. SYSTEM OPS CHECKED GOOD.SDR UALA2012041502279Shutoff Valve · faultyNO APU BLEED AIR FOR CABIN APU RUNS ELECT OKAY. REPLACED BLEED VALVE, NO HELP. ACP'D MEL REQUIREMENTS. REPLACED APU SHUTOFF VALVE AND FLOW CONTROL VALVE PER MM. RESET APU CONTROLLER, OPS NORMAL.SDR UALA2012031901751Connector · looseREF DF 391, LOG12, LOG15 ALL HAVE HISTORY AFT ENG REMOVED AT TPA, HAVE L-R PIMU BITES L ENG TAI HAS HISTORY, L ENG VIB HAS HISTORY, BOTH EEC HAS FAULTS BIT L PIMU FAULTING EEC -PIMU MODE DISAGREE, EEC CHA A&B CAT2, EEC CHA A&B EXTERNAL-DIS DISAGREE, EEC CHA A&SDR UALA2012031501713Pressure Switch · faultyBSTR PUMP LOW PRESS LT-OFF-,SW-OFF-, NO EICAS MSG. POSITION 5 (5=L FWD, 6=L AFT,9=R FWD,10=R AFT).I CENTER BOOST PUMP INOP L-. REPLACE L FWD PUMP PRESSURE SWITCH PER MM, OPS NORMAL.SDR UALA2012031401669Actuator · faultySPOILER 2 FLOAT WITH RIGHT HYD SYS OFF-REFLY. REMOVED AND REPLACED NR 2 SPOILER PCA IAW MM. LEAK AND OPERATIONAL CHECK GOOD IAW MM.SDR UALA2012031401667Switch · faultyAFTER APU START AT FL350, EICAS RAT UNLOCKED LIGHT ILLUMINATED. SUSPECT RAT DOOR SLIGHTLY OPEN WITH POWER TRANSIENT. NO VIBRATION FELT. REFLY. RMV'D & RPLC'D S369 RAT UP LIMIT SWITCH PER MM. OPS CHECKED GOOD PER MM.SDR UALA2012031201575Housing · defectiveRIGHT FORWARD BOOST PUMP INOP IN RIGHT MAIN FUEL TANK. REPLACED RIGHT MAIN BOOST PUMP HOUSING AND FWD AND AFT BOOST PUMPS OPS CHECK AND LEAK CHECK GOOD.SDR UALA2012022701160Strap · damagedRT FAILSAFE STRAP AT STA 955 FAILED ULTRA-SOUND TEST. ACCOMPLISHED COA 618451 RT STA 955 FLSF STRP RWK (SB 767-53A100 REV 1).SDR UALA2012022701159Channel · corrodedFWD CARGO STA 560, RBL 18 CORROSION ON 'C' CHANNEL. MAJOR REPAIR ACCOMPLISHED. INSTALLED NEW 'C' CHANNEL BETWEEN STA 540 - 560, RBL 18.SDR UALA2012022701141Stringer · crackedSTR 36R CRACKED AT STA 1809.5 FRAME ATTACH FITTING. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED STRINGER.SDR UALA2012022701137Stringer · crackedSTR 39R CRACKED AT STA 1809.5 FRAME ATTACH FITTING. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED STRINGER.SDR UALA2012022701149Attach Fitting · crackedSTA 1809.5 AFT BULKHEAD TO STR ATTACH FITTING CRACKED AT STR 36L. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED AFT END ATTACH FITTING.SDR UALA2012022701148Attach Fitting · bentFRAME 1809.5 FWD ATTACH FITTING BENT AT STR 36L. MAJOR REPAIR ACCOMPLISHED. INSTALLED NEW ATTACH FITTING.SDR UALA2012022701147Attach Fitting · bentFRAME 1809.5 ATTACH FITTING TO STR 36R BENT. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED STRINGER END FITTING.SDR UALA2012022701146Attach Fitting · bentFRAME 1809.5 FWD ATTACH FITTING BENT AT STR 39R. MAJOR REPAIR ACCOMPLISHED. INSTALLED NEW ATTACH FITTING.SDR UALA2012022701144Attach Fitting · bentFRAME 1809.5 FWD ATTACH FITTING BENT AT STR 39L. MAJOR REPAIR ACCOMPLISHED. INSTALLED NEW ATTACH FITTING.SDR UALA2012022701143Attach Fitting · bentFRAME 1809.5 ATTACH FITTING BENT AT STR 32L FWD. MAJOR REPAIR ACCOMPLISHED. INSTALLED NEW ATTACH FITTING.SDR UALA2012022701142Stringer · crackedSTA 32L CRACKED AT STA 1809.5 ATTACH FITTING. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED STRINGER.SDR UALA2012022701140Attach Fitting · bentFRAME 1809.5 FWD ATTACH FITTING BENT AT STR 36R. MAJOR REPAIR ACCOMPLISHED. INSTALLED NEW ATTACH FITTING.SDR UALA2012022701139Stringer · crackedSTR 36L CRACKED AT STA 1809.5 FRAME ATTACH FITTING. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED STRINGER.SDR UALA2012022701136Stringer · crackedSTR 39L CRACKED AT STA 1809.5 FRAME ATTACH FITTING. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED STRINGER AND END FITTING.SDR UALA2012022701135Skin · damagedFUSELAGE SKIN FWD OF STA 1809.5 TO STA 1767 DAMAGED BUCKLED FROM BL 0 STR 39L - 39R. REPLACED CENTER SKIN.SDR UALA2012022701134Skin · damagedFUSELAGE SKIN FWD OF STA 1809.5 TO STA 1767 DAMAGED BUCKLED STR 39R - 26R. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED FILLER, DOUBLER, AND TRIPLER.SDR UALA2012022701133Skin · damagedFUSELAGE SKIN FWD OF STA 1809.5 TO STA 1767 DAMAGED BUCKLED FROM STR 39L - 26L. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED FILLER, DOUBLER AND TRIPLER.SDR UALA2012022401110Bulkhead · bentSTA 1809.5 AFT BULKHEAD WEB CREASED BENT AT STR 36L TO 36R. MAJOR REPAIR ACCOMPLISHED. RMV'D AND RPL'D STA 1809.5 AFT LWR BULKHEAD WEB.SDR UALA2012022401106Fastener · looseSTA 1725.5 FRAME FWD SIDE OF FRAME STR 30L HAS RIVETS LOOSE, PUSHING ON ATTACH FITTING. REMOVED FASTENERS AT STA 1725.5, STR 26L AREA, ACCOMPLISHED NDT OF HOLES NO CRACKS NOTED, INSTALLED NEW FASTENERS.SDR UALA2012022401105Frame · bentSTA 1725.5 FRAME CHORD BENT-PUSHED IN FWD SIDE OF FRAME STR 30L. REPAIRED FRAME CHORD AT STA 1725.5, STR 30L.SDR UALA2012022701196Display · inoperativeP-R LOWER ECAM AND F/O DISPLAY UNIT NOT OPERATING. RMV'D & RPLC'D LOWER ECAM DISPLAY UNIT.SDR UALA2012022401113Stiffener · crackedSTA 1809.5 AFT BULKHEAD STIFFENER CRACKED, BENT AT RBL 8. MAJOR REPAIR ACCOMPLISHED. RMV'D AND RPL'D AFT BULKHEAD STIFFENER STA 1809.5.SDR UALA2012022401112Bulkhead · damagedSTA 1809 BULKHEAD RIGHT SIDE INBOARD HORIZ HINGE DEFECT INDICATION NOTED ON 2 EA HOLES, 1 LOCATED ON HINGE SECOND ONE DOWN AND 1 LOCATED ON BRACE FIRST INBOARD HOLE. RESULTS FROM NDT, RMV'D FASTENERS, REAMED HOLES, ACCOMP NDT NO CRACKS NOTED, INSTALLED NEW FASDR UALA2012022401115Stiffener · crackedSTA 1809.5 AFT BULKHEAD STIFFENER CRACKED BENT AT LBL 8. RMV'D AND RPL'D AFT BULK HEAD STIFFENER AT STA 1809.5, LBL 8.SDR UALA2012022401114Stiffener · crackedSTA 1809.5 AFT BULKHEAD STIFFENER CRACKED, BENT AT BL 0. RMV'D AND RPL'D AFT BULKHEAD STIFFENER STA 1809.5, BL 0.SDR UALA2012022401111Bulkhead · damagedHOLE ELONGATED ON 1809 BULKHEAD LT SIDE CUTOUT AT APPROXIMATELY LBL 27, 15TH HOLE FROM TOP OF LT CUTOUT. RMV'D FASTENER, REAMED HOLE, ACCOMP NDT NO CRACKS NOTED, INSTALLED NEW FASTENER.SDR UALA2012022401109Frame · damagedFRAME 1809.5 BULKHEAD BENT-BULGED FWD SIDE ABOVE STR 36L - 36R. RMV'D AND RPL'D FRAME FWD CHORD.SDR UALA2012022401108Frame · buckledFRAME 1809.5 SKIN CHORD BUCKLED FROM STR 36L - 36R. RMV'D AND RPL'D FRAME STA 1809.5.SDR UALA2012022301096Skin · damagedSTA 1725.5 EXTERNAL SKIN TORN-BENT AT LAP JOINT AND BUTT JOINT STR 32L. ACCOMPLISHED EXTERNAL SKIN REPAIR PER ECRA 5380-01078.SDR UALA2012022201068Skin · corrodedAFT OF CARGO BAY AT BS 1544, BL 0 INTERNAL SKIN IS CORRODED AROUND DRAIN VALVE. MAJOR REPAIR ACCOMPLISHED, REMOVED CORROSION AND FOUND MATERIAL LOSS OUT OF LIMITS OF SRM. TRIMMED OUT DAMAGE AND ACCOMPLISHED NDT OF REPAIR AREA AND OPEN HOLES FOR CRACKS. NONESDR UALA2012022201066Slide · unwanted deployDURING MANUAL OPERATION OF THE DISARM FEATURE FROM THE EXTERNAL HANDLE OF THE L2 DOOR IAW TASKCARD 683301410, THE SLIDE DEPLOYED. REMOVED AND REPLACED SLIDE ASSEMBLY REF AMM. OPS CHECKED GOOD.SDR UALA2012022001026Failsafe · damagedLEFT BS 955 FAILSAFE STRAP DAMAGED. ACCOMPLISHED SMC038 FAILSAFE STRAP REWORK ON TASKCARD 3872N00714.SDR UALA2012022001027Failsafe · damagedRIGHT BS 955 FAILSAFE STRAP DAMAGED. ACCOMPLISHED REPAIRE ON FAILSAFE STRAP ON TASKCARD 3872N00715.SDR UALA2012021500892Guard · corrodedL2 DOOR SPLASH GUARD CORRODED AT THE DOOR SILL. FABRICATED AND INSTALLED FILLERS, ANGLE AND PLATE PER ECRA 5360-01178 AND EA PD67- 53-045.SDR UALA2012021500891Floor Support · corrodedAFT LEFT ENTRY DOOR HAS CORROSION INBD OF THRESHOLD ON FLOOR SUPPORT AT BS 1510. FABRICATED AND INSTALLED FILLERS, ANGLE AND PLATE PER ECRA 5360-01178 AND EA PD67- 53-045.SDR UALA2012020600690Slide · unserviceableLEFT WING OW SLIDE INFLATION HOSE KINKED AND TWISTED OUT OF LIMITS. REMOVED & REPLACED LEFT OVERWING SLIDE.SDR UALA2012013000572Wire · brokenCARGO FIREX BOTTLE 1 AND 2 FAILS, DOES NOT SHOW ON EICAS. NO EICAS CARGO BOTTLE 2 LIGHT. RE-TERMINATED BROKEN WIRE AT D5673P PER SWPM 20-61-16, OPS CHECK GOOD PER AMM 26-23-00 AND TC 612224910.SDR UALA2012012500528Floorbeam · damagedPASSENGER CABIN AT STA 1197 RBL 56-80 FLOORBEAM IS SHOWING BARE METAL AROUND FASTENER HOLES AND GOUGES. COUNTER TOP REPLACED BY PEMCO VENDOR (REGENT) IAW 4 FLIGHT CMM 25-30-24, 8130 FURNISHED ON PEMCO NR 3872N00988. INCORRECT ACTION TAKEN FOR PTT 1552114, SHSDR UALA2012012500527Stiffener · crackedNLG WHEEL WELL STA 287 LT VERT STIFFENER CHORD FAILED HFEC INSPECTION. CRACK INDICATION APPROX 55 INCHES ABOVE BOTTOM OF CHORD WHERE MARKED. CUT OUT DAMAGE, FABBED AND INSTALLED FILLER AND ANGLES (3 EA) PER SRM 51-40-02 ON NR 3872N00117.SDR UALA2012012500526Floorbeam · corrodedPASS CABIN FLOOR STRUCTURE AT STA 347, LBL 43 - 49 FLOORBEAM IS CORRODED. MAJOR REPAIR ACCOMPLISHED: CUT OUT DAMAGE, FABBED AND REPLACED T-CAP, 2 ANGLES, AND STRAP REPAIR PER SRM 51-40-02 ON NR 3872N00516.SDR UALA2012011900393Skin · dentedEXT FUSELAGE SKIN DENTED STA 654+110, STR 30L. DENT WITHIN LIMITS, HFEC OF AREA FOUND MATERIAL DISTRESSED. CUT OUT DAMAGE, FABBED AND INSTALLED DOUBLER AND FILLER IAW SRM 53-00-01 AND 51-40-02 ON PEMCO NR 3872N00076.SDR UALA2012011600311Doubler · crackedNR 1 PYLON, PREVIOUS REPAIR ANGLE DOUBLER IS CRACKED AT INBOARD SIDE. REMOVED NR 1 PYLON MIDSPAR CLOSEOUT ANGLE PREVIOUS REPAIR ANGLE DOUBLER-TRIPLER. FABRICATED A REPAIR SPLICE AND STRUCTURAL FILLER AND INSTALLED PER REO G13357, REV A AND UAL EVA 73769 ON N
Back to N642UA