N653UA
Service difficulty reports · 315
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 = 'N653UA' 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 = 'N653UA' 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 2002UALA00034Beam · corrodedBODY STATION 874 LBL 12 TRANSVERSE BEAM CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SPLICE.SDR 2002UALA00033Floorbeam · corrodedBODY STATION 1219 LBL 20-44 T-CAP CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED T-CAP.SDR 2002UALA00032Floorbeam · corrodedBODY STATION 1197 + 66 LBL 25-44 T-CAP CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED T-CAP.SDR 2002UALA00031Floorbeam · corrodedBODY STATION 284 RBL 70 FLOOR EDGE BEAM CORRODED. MAJOR REPAIR ACCOMPLISHED. INSTALLED NEW EDGE BEAM.SDR 2002UALA00030Fastener · corrodedBODY STATION 1335-1345 STRINGER 20R STRINGER FASTENERS AND WEB CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED FASTENERS AND WEB.SDR 2002UALA00029Floorbeam · corrodedBODY STATION 1197-1188 RBL 40-44 RBL 20-25 LBL 6-9 LBL 40-44 T-CAP CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED T-CAP.SDR 2001UALA00042Battery Pack · inoperativeEMERGENCY LIGHTING INOP FIRST CLASS, LEFT RIGHT AND CROSS AISLE. *S/D* BATTERY PACK REPLACED FOR LT EEL LIGHTS. REPLACED POWER SUPPLY STRIP FOR RT F/C EEL AND ACCOMPLISHED PERMANENT REPAIR OF EEL STRIP.SDR 2000UALA00404Fan · failedCREW NOTICED ELECTRICAL BURNING SMELL IN COCKPIT ONLY. UTILITY BUSSES AND RECIRC FANS SHUT OFF AND EQUIP COOLINGIN STDBY. SMELL DISSIPATED. CONTINUED TO ORD. AIRCRAFT RETURNED TO GATE WITH REPORT OF SMOKEY ODOR AND FWD EQUIP COOLING EXHAUST FAN C-B POPPINGSDR 98UAL900009Warning Syst · malfunctionedUPON EVACUATION OF AIRCRAFT, AURAL WARNING SIGNAL FAILED TO OPERATE MID CABIN TO AFT CABIN. *S/D* THIS PROBLEM WAS NOT DUPLICATED. AFTER POWER WAS RESTORED, THE SYSTEM OPERATIONALLY CHECKED NORMAL. THE SYSTEM HAS ONLY ONE POWER SOURCE FOR THE FORWARD, CENTSDR 98UAL900008Wire · chafedSHORT CIRCUIT IN FRONT OF P39 PANEL RESULTED IN LOCALIZED FIRE AFT OF FORWARD GALLEY CHILLER. THE I/B WIRE BUNDLE WAS FOUND WITH SEVERE DAMAGE. DIVERTED TO LHR. *S/D* ALL WIRES REPAIRED PER BOEING STANDARD WIRING PRACTICES MANUAL CH 20. BECAUSE OF THE SEVSDR 97UAL900689Pneumatic Sys · inoperativeAPU PNEUMATIC PRESSURE AT 5 PSI, PNEUMATICS INOP.SDR 98UAL900010Latch · jammedRIGHT OVERWING SLIDE FAILED TO DEPLOY. *S/D* INVESTIGATION INTO THE CAUSE OF THIS PROBLEM HAS SHOWN THAT THE ELECTRICAL PORTION OF THE SYSTEM WORKED PROPERLY. THE ACTUATION OF THE DOOR LATCH WAS JAMMED. THE MASS OF THE TARGET COUPLED WITH NORMAL A/C VIBRATSDR 97UAL900016Psu · burnedSMOKE AND BURNING SMELL COMING FROM PASSENGER SERVICE UNIT ABOVE SEATS 1AB. *S/D* THE OVERHEAD SEAT DECODER AT SEAT 1AB WAS BURNED INTERNALLY. THERE WAS NO SIGN OF MOISTURE OR OTHER EXTERNAL CAUSE OF THE SMOKE DAMAGE. REPLACED THE OVERHEAD SEAT DECODER, OPSDR 95UAL900204Fan Blade · bentPOSSIBLE BIRD STRIKE/INGESTION IN LEFT ENGINE, HAD UNUSUAL NOISE AND VIBRATION DURING CLIMB, RETURNED TO LHR. FOUND TWO FAN BLADES WITH BENT LEADING EDGES AT BLADE MID SPAN. REPLACED BENT BLADES AND THEIR MATCHING PAIRS.SDR 95UAL900036Eel · inoperativeEEL LIGHT IN RIGHT AISLE OF FORWARD GALLEY INOP. REPLACED POWER STRIP CONNECTOR.
Back to N653UA