N476UA
Service difficulty reports · 113
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 = 'N476UA' 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 = 'N476UA' 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 UALA2010012900377Battery Pack · faultyDURING GROUND CHECK OF THE EMERGENCY LIGHTS SYS. AFT L EPSU BATTERY FAULTED. REPLACED BATTERY PACK AND RETESTED EMERGENCY LIGHT SYS AND TEST PASSED OK.SDR 2008UALA05398Unknown · odorF/A AND CPT CREW SMELLED AN ELECTRIC ODOR UPON LANDING ALSO ON APPROACH. ACCOMPLISHED POWER RUNS ON BOTH ENGINES, COMPARING BLEEDS FOR ODOR AT POWER AND AT IDLE, CHECKING COMBINATIONS OF BLEEDS AND PACKS. NO UNUSUAL ODORS NOTED, NO ELECTRICAL ODORS NOTED. PSDR 2007UALA04354Skin · puncturedTAKEOFF RUNWAY DEBRIS CAUSED NR 2 ENG NOSE COWL OUTER SKIN PUNCTURE AND FAN COWL SKIN DAMAGE. A/C STRIKING FOD TO NR 2 ENG AREA OR FUESLAGE FROM BLOWING CONSTRUCTION DEBRIS ON TAKE OFF. A/C FERRIED TO ORD WHERE NOSE NR 2 NOSE COWLING WAS REPLACED.SDR 2007UALA02872Skin · buckledFUSELAGE SKIN BUCKLED, RT SIDE AFT OF PIT DOOR BETWEEN FR 59-61 STR 35-39. WHEN RIVETS REMOVED FROM CLIPS, FOUND GAP BETWEEN SKIN AND CLIPS EXCEEDING .031". MAJOR REPAIR ACCOMPLISHED: REPLACED 4 CLIPS AND INSTALLED DOUBLER REPAIR AT FRAME 59 AND STRINGER 35SDR 2007UALA02852Sill · corrodedR2 DOOR SILL HAS CORROSION JUST FWD OF FRAME 66. REMOVED AND DRAIN AND FWD GIRT BAR PLATE. FABRICATED 2 REPAIR ANGLES. INSTALLED REPAIR. REINSTALLED DRAIN AND GIRT BAR PLATE.SDR 2007UALA01938Fuse · blownUPON ENGINE 1 AND 2 FIRE TEST, GETTING HALF A TEST AND OPPOSITE BOTTLE DISCHARGE LIGHT INDICATION ON OTHER ENGINE. JUST INBOARD LIGHTS ON FIRE SW COMES ON. REPLACED NR 2 XFMR (36LP) FUSE AT LOCATION (G). ALL TESTS NORMAL, NO REPEATS.SDR 2007UALA01558Tape · peelingSTRONG VIBRATION IN AFT GALLEY REPORTED BY FLT ATTENDANTS. STRONG ENOUGH TO VIBRATE ITEMS OFF COUNTER. SUPPLEMENTAL DATA UPDATE PERFORMED RUDDER FREEPLAY CHECK AND FOUND WITHIN LIMITS. FOUND EROSION PROTECTOVE TAPE PEELING FROM LEADING EDGE OF VERTICAL STABILSDR 2007UALA01310Gauge · damagedLOW PRESSURE READING ON GAUGE. LEAK AROUND PRESSURE GAUGE THREADS. REMOVED PRESSURE GAUGE AND FOUND STRIPPED THREADS ON GAUGE AND GAUGE ADAPTOR. REPLACED GAUGE AND ADAPTOR, RECHECKED FOR LEAKS. CHECKS OK. TECHNICIAN LEFT AND NEW TECHNICIAN HAS BEEN GIVEN SDR 2007UALA01138Fire Warning · false activationCREW REPORTS AFT PIT FIRE WARNING SOUNDED. FLT ATTENDANT AND FLT CREW CONFIRMED SMOKE IN CABIN, FLT CREW FIRED CARGO BOTTLES. [SUP 06-06-07] FIRE DEPARTMENT AND FBO MECHANIC PERFORMED A COMPLETE INSPECTION OF CARGO BAYS, AVIONICS COMPARTMENTS AND CABIN. DIDSDR 2007UALA00125Actuator · faultyRTFL DUE TO LOSS OF LEFT ELAC. REPLACED TRIM ABLE HORIZONTAL STABILIZER ACTUATOR. SYSTEM OPS CHECKS OK.SDR 2005UALA01433Light · inoperativeEEL LIGHTS AT SEATS 4, 5, 8, 9, 15, 16, 17, 21, 22 AND 23 ARE INOPERATIVE. REPAIRED SHORT UNDER SEAT 8A AND REPLACED 110WL2.SDR 2005UALA00102Warning Light · illuminatedVENT AVIONICS FAULT WITH VENT SKIN VALVE MESSAGE. ECAM PAGE SHOWS SKIN AIR OUTLET VALVE (22HQ) AT FAULT. PERFORMED CFDS TEST, CONFIRMED VALVE AT FAULT AND REPLACED.SDR 2002UALA00286Power Supply · dischargedDOOR 2L EMERGENCY EXIT LIGHT INOPERABLE. REINSTALLED POWER SUPPLY. OPERATIONAL CHECK NORMAL.
Back to N476UA