N657UA
Service difficulty reports · 337
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 = 'N657UA' 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 = 'N657UA' 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 2002UALA01019Floorbeam · corrodedAFT PIT FLOORBEAM T-CAP CORRODED BODY STATION 1241, RBL 44. MAJOR REPAIR ACCOMPLISHED. REPAIRED AND INSTALLED T-CAP.SDR 2002UALA00996Floorbeam · gougedCABIN FLOORBEAM UPPER SURFACE GOUGED NEXT TO GALLEY FITTING AT BODY STATION 807, RBL 29. MAJOR REPAIR ACCOMPLISHED. REMOVED AND REPLACED FLOORBEAM SPLICE DOUBLER.SDR 2002UALA00990Floorbeam · corrodedCABIN FLOORBEAM UPPER SURFACE CORRODED AT BS 800-825, RBL 54. MAJOR REPAIR ACCOMPLISHED. REPAIRED FLOORBEAM.SDR 2002UALA00988Spar · crackedNAC STA 221, NR 2 ENGINE PYLON, UPPER SPAR WEB, IS CRACKED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED REPAIR PARTS.SDR 2002UALA00987Floorbeam · corrodedBS 1300 LBL 40-44 T-CAP FLOORBEAM CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED T-CAP REPAIRS.SDR 2002UALA00985Spar · crackedNAC STA 221, NR 2 ENGINE PYLON, AFT UPPER SPAR WEB IS CRACKED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED REPAIR PARTS.SDR 2002UALA00982Skin · chafedBS 1809.5, LT FUSELAGE AT HORIZONTAL STABILIZER, LOWER SURFACE SKIN CHAFFED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED DOUBLER AND FILLER.SDR 2002UALA00981Skin · chafedBS 1809.5, RT EXTERIOR FUSELAGE, HAS EXCESSIVE CHAFFING AT LOWER BANANA FAIRING. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED DOUBLER AND FILLER.SDR 2002UALA00980Floorbeam · corrodedBS 852, LBL 34, FLOORBEAM CORRODED, MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED FLOORBEAM SECTION AND SPLICES.SDR 2002UALA00979Floorbeam · corrodedBS 830-870, RBL 11, WL 200, UPPER CHORD CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED FLOORBEAM REPAIR.SDR 2002UALA00978Floorbeam · crackedBS 786, LBL 12, FLOORBEAM CRACKED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED NEW FLOORBEAM SECTION.SDR 2002UALA00989Floorbeam · crackedBS 287 FLOORBEAM CRACKED, LEFT HAND SIDE. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED REPAIR PARTS.SDR 2002UALA00972Floorbeam · crackedBS 287 FLOORBEAM CRACKED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED REPAIR PARTS.SDR 2002UALA00971Skin · damagedBS 400-420, STRINGER 36R-30R SKIN DOUBLER HAS BLIND FASTENERS. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED DOUBLER.SDR 2002UALA00970Floorbeam · corrodedBS 790, LBL 11, WL 200 TOP OF FLOORBEAM CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED REPAIR PARTS AND SPLICES.SDR 2002UALA00450Indicator · out of toleranceEICAS MSG TRAILING EDGE FLAP DISAGREE DISPLAYED. EMERGENCY DECLARED. LANDING WAS UNEVENTFUL. TEMPORARY INTERRUPTION IN THE FLAP/SLAT ELECTRONICS UNIT (FSPM) CAUSED A DISAGREE INDICATION TO GENERATED ON EICAS DISPLAY. ONE TIME DISRUPTION OF SYSTEM. ACCOMPLSDR 2001UALA01451Light · brokenDOOR 1L EMER EXIT LIGHT IS BROKEN.SDR 2001UALA01436Light · brokenDOOR 1L EMER EXIT LIGHT IS BROKEN.SDR 2001UALA00546Link · missingLT MAIN LANDING GEAR HAS EVIDENCE OF CONTACTING UPPER WING PANEL DURING RETRACTION. *S/D* STABILIZING LINK WAS FOUND MISSING, ALLOWING UPSTOP FTG TO ROTATE FREELY, THEREBY CAUSING A PRELOAD BETWEEN GEAR AND GEAR DOOR. THIS CAUSED THE OVER-RETRACTION. LINSDR 2001UALA00252Web · corrodedAFT PIT BS 1280 RBL 18 FLOOR WEB CORRODED. INSTALLED REPAIR DOUBLER REF: SRM 51-70-13 FIGURE 01.SDR 2001UALA00251Web · crackedNR 2 PYLON UPPER WEB AT IDG CABLE HOLE ACCESS HAS TO CRACKS. INSTALLED REPAIR DOUBLER REF: 54-53-02.SDR 2001UALA00250Web · crackedNR 1 PYLON UPPER WEB AT IDG CABLE HOLE ACCESS HAS 2 CRACKS AT NP HOLES. INSTALLED REPAIR DOUBLER REF: SRM 54-53-02.SDR 2001UALA00246Web · crackedNR 1 PYLON WEB CRACKED AT OUTBOARD DRAIN HOLE JUST FORWARD OF IDG CUTOUT INSIDE PANEL 441DT. INSTALLED REPAIR DOUBLER REF: SRM 54-53-02.SDR 2000UALA00702Engine · leakingON ROLLOUT, FLIGHT ATTENDANTS IN MID SECTION SMELLED SMOKE IN GALLEY / LAVATORY AREA. AIRCRAFT RETURNED TO FIELD. SUPPLEMENTAL DATA UPDATE CHECKED CARBON FILTERS IN FWD CARGO PIT AND MIXER AREA, NO FAULTS NOTED. ACCOMPLISHED HIGH POWER ENGINE RUN AND NO SMOSDR 2000UALA00611Squib · will not testLEFT WING EMERGENCY EXIT SQUIB WILL NOT TEST.SDR 2000UALA00487Control Panel · inoperativeRUDDER TRIM INOP. DIVERTED DEN. *S/D* REPLACED RUDDER TRIM CONTROL PANEL (P/N: 233T6201-21).SDR 2000UALA00334Skin · lightning strikeAPPROXIMATELY 30 LIGHTNING STRIKES ON THE LEFT HAND SIDE STARTING FROM STA 785.9 FWD TO RADOME. HITS ARE ON CROWN, AROUND DOOR 1L AND BELOW CAPTS 3 & 2 WINDOWS AND ON RADOME, RT SIDE. RTF. OVERWEIGHT LANDING. *S/D* LIGHTNING STRIKE ON LEFT HAND SIDE OF AIRCSDR 99UAL900390Engine · failedENGINE FAILURE ON TAKEOFF. DUMPED FUEL. AMBER ALERT.SDR 99UAL900287Connector · failedWEATHER RADAR FAILED AFTER DEPARTING JFK. DIVERTED TO IAD DUE TO THUNDERSTORMS EN ROUTE. *S/D* THE WEATHER RADAR TRANSCEIVER (P/N 622-5122-103, MR43114 - 2032) WAS REPLACED AT IAD. THE SYSTEM OPS CHECKED NORMAL. UPDATE: 7/12/99 THE COAX CONTACT INSERT OSDR CA990310084Valve · failedFL330 CABIN RATE BEGAN TO CLIMB AT MORE THAT 2,000 FEET PER MINUTE. ATTEMPTED AUTO MODE TO NR 2 MANUAL CABIN, STILL CLIMBING WITH OUTFLOW FULLY CLOSED. THE O2 MASKS DEPLOYED. DIVERTED TO RNO. *S/D* UPPER PRESSURE RELIEF VALVE (MR21313, SN OR DASH 2690) RESDR 99UAL900277Valve · failedFL330 CABIN RATE BEGAN TO CLIMB AT MORE THAT 2,000 FEET PER MINUTE. ATTEMPTED AUTO MODE TO NR 2 MANUAL CABIN, STILL CLIMBING WITH OUTFLOW FULLY CLOSED. THE O2 MASKS DEPLOYED. DIVERTED TO RNO. *S/D* UPPER PRESSURE RELIEF VALVE (MR21313, SN OR DASH 2690) RESDR 97UAL900595Oil · decreasedRIGHT ENGINE OIL QUANTITY DECREASED TO 1 QUART. AIRCRAFT DIVERTED TO YQX. ENGINE WAS NOT SHUT DOWN. *S/D* SUSPECT LEAK AT NR 3 BEARING OIL SCAVENGE TUBE UPPER B-NUT. NO DEFECTS WERE FOUND. POSSIBLE INSTALLATION OR TORQUING ERROR. REVIEWED INSTALLATION ASDR 97UAL900150Light · inoperativeEMERGENCY EXIT LIGHTING (EEL) STRIP WAS INOPERABLE FROM SEAT 11G THROUGH RIGHT SIDE OF THE MID GALLEY. REPAIRED ASSEMBLY PER MM 2-0-15-5. OPERATIONS CHECK NORMAL.SDR 96UAL900895Check Valve · failedTHE RIGHT PACK WAS NOISY AND CAUSING A VIBRATION IN THE FORWARD CABIN DURING THE FLIGHT. THE AIRCRAFT DIVERTED TO JFK. *S/D* THE NOISE AND VIBRATION WAS CAUSED BY A LOOSE FLAPPER IN THE SUPPLY FAN CHECK VALVE. THE CHECK VALVE WAS REPLACED PER MM 21-58-02, SDR 96UAL900636Fire Warning · malfunctionedAIRCRAFT RETURNED TO THE FIELD AT SFO UNDER AMBER ALERT DUE TO A FIRE BELL AURAL WARNING. *S/D* THE ENGINE FIRE DETECTION SYSTEM CAUSED THE AURAL WARNING. A BITE TEST WAS PERFORMED AND INDICATED NO FAULTS. THE M1000 BELL CHIME MODULE WAS REPLACED AS A PRECSDR 96UAL900431Power Cable · failedFOUND INOPERABLE EMERGENCY EVACUATION LIGHT STRIP FROM SEAT 11E BACK TO 19E. FOUND SIDEWALL CONNECTOR DAMAGED. REPLACED COMPLETE POWER CABLE FROM SIDEWALL TO LIGHT STRIPS. OPERATIONS CHECK INDICATES EEL NOW FULLY OPERATIONAL.SDR 95UAL900218Eel · inopEMERGENCY ESCAPE PATH LIGHTING INOP AT GALLEY. REPLACED LIGHT, CHECKS OK.
Back to N657UA