N787UA
Service difficulty reports · 214
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 = 'N787UA' 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 = 'N787UA' 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 2006UALA00749Skin · dentedFIVE DENTS ON LWR FUSELAGE BETWEEN STATIONS 498 & 504 & STRINGERS 44R & 49L. DENTS WERE REPAIRED PER SRM53-00-01, REPAIR 13.THE REPAIR TERMINATES THE REPETITIVE INSPECTION REQUIRED BY EVA 50760.DENTS CAUSED BY CONTACT WITH GROUND EQUIPMENT.SDR 2006UALA00479Control Panel · damagedAFT GALLEY LOST POWER TO RIGHT SIDE. AFT GALLEY LOST POWER TO RIGHT SIDE. COULD NOT RESTORE POWER WITH CB RECYCLE. FOUND BURNED WIRING WITHIN THE AFT GALLEY POWER PANEL AND CIRCUIT BREAKER POPPED. SUSPECT CIRCUIT OVERLOAD FROM INCREASED RESISTANCE WITHIN GALSDR 2005UALA01223Skin · delaminatedNR 2 SLAT LWR SURFACE DELAMINATED AT INBOARD END 3 INCHES FROM THE TRAILING EDGE. INTERIM REPAIR PER 777 AMM 57-43-99. ACP AN INITIAL INSP AT 50 CYCLE AND EVERY 500 FLT CYCLE UNTIL PERMANENT REPAIR ACPL AT NEXT HMV (5JUNE06). OK TO CF PER AMM AND SFOIQ WALSDR 2005UALA01222Skin · delaminatedNR 3 SLAT LWR SURFACE DELAMINATED AT OUTBOARD END 4 INCHES FROM TRAILING EDGE. INTERIM REPAIR PER 777 AMM 57-43-99. ACP AN INITIAL INSP AT 50 CYCLE AND EVERY 500 FLT CYCLE UNTIL PERMANENT REPAIR ACPL AT NEXT HMV (5JUNE06). OK TO CF PER AMM AND SFOIQ WALSH.SDR 2005UALA01221Skin · delaminatedNR 5 SLAT LWR SURFACE DELAMINATED AT INBOARD END NEAR TRAILING EDGE. INTERIM REPAIR PER 777 AMM 57-43-99. ACP AN INITIAL INSP AT 50 CYCLE AND EVERY 500 FLT CYCLE UNTIL PERMANENT REPAIR ACPL AT NEXT HMV (5JUNE06). OK TO CF PER AMM AND SFOIQ WALSH.SDR 2005UALA00672Lamp · inoperativeSEAT 1F AFT EMERGENCY PROX FLOOR LIGHT INOP. REPLACED LIGHT ASSY.SDR 2004UALA00038Light · brokenEEL LIGHT BROKEN ON WALL BEHIND SEAT 9F. EEL LIGHTS INOP IN ROWS 1 THRU 9. EEL LIGHTS ARE INOP LEFT HAND WALL OF CENTER LAV 1. REPLACED LIGHT 2 & 3. SECURED CONNECTOR ON BATTERY PACK.SDR 2003UALA00435Skin · delaminatedT/E WEDGE LOWER SKIN DELAMINATED. MAJOR REPAIR ACCOMPLISHED. REMOVED, REPAIRED AND REINSTALLED T/E WEDGE, LT WING, SLAT NR 1.SDR 2002UALA01897Windshield · crackedWINDSHIELD 1R OUTER PANE CRACKED. THE NR 1 RT WINDSHIELD OUTER GLASS PLY SHATTERED BECAUSE OF ARCING IN THE INTERLAYER DUE TO MOISTURE INGRESSION. THE UPPER EDGE OF THE WINDOW ASSY. REVEALED EVIDENCE OF MOISTURE INGRESS BETWEEN THE GLASS PLIES NEAR THE UPPESDR 2001UALA01194Slide · failedSLIDE RAFT FAILED AIR RETENTION TEST DURING OVERHAUL.SDR 2001UALA00461Generator · failedLOST RT ENG GEN PRIOR TO ENTERING ETOPS. RIGHT GENERATOR CONTROL BREAKER (GCB) OPEN OR GENERATOR CONTROL SWITCH OFF AND ENGINE NOT SHUT DOWN. DIVERT TO LHR. SUPPLEMENTAL DATA UPDATE ELEC GEN SYS R EICAS MESSAGE WAS DISPLAYED WITH ASSOCIATED MAINTENANCE MESSSDR 2000UALA00822Connector · contaminated38A COVE LIGHT OUT. *S/D* IT APPEARS THAT MOISTURE FROM AN IMPROPERLY SHINGLED INSULATION BLANKET DRIPPED ONTO THE LIGHT CONNECTOR CAUSING A SHORT. A SERVICE BULLETIN THAT DISTURBS THE BLANKET IN THIS AND OTHER AREAS MAY HAVE BEEN THE CAUSE. A CALLOUT WAS SDR 2000UALA00332Oxygen Bottle · leakingEN ROUTE SFO-FRA, CREW REPORT CREW OXYGEN SHOWING 450 PSI. SHOULD READ 1250 PSI. DIVERTED TO BGR. *S/D* OXYGEN WAS SERVICED PER AMM 12-15-08. CHECKED COCKPIT OXYGEN MASK, NO LEAKS FOUND. ENGINEER ASSIGNED TROUBLESHOOTING TASK TO ACCOMPLISH FIM 35-11, TASSDR 97UAL900508Window · crackedA STRONG ELECTRICAL ODOR BEGAN JUST PRIOR TO DESCENT FROM FLIGHT LEVEL 370. NO SMOKE OBSERVED. CRACK FOUND IN FIRST OFFICERS SLIDING WINDOW UPON LANDING. WINDOW HOT.
Back to N787UA