N387UA, cancelled Jul 28, 2005
Service difficulty reports · 28
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 = 'N387UA' AND deregistration_id = 'N387UA-2005-07-28' 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 = 'N387UA' AND deregistration_id = 'N387UA-2005-07-28' 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 DU4R0507132Skin · dentedBS 1024, S-6L-S-7L HAS A DENT WIDTH 1.5 INCH X .070 DEPTH.SDR DU4R0507131Skin · misrepairedFUSELAGE RT SIDE BS 927-945.5 S-21R-22R HAS PREVIOUS REPAIR THAT ENDS ON A STRINGER.SDR DU4R0507130Skin · misrepairedFUSELAGE LT SIDE BS 927-945.5 S-19L- 20L HAS PREVIOUS REPAIR THAT ENDS ON A LAP SEAM.SDR DU4R0507128Skin · crackedDL/H UPPER FUSELAGE SKIN S-7L HAS 1 EA. CHERRY MAX RIVET FS 420. S/O NR 134005, OPS NR 20347.SDR DU4R0507003Skin · dentedDENT AND CREASE IN LOWER FUSELAGE SKIN AT BS 907 BETWEEN S-25R - S-26R.SDR DU4R0507126Stringer · crackedCABIN S-15L CRACKED, ALSO END FITTING.SDR 20050622ASkin · dentedDENT IN THE LT FUSELAGE SKIN IN AREA OF S20L AT BS 465.SDR 2004UALA00405Bear Strap · corrodedAFT CARGO DOOR CUT OUT AFT SIDE BEAR STRAP HAD CORROSION AND GOUGES. DOUBLER/TRIPLER INSTALLED.SDR 2004UALA00404Skin · dentedL/E HORIZ STAB LE IS DENTED AT LE STA 115. TRIMED OUT DAMAGE, INSTALLED INTERNAL DOUBLER AND FILLER.SDR 2004UALA00407Fitting · crackedTHE LT MLG BEAM O/B FITTING WAS FOUND CRACKED BEYOND LIMITS. FITTING WAS REPLACED.SDR 2004UALA00384Intercostal · crackedCABIN L1 DOOR SURROUND STRUCTURE INTERCOSTAL WEB CRACKED AT BS 294.5 STR 7L. MAJOR REPAIR ACCOMPLISHED. FABRICATED & INSTALLED NEW INTERCOSTAL.SDR 2004UALA00383Intercostal · crackedCABIN R1 DOOR SURROUND STRUCTURE INTERCOSTAL ANGLE HAS A CRACK AT BS 291 BETWEEN STR 9R AND 10R. MAJOR REPAIR ACCOMPLISHED. INSTALLED REPAIR ANGLE.SDR 2004UALA00382Intercostal · crackedCABIN R1 DOOR SURROUND STRUCTURE INTERCOSTAL ANGLE HAS A CRACK AT BS 291 BETWEEN STR 13R AND 14R. MAJOR REPAIR ACCOMPLISHED. INSTALLED REPAIR ANGLE.SDR 2004UALA00381Stringer Clip · crackedCABIN FUSELAGE FRAME CLIP CRACKED AT BS 400 STRINGER 4L. MAJOR REPAIR ACCOMPLISHED. FABRICATED & INSTALLED STRINGER CLIP.SDR 2004UALA00380Stringer Clip · crackedLT SIDE CABIN STRINGER TIE BRACKET CRACKED AT BS616 STR 4L. MAJOR REPAIR ACCOMPLISHED. FABRICATED & INSTALLED STRINGER CLIP.SDR 2004UALA00379Stringer Clip · crackedLT SIDE CABIN STRINGER TIE BRACKET CRACKED AT BS639 AND STRINGER 4L MAJOR REPAIR ACCOMPLISHED. FABRICATED NEW CLIP.SDR 2004UALA00347Frame · crackedFUSELAGE FRAME IS CRACKED AT STA 616 BELOW STR 17L. MAJOR REPAIR ACCOMPLISHED. INSTALLED ANGLE DOUBLER REPAIR.SDR 2004UALA00344Stringer · crackedSTR 15L IS CRACKED AT STA 380. MAJOR REPAIR ACCOMPLISHED. SPLICE REPAIR.SDR 2004UALA00316Pressure Panel · crackedWHEEL WELL PRESSURE DECK IS CRACKED AT STA 664 AND LBL 32. MAJOR REPAIR ACCOMPLISHED. INSTALLED REPAIR DOUBLER AND FILLER.SDR 2000UALA00355Indicator · failedFLAPS LOCKED UP AT POSITION ONE. *S/D* THE TRAILING EDGE FLAPS POSITION INDICATOR WAS REPLACED. THE AIRCRAFT HAS NOT HAD ANY FLAP PROBLEMS SINCE THE REPLACEMENT OF THE INDICATOR.SDR 2000UALA00737Bulkhead · crackedCRACK FOUND ON THE BODY STATION 178 BULKHEAD WEB. SUPPLEMENTAL DATA UPDATE CRACKS REPAIRED PER BOEING SRM 53-10-08.SDR 99UAL900475Structure · damagedTHE FUSELAGE SKIN AND TWO FRAMES WERE DAMAGED AFTER CONTACT WITH A SERVICE TRUCK. THE SKIN WAS DAMAGED FROM STATIONS 866 TO 904 BETWEEN STRINGERS 26 AND 27 LT AND FROM STATIONS 865 TO 867 BETWEEN STRINGERS 24 AND 25 RT WERE DAMAGED. *S/D* THE DAMAGED FRAME SDR 99UAL900202Coupler · failedUNEXPLAINED YAW FELT BY CREW ON FLIGHT DECK. YAW DAMPER COUPLER BITE TEST WAS PERFORMED BUT NO FAILURES WERE FOUND. REPLACED THE YAW DAMPER COUPLER PER MM 22-12-31 AS PRECAUTION. A BENCH TEST ON THE REPLACED COUPLER DETERMINED THAT THE TRANSISTOR (Q11) IN TSDR 97UAL900477Control Module · misriggedNO GREEN LIGHT ON LEFT MAIN LANDING GEAR WHEN GEAR HANDLE PUT IN DOWN POSITION. GEAR DID NOT EXTEND AND WAS EXTENDED MANUALLY.SDR 97UAL900472Tire · failedAMBER LIGHT DUE TO NR 2 MAIN TIRE TREAD SEPARATION AND THE LOSS OF THE 'A' HYDRAULIC SYSTEM. *S/D* FOUND LT LANDING GEAR TRANSFER CYLINDER HAS THREE DAMAGED HYDRAULIC LINES. REPLACED LINES IN ADDITION TO NUMBER 2 AND NUMBER 1 TIRES. NO PRELIMINARY FINDINGSSDR 97UAL900190Rate Gyro · out of adjustYAW DAMPER WILL NOT ENGAGE. THE YAW DAMPER COUPLER WAS REPLACED, AFTER WHICH, THE SYSTEM TESTED NORMAL. UPON BENCH TESTING, IT WAS DISCOVERED THAT THE RATE GYRO WAS OUT OF ADJUSTMENT.SDR 96UAL900991Light · inoperativeEMERGENCY LIGHT IS INOPERATIVE ABOVE ROW 9C.SDR 96UAL900241Fmc · malfunctionedFMC FAILS DURING TAKEOFF AT APPROXIMATELY 80 TO 100 KTS. FLAGS ARE DISPLAYED AND AUTO THROTTLES DISENGAGE. *S/D* NAVIGATION DATA BASE WAS RELOADED AND NO FURTHER PROBLEMS WERE FOUND.
Back to N387UA, cancelled Jul 28, 2005