N371UA, cancelled Sep 16, 2011
Service difficulty reports · 67
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 = 'N371UA' AND deregistration_id = 'N371UA-2011-09-16' 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 = 'N371UA' AND deregistration_id = 'N371UA-2011-09-16' 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 UALA2009011500166Warning System · inoperativeCREW REPORTS ON FIRE TEST GET NO FIRE BELL. HANDLE LIGHTS AND REMAINDER OF FIRE TEST NORMAL. REPLACED AURAL WARNING MODULE.SDR 2008UALA03732Girt Bar · out of positionDOOR 1L SLIDE PACK HAS FALLEN OUT. *S/D* SUSPECT IMPROPERLY INSTALLED. ADJUSTED GIRT BAR, OP CHECKED GOOD. AC OK FOR SERVICE.SDR 2008UALA01294Girt Bar · looseESCAPE SLIDE AT 1L HAS SLACK. REPACKED SLIDE.
SDR 2007UALA04327Slide · dislodgedDOOR 1L SLIDE FELL OUT OF CASING. SUSPECT SLIDE IMPROPERLY INSTALLED. REPLACED L1 DOOR SLIDE ASSEMBLY IAW MM-25-61-35. AC OK FOR SERVICE.SDR 2007UALA03700Door · damagedRIGHT NOSE LANDING GEAR DOOR DAMAGED LOWER EDGE FRONT 14 INCHES. REPLACED RIGHT NOSE LANDING GEAR DOOR.SDR 2007UALA03458Landing Gear · inoperativeONCE AIRBORNE LANDING GEAR WOULD NOT RETRACT. GEAR FINALLY RETRACTED AFTER RUNNING THRU CHECKLIST. 10-11-07 FOUND AIR SAFETY SENSOR S106 GAP TO BIG. REPLACED SENSOR.SDR 2007UALA03427Lamp · inoperativeRIGHT OFF WING (AFT OF TRAILING EDGE) EMERGENCY EXIT LIGHT INOP. FAILED LAMP. RELAMPED- OPS CHECK GOOD.SDR 2007UALA03383Skin · crackedEXTERNAL FUSELAGE SKIN HAS A CRACK JUST FORWARD OF POTABLE WATER SERVICE PANEL BS 942 STR 24L. MAJOR REPAIR ACCOMPLISHED: FABRICATED & INSTALLED EXTERNAL FUSELAGE DOUBLER & INTERNAL TEAR STRAP DOUBLER.SDR 2007UALA03382Skin · crackedFWD GALLEY DOOR LOWER HINGE CUTOUT FASTENER HOLE CRACKED. MAJOR REPAIR ACCOMPLISHED: FABRICATED EXTERNAL FUSELAGE DOUBLER REPAIR.SDR 2007UALA03381Intercostal · crackedCABIN BODY FRAME INTERCOSTAL OUTBOARD CHORD IS CRACKED BS 301.1 INCH ABOVE STR 10L. MAJOR REPAIR ACCOMPLISHED: FABRICATED & INSTALLED REPLACEMENT INTERCOSTAL & REPLACED PARTS PER AAR EA-I070596.SDR 2007UALA03380Intercostal · crackedCABIN BODY FRAME INTERCOSTAL OUTBOARD CHORD IS CRACKED BS 301 STR 13L. MAJOR REPAIR ACCOMPLISHED: FABRICATED & INSTALLED INTERCOSTAL & RELATED PARTS PER AAR EA-I070550 ON NR12432-2500-0014.SDR 2007UALA03379Skin · crackedFWD ENTRY DOOR UPPER HINGE CUTOUT ONE EACH FASTENER HOLE HAS CRACK INDICATION AT FWD END OF HINGE CUTOUT. MAJOR REPAIR ACCOMPLISHED: FABRICATED & INSTALLED REPAIR DOUBLER.SDR 2007UALA03378Bulkhead · crackedLEFT MLG WHEEL WELL HORIZONTAL BULKHEAD WEB IS CRACKED BS 672, LBL 42, WL 202; BS 665, LBL 39, WL 202 AND BS 665, LBL 32, WL 202. MAJOR REPAIR ACCOMPLISHED: FABRICATED & INSTALLED WEB REPLACEMENTS, DOUBLERS AND TRIPLER REPAIRS AT BOTH LBL 42 AND LBL 39.SDR 2007UALA03357Angle · corrodedAFT LAV AREA SMALL WALL ANGLE CORRODED AT BS 1013 TO BS 1016 BL 4L TO 6L AT WL 208. MAJOR REPAIR ACCOMPLISHED: FABRICATED & INSTALLED AFT LAV WALL ANGLE.SDR 2007UALA03356Crossbeam · corrodedAFT LAV AREA LEFT CROSSBEAM CORRODED AT BS 1006 TO BS 1016 AT BL 4L TO 10L WL 208. MAJOR REPAIR ACCOMPLISHED: REPLACED CROSSBEAM.SDR 2007UALA03355Attach Angle · crackedPASSENGER CABIN STA 294 STR 12L FRAME ATTACH ANGLE CRACKED ON LOWER SIDE. MAJOR REPAIR ACCOMPLISHED: REMOVED, FABRICATED & INSTALLED INTERCOSTAL WEB.SDR 2007UALA03354Fitting · crackedCABIN BODY FRAME INTERCOSTAL CLIP IS CRACKED BS 295 STR 11L. MAJOR REPAIR ACCOMPLISHED: FABRICATED & INSTALLED NEW ANGLE.SDR 2007UALA03353Skin · damagedAFT CARGO DOOR FWD LOWER CORNER IS DAMAGED. MAJOR REPAIR ACCOMPLISHED: INSTALLED NEW DOUBLER & FILLER AFTER SKIN REPLACEMENT.SDR 2007UALA03352Crossbeam · corrodedAFT LAV AREA RIGHT CROSSBEAM CORRODED AT BS 1006 TO BS 1016 BL 4R TO 10R WL 208. MAJOR REPAIR ACCOMPLISHED: REPLACED CROSSBEAM.SDR 2007UALA03351Door Frame · crackedFWD ENTRY DOOR AFT FRAME STOP SIXTH STOP FITTING CUTOUT HOLE FRAME CRACKED. MAJOR REPAIR ACCOMPLISHED: REMOVED CRACK. INSTALLED ANGLE REPAIR.SDR 2007UALA03350Angle · crackedPASSENGER CABIN STA 290 JUST ABOVE & BELOW STR 13R ANGLE CRACKED. MAJOR REPAIR ACCOMPLISHED: REMOVED ANGLE. DRILLED UP & INSTALLED NEW ANGLES. DINOLED AREA.SDR 2007UALA03250Shear Tie · damagedAFT PIT SHEAR TIE DAMAGED STA 727A STR 20L TO 21L. MAJOR REPAIR ACCOMPLISHED: REMOVED OLD SHEAR TIE MFG AND INSTALLED NEW SHEAR TIE.SDR 2007UALA03212Crease Beam · crackedFOUND CREASE BEAM WEB CRACKED AT BS 639L, LBL 62. MAJOR REPAIR ACCOMPLISHED: INSTALLED DOUBLER REPAIR ON CREASE BEAM WEB.SDR 2007UALA03211Skin · crackedEXTERNAL FUSELAGE SKIN HAS CRACK INDICATION AT STR 14L CHEM MILL STEP BTWN BS 814 AND BS 816. MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGE. INSTALLED EXTERNAL FUSELAGE DOUBLER REPAIR.SDR 2007UALA03210Torque Tube · faultyAFT ENTRY DOOR CUTOUT TORQUE TUBE HAS MOVEMENT BEYOND .003. REPLACED UPPER AND LOWER BEARING TORQUE TUBE.SDR 2007UALA03209Skin · damagedDORSAL FIN SKIN STA 860 PHENOLIC STRIP TORN AND POSSIBLE SKIN WEAR WHERE STRIP WAS TORN. REPAIRED AND INSTALLED DORSAL FIN.SDR 2007UALA03190Door Frame · crackedFWD CARGO DOOR LOWER AFT FRAME CRACKED IN RADIUS OF OUTER CHORD. MAJOR REPAIR ACP'D, REMOVED AND REPLACED FRAME SECTION.SDR 2007UALA03189Floorbeam · corrodedAFT LAV AREA FLOORBEAM CORRODED BS 1016 BL 4R-8R. MAJOR REPAIR: REMOVED DAMAGED SECTION OF STA 1016 FLOORBEAM CAP LBL 10 TO RBL 21 AND REPAIRED.SDR 2007UALA03129Door Frame · crackedFWD GALLEY DOOR LOWER FWD FRAME IS CRACKED AT 2 EA FASTENER HOLES. MAJOR REPAIR ACCOMPLISHED.SDR 2007UALA03128Skin · damagedAFT CARGO DOOR CUTOUT STA 847 STR 22, PREVIOUS REPAIR REMOVED FOR SKIN REPLACEMENT. MAJOR REPAIR ACCOMPLISHED.SDR 2007UALA03127Skin · crackedFWD ENTRY DOOR CRACK ON INNER SKIN AND FRAME AFT SIDE AT SEVENTH STOP FITTING FROM TOP. MAJOR REPAIR ACCOMPLISHED: FABRICATED & INSTALLED DOUBLER/ANGLE REPAIR.SDR 2007UALA03072Angle · crackedFOUND PASSENGER CABIN STA 290 JUST BELOW STR 11R ANGLE CRACKED. MAJOR REPAIR ACCOMPLISHED: REMOVED CRACKED ANGLE. REPLACED WITH NEW ANGLE (REF SRM 51-40-02 PGS 1-2-6)SDR 2007UALA03071Frame · crackedFOUND OVERWING FRAME INNER CHORD IS CRACKED AT BS 616L, JUST BELOW STR 17. MAJOR REPAIR ACCOMPLISHED: REPAIRED FRAME INNER CHORD AT STA 616L BELOW S17L WITH STIFFENER ANGLE AND FILLER.SDR 2007UALA03066Floorbeam · corrodedFLOORBEAM CORRODED: CABIN BS 294.5, LBL 6-7 WATERLINE 208, UPPER FLANGE CAP. REMOVED CORROSION. FABRICATED AND INSTALLED REPAIR ANGLE AND SHIM.SDR 2007UALA03008Attach Angle · crackedANGLE CRACKED, PASS CABIN FWD OF GALLEY DOOR STA 290 JUST ABOVE STR 10R, INTERCOSTAL WEB ATTACH ANGLE CRACKED. MAJOR REPAIR ACCOMPLISHED: REPLACED CRACKED ANGLE.SDR 2007UALA03006Angle · crackedPASSENGER CABIN STA 290 JUST ABOVE STR 11R ANGLE CRACKED. MAJOR REPAIR ACCOMPLISHED: REMOVED CRACKED ANGLE. REPLACED WITH NEW ANGLE.SDR 2007UALA01792Slide · unsecureDOOR 1R SLIDE PACK IS HANGING DOWN. [07-24-07] REPACKED SLIDE.SDR 2007UALA00110Slide · unsecureDOOR 1L SLIDE FELL OUT OF SLIDE CONTAINER. SECURED DOOR SLIDE.SDR 2006UALA02231Door Frame · crackedFWD PIT DOOR CUTOUT FWD FRAME CRACKED AT BS 440 NEAR STR S24R. MAJOR REPAIR: REMOVED CRACK AND ACCOMPLISHED NDT. FABRICATED AND INSTALLED TWO NESTED ANGLE EXTERNAL REPAIRS TO FRAME. REFERENCE AAR EA I060515 AND UA-EVA 60714.SDR 2006UALA02230Door Frame · crackedFWD CARGO DOOR CUTOUT FWD FRAME CRACKED AT BS 400 NEAR STRINGER S24R. MAJOR REPAIR: REMOVED DAMAGE. FABRICATED AND INSTALLED TWO NESTED ANGLE REPAIR DOUBLERS. REFERENCE AAR EA I060515 AND UA-EVA-60714.SDR 2006UALA02229Frame · crackedFWD CARGO PIT DOOR CUTOUT AFT FRAME CRACKED AT INBD RADIUS NEAR STRINGER S24R. MAJOR REPAIR: REMOVED AND REPLACED FORWARD CARGO PIT DOOR CUTOUT AFT FRAME. REFERENCE SRM 51-40-02 PG 1-30.SDR 2006UALA02228Skin · gougedEXTERNAL SKIN HAS BLENDED GOUGE AT BS 807 JUST BELOW STRINGER S-25R & ANOTHER AT BS 801 JUST ABOVE STR S-26R AT FWD LWR CORNER OF AFT PIT DOOR CUTOUT. MAJOR REPAIR: BLENDED GOUGES. FABRICATED AND INSTALLED EXTERNAL DOUBLER, TRIPLER AND STRUCTURAL FILLER REPASDR 2006UALA02221Wire Harness · burnedE&E COMP DRIP SHIELD MOISTURE BARRIER ABOVE E-3 SHELVES IS BURNED AND ABOVE NR 2 TR UNIT, WIRE BUNDLE ABOVE HAS SIGNS OF BURN, HEAT DAMAGE. FOUND NR 2 TRANSFORMER RECTIFIER UNIT FOUND OVERHEATED. REPLACED NR 2 TRU AND REINSTALLED A NEW DRIP SHIELD.
SDR 2006UALA02211Frame · crackedRH WHEEL WELL BS 695 FRAME INNER CHORD ANGLE CRACKED JUST ABOVE AND AFT OF MLG UPLOCK MECHANISM. MAJOR REPAIR: INSTALLED REPLACEMENT FRAME ANGLE. REFERENCE SRM 51-40-02 AND MM 53-10-98 PG 1-3.SDR 2006UALA02192Frame · crackedBS 695 FRAME CRACKED IN LOWER RADIUS ABOVE & AFT OF LT MLG UPLOCK MECHANISM IN LT MLG WW. MAJOR REPAIR: REMOVED AND REPLACED ANGLE. REFERENCE SRM 51-40-02 AND MM 53-10-98.SDR 2006UALA01109Warning System · activatedLANDED ORD UNDER AMBER ALERT DUE TO FLAP PROBLEM.SDR 2006UALA00756Power Supply · inoperativeDOOR 1L EMERGENCY EXIT LIGHT AND FIRST CLASS EEL FLOOR STRIP IS INOP.SDR 2005UALA01165Skin · crackedFUSELAGE HAS THREE INCH CRACK BEHIND LT WING EMERGENCY EXIT LIGHT AREA. ACCOMPLISHED CATEGORY B REPAIR REF. SRM 53-00-01. CRITICAL FASTNER ROW WILL NEED INSPECTION AT 60,000 CYCLES AFTERINSTALLATION OF REPAIR. ** MF5633 CREATED TO MONITOR **SDR 2005UALA00472Receptacle · failedAFT VACUUM CB OUT. FA REPORTED SPARKS IN GALLEY POPPED. FAILED RECEPTACLE NOT RECOVERED. AMT SAYS FOUND IT IN TWO PIECES. CAUSE OF FAILURE MAY BE DETERIORATION OVER TIME. INCONCLUSIVE WITHOUT FAILED PART.SDR 2004UALA01184Warning Light · activatedFLIGHT RETURNED TO DEN DUE TO B-SYSTEM HYDRAULIC PRESSURE LIGHT. PROBLEM COULD NOT BE REPEATED ON GROUND. OPS CHECKED OK. NO UNITS REPLACED.
Back to N371UA, cancelled Sep 16, 2011